luqingyang
2023-10-31 ddaf74466d92dffb9ba8242a071f151f9a7e0e41
Merge remote-tracking branch 'origin/master'

# Conflicts:
# consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory_mapper.java
4个文件已添加
7个文件已修改
1688 ■■■■■ 已修改文件
consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord.java 22 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java 20 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow.java 22 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow_mapper.java 20 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory_mapper.java 2 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped.java 392 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods.java 370 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods_mapper.java 389 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped_mapper.java 409 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods.java 22 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java 20 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord.java
@@ -28,6 +28,10 @@
    @JsonIgnore
    protected boolean isset_whGoodsId = false;
    private Integer warehouseType = null;
    @JsonIgnore
    protected boolean isset_warehouseType = false;
    private Long warehouseId = null;
    @JsonIgnore
    protected boolean isset_warehouseId = false;
@@ -99,6 +103,20 @@
        return this.whGoodsId == null;
    }
    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;
    }
@@ -136,6 +154,7 @@
                .append("id=").append(this.id)
                .append("warehouseFlowId=").append(this.warehouseFlowId)
                .append("whGoodsId=").append(this.whGoodsId)
                .append("warehouseType=").append(this.warehouseType)
                .append("warehouseId=").append(this.warehouseId)
                .append("dealTime=").append(this.dealTime)
                .toString();
@@ -161,6 +180,9 @@
        if (this.isset_whGoodsId) {
            l_goods_wh_record.setWhGoodsId(this.getWhGoodsId());
        }
        if (this.isset_warehouseType) {
            l_goods_wh_record.setWarehouseType(this.getWarehouseType());
        }
        if (this.isset_warehouseId) {
            l_goods_wh_record.setWarehouseId(this.getWarehouseId());
        }
consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java
@@ -30,6 +30,7 @@
    // 普通属性
    public static final String WarehouseFlowId = "warehouse_flow_id";
    public static final String WhGoodsId = "wh_goods_id";
    public static final String WarehouseType = "warehouse_type";
    public static final String WarehouseId = "warehouse_id";
    public static final String DealTime = "deal_time";
@@ -50,6 +51,9 @@
        }
        if (lGoodsWhRecord.isset_whGoodsId) {
            this.setWhGoodsId(lGoodsWhRecord.getWhGoodsId());
        }
        if (lGoodsWhRecord.isset_warehouseType) {
            this.setWarehouseType(lGoodsWhRecord.getWarehouseType());
        }
        if (lGoodsWhRecord.isset_warehouseId) {
            this.setWarehouseId(lGoodsWhRecord.getWarehouseId());
@@ -102,6 +106,7 @@
        ib.set(Id, this.getId());
        ib.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId);
        ib.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId);
        ib.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
        ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ib.set(DealTime, this.getDealTime(), this.isset_dealTime);
        return ib.genMapSql();
@@ -115,6 +120,7 @@
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId);
        ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId);
        ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
        ub.where(this.getPkName_(), this.getPkValue_());
@@ -129,6 +135,7 @@
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId);
        ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId);
        ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
        return ub.genMapSql(where, parameters);
@@ -142,6 +149,7 @@
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId);
        ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId);
        ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
        return ub.genArraySql(where, parameters);
@@ -191,7 +199,7 @@
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, warehouse_flow_id, wh_goods_id, warehouse_id, deal_time from " + this.getTableName_() + " " + where, parameters);
        return new SqlAndParameters<>("select id, warehouse_flow_id, wh_goods_id, warehouse_type, warehouse_id, deal_time from " + this.getTableName_() + " " + where, parameters);
    }
    /**
@@ -199,7 +207,7 @@
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, warehouse_flow_id, wh_goods_id, warehouse_id, deal_time from " + this.getTableName_() + " " + where, parameters);
        return new SqlAndParameters<>("select id, warehouse_flow_id, wh_goods_id, warehouse_type, warehouse_id, deal_time from " + this.getTableName_() + " " + where, parameters);
    }
    /**
@@ -252,6 +260,14 @@
                l_goods_wh_record.setWhGoodsId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.WarehouseType);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_goods_wh_record.setWarehouseType(null);
            } else {
                l_goods_wh_record.setWarehouseType(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.WarehouseId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow.java
@@ -20,6 +20,10 @@
    protected boolean isset_id = false;
    // 属性列表
    private Integer warehouseType = null;
    @JsonIgnore
    protected boolean isset_warehouseType = false;
    private Long warehouseId = null;
    @JsonIgnore
    protected boolean isset_warehouseId = false;
@@ -85,6 +89,20 @@
    @JsonIgnore
    public boolean isEmptyId() {
        return this.id == null;
    }
    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() {
@@ -206,6 +224,7 @@
    public String toString() {
        return new StringBuilder()
                .append("id=").append(this.id)
                .append("warehouseType=").append(this.warehouseType)
                .append("warehouseId=").append(this.warehouseId)
                .append("warehouseName=").append(this.warehouseName)
                .append("thisType=").append(this.thisType)
@@ -231,6 +250,9 @@
            l_warehouse_flow.setId(this.getId());
        }
        // 普通属性
        if (this.isset_warehouseType) {
            l_warehouse_flow.setWarehouseType(this.getWarehouseType());
        }
        if (this.isset_warehouseId) {
            l_warehouse_flow.setWarehouseId(this.getWarehouseId());
        }
consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow_mapper.java
@@ -28,6 +28,7 @@
    // 主键
    public static final String Id = "id";
    // 普通属性
    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 ThisType = "this_type";
@@ -49,6 +50,9 @@
            this.setId(lWarehouseFlow.getId());
        }
        //普通属性
        if (lWarehouseFlow.isset_warehouseType) {
            this.setWarehouseType(lWarehouseFlow.getWarehouseType());
        }
        if (lWarehouseFlow.isset_warehouseId) {
            this.setWarehouseId(lWarehouseFlow.getWarehouseId());
        }
@@ -116,6 +120,7 @@
    public SqlAndParameters<Map<String, Object>> getInsertSql_() {
        InsertBuilder ib = new InsertBuilder(this.getTableName_());
        ib.set(Id, this.getId());
        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(ThisType, this.getThisType(), this.isset_thisType);
@@ -133,6 +138,7 @@
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        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(ThisType, this.getThisType(), this.isset_thisType);
@@ -151,6 +157,7 @@
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        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(ThisType, this.getThisType(), this.isset_thisType);
@@ -168,6 +175,7 @@
    @Override
    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        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(ThisType, this.getThisType(), this.isset_thisType);
@@ -223,7 +231,7 @@
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, warehouse_id, warehouse_name, this_type, business_type, business_form_id, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters);
        return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_name, this_type, business_type, business_form_id, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters);
    }
    /**
@@ -231,7 +239,7 @@
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, warehouse_id, warehouse_name, this_type, business_type, business_form_id, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters);
        return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_name, this_type, business_type, business_form_id, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters);
    }
    /**
@@ -268,6 +276,14 @@
            l_warehouse_flow.setId(rs.getLong(columnIndex));
        }
        //普通属性
        columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.WarehouseType);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_warehouse_flow.setWarehouseType(null);
            } else {
                l_warehouse_flow.setWarehouseType(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.WarehouseId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory_mapper.java
@@ -7,8 +7,6 @@
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;
consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped.java
New file
@@ -0,0 +1,392 @@
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_SCRAPPED *
 * @author genrator
 */
@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
public class LWhFormScrapped extends BasePo<LWhFormScrapped> {
    // 序列化版本号
    private static final long serialVersionUID = 1L;
    // 主键
    private Long id = null;
    @JsonIgnore
    protected boolean isset_id = false;
    // 属性列表
    private Long lWarehouseFlowId = null;
    @JsonIgnore
    protected boolean isset_lWarehouseFlowId = false;
    private String businessFormCode = null;
    @JsonIgnore
    protected boolean isset_businessFormCode = false;
    private Long warehouseId = null;
    @JsonIgnore
    protected boolean isset_warehouseId = false;
    private String warehouseName = null;
    @JsonIgnore
    protected boolean isset_warehouseName = false;
    private Integer scrappedType = null;
    @JsonIgnore
    protected boolean isset_scrappedType = false;
    private Long agencyId = null;
    @JsonIgnore
    protected boolean isset_agencyId = false;
    private String agencyName = null;
    @JsonIgnore
    protected boolean isset_agencyName = false;
    private Long operatorId = null;
    @JsonIgnore
    protected boolean isset_operatorId = false;
    private String operatorName = null;
    @JsonIgnore
    protected boolean isset_operatorName = false;
    private Long dealTime = null;
    @JsonIgnore
    protected boolean isset_dealTime = false;
    private String departmentId = null;
    @JsonIgnore
    protected boolean isset_departmentId = false;
    private Long departmentName = null;
    @JsonIgnore
    protected boolean isset_departmentName = false;
    private String uploadFiles = null;
    @JsonIgnore
    protected boolean isset_uploadFiles = false;
    private Integer states = null;
    @JsonIgnore
    protected boolean isset_states = false;
    /**
     * 默认构造函数
     */
    public LWhFormScrapped() {
    }
    /**
     * 根据主键构造对象
     */
    public LWhFormScrapped(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 getLWarehouseFlowId() {
        return this.lWarehouseFlowId;
    }
    public void setLWarehouseFlowId(Long lWarehouseFlowId) {
        this.lWarehouseFlowId = lWarehouseFlowId;
        this.isset_lWarehouseFlowId = true;
    }
    @JsonIgnore
    public boolean isEmptyLWarehouseFlowId() {
        return this.lWarehouseFlowId == 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 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 Integer getScrappedType() {
        return this.scrappedType;
    }
    public void setScrappedType(Integer scrappedType) {
        this.scrappedType = scrappedType;
        this.isset_scrappedType = true;
    }
    @JsonIgnore
    public boolean isEmptyScrappedType() {
        return this.scrappedType == null;
    }
    public Long getAgencyId() {
        return this.agencyId;
    }
    public void setAgencyId(Long agencyId) {
        this.agencyId = agencyId;
        this.isset_agencyId = true;
    }
    @JsonIgnore
    public boolean isEmptyAgencyId() {
        return this.agencyId == null;
    }
    public String getAgencyName() {
        return this.agencyName;
    }
    public void setAgencyName(String agencyName) {
        this.agencyName = agencyName;
        this.isset_agencyName = true;
    }
    @JsonIgnore
    public boolean isEmptyAgencyName() {
        return this.agencyName == null || this.agencyName.length() == 0;
    }
    public Long getOperatorId() {
        return this.operatorId;
    }
    public void setOperatorId(Long operatorId) {
        this.operatorId = operatorId;
        this.isset_operatorId = true;
    }
    @JsonIgnore
    public boolean isEmptyOperatorId() {
        return this.operatorId == null;
    }
    public String getOperatorName() {
        return this.operatorName;
    }
    public void setOperatorName(String operatorName) {
        this.operatorName = operatorName;
        this.isset_operatorName = true;
    }
    @JsonIgnore
    public boolean isEmptyOperatorName() {
        return this.operatorName == null || this.operatorName.length() == 0;
    }
    public Long getDealTime() {
        return this.dealTime;
    }
    public void setDealTime(Long dealTime) {
        this.dealTime = dealTime;
        this.isset_dealTime = true;
    }
    @JsonIgnore
    public boolean isEmptyDealTime() {
        return this.dealTime == null;
    }
    public String getDepartmentId() {
        return this.departmentId;
    }
    public void setDepartmentId(String departmentId) {
        this.departmentId = departmentId;
        this.isset_departmentId = true;
    }
    @JsonIgnore
    public boolean isEmptyDepartmentId() {
        return this.departmentId == null || this.departmentId.length() == 0;
    }
    public Long getDepartmentName() {
        return this.departmentName;
    }
    public void setDepartmentName(Long departmentName) {
        this.departmentName = departmentName;
        this.isset_departmentName = true;
    }
    @JsonIgnore
    public boolean isEmptyDepartmentName() {
        return this.departmentName == null;
    }
    public String getUploadFiles() {
        return this.uploadFiles;
    }
    public void setUploadFiles(String uploadFiles) {
        this.uploadFiles = uploadFiles;
        this.isset_uploadFiles = true;
    }
    @JsonIgnore
    public boolean isEmptyUploadFiles() {
        return this.uploadFiles == null || this.uploadFiles.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;
    }
    /**
     * 重写 toString() 方法
     */
    @Override
    public String toString() {
        return new StringBuilder()
                .append("id=").append(this.id)
                .append("lWarehouseFlowId=").append(this.lWarehouseFlowId)
                .append("businessFormCode=").append(this.businessFormCode)
                .append("warehouseId=").append(this.warehouseId)
                .append("warehouseName=").append(this.warehouseName)
                .append("scrappedType=").append(this.scrappedType)
                .append("agencyId=").append(this.agencyId)
                .append("agencyName=").append(this.agencyName)
                .append("operatorId=").append(this.operatorId)
                .append("operatorName=").append(this.operatorName)
                .append("dealTime=").append(this.dealTime)
                .append("departmentId=").append(this.departmentId)
                .append("departmentName=").append(this.departmentName)
                .append("uploadFiles=").append(this.uploadFiles)
                .append("states=").append(this.states)
                .toString();
    }
    /**
     * 克隆
     */
    public LWhFormScrapped $clone() {
        LWhFormScrapped l_wh_form_scrapped = new LWhFormScrapped();
        // 数据库名称
        //l_wh_form_scrapped.setDatabaseName_(this.getDatabaseName_());
        // 主键
        if (this.isset_id) {
            l_wh_form_scrapped.setId(this.getId());
        }
        // 普通属性
        if (this.isset_lWarehouseFlowId) {
            l_wh_form_scrapped.setLWarehouseFlowId(this.getLWarehouseFlowId());
        }
        if (this.isset_businessFormCode) {
            l_wh_form_scrapped.setBusinessFormCode(this.getBusinessFormCode());
        }
        if (this.isset_warehouseId) {
            l_wh_form_scrapped.setWarehouseId(this.getWarehouseId());
        }
        if (this.isset_warehouseName) {
            l_wh_form_scrapped.setWarehouseName(this.getWarehouseName());
        }
        if (this.isset_scrappedType) {
            l_wh_form_scrapped.setScrappedType(this.getScrappedType());
        }
        if (this.isset_agencyId) {
            l_wh_form_scrapped.setAgencyId(this.getAgencyId());
        }
        if (this.isset_agencyName) {
            l_wh_form_scrapped.setAgencyName(this.getAgencyName());
        }
        if (this.isset_operatorId) {
            l_wh_form_scrapped.setOperatorId(this.getOperatorId());
        }
        if (this.isset_operatorName) {
            l_wh_form_scrapped.setOperatorName(this.getOperatorName());
        }
        if (this.isset_dealTime) {
            l_wh_form_scrapped.setDealTime(this.getDealTime());
        }
        if (this.isset_departmentId) {
            l_wh_form_scrapped.setDepartmentId(this.getDepartmentId());
        }
        if (this.isset_departmentName) {
            l_wh_form_scrapped.setDepartmentName(this.getDepartmentName());
        }
        if (this.isset_uploadFiles) {
            l_wh_form_scrapped.setUploadFiles(this.getUploadFiles());
        }
        if (this.isset_states) {
            l_wh_form_scrapped.setStates(this.getStates());
        }
        return l_wh_form_scrapped;
    }
}
consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods.java
New file
@@ -0,0 +1,370 @@
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_SCRAPPED_GOODS *
 * @author genrator
 */
@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
public class LWhFormScrappedGoods extends BasePo<LWhFormScrappedGoods> {
    // 序列化版本号
    private static final long serialVersionUID = 1L;
    // 主键
    private Long id = null;
    @JsonIgnore
    protected boolean isset_id = false;
    // 属性列表
    private Integer counts = null;
    @JsonIgnore
    protected boolean isset_counts = false;
    private String scrappedCode = null;
    @JsonIgnore
    protected boolean isset_scrappedCode = false;
    private String scrappedName = null;
    @JsonIgnore
    protected boolean isset_scrappedName = false;
    private String beiz = null;
    @JsonIgnore
    protected boolean isset_beiz = false;
    private Long formScrappedId = null;
    @JsonIgnore
    protected boolean isset_formScrappedId = 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 Long transBusinessId = null;
    @JsonIgnore
    protected boolean isset_transBusinessId = false;
    private String userName = null;
    @JsonIgnore
    protected boolean isset_userName = false;
    private Long sort = null;
    @JsonIgnore
    protected boolean isset_sort = false;
    /**
     * 默认构造函数
     */
    public LWhFormScrappedGoods() {
    }
    /**
     * 根据主键构造对象
     */
    public LWhFormScrappedGoods(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 Integer getCounts() {
        return this.counts;
    }
    public void setCounts(Integer counts) {
        this.counts = counts;
        this.isset_counts = true;
    }
    @JsonIgnore
    public boolean isEmptyCounts() {
        return this.counts == null;
    }
    public String getScrappedCode() {
        return this.scrappedCode;
    }
    public void setScrappedCode(String scrappedCode) {
        this.scrappedCode = scrappedCode;
        this.isset_scrappedCode = true;
    }
    @JsonIgnore
    public boolean isEmptyScrappedCode() {
        return this.scrappedCode == null || this.scrappedCode.length() == 0;
    }
    public String getScrappedName() {
        return this.scrappedName;
    }
    public void setScrappedName(String scrappedName) {
        this.scrappedName = scrappedName;
        this.isset_scrappedName = true;
    }
    @JsonIgnore
    public boolean isEmptyScrappedName() {
        return this.scrappedName == null || this.scrappedName.length() == 0;
    }
    public String getBeiz() {
        return this.beiz;
    }
    public void setBeiz(String beiz) {
        this.beiz = beiz;
        this.isset_beiz = true;
    }
    @JsonIgnore
    public boolean isEmptyBeiz() {
        return this.beiz == null || this.beiz.length() == 0;
    }
    public Long getFormScrappedId() {
        return this.formScrappedId;
    }
    public void setFormScrappedId(Long formScrappedId) {
        this.formScrappedId = formScrappedId;
        this.isset_formScrappedId = true;
    }
    @JsonIgnore
    public boolean isEmptyFormScrappedId() {
        return this.formScrappedId == 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 Long getTransBusinessId() {
        return this.transBusinessId;
    }
    public void setTransBusinessId(Long transBusinessId) {
        this.transBusinessId = transBusinessId;
        this.isset_transBusinessId = true;
    }
    @JsonIgnore
    public boolean isEmptyTransBusinessId() {
        return this.transBusinessId == null;
    }
    public String getUserName() {
        return this.userName;
    }
    public void setUserName(String userName) {
        this.userName = userName;
        this.isset_userName = true;
    }
    @JsonIgnore
    public boolean isEmptyUserName() {
        return this.userName == null || this.userName.length() == 0;
    }
    public Long getSort() {
        return this.sort;
    }
    public void setSort(Long sort) {
        this.sort = sort;
        this.isset_sort = true;
    }
    @JsonIgnore
    public boolean isEmptySort() {
        return this.sort == null;
    }
    /**
     * 重写 toString() 方法
     */
    @Override
    public String toString() {
        return new StringBuilder()
                .append("id=").append(this.id)
                .append("counts=").append(this.counts)
                .append("scrappedCode=").append(this.scrappedCode)
                .append("scrappedName=").append(this.scrappedName)
                .append("beiz=").append(this.beiz)
                .append("formScrappedId=").append(this.formScrappedId)
                .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("transBusinessId=").append(this.transBusinessId)
                .append("userName=").append(this.userName)
                .append("sort=").append(this.sort)
                .toString();
    }
    /**
     * 克隆
     */
    public LWhFormScrappedGoods $clone() {
        LWhFormScrappedGoods l_wh_form_scrapped_goods = new LWhFormScrappedGoods();
        // 数据库名称
        //l_wh_form_scrapped_goods.setDatabaseName_(this.getDatabaseName_());
        // 主键
        if (this.isset_id) {
            l_wh_form_scrapped_goods.setId(this.getId());
        }
        // 普通属性
        if (this.isset_counts) {
            l_wh_form_scrapped_goods.setCounts(this.getCounts());
        }
        if (this.isset_scrappedCode) {
            l_wh_form_scrapped_goods.setScrappedCode(this.getScrappedCode());
        }
        if (this.isset_scrappedName) {
            l_wh_form_scrapped_goods.setScrappedName(this.getScrappedName());
        }
        if (this.isset_beiz) {
            l_wh_form_scrapped_goods.setBeiz(this.getBeiz());
        }
        if (this.isset_formScrappedId) {
            l_wh_form_scrapped_goods.setFormScrappedId(this.getFormScrappedId());
        }
        if (this.isset_baseGoodsTemplateId) {
            l_wh_form_scrapped_goods.setBaseGoodsTemplateId(this.getBaseGoodsTemplateId());
        }
        if (this.isset_goodsTemplateName) {
            l_wh_form_scrapped_goods.setGoodsTemplateName(this.getGoodsTemplateName());
        }
        if (this.isset_unit) {
            l_wh_form_scrapped_goods.setUnit(this.getUnit());
        }
        if (this.isset_baseGoodsModelsId) {
            l_wh_form_scrapped_goods.setBaseGoodsModelsId(this.getBaseGoodsModelsId());
        }
        if (this.isset_baseGoodsModelsName) {
            l_wh_form_scrapped_goods.setBaseGoodsModelsName(this.getBaseGoodsModelsName());
        }
        if (this.isset_transBusinessId) {
            l_wh_form_scrapped_goods.setTransBusinessId(this.getTransBusinessId());
        }
        if (this.isset_userName) {
            l_wh_form_scrapped_goods.setUserName(this.getUserName());
        }
        if (this.isset_sort) {
            l_wh_form_scrapped_goods.setSort(this.getSort());
        }
        return l_wh_form_scrapped_goods;
    }
}
consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods_mapper.java
New file
@@ -0,0 +1,389 @@
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_SCRAPPED_GOODS *
 * @author genrator
 */
public class LWhFormScrappedGoods_mapper extends LWhFormScrappedGoods implements BaseMapper<LWhFormScrappedGoods> {
    // 序列化版本号
    private static final long serialVersionUID = 1L;
    public static final RowMapper<LWhFormScrappedGoods> ROW_MAPPER = new LWhFormScrappedGoodsRowMapper();
    // 主键
    public static final String Id = "id";
    // 普通属性
    public static final String Counts = "counts";
    public static final String ScrappedCode = "scrapped_code";
    public static final String ScrappedName = "scrapped_name";
    public static final String Beiz = "beiz";
    public static final String FormScrappedId = "form_scrapped_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 TransBusinessId = "trans_business_id";
    public static final String UserName = "user_name";
    public static final String Sort = "sort";
    /**
     * 默认构造函数
     */
    public LWhFormScrappedGoods_mapper(LWhFormScrappedGoods lWhFormScrappedGoods) {
        if (lWhFormScrappedGoods == null) {
            throw new IllegalArgumentException("po参数不允许为空!");
        }
        //主键
        if (lWhFormScrappedGoods.isset_id) {
            this.setId(lWhFormScrappedGoods.getId());
        }
        //普通属性
        if (lWhFormScrappedGoods.isset_counts) {
            this.setCounts(lWhFormScrappedGoods.getCounts());
        }
        if (lWhFormScrappedGoods.isset_scrappedCode) {
            this.setScrappedCode(lWhFormScrappedGoods.getScrappedCode());
        }
        if (lWhFormScrappedGoods.isset_scrappedName) {
            this.setScrappedName(lWhFormScrappedGoods.getScrappedName());
        }
        if (lWhFormScrappedGoods.isset_beiz) {
            this.setBeiz(lWhFormScrappedGoods.getBeiz());
        }
        if (lWhFormScrappedGoods.isset_formScrappedId) {
            this.setFormScrappedId(lWhFormScrappedGoods.getFormScrappedId());
        }
        if (lWhFormScrappedGoods.isset_baseGoodsTemplateId) {
            this.setBaseGoodsTemplateId(lWhFormScrappedGoods.getBaseGoodsTemplateId());
        }
        if (lWhFormScrappedGoods.isset_goodsTemplateName) {
            this.setGoodsTemplateName(lWhFormScrappedGoods.getGoodsTemplateName());
        }
        if (lWhFormScrappedGoods.isset_unit) {
            this.setUnit(lWhFormScrappedGoods.getUnit());
        }
        if (lWhFormScrappedGoods.isset_baseGoodsModelsId) {
            this.setBaseGoodsModelsId(lWhFormScrappedGoods.getBaseGoodsModelsId());
        }
        if (lWhFormScrappedGoods.isset_baseGoodsModelsName) {
            this.setBaseGoodsModelsName(lWhFormScrappedGoods.getBaseGoodsModelsName());
        }
        if (lWhFormScrappedGoods.isset_transBusinessId) {
            this.setTransBusinessId(lWhFormScrappedGoods.getTransBusinessId());
        }
        if (lWhFormScrappedGoods.isset_userName) {
            this.setUserName(lWhFormScrappedGoods.getUserName());
        }
        if (lWhFormScrappedGoods.isset_sort) {
            this.setSort(lWhFormScrappedGoods.getSort());
        }
        // 去掉,2022-09-07
        // this.setDatabaseName_(l_wh_form_scrapped_goods.getDatabaseName_());
    }
    /**
     * 获取表名
     */
    @Override
    public String getTableName_() {
        String tableName = "l_wh_form_scrapped_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(Counts, this.getCounts(), this.isset_counts);
        ib.set(ScrappedCode, this.getScrappedCode(), this.isset_scrappedCode);
        ib.set(ScrappedName, this.getScrappedName(), this.isset_scrappedName);
        ib.set(Beiz, this.getBeiz(), this.isset_beiz);
        ib.set(FormScrappedId, this.getFormScrappedId(), this.isset_formScrappedId);
        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(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
        ib.set(UserName, this.getUserName(), this.isset_userName);
        ib.set(Sort, this.getSort(), this.isset_sort);
        return ib.genMapSql();
    }
    /**
     * 获取更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(Counts, this.getCounts(), this.isset_counts);
        ub.set(ScrappedCode, this.getScrappedCode(), this.isset_scrappedCode);
        ub.set(ScrappedName, this.getScrappedName(), this.isset_scrappedName);
        ub.set(Beiz, this.getBeiz(), this.isset_beiz);
        ub.set(FormScrappedId, this.getFormScrappedId(), this.isset_formScrappedId);
        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(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
        ub.set(UserName, this.getUserName(), this.isset_userName);
        ub.set(Sort, this.getSort(), this.isset_sort);
        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(Counts, this.getCounts(), this.isset_counts);
        ub.set(ScrappedCode, this.getScrappedCode(), this.isset_scrappedCode);
        ub.set(ScrappedName, this.getScrappedName(), this.isset_scrappedName);
        ub.set(Beiz, this.getBeiz(), this.isset_beiz);
        ub.set(FormScrappedId, this.getFormScrappedId(), this.isset_formScrappedId);
        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(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
        ub.set(UserName, this.getUserName(), this.isset_userName);
        ub.set(Sort, this.getSort(), this.isset_sort);
        return ub.genMapSql(where, parameters);
    }
    /**
     * 获取更新语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(Counts, this.getCounts(), this.isset_counts);
        ub.set(ScrappedCode, this.getScrappedCode(), this.isset_scrappedCode);
        ub.set(ScrappedName, this.getScrappedName(), this.isset_scrappedName);
        ub.set(Beiz, this.getBeiz(), this.isset_beiz);
        ub.set(FormScrappedId, this.getFormScrappedId(), this.isset_formScrappedId);
        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(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
        ub.set(UserName, this.getUserName(), this.isset_userName);
        ub.set(Sort, this.getSort(), this.isset_sort);
        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, counts, scrapped_code, scrapped_name, beiz, form_scrapped_id, base_goods_template_id, goods_template_name, unit, base_goods_models_id, base_goods_models_name, trans_business_id, user_name, sort from " + this.getTableName_() + " " + where, parameters);
    }
    /**
     * 获取查询语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, counts, scrapped_code, scrapped_name, beiz, form_scrapped_id, base_goods_template_id, goods_template_name, unit, base_goods_models_id, base_goods_models_name, trans_business_id, user_name, sort from " + this.getTableName_() + " " + where, parameters);
    }
    /**
     * 将resultset的一行转化为po
     */
    @Override
    public LWhFormScrappedGoods mapRow(ResultSet rs, int i) throws SQLException {
        return ROW_MAPPER.mapRow(rs, i);
    }
    /**
     * 克隆
     */
    public LWhFormScrappedGoods toLWhFormScrappedGoods() {
        return super.$clone();
    }
}
/**
 * l_wh_form_scrapped_goods RowMapper
 *
 * @author genrator
 */
class LWhFormScrappedGoodsRowMapper implements RowMapper<LWhFormScrappedGoods> {
    @Override
    public LWhFormScrappedGoods mapRow(ResultSet rs, int i) throws SQLException {
        ResultSetUtils resultSetUtils = new ResultSetUtils();
        LWhFormScrappedGoods l_wh_form_scrapped_goods = new LWhFormScrappedGoods();
        Integer columnIndex;
        //主键
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.Id);
        if (columnIndex > 0) {
            l_wh_form_scrapped_goods.setId(rs.getLong(columnIndex));
        }
        //普通属性
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.Counts);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_scrapped_goods.setCounts(null);
            } else {
                l_wh_form_scrapped_goods.setCounts(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.ScrappedCode);
        if (columnIndex > 0) {
            l_wh_form_scrapped_goods.setScrappedCode(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.ScrappedName);
        if (columnIndex > 0) {
            l_wh_form_scrapped_goods.setScrappedName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.Beiz);
        if (columnIndex > 0) {
            l_wh_form_scrapped_goods.setBeiz(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.FormScrappedId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_scrapped_goods.setFormScrappedId(null);
            } else {
                l_wh_form_scrapped_goods.setFormScrappedId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.BaseGoodsTemplateId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_scrapped_goods.setBaseGoodsTemplateId(null);
            } else {
                l_wh_form_scrapped_goods.setBaseGoodsTemplateId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.GoodsTemplateName);
        if (columnIndex > 0) {
            l_wh_form_scrapped_goods.setGoodsTemplateName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.Unit);
        if (columnIndex > 0) {
            l_wh_form_scrapped_goods.setUnit(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.BaseGoodsModelsId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_scrapped_goods.setBaseGoodsModelsId(null);
            } else {
                l_wh_form_scrapped_goods.setBaseGoodsModelsId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.BaseGoodsModelsName);
        if (columnIndex > 0) {
            l_wh_form_scrapped_goods.setBaseGoodsModelsName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.TransBusinessId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_scrapped_goods.setTransBusinessId(null);
            } else {
                l_wh_form_scrapped_goods.setTransBusinessId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.UserName);
        if (columnIndex > 0) {
            l_wh_form_scrapped_goods.setUserName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrappedGoods_mapper.Sort);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_scrapped_goods.setSort(null);
            } else {
                l_wh_form_scrapped_goods.setSort(rs.getLong(columnIndex));
            }
        }
        return l_wh_form_scrapped_goods;
    }
}
consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped_mapper.java
New file
@@ -0,0 +1,409 @@
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_SCRAPPED *
 * @author genrator
 */
public class LWhFormScrapped_mapper extends LWhFormScrapped implements BaseMapper<LWhFormScrapped> {
    // 序列化版本号
    private static final long serialVersionUID = 1L;
    public static final RowMapper<LWhFormScrapped> ROW_MAPPER = new LWhFormScrappedRowMapper();
    // 主键
    public static final String Id = "id";
    // 普通属性
    public static final String LWarehouseFlowId = "l_warehouse_flow_id";
    public static final String BusinessFormCode = "business_form_code";
    public static final String WarehouseId = "warehouse_id";
    public static final String WarehouseName = "warehouse_name";
    public static final String ScrappedType = "scrapped_type";
    public static final String AgencyId = "agency_id";
    public static final String AgencyName = "agency_name";
    public static final String OperatorId = "operator_id";
    public static final String OperatorName = "operator_name";
    public static final String DealTime = "deal_time";
    public static final String DepartmentId = "department_id";
    public static final String DepartmentName = "department_name";
    public static final String UploadFiles = "upload_files";
    public static final String States = "states";
    /**
     * 默认构造函数
     */
    public LWhFormScrapped_mapper(LWhFormScrapped lWhFormScrapped) {
        if (lWhFormScrapped == null) {
            throw new IllegalArgumentException("po参数不允许为空!");
        }
        //主键
        if (lWhFormScrapped.isset_id) {
            this.setId(lWhFormScrapped.getId());
        }
        //普通属性
        if (lWhFormScrapped.isset_lWarehouseFlowId) {
            this.setLWarehouseFlowId(lWhFormScrapped.getLWarehouseFlowId());
        }
        if (lWhFormScrapped.isset_businessFormCode) {
            this.setBusinessFormCode(lWhFormScrapped.getBusinessFormCode());
        }
        if (lWhFormScrapped.isset_warehouseId) {
            this.setWarehouseId(lWhFormScrapped.getWarehouseId());
        }
        if (lWhFormScrapped.isset_warehouseName) {
            this.setWarehouseName(lWhFormScrapped.getWarehouseName());
        }
        if (lWhFormScrapped.isset_scrappedType) {
            this.setScrappedType(lWhFormScrapped.getScrappedType());
        }
        if (lWhFormScrapped.isset_agencyId) {
            this.setAgencyId(lWhFormScrapped.getAgencyId());
        }
        if (lWhFormScrapped.isset_agencyName) {
            this.setAgencyName(lWhFormScrapped.getAgencyName());
        }
        if (lWhFormScrapped.isset_operatorId) {
            this.setOperatorId(lWhFormScrapped.getOperatorId());
        }
        if (lWhFormScrapped.isset_operatorName) {
            this.setOperatorName(lWhFormScrapped.getOperatorName());
        }
        if (lWhFormScrapped.isset_dealTime) {
            this.setDealTime(lWhFormScrapped.getDealTime());
        }
        if (lWhFormScrapped.isset_departmentId) {
            this.setDepartmentId(lWhFormScrapped.getDepartmentId());
        }
        if (lWhFormScrapped.isset_departmentName) {
            this.setDepartmentName(lWhFormScrapped.getDepartmentName());
        }
        if (lWhFormScrapped.isset_uploadFiles) {
            this.setUploadFiles(lWhFormScrapped.getUploadFiles());
        }
        if (lWhFormScrapped.isset_states) {
            this.setStates(lWhFormScrapped.getStates());
        }
        // 去掉,2022-09-07
        // this.setDatabaseName_(l_wh_form_scrapped.getDatabaseName_());
    }
    /**
     * 获取表名
     */
    @Override
    public String getTableName_() {
        String tableName = "l_wh_form_scrapped";
        /**
        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(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
        ib.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
        ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ib.set(ScrappedType, this.getScrappedType(), this.isset_scrappedType);
        ib.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
        ib.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
        ib.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
        ib.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
        ib.set(DealTime, this.getDealTime(), this.isset_dealTime);
        ib.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId);
        ib.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName);
        ib.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles);
        ib.set(States, this.getStates(), this.isset_states);
        return ib.genMapSql();
    }
    /**
     * 获取更新语句和参数
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(ScrappedType, this.getScrappedType(), this.isset_scrappedType);
        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
        ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
        ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId);
        ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName);
        ub.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles);
        ub.set(States, this.getStates(), this.isset_states);
        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(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(ScrappedType, this.getScrappedType(), this.isset_scrappedType);
        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
        ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
        ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId);
        ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName);
        ub.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles);
        ub.set(States, this.getStates(), this.isset_states);
        return ub.genMapSql(where, parameters);
    }
    /**
     * 获取更新语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId);
        ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode);
        ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
        ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
        ub.set(ScrappedType, this.getScrappedType(), this.isset_scrappedType);
        ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId);
        ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName);
        ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
        ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
        ub.set(DepartmentId, this.getDepartmentId(), this.isset_departmentId);
        ub.set(DepartmentName, this.getDepartmentName(), this.isset_departmentName);
        ub.set(UploadFiles, this.getUploadFiles(), this.isset_uploadFiles);
        ub.set(States, this.getStates(), this.isset_states);
        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, l_warehouse_flow_id, business_form_code, warehouse_id, warehouse_name, scrapped_type, agency_id, agency_name, operator_id, operator_name, deal_time, department_id, department_name, upload_files, states from " + this.getTableName_() + " " + where, parameters);
    }
    /**
     * 获取查询语句和参数
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, l_warehouse_flow_id, business_form_code, warehouse_id, warehouse_name, scrapped_type, agency_id, agency_name, operator_id, operator_name, deal_time, department_id, department_name, upload_files, states from " + this.getTableName_() + " " + where, parameters);
    }
    /**
     * 将resultset的一行转化为po
     */
    @Override
    public LWhFormScrapped mapRow(ResultSet rs, int i) throws SQLException {
        return ROW_MAPPER.mapRow(rs, i);
    }
    /**
     * 克隆
     */
    public LWhFormScrapped toLWhFormScrapped() {
        return super.$clone();
    }
}
/**
 * l_wh_form_scrapped RowMapper
 *
 * @author genrator
 */
class LWhFormScrappedRowMapper implements RowMapper<LWhFormScrapped> {
    @Override
    public LWhFormScrapped mapRow(ResultSet rs, int i) throws SQLException {
        ResultSetUtils resultSetUtils = new ResultSetUtils();
        LWhFormScrapped l_wh_form_scrapped = new LWhFormScrapped();
        Integer columnIndex;
        //主键
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.Id);
        if (columnIndex > 0) {
            l_wh_form_scrapped.setId(rs.getLong(columnIndex));
        }
        //普通属性
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.LWarehouseFlowId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_scrapped.setLWarehouseFlowId(null);
            } else {
                l_wh_form_scrapped.setLWarehouseFlowId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.BusinessFormCode);
        if (columnIndex > 0) {
            l_wh_form_scrapped.setBusinessFormCode(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.WarehouseId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_scrapped.setWarehouseId(null);
            } else {
                l_wh_form_scrapped.setWarehouseId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.WarehouseName);
        if (columnIndex > 0) {
            l_wh_form_scrapped.setWarehouseName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.ScrappedType);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_scrapped.setScrappedType(null);
            } else {
                l_wh_form_scrapped.setScrappedType(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.AgencyId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_scrapped.setAgencyId(null);
            } else {
                l_wh_form_scrapped.setAgencyId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.AgencyName);
        if (columnIndex > 0) {
            l_wh_form_scrapped.setAgencyName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.OperatorId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_scrapped.setOperatorId(null);
            } else {
                l_wh_form_scrapped.setOperatorId(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.OperatorName);
        if (columnIndex > 0) {
            l_wh_form_scrapped.setOperatorName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.DealTime);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_scrapped.setDealTime(null);
            } else {
                l_wh_form_scrapped.setDealTime(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.DepartmentId);
        if (columnIndex > 0) {
            l_wh_form_scrapped.setDepartmentId(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.DepartmentName);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_scrapped.setDepartmentName(null);
            } else {
                l_wh_form_scrapped.setDepartmentName(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.UploadFiles);
        if (columnIndex > 0) {
            l_wh_form_scrapped.setUploadFiles(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhFormScrapped_mapper.States);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_form_scrapped.setStates(null);
            } else {
                l_wh_form_scrapped.setStates(rs.getInt(columnIndex));
            }
        }
        return l_wh_form_scrapped;
    }
}
consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods.java
@@ -20,6 +20,10 @@
    protected boolean isset_id = false;
    // 属性列表
    private Integer warehouseType = null;
    @JsonIgnore
    protected boolean isset_warehouseType = false;
    private Long warehouseId = null;
    @JsonIgnore
    protected boolean isset_warehouseId = false;
@@ -105,6 +109,20 @@
    @JsonIgnore
    public boolean isEmptyId() {
        return this.id == null;
    }
    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() {
@@ -296,6 +314,7 @@
    public String toString() {
        return new StringBuilder()
                .append("id=").append(this.id)
                .append("warehouseType=").append(this.warehouseType)
                .append("warehouseId=").append(this.warehouseId)
                .append("warehouseName=").append(this.warehouseName)
                .append("costType=").append(this.costType)
@@ -326,6 +345,9 @@
            l_wh_goods.setId(this.getId());
        }
        // 普通属性
        if (this.isset_warehouseType) {
            l_wh_goods.setWarehouseType(this.getWarehouseType());
        }
        if (this.isset_warehouseId) {
            l_wh_goods.setWarehouseId(this.getWarehouseId());
        }
consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java
@@ -28,6 +28,7 @@
    // 主键
    public static final String Id = "id";
    // 普通属性
    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 CostType = "cost_type";
@@ -54,6 +55,9 @@
            this.setId(lWhGoods.getId());
        }
        //普通属性
        if (lWhGoods.isset_warehouseType) {
            this.setWarehouseType(lWhGoods.getWarehouseType());
        }
        if (lWhGoods.isset_warehouseId) {
            this.setWarehouseId(lWhGoods.getWarehouseId());
        }
@@ -136,6 +140,7 @@
    public SqlAndParameters<Map<String, Object>> getInsertSql_() {
        InsertBuilder ib = new InsertBuilder(this.getTableName_());
        ib.set(Id, this.getId());
        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(CostType, this.getCostType(), this.isset_costType);
@@ -158,6 +163,7 @@
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        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(CostType, this.getCostType(), this.isset_costType);
@@ -181,6 +187,7 @@
    @Override
    public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        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(CostType, this.getCostType(), this.isset_costType);
@@ -203,6 +210,7 @@
    @Override
    public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
        UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
        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(CostType, this.getCostType(), this.isset_costType);
@@ -263,7 +271,7 @@
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, warehouse_id, warehouse_name, cost_type, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, supplier, buy_type, unit, price, procure_date, states from " + this.getTableName_() + " " + where, parameters);
        return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_name, cost_type, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, supplier, buy_type, unit, price, procure_date, states from " + this.getTableName_() + " " + where, parameters);
    }
    /**
@@ -271,7 +279,7 @@
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, warehouse_id, warehouse_name, cost_type, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, supplier, buy_type, unit, price, procure_date, states from " + this.getTableName_() + " " + where, parameters);
        return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_name, cost_type, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, supplier, buy_type, unit, price, procure_date, states from " + this.getTableName_() + " " + where, parameters);
    }
    /**
@@ -308,6 +316,14 @@
            l_wh_goods.setId(rs.getLong(columnIndex));
        }
        //普通属性
        columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.WarehouseType);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods.setWarehouseType(null);
            } else {
                l_wh_goods.setWarehouseType(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.WarehouseId);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {