库存盘点 相关代码

luqingyang

2023-10-31 f5623e6c538ebff2dfe38ff04bdb996307e7aa84

库存盘点 相关代码

 consum-base/src/main/java/com/consum/base/controller/LWhFormInventoryController.java

New file
@@ -0,0 +1,144 @@
package com.consum.base.controller;

import com.consum.base.BaseController;
import com.consum.base.pojo.LWhFormInventoryDto;
import com.consum.base.pojo.LWhFormInventoryParam;
import com.consum.base.service.LWhFormInventoryServiceImpl;
import com.consum.model.po.BaseCategory;
import com.consum.model.po.FinSysTenantUser;
import com.consum.model.po.LWhFormInventory;
import com.iplatform.model.po.S_user_core;
import com.walker.db.page.GenericPager;
import com.walker.web.ResponseValue;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.util.CollectionUtils;
import org.springframework.web.bind.annotation.*;

import java.util.List;

/**
 * @Description 盘点
 * @Author 卢庆阳
 * @Date 2023/10/23
 */
@RestController
@RequestMapping("/pc/l/wh/form/inventory")
public class LWhFormInventoryController extends BaseController {

    @Autowired
    private LWhFormInventoryServiceImpl lWhFormInventoryService;

    /**
     * @Description 新增
     * @Author 卢庆阳
     * @Date 2023/10/31
     */
    @PostMapping("/add")
    public ResponseValue add(@RequestBody LWhFormInventoryParam param) {
        //根据盘点人id查询盘点人
        S_user_core operatorUser = this.getUser(param.getOperatorId());
        //根据监盘人id查询监盘人
        S_user_core operatorUser2 = this.getUser(param.getOperatorId2());
        int result = this.lWhFormInventoryService.add(param, this.getSysInfo(),operatorUser,operatorUser2);
        if (result > 0) return ResponseValue.success(1);
        return ResponseValue.error("新增失败！");
    }

    /**
     * @Description 盘点单列表查询
     * @Author 卢庆阳
     * @Date 2023/10/31
     */
    @GetMapping("/list")
    public ResponseValue queryList(LWhFormInventoryParam param) {
        FinSysTenantUser sysInfo = this.getSysInfo();
        if (sysInfo == null) {
            return ResponseValue.error("登录用户信息不存在");
        }
        GenericPager<LWhFormInventory> pager = this.lWhFormInventoryService.queryList(param,sysInfo);
        return ResponseValue.success(pager);
    }

    /**
     * @Description 编辑
     * @Author 卢庆阳
     * @Date 2023/10/31
     */
    @PostMapping("/edit")
    public ResponseValue edit(@RequestBody LWhFormInventoryParam param) {
        LWhFormInventory lWhFormInventory = lWhFormInventoryService.get(new LWhFormInventory(param.getId()));
        if (lWhFormInventory == null) {
            return ResponseValue.error("编辑失败！");
        }
        if (lWhFormInventory.getStates() != 0) {
            return ResponseValue.error("未开始状态才能编辑！");
        }
        int num = lWhFormInventoryService.delete(new LWhFormInventory(param.getId()));
        if (num == 0) {
            return ResponseValue.error("编辑失败！");
        }
        ResponseValue add = this.add(param);
        if (add.getCode() == ResponseValue.CODE_SUCCESS) {
            return ResponseValue.success(1);
        }

        return ResponseValue.error("编辑失败！");
    }

    /**
     * @Description 根据id删除
     */
    @DeleteMapping("/del")
    public ResponseValue delById(Long id) {
        if (id == null) {
            return ResponseValue.error("参数不能为空！");
        }
        LWhFormInventory lWhFormInventory = lWhFormInventoryService.get(new LWhFormInventory(id));
        if (lWhFormInventory == null) {
            return ResponseValue.error("删除失败！");
        }
        if (lWhFormInventory.getStates() != 0) {
            return ResponseValue.error("未开始状态才能删除！");
        }
        int num = lWhFormInventoryService.delete(new LWhFormInventory(id));
        if (num == 0) {
            return ResponseValue.error("删除失败！");
        }

        return ResponseValue.success(1);
    }

    /**
     * @Description 盘点
     * @Author 卢庆阳
     * @Date 2023/10/31
     */
    @GetMapping("/select/pdList")
    public ResponseValue queryPdList(Long id) {
        if (id == null) {
            return ResponseValue.error("盘点失败！");
        }

        List list = this.lWhFormInventoryService.queryPdList(id);
        return ResponseValue.success(list);
    }

    /**
     * 暂存
     * @author 卢庆阳
     * @date 2023/10/31
     */
    @PostMapping("/temporaryStorage")
    public ResponseValue temporaryStorage(@RequestBody LWhFormInventoryDto dto) {
        if (dto == null) {
            return ResponseValue.error("参数错误");
        }

        int num = this.lWhFormInventoryService.temporaryStorage(dto);
        return num > 0 ? ResponseValue.success(1) : ResponseValue.error("修改失败！");
    }



}


 consum-base/src/main/java/com/consum/base/controller/LWhFormInventoryGoodsController.java

New file
@@ -0,0 +1,51 @@
package com.consum.base.controller;

import com.consum.base.BaseController;
import com.consum.base.pojo.LWhFormInventoryParam;
import com.consum.base.service.LWhFormInventoryGoodsServiceImpl;
import com.consum.base.service.LWhFormInventoryServiceImpl;
import com.consum.model.po.FinSysTenantUser;
import com.consum.model.po.LWhFormInventory;
import com.consum.model.po.LWhFormInventoryGoods;
import com.iplatform.model.po.S_user_core;
import com.walker.db.page.GenericPager;
import com.walker.web.ResponseValue;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;

import java.util.List;

/**
 * @Description 盘点单物品
 * @Author 卢庆阳
 * @Date 2023/10/31
 */
@RestController
@RequestMapping("/pc/l/wh/form/inventory/goods")
public class LWhFormInventoryGoodsController extends BaseController {

    @Autowired
    private LWhFormInventoryGoodsServiceImpl inventoryGoodsService;

    /**
     * @Description  根据盘点单id查询盘点单物品(继续盘点)
     * @Author 卢庆阳
     * @Date 2023/10/31
     * @return
     */
    @GetMapping("/list")
    public ResponseValue queryList(Long id) {
        FinSysTenantUser sysInfo = this.getSysInfo();
        if (sysInfo == null) {
            return ResponseValue.error("登录用户信息不存在");
        }
        if (id == null) {
            ResponseValue.error("参数错误");
        }
        List<LWhFormInventoryGoods> list = this.inventoryGoodsService.getByInventoryId(id);
        return ResponseValue.success(list);
    }


}


 consum-base/src/main/java/com/consum/base/core/CodeGeneratorEnum.java

@@ -24,10 +24,16 @@
    Transfer("DB"),

    /**
     * 盘点单编码，简写：PD
     */
    Inventory("PD"),

    /**
     * 出库单编码，简写：CK
     */
    OutPut_Warehouse("CK");


    private String value;

    CodeGeneratorEnum(String prefix) {

 consum-base/src/main/java/com/consum/base/pojo/LWhFormInventoryDto.java

New file
@@ -0,0 +1,21 @@
package com.consum.base.pojo;

import com.consum.model.po.LWhFormInventory;
import com.consum.model.po.LWhFormInventoryGoods;

import java.util.List;

public class LWhFormInventoryDto extends LWhFormInventory {
    /**
     * 盘点单物品
     */
    private  List<LWhFormInventoryGoods> inventoryGoodsList;

    public List<LWhFormInventoryGoods> getInventoryGoodsList() {
        return inventoryGoodsList;
    }

    public void setInventoryGoodsList(List<LWhFormInventoryGoods> inventoryGoodsList) {
        this.inventoryGoodsList = inventoryGoodsList;
    }
}

 consum-base/src/main/java/com/consum/base/pojo/LWhFormInventoryParam.java

New file
@@ -0,0 +1,111 @@
package com.consum.base.pojo;

import com.walker.web.param.ParamRequest;

public class LWhFormInventoryParam extends ParamRequest {
    private Long id;
    /**
     * 盘点单号
     */
    private String businessFormCode;
    /**
     * 盘点单名
     */
    private String businessFormName;
    /**
     * 仓库编号
     */
    private Long warehouseId;
    /**
     * 盘点人
     */
    private Long operatorId;
    /**
     * 监盘人
     */
    private Integer operatorId2;
    /**
     * 备注
     */
    private String beiz1;
    /**
     * 盘点时间 开始
     */
    private Long inventoryDateStart;
    /**
     * 盘点时间 结束
     */
    private Long inventoryDateEnd;

    public Long getId() {
        return id;
    }

    public void setId(Long id) {
        this.id = id;
    }

    public String getBusinessFormCode() {
        return businessFormCode;
    }

    public void setBusinessFormCode(String businessFormCode) {
        this.businessFormCode = businessFormCode;
    }

    public String getBusinessFormName() {
        return businessFormName;
    }

    public void setBusinessFormName(String businessFormName) {
        this.businessFormName = businessFormName;
    }

    public Long getWarehouseId() {
        return warehouseId;
    }

    public void setWarehouseId(Long warehouseId) {
        this.warehouseId = warehouseId;
    }

    public Long getOperatorId() {
        return operatorId;
    }

    public void setOperatorId(Long operatorId) {
        this.operatorId = operatorId;
    }

    public Integer getOperatorId2() {
        return operatorId2;
    }

    public void setOperatorId2(Integer operatorId2) {
        this.operatorId2 = operatorId2;
    }

    public String getBeiz1() {
        return beiz1;
    }

    public void setBeiz1(String beiz1) {
        this.beiz1 = beiz1;
    }

    public Long getInventoryDateStart() {
        return inventoryDateStart;
    }

    public void setInventoryDateStart(Long inventoryDateStart) {
        this.inventoryDateStart = inventoryDateStart;
    }

    public Long getInventoryDateEnd() {
        return inventoryDateEnd;
    }

    public void setInventoryDateEnd(Long inventoryDateEnd) {
        this.inventoryDateEnd = inventoryDateEnd;
    }
}

 consum-base/src/main/java/com/consum/base/service/LWhFormInventoryGoodsServiceImpl.java

New file
@@ -0,0 +1,57 @@
package com.consum.base.service;

import com.consum.base.util.IdUtil;
import com.consum.model.po.LWhFormInventoryGoods;
import com.walker.jdbc.service.BaseServiceImpl;
import lombok.extern.slf4j.Slf4j;
import org.springframework.stereotype.Service;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

/**
 * @Description 盘点单物品
 * @Author 卢庆阳
 * @Date 2023/10/31
 */
@Slf4j
@Service
public class LWhFormInventoryGoodsServiceImpl extends BaseServiceImpl {

    /**
     * @Description  根据盘点单id查询盘点单物品
     * @Author 卢庆阳
     * @Date 2023/10/31
     * @return
     */
    public List<LWhFormInventoryGoods> getByInventoryId(Long id) {
        LWhFormInventoryGoods inventoryGoods = new LWhFormInventoryGoods();
        inventoryGoods.setWhFormInventoryId(id);
        return this.select(inventoryGoods);
    }

    /**
     * @Description  新增盘点单物品记录
     * @Author 卢庆阳
     * @Date 2023/10/31
     * @return
     */
    public int add(List<Map<String, Object>> list, Long warehouseId) {
        List<LWhFormInventoryGoods> inventoryGoodsList = new ArrayList<>();
        for (Map<String, Object> map : list) {
            LWhFormInventoryGoods inventoryGoods = new LWhFormInventoryGoods();
            inventoryGoods.setId(IdUtil.generateId());
            inventoryGoods.setWhFormInventoryId(warehouseId);
            inventoryGoods.setBaseGoodsTemplateId((Long) map.get("id"));
            inventoryGoods.setGoodsTemplateName((String) map.get("goodsname"));
            inventoryGoods.setUnit((String) map.get("unit"));
            inventoryGoods.setBaseGoodsModelsId((Long) map.get("modelsid"));
            inventoryGoods.setBaseGoodsModelsName((String) map.get("goodsTemplateId"));
            inventoryGoods.setInitCounts((Integer) map.get("endcount"));

            inventoryGoodsList.add(inventoryGoods);
        }
        return this.insert(inventoryGoodsList);
    }
}

 consum-base/src/main/java/com/consum/base/service/LWhFormInventoryServiceImpl.java

New file
@@ -0,0 +1,173 @@
package com.consum.base.service;

import com.consum.base.core.CodeGeneratorEnum;
import com.consum.base.core.CodeGeneratorService;
import com.consum.base.pojo.LWhFormInventoryDto;
import com.consum.base.pojo.LWhFormInventoryParam;
import com.consum.base.util.IdUtil;
import com.consum.model.po.*;
import com.iplatform.model.po.S_user_core;
import com.walker.db.page.GenericPager;
import com.walker.infrastructure.utils.DateUtils;
import com.walker.infrastructure.utils.StringUtils;
import com.walker.jdbc.service.BaseServiceImpl;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.util.CollectionUtils;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * @Description 盘点
 * @Author 卢庆阳
 * @Date 2023/10/23
 */
@Slf4j
@Service
public class LWhFormInventoryServiceImpl extends BaseServiceImpl {

    @Autowired
    private CodeGeneratorService codeGeneratorService;
    @Autowired
    private BaseWarehouseServiceImpl baseWarehouseService;
    @Autowired
    private FinSysTenantUserServiceImpl finSysTenantUserService;
    @Autowired
    private LWhFormInventoryGoodsServiceImpl inventoryGoodsService;


    private static final String QUERY_LIST = "select * from l_wh_form_inventory where 1=1 ";

    private static final String QUERY_PD_List = "SELECT bgt.GOODS_NAME goodsName,model.MODEL_NAME modelName,bgt.CLASSIFICATION,model.UNIT,\n" +
            "       record.endCount,bgt.ID goodsTemplateId,model.ID modelsId\n" +
            "FROM BASE_GOODS_MODELS model\n" +
            "         LEFT JOIN (SELECT COUNT(1) endCount, BASE_GOODS_MODELS_ID\n" +
            "                    FROM L_WH_GOODS\n" +
            "                    WHERE WAREHOUSE_TYPE = 0\n" +
            "                      AND WAREHOUSE_ID = 1\n" +
            "                      AND STATES = ?\n" +
            "                    GROUP BY BASE_GOODS_MODELS_ID) record ON record.BASE_GOODS_MODELS_ID = model.id\n" +
            "left join base_goods_template bgt on bgt.ID = model.GOODS_TEMPLATES_ID; ";

    /**
     * @Description 新增
     * @Author 卢庆阳
     * @Date 2023/10/31
     * @param param
     * @param currentUser   当前登录用户
     * @param operatorUser  盘点人
     * @param operatorUser2 监盘人
     * @return
     */
    public int add(LWhFormInventoryParam param, FinSysTenantUser currentUser, S_user_core operatorUser, S_user_core operatorUser2) {
        //新增盘点单
        LWhFormInventory lWhFormInventory = new LWhFormInventory();
        BeanUtils.copyProperties(param,lWhFormInventory);
        lWhFormInventory.setId(IdUtil.generateId());
        //盘点单编码
        String businessFormCode = codeGeneratorService.createBusinessFormCode(CodeGeneratorEnum.Inventory);
        lWhFormInventory.setBusinessFormCode(businessFormCode);
        //根据仓库id查询仓库
        BaseWarehouse baseWarehouse = this.baseWarehouseService.getById(param.getWarehouseId());
        if (baseWarehouse != null) {
            lWhFormInventory.setWarehouseName(baseWarehouse.getWarehouseName());
        }
        lWhFormInventory.setOperatorName(operatorUser.getUser_name());
        lWhFormInventory.setOperatorName2(operatorUser2.getUser_name());
        lWhFormInventory.setStates(0);
        lWhFormInventory.setAgencyId(Long.valueOf(currentUser.getTenantId()));
        lWhFormInventory.setAgencyName(currentUser.getTenantName());
        lWhFormInventory.setCreatorId(currentUser.getSysUserId());
        lWhFormInventory.setCreatorName(currentUser.getUserName());
        lWhFormInventory.setCreateTime(DateUtils.getDateTimeNumber(System.currentTimeMillis()));

        return this.insert(lWhFormInventory);
    }

    /**
     * @Description 盘点单列表查询
     * @Author 卢庆阳
     * @Date 2023/10/31
     */
    public GenericPager<LWhFormInventory> queryList(LWhFormInventoryParam param, FinSysTenantUser sysInfo) {
        StringBuilder sql = new StringBuilder(QUERY_LIST);
        HashMap<String, Object> paramts = new HashMap<>();

        //盘点单号
        if (!StringUtils.isEmpty(param.getBusinessFormCode())) {
            sql.append(" and BUSINESS_FORM_CODE like:BUSINESS_FORM_CODE ");
            paramts.put("BUSINESS_FORM_CODE", StringUtils.CHAR_PERCENT + param.getBusinessFormCode() + StringUtils.CHAR_PERCENT);
        }
        //盘点单名称
        if (!StringUtils.isEmpty(param.getBusinessFormName())) {
            sql.append(" and BUSINESS_FORM_NAME =:BUSINESS_FORM_NAME ");
            paramts.put("BUSINESS_FORM_NAME", StringUtils.CHAR_PERCENT + param.getBusinessFormName() + StringUtils.CHAR_PERCENT);
        }
        //仓库编号
        if (param.getWarehouseId() != null) {
            sql.append(" and WAREHOUSE_ID =:WAREHOUSE_ID ");
            paramts.put("WAREHOUSE_ID", param.getWarehouseId());
        }
        //盘点时间
        if (param.getInventoryDateStart() != null) {
            sql.append(" and INVENTORY_DATE >=:inventoryDateStart ");
            paramts.put("inventoryDateStart", param.getInventoryDateStart() * 1000000);
        }
        if (param.getInventoryDateEnd() != null) {
            sql.append(" and INVENTORY_DATE <:inventoryDateEnd ");
            paramts.put("inventoryDateEnd", param.getInventoryDateEnd() * 1000000 + 240000);
        }
        //机构
        sql.append(" and AGENCY_ID =:AGENCY_ID ");
        paramts.put("AGENCY_ID", sysInfo.getTenantId());

        sql.append(" ORDER BY CREATE_TIME DESC ");
        return selectSplit(sql.toString(), paramts, new LWhFormInventory());
    }

    /**
     * @Description 盘点
     * @Author 卢庆阳
     * @Date 2023/10/31
     * @param id  盘点单id
     */
    public List queryPdList(Long id) {
        //1.根据盘点单id查询盘点单
        LWhFormInventory lWhFormInventory = this.get(new LWhFormInventory(id));
        if (lWhFormInventory == null) {
            log.error("盘点失败");
        }
        //2.查询盘点单数据
        List<Map<String, Object>> list = this.select(QUERY_PD_List, new Object[]{lWhFormInventory.getWarehouseId()});
        if (CollectionUtils.isEmpty(list)) {
            log.error("盘点失败");
            return null;
        }
        //3.新增盘点单物品记录
        int flag = inventoryGoodsService.add(list, lWhFormInventory.getWarehouseId());
        if (flag != list.size()) {
            log.error("新增盘点单记录");
            return null;
        }
        //4.根据盘点单id查询盘点单物品
        return inventoryGoodsService.getByInventoryId(id);
    }

    /**
     * 暂存
     * @author 卢庆阳
     * @date 2023/10/31
     */
    public int temporaryStorage(LWhFormInventoryDto dto) {
        //1.根据盘点单id查询盘点单

        //2.删除盘点单物品
        //3.新增盘点单物品
        return 0;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory.java

New file
@@ -0,0 +1,480 @@

package com.consum.model.po;

import com.fasterxml.jackson.annotation.JsonAutoDetect;
import com.fasterxml.jackson.annotation.JsonIgnore;
import com.walker.jdbc.BasePo;

/**
 * 表名:L_WH_FORM_INVENTORY *
 * @author genrator
 */
@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
public class LWhFormInventory extends BasePo<LWhFormInventory> {
    // 序列化版本号
    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 businessFormName = null;
    @JsonIgnore
    protected boolean isset_businessFormName = false;

    private Integer warehouseType = null;
    @JsonIgnore
    protected boolean isset_warehouseType = false;

    private Long warehouseId = null;
    @JsonIgnore
    protected boolean isset_warehouseId = false;

    private String warehouseName = null;
    @JsonIgnore
    protected boolean isset_warehouseName = false;

    private Long operatorId = null;
    @JsonIgnore
    protected boolean isset_operatorId = false;

    private String operatorName = null;
    @JsonIgnore
    protected boolean isset_operatorName = false;

    private Integer states = null;
    @JsonIgnore
    protected boolean isset_states = false;

    private Long operatorId2 = null;
    @JsonIgnore
    protected boolean isset_operatorId2 = false;

    private String operatorName2 = null;
    @JsonIgnore
    protected boolean isset_operatorName2 = false;

    private String beiz1 = null;
    @JsonIgnore
    protected boolean isset_beiz1 = false;

    private Long agencyId = null;
    @JsonIgnore
    protected boolean isset_agencyId = false;

    private String agencyName = null;
    @JsonIgnore
    protected boolean isset_agencyName = false;

    private Long creatorId = null;
    @JsonIgnore
    protected boolean isset_creatorId = false;

    private String creatorName = null;
    @JsonIgnore
    protected boolean isset_creatorName = false;

    private Long inventoryDate = null;
    @JsonIgnore
    protected boolean isset_inventoryDate = false;

    private Long createTime = null;
    @JsonIgnore
    protected boolean isset_createTime = false;

    private Long stopTime = null;
    @JsonIgnore
    protected boolean isset_stopTime = false;

    /**
     * 默认构造函数
     */
    public LWhFormInventory() {
    }

    /**
     * 根据主键构造对象
     */
    public LWhFormInventory(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 getBusinessFormName() {
        return this.businessFormName;
    }

    public void setBusinessFormName(String businessFormName) {
        this.businessFormName = businessFormName;
        this.isset_businessFormName = true;
    }

    @JsonIgnore
    public boolean isEmptyBusinessFormName() {
        return this.businessFormName == null || this.businessFormName.length() == 0;
    }

    public Integer getWarehouseType() {
        return this.warehouseType;
    }

    public void setWarehouseType(Integer warehouseType) {
        this.warehouseType = warehouseType;
        this.isset_warehouseType = true;
    }

    @JsonIgnore
    public boolean isEmptyWarehouseType() {
        return this.warehouseType == null;
    }

    public Long getWarehouseId() {
        return this.warehouseId;
    }

    public void setWarehouseId(Long warehouseId) {
        this.warehouseId = warehouseId;
        this.isset_warehouseId = true;
    }

    @JsonIgnore
    public boolean isEmptyWarehouseId() {
        return this.warehouseId == null;
    }

    public String getWarehouseName() {
        return this.warehouseName;
    }

    public void setWarehouseName(String warehouseName) {
        this.warehouseName = warehouseName;
        this.isset_warehouseName = true;
    }

    @JsonIgnore
    public boolean isEmptyWarehouseName() {
        return this.warehouseName == null || this.warehouseName.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 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 Long getOperatorId2() {
        return this.operatorId2;
    }

    public void setOperatorId2(Long operatorId2) {
        this.operatorId2 = operatorId2;
        this.isset_operatorId2 = true;
    }

    @JsonIgnore
    public boolean isEmptyOperatorId2() {
        return this.operatorId2 == null;
    }

    public String getOperatorName2() {
        return this.operatorName2;
    }

    public void setOperatorName2(String operatorName2) {
        this.operatorName2 = operatorName2;
        this.isset_operatorName2 = true;
    }

    @JsonIgnore
    public boolean isEmptyOperatorName2() {
        return this.operatorName2 == null || this.operatorName2.length() == 0;
    }

    public String getBeiz1() {
        return this.beiz1;
    }

    public void setBeiz1(String beiz1) {
        this.beiz1 = beiz1;
        this.isset_beiz1 = true;
    }

    @JsonIgnore
    public boolean isEmptyBeiz1() {
        return this.beiz1 == null || this.beiz1.length() == 0;
    }

    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 getCreatorId() {
        return this.creatorId;
    }

    public void setCreatorId(Long creatorId) {
        this.creatorId = creatorId;
        this.isset_creatorId = true;
    }

    @JsonIgnore
    public boolean isEmptyCreatorId() {
        return this.creatorId == null;
    }

    public String getCreatorName() {
        return this.creatorName;
    }

    public void setCreatorName(String creatorName) {
        this.creatorName = creatorName;
        this.isset_creatorName = true;
    }

    @JsonIgnore
    public boolean isEmptyCreatorName() {
        return this.creatorName == null || this.creatorName.length() == 0;
    }

    public Long getInventoryDate() {
        return this.inventoryDate;
    }

    public void setInventoryDate(Long inventoryDate) {
        this.inventoryDate = inventoryDate;
        this.isset_inventoryDate = true;
    }

    @JsonIgnore
    public boolean isEmptyInventoryDate() {
        return this.inventoryDate == null;
    }

    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 Long getStopTime() {
        return this.stopTime;
    }

    public void setStopTime(Long stopTime) {
        this.stopTime = stopTime;
        this.isset_stopTime = true;
    }

    @JsonIgnore
    public boolean isEmptyStopTime() {
        return this.stopTime == null;
    }

    /**
     * 重写 toString() 方法
     */
    @Override
    public String toString() {
        return new StringBuilder()
                .append("id=").append(this.id)
                .append("businessFormCode=").append(this.businessFormCode)
                .append("businessFormName=").append(this.businessFormName)
                .append("warehouseType=").append(this.warehouseType)
                .append("warehouseId=").append(this.warehouseId)
                .append("warehouseName=").append(this.warehouseName)
                .append("operatorId=").append(this.operatorId)
                .append("operatorName=").append(this.operatorName)
                .append("states=").append(this.states)
                .append("operatorId2=").append(this.operatorId2)
                .append("operatorName2=").append(this.operatorName2)
                .append("beiz1=").append(this.beiz1)
                .append("agencyId=").append(this.agencyId)
                .append("agencyName=").append(this.agencyName)
                .append("creatorId=").append(this.creatorId)
                .append("creatorName=").append(this.creatorName)
                .append("inventoryDate=").append(this.inventoryDate)
                .append("createTime=").append(this.createTime)
                .append("stopTime=").append(this.stopTime)
                .toString();
    }

    /**
     * 克隆
     */
    public LWhFormInventory $clone() {
        LWhFormInventory l_wh_form_inventory = new LWhFormInventory();

        // 数据库名称
        //l_wh_form_inventory.setDatabaseName_(this.getDatabaseName_());

        // 主键
        if (this.isset_id) {
            l_wh_form_inventory.setId(this.getId());
        }
        // 普通属性
        if (this.isset_businessFormCode) {
            l_wh_form_inventory.setBusinessFormCode(this.getBusinessFormCode());
        }
        if (this.isset_businessFormName) {
            l_wh_form_inventory.setBusinessFormName(this.getBusinessFormName());
        }
        if (this.isset_warehouseType) {
            l_wh_form_inventory.setWarehouseType(this.getWarehouseType());
        }
        if (this.isset_warehouseId) {
            l_wh_form_inventory.setWarehouseId(this.getWarehouseId());
        }
        if (this.isset_warehouseName) {
            l_wh_form_inventory.setWarehouseName(this.getWarehouseName());
        }
        if (this.isset_operatorId) {
            l_wh_form_inventory.setOperatorId(this.getOperatorId());
        }
        if (this.isset_operatorName) {
            l_wh_form_inventory.setOperatorName(this.getOperatorName());
        }
        if (this.isset_states) {
            l_wh_form_inventory.setStates(this.getStates());
        }
        if (this.isset_operatorId2) {
            l_wh_form_inventory.setOperatorId2(this.getOperatorId2());
        }
        if (this.isset_operatorName2) {
            l_wh_form_inventory.setOperatorName2(this.getOperatorName2());
        }
        if (this.isset_beiz1) {
            l_wh_form_inventory.setBeiz1(this.getBeiz1());
        }
        if (this.isset_agencyId) {
            l_wh_form_inventory.setAgencyId(this.getAgencyId());
        }
        if (this.isset_agencyName) {
            l_wh_form_inventory.setAgencyName(this.getAgencyName());
        }
        if (this.isset_creatorId) {
            l_wh_form_inventory.setCreatorId(this.getCreatorId());
        }
        if (this.isset_creatorName) {
            l_wh_form_inventory.setCreatorName(this.getCreatorName());
        }
        if (this.isset_inventoryDate) {
            l_wh_form_inventory.setInventoryDate(this.getInventoryDate());
        }
        if (this.isset_createTime) {
            l_wh_form_inventory.setCreateTime(this.getCreateTime());
        }
        if (this.isset_stopTime) {
            l_wh_form_inventory.setStopTime(this.getStopTime());
        }
        return l_wh_form_inventory;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventoryGoods.java

New file
@@ -0,0 +1,326 @@

package com.consum.model.po;

import com.fasterxml.jackson.annotation.JsonAutoDetect;
import com.fasterxml.jackson.annotation.JsonIgnore;
import com.walker.jdbc.BasePo;

/**
 * 表名:L_WH_FORM_INVENTORY_GOODS *
 * @author genrator
 */
@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
public class LWhFormInventoryGoods extends BasePo<LWhFormInventoryGoods> {
    // 序列化版本号
    private static final long serialVersionUID = 1L;

    // 主键
    private Long id = null;
    @JsonIgnore
    protected boolean isset_id = false;

    // 属性列表
    private Long whFormInventoryId = null;
    @JsonIgnore
    protected boolean isset_whFormInventoryId = false;

    private Long baseGoodsTemplateId = null;
    @JsonIgnore
    protected boolean isset_baseGoodsTemplateId = false;

    private String goodsTemplateName = null;
    @JsonIgnore
    protected boolean isset_goodsTemplateName = 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 Double price = null;
    @JsonIgnore
    protected boolean isset_price = false;

    private Integer initCounts = null;
    @JsonIgnore
    protected boolean isset_initCounts = false;

    private Integer inventoryCounts = null;
    @JsonIgnore
    protected boolean isset_inventoryCounts = false;

    private Integer errorCounts = null;
    @JsonIgnore
    protected boolean isset_errorCounts = false;

    private Integer inventoryResult = null;
    @JsonIgnore
    protected boolean isset_inventoryResult = false;

    /**
     * 默认构造函数
     */
    public LWhFormInventoryGoods() {
    }

    /**
     * 根据主键构造对象
     */
    public LWhFormInventoryGoods(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 getWhFormInventoryId() {
        return this.whFormInventoryId;
    }

    public void setWhFormInventoryId(Long whFormInventoryId) {
        this.whFormInventoryId = whFormInventoryId;
        this.isset_whFormInventoryId = true;
    }

    @JsonIgnore
    public boolean isEmptyWhFormInventoryId() {
        return this.whFormInventoryId == 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 getGoodsTemplateName() {
        return this.goodsTemplateName;
    }

    public void setGoodsTemplateName(String goodsTemplateName) {
        this.goodsTemplateName = goodsTemplateName;
        this.isset_goodsTemplateName = true;
    }

    @JsonIgnore
    public boolean isEmptyGoodsTemplateName() {
        return this.goodsTemplateName == null || this.goodsTemplateName.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 Double getPrice() {
        return this.price;
    }

    public void setPrice(Double price) {
        this.price = price;
        this.isset_price = true;
    }

    @JsonIgnore
    public boolean isEmptyPrice() {
        return this.price == null;
    }

    public Integer getInitCounts() {
        return this.initCounts;
    }

    public void setInitCounts(Integer initCounts) {
        this.initCounts = initCounts;
        this.isset_initCounts = true;
    }

    @JsonIgnore
    public boolean isEmptyInitCounts() {
        return this.initCounts == null;
    }

    public Integer getInventoryCounts() {
        return this.inventoryCounts;
    }

    public void setInventoryCounts(Integer inventoryCounts) {
        this.inventoryCounts = inventoryCounts;
        this.isset_inventoryCounts = true;
    }

    @JsonIgnore
    public boolean isEmptyInventoryCounts() {
        return this.inventoryCounts == null;
    }

    public Integer getErrorCounts() {
        return this.errorCounts;
    }

    public void setErrorCounts(Integer errorCounts) {
        this.errorCounts = errorCounts;
        this.isset_errorCounts = true;
    }

    @JsonIgnore
    public boolean isEmptyErrorCounts() {
        return this.errorCounts == null;
    }

    public Integer getInventoryResult() {
        return this.inventoryResult;
    }

    public void setInventoryResult(Integer inventoryResult) {
        this.inventoryResult = inventoryResult;
        this.isset_inventoryResult = true;
    }

    @JsonIgnore
    public boolean isEmptyInventoryResult() {
        return this.inventoryResult == null;
    }

    /**
     * 重写 toString() 方法
     */
    @Override
    public String toString() {
        return new StringBuilder()
                .append("id=").append(this.id)
                .append("whFormInventoryId=").append(this.whFormInventoryId)
                .append("baseGoodsTemplateId=").append(this.baseGoodsTemplateId)
                .append("goodsTemplateName=").append(this.goodsTemplateName)
                .append("unit=").append(this.unit)
                .append("baseGoodsModelsId=").append(this.baseGoodsModelsId)
                .append("baseGoodsModelsName=").append(this.baseGoodsModelsName)
                .append("price=").append(this.price)
                .append("initCounts=").append(this.initCounts)
                .append("inventoryCounts=").append(this.inventoryCounts)
                .append("errorCounts=").append(this.errorCounts)
                .append("inventoryResult=").append(this.inventoryResult)
                .toString();
    }

    /**
     * 克隆
     */
    public LWhFormInventoryGoods $clone() {
        LWhFormInventoryGoods l_wh_form_inventory_goods = new LWhFormInventoryGoods();

        // 数据库名称
        //l_wh_form_inventory_goods.setDatabaseName_(this.getDatabaseName_());

        // 主键
        if (this.isset_id) {
            l_wh_form_inventory_goods.setId(this.getId());
        }
        // 普通属性
        if (this.isset_whFormInventoryId) {
            l_wh_form_inventory_goods.setWhFormInventoryId(this.getWhFormInventoryId());
        }
        if (this.isset_baseGoodsTemplateId) {
            l_wh_form_inventory_goods.setBaseGoodsTemplateId(this.getBaseGoodsTemplateId());
        }
        if (this.isset_goodsTemplateName) {
            l_wh_form_inventory_goods.setGoodsTemplateName(this.getGoodsTemplateName());
        }
        if (this.isset_unit) {
            l_wh_form_inventory_goods.setUnit(this.getUnit());
        }
        if (this.isset_baseGoodsModelsId) {
            l_wh_form_inventory_goods.setBaseGoodsModelsId(this.getBaseGoodsModelsId());
        }
        if (this.isset_baseGoodsModelsName) {
            l_wh_form_inventory_goods.setBaseGoodsModelsName(this.getBaseGoodsModelsName());
        }
        if (this.isset_price) {
            l_wh_form_inventory_goods.setPrice(this.getPrice());
        }
        if (this.isset_initCounts) {
            l_wh_form_inventory_goods.setInitCounts(this.getInitCounts());
        }
        if (this.isset_inventoryCounts) {
            l_wh_form_inventory_goods.setInventoryCounts(this.getInventoryCounts());
        }
        if (this.isset_errorCounts) {
            l_wh_form_inventory_goods.setErrorCounts(this.getErrorCounts());
        }
        if (this.isset_inventoryResult) {
            l_wh_form_inventory_goods.setInventoryResult(this.getInventoryResult());
        }
        return l_wh_form_inventory_goods;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventoryGoods_mapper.java

New file
@@ -0,0 +1,373 @@
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 com.walker.jdbc.util.StringUtils;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

/**
 * 表名:L_WH_FORM_INVENTORY_GOODS *
 * @author genrator
 */
public class LWhFormInventoryGoods_mapper extends LWhFormInventoryGoods implements BaseMapper<LWhFormInventoryGoods> {
    // 序列化版本号
    private static final long serialVersionUID = 1L;

    public static final RowMapper<LWhFormInventoryGoods> ROW_MAPPER = new LWhFormInventoryGoodsRowMapper();

    // 主键
    public static final String Id = "id";
    // 普通属性
    public static final String WhFormInventoryId = "wh_form_inventory_id";
    public static final String BaseGoodsTemplateId = "base_goods_template_id";
    public static final String GoodsTemplateName = "goods_template_name";
    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 Price = "price";
    public static final String InitCounts = "init_counts";
    public static final String InventoryCounts = "inventory_counts";
    public static final String ErrorCounts = "error_counts";
    public static final String InventoryResult = "inventory_result";

    /**
     * 默认构造函数
     */
    public LWhFormInventoryGoods_mapper(LWhFormInventoryGoods lWhFormInventoryGoods) {
        if (lWhFormInventoryGoods == null) {
            throw new IllegalArgumentException("po参数不允许为空！");
        }
        //主键
        if (lWhFormInventoryGoods.isset_id) {
            this.setId(lWhFormInventoryGoods.getId());
        }
        //普通属性
        if (lWhFormInventoryGoods.isset_whFormInventoryId) {
            this.setWhFormInventoryId(lWhFormInventoryGoods.getWhFormInventoryId());
        }
        if (lWhFormInventoryGoods.isset_baseGoodsTemplateId) {
            this.setBaseGoodsTemplateId(lWhFormInventoryGoods.getBaseGoodsTemplateId());
        }
        if (lWhFormInventoryGoods.isset_goodsTemplateName) {
            this.setGoodsTemplateName(lWhFormInventoryGoods.getGoodsTemplateName());
        }
        if (lWhFormInventoryGoods.isset_unit) {
            this.setUnit(lWhFormInventoryGoods.getUnit());
        }
        if (lWhFormInventoryGoods.isset_baseGoodsModelsId) {
            this.setBaseGoodsModelsId(lWhFormInventoryGoods.getBaseGoodsModelsId());
        }
        if (lWhFormInventoryGoods.isset_baseGoodsModelsName) {
            this.setBaseGoodsModelsName(lWhFormInventoryGoods.getBaseGoodsModelsName());
        }
        if (lWhFormInventoryGoods.isset_price) {
            this.setPrice(lWhFormInventoryGoods.getPrice());
        }
        if (lWhFormInventoryGoods.isset_initCounts) {
            this.setInitCounts(lWhFormInventoryGoods.getInitCounts());
        }
        if (lWhFormInventoryGoods.isset_inventoryCounts) {
            this.setInventoryCounts(lWhFormInventoryGoods.getInventoryCounts());
        }
        if (lWhFormInventoryGoods.isset_errorCounts) {
            this.setErrorCounts(lWhFormInventoryGoods.getErrorCounts());
        }
        if (lWhFormInventoryGoods.isset_inventoryResult) {
            this.setInventoryResult(lWhFormInventoryGoods.getInventoryResult());
        }
        // 去掉，2022-09-07
        // this.setDatabaseName_(l_wh_form_inventory_goods.getDatabaseName_());
    }

    /**
     * 获取表名
     */
    @Override
    public String getTableName_() {
        String tableName = "l_wh_form_inventory_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(WhFormInventoryId, this.getWhFormInventoryId(), this.isset_whFormInventoryId);
        ib.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
        ib.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
        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(Price, this.getPrice(), this.isset_price);
        ib.set(InitCounts, this.getInitCounts(), this.isset_initCounts);
        ib.set(InventoryCounts, this.getInventoryCounts(), this.isset_inventoryCounts);
        ib.set(ErrorCounts, this.getErrorCounts(), this.isset_errorCounts);
        ib.set(InventoryResult, this.getInventoryResult(), this.isset_inventoryResult);
        return ib.genMapSql();
    }

    /**
     * 获取更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(WhFormInventoryId, this.getWhFormInventoryId(), this.isset_whFormInventoryId);
        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
        ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
        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(Price, this.getPrice(), this.isset_price);
        ub.set(InitCounts, this.getInitCounts(), this.isset_initCounts);
        ub.set(InventoryCounts, this.getInventoryCounts(), this.isset_inventoryCounts);
        ub.set(ErrorCounts, this.getErrorCounts(), this.isset_errorCounts);
        ub.set(InventoryResult, this.getInventoryResult(), this.isset_inventoryResult);
        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(WhFormInventoryId, this.getWhFormInventoryId(), this.isset_whFormInventoryId);
        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
        ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
        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(Price, this.getPrice(), this.isset_price);
        ub.set(InitCounts, this.getInitCounts(), this.isset_initCounts);
        ub.set(InventoryCounts, this.getInventoryCounts(), this.isset_inventoryCounts);
        ub.set(ErrorCounts, this.getErrorCounts(), this.isset_errorCounts);
        ub.set(InventoryResult, this.getInventoryResult(), this.isset_inventoryResult);
        return ub.genMapSql(where, parameters);
    }

    /**
     * 获取更新语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(WhFormInventoryId, this.getWhFormInventoryId(), this.isset_whFormInventoryId);
        ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId);
        ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName);
        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(Price, this.getPrice(), this.isset_price);
        ub.set(InitCounts, this.getInitCounts(), this.isset_initCounts);
        ub.set(InventoryCounts, this.getInventoryCounts(), this.isset_inventoryCounts);
        ub.set(ErrorCounts, this.getErrorCounts(), this.isset_errorCounts);
        ub.set(InventoryResult, this.getInventoryResult(), this.isset_inventoryResult);
        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, wh_form_inventory_id, base_goods_template_id, goods_template_name, unit, base_goods_models_id, base_goods_models_name, price, init_counts, inventory_counts, error_counts, inventory_result from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * 获取查询语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, wh_form_inventory_id, base_goods_template_id, goods_template_name, unit, base_goods_models_id, base_goods_models_name, price, init_counts, inventory_counts, error_counts, inventory_result from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * 将resultset的一行转化为po
     */
    @Override
    public LWhFormInventoryGoods mapRow(ResultSet rs, int i) throws SQLException {
        return ROW_MAPPER.mapRow(rs, i);
    }

    /**
     * 克隆
     */
    public LWhFormInventoryGoods toLWhFormInventoryGoods() {
        return super.$clone();
    }
}

/**
 * l_wh_form_inventory_goods RowMapper
 *
 * @author genrator
 */
class LWhFormInventoryGoodsRowMapper implements RowMapper<LWhFormInventoryGoods> {

    @Override
    public LWhFormInventoryGoods mapRow(ResultSet rs, int i) throws SQLException {
        ResultSetUtils resultSetUtils = new ResultSetUtils();
        LWhFormInventoryGoods l_wh_form_inventory_goods = new LWhFormInventoryGoods();
        Integer columnIndex;
        //主键
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventoryGoods_mapper.Id);
        if (columnIndex > 0) {
            l_wh_form_inventory_goods.setId(rs.getLong(columnIndex));
        }
        //普通属性
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventoryGoods_mapper.WhFormInventoryId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_inventory_goods.setWhFormInventoryId(null);
            } else {
                l_wh_form_inventory_goods.setWhFormInventoryId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventoryGoods_mapper.BaseGoodsTemplateId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_inventory_goods.setBaseGoodsTemplateId(null);
            } else {
                l_wh_form_inventory_goods.setBaseGoodsTemplateId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventoryGoods_mapper.GoodsTemplateName);
        if (columnIndex > 0) {
            l_wh_form_inventory_goods.setGoodsTemplateName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventoryGoods_mapper.Unit);
        if (columnIndex > 0) {
            l_wh_form_inventory_goods.setUnit(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventoryGoods_mapper.BaseGoodsModelsId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_inventory_goods.setBaseGoodsModelsId(null);
            } else {
                l_wh_form_inventory_goods.setBaseGoodsModelsId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventoryGoods_mapper.BaseGoodsModelsName);
        if (columnIndex > 0) {
            l_wh_form_inventory_goods.setBaseGoodsModelsName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventoryGoods_mapper.Price);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_inventory_goods.setPrice(null);
            } else {
                l_wh_form_inventory_goods.setPrice(rs.getDouble(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventoryGoods_mapper.InitCounts);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_inventory_goods.setInitCounts(null);
            } else {
                l_wh_form_inventory_goods.setInitCounts(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventoryGoods_mapper.InventoryCounts);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_inventory_goods.setInventoryCounts(null);
            } else {
                l_wh_form_inventory_goods.setInventoryCounts(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventoryGoods_mapper.ErrorCounts);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_inventory_goods.setErrorCounts(null);
            } else {
                l_wh_form_inventory_goods.setErrorCounts(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventoryGoods_mapper.InventoryResult);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_inventory_goods.setInventoryResult(null);
            } else {
                l_wh_form_inventory_goods.setInventoryResult(rs.getInt(columnIndex));
            }
        }
        return l_wh_form_inventory_goods;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory_mapper.java

New file
@@ -0,0 +1,465 @@
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 com.walker.jdbc.util.StringUtils;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Map;

/**
 * 表名:L_WH_FORM_INVENTORY *
 * @author genrator
 */
public class LWhFormInventory_mapper extends LWhFormInventory implements BaseMapper<LWhFormInventory> {
    // 序列化版本号
    private static final long serialVersionUID = 1L;

    public static final RowMapper<LWhFormInventory> ROW_MAPPER = new LWhFormInventoryRowMapper();

    // 主键
    public static final String Id = "id";
    // 普通属性
    public static final String BusinessFormCode = "business_form_code";
    public static final String BusinessFormName = "business_form_name";
    public static final String WarehouseType = "warehouse_type";
    public static final String WarehouseId = "warehouse_id";
    public static final String WarehouseName = "warehouse_name";
    public static final String OperatorId = "operator_id";
    public static final String OperatorName = "operator_name";
    public static final String States = "states";
    public static final String OperatorId2 = "operator_id2";
    public static final String OperatorName2 = "operator_name2";
    public static final String Beiz1 = "beiz1";
    public static final String AgencyId = "agency_id";
    public static final String AgencyName = "agency_name";
    public static final String CreatorId = "creator_id";
    public static final String CreatorName = "creator_name";
    public static final String InventoryDate = "inventory_date";
    public static final String CreateTime = "create_time";
    public static final String StopTime = "stop_time";

    /**
     * 默认构造函数
     */
    public LWhFormInventory_mapper(LWhFormInventory lWhFormInventory) {
        if (lWhFormInventory == null) {
            throw new IllegalArgumentException("po参数不允许为空！");
        }
        //主键
        if (lWhFormInventory.isset_id) {
            this.setId(lWhFormInventory.getId());
        }
        //普通属性
        if (lWhFormInventory.isset_businessFormCode) {
            this.setBusinessFormCode(lWhFormInventory.getBusinessFormCode());
        }
        if (lWhFormInventory.isset_businessFormName) {
            this.setBusinessFormName(lWhFormInventory.getBusinessFormName());
        }
        if (lWhFormInventory.isset_warehouseType) {
            this.setWarehouseType(lWhFormInventory.getWarehouseType());
        }
        if (lWhFormInventory.isset_warehouseId) {
            this.setWarehouseId(lWhFormInventory.getWarehouseId());
        }
        if (lWhFormInventory.isset_warehouseName) {
            this.setWarehouseName(lWhFormInventory.getWarehouseName());
        }
        if (lWhFormInventory.isset_operatorId) {
            this.setOperatorId(lWhFormInventory.getOperatorId());
        }
        if (lWhFormInventory.isset_operatorName) {
            this.setOperatorName(lWhFormInventory.getOperatorName());
        }
        if (lWhFormInventory.isset_states) {
            this.setStates(lWhFormInventory.getStates());
        }
        if (lWhFormInventory.isset_operatorId2) {
            this.setOperatorId2(lWhFormInventory.getOperatorId2());
        }
        if (lWhFormInventory.isset_operatorName2) {
            this.setOperatorName2(lWhFormInventory.getOperatorName2());
        }
        if (lWhFormInventory.isset_beiz1) {
            this.setBeiz1(lWhFormInventory.getBeiz1());
        }
        if (lWhFormInventory.isset_agencyId) {
            this.setAgencyId(lWhFormInventory.getAgencyId());
        }
        if (lWhFormInventory.isset_agencyName) {
            this.setAgencyName(lWhFormInventory.getAgencyName());
        }
        if (lWhFormInventory.isset_creatorId) {
            this.setCreatorId(lWhFormInventory.getCreatorId());
        }
        if (lWhFormInventory.isset_creatorName) {
            this.setCreatorName(lWhFormInventory.getCreatorName());
        }
        if (lWhFormInventory.isset_inventoryDate) {
            this.setInventoryDate(lWhFormInventory.getInventoryDate());
        }
        if (lWhFormInventory.isset_createTime) {
            this.setCreateTime(lWhFormInventory.getCreateTime());
        }
        if (lWhFormInventory.isset_stopTime) {
            this.setStopTime(lWhFormInventory.getStopTime());
        }
        // 去掉，2022-09-07
        // this.setDatabaseName_(l_wh_form_inventory.getDatabaseName_());
    }

    /**
     * 获取表名
     */
    @Override
    public String getTableName_() {
        String tableName = "l_wh_form_inventory";
        /**
        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(BusinessFormName, this.getBusinessFormName(), this.isset_businessFormName);
        ib.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
        ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ib.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
        ib.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
        ib.set(States, this.getStates(), this.isset_states);
        ib.set(OperatorId2, this.getOperatorId2(), this.isset_operatorId2);
        ib.set(OperatorName2, this.getOperatorName2(), this.isset_operatorName2);
        ib.set(Beiz1, this.getBeiz1(), this.isset_beiz1);
        ib.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
        ib.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
        ib.set(CreatorId, this.getCreatorId(), this.isset_creatorId);
        ib.set(CreatorName, this.getCreatorName(), this.isset_creatorName);
        ib.set(InventoryDate, this.getInventoryDate(), this.isset_inventoryDate);
        ib.set(CreateTime, this.getCreateTime(), this.isset_createTime);
        ib.set(StopTime, this.getStopTime(), this.isset_stopTime);
        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(BusinessFormName, this.getBusinessFormName(), this.isset_businessFormName);
        ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
        ub.set(States, this.getStates(), this.isset_states);
        ub.set(OperatorId2, this.getOperatorId2(), this.isset_operatorId2);
        ub.set(OperatorName2, this.getOperatorName2(), this.isset_operatorName2);
        ub.set(Beiz1, this.getBeiz1(), this.isset_beiz1);
        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
        ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
        ub.set(CreatorId, this.getCreatorId(), this.isset_creatorId);
        ub.set(CreatorName, this.getCreatorName(), this.isset_creatorName);
        ub.set(InventoryDate, this.getInventoryDate(), this.isset_inventoryDate);
        ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
        ub.set(StopTime, this.getStopTime(), this.isset_stopTime);
        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(BusinessFormName, this.getBusinessFormName(), this.isset_businessFormName);
        ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
        ub.set(States, this.getStates(), this.isset_states);
        ub.set(OperatorId2, this.getOperatorId2(), this.isset_operatorId2);
        ub.set(OperatorName2, this.getOperatorName2(), this.isset_operatorName2);
        ub.set(Beiz1, this.getBeiz1(), this.isset_beiz1);
        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
        ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
        ub.set(CreatorId, this.getCreatorId(), this.isset_creatorId);
        ub.set(CreatorName, this.getCreatorName(), this.isset_creatorName);
        ub.set(InventoryDate, this.getInventoryDate(), this.isset_inventoryDate);
        ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
        ub.set(StopTime, this.getStopTime(), this.isset_stopTime);
        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(BusinessFormName, this.getBusinessFormName(), this.isset_businessFormName);
        ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
        ub.set(States, this.getStates(), this.isset_states);
        ub.set(OperatorId2, this.getOperatorId2(), this.isset_operatorId2);
        ub.set(OperatorName2, this.getOperatorName2(), this.isset_operatorName2);
        ub.set(Beiz1, this.getBeiz1(), this.isset_beiz1);
        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
        ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
        ub.set(CreatorId, this.getCreatorId(), this.isset_creatorId);
        ub.set(CreatorName, this.getCreatorName(), this.isset_creatorName);
        ub.set(InventoryDate, this.getInventoryDate(), this.isset_inventoryDate);
        ub.set(CreateTime, this.getCreateTime(), this.isset_createTime);
        ub.set(StopTime, this.getStopTime(), this.isset_stopTime);
        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, business_form_name, warehouse_type, warehouse_id, warehouse_name, operator_id, operator_name, states, operator_id2, operator_name2, beiz1, agency_id, agency_name, creator_id, creator_name, inventory_date, create_time, stop_time from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * 获取查询语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, business_form_code, business_form_name, warehouse_type, warehouse_id, warehouse_name, operator_id, operator_name, states, operator_id2, operator_name2, beiz1, agency_id, agency_name, creator_id, creator_name, inventory_date, create_time, stop_time from " + this.getTableName_() + " " + where, parameters);
    }

    /**
     * 将resultset的一行转化为po
     */
    @Override
    public LWhFormInventory mapRow(ResultSet rs, int i) throws SQLException {
        return ROW_MAPPER.mapRow(rs, i);
    }

    /**
     * 克隆
     */
    public LWhFormInventory toLWhFormInventory() {
        return super.$clone();
    }
}

/**
 * l_wh_form_inventory RowMapper
 *
 * @author genrator
 */
class LWhFormInventoryRowMapper implements RowMapper<LWhFormInventory> {

    @Override
    public LWhFormInventory mapRow(ResultSet rs, int i) throws SQLException {
        ResultSetUtils resultSetUtils = new ResultSetUtils();
        LWhFormInventory l_wh_form_inventory = new LWhFormInventory();
        Integer columnIndex;
        //主键
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.Id);
        if (columnIndex > 0) {
            l_wh_form_inventory.setId(rs.getLong(columnIndex));
        }
        //普通属性
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.BusinessFormCode);
        if (columnIndex > 0) {
            l_wh_form_inventory.setBusinessFormCode(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.BusinessFormName);
        if (columnIndex > 0) {
            l_wh_form_inventory.setBusinessFormName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.WarehouseType);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_inventory.setWarehouseType(null);
            } else {
                l_wh_form_inventory.setWarehouseType(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.WarehouseId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_inventory.setWarehouseId(null);
            } else {
                l_wh_form_inventory.setWarehouseId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.WarehouseName);
        if (columnIndex > 0) {
            l_wh_form_inventory.setWarehouseName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.OperatorId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_inventory.setOperatorId(null);
            } else {
                l_wh_form_inventory.setOperatorId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.OperatorName);
        if (columnIndex > 0) {
            l_wh_form_inventory.setOperatorName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.States);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_inventory.setStates(null);
            } else {
                l_wh_form_inventory.setStates(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.OperatorId2);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_inventory.setOperatorId2(null);
            } else {
                l_wh_form_inventory.setOperatorId2(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.OperatorName2);
        if (columnIndex > 0) {
            l_wh_form_inventory.setOperatorName2(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.Beiz1);
        if (columnIndex > 0) {
            l_wh_form_inventory.setBeiz1(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.AgencyId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_inventory.setAgencyId(null);
            } else {
                l_wh_form_inventory.setAgencyId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.AgencyName);
        if (columnIndex > 0) {
            l_wh_form_inventory.setAgencyName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.CreatorId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_inventory.setCreatorId(null);
            } else {
                l_wh_form_inventory.setCreatorId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.CreatorName);
        if (columnIndex > 0) {
            l_wh_form_inventory.setCreatorName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.InventoryDate);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_inventory.setInventoryDate(null);
            } else {
                l_wh_form_inventory.setInventoryDate(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.CreateTime);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_inventory.setCreateTime(null);
            } else {
                l_wh_form_inventory.setCreateTime(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormInventory_mapper.StopTime);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_inventory.setStopTime(null);
            } else {
                l_wh_form_inventory.setStopTime(rs.getLong(columnIndex));
            }
        }
        return l_wh_form_inventory;
    }
}

 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormOutput.java

@@ -36,6 +36,10 @@
    @JsonIgnore
    protected boolean isset_transBusinessId = false;

    private Integer outWarehouseType = null;
    @JsonIgnore
    protected boolean isset_outWarehouseType = false;

    private String outputCode = null;
    @JsonIgnore
    protected boolean isset_outputCode = false;
@@ -51,6 +55,10 @@
    private String warehouseName = null;
    @JsonIgnore
    protected boolean isset_warehouseName = false;

    private Integer inWarehouseType = null;
    @JsonIgnore
    protected boolean isset_inWarehouseType = false;

    private Long inWarehouseId = null;
    @JsonIgnore
@@ -179,6 +187,20 @@
        return this.transBusinessId == null;
    }

    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 String getOutputCode() {
        return this.outputCode;
    }
@@ -233,6 +255,20 @@
    @JsonIgnore
    public boolean isEmptyWarehouseName() {
        return this.warehouseName == null || this.warehouseName.length() == 0;
    }

    public Integer getInWarehouseType() {
        return this.inWarehouseType;
    }

    public void setInWarehouseType(Integer inWarehouseType) {
        this.inWarehouseType = inWarehouseType;
        this.isset_inWarehouseType = true;
    }

    @JsonIgnore
    public boolean isEmptyInWarehouseType() {
        return this.inWarehouseType == null;
    }

    public Long getInWarehouseId() {
@@ -372,10 +408,12 @@
                .append("businessFormCode=").append(this.businessFormCode)
                .append("inWarehouseFlowId=").append(this.inWarehouseFlowId)
                .append("transBusinessId=").append(this.transBusinessId)
                .append("outWarehouseType=").append(this.outWarehouseType)
                .append("outputCode=").append(this.outputCode)
                .append("outputName=").append(this.outputName)
                .append("warehouseId=").append(this.warehouseId)
                .append("warehouseName=").append(this.warehouseName)
                .append("inWarehouseType=").append(this.inWarehouseType)
                .append("inWarehouseId=").append(this.inWarehouseId)
                .append("inWarehouseName=").append(this.inWarehouseName)
                .append("agencyId=").append(this.agencyId)
@@ -414,6 +452,9 @@
        if (this.isset_transBusinessId) {
            l_wh_form_output.setTransBusinessId(this.getTransBusinessId());
        }
        if (this.isset_outWarehouseType) {
            l_wh_form_output.setOutWarehouseType(this.getOutWarehouseType());
        }
        if (this.isset_outputCode) {
            l_wh_form_output.setOutputCode(this.getOutputCode());
        }
@@ -426,6 +467,9 @@
        if (this.isset_warehouseName) {
            l_wh_form_output.setWarehouseName(this.getWarehouseName());
        }
        if (this.isset_inWarehouseType) {
            l_wh_form_output.setInWarehouseType(this.getInWarehouseType());
        }
        if (this.isset_inWarehouseId) {
            l_wh_form_output.setInWarehouseId(this.getInWarehouseId());
        }

 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormOutput_mapper.java

@@ -7,6 +7,8 @@
import com.walker.jdbc.sqlgen.InsertBuilder;
import com.walker.jdbc.sqlgen.SelectBuilder;
import com.walker.jdbc.sqlgen.UpdateBuilder;
import com.walker.jdbc.util.StringUtils;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
@@ -30,10 +32,12 @@
    public static final String BusinessFormCode = "business_form_code";
    public static final String InWarehouseFlowId = "in_warehouse_flow_id";
    public static final String TransBusinessId = "trans_business_id";
    public static final String OutWarehouseType = "out_warehouse_type";
    public static final String OutputCode = "output_code";
    public static final String OutputName = "output_name";
    public static final String WarehouseId = "warehouse_id";
    public static final String WarehouseName = "warehouse_name";
    public static final String InWarehouseType = "in_warehouse_type";
    public static final String InWarehouseId = "in_warehouse_id";
    public static final String InWarehouseName = "in_warehouse_name";
    public static final String AgencyId = "agency_id";
@@ -68,6 +72,9 @@
        if (lWhFormOutput.isset_transBusinessId) {
            this.setTransBusinessId(lWhFormOutput.getTransBusinessId());
        }
        if (lWhFormOutput.isset_outWarehouseType) {
            this.setOutWarehouseType(lWhFormOutput.getOutWarehouseType());
        }
        if (lWhFormOutput.isset_outputCode) {
            this.setOutputCode(lWhFormOutput.getOutputCode());
        }
@@ -79,6 +86,9 @@
        }
        if (lWhFormOutput.isset_warehouseName) {
            this.setWarehouseName(lWhFormOutput.getWarehouseName());
        }
        if (lWhFormOutput.isset_inWarehouseType) {
            this.setInWarehouseType(lWhFormOutput.getInWarehouseType());
        }
        if (lWhFormOutput.isset_inWarehouseId) {
            this.setInWarehouseId(lWhFormOutput.getInWarehouseId());
@@ -154,10 +164,12 @@
        ib.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
        ib.set(InWarehouseFlowId, this.getInWarehouseFlowId(), this.isset_inWarehouseFlowId);
        ib.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
        ib.set(OutWarehouseType, this.getOutWarehouseType(), this.isset_outWarehouseType);
        ib.set(OutputCode, this.getOutputCode(), this.isset_outputCode);
        ib.set(OutputName, this.getOutputName(), this.isset_outputName);
        ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ib.set(InWarehouseType, this.getInWarehouseType(), this.isset_inWarehouseType);
        ib.set(InWarehouseId, this.getInWarehouseId(), this.isset_inWarehouseId);
        ib.set(InWarehouseName, this.getInWarehouseName(), this.isset_inWarehouseName);
        ib.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
@@ -180,10 +192,12 @@
        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
        ub.set(InWarehouseFlowId, this.getInWarehouseFlowId(), this.isset_inWarehouseFlowId);
        ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
        ub.set(OutWarehouseType, this.getOutWarehouseType(), this.isset_outWarehouseType);
        ub.set(OutputCode, this.getOutputCode(), this.isset_outputCode);
        ub.set(OutputName, this.getOutputName(), this.isset_outputName);
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(InWarehouseType, this.getInWarehouseType(), this.isset_inWarehouseType);
        ub.set(InWarehouseId, this.getInWarehouseId(), this.isset_inWarehouseId);
        ub.set(InWarehouseName, this.getInWarehouseName(), this.isset_inWarehouseName);
        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
@@ -207,10 +221,12 @@
        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
        ub.set(InWarehouseFlowId, this.getInWarehouseFlowId(), this.isset_inWarehouseFlowId);
        ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
        ub.set(OutWarehouseType, this.getOutWarehouseType(), this.isset_outWarehouseType);
        ub.set(OutputCode, this.getOutputCode(), this.isset_outputCode);
        ub.set(OutputName, this.getOutputName(), this.isset_outputName);
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(InWarehouseType, this.getInWarehouseType(), this.isset_inWarehouseType);
        ub.set(InWarehouseId, this.getInWarehouseId(), this.isset_inWarehouseId);
        ub.set(InWarehouseName, this.getInWarehouseName(), this.isset_inWarehouseName);
        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
@@ -233,10 +249,12 @@
        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
        ub.set(InWarehouseFlowId, this.getInWarehouseFlowId(), this.isset_inWarehouseFlowId);
        ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
        ub.set(OutWarehouseType, this.getOutWarehouseType(), this.isset_outWarehouseType);
        ub.set(OutputCode, this.getOutputCode(), this.isset_outputCode);
        ub.set(OutputName, this.getOutputName(), this.isset_outputName);
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(InWarehouseType, this.getInWarehouseType(), this.isset_inWarehouseType);
        ub.set(InWarehouseId, this.getInWarehouseId(), this.isset_inWarehouseId);
        ub.set(InWarehouseName, this.getInWarehouseName(), this.isset_inWarehouseName);
        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
@@ -293,7 +311,7 @@
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, warehouse_flow_id, business_form_code, in_warehouse_flow_id, trans_business_id, output_code, output_name, warehouse_id, warehouse_name, in_warehouse_id, in_warehouse_name, agency_id, agency_name, operator_id, operator_name, deal_time, states, beiz from " + this.getTableName_() + " " + where, parameters);
        return new SqlAndParameters<>("select id, warehouse_flow_id, business_form_code, in_warehouse_flow_id, trans_business_id, out_warehouse_type, output_code, output_name, warehouse_id, warehouse_name, in_warehouse_type, in_warehouse_id, in_warehouse_name, agency_id, agency_name, operator_id, operator_name, deal_time, states, beiz from " + this.getTableName_() + " " + where, parameters);
    }

    /**
@@ -301,7 +319,7 @@
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, warehouse_flow_id, business_form_code, in_warehouse_flow_id, trans_business_id, output_code, output_name, warehouse_id, warehouse_name, in_warehouse_id, in_warehouse_name, agency_id, agency_name, operator_id, operator_name, deal_time, states, beiz from " + this.getTableName_() + " " + where, parameters);
        return new SqlAndParameters<>("select id, warehouse_flow_id, business_form_code, in_warehouse_flow_id, trans_business_id, out_warehouse_type, output_code, output_name, warehouse_id, warehouse_name, in_warehouse_type, in_warehouse_id, in_warehouse_name, agency_id, agency_name, operator_id, operator_name, deal_time, states, beiz from " + this.getTableName_() + " " + where, parameters);
    }

    /**
@@ -366,6 +384,14 @@
                l_wh_form_output.setTransBusinessId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormOutput_mapper.OutWarehouseType);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_output.setOutWarehouseType(null);
            } else {
                l_wh_form_output.setOutWarehouseType(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormOutput_mapper.OutputCode);
        if (columnIndex > 0) {
            l_wh_form_output.setOutputCode(rs.getString(columnIndex));
@@ -386,6 +412,14 @@
        if (columnIndex > 0) {
            l_wh_form_output.setWarehouseName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormOutput_mapper.InWarehouseType);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_output.setInWarehouseType(null);
            } else {
                l_wh_form_output.setInWarehouseType(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormOutput_mapper.InWarehouseId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {

 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormTransfer.java

@@ -36,6 +36,10 @@
    @JsonIgnore
    protected boolean isset_businessFormCode = false;

    private Integer inWarehouseType = null;
    @JsonIgnore
    protected boolean isset_inWarehouseType = false;

    private Long inWarehouseId = null;
    @JsonIgnore
    protected boolean isset_inWarehouseId = false;
@@ -43,6 +47,10 @@
    private String inWarehouseName = null;
    @JsonIgnore
    protected boolean isset_inWarehouseName = false;

    private Integer outWarehouseType = null;
    @JsonIgnore
    protected boolean isset_outWarehouseType = false;

    private Long outWarehouseId = null;
    @JsonIgnore
@@ -215,6 +223,20 @@
        return this.businessFormCode == null || this.businessFormCode.length() == 0;
    }

    public Integer getInWarehouseType() {
        return this.inWarehouseType;
    }

    public void setInWarehouseType(Integer inWarehouseType) {
        this.inWarehouseType = inWarehouseType;
        this.isset_inWarehouseType = true;
    }

    @JsonIgnore
    public boolean isEmptyInWarehouseType() {
        return this.inWarehouseType == null;
    }

    public Long getInWarehouseId() {
        return this.inWarehouseId;
    }
@@ -241,6 +263,20 @@
    @JsonIgnore
    public boolean isEmptyInWarehouseName() {
        return this.inWarehouseName == null || this.inWarehouseName.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() {
@@ -534,8 +570,10 @@
                .append("outWarehouseFormId=").append(this.outWarehouseFormId)
                .append("businessType=").append(this.businessType)
                .append("businessFormCode=").append(this.businessFormCode)
                .append("inWarehouseType=").append(this.inWarehouseType)
                .append("inWarehouseId=").append(this.inWarehouseId)
                .append("inWarehouseName=").append(this.inWarehouseName)
                .append("outWarehouseType=").append(this.outWarehouseType)
                .append("outWarehouseId=").append(this.outWarehouseId)
                .append("outWarehouseName=").append(this.outWarehouseName)
                .append("inAgencyId=").append(this.inAgencyId)
@@ -585,12 +623,18 @@
        if (this.isset_businessFormCode) {
            l_wh_form_transfer.setBusinessFormCode(this.getBusinessFormCode());
        }
        if (this.isset_inWarehouseType) {
            l_wh_form_transfer.setInWarehouseType(this.getInWarehouseType());
        }
        if (this.isset_inWarehouseId) {
            l_wh_form_transfer.setInWarehouseId(this.getInWarehouseId());
        }
        if (this.isset_inWarehouseName) {
            l_wh_form_transfer.setInWarehouseName(this.getInWarehouseName());
        }
        if (this.isset_outWarehouseType) {
            l_wh_form_transfer.setOutWarehouseType(this.getOutWarehouseType());
        }
        if (this.isset_outWarehouseId) {
            l_wh_form_transfer.setOutWarehouseId(this.getOutWarehouseId());
        }

 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormTransfer_mapper.java

@@ -7,6 +7,8 @@
import com.walker.jdbc.sqlgen.InsertBuilder;
import com.walker.jdbc.sqlgen.SelectBuilder;
import com.walker.jdbc.sqlgen.UpdateBuilder;
import com.walker.jdbc.util.StringUtils;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
@@ -30,8 +32,10 @@
    public static final String OutWarehouseFormId = "out_warehouse_form_id";
    public static final String BusinessType = "business_type";
    public static final String BusinessFormCode = "business_form_code";
    public static final String InWarehouseType = "in_warehouse_type";
    public static final String InWarehouseId = "in_warehouse_id";
    public static final String InWarehouseName = "in_warehouse_name";
    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 InAgencyId = "in_agency_id";
@@ -77,11 +81,17 @@
        if (lWhFormTransfer.isset_businessFormCode) {
            this.setBusinessFormCode(lWhFormTransfer.getBusinessFormCode());
        }
        if (lWhFormTransfer.isset_inWarehouseType) {
            this.setInWarehouseType(lWhFormTransfer.getInWarehouseType());
        }
        if (lWhFormTransfer.isset_inWarehouseId) {
            this.setInWarehouseId(lWhFormTransfer.getInWarehouseId());
        }
        if (lWhFormTransfer.isset_inWarehouseName) {
            this.setInWarehouseName(lWhFormTransfer.getInWarehouseName());
        }
        if (lWhFormTransfer.isset_outWarehouseType) {
            this.setOutWarehouseType(lWhFormTransfer.getOutWarehouseType());
        }
        if (lWhFormTransfer.isset_outWarehouseId) {
            this.setOutWarehouseId(lWhFormTransfer.getOutWarehouseId());
@@ -190,8 +200,10 @@
        ib.set(OutWarehouseFormId, this.getOutWarehouseFormId(), this.isset_outWarehouseFormId);
        ib.set(BusinessType, this.getBusinessType(), this.isset_businessType);
        ib.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
        ib.set(InWarehouseType, this.getInWarehouseType(), this.isset_inWarehouseType);
        ib.set(InWarehouseId, this.getInWarehouseId(), this.isset_inWarehouseId);
        ib.set(InWarehouseName, this.getInWarehouseName(), this.isset_inWarehouseName);
        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(InAgencyId, this.getInAgencyId(), this.isset_inAgencyId);
@@ -225,8 +237,10 @@
        ub.set(OutWarehouseFormId, this.getOutWarehouseFormId(), this.isset_outWarehouseFormId);
        ub.set(BusinessType, this.getBusinessType(), this.isset_businessType);
        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
        ub.set(InWarehouseType, this.getInWarehouseType(), this.isset_inWarehouseType);
        ub.set(InWarehouseId, this.getInWarehouseId(), this.isset_inWarehouseId);
        ub.set(InWarehouseName, this.getInWarehouseName(), this.isset_inWarehouseName);
        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(InAgencyId, this.getInAgencyId(), this.isset_inAgencyId);
@@ -261,8 +275,10 @@
        ub.set(OutWarehouseFormId, this.getOutWarehouseFormId(), this.isset_outWarehouseFormId);
        ub.set(BusinessType, this.getBusinessType(), this.isset_businessType);
        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
        ub.set(InWarehouseType, this.getInWarehouseType(), this.isset_inWarehouseType);
        ub.set(InWarehouseId, this.getInWarehouseId(), this.isset_inWarehouseId);
        ub.set(InWarehouseName, this.getInWarehouseName(), this.isset_inWarehouseName);
        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(InAgencyId, this.getInAgencyId(), this.isset_inAgencyId);
@@ -296,8 +312,10 @@
        ub.set(OutWarehouseFormId, this.getOutWarehouseFormId(), this.isset_outWarehouseFormId);
        ub.set(BusinessType, this.getBusinessType(), this.isset_businessType);
        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
        ub.set(InWarehouseType, this.getInWarehouseType(), this.isset_inWarehouseType);
        ub.set(InWarehouseId, this.getInWarehouseId(), this.isset_inWarehouseId);
        ub.set(InWarehouseName, this.getInWarehouseName(), this.isset_inWarehouseName);
        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(InAgencyId, this.getInAgencyId(), this.isset_inAgencyId);
@@ -365,7 +383,7 @@
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, in_warehouse_form_id, out_warehouse_form_id, business_type, business_form_code, in_warehouse_id, in_warehouse_name, out_warehouse_id, out_warehouse_name, in_agency_id, in_agency_name, out_agency_id, out_agency_name, operator_id, operator_name, create_time, states, in_operator_id, in_operator_name, in_time, out_operator_id, out_operator_name, output_time, beiz1, beiz2, beiz3, procure_doc from " + this.getTableName_() + " " + where, parameters);
        return new SqlAndParameters<>("select id, in_warehouse_form_id, out_warehouse_form_id, business_type, business_form_code, in_warehouse_type, in_warehouse_id, in_warehouse_name, out_warehouse_type, out_warehouse_id, out_warehouse_name, in_agency_id, in_agency_name, out_agency_id, out_agency_name, operator_id, operator_name, create_time, states, in_operator_id, in_operator_name, in_time, out_operator_id, out_operator_name, output_time, beiz1, beiz2, beiz3, procure_doc from " + this.getTableName_() + " " + where, parameters);
    }

    /**
@@ -373,7 +391,7 @@
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, in_warehouse_form_id, out_warehouse_form_id, business_type, business_form_code, in_warehouse_id, in_warehouse_name, out_warehouse_id, out_warehouse_name, in_agency_id, in_agency_name, out_agency_id, out_agency_name, operator_id, operator_name, create_time, states, in_operator_id, in_operator_name, in_time, out_operator_id, out_operator_name, output_time, beiz1, beiz2, beiz3, procure_doc from " + this.getTableName_() + " " + where, parameters);
        return new SqlAndParameters<>("select id, in_warehouse_form_id, out_warehouse_form_id, business_type, business_form_code, in_warehouse_type, in_warehouse_id, in_warehouse_name, out_warehouse_type, out_warehouse_id, out_warehouse_name, in_agency_id, in_agency_name, out_agency_id, out_agency_name, operator_id, operator_name, create_time, states, in_operator_id, in_operator_name, in_time, out_operator_id, out_operator_name, output_time, beiz1, beiz2, beiz3, procure_doc from " + this.getTableName_() + " " + where, parameters);
    }

    /**
@@ -438,6 +456,14 @@
        if (columnIndex > 0) {
            l_wh_form_transfer.setBusinessFormCode(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.InWarehouseType);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_transfer.setInWarehouseType(null);
            } else {
                l_wh_form_transfer.setInWarehouseType(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.InWarehouseId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
@@ -450,6 +476,14 @@
        if (columnIndex > 0) {
            l_wh_form_transfer.setInWarehouseName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.OutWarehouseType);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_transfer.setOutWarehouseType(null);
            } else {
                l_wh_form_transfer.setOutWarehouseType(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormTransfer_mapper.OutWarehouseId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {