From ddaf74466d92dffb9ba8242a071f151f9a7e0e41 Mon Sep 17 00:00:00 2001 From: luqingyang <lqy5492@163.com> Date: 星期二, 31 十月 2023 17:04:35 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/master' --- consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java | 20 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped.java | 392 +++++++++++++ consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped_mapper.java | 409 ++++++++++++++ consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow.java | 22 consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord.java | 22 consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods.java | 22 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods_mapper.java | 389 +++++++++++++ consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory_mapper.java | 2 consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow_mapper.java | 20 consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java | 20 consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods.java | 370 ++++++++++++ 11 files changed, 1,680 insertions(+), 8 deletions(-) diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord.java b/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord.java index 97921d3..e962ffe 100644 --- a/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord.java +++ b/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()); } diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java index 60801e6..8ce8f90 100644 --- a/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java +++ b/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) { diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow.java index 886443a..21eee37 100644 --- a/consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow.java +++ b/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()); } diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow_mapper.java index 140478d..d56e971 100644 --- a/consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow_mapper.java +++ b/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) { diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory_mapper.java index 97635a6..fb5146d 100644 --- a/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormInventory_mapper.java +++ b/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; diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped.java new file mode 100644 index 0000000..eb4ffd8 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped.java @@ -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; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods.java new file mode 100644 index 0000000..66b1fd6 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods.java @@ -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; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods_mapper.java new file mode 100644 index 0000000..e877fcc --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrappedGoods_mapper.java @@ -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); + } + + /** + * 灏唕esultset鐨勪竴琛岃浆鍖栦负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; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped_mapper.java new file mode 100644 index 0000000..30a7746 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormScrapped_mapper.java @@ -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); + } + + /** + * 灏唕esultset鐨勪竴琛岃浆鍖栦负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; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods.java index 5bb2173..e33e012 100644 --- a/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods.java +++ b/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()); } diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java index 0c08812..d923b0c 100644 --- a/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java +++ b/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) { -- Gitblit v1.9.1