From b3dc06734af35528496c192368586d5d8a61b42a Mon Sep 17 00:00:00 2001
From: futian.liu <liufutianyoo@163.com>
Date: 星期五, 01 十二月 2023 15:02:05 +0800
Subject: [PATCH] 部门分发新增

---
 consum-base/src/main/java/com/consum/base/pojo/request/UseInfo.java                       |   26 
 consum-base/src/main/java/com/consum/base/service/UsingFormBackGoodsService.java          |   13 
 consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackModelServiceImpl.java |   16 
 consum-base/src/main/java/com/consum/base/controller/UsingFormBackController.java         |   40 
 consum-base/src/main/java/com/consum/base/service/UsingFormBackService.java               |   16 
 consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackGoodsServiceImpl.java |   16 
 consum-base/src/main/java/com/consum/base/service/UsingFormBackModelService.java          |   13 
 consum-base/src/main/java/com/consum/base/pojo/request/baseGoodModel.java                 |   41 
 consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackGoods_mapper.java        |  340 +++++++
 consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackServiceImpl.java      |  106 ++
 consum-base/src/main/java/com/consum/base/pojo/request/UsingFormBackGoodsInfo.java        |   30 
 consum-base/src/main/java/com/consum/base/service/BaseCategoryService.java                |   30 
 consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBack.java                    |  416 +++++++++
 /dev/null                                                                                 |   42 
 consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackModel.java               |  394 ++++++++
 consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBack_mapper.java             |  424 +++++++++
 consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackGoods.java               |  284 ++++++
 consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackModel_mapper.java        |  412 ++++++++
 consum-base/src/main/java/com/consum/base/pojo/request/UsingFormBackParam.java            |   45 
 19 files changed, 2,662 insertions(+), 42 deletions(-)

diff --git a/consum-base/src/main/java/com/consum/base/controller/UsingFormBackController.java b/consum-base/src/main/java/com/consum/base/controller/UsingFormBackController.java
new file mode 100644
index 0000000..91699f6
--- /dev/null
+++ b/consum-base/src/main/java/com/consum/base/controller/UsingFormBackController.java
@@ -0,0 +1,40 @@
+package com.consum.base.controller;
+
+import com.consum.base.BaseController;
+import com.consum.base.pojo.request.UsingFormBackParam;
+import com.consum.base.service.UsingFormBackService;
+import com.consum.model.po.FinSysTenantUser;
+import com.walker.web.ResponseValue;
+import io.swagger.annotations.Api;
+import io.swagger.annotations.ApiOperation;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.web.bind.annotation.RequestBody;
+import org.springframework.web.bind.annotation.RequestMapping;
+import org.springframework.web.bind.annotation.RestController;
+
+/**
+ * @author asus
+ * @version 1.0
+ * @description: 閮ㄩ棬鐗╁搧閫�鍥炲崟
+ * @date 2023/12/1 11:36
+ */
+@Api(value = "閮ㄩ棬鐗╁搧閫�鍥�", tags = "閮ㄩ棬鐗╁搧閫�鍥�")
+@RestController
+@RequestMapping("/pc/l/wh/using/form/back")
+public class UsingFormBackController extends BaseController {
+
+    @Autowired
+    private UsingFormBackService usingFormBackService;
+
+
+    @ApiOperation(value = "閮ㄩ棬鐗╁搧閫�鍥炲崟鏂板鎺ュ彛", notes = "閮ㄩ棬鐗╁搧閫�鍥炲崟鏂板鎺ュ彛")
+    @RequestMapping("/add")
+    public ResponseValue add(@RequestBody UsingFormBackParam usingFormBackParam) {
+
+        FinSysTenantUser sysInfo = getSysInfo();
+        String tenantId = sysInfo.getTenantId();
+        String tenantName = sysInfo.getTenantName();
+        usingFormBackService.add(usingFormBackParam, sysInfo);
+        return null;
+    }
+}
diff --git a/consum-base/src/main/java/com/consum/base/pojo/request/UseInfo.java b/consum-base/src/main/java/com/consum/base/pojo/request/UseInfo.java
new file mode 100644
index 0000000..94f4058
--- /dev/null
+++ b/consum-base/src/main/java/com/consum/base/pojo/request/UseInfo.java
@@ -0,0 +1,26 @@
+package com.consum.base.pojo.request;
+
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import lombok.Data;
+
+/**
+ * @author asus
+ * @version 1.0
+ * @description: 浣跨敤浜轰俊鎭�
+ * @date 2023/12/1 13:27
+ */
+@Data
+@ApiModel
+public class UseInfo {
+
+    @ApiModelProperty(value = "浣跨敤浜哄鍚�")
+    private String useName;
+    @ApiModelProperty(value = "鍒嗗彂鏁伴噺")
+    private Integer num;
+    @ApiModelProperty(value = "鍙��鏁伴噺")
+    private Integer backNum;
+    @ApiModelProperty(value = "閫�鍥炴暟閲�")
+    private Integer returnNum;
+
+}
diff --git a/consum-base/src/main/java/com/consum/base/pojo/request/UsingFormBackGoodsInfo.java b/consum-base/src/main/java/com/consum/base/pojo/request/UsingFormBackGoodsInfo.java
new file mode 100644
index 0000000..aa864b1
--- /dev/null
+++ b/consum-base/src/main/java/com/consum/base/pojo/request/UsingFormBackGoodsInfo.java
@@ -0,0 +1,30 @@
+package com.consum.base.pojo.request;
+
+import io.swagger.annotations.ApiModel;
+import java.util.List;
+import lombok.Data;
+
+/**
+ * @author asus
+ * @version 1.0
+ * @description: TODO
+ * @date 2023/12/1 13:16
+ */
+@Data
+@ApiModel
+public class UsingFormBackGoodsInfo {
+
+    //鍒嗙被缂栧彿
+    private Long baseCategoryId;
+    //鐗╁搧妯$増缂栧彿
+    private Long baseGoodsTemplateId;
+    //鐗╁搧妯$増鍚嶅瓧
+    private String goodsTemplateName;
+    //鍒嗗彂鍗昳d
+    private Long transBusinessId;
+    //鍒嗗彂鍗曠紪鍙�
+    private String businessFormCode;
+
+    private List<baseGoodModel> models;
+
+}
diff --git a/consum-base/src/main/java/com/consum/base/pojo/request/UsingFormBackParam.java b/consum-base/src/main/java/com/consum/base/pojo/request/UsingFormBackParam.java
new file mode 100644
index 0000000..b794736
--- /dev/null
+++ b/consum-base/src/main/java/com/consum/base/pojo/request/UsingFormBackParam.java
@@ -0,0 +1,45 @@
+package com.consum.base.pojo.request;
+
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import java.util.List;
+import lombok.Data;
+import lombok.NoArgsConstructor;
+
+/**
+ * @author asus
+ * @version 1.0
+ * @description: 鐗╁搧閫�鍥�
+ * @date 2023/12/1 11:49
+ */
+@NoArgsConstructor
+@Data
+@ApiModel
+public class UsingFormBackParam {
+
+    @ApiModelProperty(value = "鐗╁搧閫�鍥為儴闂╥d")
+    private Long departmentId;
+
+    @ApiModelProperty(value = "鐗╁搧閫�鍥為儴闂ㄥ悕瀛�")
+    private String departmentName;
+
+    @ApiModelProperty(value = "閫�鍥炰汉id")
+    private Long operatorId;
+    @ApiModelProperty(value = "閫�鍥炰汉鍚嶅瓧")
+    private String operatorName;
+
+    @ApiModelProperty(value = "鐗╁搧閫�鍥炴椂闂�")
+    private Long dealTime;
+
+    @ApiModelProperty(value = "鎵嬬画")
+    private String procureDoc;
+
+    @ApiModelProperty(value = "鍒嗗彂鐗╁搧淇℃伅")
+    private List<UsingFormBackGoodsInfo> goods;
+
+
+
+
+
+
+}
diff --git a/consum-base/src/main/java/com/consum/base/pojo/request/baseGoodModel.java b/consum-base/src/main/java/com/consum/base/pojo/request/baseGoodModel.java
new file mode 100644
index 0000000..e568826
--- /dev/null
+++ b/consum-base/src/main/java/com/consum/base/pojo/request/baseGoodModel.java
@@ -0,0 +1,41 @@
+package com.consum.base.pojo.request;
+
+import io.swagger.annotations.ApiModel;
+import io.swagger.annotations.ApiModelProperty;
+import java.util.List;
+import lombok.Data;
+
+/**
+ * @author asus
+ * @version 1.0
+ * @description: TODO
+ * @date 2023/12/1 13:21
+ */
+@Data
+@ApiModel
+public class baseGoodModel {
+
+    @ApiModelProperty(value = "鍟嗗搧妯″瀷id")
+    private String baseGoodsModelsId;
+    @ApiModelProperty(value = "鍟嗗搧妯″瀷鍚嶇О")
+    private String baseGoodsModelsName;
+    @ApiModelProperty(value = "鍗曚綅")
+    private String unit;
+    @ApiModelProperty(value = "鐗╁搧绫诲瀷 A,B,C")
+    private String goodType;
+
+    private Long goodsTemplatesId;
+    private String modelName;
+
+    private Long modelUserId;
+    private Long nowUserPhone;
+    private String classification;
+
+    private String nowUserName;
+    private Integer userUseCount;
+    private Integer goodsNum;
+    private Integer counts;
+
+
+    private List<UseInfo> useInfo;
+}
diff --git a/consum-base/src/main/java/com/consum/base/service/BaseCategoryService.java b/consum-base/src/main/java/com/consum/base/service/BaseCategoryService.java
new file mode 100644
index 0000000..b0bc91a
--- /dev/null
+++ b/consum-base/src/main/java/com/consum/base/service/BaseCategoryService.java
@@ -0,0 +1,30 @@
+package com.consum.base.service;
+
+import com.consum.base.pojo.BaseCategoryParam;
+import com.consum.base.pojo.ProjectTreeResult;
+import com.consum.model.po.BaseCategory;
+import com.iplatform.model.po.S_user_core;
+import com.walker.db.page.GenericPager;
+import com.walker.jdbc.service.BaseService;
+import java.util.List;
+
+public interface BaseCategoryService extends BaseService {
+
+    int add(BaseCategoryParam param, S_user_core currentUser);
+
+    BaseCategory getByCategoryNameAndFatherCategoryId(String categoryName, Long fatherCategoryId);
+
+    GenericPager<BaseCategory> queryBaseCategoryList(BaseCategoryParam param);
+
+    int updateBaseCategory(BaseCategory baseCategory);
+
+    int updateStatus(BaseCategory baseCategory);
+
+    public int updateById(BaseCategory baseCategory, S_user_core currentUser);
+
+    public BaseCategory getById(Long id);
+
+    List<ProjectTreeResult> tree();
+
+    List<BaseCategory> queryForLv3Tree();
+}
diff --git a/consum-base/src/main/java/com/consum/base/service/UsingFormBackGoodsService.java b/consum-base/src/main/java/com/consum/base/service/UsingFormBackGoodsService.java
new file mode 100644
index 0000000..88a2e79
--- /dev/null
+++ b/consum-base/src/main/java/com/consum/base/service/UsingFormBackGoodsService.java
@@ -0,0 +1,13 @@
+package com.consum.base.service;
+
+import com.walker.jdbc.service.BaseService;
+
+/**
+ * @author asus
+ * @version 1.0
+ * @description: 鍥炴敹鍗曠墿鍝�
+ * @date 2023/12/1 11:26
+ */
+public interface UsingFormBackGoodsService extends BaseService {
+
+}
diff --git a/consum-base/src/main/java/com/consum/base/service/UsingFormBackModelService.java b/consum-base/src/main/java/com/consum/base/service/UsingFormBackModelService.java
new file mode 100644
index 0000000..2874e68
--- /dev/null
+++ b/consum-base/src/main/java/com/consum/base/service/UsingFormBackModelService.java
@@ -0,0 +1,13 @@
+package com.consum.base.service;
+
+import com.walker.jdbc.service.BaseService;
+
+/**
+ * @author asus
+ * @version 1.0
+ * @description: 鍥炴敹鍗曠墿鍝�
+ * @date 2023/12/1 11:26
+ */
+public interface UsingFormBackModelService extends BaseService {
+
+}
diff --git a/consum-base/src/main/java/com/consum/base/service/UsingFormBackService.java b/consum-base/src/main/java/com/consum/base/service/UsingFormBackService.java
new file mode 100644
index 0000000..9b56636
--- /dev/null
+++ b/consum-base/src/main/java/com/consum/base/service/UsingFormBackService.java
@@ -0,0 +1,16 @@
+package com.consum.base.service;
+
+import com.consum.base.pojo.request.UsingFormBackParam;
+import com.consum.model.po.FinSysTenantUser;
+import com.walker.jdbc.service.BaseService;
+
+/**
+ * @author asus
+ * @version 1.0
+ * @description: 鐗╁搧鍥炴敹鍗�
+ * @date 2023/12/1 11:26
+ */
+public interface UsingFormBackService extends BaseService {
+
+    void add(UsingFormBackParam usingFormBackParam, FinSysTenantUser sysInfo);
+}
diff --git a/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackGoodsServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackGoodsServiceImpl.java
new file mode 100644
index 0000000..4fdf718
--- /dev/null
+++ b/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackGoodsServiceImpl.java
@@ -0,0 +1,16 @@
+package com.consum.base.service.impl;
+
+import com.consum.base.service.UsingFormBackGoodsService;
+import com.walker.jdbc.service.BaseServiceImpl;
+import org.springframework.stereotype.Service;
+
+/**
+ * @author asus
+ * @version 1.0
+ * @description: 鐗╁搧鍥炴敹鍗�
+ * @date 2023/12/1 11:27
+ */
+@Service
+public class UsingFormBackGoodsServiceImpl extends BaseServiceImpl implements UsingFormBackGoodsService {
+
+}
diff --git a/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackModelServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackModelServiceImpl.java
new file mode 100644
index 0000000..49918fb
--- /dev/null
+++ b/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackModelServiceImpl.java
@@ -0,0 +1,16 @@
+package com.consum.base.service.impl;
+
+import com.consum.base.service.UsingFormBackModelService;
+import com.walker.jdbc.service.BaseServiceImpl;
+import org.springframework.stereotype.Service;
+
+/**
+ * @author asus
+ * @version 1.0
+ * @description: 鐗╁搧鍥炴敹鍗�
+ * @date 2023/12/1 11:27
+ */
+@Service
+public class UsingFormBackModelServiceImpl extends BaseServiceImpl implements UsingFormBackModelService {
+
+}
diff --git a/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackServiceImpl.java b/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackServiceImpl.java
new file mode 100644
index 0000000..db6a904
--- /dev/null
+++ b/consum-base/src/main/java/com/consum/base/service/impl/UsingFormBackServiceImpl.java
@@ -0,0 +1,106 @@
+package com.consum.base.service.impl;
+
+import com.consum.base.core.CodeGeneratorEnum;
+import com.consum.base.core.CodeGeneratorService;
+import com.consum.base.core.utils.IdUtil;
+import com.consum.base.pojo.request.UsingFormBackGoodsInfo;
+import com.consum.base.pojo.request.UsingFormBackParam;
+import com.consum.base.pojo.request.baseGoodModel;
+import com.consum.base.service.BaseCategoryServiceImpl;
+import com.consum.base.service.UsingFormBackService;
+import com.consum.model.po.BaseCategory;
+import com.consum.model.po.FinSysTenantUser;
+import com.consum.model.po.UsingFormBack;
+import com.consum.model.po.UsingFormBackGoods;
+import com.walker.infrastructure.utils.DateUtils;
+import com.walker.jdbc.service.BaseServiceImpl;
+import java.util.List;
+import java.util.Map;
+import java.util.stream.Collectors;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+/**
+ * @author asus
+ * @version 1.0
+ * @description: 鐗╁搧鍥炴敹鍗�
+ * @date 2023/12/1 11:27
+ */
+@Service
+public class UsingFormBackServiceImpl extends BaseServiceImpl implements UsingFormBackService {
+
+    @Autowired
+    private CodeGeneratorService codeGeneratorService;
+    @Autowired
+    private BaseCategoryServiceImpl baseCategoryService;
+
+    @Override
+    public void add(UsingFormBackParam usingFormBackParam, FinSysTenantUser sysInfo) {
+
+        Long departmentId = usingFormBackParam.getDepartmentId();
+        String departmentName = usingFormBackParam.getDepartmentName();
+        Long operatorId = usingFormBackParam.getOperatorId();
+        String operatorName = usingFormBackParam.getOperatorName();
+        Long backTime = usingFormBackParam.getDealTime();
+        String procureDoc = usingFormBackParam.getProcureDoc();
+        List<UsingFormBackGoodsInfo> usingFormBackGoodsInfo = usingFormBackParam.getGoods();
+
+        Long usingFormBackId = addUsingFormBack(sysInfo, departmentId, departmentName, operatorId, operatorName, backTime, procureDoc);
+        for (UsingFormBackGoodsInfo backingGoodsInfo : usingFormBackGoodsInfo) {
+            Long baseCategoryId = backingGoodsInfo.getBaseCategoryId();
+            Long baseGoodsTemplateId = backingGoodsInfo.getBaseGoodsTemplateId();
+            String goodsTemplateName = backingGoodsInfo.getGoodsTemplateName();
+            Long transBusinessId = backingGoodsInfo.getTransBusinessId();
+            String businessFormCode = backingGoodsInfo.getBusinessFormCode();
+
+            Map<String, List<baseGoodModel>> collect = backingGoodsInfo.getModels().stream()
+                .collect(Collectors.groupingBy(baseGoodModel::getBaseGoodsModelsId));
+
+            UsingFormBackGoods usingFormBackGoods = new UsingFormBackGoods();
+            usingFormBackGoods.setId(IdUtil.generateId());
+            usingFormBackGoods.setUsingFormBackId(usingFormBackId);
+            usingFormBackGoods.setBaseGoodsTemplateId(baseGoodsTemplateId);
+            usingFormBackGoods.setBaseGoodsTemplateName(goodsTemplateName);
+
+            BaseCategory baseCategory = baseCategoryService.getById(baseCategoryId);
+            String categoryName = baseCategory.getCategoryName();
+            String classification = baseCategory.getClassification();
+            usingFormBackGoods.setCategoryName(categoryName);
+            usingFormBackGoods.setClassification(classification);
+            usingFormBackGoods.setTransBusinessId(transBusinessId);
+            usingFormBackGoods.setBusinessFormCode(businessFormCode);
+
+//            usingFormBackGoods.setTransOutWarehouseType();
+//            usingFormBackGoods.setTransOutWarehouseId();
+
+        }
+    }
+
+    @Transactional
+    public Long addUsingFormBack(FinSysTenantUser sysInfo, Long departmentId, String departmentName, Long operatorId, String operatorName, Long backTime,
+        String procureDoc) {
+        UsingFormBack usingFormBack = new UsingFormBack();
+        usingFormBack.setId(IdUtil.generateId());
+        usingFormBack.setBusinessFormCode(codeGeneratorService.createBusinessFormCode(CodeGeneratorEnum.GOBACK));
+//        usingFormBack.setOutWarehouseType();
+//        usingFormBack.setOutWarehouseId();
+//        usingFormBack.setOutWarehouseName();
+
+        String tenantId = sysInfo.getTenantId();
+        String tenantName = sysInfo.getTenantName();
+        usingFormBack.setAgencyId(Long.valueOf(tenantId));
+        usingFormBack.setAgencyName(tenantName);
+        usingFormBack.setCreateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis()));
+        usingFormBack.setStates(1);
+
+        usingFormBack.setDepartmentId(departmentId);
+        usingFormBack.setDepartmentName(departmentName);
+        usingFormBack.setOperatorId(operatorId);
+        usingFormBack.setOperatorName(operatorName);
+        usingFormBack.setDealTime(backTime);
+        usingFormBack.setProcureDoc(procureDoc);
+        this.insert(usingFormBack);
+        return usingFormBack.getId();
+    }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBack.java b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBack.java
new file mode 100644
index 0000000..c899bec
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBack.java
@@ -0,0 +1,416 @@
+
+package com.consum.model.po;
+
+import com.fasterxml.jackson.annotation.JsonAutoDetect;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.walker.jdbc.BasePo;
+
+/**
+ * 琛ㄥ悕:USING_FORM_BACK
+ *
+ * @author genrator
+ */
+@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
+public class UsingFormBack extends BasePo<UsingFormBack> {
+
+    // 搴忓垪鍖栫増鏈彿
+    private static final long serialVersionUID = 1L;
+
+    // 涓婚敭
+    private Long id = null;
+    @JsonIgnore
+    protected boolean isset_id = false;
+
+    // 灞炴�у垪琛�
+    private String businessFormCode = null;
+    @JsonIgnore
+    protected boolean isset_businessFormCode = false;
+
+    private String procureDoc = null;
+    @JsonIgnore
+    protected boolean isset_procureDoc = false;
+
+    private Integer outWarehouseType = null;
+    @JsonIgnore
+    protected boolean isset_outWarehouseType = false;
+
+    private Long outWarehouseId = null;
+    @JsonIgnore
+    protected boolean isset_outWarehouseId = false;
+
+    private String outWarehouseName = null;
+    @JsonIgnore
+    protected boolean isset_outWarehouseName = false;
+
+    private Long operatorId = null;
+    @JsonIgnore
+    protected boolean isset_operatorId = false;
+
+    private String operatorName = null;
+    @JsonIgnore
+    protected boolean isset_operatorName = false;
+
+    private Long dealTime = null;
+    @JsonIgnore
+    protected boolean isset_dealTime = false;
+
+    private Long agencyId = null;
+    @JsonIgnore
+    protected boolean isset_agencyId = false;
+
+    private String agencyName = null;
+    @JsonIgnore
+    protected boolean isset_agencyName = false;
+
+    private Long departmentId = null;
+    @JsonIgnore
+    protected boolean isset_departmentId = false;
+
+    private String departmentName = null;
+    @JsonIgnore
+    protected boolean isset_departmentName = false;
+
+    private Long createTime = null;
+    @JsonIgnore
+    protected boolean isset_createTime = false;
+
+    private Integer states = null;
+    @JsonIgnore
+    protected boolean isset_states = false;
+
+    private String beiz = null;
+    @JsonIgnore
+    protected boolean isset_beiz = false;
+
+    /**
+     * 榛樿鏋勯�犲嚱鏁�
+     */
+    public UsingFormBack() {
+    }
+
+    /**
+     * 鏍规嵁涓婚敭鏋勯�犲璞�
+     */
+    public UsingFormBack(Long id) {
+        this.setId(id);
+    }
+
+    /**
+     * 璁剧疆涓婚敭鍊�
+     */
+    @Override
+    public void setPkValue(Object value) {
+        this.setId((Long) value);
+    }
+
+    public Long getId() {
+        return this.id;
+    }
+
+    public void setId(Long id) {
+        this.id = id;
+        this.isset_id = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyId() {
+        return this.id == null;
+    }
+
+    public String getBusinessFormCode() {
+        return this.businessFormCode;
+    }
+
+    public void setBusinessFormCode(String businessFormCode) {
+        this.businessFormCode = businessFormCode;
+        this.isset_businessFormCode = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyBusinessFormCode() {
+        return this.businessFormCode == null || this.businessFormCode.length() == 0;
+    }
+
+    public String getProcureDoc() {
+        return this.procureDoc;
+    }
+
+    public void setProcureDoc(String procureDoc) {
+        this.procureDoc = procureDoc;
+        this.isset_procureDoc = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyProcureDoc() {
+        return this.procureDoc == null || this.procureDoc.length() == 0;
+    }
+
+    public Integer getOutWarehouseType() {
+        return this.outWarehouseType;
+    }
+
+    public void setOutWarehouseType(Integer outWarehouseType) {
+        this.outWarehouseType = outWarehouseType;
+        this.isset_outWarehouseType = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyOutWarehouseType() {
+        return this.outWarehouseType == null;
+    }
+
+    public Long getOutWarehouseId() {
+        return this.outWarehouseId;
+    }
+
+    public void setOutWarehouseId(Long outWarehouseId) {
+        this.outWarehouseId = outWarehouseId;
+        this.isset_outWarehouseId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyOutWarehouseId() {
+        return this.outWarehouseId == null;
+    }
+
+    public String getOutWarehouseName() {
+        return this.outWarehouseName;
+    }
+
+    public void setOutWarehouseName(String outWarehouseName) {
+        this.outWarehouseName = outWarehouseName;
+        this.isset_outWarehouseName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyOutWarehouseName() {
+        return this.outWarehouseName == null || this.outWarehouseName.length() == 0;
+    }
+
+    public Long getOperatorId() {
+        return this.operatorId;
+    }
+
+    public void setOperatorId(Long operatorId) {
+        this.operatorId = operatorId;
+        this.isset_operatorId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyOperatorId() {
+        return this.operatorId == null;
+    }
+
+    public String getOperatorName() {
+        return this.operatorName;
+    }
+
+    public void setOperatorName(String operatorName) {
+        this.operatorName = operatorName;
+        this.isset_operatorName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyOperatorName() {
+        return this.operatorName == null || this.operatorName.length() == 0;
+    }
+
+    public Long getDealTime() {
+        return this.dealTime;
+    }
+
+    public void setDealTime(Long dealTime) {
+        this.dealTime = dealTime;
+        this.isset_dealTime = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyDealTime() {
+        return this.dealTime == null;
+    }
+
+    public Long getAgencyId() {
+        return this.agencyId;
+    }
+
+    public void setAgencyId(Long agencyId) {
+        this.agencyId = agencyId;
+        this.isset_agencyId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyAgencyId() {
+        return this.agencyId == null;
+    }
+
+    public String getAgencyName() {
+        return this.agencyName;
+    }
+
+    public void setAgencyName(String agencyName) {
+        this.agencyName = agencyName;
+        this.isset_agencyName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyAgencyName() {
+        return this.agencyName == null || this.agencyName.length() == 0;
+    }
+
+    public Long getDepartmentId() {
+        return this.departmentId;
+    }
+
+    public void setDepartmentId(Long departmentId) {
+        this.departmentId = departmentId;
+        this.isset_departmentId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyDepartmentId() {
+        return this.departmentId == null;
+    }
+
+    public String getDepartmentName() {
+        return this.departmentName;
+    }
+
+    public void setDepartmentName(String departmentName) {
+        this.departmentName = departmentName;
+        this.isset_departmentName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyDepartmentName() {
+        return this.departmentName == null || this.departmentName.length() == 0;
+    }
+
+    public Long getCreateTime() {
+        return this.createTime;
+    }
+
+    public void setCreateTime(Long createTime) {
+        this.createTime = createTime;
+        this.isset_createTime = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyCreateTime() {
+        return this.createTime == null;
+    }
+
+    public Integer getStates() {
+        return this.states;
+    }
+
+    public void setStates(Integer states) {
+        this.states = states;
+        this.isset_states = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyStates() {
+        return this.states == null;
+    }
+
+    public String getBeiz() {
+        return this.beiz;
+    }
+
+    public void setBeiz(String beiz) {
+        this.beiz = beiz;
+        this.isset_beiz = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyBeiz() {
+        return this.beiz == null || this.beiz.length() == 0;
+    }
+
+    /**
+     * 閲嶅啓 toString() 鏂规硶
+     */
+    @Override
+    public String toString() {
+        return new StringBuilder()
+            .append("id=").append(this.id)
+            .append("businessFormCode=").append(this.businessFormCode)
+            .append("procureDoc=").append(this.procureDoc)
+            .append("outWarehouseType=").append(this.outWarehouseType)
+            .append("outWarehouseId=").append(this.outWarehouseId)
+            .append("outWarehouseName=").append(this.outWarehouseName)
+            .append("operatorId=").append(this.operatorId)
+            .append("operatorName=").append(this.operatorName)
+            .append("dealTime=").append(this.dealTime)
+            .append("agencyId=").append(this.agencyId)
+            .append("agencyName=").append(this.agencyName)
+            .append("departmentId=").append(this.departmentId)
+            .append("departmentName=").append(this.departmentName)
+            .append("createTime=").append(this.createTime)
+            .append("states=").append(this.states)
+            .append("beiz=").append(this.beiz)
+            .toString();
+    }
+
+    /**
+     * 鍏嬮殕
+     */
+    public UsingFormBack $clone() {
+        UsingFormBack using_form_back = new UsingFormBack();
+
+        // 鏁版嵁搴撳悕绉�
+        //using_form_back.setDatabaseName_(this.getDatabaseName_());
+
+        // 涓婚敭
+        if (this.isset_id) {
+            using_form_back.setId(this.getId());
+        }
+        // 鏅�氬睘鎬�
+        if (this.isset_businessFormCode) {
+            using_form_back.setBusinessFormCode(this.getBusinessFormCode());
+        }
+        if (this.isset_procureDoc) {
+            using_form_back.setProcureDoc(this.getProcureDoc());
+        }
+        if (this.isset_outWarehouseType) {
+            using_form_back.setOutWarehouseType(this.getOutWarehouseType());
+        }
+        if (this.isset_outWarehouseId) {
+            using_form_back.setOutWarehouseId(this.getOutWarehouseId());
+        }
+        if (this.isset_outWarehouseName) {
+            using_form_back.setOutWarehouseName(this.getOutWarehouseName());
+        }
+        if (this.isset_operatorId) {
+            using_form_back.setOperatorId(this.getOperatorId());
+        }
+        if (this.isset_operatorName) {
+            using_form_back.setOperatorName(this.getOperatorName());
+        }
+        if (this.isset_dealTime) {
+            using_form_back.setDealTime(this.getDealTime());
+        }
+        if (this.isset_agencyId) {
+            using_form_back.setAgencyId(this.getAgencyId());
+        }
+        if (this.isset_agencyName) {
+            using_form_back.setAgencyName(this.getAgencyName());
+        }
+        if (this.isset_departmentId) {
+            using_form_back.setDepartmentId(this.getDepartmentId());
+        }
+        if (this.isset_departmentName) {
+            using_form_back.setDepartmentName(this.getDepartmentName());
+        }
+        if (this.isset_createTime) {
+            using_form_back.setCreateTime(this.getCreateTime());
+        }
+        if (this.isset_states) {
+            using_form_back.setStates(this.getStates());
+        }
+        if (this.isset_beiz) {
+            using_form_back.setBeiz(this.getBeiz());
+        }
+        return using_form_back;
+    }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackGoods.java b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackGoods.java
new file mode 100644
index 0000000..d39b8c4
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackGoods.java
@@ -0,0 +1,284 @@
+
+package com.consum.model.po;
+
+import com.fasterxml.jackson.annotation.JsonAutoDetect;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.walker.jdbc.BasePo;
+
+/**
+ * 琛ㄥ悕:USING_FORM_BACK_GOODS
+ *
+ * @author genrator
+ */
+@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
+public class UsingFormBackGoods extends BasePo<UsingFormBackGoods> {
+
+    // 搴忓垪鍖栫増鏈彿
+    private static final long serialVersionUID = 1L;
+
+    // 涓婚敭
+    private Long id = null;
+    @JsonIgnore
+    protected boolean isset_id = false;
+
+    // 灞炴�у垪琛�
+    private Long usingFormBackId = null;
+    @JsonIgnore
+    protected boolean isset_usingFormBackId = false;
+
+    private Long baseGoodsTemplateId = null;
+    @JsonIgnore
+    protected boolean isset_baseGoodsTemplateId = false;
+
+    private String baseGoodsTemplateName = null;
+    @JsonIgnore
+    protected boolean isset_baseGoodsTemplateName = false;
+
+    private String categoryName = null;
+    @JsonIgnore
+    protected boolean isset_categoryName = false;
+
+    private String classification = null;
+    @JsonIgnore
+    protected boolean isset_classification = false;
+
+    private Long transBusinessId = null;
+    @JsonIgnore
+    protected boolean isset_transBusinessId = false;
+
+    private String businessFormCode = null;
+    @JsonIgnore
+    protected boolean isset_businessFormCode = false;
+
+    private Integer transOutWarehouseType = null;
+    @JsonIgnore
+    protected boolean isset_transOutWarehouseType = false;
+
+    private Long transOutWarehouseId = null;
+    @JsonIgnore
+    protected boolean isset_transOutWarehouseId = false;
+
+    /**
+     * 榛樿鏋勯�犲嚱鏁�
+     */
+    public UsingFormBackGoods() {
+    }
+
+    /**
+     * 鏍规嵁涓婚敭鏋勯�犲璞�
+     */
+    public UsingFormBackGoods(Long id) {
+        this.setId(id);
+    }
+
+    /**
+     * 璁剧疆涓婚敭鍊�
+     */
+    @Override
+    public void setPkValue(Object value) {
+        this.setId((Long) value);
+    }
+
+    public Long getId() {
+        return this.id;
+    }
+
+    public void setId(Long id) {
+        this.id = id;
+        this.isset_id = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyId() {
+        return this.id == null;
+    }
+
+    public Long getUsingFormBackId() {
+        return this.usingFormBackId;
+    }
+
+    public void setUsingFormBackId(Long usingFormBackId) {
+        this.usingFormBackId = usingFormBackId;
+        this.isset_usingFormBackId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyUsingFormBackId() {
+        return this.usingFormBackId == null;
+    }
+
+    public Long getBaseGoodsTemplateId() {
+        return this.baseGoodsTemplateId;
+    }
+
+    public void setBaseGoodsTemplateId(Long baseGoodsTemplateId) {
+        this.baseGoodsTemplateId = baseGoodsTemplateId;
+        this.isset_baseGoodsTemplateId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyBaseGoodsTemplateId() {
+        return this.baseGoodsTemplateId == null;
+    }
+
+    public String getBaseGoodsTemplateName() {
+        return this.baseGoodsTemplateName;
+    }
+
+    public void setBaseGoodsTemplateName(String baseGoodsTemplateName) {
+        this.baseGoodsTemplateName = baseGoodsTemplateName;
+        this.isset_baseGoodsTemplateName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyBaseGoodsTemplateName() {
+        return this.baseGoodsTemplateName == null || this.baseGoodsTemplateName.length() == 0;
+    }
+
+    public String getCategoryName() {
+        return this.categoryName;
+    }
+
+    public void setCategoryName(String categoryName) {
+        this.categoryName = categoryName;
+        this.isset_categoryName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyCategoryName() {
+        return this.categoryName == null || this.categoryName.length() == 0;
+    }
+
+    public String getClassification() {
+        return this.classification;
+    }
+
+    public void setClassification(String classification) {
+        this.classification = classification;
+        this.isset_classification = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyClassification() {
+        return this.classification == null || this.classification.length() == 0;
+    }
+
+    public Long getTransBusinessId() {
+        return this.transBusinessId;
+    }
+
+    public void setTransBusinessId(Long transBusinessId) {
+        this.transBusinessId = transBusinessId;
+        this.isset_transBusinessId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyTransBusinessId() {
+        return this.transBusinessId == null;
+    }
+
+    public String getBusinessFormCode() {
+        return this.businessFormCode;
+    }
+
+    public void setBusinessFormCode(String businessFormCode) {
+        this.businessFormCode = businessFormCode;
+        this.isset_businessFormCode = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyBusinessFormCode() {
+        return this.businessFormCode == null || this.businessFormCode.length() == 0;
+    }
+
+    public Integer getTransOutWarehouseType() {
+        return this.transOutWarehouseType;
+    }
+
+    public void setTransOutWarehouseType(Integer transOutWarehouseType) {
+        this.transOutWarehouseType = transOutWarehouseType;
+        this.isset_transOutWarehouseType = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyTransOutWarehouseType() {
+        return this.transOutWarehouseType == null;
+    }
+
+    public Long getTransOutWarehouseId() {
+        return this.transOutWarehouseId;
+    }
+
+    public void setTransOutWarehouseId(Long transOutWarehouseId) {
+        this.transOutWarehouseId = transOutWarehouseId;
+        this.isset_transOutWarehouseId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyTransOutWarehouseId() {
+        return this.transOutWarehouseId == null;
+    }
+
+    /**
+     * 閲嶅啓 toString() 鏂规硶
+     */
+    @Override
+    public String toString() {
+        return new StringBuilder()
+            .append("id=").append(this.id)
+            .append("usingFormBackId=").append(this.usingFormBackId)
+            .append("baseGoodsTemplateId=").append(this.baseGoodsTemplateId)
+            .append("baseGoodsTemplateName=").append(this.baseGoodsTemplateName)
+            .append("categoryName=").append(this.categoryName)
+            .append("classification=").append(this.classification)
+            .append("transBusinessId=").append(this.transBusinessId)
+            .append("businessFormCode=").append(this.businessFormCode)
+            .append("transOutWarehouseType=").append(this.transOutWarehouseType)
+            .append("transOutWarehouseId=").append(this.transOutWarehouseId)
+            .toString();
+    }
+
+    /**
+     * 鍏嬮殕
+     */
+    public UsingFormBackGoods $clone() {
+        UsingFormBackGoods using_form_back_goods = new UsingFormBackGoods();
+
+        // 鏁版嵁搴撳悕绉�
+        //using_form_back_goods.setDatabaseName_(this.getDatabaseName_());
+
+        // 涓婚敭
+        if (this.isset_id) {
+            using_form_back_goods.setId(this.getId());
+        }
+        // 鏅�氬睘鎬�
+        if (this.isset_usingFormBackId) {
+            using_form_back_goods.setUsingFormBackId(this.getUsingFormBackId());
+        }
+        if (this.isset_baseGoodsTemplateId) {
+            using_form_back_goods.setBaseGoodsTemplateId(this.getBaseGoodsTemplateId());
+        }
+        if (this.isset_baseGoodsTemplateName) {
+            using_form_back_goods.setBaseGoodsTemplateName(this.getBaseGoodsTemplateName());
+        }
+        if (this.isset_categoryName) {
+            using_form_back_goods.setCategoryName(this.getCategoryName());
+        }
+        if (this.isset_classification) {
+            using_form_back_goods.setClassification(this.getClassification());
+        }
+        if (this.isset_transBusinessId) {
+            using_form_back_goods.setTransBusinessId(this.getTransBusinessId());
+        }
+        if (this.isset_businessFormCode) {
+            using_form_back_goods.setBusinessFormCode(this.getBusinessFormCode());
+        }
+        if (this.isset_transOutWarehouseType) {
+            using_form_back_goods.setTransOutWarehouseType(this.getTransOutWarehouseType());
+        }
+        if (this.isset_transOutWarehouseId) {
+            using_form_back_goods.setTransOutWarehouseId(this.getTransOutWarehouseId());
+        }
+        return using_form_back_goods;
+    }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackGoods_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackGoods_mapper.java
new file mode 100644
index 0000000..75842c7
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackGoods_mapper.java
@@ -0,0 +1,340 @@
+package com.consum.model.po;
+
+import com.walker.jdbc.BaseMapper;
+import com.walker.jdbc.ResultSetUtils;
+import com.walker.jdbc.SqlAndParameters;
+import com.walker.jdbc.sqlgen.DeleteBuilder;
+import com.walker.jdbc.sqlgen.InsertBuilder;
+import com.walker.jdbc.sqlgen.SelectBuilder;
+import com.walker.jdbc.sqlgen.UpdateBuilder;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.Map;
+import org.springframework.jdbc.core.RowMapper;
+
+/**
+ * 琛ㄥ悕:USING_FORM_BACK_GOODS
+ *
+ * @author genrator
+ */
+public class UsingFormBackGoods_mapper extends UsingFormBackGoods implements BaseMapper<UsingFormBackGoods> {
+
+    // 搴忓垪鍖栫増鏈彿
+    private static final long serialVersionUID = 1L;
+
+    public static final RowMapper<UsingFormBackGoods> ROW_MAPPER = new UsingFormBackGoodsRowMapper();
+
+    // 涓婚敭
+    public static final String Id = "id";
+    // 鏅�氬睘鎬�
+    public static final String UsingFormBackId = "using_form_back_id";
+    public static final String BaseGoodsTemplateId = "base_goods_template_id";
+    public static final String BaseGoodsTemplateName = "base_goods_template_name";
+    public static final String CategoryName = "category_name";
+    public static final String Classification = "classification";
+    public static final String TransBusinessId = "trans_business_id";
+    public static final String BusinessFormCode = "business_form_code";
+    public static final String TransOutWarehouseType = "trans_out_warehouse_type";
+    public static final String TransOutWarehouseId = "trans_out_warehouse_id";
+
+    /**
+     * 榛樿鏋勯�犲嚱鏁�
+     */
+    public UsingFormBackGoods_mapper(UsingFormBackGoods usingFormBackGoods) {
+        if (usingFormBackGoods == null) {
+            throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒");
+        }
+        //涓婚敭
+        if (usingFormBackGoods.isset_id) {
+            this.setId(usingFormBackGoods.getId());
+        }
+        //鏅�氬睘鎬�
+        if (usingFormBackGoods.isset_usingFormBackId) {
+            this.setUsingFormBackId(usingFormBackGoods.getUsingFormBackId());
+        }
+        if (usingFormBackGoods.isset_baseGoodsTemplateId) {
+            this.setBaseGoodsTemplateId(usingFormBackGoods.getBaseGoodsTemplateId());
+        }
+        if (usingFormBackGoods.isset_baseGoodsTemplateName) {
+            this.setBaseGoodsTemplateName(usingFormBackGoods.getBaseGoodsTemplateName());
+        }
+        if (usingFormBackGoods.isset_categoryName) {
+            this.setCategoryName(usingFormBackGoods.getCategoryName());
+        }
+        if (usingFormBackGoods.isset_classification) {
+            this.setClassification(usingFormBackGoods.getClassification());
+        }
+        if (usingFormBackGoods.isset_transBusinessId) {
+            this.setTransBusinessId(usingFormBackGoods.getTransBusinessId());
+        }
+        if (usingFormBackGoods.isset_businessFormCode) {
+            this.setBusinessFormCode(usingFormBackGoods.getBusinessFormCode());
+        }
+        if (usingFormBackGoods.isset_transOutWarehouseType) {
+            this.setTransOutWarehouseType(usingFormBackGoods.getTransOutWarehouseType());
+        }
+        if (usingFormBackGoods.isset_transOutWarehouseId) {
+            this.setTransOutWarehouseId(usingFormBackGoods.getTransOutWarehouseId());
+        }
+        // 鍘绘帀锛�2022-09-07
+        // this.setDatabaseName_(using_form_back_goods.getDatabaseName_());
+    }
+
+    /**
+     * 鑾峰彇琛ㄥ悕
+     */
+    @Override
+    public String getTableName_() {
+        String tableName = "using_form_back_goods";
+        /**
+         if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
+         return this.getDatabaseName_() + "." + tableName;
+         } else {
+         return tableName;
+         }
+         */
+        return tableName;
+    }
+
+    /**
+     * 鑾峰彇涓婚敭鍚嶇О
+     */
+    @Override
+    public String getPkName_() {
+        return Id;
+    }
+
+    /**
+     * 鑾峰彇涓婚敭鍊�
+     */
+    @Override
+    public Object getPkValue_() {
+        return this.getId();
+    }
+
+    /**
+     * 鑾峰彇鎻掑叆璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getInsertSql_() {
+        InsertBuilder ib = new InsertBuilder(this.getTableName_());
+        ib.set(Id, this.getId());
+        ib.set(UsingFormBackId, this.getUsingFormBackId(), this.isset_usingFormBackId);
+        ib.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
+        ib.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName);
+        ib.set(CategoryName, this.getCategoryName(), this.isset_categoryName);
+        ib.set(Classification, this.getClassification(), this.isset_classification);
+        ib.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+        ib.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+        ib.set(TransOutWarehouseType, this.getTransOutWarehouseType(), this.isset_transOutWarehouseType);
+        ib.set(TransOutWarehouseId, this.getTransOutWarehouseId(), this.isset_transOutWarehouseId);
+        return ib.genMapSql();
+    }
+
+    /**
+     * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
+        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(UsingFormBackId, this.getUsingFormBackId(), this.isset_usingFormBackId);
+        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
+        ub.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName);
+        ub.set(CategoryName, this.getCategoryName(), this.isset_categoryName);
+        ub.set(Classification, this.getClassification(), this.isset_classification);
+        ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+        ub.set(TransOutWarehouseType, this.getTransOutWarehouseType(), this.isset_transOutWarehouseType);
+        ub.set(TransOutWarehouseId, this.getTransOutWarehouseId(), this.isset_transOutWarehouseId);
+        ub.where(this.getPkName_(), this.getPkValue_());
+        return ub.genMapSql();
+    }
+
+    /**
+     * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
+        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(UsingFormBackId, this.getUsingFormBackId(), this.isset_usingFormBackId);
+        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
+        ub.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName);
+        ub.set(CategoryName, this.getCategoryName(), this.isset_categoryName);
+        ub.set(Classification, this.getClassification(), this.isset_classification);
+        ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+        ub.set(TransOutWarehouseType, this.getTransOutWarehouseType(), this.isset_transOutWarehouseType);
+        ub.set(TransOutWarehouseId, this.getTransOutWarehouseId(), this.isset_transOutWarehouseId);
+        return ub.genMapSql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
+        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(UsingFormBackId, this.getUsingFormBackId(), this.isset_usingFormBackId);
+        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
+        ub.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName);
+        ub.set(CategoryName, this.getCategoryName(), this.isset_categoryName);
+        ub.set(Classification, this.getClassification(), this.isset_classification);
+        ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+        ub.set(TransOutWarehouseType, this.getTransOutWarehouseType(), this.isset_transOutWarehouseType);
+        ub.set(TransOutWarehouseId, this.getTransOutWarehouseId(), this.isset_transOutWarehouseId);
+        return ub.genArraySql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
+        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+        db.where(this.getPkName_(), this.getPkValue_());
+        return db.genMapSql();
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
+        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+        return db.genMapSql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
+        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+        return db.genArraySql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鍗曡鏌ヨ璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getSingleSql_() {
+        SelectBuilder sb = new SelectBuilder(this.getTableName_());
+        sb.where(this.getPkName_(), this.getPkValue_());
+        return sb.genMapSql();
+    }
+
+
+    /**
+     * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
+        return new SqlAndParameters<>(
+            "select id, using_form_back_id, base_goods_template_id, base_goods_template_name, category_name, classification, trans_business_id, business_form_code, trans_out_warehouse_type, trans_out_warehouse_id from "
+                + this.getTableName_() + " " + where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
+        return new SqlAndParameters<>(
+            "select id, using_form_back_id, base_goods_template_id, base_goods_template_name, category_name, classification, trans_business_id, business_form_code, trans_out_warehouse_type, trans_out_warehouse_id from "
+                + this.getTableName_() + " " + where, parameters);
+    }
+
+    /**
+     * 灏唕esultset鐨勪竴琛岃浆鍖栦负po
+     */
+    @Override
+    public UsingFormBackGoods mapRow(ResultSet rs, int i) throws SQLException {
+        return ROW_MAPPER.mapRow(rs, i);
+    }
+
+    /**
+     * 鍏嬮殕
+     */
+    public UsingFormBackGoods toUsingFormBackGoods() {
+        return super.$clone();
+    }
+}
+
+/**
+ * using_form_back_goods RowMapper
+ *
+ * @author genrator
+ */
+class UsingFormBackGoodsRowMapper implements RowMapper<UsingFormBackGoods> {
+
+    @Override
+    public UsingFormBackGoods mapRow(ResultSet rs, int i) throws SQLException {
+        ResultSetUtils resultSetUtils = new ResultSetUtils();
+        UsingFormBackGoods using_form_back_goods = new UsingFormBackGoods();
+        Integer columnIndex;
+        //涓婚敭
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.Id);
+        if (columnIndex > 0) {
+            using_form_back_goods.setId(rs.getLong(columnIndex));
+        }
+        //鏅�氬睘鎬�
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.UsingFormBackId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back_goods.setUsingFormBackId(null);
+            } else {
+                using_form_back_goods.setUsingFormBackId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.BaseGoodsTemplateId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back_goods.setBaseGoodsTemplateId(null);
+            } else {
+                using_form_back_goods.setBaseGoodsTemplateId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.BaseGoodsTemplateName);
+        if (columnIndex > 0) {
+            using_form_back_goods.setBaseGoodsTemplateName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.CategoryName);
+        if (columnIndex > 0) {
+            using_form_back_goods.setCategoryName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.Classification);
+        if (columnIndex > 0) {
+            using_form_back_goods.setClassification(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.TransBusinessId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back_goods.setTransBusinessId(null);
+            } else {
+                using_form_back_goods.setTransBusinessId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.BusinessFormCode);
+        if (columnIndex > 0) {
+            using_form_back_goods.setBusinessFormCode(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.TransOutWarehouseType);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back_goods.setTransOutWarehouseType(null);
+            } else {
+                using_form_back_goods.setTransOutWarehouseType(rs.getInt(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackGoods_mapper.TransOutWarehouseId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back_goods.setTransOutWarehouseId(null);
+            } else {
+                using_form_back_goods.setTransOutWarehouseId(rs.getLong(columnIndex));
+            }
+        }
+        return using_form_back_goods;
+    }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackModel.java b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackModel.java
new file mode 100644
index 0000000..3a4c741
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackModel.java
@@ -0,0 +1,394 @@
+
+package com.consum.model.po;
+
+import com.fasterxml.jackson.annotation.JsonAutoDetect;
+import com.fasterxml.jackson.annotation.JsonIgnore;
+import com.walker.jdbc.BasePo;
+
+/**
+ * 琛ㄥ悕:USING_FORM_BACK_MODEL
+ *
+ * @author genrator
+ */
+@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
+public class UsingFormBackModel extends BasePo<UsingFormBackModel> {
+
+    // 搴忓垪鍖栫増鏈彿
+    private static final long serialVersionUID = 1L;
+
+    // 涓婚敭
+    private Long id = null;
+    @JsonIgnore
+    protected boolean isset_id = false;
+
+    // 灞炴�у垪琛�
+    private Long usingFormBackId = null;
+    @JsonIgnore
+    protected boolean isset_usingFormBackId = false;
+
+    private Long usingFormBackGoodsId = null;
+    @JsonIgnore
+    protected boolean isset_usingFormBackGoodsId = false;
+
+    private Long baseGoodsTemplateId = null;
+    @JsonIgnore
+    protected boolean isset_baseGoodsTemplateId = false;
+
+    private String baseGoodsTemplateName = null;
+    @JsonIgnore
+    protected boolean isset_baseGoodsTemplateName = false;
+
+    private String classification = null;
+    @JsonIgnore
+    protected boolean isset_classification = false;
+
+    private String unit = null;
+    @JsonIgnore
+    protected boolean isset_unit = false;
+
+    private Long baseGoodsModelsId = null;
+    @JsonIgnore
+    protected boolean isset_baseGoodsModelsId = false;
+
+    private String baseGoodsModelsName = null;
+    @JsonIgnore
+    protected boolean isset_baseGoodsModelsName = false;
+
+    private Long procureModelUserId = null;
+    @JsonIgnore
+    protected boolean isset_procureModelUserId = false;
+
+    private Integer initialCount = null;
+    @JsonIgnore
+    protected boolean isset_initialCount = false;
+
+    private Integer useCount = null;
+    @JsonIgnore
+    protected boolean isset_useCount = false;
+
+    private Integer counts = null;
+    @JsonIgnore
+    protected boolean isset_counts = false;
+
+    private String goodsUserName = null;
+    @JsonIgnore
+    protected boolean isset_goodsUserName = false;
+
+    private String beiz = null;
+    @JsonIgnore
+    protected boolean isset_beiz = false;
+
+    /**
+     * 榛樿鏋勯�犲嚱鏁�
+     */
+    public UsingFormBackModel() {
+    }
+
+    /**
+     * 鏍规嵁涓婚敭鏋勯�犲璞�
+     */
+    public UsingFormBackModel(Long id) {
+        this.setId(id);
+    }
+
+    /**
+     * 璁剧疆涓婚敭鍊�
+     */
+    @Override
+    public void setPkValue(Object value) {
+        this.setId((Long) value);
+    }
+
+    public Long getId() {
+        return this.id;
+    }
+
+    public void setId(Long id) {
+        this.id = id;
+        this.isset_id = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyId() {
+        return this.id == null;
+    }
+
+    public Long getUsingFormBackId() {
+        return this.usingFormBackId;
+    }
+
+    public void setUsingFormBackId(Long usingFormBackId) {
+        this.usingFormBackId = usingFormBackId;
+        this.isset_usingFormBackId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyUsingFormBackId() {
+        return this.usingFormBackId == null;
+    }
+
+    public Long getUsingFormBackGoodsId() {
+        return this.usingFormBackGoodsId;
+    }
+
+    public void setUsingFormBackGoodsId(Long usingFormBackGoodsId) {
+        this.usingFormBackGoodsId = usingFormBackGoodsId;
+        this.isset_usingFormBackGoodsId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyUsingFormBackGoodsId() {
+        return this.usingFormBackGoodsId == null;
+    }
+
+    public Long getBaseGoodsTemplateId() {
+        return this.baseGoodsTemplateId;
+    }
+
+    public void setBaseGoodsTemplateId(Long baseGoodsTemplateId) {
+        this.baseGoodsTemplateId = baseGoodsTemplateId;
+        this.isset_baseGoodsTemplateId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyBaseGoodsTemplateId() {
+        return this.baseGoodsTemplateId == null;
+    }
+
+    public String getBaseGoodsTemplateName() {
+        return this.baseGoodsTemplateName;
+    }
+
+    public void setBaseGoodsTemplateName(String baseGoodsTemplateName) {
+        this.baseGoodsTemplateName = baseGoodsTemplateName;
+        this.isset_baseGoodsTemplateName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyBaseGoodsTemplateName() {
+        return this.baseGoodsTemplateName == null || this.baseGoodsTemplateName.length() == 0;
+    }
+
+    public String getClassification() {
+        return this.classification;
+    }
+
+    public void setClassification(String classification) {
+        this.classification = classification;
+        this.isset_classification = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyClassification() {
+        return this.classification == null || this.classification.length() == 0;
+    }
+
+    public String getUnit() {
+        return this.unit;
+    }
+
+    public void setUnit(String unit) {
+        this.unit = unit;
+        this.isset_unit = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyUnit() {
+        return this.unit == null || this.unit.length() == 0;
+    }
+
+    public Long getBaseGoodsModelsId() {
+        return this.baseGoodsModelsId;
+    }
+
+    public void setBaseGoodsModelsId(Long baseGoodsModelsId) {
+        this.baseGoodsModelsId = baseGoodsModelsId;
+        this.isset_baseGoodsModelsId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyBaseGoodsModelsId() {
+        return this.baseGoodsModelsId == null;
+    }
+
+    public String getBaseGoodsModelsName() {
+        return this.baseGoodsModelsName;
+    }
+
+    public void setBaseGoodsModelsName(String baseGoodsModelsName) {
+        this.baseGoodsModelsName = baseGoodsModelsName;
+        this.isset_baseGoodsModelsName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyBaseGoodsModelsName() {
+        return this.baseGoodsModelsName == null || this.baseGoodsModelsName.length() == 0;
+    }
+
+    public Long getProcureModelUserId() {
+        return this.procureModelUserId;
+    }
+
+    public void setProcureModelUserId(Long procureModelUserId) {
+        this.procureModelUserId = procureModelUserId;
+        this.isset_procureModelUserId = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyProcureModelUserId() {
+        return this.procureModelUserId == null;
+    }
+
+    public Integer getInitialCount() {
+        return this.initialCount;
+    }
+
+    public void setInitialCount(Integer initialCount) {
+        this.initialCount = initialCount;
+        this.isset_initialCount = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyInitialCount() {
+        return this.initialCount == null;
+    }
+
+    public Integer getUseCount() {
+        return this.useCount;
+    }
+
+    public void setUseCount(Integer useCount) {
+        this.useCount = useCount;
+        this.isset_useCount = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyUseCount() {
+        return this.useCount == null;
+    }
+
+    public Integer getCounts() {
+        return this.counts;
+    }
+
+    public void setCounts(Integer counts) {
+        this.counts = counts;
+        this.isset_counts = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyCounts() {
+        return this.counts == null;
+    }
+
+    public String getGoodsUserName() {
+        return this.goodsUserName;
+    }
+
+    public void setGoodsUserName(String goodsUserName) {
+        this.goodsUserName = goodsUserName;
+        this.isset_goodsUserName = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyGoodsUserName() {
+        return this.goodsUserName == null || this.goodsUserName.length() == 0;
+    }
+
+    public String getBeiz() {
+        return this.beiz;
+    }
+
+    public void setBeiz(String beiz) {
+        this.beiz = beiz;
+        this.isset_beiz = true;
+    }
+
+    @JsonIgnore
+    public boolean isEmptyBeiz() {
+        return this.beiz == null || this.beiz.length() == 0;
+    }
+
+    /**
+     * 閲嶅啓 toString() 鏂规硶
+     */
+    @Override
+    public String toString() {
+        return new StringBuilder()
+            .append("id=").append(this.id)
+            .append("usingFormBackId=").append(this.usingFormBackId)
+            .append("usingFormBackGoodsId=").append(this.usingFormBackGoodsId)
+            .append("baseGoodsTemplateId=").append(this.baseGoodsTemplateId)
+            .append("baseGoodsTemplateName=").append(this.baseGoodsTemplateName)
+            .append("classification=").append(this.classification)
+            .append("unit=").append(this.unit)
+            .append("baseGoodsModelsId=").append(this.baseGoodsModelsId)
+            .append("baseGoodsModelsName=").append(this.baseGoodsModelsName)
+            .append("procureModelUserId=").append(this.procureModelUserId)
+            .append("initialCount=").append(this.initialCount)
+            .append("useCount=").append(this.useCount)
+            .append("counts=").append(this.counts)
+            .append("goodsUserName=").append(this.goodsUserName)
+            .append("beiz=").append(this.beiz)
+            .toString();
+    }
+
+    /**
+     * 鍏嬮殕
+     */
+    public UsingFormBackModel $clone() {
+        UsingFormBackModel using_form_back_model = new UsingFormBackModel();
+
+        // 鏁版嵁搴撳悕绉�
+        //using_form_back_model.setDatabaseName_(this.getDatabaseName_());
+
+        // 涓婚敭
+        if (this.isset_id) {
+            using_form_back_model.setId(this.getId());
+        }
+        // 鏅�氬睘鎬�
+        if (this.isset_usingFormBackId) {
+            using_form_back_model.setUsingFormBackId(this.getUsingFormBackId());
+        }
+        if (this.isset_usingFormBackGoodsId) {
+            using_form_back_model.setUsingFormBackGoodsId(this.getUsingFormBackGoodsId());
+        }
+        if (this.isset_baseGoodsTemplateId) {
+            using_form_back_model.setBaseGoodsTemplateId(this.getBaseGoodsTemplateId());
+        }
+        if (this.isset_baseGoodsTemplateName) {
+            using_form_back_model.setBaseGoodsTemplateName(this.getBaseGoodsTemplateName());
+        }
+        if (this.isset_classification) {
+            using_form_back_model.setClassification(this.getClassification());
+        }
+        if (this.isset_unit) {
+            using_form_back_model.setUnit(this.getUnit());
+        }
+        if (this.isset_baseGoodsModelsId) {
+            using_form_back_model.setBaseGoodsModelsId(this.getBaseGoodsModelsId());
+        }
+        if (this.isset_baseGoodsModelsName) {
+            using_form_back_model.setBaseGoodsModelsName(this.getBaseGoodsModelsName());
+        }
+        if (this.isset_procureModelUserId) {
+            using_form_back_model.setProcureModelUserId(this.getProcureModelUserId());
+        }
+        if (this.isset_initialCount) {
+            using_form_back_model.setInitialCount(this.getInitialCount());
+        }
+        if (this.isset_useCount) {
+            using_form_back_model.setUseCount(this.getUseCount());
+        }
+        if (this.isset_counts) {
+            using_form_back_model.setCounts(this.getCounts());
+        }
+        if (this.isset_goodsUserName) {
+            using_form_back_model.setGoodsUserName(this.getGoodsUserName());
+        }
+        if (this.isset_beiz) {
+            using_form_back_model.setBeiz(this.getBeiz());
+        }
+        return using_form_back_model;
+    }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackModel_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackModel_mapper.java
new file mode 100644
index 0000000..2002027
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBackModel_mapper.java
@@ -0,0 +1,412 @@
+package com.consum.model.po;
+
+import com.walker.jdbc.BaseMapper;
+import com.walker.jdbc.ResultSetUtils;
+import com.walker.jdbc.SqlAndParameters;
+import com.walker.jdbc.sqlgen.DeleteBuilder;
+import com.walker.jdbc.sqlgen.InsertBuilder;
+import com.walker.jdbc.sqlgen.SelectBuilder;
+import com.walker.jdbc.sqlgen.UpdateBuilder;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.Map;
+import org.springframework.jdbc.core.RowMapper;
+
+/**
+ * 琛ㄥ悕:USING_FORM_BACK_MODEL
+ *
+ * @author genrator
+ */
+public class UsingFormBackModel_mapper extends UsingFormBackModel implements BaseMapper<UsingFormBackModel> {
+
+    // 搴忓垪鍖栫増鏈彿
+    private static final long serialVersionUID = 1L;
+
+    public static final RowMapper<UsingFormBackModel> ROW_MAPPER = new UsingFormBackModelRowMapper();
+
+    // 涓婚敭
+    public static final String Id = "id";
+    // 鏅�氬睘鎬�
+    public static final String UsingFormBackId = "using_form_back_id";
+    public static final String UsingFormBackGoodsId = "using_form_back_goods_id";
+    public static final String BaseGoodsTemplateId = "base_goods_template_id";
+    public static final String BaseGoodsTemplateName = "base_goods_template_name";
+    public static final String Classification = "classification";
+    public static final String Unit = "unit";
+    public static final String BaseGoodsModelsId = "base_goods_models_id";
+    public static final String BaseGoodsModelsName = "base_goods_models_name";
+    public static final String ProcureModelUserId = "procure_model_user_id";
+    public static final String InitialCount = "initial_count";
+    public static final String UseCount = "use_count";
+    public static final String Counts = "counts";
+    public static final String GoodsUserName = "goods_user_name";
+    public static final String Beiz = "beiz";
+
+    /**
+     * 榛樿鏋勯�犲嚱鏁�
+     */
+    public UsingFormBackModel_mapper(UsingFormBackModel usingFormBackModel) {
+        if (usingFormBackModel == null) {
+            throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒");
+        }
+        //涓婚敭
+        if (usingFormBackModel.isset_id) {
+            this.setId(usingFormBackModel.getId());
+        }
+        //鏅�氬睘鎬�
+        if (usingFormBackModel.isset_usingFormBackId) {
+            this.setUsingFormBackId(usingFormBackModel.getUsingFormBackId());
+        }
+        if (usingFormBackModel.isset_usingFormBackGoodsId) {
+            this.setUsingFormBackGoodsId(usingFormBackModel.getUsingFormBackGoodsId());
+        }
+        if (usingFormBackModel.isset_baseGoodsTemplateId) {
+            this.setBaseGoodsTemplateId(usingFormBackModel.getBaseGoodsTemplateId());
+        }
+        if (usingFormBackModel.isset_baseGoodsTemplateName) {
+            this.setBaseGoodsTemplateName(usingFormBackModel.getBaseGoodsTemplateName());
+        }
+        if (usingFormBackModel.isset_classification) {
+            this.setClassification(usingFormBackModel.getClassification());
+        }
+        if (usingFormBackModel.isset_unit) {
+            this.setUnit(usingFormBackModel.getUnit());
+        }
+        if (usingFormBackModel.isset_baseGoodsModelsId) {
+            this.setBaseGoodsModelsId(usingFormBackModel.getBaseGoodsModelsId());
+        }
+        if (usingFormBackModel.isset_baseGoodsModelsName) {
+            this.setBaseGoodsModelsName(usingFormBackModel.getBaseGoodsModelsName());
+        }
+        if (usingFormBackModel.isset_procureModelUserId) {
+            this.setProcureModelUserId(usingFormBackModel.getProcureModelUserId());
+        }
+        if (usingFormBackModel.isset_initialCount) {
+            this.setInitialCount(usingFormBackModel.getInitialCount());
+        }
+        if (usingFormBackModel.isset_useCount) {
+            this.setUseCount(usingFormBackModel.getUseCount());
+        }
+        if (usingFormBackModel.isset_counts) {
+            this.setCounts(usingFormBackModel.getCounts());
+        }
+        if (usingFormBackModel.isset_goodsUserName) {
+            this.setGoodsUserName(usingFormBackModel.getGoodsUserName());
+        }
+        if (usingFormBackModel.isset_beiz) {
+            this.setBeiz(usingFormBackModel.getBeiz());
+        }
+        // 鍘绘帀锛�2022-09-07
+        // this.setDatabaseName_(using_form_back_model.getDatabaseName_());
+    }
+
+    /**
+     * 鑾峰彇琛ㄥ悕
+     */
+    @Override
+    public String getTableName_() {
+        String tableName = "using_form_back_model";
+        /**
+         if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
+         return this.getDatabaseName_() + "." + tableName;
+         } else {
+         return tableName;
+         }
+         */
+        return tableName;
+    }
+
+    /**
+     * 鑾峰彇涓婚敭鍚嶇О
+     */
+    @Override
+    public String getPkName_() {
+        return Id;
+    }
+
+    /**
+     * 鑾峰彇涓婚敭鍊�
+     */
+    @Override
+    public Object getPkValue_() {
+        return this.getId();
+    }
+
+    /**
+     * 鑾峰彇鎻掑叆璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getInsertSql_() {
+        InsertBuilder ib = new InsertBuilder(this.getTableName_());
+        ib.set(Id, this.getId());
+        ib.set(UsingFormBackId, this.getUsingFormBackId(), this.isset_usingFormBackId);
+        ib.set(UsingFormBackGoodsId, this.getUsingFormBackGoodsId(), this.isset_usingFormBackGoodsId);
+        ib.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
+        ib.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName);
+        ib.set(Classification, this.getClassification(), this.isset_classification);
+        ib.set(Unit, this.getUnit(), this.isset_unit);
+        ib.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
+        ib.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
+        ib.set(ProcureModelUserId, this.getProcureModelUserId(), this.isset_procureModelUserId);
+        ib.set(InitialCount, this.getInitialCount(), this.isset_initialCount);
+        ib.set(UseCount, this.getUseCount(), this.isset_useCount);
+        ib.set(Counts, this.getCounts(), this.isset_counts);
+        ib.set(GoodsUserName, this.getGoodsUserName(), this.isset_goodsUserName);
+        ib.set(Beiz, this.getBeiz(), this.isset_beiz);
+        return ib.genMapSql();
+    }
+
+    /**
+     * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
+        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(UsingFormBackId, this.getUsingFormBackId(), this.isset_usingFormBackId);
+        ub.set(UsingFormBackGoodsId, this.getUsingFormBackGoodsId(), this.isset_usingFormBackGoodsId);
+        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
+        ub.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName);
+        ub.set(Classification, this.getClassification(), this.isset_classification);
+        ub.set(Unit, this.getUnit(), this.isset_unit);
+        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
+        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
+        ub.set(ProcureModelUserId, this.getProcureModelUserId(), this.isset_procureModelUserId);
+        ub.set(InitialCount, this.getInitialCount(), this.isset_initialCount);
+        ub.set(UseCount, this.getUseCount(), this.isset_useCount);
+        ub.set(Counts, this.getCounts(), this.isset_counts);
+        ub.set(GoodsUserName, this.getGoodsUserName(), this.isset_goodsUserName);
+        ub.set(Beiz, this.getBeiz(), this.isset_beiz);
+        ub.where(this.getPkName_(), this.getPkValue_());
+        return ub.genMapSql();
+    }
+
+    /**
+     * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
+        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(UsingFormBackId, this.getUsingFormBackId(), this.isset_usingFormBackId);
+        ub.set(UsingFormBackGoodsId, this.getUsingFormBackGoodsId(), this.isset_usingFormBackGoodsId);
+        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
+        ub.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName);
+        ub.set(Classification, this.getClassification(), this.isset_classification);
+        ub.set(Unit, this.getUnit(), this.isset_unit);
+        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
+        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
+        ub.set(ProcureModelUserId, this.getProcureModelUserId(), this.isset_procureModelUserId);
+        ub.set(InitialCount, this.getInitialCount(), this.isset_initialCount);
+        ub.set(UseCount, this.getUseCount(), this.isset_useCount);
+        ub.set(Counts, this.getCounts(), this.isset_counts);
+        ub.set(GoodsUserName, this.getGoodsUserName(), this.isset_goodsUserName);
+        ub.set(Beiz, this.getBeiz(), this.isset_beiz);
+        return ub.genMapSql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
+        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(UsingFormBackId, this.getUsingFormBackId(), this.isset_usingFormBackId);
+        ub.set(UsingFormBackGoodsId, this.getUsingFormBackGoodsId(), this.isset_usingFormBackGoodsId);
+        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
+        ub.set(BaseGoodsTemplateName, this.getBaseGoodsTemplateName(), this.isset_baseGoodsTemplateName);
+        ub.set(Classification, this.getClassification(), this.isset_classification);
+        ub.set(Unit, this.getUnit(), this.isset_unit);
+        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
+        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
+        ub.set(ProcureModelUserId, this.getProcureModelUserId(), this.isset_procureModelUserId);
+        ub.set(InitialCount, this.getInitialCount(), this.isset_initialCount);
+        ub.set(UseCount, this.getUseCount(), this.isset_useCount);
+        ub.set(Counts, this.getCounts(), this.isset_counts);
+        ub.set(GoodsUserName, this.getGoodsUserName(), this.isset_goodsUserName);
+        ub.set(Beiz, this.getBeiz(), this.isset_beiz);
+        return ub.genArraySql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
+        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+        db.where(this.getPkName_(), this.getPkValue_());
+        return db.genMapSql();
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
+        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+        return db.genMapSql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
+        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+        return db.genArraySql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鍗曡鏌ヨ璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getSingleSql_() {
+        SelectBuilder sb = new SelectBuilder(this.getTableName_());
+        sb.where(this.getPkName_(), this.getPkValue_());
+        return sb.genMapSql();
+    }
+
+
+    /**
+     * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
+        return new SqlAndParameters<>(
+            "select id, using_form_back_id, using_form_back_goods_id, base_goods_template_id, base_goods_template_name, classification, unit, base_goods_models_id, base_goods_models_name, procure_model_user_id, initial_count, use_count, counts, goods_user_name, beiz from "
+                + this.getTableName_() + " " + where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
+        return new SqlAndParameters<>(
+            "select id, using_form_back_id, using_form_back_goods_id, base_goods_template_id, base_goods_template_name, classification, unit, base_goods_models_id, base_goods_models_name, procure_model_user_id, initial_count, use_count, counts, goods_user_name, beiz from "
+                + this.getTableName_() + " " + where, parameters);
+    }
+
+    /**
+     * 灏唕esultset鐨勪竴琛岃浆鍖栦负po
+     */
+    @Override
+    public UsingFormBackModel mapRow(ResultSet rs, int i) throws SQLException {
+        return ROW_MAPPER.mapRow(rs, i);
+    }
+
+    /**
+     * 鍏嬮殕
+     */
+    public UsingFormBackModel toUsingFormBackModel() {
+        return super.$clone();
+    }
+}
+
+/**
+ * using_form_back_model RowMapper
+ *
+ * @author genrator
+ */
+class UsingFormBackModelRowMapper implements RowMapper<UsingFormBackModel> {
+
+    @Override
+    public UsingFormBackModel mapRow(ResultSet rs, int i) throws SQLException {
+        ResultSetUtils resultSetUtils = new ResultSetUtils();
+        UsingFormBackModel using_form_back_model = new UsingFormBackModel();
+        Integer columnIndex;
+        //涓婚敭
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.Id);
+        if (columnIndex > 0) {
+            using_form_back_model.setId(rs.getLong(columnIndex));
+        }
+        //鏅�氬睘鎬�
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.UsingFormBackId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back_model.setUsingFormBackId(null);
+            } else {
+                using_form_back_model.setUsingFormBackId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.UsingFormBackGoodsId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back_model.setUsingFormBackGoodsId(null);
+            } else {
+                using_form_back_model.setUsingFormBackGoodsId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.BaseGoodsTemplateId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back_model.setBaseGoodsTemplateId(null);
+            } else {
+                using_form_back_model.setBaseGoodsTemplateId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.BaseGoodsTemplateName);
+        if (columnIndex > 0) {
+            using_form_back_model.setBaseGoodsTemplateName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.Classification);
+        if (columnIndex > 0) {
+            using_form_back_model.setClassification(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.Unit);
+        if (columnIndex > 0) {
+            using_form_back_model.setUnit(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.BaseGoodsModelsId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back_model.setBaseGoodsModelsId(null);
+            } else {
+                using_form_back_model.setBaseGoodsModelsId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.BaseGoodsModelsName);
+        if (columnIndex > 0) {
+            using_form_back_model.setBaseGoodsModelsName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.ProcureModelUserId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back_model.setProcureModelUserId(null);
+            } else {
+                using_form_back_model.setProcureModelUserId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.InitialCount);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back_model.setInitialCount(null);
+            } else {
+                using_form_back_model.setInitialCount(rs.getInt(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.UseCount);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back_model.setUseCount(null);
+            } else {
+                using_form_back_model.setUseCount(rs.getInt(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.Counts);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back_model.setCounts(null);
+            } else {
+                using_form_back_model.setCounts(rs.getInt(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.GoodsUserName);
+        if (columnIndex > 0) {
+            using_form_back_model.setGoodsUserName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBackModel_mapper.Beiz);
+        if (columnIndex > 0) {
+            using_form_back_model.setBeiz(rs.getString(columnIndex));
+        }
+        return using_form_back_model;
+    }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBack_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBack_mapper.java
new file mode 100644
index 0000000..89158f0
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/UsingFormBack_mapper.java
@@ -0,0 +1,424 @@
+package com.consum.model.po;
+
+import com.walker.jdbc.BaseMapper;
+import com.walker.jdbc.ResultSetUtils;
+import com.walker.jdbc.SqlAndParameters;
+import com.walker.jdbc.sqlgen.DeleteBuilder;
+import com.walker.jdbc.sqlgen.InsertBuilder;
+import com.walker.jdbc.sqlgen.SelectBuilder;
+import com.walker.jdbc.sqlgen.UpdateBuilder;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.Map;
+import org.springframework.jdbc.core.RowMapper;
+
+/**
+ * 琛ㄥ悕:USING_FORM_BACK
+ *
+ * @author genrator
+ */
+public class UsingFormBack_mapper extends UsingFormBack implements BaseMapper<UsingFormBack> {
+
+    // 搴忓垪鍖栫増鏈彿
+    private static final long serialVersionUID = 1L;
+
+    public static final RowMapper<UsingFormBack> ROW_MAPPER = new UsingFormBackRowMapper();
+
+    // 涓婚敭
+    public static final String Id = "id";
+    // 鏅�氬睘鎬�
+    public static final String BusinessFormCode = "business_form_code";
+    public static final String ProcureDoc = "procure_doc";
+    public static final String OutWarehouseType = "out_warehouse_type";
+    public static final String OutWarehouseId = "out_warehouse_id";
+    public static final String OutWarehouseName = "out_warehouse_name";
+    public static final String OperatorId = "operator_id";
+    public static final String OperatorName = "operator_name";
+    public static final String DealTime = "deal_time";
+    public static final String AgencyId = "agency_id";
+    public static final String AgencyName = "agency_name";
+    public static final String DepartmentId = "department_id";
+    public static final String DepartmentName = "department_name";
+    public static final String CreateTime = "create_time";
+    public static final String States = "states";
+    public static final String Beiz = "beiz";
+
+    /**
+     * 榛樿鏋勯�犲嚱鏁�
+     */
+    public UsingFormBack_mapper(UsingFormBack usingFormBack) {
+        if (usingFormBack == null) {
+            throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒");
+        }
+        //涓婚敭
+        if (usingFormBack.isset_id) {
+            this.setId(usingFormBack.getId());
+        }
+        //鏅�氬睘鎬�
+        if (usingFormBack.isset_businessFormCode) {
+            this.setBusinessFormCode(usingFormBack.getBusinessFormCode());
+        }
+        if (usingFormBack.isset_procureDoc) {
+            this.setProcureDoc(usingFormBack.getProcureDoc());
+        }
+        if (usingFormBack.isset_outWarehouseType) {
+            this.setOutWarehouseType(usingFormBack.getOutWarehouseType());
+        }
+        if (usingFormBack.isset_outWarehouseId) {
+            this.setOutWarehouseId(usingFormBack.getOutWarehouseId());
+        }
+        if (usingFormBack.isset_outWarehouseName) {
+            this.setOutWarehouseName(usingFormBack.getOutWarehouseName());
+        }
+        if (usingFormBack.isset_operatorId) {
+            this.setOperatorId(usingFormBack.getOperatorId());
+        }
+        if (usingFormBack.isset_operatorName) {
+            this.setOperatorName(usingFormBack.getOperatorName());
+        }
+        if (usingFormBack.isset_dealTime) {
+            this.setDealTime(usingFormBack.getDealTime());
+        }
+        if (usingFormBack.isset_agencyId) {
+            this.setAgencyId(usingFormBack.getAgencyId());
+        }
+        if (usingFormBack.isset_agencyName) {
+            this.setAgencyName(usingFormBack.getAgencyName());
+        }
+        if (usingFormBack.isset_departmentId) {
+            this.setDepartmentId(usingFormBack.getDepartmentId());
+        }
+        if (usingFormBack.isset_departmentName) {
+            this.setDepartmentName(usingFormBack.getDepartmentName());
+        }
+        if (usingFormBack.isset_createTime) {
+            this.setCreateTime(usingFormBack.getCreateTime());
+        }
+        if (usingFormBack.isset_states) {
+            this.setStates(usingFormBack.getStates());
+        }
+        if (usingFormBack.isset_beiz) {
+            this.setBeiz(usingFormBack.getBeiz());
+        }
+        // 鍘绘帀锛�2022-09-07
+        // this.setDatabaseName_(using_form_back.getDatabaseName_());
+    }
+
+    /**
+     * 鑾峰彇琛ㄥ悕
+     */
+    @Override
+    public String getTableName_() {
+        String tableName = "using_form_back";
+        /**
+         if (StringUtils.isNotEmpty(this.getDatabaseName_())) {
+         return this.getDatabaseName_() + "." + tableName;
+         } else {
+         return tableName;
+         }
+         */
+        return tableName;
+    }
+
+    /**
+     * 鑾峰彇涓婚敭鍚嶇О
+     */
+    @Override
+    public String getPkName_() {
+        return Id;
+    }
+
+    /**
+     * 鑾峰彇涓婚敭鍊�
+     */
+    @Override
+    public Object getPkValue_() {
+        return this.getId();
+    }
+
+    /**
+     * 鑾峰彇鎻掑叆璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getInsertSql_() {
+        InsertBuilder ib = new InsertBuilder(this.getTableName_());
+        ib.set(Id, this.getId());
+        ib.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+        ib.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc);
+        ib.set(OutWarehouseType, this.getOutWarehouseType(), this.isset_outWarehouseType);
+        ib.set(OutWarehouseId, this.getOutWarehouseId(), this.isset_outWarehouseId);
+        ib.set(OutWarehouseName, this.getOutWarehouseName(), this.isset_outWarehouseName);
+        ib.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
+        ib.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
+        ib.set(DealTime, this.getDealTime(), this.isset_dealTime);
+        ib.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+        ib.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+        ib.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId);
+        ib.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName);
+        ib.set(CreateTime, this.getCreateTime(), this.isset_createTime);
+        ib.set(States, this.getStates(), this.isset_states);
+        ib.set(Beiz, this.getBeiz(), this.isset_beiz);
+        return ib.genMapSql();
+    }
+
+    /**
+     * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
+        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+        ub.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc);
+        ub.set(OutWarehouseType, this.getOutWarehouseType(), this.isset_outWarehouseType);
+        ub.set(OutWarehouseId, this.getOutWarehouseId(), this.isset_outWarehouseId);
+        ub.set(OutWarehouseName, this.getOutWarehouseName(), this.isset_outWarehouseName);
+        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
+        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
+        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
+        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+        ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+        ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId);
+        ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName);
+        ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
+        ub.set(States, this.getStates(), this.isset_states);
+        ub.set(Beiz, this.getBeiz(), this.isset_beiz);
+        ub.where(this.getPkName_(), this.getPkValue_());
+        return ub.genMapSql();
+    }
+
+    /**
+     * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
+        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+        ub.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc);
+        ub.set(OutWarehouseType, this.getOutWarehouseType(), this.isset_outWarehouseType);
+        ub.set(OutWarehouseId, this.getOutWarehouseId(), this.isset_outWarehouseId);
+        ub.set(OutWarehouseName, this.getOutWarehouseName(), this.isset_outWarehouseName);
+        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
+        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
+        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
+        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+        ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+        ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId);
+        ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName);
+        ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
+        ub.set(States, this.getStates(), this.isset_states);
+        ub.set(Beiz, this.getBeiz(), this.isset_beiz);
+        return ub.genMapSql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
+        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
+        ub.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc);
+        ub.set(OutWarehouseType, this.getOutWarehouseType(), this.isset_outWarehouseType);
+        ub.set(OutWarehouseId, this.getOutWarehouseId(), this.isset_outWarehouseId);
+        ub.set(OutWarehouseName, this.getOutWarehouseName(), this.isset_outWarehouseName);
+        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
+        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
+        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
+        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
+        ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
+        ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId);
+        ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName);
+        ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
+        ub.set(States, this.getStates(), this.isset_states);
+        ub.set(Beiz, this.getBeiz(), this.isset_beiz);
+        return ub.genArraySql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getDeleteSql_() {
+        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+        db.where(this.getPkName_(), this.getPkValue_());
+        return db.genMapSql();
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) {
+        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+        return db.genMapSql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) {
+        DeleteBuilder db = new DeleteBuilder(this.getTableName_());
+        return db.genArraySql(where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鍗曡鏌ヨ璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getSingleSql_() {
+        SelectBuilder sb = new SelectBuilder(this.getTableName_());
+        sb.where(this.getPkName_(), this.getPkValue_());
+        return sb.genMapSql();
+    }
+
+
+    /**
+     * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
+        return new SqlAndParameters<>(
+            "select id, business_form_code, procure_doc, out_warehouse_type, out_warehouse_id, out_warehouse_name, operator_id, operator_name, deal_time, agency_id, agency_name, department_id, department_name, create_time, states, beiz from "
+                + this.getTableName_() + " " + where, parameters);
+    }
+
+    /**
+     * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+     */
+    @Override
+    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
+        return new SqlAndParameters<>(
+            "select id, business_form_code, procure_doc, out_warehouse_type, out_warehouse_id, out_warehouse_name, operator_id, operator_name, deal_time, agency_id, agency_name, department_id, department_name, create_time, states, beiz from "
+                + this.getTableName_() + " " + where, parameters);
+    }
+
+    /**
+     * 灏唕esultset鐨勪竴琛岃浆鍖栦负po
+     */
+    @Override
+    public UsingFormBack mapRow(ResultSet rs, int i) throws SQLException {
+        return ROW_MAPPER.mapRow(rs, i);
+    }
+
+    /**
+     * 鍏嬮殕
+     */
+    public UsingFormBack toUsingFormBack() {
+        return super.$clone();
+    }
+}
+
+/**
+ * using_form_back RowMapper
+ *
+ * @author genrator
+ */
+class UsingFormBackRowMapper implements RowMapper<UsingFormBack> {
+
+    @Override
+    public UsingFormBack mapRow(ResultSet rs, int i) throws SQLException {
+        ResultSetUtils resultSetUtils = new ResultSetUtils();
+        UsingFormBack using_form_back = new UsingFormBack();
+        Integer columnIndex;
+        //涓婚敭
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.Id);
+        if (columnIndex > 0) {
+            using_form_back.setId(rs.getLong(columnIndex));
+        }
+        //鏅�氬睘鎬�
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.BusinessFormCode);
+        if (columnIndex > 0) {
+            using_form_back.setBusinessFormCode(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.ProcureDoc);
+        if (columnIndex > 0) {
+            using_form_back.setProcureDoc(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.OutWarehouseType);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back.setOutWarehouseType(null);
+            } else {
+                using_form_back.setOutWarehouseType(rs.getInt(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.OutWarehouseId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back.setOutWarehouseId(null);
+            } else {
+                using_form_back.setOutWarehouseId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.OutWarehouseName);
+        if (columnIndex > 0) {
+            using_form_back.setOutWarehouseName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.OperatorId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back.setOperatorId(null);
+            } else {
+                using_form_back.setOperatorId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.OperatorName);
+        if (columnIndex > 0) {
+            using_form_back.setOperatorName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.DealTime);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back.setDealTime(null);
+            } else {
+                using_form_back.setDealTime(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.AgencyId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back.setAgencyId(null);
+            } else {
+                using_form_back.setAgencyId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.AgencyName);
+        if (columnIndex > 0) {
+            using_form_back.setAgencyName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.DepartmentId);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back.setDepartmentId(null);
+            } else {
+                using_form_back.setDepartmentId(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.DepartmentName);
+        if (columnIndex > 0) {
+            using_form_back.setDepartmentName(rs.getString(columnIndex));
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.CreateTime);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back.setCreateTime(null);
+            } else {
+                using_form_back.setCreateTime(rs.getLong(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.States);
+        if (columnIndex > 0) {
+            if (rs.getBigDecimal(columnIndex) == null) {
+                using_form_back.setStates(null);
+            } else {
+                using_form_back.setStates(rs.getInt(columnIndex));
+            }
+        }
+        columnIndex = resultSetUtils.findColumn(rs, UsingFormBack_mapper.Beiz);
+        if (columnIndex > 0) {
+            using_form_back.setBeiz(rs.getString(columnIndex));
+        }
+        return using_form_back;
+    }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/vo/LWhFormOutputVo.java b/consum-model-pojo/src/main/java/com/consum/model/vo/LWhFormOutputVo.java
deleted file mode 100644
index 0555a3c..0000000
--- a/consum-model-pojo/src/main/java/com/consum/model/vo/LWhFormOutputVo.java
+++ /dev/null
@@ -1,21 +0,0 @@
-
-package com.consum.model.vo;
-
-import com.consum.model.po.LWhFormOutput;
-
-import java.util.List;
-
-public class LWhFormOutputVo extends LWhFormOutput {
-    /**
-     * 鍚勮鏍肩墿鍝佺殑杩涘嚭搴撹褰�
-     */
-    private List<LWhGoodsRecordVo> recordVoList;
-
-    public List<LWhGoodsRecordVo> getRecordVoList() {
-        return recordVoList;
-    }
-
-    public void setRecordVoList(List<LWhGoodsRecordVo> recordVoList) {
-        this.recordVoList = recordVoList;
-    }
-}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/vo/LWhFormTransferVo.java b/consum-model-pojo/src/main/java/com/consum/model/vo/LWhFormTransferVo.java
deleted file mode 100644
index 0969d0a..0000000
--- a/consum-model-pojo/src/main/java/com/consum/model/vo/LWhFormTransferVo.java
+++ /dev/null
@@ -1,16 +0,0 @@
-package com.consum.model.vo;
-
-import com.consum.model.po.LWhFormTransfer;
-import java.util.List;
-import lombok.Data;
-
-@Data
-public class LWhFormTransferVo extends LWhFormTransfer {
-
-    /**
-     * 瑙勬牸鍨嬪彿
-     */
-    private List<LWhProcureModelVo> models;
-
-
-}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/vo/LWhGoodsRecordVo.java b/consum-model-pojo/src/main/java/com/consum/model/vo/LWhGoodsRecordVo.java
deleted file mode 100644
index 912fab9..0000000
--- a/consum-model-pojo/src/main/java/com/consum/model/vo/LWhGoodsRecordVo.java
+++ /dev/null
@@ -1,19 +0,0 @@
-
-package com.consum.model.vo;
-
-import com.consum.model.po.LWhGoodsRecord;
-
-public class LWhGoodsRecordVo extends LWhGoodsRecord {
-    /**
-     * 鐗╁搧鍗曚綅
-     */
-    private String unit;
-
-    public String getUnit() {
-        return unit;
-    }
-
-    public void setUnit(String unit) {
-        this.unit = unit;
-    }
-}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/vo/LWhProcureModelVo.java b/consum-model-pojo/src/main/java/com/consum/model/vo/LWhProcureModelVo.java
deleted file mode 100644
index 7b20425..0000000
--- a/consum-model-pojo/src/main/java/com/consum/model/vo/LWhProcureModelVo.java
+++ /dev/null
@@ -1,54 +0,0 @@
-package com.consum.model.vo;
-
-import com.consum.model.po.LWhProcureModelUser;
-import java.util.List;
-import lombok.Data;
-
-/**
- * @author asus
- * @version 1.0
- * @description: TODO
- * @date 2023/11/6 15:23
- */
-@Data
-public class LWhProcureModelVo {
-
-
-    // 涓婚敭
-    private Long id;
-
-    // 灞炴�у垪琛�
-    private Long fromProcureGoodsId;
-
-
-    private Integer businessType;
-
-
-    private Long businessId;
-
-
-    private Long baseGoodsModelsId;
-
-
-    private String baseGoodsModelsName;
-
-
-    private Long price;
-
-
-    private Integer counts;
-
-
-    private Integer worehouseCount;
-
-
-    private String supplier;
-
-    /**
-     * 鐗╁搧浣跨敤浜轰俊鎭�
-     * TODO 灞炴�ч噸澶�
-     */
-    private List<LWhProcureModelUser> procureModelUsersList;
-
-
-}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/vo/TransferInfoDetailsVo.java b/consum-model-pojo/src/main/java/com/consum/model/vo/TransferInfoDetailsVo.java
deleted file mode 100644
index cc21f19..0000000
--- a/consum-model-pojo/src/main/java/com/consum/model/vo/TransferInfoDetailsVo.java
+++ /dev/null
@@ -1,42 +0,0 @@
-package com.consum.model.vo;
-
-import lombok.AllArgsConstructor;
-import lombok.Data;
-import lombok.NoArgsConstructor;
-
-/**
- * @author asus
- * @version 1.0
- * @description: 鍒嗗彂鏄庣粏
- * @date 2023/11/7 11:48
- */
-@Data
-@NoArgsConstructor
-@AllArgsConstructor
-public class TransferInfoDetailsVo {
-
-    //id
-    private Long id;
-    //鍗曞彿
-    private String businessCode;
-    //鐗╁搧鍚嶇О
-    private String goodsName;
-    //绫诲埆
-    private String goodsType;
-    //瑙勬牸鍨嬪彿id
-    private String goodsModelId;
-    //瑙勬牸鍨嬪彿鍚嶅瓧
-    private String goodsModelName;
-    //鍒嗗彂鏁伴噺
-    private Integer goodsCount;
-    //鎵�灞炴満鏋�
-    private String orgName;
-    //閮ㄩ棬
-    private String deptName;
-    //鍒嗗彂浜�
-    private String distributor;
-    //鍒嗗彂鏃堕棿
-    private String time;
-
-
-}

--
Gitblit v1.9.1