Merge remote-tracking branch 'origin/master'
# Conflicts:
# consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory_mapper.java
| | |
| | | @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; |
| | |
| | | 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; |
| | | } |
| | |
| | | .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(); |
| | |
| | | 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()); |
| | | } |
| | |
| | | // 普通属性 |
| | | 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"; |
| | | |
| | |
| | | } |
| | | if (lGoodsWhRecord.isset_whGoodsId) { |
| | | this.setWhGoodsId(lGoodsWhRecord.getWhGoodsId()); |
| | | } |
| | | if (lGoodsWhRecord.isset_warehouseType) { |
| | | this.setWarehouseType(lGoodsWhRecord.getWarehouseType()); |
| | | } |
| | | if (lGoodsWhRecord.isset_warehouseId) { |
| | | this.setWarehouseId(lGoodsWhRecord.getWarehouseId()); |
| | |
| | | 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(); |
| | |
| | | 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_()); |
| | |
| | | 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); |
| | |
| | | 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); |
| | |
| | | */ |
| | | @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); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @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); |
| | | } |
| | | |
| | | /** |
| | |
| | | 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) { |
| | |
| | | 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; |
| | |
| | | @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() { |
| | |
| | | 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) |
| | |
| | | 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()); |
| | | } |
| | |
| | | // 主键 |
| | | 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"; |
| | |
| | | this.setId(lWarehouseFlow.getId()); |
| | | } |
| | | //普通属性 |
| | | if (lWarehouseFlow.isset_warehouseType) { |
| | | this.setWarehouseType(lWarehouseFlow.getWarehouseType()); |
| | | } |
| | | if (lWarehouseFlow.isset_warehouseId) { |
| | | this.setWarehouseId(lWarehouseFlow.getWarehouseId()); |
| | | } |
| | |
| | | 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); |
| | |
| | | @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); |
| | |
| | | @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); |
| | |
| | | @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); |
| | |
| | | */ |
| | | @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); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @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); |
| | | } |
| | | |
| | | /** |
| | |
| | | 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) { |
| | |
| | | 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; |
New file |
| | |
| | | |
| | | 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; |
| | | } |
| | | } |
New file |
| | |
| | | |
| | | 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; |
| | | } |
| | | } |
New file |
| | |
| | | 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; |
| | | } |
| | | } |
New file |
| | |
| | | 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; |
| | | } |
| | | } |
| | |
| | | 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; |
| | |
| | | @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() { |
| | |
| | | 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) |
| | |
| | | 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()); |
| | | } |
| | |
| | | // 主键 |
| | | 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"; |
| | |
| | | this.setId(lWhGoods.getId()); |
| | | } |
| | | //普通属性 |
| | | if (lWhGoods.isset_warehouseType) { |
| | | this.setWarehouseType(lWhGoods.getWarehouseType()); |
| | | } |
| | | if (lWhGoods.isset_warehouseId) { |
| | | this.setWarehouseId(lWhGoods.getWarehouseId()); |
| | | } |
| | |
| | | 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); |
| | |
| | | @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); |
| | |
| | | @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); |
| | |
| | | @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); |
| | |
| | | */ |
| | | @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); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @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); |
| | | } |
| | | |
| | | /** |
| | |
| | | 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) { |