From 678f5441f463b86d2b59f111085e5be4981beebd Mon Sep 17 00:00:00 2001 From: luqingyang <lqy5492@163.com> Date: 星期三, 25 十月 2023 09:12:16 +0800 Subject: [PATCH] 物品管理和机构 相关代码 --- consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcureGoods_mapper.java | 297 +++ consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModel.java | 304 +++ consum-model-pojo/src/main/java/com/consum/model/po/LGoodsUserRecord.java | 260 ++ consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord.java | 194 ++ consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcureGoods.java | 216 ++ consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods.java | 370 +++ consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecordDetails.java | 150 + consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcure.java | 436 ++++ consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow_mapper.java | 329 +++ consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModel_mapper.java | 355 +++ consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecord_mapper.java | 361 +++ consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java | 289 +++ consum-model-pojo/src/main/java/com/consum/model/po/LGoodsUserRecord_mapper.java | 329 +++ consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow.java | 260 ++ consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecord.java | 304 +++ consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java | 397 ++++ consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcure_mapper.java | 437 ++++ consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecordDetails_mapper.java | 255 ++ 18 files changed, 5,543 insertions(+), 0 deletions(-) diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsUserRecord.java b/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsUserRecord.java new file mode 100644 index 0000000..022416b --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsUserRecord.java @@ -0,0 +1,260 @@ + +package com.consum.model.po; + +import com.fasterxml.jackson.annotation.JsonAutoDetect; +import com.fasterxml.jackson.annotation.JsonIgnore; +import com.walker.jdbc.BasePo; + +/** + * 琛ㄥ悕:L_GOODS_USER_RECORD * + * @author genrator + */ +@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY) +public class LGoodsUserRecord extends BasePo<LGoodsUserRecord> { + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + // 涓婚敭 + private Long id = null; + @JsonIgnore + protected boolean isset_id = false; + + // 灞炴�у垪琛� + private Long goodsUserPhone = null; + @JsonIgnore + protected boolean isset_goodsUserPhone = false; + + private Integer recordType = null; + @JsonIgnore + protected boolean isset_recordType = false; + + private Long lastRecordId = null; + @JsonIgnore + protected boolean isset_lastRecordId = false; + + private Long nowUserPhone = null; + @JsonIgnore + protected boolean isset_nowUserPhone = false; + + private String nowUserName = null; + @JsonIgnore + protected boolean isset_nowUserName = 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; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public LGoodsUserRecord() { + } + + /** + * 鏍规嵁涓婚敭鏋勯�犲璞� + */ + public LGoodsUserRecord(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 getGoodsUserPhone() { + return this.goodsUserPhone; + } + + public void setGoodsUserPhone(Long goodsUserPhone) { + this.goodsUserPhone = goodsUserPhone; + this.isset_goodsUserPhone = true; + } + + @JsonIgnore + public boolean isEmptyGoodsUserPhone() { + return this.goodsUserPhone == null; + } + + public Integer getRecordType() { + return this.recordType; + } + + public void setRecordType(Integer recordType) { + this.recordType = recordType; + this.isset_recordType = true; + } + + @JsonIgnore + public boolean isEmptyRecordType() { + return this.recordType == null; + } + + public Long getLastRecordId() { + return this.lastRecordId; + } + + public void setLastRecordId(Long lastRecordId) { + this.lastRecordId = lastRecordId; + this.isset_lastRecordId = true; + } + + @JsonIgnore + public boolean isEmptyLastRecordId() { + return this.lastRecordId == null; + } + + public Long getNowUserPhone() { + return this.nowUserPhone; + } + + public void setNowUserPhone(Long nowUserPhone) { + this.nowUserPhone = nowUserPhone; + this.isset_nowUserPhone = true; + } + + @JsonIgnore + public boolean isEmptyNowUserPhone() { + return this.nowUserPhone == null; + } + + public String getNowUserName() { + return this.nowUserName; + } + + public void setNowUserName(String nowUserName) { + this.nowUserName = nowUserName; + this.isset_nowUserName = true; + } + + @JsonIgnore + public boolean isEmptyNowUserName() { + return this.nowUserName == null || this.nowUserName.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; + } + + /** + * 閲嶅啓 toString() 鏂规硶 + */ + @Override + public String toString() { + return new StringBuilder() + .append("id=").append(this.id) + .append("goodsUserPhone=").append(this.goodsUserPhone) + .append("recordType=").append(this.recordType) + .append("lastRecordId=").append(this.lastRecordId) + .append("nowUserPhone=").append(this.nowUserPhone) + .append("nowUserName=").append(this.nowUserName) + .append("operatorId=").append(this.operatorId) + .append("operatorName=").append(this.operatorName) + .append("dealTime=").append(this.dealTime) + .toString(); + } + + /** + * 鍏嬮殕 + */ + public LGoodsUserRecord $clone() { + LGoodsUserRecord l_goods_user_record = new LGoodsUserRecord(); + + // 鏁版嵁搴撳悕绉� + //l_goods_user_record.setDatabaseName_(this.getDatabaseName_()); + + // 涓婚敭 + if (this.isset_id) { + l_goods_user_record.setId(this.getId()); + } + // 鏅�氬睘鎬� + if (this.isset_goodsUserPhone) { + l_goods_user_record.setGoodsUserPhone(this.getGoodsUserPhone()); + } + if (this.isset_recordType) { + l_goods_user_record.setRecordType(this.getRecordType()); + } + if (this.isset_lastRecordId) { + l_goods_user_record.setLastRecordId(this.getLastRecordId()); + } + if (this.isset_nowUserPhone) { + l_goods_user_record.setNowUserPhone(this.getNowUserPhone()); + } + if (this.isset_nowUserName) { + l_goods_user_record.setNowUserName(this.getNowUserName()); + } + if (this.isset_operatorId) { + l_goods_user_record.setOperatorId(this.getOperatorId()); + } + if (this.isset_operatorName) { + l_goods_user_record.setOperatorName(this.getOperatorName()); + } + if (this.isset_dealTime) { + l_goods_user_record.setDealTime(this.getDealTime()); + } + return l_goods_user_record; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsUserRecord_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsUserRecord_mapper.java new file mode 100644 index 0000000..c39ab0b --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsUserRecord_mapper.java @@ -0,0 +1,329 @@ +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_GOODS_USER_RECORD * + * @author genrator + */ +public class LGoodsUserRecord_mapper extends LGoodsUserRecord implements BaseMapper<LGoodsUserRecord> { + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + public static final RowMapper<LGoodsUserRecord> ROW_MAPPER = new LGoodsUserRecordRowMapper(); + + // 涓婚敭 + public static final String Id = "id"; + // 鏅�氬睘鎬� + public static final String GoodsUserPhone = "goods_user_phone"; + public static final String RecordType = "record_type"; + public static final String LastRecordId = "last_record_id"; + public static final String NowUserPhone = "now_user_phone"; + public static final String NowUserName = "now_user_name"; + public static final String OperatorId = "operator_id"; + public static final String OperatorName = "operator_name"; + public static final String DealTime = "deal_time"; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public LGoodsUserRecord_mapper(LGoodsUserRecord lGoodsUserRecord) { + if (lGoodsUserRecord == null) { + throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒"); + } + //涓婚敭 + if (lGoodsUserRecord.isset_id) { + this.setId(lGoodsUserRecord.getId()); + } + //鏅�氬睘鎬� + if (lGoodsUserRecord.isset_goodsUserPhone) { + this.setGoodsUserPhone(lGoodsUserRecord.getGoodsUserPhone()); + } + if (lGoodsUserRecord.isset_recordType) { + this.setRecordType(lGoodsUserRecord.getRecordType()); + } + if (lGoodsUserRecord.isset_lastRecordId) { + this.setLastRecordId(lGoodsUserRecord.getLastRecordId()); + } + if (lGoodsUserRecord.isset_nowUserPhone) { + this.setNowUserPhone(lGoodsUserRecord.getNowUserPhone()); + } + if (lGoodsUserRecord.isset_nowUserName) { + this.setNowUserName(lGoodsUserRecord.getNowUserName()); + } + if (lGoodsUserRecord.isset_operatorId) { + this.setOperatorId(lGoodsUserRecord.getOperatorId()); + } + if (lGoodsUserRecord.isset_operatorName) { + this.setOperatorName(lGoodsUserRecord.getOperatorName()); + } + if (lGoodsUserRecord.isset_dealTime) { + this.setDealTime(lGoodsUserRecord.getDealTime()); + } + // 鍘绘帀锛�2022-09-07 + // this.setDatabaseName_(l_goods_user_record.getDatabaseName_()); + } + + /** + * 鑾峰彇琛ㄥ悕 + */ + @Override + public String getTableName_() { + String tableName = "l_goods_user_record"; + /** + 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(GoodsUserPhone, this.getGoodsUserPhone(), this.isset_goodsUserPhone); + ib.set(RecordType, this.getRecordType(), this.isset_recordType); + ib.set(LastRecordId, this.getLastRecordId(), this.isset_lastRecordId); + ib.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone); + ib.set(NowUserName, this.getNowUserName(), this.isset_nowUserName); + ib.set(OperatorId, this.getOperatorId(), this.isset_operatorId); + ib.set(OperatorName, this.getOperatorName(), this.isset_operatorName); + ib.set(DealTime, this.getDealTime(), this.isset_dealTime); + return ib.genMapSql(); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Map<String, Object>> getUpdateSql_() { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(GoodsUserPhone, this.getGoodsUserPhone(), this.isset_goodsUserPhone); + ub.set(RecordType, this.getRecordType(), this.isset_recordType); + ub.set(LastRecordId, this.getLastRecordId(), this.isset_lastRecordId); + ub.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone); + ub.set(NowUserName, this.getNowUserName(), this.isset_nowUserName); + 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.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(GoodsUserPhone, this.getGoodsUserPhone(), this.isset_goodsUserPhone); + ub.set(RecordType, this.getRecordType(), this.isset_recordType); + ub.set(LastRecordId, this.getLastRecordId(), this.isset_lastRecordId); + ub.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone); + ub.set(NowUserName, this.getNowUserName(), this.isset_nowUserName); + ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId); + ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName); + ub.set(DealTime, this.getDealTime(), this.isset_dealTime); + return ub.genMapSql(where, parameters); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(GoodsUserPhone, this.getGoodsUserPhone(), this.isset_goodsUserPhone); + ub.set(RecordType, this.getRecordType(), this.isset_recordType); + ub.set(LastRecordId, this.getLastRecordId(), this.isset_lastRecordId); + ub.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone); + ub.set(NowUserName, this.getNowUserName(), this.isset_nowUserName); + ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId); + ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName); + ub.set(DealTime, this.getDealTime(), this.isset_dealTime); + 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, goods_user_phone, record_type, last_record_id, now_user_phone, now_user_name, 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, goods_user_phone, record_type, last_record_id, now_user_phone, now_user_name, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters); + } + + /** + * 灏唕esultset鐨勪竴琛岃浆鍖栦负po + */ + @Override + public LGoodsUserRecord mapRow(ResultSet rs, int i) throws SQLException { + return ROW_MAPPER.mapRow(rs, i); + } + + /** + * 鍏嬮殕 + */ + public LGoodsUserRecord toLGoodsUserRecord() { + return super.$clone(); + } +} + +/** + * l_goods_user_record RowMapper + * + * @author genrator + */ +class LGoodsUserRecordRowMapper implements RowMapper<LGoodsUserRecord> { + + @Override + public LGoodsUserRecord mapRow(ResultSet rs, int i) throws SQLException { + ResultSetUtils resultSetUtils = new ResultSetUtils(); + LGoodsUserRecord l_goods_user_record = new LGoodsUserRecord(); + Integer columnIndex; + //涓婚敭 + columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.Id); + if (columnIndex > 0) { + l_goods_user_record.setId(rs.getLong(columnIndex)); + } + //鏅�氬睘鎬� + columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.GoodsUserPhone); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_goods_user_record.setGoodsUserPhone(null); + } else { + l_goods_user_record.setGoodsUserPhone(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.RecordType); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_goods_user_record.setRecordType(null); + } else { + l_goods_user_record.setRecordType(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.LastRecordId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_goods_user_record.setLastRecordId(null); + } else { + l_goods_user_record.setLastRecordId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.NowUserPhone); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_goods_user_record.setNowUserPhone(null); + } else { + l_goods_user_record.setNowUserPhone(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.NowUserName); + if (columnIndex > 0) { + l_goods_user_record.setNowUserName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.OperatorId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_goods_user_record.setOperatorId(null); + } else { + l_goods_user_record.setOperatorId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.OperatorName); + if (columnIndex > 0) { + l_goods_user_record.setOperatorName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.DealTime); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_goods_user_record.setDealTime(null); + } else { + l_goods_user_record.setDealTime(rs.getLong(columnIndex)); + } + } + return l_goods_user_record; + } +} 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 new file mode 100644 index 0000000..3c50152 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord.java @@ -0,0 +1,194 @@ + +package com.consum.model.po; + +import com.fasterxml.jackson.annotation.JsonAutoDetect; +import com.fasterxml.jackson.annotation.JsonIgnore; +import com.walker.jdbc.BasePo; + +/** + * 琛ㄥ悕:L_GOODS_WH_RECORD * + * @author genrator + */ +@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY) +public class LGoodsWhRecord extends BasePo<LGoodsWhRecord> { + // 搴忓垪鍖栫増鏈彿 + 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 Long lWhGoodsId = null; + @JsonIgnore + protected boolean isset_lWhGoodsId = false; + + private Long warehouseId = null; + @JsonIgnore + protected boolean isset_warehouseId = false; + + private Integer parentId = null; + @JsonIgnore + protected boolean isset_parentId = false; + + private Long dealTime = null; + @JsonIgnore + protected boolean isset_dealTime = false; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public LGoodsWhRecord() { + } + + /** + * 鏍规嵁涓婚敭鏋勯�犲璞� + */ + public LGoodsWhRecord(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 Long getLWhGoodsId() { + return this.lWhGoodsId; + } + + public void setLWhGoodsId(Long lWhGoodsId) { + this.lWhGoodsId = lWhGoodsId; + this.isset_lWhGoodsId = true; + } + + @JsonIgnore + public boolean isEmptyLWhGoodsId() { + return this.lWhGoodsId == null; + } + + public Long getWarehouseId() { + return this.warehouseId; + } + + public void setWarehouseId(Long warehouseId) { + this.warehouseId = warehouseId; + this.isset_warehouseId = true; + } + + @JsonIgnore + public boolean isEmptyWarehouseId() { + return this.warehouseId == null; + } + + public Integer getParentId() { + return this.parentId; + } + + public void setParentId(Integer parentId) { + this.parentId = parentId; + this.isset_parentId = true; + } + + @JsonIgnore + public boolean isEmptyParentId() { + return this.parentId == null; + } + + 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; + } + + /** + * 閲嶅啓 toString() 鏂规硶 + */ + @Override + public String toString() { + return new StringBuilder() + .append("id=").append(this.id) + .append("lWarehouseFlowId=").append(this.lWarehouseFlowId) + .append("lWhGoodsId=").append(this.lWhGoodsId) + .append("warehouseId=").append(this.warehouseId) + .append("parentId=").append(this.parentId) + .append("dealTime=").append(this.dealTime) + .toString(); + } + + /** + * 鍏嬮殕 + */ + public LGoodsWhRecord $clone() { + LGoodsWhRecord l_goods_wh_record = new LGoodsWhRecord(); + + // 鏁版嵁搴撳悕绉� + //l_goods_wh_record.setDatabaseName_(this.getDatabaseName_()); + + // 涓婚敭 + if (this.isset_id) { + l_goods_wh_record.setId(this.getId()); + } + // 鏅�氬睘鎬� + if (this.isset_lWarehouseFlowId) { + l_goods_wh_record.setLWarehouseFlowId(this.getLWarehouseFlowId()); + } + if (this.isset_lWhGoodsId) { + l_goods_wh_record.setLWhGoodsId(this.getLWhGoodsId()); + } + if (this.isset_warehouseId) { + l_goods_wh_record.setWarehouseId(this.getWarehouseId()); + } + if (this.isset_parentId) { + l_goods_wh_record.setParentId(this.getParentId()); + } + if (this.isset_dealTime) { + l_goods_wh_record.setDealTime(this.getDealTime()); + } + return l_goods_wh_record; + } +} 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 new file mode 100644 index 0000000..ae734c1 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java @@ -0,0 +1,289 @@ +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_GOODS_WH_RECORD * + * @author genrator + */ +public class LGoodsWhRecord_mapper extends LGoodsWhRecord implements BaseMapper<LGoodsWhRecord> { + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + public static final RowMapper<LGoodsWhRecord> ROW_MAPPER = new LGoodsWhRecordRowMapper(); + + // 涓婚敭 + public static final String Id = "id"; + // 鏅�氬睘鎬� + public static final String LWarehouseFlowId = "l_warehouse_flow_id"; + public static final String LWhGoodsId = "l_wh_goods_id"; + public static final String WarehouseId = "warehouse_id"; + public static final String ParentId = "parent_id"; + public static final String DealTime = "deal_time"; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public LGoodsWhRecord_mapper(LGoodsWhRecord lGoodsWhRecord) { + if (lGoodsWhRecord == null) { + throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒"); + } + //涓婚敭 + if (lGoodsWhRecord.isset_id) { + this.setId(lGoodsWhRecord.getId()); + } + //鏅�氬睘鎬� + if (lGoodsWhRecord.isset_lWarehouseFlowId) { + this.setLWarehouseFlowId(lGoodsWhRecord.getLWarehouseFlowId()); + } + if (lGoodsWhRecord.isset_lWhGoodsId) { + this.setLWhGoodsId(lGoodsWhRecord.getLWhGoodsId()); + } + if (lGoodsWhRecord.isset_warehouseId) { + this.setWarehouseId(lGoodsWhRecord.getWarehouseId()); + } + if (lGoodsWhRecord.isset_parentId) { + this.setParentId(lGoodsWhRecord.getParentId()); + } + if (lGoodsWhRecord.isset_dealTime) { + this.setDealTime(lGoodsWhRecord.getDealTime()); + } + // 鍘绘帀锛�2022-09-07 + // this.setDatabaseName_(l_goods_wh_record.getDatabaseName_()); + } + + /** + * 鑾峰彇琛ㄥ悕 + */ + @Override + public String getTableName_() { + String tableName = "l_goods_wh_record"; + /** + 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(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId); + ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); + ib.set(ParentId, this.getParentId(), this.isset_parentId); + ib.set(DealTime, this.getDealTime(), this.isset_dealTime); + 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(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId); + ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); + ub.set(ParentId, this.getParentId(), this.isset_parentId); + ub.set(DealTime, this.getDealTime(), this.isset_dealTime); + 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(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId); + ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); + ub.set(ParentId, this.getParentId(), this.isset_parentId); + ub.set(DealTime, this.getDealTime(), this.isset_dealTime); + 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(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId); + ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); + ub.set(ParentId, this.getParentId(), this.isset_parentId); + ub.set(DealTime, this.getDealTime(), this.isset_dealTime); + 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, l_wh_goods_id, warehouse_id, parent_id, deal_time from " + this.getTableName_() + " " + where, parameters); + } + + /** + * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { + return new SqlAndParameters<>("select id, l_warehouse_flow_id, l_wh_goods_id, warehouse_id, parent_id, deal_time from " + this.getTableName_() + " " + where, parameters); + } + + /** + * 灏唕esultset鐨勪竴琛岃浆鍖栦负po + */ + @Override + public LGoodsWhRecord mapRow(ResultSet rs, int i) throws SQLException { + return ROW_MAPPER.mapRow(rs, i); + } + + /** + * 鍏嬮殕 + */ + public LGoodsWhRecord toLGoodsWhRecord() { + return super.$clone(); + } +} + +/** + * l_goods_wh_record RowMapper + * + * @author genrator + */ +class LGoodsWhRecordRowMapper implements RowMapper<LGoodsWhRecord> { + + @Override + public LGoodsWhRecord mapRow(ResultSet rs, int i) throws SQLException { + ResultSetUtils resultSetUtils = new ResultSetUtils(); + LGoodsWhRecord l_goods_wh_record = new LGoodsWhRecord(); + Integer columnIndex; + //涓婚敭 + columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.Id); + if (columnIndex > 0) { + l_goods_wh_record.setId(rs.getLong(columnIndex)); + } + //鏅�氬睘鎬� + columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.LWarehouseFlowId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_goods_wh_record.setLWarehouseFlowId(null); + } else { + l_goods_wh_record.setLWarehouseFlowId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.LWhGoodsId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_goods_wh_record.setLWhGoodsId(null); + } else { + l_goods_wh_record.setLWhGoodsId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.WarehouseId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_goods_wh_record.setWarehouseId(null); + } else { + l_goods_wh_record.setWarehouseId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.ParentId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_goods_wh_record.setParentId(null); + } else { + l_goods_wh_record.setParentId(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.DealTime); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_goods_wh_record.setDealTime(null); + } else { + l_goods_wh_record.setDealTime(rs.getLong(columnIndex)); + } + } + return l_goods_wh_record; + } +} 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 new file mode 100644 index 0000000..02d7320 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow.java @@ -0,0 +1,260 @@ + +package com.consum.model.po; + +import com.fasterxml.jackson.annotation.JsonAutoDetect; +import com.fasterxml.jackson.annotation.JsonIgnore; +import com.walker.jdbc.BasePo; + +/** + * 琛ㄥ悕:L_WAREHOUSE_FLOW * + * @author genrator + */ +@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY) +public class LWarehouseFlow extends BasePo<LWarehouseFlow> { + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + // 涓婚敭 + private Long id = null; + @JsonIgnore + protected boolean isset_id = false; + + // 灞炴�у垪琛� + private Long warehouseId = null; + @JsonIgnore + protected boolean isset_warehouseId = false; + + private String warehouseName = null; + @JsonIgnore + protected boolean isset_warehouseName = false; + + private Integer lastRecord = null; + @JsonIgnore + protected boolean isset_lastRecord = false; + + private Integer businessType = null; + @JsonIgnore + protected boolean isset_businessType = false; + + private Long businessFormId = null; + @JsonIgnore + protected boolean isset_businessFormId = 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; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public LWarehouseFlow() { + } + + /** + * 鏍规嵁涓婚敭鏋勯�犲璞� + */ + public LWarehouseFlow(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 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 getLastRecord() { + return this.lastRecord; + } + + public void setLastRecord(Integer lastRecord) { + this.lastRecord = lastRecord; + this.isset_lastRecord = true; + } + + @JsonIgnore + public boolean isEmptyLastRecord() { + return this.lastRecord == null; + } + + public Integer getBusinessType() { + return this.businessType; + } + + public void setBusinessType(Integer businessType) { + this.businessType = businessType; + this.isset_businessType = true; + } + + @JsonIgnore + public boolean isEmptyBusinessType() { + return this.businessType == null; + } + + public Long getBusinessFormId() { + return this.businessFormId; + } + + public void setBusinessFormId(Long businessFormId) { + this.businessFormId = businessFormId; + this.isset_businessFormId = true; + } + + @JsonIgnore + public boolean isEmptyBusinessFormId() { + return this.businessFormId == null; + } + + 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; + } + + /** + * 閲嶅啓 toString() 鏂规硶 + */ + @Override + public String toString() { + return new StringBuilder() + .append("id=").append(this.id) + .append("warehouseId=").append(this.warehouseId) + .append("warehouseName=").append(this.warehouseName) + .append("lastRecord=").append(this.lastRecord) + .append("businessType=").append(this.businessType) + .append("businessFormId=").append(this.businessFormId) + .append("operatorId=").append(this.operatorId) + .append("operatorName=").append(this.operatorName) + .append("dealTime=").append(this.dealTime) + .toString(); + } + + /** + * 鍏嬮殕 + */ + public LWarehouseFlow $clone() { + LWarehouseFlow l_warehouse_flow = new LWarehouseFlow(); + + // 鏁版嵁搴撳悕绉� + //l_warehouse_flow.setDatabaseName_(this.getDatabaseName_()); + + // 涓婚敭 + if (this.isset_id) { + l_warehouse_flow.setId(this.getId()); + } + // 鏅�氬睘鎬� + if (this.isset_warehouseId) { + l_warehouse_flow.setWarehouseId(this.getWarehouseId()); + } + if (this.isset_warehouseName) { + l_warehouse_flow.setWarehouseName(this.getWarehouseName()); + } + if (this.isset_lastRecord) { + l_warehouse_flow.setLastRecord(this.getLastRecord()); + } + if (this.isset_businessType) { + l_warehouse_flow.setBusinessType(this.getBusinessType()); + } + if (this.isset_businessFormId) { + l_warehouse_flow.setBusinessFormId(this.getBusinessFormId()); + } + if (this.isset_operatorId) { + l_warehouse_flow.setOperatorId(this.getOperatorId()); + } + if (this.isset_operatorName) { + l_warehouse_flow.setOperatorName(this.getOperatorName()); + } + if (this.isset_dealTime) { + l_warehouse_flow.setDealTime(this.getDealTime()); + } + return l_warehouse_flow; + } +} 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 new file mode 100644 index 0000000..6b28d09 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWarehouseFlow_mapper.java @@ -0,0 +1,329 @@ +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_WAREHOUSE_FLOW * + * @author genrator + */ +public class LWarehouseFlow_mapper extends LWarehouseFlow implements BaseMapper<LWarehouseFlow> { + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + public static final RowMapper<LWarehouseFlow> ROW_MAPPER = new LWarehouseFlowRowMapper(); + + // 涓婚敭 + public static final String Id = "id"; + // 鏅�氬睘鎬� + public static final String WarehouseId = "warehouse_id"; + public static final String WarehouseName = "warehouse_name"; + public static final String LastRecord = "last_record"; + public static final String BusinessType = "business_type"; + public static final String BusinessFormId = "business_form_id"; + public static final String OperatorId = "operator_id"; + public static final String OperatorName = "operator_name"; + public static final String DealTime = "deal_time"; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public LWarehouseFlow_mapper(LWarehouseFlow lWarehouseFlow) { + if (lWarehouseFlow == null) { + throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒"); + } + //涓婚敭 + if (lWarehouseFlow.isset_id) { + this.setId(lWarehouseFlow.getId()); + } + //鏅�氬睘鎬� + if (lWarehouseFlow.isset_warehouseId) { + this.setWarehouseId(lWarehouseFlow.getWarehouseId()); + } + if (lWarehouseFlow.isset_warehouseName) { + this.setWarehouseName(lWarehouseFlow.getWarehouseName()); + } + if (lWarehouseFlow.isset_lastRecord) { + this.setLastRecord(lWarehouseFlow.getLastRecord()); + } + if (lWarehouseFlow.isset_businessType) { + this.setBusinessType(lWarehouseFlow.getBusinessType()); + } + if (lWarehouseFlow.isset_businessFormId) { + this.setBusinessFormId(lWarehouseFlow.getBusinessFormId()); + } + if (lWarehouseFlow.isset_operatorId) { + this.setOperatorId(lWarehouseFlow.getOperatorId()); + } + if (lWarehouseFlow.isset_operatorName) { + this.setOperatorName(lWarehouseFlow.getOperatorName()); + } + if (lWarehouseFlow.isset_dealTime) { + this.setDealTime(lWarehouseFlow.getDealTime()); + } + // 鍘绘帀锛�2022-09-07 + // this.setDatabaseName_(l_warehouse_flow.getDatabaseName_()); + } + + /** + * 鑾峰彇琛ㄥ悕 + */ + @Override + public String getTableName_() { + String tableName = "l_warehouse_flow"; + /** + 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(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); + ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); + ib.set(LastRecord, this.getLastRecord(), this.isset_lastRecord); + ib.set(BusinessType, this.getBusinessType(), this.isset_businessType); + ib.set(BusinessFormId, this.getBusinessFormId(), this.isset_businessFormId); + ib.set(OperatorId, this.getOperatorId(), this.isset_operatorId); + ib.set(OperatorName, this.getOperatorName(), this.isset_operatorName); + ib.set(DealTime, this.getDealTime(), this.isset_dealTime); + return ib.genMapSql(); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Map<String, Object>> getUpdateSql_() { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); + ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); + ub.set(LastRecord, this.getLastRecord(), this.isset_lastRecord); + ub.set(BusinessType, this.getBusinessType(), this.isset_businessType); + ub.set(BusinessFormId, this.getBusinessFormId(), this.isset_businessFormId); + 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.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(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); + ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); + ub.set(LastRecord, this.getLastRecord(), this.isset_lastRecord); + ub.set(BusinessType, this.getBusinessType(), this.isset_businessType); + ub.set(BusinessFormId, this.getBusinessFormId(), this.isset_businessFormId); + ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId); + ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName); + ub.set(DealTime, this.getDealTime(), this.isset_dealTime); + return ub.genMapSql(where, parameters); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); + ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); + ub.set(LastRecord, this.getLastRecord(), this.isset_lastRecord); + ub.set(BusinessType, this.getBusinessType(), this.isset_businessType); + ub.set(BusinessFormId, this.getBusinessFormId(), this.isset_businessFormId); + ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId); + ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName); + ub.set(DealTime, this.getDealTime(), this.isset_dealTime); + 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, warehouse_id, warehouse_name, last_record, 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, last_record, business_type, business_form_id, operator_id, operator_name, deal_time from " + this.getTableName_() + " " + where, parameters); + } + + /** + * 灏唕esultset鐨勪竴琛岃浆鍖栦负po + */ + @Override + public LWarehouseFlow mapRow(ResultSet rs, int i) throws SQLException { + return ROW_MAPPER.mapRow(rs, i); + } + + /** + * 鍏嬮殕 + */ + public LWarehouseFlow toLWarehouseFlow() { + return super.$clone(); + } +} + +/** + * l_warehouse_flow RowMapper + * + * @author genrator + */ +class LWarehouseFlowRowMapper implements RowMapper<LWarehouseFlow> { + + @Override + public LWarehouseFlow mapRow(ResultSet rs, int i) throws SQLException { + ResultSetUtils resultSetUtils = new ResultSetUtils(); + LWarehouseFlow l_warehouse_flow = new LWarehouseFlow(); + Integer columnIndex; + //涓婚敭 + columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.Id); + if (columnIndex > 0) { + l_warehouse_flow.setId(rs.getLong(columnIndex)); + } + //鏅�氬睘鎬� + columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.WarehouseId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_warehouse_flow.setWarehouseId(null); + } else { + l_warehouse_flow.setWarehouseId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.WarehouseName); + if (columnIndex > 0) { + l_warehouse_flow.setWarehouseName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.LastRecord); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_warehouse_flow.setLastRecord(null); + } else { + l_warehouse_flow.setLastRecord(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.BusinessType); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_warehouse_flow.setBusinessType(null); + } else { + l_warehouse_flow.setBusinessType(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.BusinessFormId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_warehouse_flow.setBusinessFormId(null); + } else { + l_warehouse_flow.setBusinessFormId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.OperatorId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_warehouse_flow.setOperatorId(null); + } else { + l_warehouse_flow.setOperatorId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.OperatorName); + if (columnIndex > 0) { + l_warehouse_flow.setOperatorName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWarehouseFlow_mapper.DealTime); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_warehouse_flow.setDealTime(null); + } else { + l_warehouse_flow.setDealTime(rs.getLong(columnIndex)); + } + } + return l_warehouse_flow; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcure.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcure.java new file mode 100644 index 0000000..e9d558a --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcure.java @@ -0,0 +1,436 @@ + +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_PROCURE * + * @author genrator + */ +@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY) +public class LWhFormProcure extends BasePo<LWhFormProcure> { + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + // 涓婚敭 + private Long id = null; + @JsonIgnore + protected boolean isset_id = false; + + // 灞炴�у垪琛� + private String businessFormCode = null; + @JsonIgnore + protected boolean isset_businessFormCode = false; + + private String warehouseName = null; + @JsonIgnore + protected boolean isset_warehouseName = false; + + private Long buyerId = null; + @JsonIgnore + protected boolean isset_buyerId = false; + + private String buyerName = null; + @JsonIgnore + protected boolean isset_buyerName = false; + + private Long procureTime = null; + @JsonIgnore + protected boolean isset_procureTime = false; + + private String procureDoc = null; + @JsonIgnore + protected boolean isset_procureDoc = false; + + private Integer buyType = null; + @JsonIgnore + protected boolean isset_buyType = false; + + private Integer states = null; + @JsonIgnore + protected boolean isset_states = false; + + private Long agencyId = null; + @JsonIgnore + protected boolean isset_agencyId = false; + + private String agencyName = null; + @JsonIgnore + protected boolean isset_agencyName = false; + + private Long incomeId = null; + @JsonIgnore + protected boolean isset_incomeId = false; + + private String incomeName = null; + @JsonIgnore + protected boolean isset_incomeName = false; + + private Long incomeTime = null; + @JsonIgnore + protected boolean isset_incomeTime = false; + + private Long warehouseId = null; + @JsonIgnore + protected boolean isset_warehouseId = false; + + private String beiz = null; + @JsonIgnore + protected boolean isset_beiz = false; + + private Long lWarehouseFlowId = null; + @JsonIgnore + protected boolean isset_lWarehouseFlowId = false; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public LWhFormProcure() { + } + + /** + * 鏍规嵁涓婚敭鏋勯�犲璞� + */ + public LWhFormProcure(Long id) { + this.setId(id); + } + + /** + * 璁剧疆涓婚敭鍊� + */ + @Override + public void setPkValue(Object value) { + this.setId((Long) value); + } + + public Long getId() { + return this.id; + } + + public void setId(Long id) { + this.id = id; + this.isset_id = true; + } + + @JsonIgnore + public boolean isEmptyId() { + return this.id == null; + } + + public String getBusinessFormCode() { + return this.businessFormCode; + } + + public void setBusinessFormCode(String businessFormCode) { + this.businessFormCode = businessFormCode; + this.isset_businessFormCode = true; + } + + @JsonIgnore + public boolean isEmptyBusinessFormCode() { + return this.businessFormCode == null || this.businessFormCode.length() == 0; + } + + public String getWarehouseName() { + return this.warehouseName; + } + + public void setWarehouseName(String warehouseName) { + this.warehouseName = warehouseName; + this.isset_warehouseName = true; + } + + @JsonIgnore + public boolean isEmptyWarehouseName() { + return this.warehouseName == null || this.warehouseName.length() == 0; + } + + public Long getBuyerId() { + return this.buyerId; + } + + public void setBuyerId(Long buyerId) { + this.buyerId = buyerId; + this.isset_buyerId = true; + } + + @JsonIgnore + public boolean isEmptyBuyerId() { + return this.buyerId == null; + } + + public String getBuyerName() { + return this.buyerName; + } + + public void setBuyerName(String buyerName) { + this.buyerName = buyerName; + this.isset_buyerName = true; + } + + @JsonIgnore + public boolean isEmptyBuyerName() { + return this.buyerName == null || this.buyerName.length() == 0; + } + + public Long getProcureTime() { + return this.procureTime; + } + + public void setProcureTime(Long procureTime) { + this.procureTime = procureTime; + this.isset_procureTime = true; + } + + @JsonIgnore + public boolean isEmptyProcureTime() { + return this.procureTime == null; + } + + public String getProcureDoc() { + return this.procureDoc; + } + + public void setProcureDoc(String procureDoc) { + this.procureDoc = procureDoc; + this.isset_procureDoc = true; + } + + @JsonIgnore + public boolean isEmptyProcureDoc() { + return this.procureDoc == null || this.procureDoc.length() == 0; + } + + public Integer getBuyType() { + return this.buyType; + } + + public void setBuyType(Integer buyType) { + this.buyType = buyType; + this.isset_buyType = true; + } + + @JsonIgnore + public boolean isEmptyBuyType() { + return this.buyType == null; + } + + public Integer getStates() { + return this.states; + } + + public void setStates(Integer states) { + this.states = states; + this.isset_states = true; + } + + @JsonIgnore + public boolean isEmptyStates() { + return this.states == null; + } + + public 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 getIncomeId() { + return this.incomeId; + } + + public void setIncomeId(Long incomeId) { + this.incomeId = incomeId; + this.isset_incomeId = true; + } + + @JsonIgnore + public boolean isEmptyIncomeId() { + return this.incomeId == null; + } + + public String getIncomeName() { + return this.incomeName; + } + + public void setIncomeName(String incomeName) { + this.incomeName = incomeName; + this.isset_incomeName = true; + } + + @JsonIgnore + public boolean isEmptyIncomeName() { + return this.incomeName == null || this.incomeName.length() == 0; + } + + public Long getIncomeTime() { + return this.incomeTime; + } + + public void setIncomeTime(Long incomeTime) { + this.incomeTime = incomeTime; + this.isset_incomeTime = true; + } + + @JsonIgnore + public boolean isEmptyIncomeTime() { + return this.incomeTime == null; + } + + public Long getWarehouseId() { + return this.warehouseId; + } + + public void setWarehouseId(Long warehouseId) { + this.warehouseId = warehouseId; + this.isset_warehouseId = true; + } + + @JsonIgnore + public boolean isEmptyWarehouseId() { + return this.warehouseId == null; + } + + public String 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 getLWarehouseFlowId() { + return this.lWarehouseFlowId; + } + + public void setLWarehouseFlowId(Long lWarehouseFlowId) { + this.lWarehouseFlowId = lWarehouseFlowId; + this.isset_lWarehouseFlowId = true; + } + + @JsonIgnore + public boolean isEmptyLWarehouseFlowId() { + return this.lWarehouseFlowId == null; + } + + /** + * 閲嶅啓 toString() 鏂规硶 + */ + @Override + public String toString() { + return new StringBuilder() + .append("id=").append(this.id) + .append("businessFormCode=").append(this.businessFormCode) + .append("warehouseName=").append(this.warehouseName) + .append("buyerId=").append(this.buyerId) + .append("buyerName=").append(this.buyerName) + .append("procureTime=").append(this.procureTime) + .append("procureDoc=").append(this.procureDoc) + .append("buyType=").append(this.buyType) + .append("states=").append(this.states) + .append("agencyId=").append(this.agencyId) + .append("agencyName=").append(this.agencyName) + .append("incomeId=").append(this.incomeId) + .append("incomeName=").append(this.incomeName) + .append("incomeTime=").append(this.incomeTime) + .append("warehouseId=").append(this.warehouseId) + .append("beiz=").append(this.beiz) + .append("lWarehouseFlowId=").append(this.lWarehouseFlowId) + .toString(); + } + + /** + * 鍏嬮殕 + */ + public LWhFormProcure $clone() { + LWhFormProcure l_wh_form_procure = new LWhFormProcure(); + + // 鏁版嵁搴撳悕绉� + //l_wh_form_procure.setDatabaseName_(this.getDatabaseName_()); + + // 涓婚敭 + if (this.isset_id) { + l_wh_form_procure.setId(this.getId()); + } + // 鏅�氬睘鎬� + if (this.isset_businessFormCode) { + l_wh_form_procure.setBusinessFormCode(this.getBusinessFormCode()); + } + if (this.isset_warehouseName) { + l_wh_form_procure.setWarehouseName(this.getWarehouseName()); + } + if (this.isset_buyerId) { + l_wh_form_procure.setBuyerId(this.getBuyerId()); + } + if (this.isset_buyerName) { + l_wh_form_procure.setBuyerName(this.getBuyerName()); + } + if (this.isset_procureTime) { + l_wh_form_procure.setProcureTime(this.getProcureTime()); + } + if (this.isset_procureDoc) { + l_wh_form_procure.setProcureDoc(this.getProcureDoc()); + } + if (this.isset_buyType) { + l_wh_form_procure.setBuyType(this.getBuyType()); + } + if (this.isset_states) { + l_wh_form_procure.setStates(this.getStates()); + } + if (this.isset_agencyId) { + l_wh_form_procure.setAgencyId(this.getAgencyId()); + } + if (this.isset_agencyName) { + l_wh_form_procure.setAgencyName(this.getAgencyName()); + } + if (this.isset_incomeId) { + l_wh_form_procure.setIncomeId(this.getIncomeId()); + } + if (this.isset_incomeName) { + l_wh_form_procure.setIncomeName(this.getIncomeName()); + } + if (this.isset_incomeTime) { + l_wh_form_procure.setIncomeTime(this.getIncomeTime()); + } + if (this.isset_warehouseId) { + l_wh_form_procure.setWarehouseId(this.getWarehouseId()); + } + if (this.isset_beiz) { + l_wh_form_procure.setBeiz(this.getBeiz()); + } + if (this.isset_lWarehouseFlowId) { + l_wh_form_procure.setLWarehouseFlowId(this.getLWarehouseFlowId()); + } + return l_wh_form_procure; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcureGoods.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcureGoods.java new file mode 100644 index 0000000..9f54f4d --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcureGoods.java @@ -0,0 +1,216 @@ + +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_PROCURE_GOODS * + * @author genrator + */ +@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY) +public class LWhFormProcureGoods extends BasePo<LWhFormProcureGoods> { + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + // 涓婚敭 + private Long id = null; + @JsonIgnore + protected boolean isset_id = false; + + // 灞炴�у垪琛� + private Long whFormProcureId = null; + @JsonIgnore + protected boolean isset_whFormProcureId = false; + + private Long baseCategoryId = null; + @JsonIgnore + protected boolean isset_baseCategoryId = false; + + private Long baseGoodsTemplateId = null; + @JsonIgnore + protected boolean isset_baseGoodsTemplateId = false; + + private String goodsTemplateName = null; + @JsonIgnore + protected boolean isset_goodsTemplateName = false; + + private String supplier = null; + @JsonIgnore + protected boolean isset_supplier = false; + + private Integer sort = null; + @JsonIgnore + protected boolean isset_sort = false; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public LWhFormProcureGoods() { + } + + /** + * 鏍规嵁涓婚敭鏋勯�犲璞� + */ + public LWhFormProcureGoods(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 getWhFormProcureId() { + return this.whFormProcureId; + } + + public void setWhFormProcureId(Long whFormProcureId) { + this.whFormProcureId = whFormProcureId; + this.isset_whFormProcureId = true; + } + + @JsonIgnore + public boolean isEmptyWhFormProcureId() { + return this.whFormProcureId == null; + } + + public Long getBaseCategoryId() { + return this.baseCategoryId; + } + + public void setBaseCategoryId(Long baseCategoryId) { + this.baseCategoryId = baseCategoryId; + this.isset_baseCategoryId = true; + } + + @JsonIgnore + public boolean isEmptyBaseCategoryId() { + return this.baseCategoryId == 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 getSupplier() { + return this.supplier; + } + + public void setSupplier(String supplier) { + this.supplier = supplier; + this.isset_supplier = true; + } + + @JsonIgnore + public boolean isEmptySupplier() { + return this.supplier == null || this.supplier.length() == 0; + } + + public Integer getSort() { + return this.sort; + } + + public void setSort(Integer 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("whFormProcureId=").append(this.whFormProcureId) + .append("baseCategoryId=").append(this.baseCategoryId) + .append("baseGoodsTemplateId=").append(this.baseGoodsTemplateId) + .append("goodsTemplateName=").append(this.goodsTemplateName) + .append("supplier=").append(this.supplier) + .append("sort=").append(this.sort) + .toString(); + } + + /** + * 鍏嬮殕 + */ + public LWhFormProcureGoods $clone() { + LWhFormProcureGoods l_wh_form_procure_goods = new LWhFormProcureGoods(); + + // 鏁版嵁搴撳悕绉� + //l_wh_form_procure_goods.setDatabaseName_(this.getDatabaseName_()); + + // 涓婚敭 + if (this.isset_id) { + l_wh_form_procure_goods.setId(this.getId()); + } + // 鏅�氬睘鎬� + if (this.isset_whFormProcureId) { + l_wh_form_procure_goods.setWhFormProcureId(this.getWhFormProcureId()); + } + if (this.isset_baseCategoryId) { + l_wh_form_procure_goods.setBaseCategoryId(this.getBaseCategoryId()); + } + if (this.isset_baseGoodsTemplateId) { + l_wh_form_procure_goods.setBaseGoodsTemplateId(this.getBaseGoodsTemplateId()); + } + if (this.isset_goodsTemplateName) { + l_wh_form_procure_goods.setGoodsTemplateName(this.getGoodsTemplateName()); + } + if (this.isset_supplier) { + l_wh_form_procure_goods.setSupplier(this.getSupplier()); + } + if (this.isset_sort) { + l_wh_form_procure_goods.setSort(this.getSort()); + } + return l_wh_form_procure_goods; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcureGoods_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcureGoods_mapper.java new file mode 100644 index 0000000..de48a8a --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcureGoods_mapper.java @@ -0,0 +1,297 @@ +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_PROCURE_GOODS * + * @author genrator + */ +public class LWhFormProcureGoods_mapper extends LWhFormProcureGoods implements BaseMapper<LWhFormProcureGoods> { + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + public static final RowMapper<LWhFormProcureGoods> ROW_MAPPER = new LWhFormProcureGoodsRowMapper(); + + // 涓婚敭 + public static final String Id = "id"; + // 鏅�氬睘鎬� + public static final String WhFormProcureId = "wh_form_procure_id"; + public static final String BaseCategoryId = "base_category_id"; + public static final String BaseGoodsTemplateId = "base_goods_template_id"; + public static final String GoodsTemplateName = "goods_template_name"; + public static final String Supplier = "supplier"; + public static final String Sort = "sort"; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public LWhFormProcureGoods_mapper(LWhFormProcureGoods lWhFormProcureGoods) { + if (lWhFormProcureGoods == null) { + throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒"); + } + //涓婚敭 + if (lWhFormProcureGoods.isset_id) { + this.setId(lWhFormProcureGoods.getId()); + } + //鏅�氬睘鎬� + if (lWhFormProcureGoods.isset_whFormProcureId) { + this.setWhFormProcureId(lWhFormProcureGoods.getWhFormProcureId()); + } + if (lWhFormProcureGoods.isset_baseCategoryId) { + this.setBaseCategoryId(lWhFormProcureGoods.getBaseCategoryId()); + } + if (lWhFormProcureGoods.isset_baseGoodsTemplateId) { + this.setBaseGoodsTemplateId(lWhFormProcureGoods.getBaseGoodsTemplateId()); + } + if (lWhFormProcureGoods.isset_goodsTemplateName) { + this.setGoodsTemplateName(lWhFormProcureGoods.getGoodsTemplateName()); + } + if (lWhFormProcureGoods.isset_supplier) { + this.setSupplier(lWhFormProcureGoods.getSupplier()); + } + if (lWhFormProcureGoods.isset_sort) { + this.setSort(lWhFormProcureGoods.getSort()); + } + // 鍘绘帀锛�2022-09-07 + // this.setDatabaseName_(l_wh_form_procure_goods.getDatabaseName_()); + } + + /** + * 鑾峰彇琛ㄥ悕 + */ + @Override + public String getTableName_() { + String tableName = "l_wh_form_procure_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(WhFormProcureId, this.getWhFormProcureId(), this.isset_whFormProcureId); + ib.set(BaseCategoryId, this.getBaseCategoryId(), this.isset_baseCategoryId); + ib.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ib.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName); + ib.set(Supplier, this.getSupplier(), this.isset_supplier); + 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(WhFormProcureId, this.getWhFormProcureId(), this.isset_whFormProcureId); + ub.set(BaseCategoryId, this.getBaseCategoryId(), this.isset_baseCategoryId); + ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName); + ub.set(Supplier, this.getSupplier(), this.isset_supplier); + 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(WhFormProcureId, this.getWhFormProcureId(), this.isset_whFormProcureId); + ub.set(BaseCategoryId, this.getBaseCategoryId(), this.isset_baseCategoryId); + ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName); + ub.set(Supplier, this.getSupplier(), this.isset_supplier); + 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(WhFormProcureId, this.getWhFormProcureId(), this.isset_whFormProcureId); + ub.set(BaseCategoryId, this.getBaseCategoryId(), this.isset_baseCategoryId); + ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName); + ub.set(Supplier, this.getSupplier(), this.isset_supplier); + 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, wh_form_procure_id, base_category_id, base_goods_template_id, goods_template_name, supplier, sort from " + this.getTableName_() + " " + where, parameters); + } + + /** + * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { + return new SqlAndParameters<>("select id, wh_form_procure_id, base_category_id, base_goods_template_id, goods_template_name, supplier, sort from " + this.getTableName_() + " " + where, parameters); + } + + /** + * 灏唕esultset鐨勪竴琛岃浆鍖栦负po + */ + @Override + public LWhFormProcureGoods mapRow(ResultSet rs, int i) throws SQLException { + return ROW_MAPPER.mapRow(rs, i); + } + + /** + * 鍏嬮殕 + */ + public LWhFormProcureGoods toLWhFormProcureGoods() { + return super.$clone(); + } +} + +/** + * l_wh_form_procure_goods RowMapper + * + * @author genrator + */ +class LWhFormProcureGoodsRowMapper implements RowMapper<LWhFormProcureGoods> { + + @Override + public LWhFormProcureGoods mapRow(ResultSet rs, int i) throws SQLException { + ResultSetUtils resultSetUtils = new ResultSetUtils(); + LWhFormProcureGoods l_wh_form_procure_goods = new LWhFormProcureGoods(); + Integer columnIndex; + //涓婚敭 + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcureGoods_mapper.Id); + if (columnIndex > 0) { + l_wh_form_procure_goods.setId(rs.getLong(columnIndex)); + } + //鏅�氬睘鎬� + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcureGoods_mapper.WhFormProcureId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_form_procure_goods.setWhFormProcureId(null); + } else { + l_wh_form_procure_goods.setWhFormProcureId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcureGoods_mapper.BaseCategoryId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_form_procure_goods.setBaseCategoryId(null); + } else { + l_wh_form_procure_goods.setBaseCategoryId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcureGoods_mapper.BaseGoodsTemplateId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_form_procure_goods.setBaseGoodsTemplateId(null); + } else { + l_wh_form_procure_goods.setBaseGoodsTemplateId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcureGoods_mapper.GoodsTemplateName); + if (columnIndex > 0) { + l_wh_form_procure_goods.setGoodsTemplateName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcureGoods_mapper.Supplier); + if (columnIndex > 0) { + l_wh_form_procure_goods.setSupplier(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcureGoods_mapper.Sort); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_form_procure_goods.setSort(null); + } else { + l_wh_form_procure_goods.setSort(rs.getInt(columnIndex)); + } + } + return l_wh_form_procure_goods; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcure_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcure_mapper.java new file mode 100644 index 0000000..5762b0a --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhFormProcure_mapper.java @@ -0,0 +1,437 @@ +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_PROCURE * + * @author genrator + */ +public class LWhFormProcure_mapper extends LWhFormProcure implements BaseMapper<LWhFormProcure> { + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + public static final RowMapper<LWhFormProcure> ROW_MAPPER = new LWhFormProcureRowMapper(); + + // 涓婚敭 + public static final String Id = "id"; + // 鏅�氬睘鎬� + public static final String BusinessFormCode = "business_form_code"; + public static final String WarehouseName = "warehouse_name"; + public static final String BuyerId = "buyer_id"; + public static final String BuyerName = "buyer_name"; + public static final String ProcureTime = "procure_time"; + public static final String ProcureDoc = "procure_doc"; + public static final String BuyType = "buy_type"; + public static final String States = "states"; + public static final String AgencyId = "agency_id"; + public static final String AgencyName = "agency_name"; + public static final String IncomeId = "income_id"; + public static final String IncomeName = "income_name"; + public static final String IncomeTime = "income_time"; + public static final String WarehouseId = "warehouse_id"; + public static final String Beiz = "beiz"; + public static final String LWarehouseFlowId = "l_warehouse_flow_id"; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public LWhFormProcure_mapper(LWhFormProcure lWhFormProcure) { + if (lWhFormProcure == null) { + throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒"); + } + //涓婚敭 + if (lWhFormProcure.isset_id) { + this.setId(lWhFormProcure.getId()); + } + //鏅�氬睘鎬� + if (lWhFormProcure.isset_businessFormCode) { + this.setBusinessFormCode(lWhFormProcure.getBusinessFormCode()); + } + if (lWhFormProcure.isset_warehouseName) { + this.setWarehouseName(lWhFormProcure.getWarehouseName()); + } + if (lWhFormProcure.isset_buyerId) { + this.setBuyerId(lWhFormProcure.getBuyerId()); + } + if (lWhFormProcure.isset_buyerName) { + this.setBuyerName(lWhFormProcure.getBuyerName()); + } + if (lWhFormProcure.isset_procureTime) { + this.setProcureTime(lWhFormProcure.getProcureTime()); + } + if (lWhFormProcure.isset_procureDoc) { + this.setProcureDoc(lWhFormProcure.getProcureDoc()); + } + if (lWhFormProcure.isset_buyType) { + this.setBuyType(lWhFormProcure.getBuyType()); + } + if (lWhFormProcure.isset_states) { + this.setStates(lWhFormProcure.getStates()); + } + if (lWhFormProcure.isset_agencyId) { + this.setAgencyId(lWhFormProcure.getAgencyId()); + } + if (lWhFormProcure.isset_agencyName) { + this.setAgencyName(lWhFormProcure.getAgencyName()); + } + if (lWhFormProcure.isset_incomeId) { + this.setIncomeId(lWhFormProcure.getIncomeId()); + } + if (lWhFormProcure.isset_incomeName) { + this.setIncomeName(lWhFormProcure.getIncomeName()); + } + if (lWhFormProcure.isset_incomeTime) { + this.setIncomeTime(lWhFormProcure.getIncomeTime()); + } + if (lWhFormProcure.isset_warehouseId) { + this.setWarehouseId(lWhFormProcure.getWarehouseId()); + } + if (lWhFormProcure.isset_beiz) { + this.setBeiz(lWhFormProcure.getBeiz()); + } + if (lWhFormProcure.isset_lWarehouseFlowId) { + this.setLWarehouseFlowId(lWhFormProcure.getLWarehouseFlowId()); + } + // 鍘绘帀锛�2022-09-07 + // this.setDatabaseName_(l_wh_form_procure.getDatabaseName_()); + } + + /** + * 鑾峰彇琛ㄥ悕 + */ + @Override + public String getTableName_() { + String tableName = "l_wh_form_procure"; + /** + if (StringUtils.isNotEmpty(this.getDatabaseName_())) { + return this.getDatabaseName_() + "." + tableName; + } else { + return tableName; + } + */ + return tableName; + } + + /** + * 鑾峰彇涓婚敭鍚嶇О + */ + @Override + public String getPkName_() { + return Id; + } + + /** + * 鑾峰彇涓婚敭鍊� + */ + @Override + public Object getPkValue_() { + return this.getId(); + } + + /** + * 鑾峰彇鎻掑叆璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Map<String, Object>> getInsertSql_() { + InsertBuilder ib = new InsertBuilder(this.getTableName_()); + ib.set(Id, this.getId()); + ib.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); + ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); + ib.set(BuyerId, this.getBuyerId(), this.isset_buyerId); + ib.set(BuyerName, this.getBuyerName(), this.isset_buyerName); + ib.set(ProcureTime, this.getProcureTime(), this.isset_procureTime); + ib.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc); + ib.set(BuyType, this.getBuyType(), this.isset_buyType); + ib.set(States, this.getStates(), this.isset_states); + ib.set(AgencyId, this.getAgencyId(), this.isset_agencyId); + ib.set(AgencyName, this.getAgencyName(), this.isset_agencyName); + ib.set(IncomeId, this.getIncomeId(), this.isset_incomeId); + ib.set(IncomeName, this.getIncomeName(), this.isset_incomeName); + ib.set(IncomeTime, this.getIncomeTime(), this.isset_incomeTime); + ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); + ib.set(Beiz, this.getBeiz(), this.isset_beiz); + ib.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); + return ib.genMapSql(); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Map<String, Object>> getUpdateSql_() { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); + ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); + ub.set(BuyerId, this.getBuyerId(), this.isset_buyerId); + ub.set(BuyerName, this.getBuyerName(), this.isset_buyerName); + ub.set(ProcureTime, this.getProcureTime(), this.isset_procureTime); + ub.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc); + ub.set(BuyType, this.getBuyType(), this.isset_buyType); + ub.set(States, this.getStates(), this.isset_states); + ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId); + ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); + ub.set(IncomeId, this.getIncomeId(), this.isset_incomeId); + ub.set(IncomeName, this.getIncomeName(), this.isset_incomeName); + ub.set(IncomeTime, this.getIncomeTime(), this.isset_incomeTime); + ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); + ub.set(Beiz, this.getBeiz(), this.isset_beiz); + ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); + ub.where(this.getPkName_(), this.getPkValue_()); + return ub.genMapSql(); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); + ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); + ub.set(BuyerId, this.getBuyerId(), this.isset_buyerId); + ub.set(BuyerName, this.getBuyerName(), this.isset_buyerName); + ub.set(ProcureTime, this.getProcureTime(), this.isset_procureTime); + ub.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc); + ub.set(BuyType, this.getBuyType(), this.isset_buyType); + ub.set(States, this.getStates(), this.isset_states); + ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId); + ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); + ub.set(IncomeId, this.getIncomeId(), this.isset_incomeId); + ub.set(IncomeName, this.getIncomeName(), this.isset_incomeName); + ub.set(IncomeTime, this.getIncomeTime(), this.isset_incomeTime); + ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); + ub.set(Beiz, this.getBeiz(), this.isset_beiz); + ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); + return ub.genMapSql(where, parameters); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(BusinessFormCode, this.getBusinessFormCode(), this.isset_businessFormCode); + ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); + ub.set(BuyerId, this.getBuyerId(), this.isset_buyerId); + ub.set(BuyerName, this.getBuyerName(), this.isset_buyerName); + ub.set(ProcureTime, this.getProcureTime(), this.isset_procureTime); + ub.set(ProcureDoc, this.getProcureDoc(), this.isset_procureDoc); + ub.set(BuyType, this.getBuyType(), this.isset_buyType); + ub.set(States, this.getStates(), this.isset_states); + ub.set(AgencyId, this.getAgencyId(), this.isset_agencyId); + ub.set(AgencyName, this.getAgencyName(), this.isset_agencyName); + ub.set(IncomeId, this.getIncomeId(), this.isset_incomeId); + ub.set(IncomeName, this.getIncomeName(), this.isset_incomeName); + ub.set(IncomeTime, this.getIncomeTime(), this.isset_incomeTime); + ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); + ub.set(Beiz, this.getBeiz(), this.isset_beiz); + ub.set(LWarehouseFlowId, this.getLWarehouseFlowId(), this.isset_lWarehouseFlowId); + return ub.genArraySql(where, parameters); + } + + /** + * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Map<String, Object>> getDeleteSql_() { + DeleteBuilder db = new DeleteBuilder(this.getTableName_()); + db.where(this.getPkName_(), this.getPkValue_()); + return db.genMapSql(); + } + + /** + * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Map<String, Object>> getDeleteSql_(String where, Map<String, Object> parameters) { + DeleteBuilder db = new DeleteBuilder(this.getTableName_()); + return db.genMapSql(where, parameters); + } + + /** + * 鑾峰彇鍒犻櫎璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getDeleteSql_(String where, Object[] parameters) { + DeleteBuilder db = new DeleteBuilder(this.getTableName_()); + return db.genArraySql(where, parameters); + } + + /** + * 鑾峰彇鍗曡鏌ヨ璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Map<String, Object>> getSingleSql_() { + SelectBuilder sb = new SelectBuilder(this.getTableName_()); + sb.where(this.getPkName_(), this.getPkValue_()); + return sb.genMapSql(); + } + + + /** + * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { + return new SqlAndParameters<>("select id, business_form_code, warehouse_name, buyer_id, buyer_name, procure_time, procure_doc, buy_type, states, agency_id, agency_name, income_id, income_name, income_time, warehouse_id, beiz, l_warehouse_flow_id from " + this.getTableName_() + " " + where, parameters); + } + + /** + * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { + return new SqlAndParameters<>("select id, business_form_code, warehouse_name, buyer_id, buyer_name, procure_time, procure_doc, buy_type, states, agency_id, agency_name, income_id, income_name, income_time, warehouse_id, beiz, l_warehouse_flow_id from " + this.getTableName_() + " " + where, parameters); + } + + /** + * 灏唕esultset鐨勪竴琛岃浆鍖栦负po + */ + @Override + public LWhFormProcure mapRow(ResultSet rs, int i) throws SQLException { + return ROW_MAPPER.mapRow(rs, i); + } + + /** + * 鍏嬮殕 + */ + public LWhFormProcure toLWhFormProcure() { + return super.$clone(); + } +} + +/** + * l_wh_form_procure RowMapper + * + * @author genrator + */ +class LWhFormProcureRowMapper implements RowMapper<LWhFormProcure> { + + @Override + public LWhFormProcure mapRow(ResultSet rs, int i) throws SQLException { + ResultSetUtils resultSetUtils = new ResultSetUtils(); + LWhFormProcure l_wh_form_procure = new LWhFormProcure(); + Integer columnIndex; + //涓婚敭 + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.Id); + if (columnIndex > 0) { + l_wh_form_procure.setId(rs.getLong(columnIndex)); + } + //鏅�氬睘鎬� + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.BusinessFormCode); + if (columnIndex > 0) { + l_wh_form_procure.setBusinessFormCode(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.WarehouseName); + if (columnIndex > 0) { + l_wh_form_procure.setWarehouseName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.BuyerId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_form_procure.setBuyerId(null); + } else { + l_wh_form_procure.setBuyerId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.BuyerName); + if (columnIndex > 0) { + l_wh_form_procure.setBuyerName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.ProcureTime); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_form_procure.setProcureTime(null); + } else { + l_wh_form_procure.setProcureTime(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.ProcureDoc); + if (columnIndex > 0) { + l_wh_form_procure.setProcureDoc(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.BuyType); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_form_procure.setBuyType(null); + } else { + l_wh_form_procure.setBuyType(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.States); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_form_procure.setStates(null); + } else { + l_wh_form_procure.setStates(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.AgencyId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_form_procure.setAgencyId(null); + } else { + l_wh_form_procure.setAgencyId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.AgencyName); + if (columnIndex > 0) { + l_wh_form_procure.setAgencyName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.IncomeId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_form_procure.setIncomeId(null); + } else { + l_wh_form_procure.setIncomeId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.IncomeName); + if (columnIndex > 0) { + l_wh_form_procure.setIncomeName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.IncomeTime); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_form_procure.setIncomeTime(null); + } else { + l_wh_form_procure.setIncomeTime(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.WarehouseId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_form_procure.setWarehouseId(null); + } else { + l_wh_form_procure.setWarehouseId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.Beiz); + if (columnIndex > 0) { + l_wh_form_procure.setBeiz(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWhFormProcure_mapper.LWarehouseFlowId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_form_procure.setLWarehouseFlowId(null); + } else { + l_wh_form_procure.setLWarehouseFlowId(rs.getLong(columnIndex)); + } + } + return l_wh_form_procure; + } +} 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 new file mode 100644 index 0000000..391c973 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods.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_GOODS * + * @author genrator + */ +@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY) +public class LWhGoods extends BasePo<LWhGoods> { + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + // 涓婚敭 + private Long id = null; + @JsonIgnore + protected boolean isset_id = false; + + // 灞炴�у垪琛� + private Long warehouseId = null; + @JsonIgnore + protected boolean isset_warehouseId = false; + + private String warehouseName = null; + @JsonIgnore + protected boolean isset_warehouseName = false; + + private Integer costType = null; + @JsonIgnore + protected boolean isset_costType = false; + + private Long baseGoodsTemplateId = null; + @JsonIgnore + protected boolean isset_baseGoodsTemplateId = false; + + private String goodsTemplateName = null; + @JsonIgnore + protected boolean isset_goodsTemplateName = false; + + private Long baseGoodsModelsId = null; + @JsonIgnore + protected boolean isset_baseGoodsModelsId = false; + + private String baseGoodsModelsName = null; + @JsonIgnore + protected boolean isset_baseGoodsModelsName = false; + + private String supplier = null; + @JsonIgnore + protected boolean isset_supplier = false; + + private Integer buyType = null; + @JsonIgnore + protected boolean isset_buyType = false; + + private String unit = null; + @JsonIgnore + protected boolean isset_unit = false; + + private Double price = null; + @JsonIgnore + protected boolean isset_price = false; + + private Long procureDate = null; + @JsonIgnore + protected boolean isset_procureDate = false; + + private Integer states = null; + @JsonIgnore + protected boolean isset_states = false; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public LWhGoods() { + } + + /** + * 鏍规嵁涓婚敭鏋勯�犲璞� + */ + public LWhGoods(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 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 getCostType() { + return this.costType; + } + + public void setCostType(Integer costType) { + this.costType = costType; + this.isset_costType = true; + } + + @JsonIgnore + public boolean isEmptyCostType() { + return this.costType == 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 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 String getSupplier() { + return this.supplier; + } + + public void setSupplier(String supplier) { + this.supplier = supplier; + this.isset_supplier = true; + } + + @JsonIgnore + public boolean isEmptySupplier() { + return this.supplier == null || this.supplier.length() == 0; + } + + public Integer getBuyType() { + return this.buyType; + } + + public void setBuyType(Integer buyType) { + this.buyType = buyType; + this.isset_buyType = true; + } + + @JsonIgnore + public boolean isEmptyBuyType() { + return this.buyType == null; + } + + 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 Double getPrice() { + return this.price; + } + + public void setPrice(Double price) { + this.price = price; + this.isset_price = true; + } + + @JsonIgnore + public boolean isEmptyPrice() { + return this.price == null; + } + + public Long getProcureDate() { + return this.procureDate; + } + + public void setProcureDate(Long procureDate) { + this.procureDate = procureDate; + this.isset_procureDate = true; + } + + @JsonIgnore + public boolean isEmptyProcureDate() { + return this.procureDate == null; + } + + public Integer getStates() { + return this.states; + } + + public void setStates(Integer states) { + this.states = states; + this.isset_states = true; + } + + @JsonIgnore + public boolean isEmptyStates() { + return this.states == null; + } + + /** + * 閲嶅啓 toString() 鏂规硶 + */ + @Override + public String toString() { + return new StringBuilder() + .append("id=").append(this.id) + .append("warehouseId=").append(this.warehouseId) + .append("warehouseName=").append(this.warehouseName) + .append("costType=").append(this.costType) + .append("baseGoodsTemplateId=").append(this.baseGoodsTemplateId) + .append("goodsTemplateName=").append(this.goodsTemplateName) + .append("baseGoodsModelsId=").append(this.baseGoodsModelsId) + .append("baseGoodsModelsName=").append(this.baseGoodsModelsName) + .append("supplier=").append(this.supplier) + .append("buyType=").append(this.buyType) + .append("unit=").append(this.unit) + .append("price=").append(this.price) + .append("procureDate=").append(this.procureDate) + .append("states=").append(this.states) + .toString(); + } + + /** + * 鍏嬮殕 + */ + public LWhGoods $clone() { + LWhGoods l_wh_goods = new LWhGoods(); + + // 鏁版嵁搴撳悕绉� + //l_wh_goods.setDatabaseName_(this.getDatabaseName_()); + + // 涓婚敭 + if (this.isset_id) { + l_wh_goods.setId(this.getId()); + } + // 鏅�氬睘鎬� + if (this.isset_warehouseId) { + l_wh_goods.setWarehouseId(this.getWarehouseId()); + } + if (this.isset_warehouseName) { + l_wh_goods.setWarehouseName(this.getWarehouseName()); + } + if (this.isset_costType) { + l_wh_goods.setCostType(this.getCostType()); + } + if (this.isset_baseGoodsTemplateId) { + l_wh_goods.setBaseGoodsTemplateId(this.getBaseGoodsTemplateId()); + } + if (this.isset_goodsTemplateName) { + l_wh_goods.setGoodsTemplateName(this.getGoodsTemplateName()); + } + if (this.isset_baseGoodsModelsId) { + l_wh_goods.setBaseGoodsModelsId(this.getBaseGoodsModelsId()); + } + if (this.isset_baseGoodsModelsName) { + l_wh_goods.setBaseGoodsModelsName(this.getBaseGoodsModelsName()); + } + if (this.isset_supplier) { + l_wh_goods.setSupplier(this.getSupplier()); + } + if (this.isset_buyType) { + l_wh_goods.setBuyType(this.getBuyType()); + } + if (this.isset_unit) { + l_wh_goods.setUnit(this.getUnit()); + } + if (this.isset_price) { + l_wh_goods.setPrice(this.getPrice()); + } + if (this.isset_procureDate) { + l_wh_goods.setProcureDate(this.getProcureDate()); + } + if (this.isset_states) { + l_wh_goods.setStates(this.getStates()); + } + return l_wh_goods; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecord.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecord.java new file mode 100644 index 0000000..6e5f7b7 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecord.java @@ -0,0 +1,304 @@ + +package com.consum.model.po; + +import com.fasterxml.jackson.annotation.JsonAutoDetect; +import com.fasterxml.jackson.annotation.JsonIgnore; +import com.walker.jdbc.BasePo; + +/** + * 琛ㄥ悕:L_WH_GOODS_RECORD * + * @author genrator + */ +@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY) +public class LWhGoodsRecord extends BasePo<LWhGoodsRecord> { + // 搴忓垪鍖栫増鏈彿 + 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 Long warehouseFlowId = null; + @JsonIgnore + protected boolean isset_warehouseFlowId = false; + + private Integer initialCount = null; + @JsonIgnore + protected boolean isset_initialCount = false; + + private Integer thisType = null; + @JsonIgnore + protected boolean isset_thisType = false; + + private Integer thisCount = null; + @JsonIgnore + protected boolean isset_thisCount = false; + + private Integer endCount = null; + @JsonIgnore + protected boolean isset_endCount = false; + + private Long baseGoodsTemplateId = null; + @JsonIgnore + protected boolean isset_baseGoodsTemplateId = false; + + private String goodsTemplateName = null; + @JsonIgnore + protected boolean isset_goodsTemplateName = false; + + private Long baseGoodsModelsId = null; + @JsonIgnore + protected boolean isset_baseGoodsModelsId = false; + + private String baseGoodsModelsName = null; + @JsonIgnore + protected boolean isset_baseGoodsModelsName = false; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public LWhGoodsRecord() { + } + + /** + * 鏍规嵁涓婚敭鏋勯�犲璞� + */ + public LWhGoodsRecord(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 Long getWarehouseFlowId() { + return this.warehouseFlowId; + } + + public void setWarehouseFlowId(Long warehouseFlowId) { + this.warehouseFlowId = warehouseFlowId; + this.isset_warehouseFlowId = true; + } + + @JsonIgnore + public boolean isEmptyWarehouseFlowId() { + return this.warehouseFlowId == null; + } + + public Integer getInitialCount() { + return this.initialCount; + } + + public void setInitialCount(Integer initialCount) { + this.initialCount = initialCount; + this.isset_initialCount = true; + } + + @JsonIgnore + public boolean isEmptyInitialCount() { + return this.initialCount == null; + } + + public Integer getThisType() { + return this.thisType; + } + + public void setThisType(Integer thisType) { + this.thisType = thisType; + this.isset_thisType = true; + } + + @JsonIgnore + public boolean isEmptyThisType() { + return this.thisType == null; + } + + public Integer getThisCount() { + return this.thisCount; + } + + public void setThisCount(Integer thisCount) { + this.thisCount = thisCount; + this.isset_thisCount = true; + } + + @JsonIgnore + public boolean isEmptyThisCount() { + return this.thisCount == null; + } + + public Integer getEndCount() { + return this.endCount; + } + + public void setEndCount(Integer endCount) { + this.endCount = endCount; + this.isset_endCount = true; + } + + @JsonIgnore + public boolean isEmptyEndCount() { + return this.endCount == 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 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; + } + + /** + * 閲嶅啓 toString() 鏂规硶 + */ + @Override + public String toString() { + return new StringBuilder() + .append("id=").append(this.id) + .append("lWarehouseFlowId=").append(this.lWarehouseFlowId) + .append("warehouseFlowId=").append(this.warehouseFlowId) + .append("initialCount=").append(this.initialCount) + .append("thisType=").append(this.thisType) + .append("thisCount=").append(this.thisCount) + .append("endCount=").append(this.endCount) + .append("baseGoodsTemplateId=").append(this.baseGoodsTemplateId) + .append("goodsTemplateName=").append(this.goodsTemplateName) + .append("baseGoodsModelsId=").append(this.baseGoodsModelsId) + .append("baseGoodsModelsName=").append(this.baseGoodsModelsName) + .toString(); + } + + /** + * 鍏嬮殕 + */ + public LWhGoodsRecord $clone() { + LWhGoodsRecord l_wh_goods_record = new LWhGoodsRecord(); + + // 鏁版嵁搴撳悕绉� + //l_wh_goods_record.setDatabaseName_(this.getDatabaseName_()); + + // 涓婚敭 + if (this.isset_id) { + l_wh_goods_record.setId(this.getId()); + } + // 鏅�氬睘鎬� + if (this.isset_lWarehouseFlowId) { + l_wh_goods_record.setLWarehouseFlowId(this.getLWarehouseFlowId()); + } + if (this.isset_warehouseFlowId) { + l_wh_goods_record.setWarehouseFlowId(this.getWarehouseFlowId()); + } + if (this.isset_initialCount) { + l_wh_goods_record.setInitialCount(this.getInitialCount()); + } + if (this.isset_thisType) { + l_wh_goods_record.setThisType(this.getThisType()); + } + if (this.isset_thisCount) { + l_wh_goods_record.setThisCount(this.getThisCount()); + } + if (this.isset_endCount) { + l_wh_goods_record.setEndCount(this.getEndCount()); + } + if (this.isset_baseGoodsTemplateId) { + l_wh_goods_record.setBaseGoodsTemplateId(this.getBaseGoodsTemplateId()); + } + if (this.isset_goodsTemplateName) { + l_wh_goods_record.setGoodsTemplateName(this.getGoodsTemplateName()); + } + if (this.isset_baseGoodsModelsId) { + l_wh_goods_record.setBaseGoodsModelsId(this.getBaseGoodsModelsId()); + } + if (this.isset_baseGoodsModelsName) { + l_wh_goods_record.setBaseGoodsModelsName(this.getBaseGoodsModelsName()); + } + return l_wh_goods_record; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecordDetails.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecordDetails.java new file mode 100644 index 0000000..b092290 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecordDetails.java @@ -0,0 +1,150 @@ + +package com.consum.model.po; + +import com.fasterxml.jackson.annotation.JsonAutoDetect; +import com.fasterxml.jackson.annotation.JsonIgnore; +import com.walker.jdbc.BasePo; + +/** + * 琛ㄥ悕:L_WH_GOODS_RECORD_DETAILS * + * @author genrator + */ +@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY) +public class LWhGoodsRecordDetails extends BasePo<LWhGoodsRecordDetails> { + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + // 涓婚敭 + private Long id = null; + @JsonIgnore + protected boolean isset_id = false; + + // 灞炴�у垪琛� + private Long lWhGoodsRecordId = null; + @JsonIgnore + protected boolean isset_lWhGoodsRecordId = false; + + private Long lWhGoodsId = null; + @JsonIgnore + protected boolean isset_lWhGoodsId = false; + + private Integer thisType = null; + @JsonIgnore + protected boolean isset_thisType = false; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public LWhGoodsRecordDetails() { + } + + /** + * 鏍规嵁涓婚敭鏋勯�犲璞� + */ + public LWhGoodsRecordDetails(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 getLWhGoodsRecordId() { + return this.lWhGoodsRecordId; + } + + public void setLWhGoodsRecordId(Long lWhGoodsRecordId) { + this.lWhGoodsRecordId = lWhGoodsRecordId; + this.isset_lWhGoodsRecordId = true; + } + + @JsonIgnore + public boolean isEmptyLWhGoodsRecordId() { + return this.lWhGoodsRecordId == null; + } + + public Long getLWhGoodsId() { + return this.lWhGoodsId; + } + + public void setLWhGoodsId(Long lWhGoodsId) { + this.lWhGoodsId = lWhGoodsId; + this.isset_lWhGoodsId = true; + } + + @JsonIgnore + public boolean isEmptyLWhGoodsId() { + return this.lWhGoodsId == null; + } + + public Integer getThisType() { + return this.thisType; + } + + public void setThisType(Integer thisType) { + this.thisType = thisType; + this.isset_thisType = true; + } + + @JsonIgnore + public boolean isEmptyThisType() { + return this.thisType == null; + } + + /** + * 閲嶅啓 toString() 鏂规硶 + */ + @Override + public String toString() { + return new StringBuilder() + .append("id=").append(this.id) + .append("lWhGoodsRecordId=").append(this.lWhGoodsRecordId) + .append("lWhGoodsId=").append(this.lWhGoodsId) + .append("thisType=").append(this.thisType) + .toString(); + } + + /** + * 鍏嬮殕 + */ + public LWhGoodsRecordDetails $clone() { + LWhGoodsRecordDetails l_wh_goods_record_details = new LWhGoodsRecordDetails(); + + // 鏁版嵁搴撳悕绉� + //l_wh_goods_record_details.setDatabaseName_(this.getDatabaseName_()); + + // 涓婚敭 + if (this.isset_id) { + l_wh_goods_record_details.setId(this.getId()); + } + // 鏅�氬睘鎬� + if (this.isset_lWhGoodsRecordId) { + l_wh_goods_record_details.setLWhGoodsRecordId(this.getLWhGoodsRecordId()); + } + if (this.isset_lWhGoodsId) { + l_wh_goods_record_details.setLWhGoodsId(this.getLWhGoodsId()); + } + if (this.isset_thisType) { + l_wh_goods_record_details.setThisType(this.getThisType()); + } + return l_wh_goods_record_details; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecordDetails_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecordDetails_mapper.java new file mode 100644 index 0000000..6433a09 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecordDetails_mapper.java @@ -0,0 +1,255 @@ +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 org.springframework.jdbc.core.RowMapper; + +import java.sql.ResultSet; +import java.sql.SQLException; +import java.util.Map; + +/** + * 琛ㄥ悕:L_WH_GOODS_RECORD_DETAILS * + * @author genrator + */ +public class LWhGoodsRecordDetails_mapper extends LWhGoodsRecordDetails implements BaseMapper<LWhGoodsRecordDetails> { + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + public static final RowMapper<LWhGoodsRecordDetails> ROW_MAPPER = new LWhGoodsRecordDetailsRowMapper(); + + // 涓婚敭 + public static final String Id = "id"; + // 鏅�氬睘鎬� + public static final String LWhGoodsRecordId = "l_wh_goods_record_id"; + public static final String LWhGoodsId = "l_wh_goods_id"; + public static final String ThisType = "this_type"; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public LWhGoodsRecordDetails_mapper(LWhGoodsRecordDetails lWhGoodsRecordDetails) { + if (lWhGoodsRecordDetails == null) { + throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒"); + } + //涓婚敭 + if (lWhGoodsRecordDetails.isset_id) { + this.setId(lWhGoodsRecordDetails.getId()); + } + //鏅�氬睘鎬� + if (lWhGoodsRecordDetails.isset_lWhGoodsRecordId) { + this.setLWhGoodsRecordId(lWhGoodsRecordDetails.getLWhGoodsRecordId()); + } + if (lWhGoodsRecordDetails.isset_lWhGoodsId) { + this.setLWhGoodsId(lWhGoodsRecordDetails.getLWhGoodsId()); + } + if (lWhGoodsRecordDetails.isset_thisType) { + this.setThisType(lWhGoodsRecordDetails.getThisType()); + } + // 鍘绘帀锛�2022-09-07 + // this.setDatabaseName_(l_wh_goods_record_details.getDatabaseName_()); + } + + /** + * 鑾峰彇琛ㄥ悕 + */ + @Override + public String getTableName_() { + String tableName = "l_wh_goods_record_details"; + /** + 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(LWhGoodsRecordId, this.getLWhGoodsRecordId(), this.isset_lWhGoodsRecordId); + ib.set(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId); + ib.set(ThisType, this.getThisType(), this.isset_thisType); + return ib.genMapSql(); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Map<String, Object>> getUpdateSql_() { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(LWhGoodsRecordId, this.getLWhGoodsRecordId(), this.isset_lWhGoodsRecordId); + ub.set(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId); + ub.set(ThisType, this.getThisType(), this.isset_thisType); + 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(LWhGoodsRecordId, this.getLWhGoodsRecordId(), this.isset_lWhGoodsRecordId); + ub.set(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId); + ub.set(ThisType, this.getThisType(), this.isset_thisType); + return ub.genMapSql(where, parameters); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(LWhGoodsRecordId, this.getLWhGoodsRecordId(), this.isset_lWhGoodsRecordId); + ub.set(LWhGoodsId, this.getLWhGoodsId(), this.isset_lWhGoodsId); + ub.set(ThisType, this.getThisType(), this.isset_thisType); + 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_wh_goods_record_id, l_wh_goods_id, this_type from " + this.getTableName_() + " " + where, parameters); + } + + /** + * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { + return new SqlAndParameters<>("select id, l_wh_goods_record_id, l_wh_goods_id, this_type from " + this.getTableName_() + " " + where, parameters); + } + + /** + * 灏唕esultset鐨勪竴琛岃浆鍖栦负po + */ + @Override + public LWhGoodsRecordDetails mapRow(ResultSet rs, int i) throws SQLException { + return ROW_MAPPER.mapRow(rs, i); + } + + /** + * 鍏嬮殕 + */ + public LWhGoodsRecordDetails toLWhGoodsRecordDetails() { + return super.$clone(); + } +} + +/** + * l_wh_goods_record_details RowMapper + * + * @author genrator + */ +class LWhGoodsRecordDetailsRowMapper implements RowMapper<LWhGoodsRecordDetails> { + + @Override + public LWhGoodsRecordDetails mapRow(ResultSet rs, int i) throws SQLException { + ResultSetUtils resultSetUtils = new ResultSetUtils(); + LWhGoodsRecordDetails l_wh_goods_record_details = new LWhGoodsRecordDetails(); + Integer columnIndex; + //涓婚敭 + columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecordDetails_mapper.Id); + if (columnIndex > 0) { + l_wh_goods_record_details.setId(rs.getLong(columnIndex)); + } + //鏅�氬睘鎬� + columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecordDetails_mapper.LWhGoodsRecordId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods_record_details.setLWhGoodsRecordId(null); + } else { + l_wh_goods_record_details.setLWhGoodsRecordId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecordDetails_mapper.LWhGoodsId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods_record_details.setLWhGoodsId(null); + } else { + l_wh_goods_record_details.setLWhGoodsId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecordDetails_mapper.ThisType); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods_record_details.setThisType(null); + } else { + l_wh_goods_record_details.setThisType(rs.getInt(columnIndex)); + } + } + return l_wh_goods_record_details; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecord_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecord_mapper.java new file mode 100644 index 0000000..1a2769a --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecord_mapper.java @@ -0,0 +1,361 @@ +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_GOODS_RECORD * + * @author genrator + */ +public class LWhGoodsRecord_mapper extends LWhGoodsRecord implements BaseMapper<LWhGoodsRecord> { + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + public static final RowMapper<LWhGoodsRecord> ROW_MAPPER = new LWhGoodsRecordRowMapper(); + + // 涓婚敭 + public static final String Id = "id"; + // 鏅�氬睘鎬� + public static final String LWarehouseFlowId = "l_warehouse_flow_id"; + public static final String WarehouseFlowId = "warehouse_flow_id"; + public static final String InitialCount = "initial_count"; + public static final String ThisType = "this_type"; + public static final String ThisCount = "this_count"; + public static final String EndCount = "end_count"; + public static final String BaseGoodsTemplateId = "base_goods_template_id"; + public static final String GoodsTemplateName = "goods_template_name"; + public static final String BaseGoodsModelsId = "base_goods_models_id"; + public static final String BaseGoodsModelsName = "base_goods_models_name"; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public LWhGoodsRecord_mapper(LWhGoodsRecord lWhGoodsRecord) { + if (lWhGoodsRecord == null) { + throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒"); + } + //涓婚敭 + if (lWhGoodsRecord.isset_id) { + this.setId(lWhGoodsRecord.getId()); + } + //鏅�氬睘鎬� + if (lWhGoodsRecord.isset_lWarehouseFlowId) { + this.setLWarehouseFlowId(lWhGoodsRecord.getLWarehouseFlowId()); + } + if (lWhGoodsRecord.isset_warehouseFlowId) { + this.setWarehouseFlowId(lWhGoodsRecord.getWarehouseFlowId()); + } + if (lWhGoodsRecord.isset_initialCount) { + this.setInitialCount(lWhGoodsRecord.getInitialCount()); + } + if (lWhGoodsRecord.isset_thisType) { + this.setThisType(lWhGoodsRecord.getThisType()); + } + if (lWhGoodsRecord.isset_thisCount) { + this.setThisCount(lWhGoodsRecord.getThisCount()); + } + if (lWhGoodsRecord.isset_endCount) { + this.setEndCount(lWhGoodsRecord.getEndCount()); + } + if (lWhGoodsRecord.isset_baseGoodsTemplateId) { + this.setBaseGoodsTemplateId(lWhGoodsRecord.getBaseGoodsTemplateId()); + } + if (lWhGoodsRecord.isset_goodsTemplateName) { + this.setGoodsTemplateName(lWhGoodsRecord.getGoodsTemplateName()); + } + if (lWhGoodsRecord.isset_baseGoodsModelsId) { + this.setBaseGoodsModelsId(lWhGoodsRecord.getBaseGoodsModelsId()); + } + if (lWhGoodsRecord.isset_baseGoodsModelsName) { + this.setBaseGoodsModelsName(lWhGoodsRecord.getBaseGoodsModelsName()); + } + // 鍘绘帀锛�2022-09-07 + // this.setDatabaseName_(l_wh_goods_record.getDatabaseName_()); + } + + /** + * 鑾峰彇琛ㄥ悕 + */ + @Override + public String getTableName_() { + String tableName = "l_wh_goods_record"; + /** + 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(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId); + ib.set(InitialCount, this.getInitialCount(), this.isset_initialCount); + ib.set(ThisType, this.getThisType(), this.isset_thisType); + ib.set(ThisCount, this.getThisCount(), this.isset_thisCount); + ib.set(EndCount, this.getEndCount(), this.isset_endCount); + ib.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ib.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName); + ib.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId); + ib.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName); + 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(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId); + ub.set(InitialCount, this.getInitialCount(), this.isset_initialCount); + ub.set(ThisType, this.getThisType(), this.isset_thisType); + ub.set(ThisCount, this.getThisCount(), this.isset_thisCount); + ub.set(EndCount, this.getEndCount(), this.isset_endCount); + ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName); + ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId); + ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName); + 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(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId); + ub.set(InitialCount, this.getInitialCount(), this.isset_initialCount); + ub.set(ThisType, this.getThisType(), this.isset_thisType); + ub.set(ThisCount, this.getThisCount(), this.isset_thisCount); + ub.set(EndCount, this.getEndCount(), this.isset_endCount); + ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName); + ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId); + ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName); + 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(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId); + ub.set(InitialCount, this.getInitialCount(), this.isset_initialCount); + ub.set(ThisType, this.getThisType(), this.isset_thisType); + ub.set(ThisCount, this.getThisCount(), this.isset_thisCount); + ub.set(EndCount, this.getEndCount(), this.isset_endCount); + ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName); + ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId); + ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName); + 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, warehouse_flow_id, initial_count, this_type, this_count, end_count, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name from " + this.getTableName_() + " " + where, parameters); + } + + /** + * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { + return new SqlAndParameters<>("select id, l_warehouse_flow_id, warehouse_flow_id, initial_count, this_type, this_count, end_count, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name from " + this.getTableName_() + " " + where, parameters); + } + + /** + * 灏唕esultset鐨勪竴琛岃浆鍖栦负po + */ + @Override + public LWhGoodsRecord mapRow(ResultSet rs, int i) throws SQLException { + return ROW_MAPPER.mapRow(rs, i); + } + + /** + * 鍏嬮殕 + */ + public LWhGoodsRecord toLWhGoodsRecord() { + return super.$clone(); + } +} + +/** + * l_wh_goods_record RowMapper + * + * @author genrator + */ +class LWhGoodsRecordRowMapper implements RowMapper<LWhGoodsRecord> { + + @Override + public LWhGoodsRecord mapRow(ResultSet rs, int i) throws SQLException { + ResultSetUtils resultSetUtils = new ResultSetUtils(); + LWhGoodsRecord l_wh_goods_record = new LWhGoodsRecord(); + Integer columnIndex; + //涓婚敭 + columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.Id); + if (columnIndex > 0) { + l_wh_goods_record.setId(rs.getLong(columnIndex)); + } + //鏅�氬睘鎬� + columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.LWarehouseFlowId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods_record.setLWarehouseFlowId(null); + } else { + l_wh_goods_record.setLWarehouseFlowId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.WarehouseFlowId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods_record.setWarehouseFlowId(null); + } else { + l_wh_goods_record.setWarehouseFlowId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.InitialCount); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods_record.setInitialCount(null); + } else { + l_wh_goods_record.setInitialCount(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.ThisType); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods_record.setThisType(null); + } else { + l_wh_goods_record.setThisType(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.ThisCount); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods_record.setThisCount(null); + } else { + l_wh_goods_record.setThisCount(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.EndCount); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods_record.setEndCount(null); + } else { + l_wh_goods_record.setEndCount(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.BaseGoodsTemplateId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods_record.setBaseGoodsTemplateId(null); + } else { + l_wh_goods_record.setBaseGoodsTemplateId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.GoodsTemplateName); + if (columnIndex > 0) { + l_wh_goods_record.setGoodsTemplateName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.BaseGoodsModelsId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods_record.setBaseGoodsModelsId(null); + } else { + l_wh_goods_record.setBaseGoodsModelsId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.BaseGoodsModelsName); + if (columnIndex > 0) { + l_wh_goods_record.setBaseGoodsModelsName(rs.getString(columnIndex)); + } + return l_wh_goods_record; + } +} 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 new file mode 100644 index 0000000..9fc5e76 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java @@ -0,0 +1,397 @@ +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_GOODS * + * @author genrator + */ +public class LWhGoods_mapper extends LWhGoods implements BaseMapper<LWhGoods> { + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + public static final RowMapper<LWhGoods> ROW_MAPPER = new LWhGoodsRowMapper(); + + // 涓婚敭 + public static final String Id = "id"; + // 鏅�氬睘鎬� + public static final String WarehouseId = "warehouse_id"; + public static final String WarehouseName = "warehouse_name"; + public static final String CostType = "cost_type"; + public static final String BaseGoodsTemplateId = "base_goods_template_id"; + public static final String GoodsTemplateName = "goods_template_name"; + public static final String BaseGoodsModelsId = "base_goods_models_id"; + public static final String BaseGoodsModelsName = "base_goods_models_name"; + public static final String Supplier = "supplier"; + public static final String BuyType = "buy_type"; + public static final String Unit = "unit"; + public static final String Price = "price"; + public static final String ProcureDate = "procure_date"; + public static final String States = "states"; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public LWhGoods_mapper(LWhGoods lWhGoods) { + if (lWhGoods == null) { + throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒"); + } + //涓婚敭 + if (lWhGoods.isset_id) { + this.setId(lWhGoods.getId()); + } + //鏅�氬睘鎬� + if (lWhGoods.isset_warehouseId) { + this.setWarehouseId(lWhGoods.getWarehouseId()); + } + if (lWhGoods.isset_warehouseName) { + this.setWarehouseName(lWhGoods.getWarehouseName()); + } + if (lWhGoods.isset_costType) { + this.setCostType(lWhGoods.getCostType()); + } + if (lWhGoods.isset_baseGoodsTemplateId) { + this.setBaseGoodsTemplateId(lWhGoods.getBaseGoodsTemplateId()); + } + if (lWhGoods.isset_goodsTemplateName) { + this.setGoodsTemplateName(lWhGoods.getGoodsTemplateName()); + } + if (lWhGoods.isset_baseGoodsModelsId) { + this.setBaseGoodsModelsId(lWhGoods.getBaseGoodsModelsId()); + } + if (lWhGoods.isset_baseGoodsModelsName) { + this.setBaseGoodsModelsName(lWhGoods.getBaseGoodsModelsName()); + } + if (lWhGoods.isset_supplier) { + this.setSupplier(lWhGoods.getSupplier()); + } + if (lWhGoods.isset_buyType) { + this.setBuyType(lWhGoods.getBuyType()); + } + if (lWhGoods.isset_unit) { + this.setUnit(lWhGoods.getUnit()); + } + if (lWhGoods.isset_price) { + this.setPrice(lWhGoods.getPrice()); + } + if (lWhGoods.isset_procureDate) { + this.setProcureDate(lWhGoods.getProcureDate()); + } + if (lWhGoods.isset_states) { + this.setStates(lWhGoods.getStates()); + } + // 鍘绘帀锛�2022-09-07 + // this.setDatabaseName_(l_wh_goods.getDatabaseName_()); + } + + /** + * 鑾峰彇琛ㄥ悕 + */ + @Override + public String getTableName_() { + String tableName = "l_wh_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(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); + ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); + ib.set(CostType, this.getCostType(), this.isset_costType); + ib.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ib.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName); + ib.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId); + ib.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName); + ib.set(Supplier, this.getSupplier(), this.isset_supplier); + ib.set(BuyType, this.getBuyType(), this.isset_buyType); + ib.set(Unit, this.getUnit(), this.isset_unit); + ib.set(Price, this.getPrice(), this.isset_price); + ib.set(ProcureDate, this.getProcureDate(), this.isset_procureDate); + 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(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); + ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); + ub.set(CostType, this.getCostType(), this.isset_costType); + ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName); + ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId); + ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName); + ub.set(Supplier, this.getSupplier(), this.isset_supplier); + ub.set(BuyType, this.getBuyType(), this.isset_buyType); + ub.set(Unit, this.getUnit(), this.isset_unit); + ub.set(Price, this.getPrice(), this.isset_price); + ub.set(ProcureDate, this.getProcureDate(), this.isset_procureDate); + 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(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); + ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); + ub.set(CostType, this.getCostType(), this.isset_costType); + ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName); + ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId); + ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName); + ub.set(Supplier, this.getSupplier(), this.isset_supplier); + ub.set(BuyType, this.getBuyType(), this.isset_buyType); + ub.set(Unit, this.getUnit(), this.isset_unit); + ub.set(Price, this.getPrice(), this.isset_price); + ub.set(ProcureDate, this.getProcureDate(), this.isset_procureDate); + 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(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); + ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName); + ub.set(CostType, this.getCostType(), this.isset_costType); + ub.set(BaseGoodsTemplateId, this.getBaseGoodsTemplateId(), this.isset_baseGoodsTemplateId); + ub.set(GoodsTemplateName, this.getGoodsTemplateName(), this.isset_goodsTemplateName); + ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId); + ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName); + ub.set(Supplier, this.getSupplier(), this.isset_supplier); + ub.set(BuyType, this.getBuyType(), this.isset_buyType); + ub.set(Unit, this.getUnit(), this.isset_unit); + ub.set(Price, this.getPrice(), this.isset_price); + ub.set(ProcureDate, this.getProcureDate(), this.isset_procureDate); + 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, 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); + } + + /** + * 灏唕esultset鐨勪竴琛岃浆鍖栦负po + */ + @Override + public LWhGoods mapRow(ResultSet rs, int i) throws SQLException { + return ROW_MAPPER.mapRow(rs, i); + } + + /** + * 鍏嬮殕 + */ + public LWhGoods toLWhGoods() { + return super.$clone(); + } +} + +/** + * l_wh_goods RowMapper + * + * @author genrator + */ +class LWhGoodsRowMapper implements RowMapper<LWhGoods> { + + @Override + public LWhGoods mapRow(ResultSet rs, int i) throws SQLException { + ResultSetUtils resultSetUtils = new ResultSetUtils(); + LWhGoods l_wh_goods = new LWhGoods(); + Integer columnIndex; + //涓婚敭 + columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.Id); + if (columnIndex > 0) { + l_wh_goods.setId(rs.getLong(columnIndex)); + } + //鏅�氬睘鎬� + columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.WarehouseId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods.setWarehouseId(null); + } else { + l_wh_goods.setWarehouseId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.WarehouseName); + if (columnIndex > 0) { + l_wh_goods.setWarehouseName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.CostType); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods.setCostType(null); + } else { + l_wh_goods.setCostType(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.BaseGoodsTemplateId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods.setBaseGoodsTemplateId(null); + } else { + l_wh_goods.setBaseGoodsTemplateId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.GoodsTemplateName); + if (columnIndex > 0) { + l_wh_goods.setGoodsTemplateName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.BaseGoodsModelsId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods.setBaseGoodsModelsId(null); + } else { + l_wh_goods.setBaseGoodsModelsId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.BaseGoodsModelsName); + if (columnIndex > 0) { + l_wh_goods.setBaseGoodsModelsName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.Supplier); + if (columnIndex > 0) { + l_wh_goods.setSupplier(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.BuyType); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods.setBuyType(null); + } else { + l_wh_goods.setBuyType(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.Unit); + if (columnIndex > 0) { + l_wh_goods.setUnit(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.Price); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods.setPrice(null); + } else { + l_wh_goods.setPrice(rs.getDouble(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.ProcureDate); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods.setProcureDate(null); + } else { + l_wh_goods.setProcureDate(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.States); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_goods.setStates(null); + } else { + l_wh_goods.setStates(rs.getInt(columnIndex)); + } + } + return l_wh_goods; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModel.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModel.java new file mode 100644 index 0000000..71ce256 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModel.java @@ -0,0 +1,304 @@ + +package com.consum.model.po; + +import com.fasterxml.jackson.annotation.JsonAutoDetect; +import com.fasterxml.jackson.annotation.JsonIgnore; +import com.walker.jdbc.BasePo; + +/** + * 琛ㄥ悕:L_WH_PROCURE_MODEL * + * @author genrator + */ +@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY) +public class LWhProcureModel extends BasePo<LWhProcureModel> { + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + // 涓婚敭 + private Long id = null; + @JsonIgnore + protected boolean isset_id = false; + + // 灞炴�у垪琛� + private Long fromProcureGoodsId = null; + @JsonIgnore + protected boolean isset_fromProcureGoodsId = false; + + private Integer businessType = null; + @JsonIgnore + protected boolean isset_businessType = false; + + private Long businessId = null; + @JsonIgnore + protected boolean isset_businessId = false; + + private Long baseGoodsModelsId = null; + @JsonIgnore + protected boolean isset_baseGoodsModelsId = false; + + private String baseGoodsModelsName = null; + @JsonIgnore + protected boolean isset_baseGoodsModelsName = false; + + private String unit = null; + @JsonIgnore + protected boolean isset_unit = false; + + private Double price = null; + @JsonIgnore + protected boolean isset_price = false; + + private Integer counts = null; + @JsonIgnore + protected boolean isset_counts = false; + + private Integer worehouseCount = null; + @JsonIgnore + protected boolean isset_worehouseCount = false; + + private String supplier = null; + @JsonIgnore + protected boolean isset_supplier = false; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public LWhProcureModel() { + } + + /** + * 鏍规嵁涓婚敭鏋勯�犲璞� + */ + public LWhProcureModel(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 getFromProcureGoodsId() { + return this.fromProcureGoodsId; + } + + public void setFromProcureGoodsId(Long fromProcureGoodsId) { + this.fromProcureGoodsId = fromProcureGoodsId; + this.isset_fromProcureGoodsId = true; + } + + @JsonIgnore + public boolean isEmptyFromProcureGoodsId() { + return this.fromProcureGoodsId == null; + } + + public Integer getBusinessType() { + return this.businessType; + } + + public void setBusinessType(Integer businessType) { + this.businessType = businessType; + this.isset_businessType = true; + } + + @JsonIgnore + public boolean isEmptyBusinessType() { + return this.businessType == null; + } + + public Long getBusinessId() { + return this.businessId; + } + + public void setBusinessId(Long businessId) { + this.businessId = businessId; + this.isset_businessId = true; + } + + @JsonIgnore + public boolean isEmptyBusinessId() { + return this.businessId == null; + } + + 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 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 Double getPrice() { + return this.price; + } + + public void setPrice(Double price) { + this.price = price; + this.isset_price = true; + } + + @JsonIgnore + public boolean isEmptyPrice() { + return this.price == null; + } + + public Integer 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 Integer getWorehouseCount() { + return this.worehouseCount; + } + + public void setWorehouseCount(Integer worehouseCount) { + this.worehouseCount = worehouseCount; + this.isset_worehouseCount = true; + } + + @JsonIgnore + public boolean isEmptyWorehouseCount() { + return this.worehouseCount == null; + } + + public String getSupplier() { + return this.supplier; + } + + public void setSupplier(String supplier) { + this.supplier = supplier; + this.isset_supplier = true; + } + + @JsonIgnore + public boolean isEmptySupplier() { + return this.supplier == null || this.supplier.length() == 0; + } + + /** + * 閲嶅啓 toString() 鏂规硶 + */ + @Override + public String toString() { + return new StringBuilder() + .append("id=").append(this.id) + .append("fromProcureGoodsId=").append(this.fromProcureGoodsId) + .append("businessType=").append(this.businessType) + .append("businessId=").append(this.businessId) + .append("baseGoodsModelsId=").append(this.baseGoodsModelsId) + .append("baseGoodsModelsName=").append(this.baseGoodsModelsName) + .append("unit=").append(this.unit) + .append("price=").append(this.price) + .append("counts=").append(this.counts) + .append("worehouseCount=").append(this.worehouseCount) + .append("supplier=").append(this.supplier) + .toString(); + } + + /** + * 鍏嬮殕 + */ + public LWhProcureModel $clone() { + LWhProcureModel l_wh_procure_model = new LWhProcureModel(); + + // 鏁版嵁搴撳悕绉� + //l_wh_procure_model.setDatabaseName_(this.getDatabaseName_()); + + // 涓婚敭 + if (this.isset_id) { + l_wh_procure_model.setId(this.getId()); + } + // 鏅�氬睘鎬� + if (this.isset_fromProcureGoodsId) { + l_wh_procure_model.setFromProcureGoodsId(this.getFromProcureGoodsId()); + } + if (this.isset_businessType) { + l_wh_procure_model.setBusinessType(this.getBusinessType()); + } + if (this.isset_businessId) { + l_wh_procure_model.setBusinessId(this.getBusinessId()); + } + if (this.isset_baseGoodsModelsId) { + l_wh_procure_model.setBaseGoodsModelsId(this.getBaseGoodsModelsId()); + } + if (this.isset_baseGoodsModelsName) { + l_wh_procure_model.setBaseGoodsModelsName(this.getBaseGoodsModelsName()); + } + if (this.isset_unit) { + l_wh_procure_model.setUnit(this.getUnit()); + } + if (this.isset_price) { + l_wh_procure_model.setPrice(this.getPrice()); + } + if (this.isset_counts) { + l_wh_procure_model.setCounts(this.getCounts()); + } + if (this.isset_worehouseCount) { + l_wh_procure_model.setWorehouseCount(this.getWorehouseCount()); + } + if (this.isset_supplier) { + l_wh_procure_model.setSupplier(this.getSupplier()); + } + return l_wh_procure_model; + } +} diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModel_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModel_mapper.java new file mode 100644 index 0000000..f66da47 --- /dev/null +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModel_mapper.java @@ -0,0 +1,355 @@ +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 org.springframework.jdbc.core.RowMapper; + +import java.sql.ResultSet; +import java.sql.SQLException; +import java.util.Map; + +/** + * 琛ㄥ悕:L_WH_PROCURE_MODEL * + * @author genrator + */ +public class LWhProcureModel_mapper extends LWhProcureModel implements BaseMapper<LWhProcureModel> { + // 搴忓垪鍖栫増鏈彿 + private static final long serialVersionUID = 1L; + + public static final RowMapper<LWhProcureModel> ROW_MAPPER = new LWhProcureModelRowMapper(); + + // 涓婚敭 + public static final String Id = "id"; + // 鏅�氬睘鎬� + public static final String FromProcureGoodsId = "from_procure_goods_id"; + public static final String BusinessType = "business_type"; + public static final String BusinessId = "business_id"; + public static final String BaseGoodsModelsId = "base_goods_models_id"; + public static final String BaseGoodsModelsName = "base_goods_models_name"; + public static final String Unit = "unit"; + public static final String Price = "price"; + public static final String Counts = "counts"; + public static final String WorehouseCount = "worehouse_count"; + public static final String Supplier = "supplier"; + + /** + * 榛樿鏋勯�犲嚱鏁� + */ + public LWhProcureModel_mapper(LWhProcureModel lWhProcureModel) { + if (lWhProcureModel == null) { + throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒"); + } + //涓婚敭 + if (lWhProcureModel.isset_id) { + this.setId(lWhProcureModel.getId()); + } + //鏅�氬睘鎬� + if (lWhProcureModel.isset_fromProcureGoodsId) { + this.setFromProcureGoodsId(lWhProcureModel.getFromProcureGoodsId()); + } + if (lWhProcureModel.isset_businessType) { + this.setBusinessType(lWhProcureModel.getBusinessType()); + } + if (lWhProcureModel.isset_businessId) { + this.setBusinessId(lWhProcureModel.getBusinessId()); + } + if (lWhProcureModel.isset_baseGoodsModelsId) { + this.setBaseGoodsModelsId(lWhProcureModel.getBaseGoodsModelsId()); + } + if (lWhProcureModel.isset_baseGoodsModelsName) { + this.setBaseGoodsModelsName(lWhProcureModel.getBaseGoodsModelsName()); + } + if (lWhProcureModel.isset_unit) { + this.setUnit(lWhProcureModel.getUnit()); + } + if (lWhProcureModel.isset_price) { + this.setPrice(lWhProcureModel.getPrice()); + } + if (lWhProcureModel.isset_counts) { + this.setCounts(lWhProcureModel.getCounts()); + } + if (lWhProcureModel.isset_worehouseCount) { + this.setWorehouseCount(lWhProcureModel.getWorehouseCount()); + } + if (lWhProcureModel.isset_supplier) { + this.setSupplier(lWhProcureModel.getSupplier()); + } + // 鍘绘帀锛�2022-09-07 + // this.setDatabaseName_(l_wh_procure_model.getDatabaseName_()); + } + + /** + * 鑾峰彇琛ㄥ悕 + */ + @Override + public String getTableName_() { + String tableName = "l_wh_procure_model"; + /** + if (StringUtils.isNotEmpty(this.getDatabaseName_())) { + return this.getDatabaseName_() + "." + tableName; + } else { + return tableName; + } + */ + return tableName; + } + + /** + * 鑾峰彇涓婚敭鍚嶇О + */ + @Override + public String getPkName_() { + return Id; + } + + /** + * 鑾峰彇涓婚敭鍊� + */ + @Override + public Object getPkValue_() { + return this.getId(); + } + + /** + * 鑾峰彇鎻掑叆璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Map<String, Object>> getInsertSql_() { + InsertBuilder ib = new InsertBuilder(this.getTableName_()); + ib.set(Id, this.getId()); + ib.set(FromProcureGoodsId, this.getFromProcureGoodsId(), this.isset_fromProcureGoodsId); + ib.set(BusinessType, this.getBusinessType(), this.isset_businessType); + ib.set(BusinessId, this.getBusinessId(), this.isset_businessId); + ib.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId); + ib.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName); + ib.set(Unit, this.getUnit(), this.isset_unit); + ib.set(Price, this.getPrice(), this.isset_price); + ib.set(Counts, this.getCounts(), this.isset_counts); + ib.set(WorehouseCount, this.getWorehouseCount(), this.isset_worehouseCount); + ib.set(Supplier, this.getSupplier(), this.isset_supplier); + return ib.genMapSql(); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Map<String, Object>> getUpdateSql_() { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(FromProcureGoodsId, this.getFromProcureGoodsId(), this.isset_fromProcureGoodsId); + ub.set(BusinessType, this.getBusinessType(), this.isset_businessType); + ub.set(BusinessId, this.getBusinessId(), this.isset_businessId); + ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId); + ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName); + ub.set(Unit, this.getUnit(), this.isset_unit); + ub.set(Price, this.getPrice(), this.isset_price); + ub.set(Counts, this.getCounts(), this.isset_counts); + ub.set(WorehouseCount, this.getWorehouseCount(), this.isset_worehouseCount); + ub.set(Supplier, this.getSupplier(), this.isset_supplier); + 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(FromProcureGoodsId, this.getFromProcureGoodsId(), this.isset_fromProcureGoodsId); + ub.set(BusinessType, this.getBusinessType(), this.isset_businessType); + ub.set(BusinessId, this.getBusinessId(), this.isset_businessId); + ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId); + ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName); + ub.set(Unit, this.getUnit(), this.isset_unit); + ub.set(Price, this.getPrice(), this.isset_price); + ub.set(Counts, this.getCounts(), this.isset_counts); + ub.set(WorehouseCount, this.getWorehouseCount(), this.isset_worehouseCount); + ub.set(Supplier, this.getSupplier(), this.isset_supplier); + return ub.genMapSql(where, parameters); + } + + /** + * 鑾峰彇鏇存柊璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) { + UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); + ub.set(FromProcureGoodsId, this.getFromProcureGoodsId(), this.isset_fromProcureGoodsId); + ub.set(BusinessType, this.getBusinessType(), this.isset_businessType); + ub.set(BusinessId, this.getBusinessId(), this.isset_businessId); + ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId); + ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName); + ub.set(Unit, this.getUnit(), this.isset_unit); + ub.set(Price, this.getPrice(), this.isset_price); + ub.set(Counts, this.getCounts(), this.isset_counts); + ub.set(WorehouseCount, this.getWorehouseCount(), this.isset_worehouseCount); + ub.set(Supplier, this.getSupplier(), this.isset_supplier); + 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, from_procure_goods_id, business_type, business_id, base_goods_models_id, base_goods_models_name, unit, price, counts, worehouse_count, supplier from " + this.getTableName_() + " " + where, parameters); + } + + /** + * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁� + */ + @Override + public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { + return new SqlAndParameters<>("select id, from_procure_goods_id, business_type, business_id, base_goods_models_id, base_goods_models_name, unit, price, counts, worehouse_count, supplier from " + this.getTableName_() + " " + where, parameters); + } + + /** + * 灏唕esultset鐨勪竴琛岃浆鍖栦负po + */ + @Override + public LWhProcureModel mapRow(ResultSet rs, int i) throws SQLException { + return ROW_MAPPER.mapRow(rs, i); + } + + /** + * 鍏嬮殕 + */ + public LWhProcureModel toLWhProcureModel() { + return super.$clone(); + } +} + +/** + * l_wh_procure_model RowMapper + * + * @author genrator + */ +class LWhProcureModelRowMapper implements RowMapper<LWhProcureModel> { + + @Override + public LWhProcureModel mapRow(ResultSet rs, int i) throws SQLException { + ResultSetUtils resultSetUtils = new ResultSetUtils(); + LWhProcureModel l_wh_procure_model = new LWhProcureModel(); + Integer columnIndex; + //涓婚敭 + columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.Id); + if (columnIndex > 0) { + l_wh_procure_model.setId(rs.getLong(columnIndex)); + } + //鏅�氬睘鎬� + columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.FromProcureGoodsId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_procure_model.setFromProcureGoodsId(null); + } else { + l_wh_procure_model.setFromProcureGoodsId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.BusinessType); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_procure_model.setBusinessType(null); + } else { + l_wh_procure_model.setBusinessType(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.BusinessId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_procure_model.setBusinessId(null); + } else { + l_wh_procure_model.setBusinessId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.BaseGoodsModelsId); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_procure_model.setBaseGoodsModelsId(null); + } else { + l_wh_procure_model.setBaseGoodsModelsId(rs.getLong(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.BaseGoodsModelsName); + if (columnIndex > 0) { + l_wh_procure_model.setBaseGoodsModelsName(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.Unit); + if (columnIndex > 0) { + l_wh_procure_model.setUnit(rs.getString(columnIndex)); + } + columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.Price); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_procure_model.setPrice(null); + } else { + l_wh_procure_model.setPrice(rs.getDouble(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.Counts); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_procure_model.setCounts(null); + } else { + l_wh_procure_model.setCounts(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.WorehouseCount); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_procure_model.setWorehouseCount(null); + } else { + l_wh_procure_model.setWorehouseCount(rs.getInt(columnIndex)); + } + } + columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.Supplier); + if (columnIndex > 0) { + l_wh_procure_model.setSupplier(rs.getString(columnIndex)); + } + return l_wh_procure_model; + } +} -- Gitblit v1.9.1