From 4481595ab968ae69919867de87354270cc0444c3 Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期四, 02 十一月 2023 11:48:22 +0800
Subject: [PATCH] feat: 提交po
---
consum-model-pojo/src/main/java/com/consum/model/po/LGoodsUserRecord_mapper.java | 20 +
consum-model-pojo/src/main/java/com/consum/model/po/LGoodsUserRecord.java | 22 ++
consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModelUser_mapper.java | 317 +++++++++++++++++++++++++++++++
consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModelUser.java | 238 +++++++++++++++++++++++
4 files changed, 595 insertions(+), 2 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
index ec835f9..d9ce23f 100644
--- 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
@@ -32,6 +32,10 @@
@JsonIgnore
protected boolean isset_transBusinessId = false;
+ private Long procureModelUserRecordId = null;
+ @JsonIgnore
+ protected boolean isset_procureModelUserRecordId = false;
+
private Long nowUserPhone = null;
@JsonIgnore
protected boolean isset_nowUserPhone = false;
@@ -133,6 +137,20 @@
return this.transBusinessId == null;
}
+ public Long getProcureModelUserRecordId() {
+ return this.procureModelUserRecordId;
+ }
+
+ public void setProcureModelUserRecordId(Long procureModelUserRecordId) {
+ this.procureModelUserRecordId = procureModelUserRecordId;
+ this.isset_procureModelUserRecordId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyProcureModelUserRecordId() {
+ return this.procureModelUserRecordId == null;
+ }
+
public Long getNowUserPhone() {
return this.nowUserPhone;
}
@@ -227,6 +245,7 @@
.append("whGoodsId=").append(this.whGoodsId)
.append("recordType=").append(this.recordType)
.append("transBusinessId=").append(this.transBusinessId)
+ .append("procureModelUserRecordId=").append(this.procureModelUserRecordId)
.append("nowUserPhone=").append(this.nowUserPhone)
.append("nowUserName=").append(this.nowUserName)
.append("operatorId=").append(this.operatorId)
@@ -259,6 +278,9 @@
if (this.isset_transBusinessId) {
l_goods_user_record.setTransBusinessId(this.getTransBusinessId());
}
+ if (this.isset_procureModelUserRecordId) {
+ l_goods_user_record.setProcureModelUserRecordId(this.getProcureModelUserRecordId());
+ }
if (this.isset_nowUserPhone) {
l_goods_user_record.setNowUserPhone(this.getNowUserPhone());
}
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
index 1dc58a5..df4c34e 100644
--- 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
@@ -31,6 +31,7 @@
public static final String WhGoodsId = "wh_goods_id";
public static final String RecordType = "record_type";
public static final String TransBusinessId = "trans_business_id";
+ public static final String ProcureModelUserRecordId = "procure_model_user_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";
@@ -58,6 +59,9 @@
}
if (lGoodsUserRecord.isset_transBusinessId) {
this.setTransBusinessId(lGoodsUserRecord.getTransBusinessId());
+ }
+ if (lGoodsUserRecord.isset_procureModelUserRecordId) {
+ this.setProcureModelUserRecordId(lGoodsUserRecord.getProcureModelUserRecordId());
}
if (lGoodsUserRecord.isset_nowUserPhone) {
this.setNowUserPhone(lGoodsUserRecord.getNowUserPhone());
@@ -123,6 +127,7 @@
ib.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId);
ib.set(RecordType, this.getRecordType(), this.isset_recordType);
ib.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+ ib.set(ProcureModelUserRecordId, this.getProcureModelUserRecordId(), this.isset_procureModelUserRecordId);
ib.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone);
ib.set(NowUserName, this.getNowUserName(), this.isset_nowUserName);
ib.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
@@ -141,6 +146,7 @@
ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId);
ub.set(RecordType, this.getRecordType(), this.isset_recordType);
ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+ ub.set(ProcureModelUserRecordId, this.getProcureModelUserRecordId(), this.isset_procureModelUserRecordId);
ub.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone);
ub.set(NowUserName, this.getNowUserName(), this.isset_nowUserName);
ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
@@ -160,6 +166,7 @@
ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId);
ub.set(RecordType, this.getRecordType(), this.isset_recordType);
ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+ ub.set(ProcureModelUserRecordId, this.getProcureModelUserRecordId(), this.isset_procureModelUserRecordId);
ub.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone);
ub.set(NowUserName, this.getNowUserName(), this.isset_nowUserName);
ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
@@ -178,6 +185,7 @@
ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId);
ub.set(RecordType, this.getRecordType(), this.isset_recordType);
ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+ ub.set(ProcureModelUserRecordId, this.getProcureModelUserRecordId(), this.isset_procureModelUserRecordId);
ub.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone);
ub.set(NowUserName, this.getNowUserName(), this.isset_nowUserName);
ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
@@ -231,7 +239,7 @@
*/
@Override
public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
- return new SqlAndParameters<>("select id, wh_goods_id, record_type, trans_business_id, now_user_phone, now_user_name, operator_id, operator_name, deal_time, last_record from " + this.getTableName_() + " " + where, parameters);
+ return new SqlAndParameters<>("select id, wh_goods_id, record_type, trans_business_id, procure_model_user_record_id, now_user_phone, now_user_name, operator_id, operator_name, deal_time, last_record from " + this.getTableName_() + " " + where, parameters);
}
/**
@@ -239,7 +247,7 @@
*/
@Override
public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
- return new SqlAndParameters<>("select id, wh_goods_id, record_type, trans_business_id, now_user_phone, now_user_name, operator_id, operator_name, deal_time, last_record from " + this.getTableName_() + " " + where, parameters);
+ return new SqlAndParameters<>("select id, wh_goods_id, record_type, trans_business_id, procure_model_user_record_id, now_user_phone, now_user_name, operator_id, operator_name, deal_time, last_record from " + this.getTableName_() + " " + where, parameters);
}
/**
@@ -300,6 +308,14 @@
l_goods_user_record.setTransBusinessId(rs.getLong(columnIndex));
}
}
+ columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.ProcureModelUserRecordId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ l_goods_user_record.setProcureModelUserRecordId(null);
+ } else {
+ l_goods_user_record.setProcureModelUserRecordId(rs.getLong(columnIndex));
+ }
+ }
columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.NowUserPhone);
if (columnIndex > 0) {
if (rs.getBigDecimal(columnIndex) == null) {
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModelUser.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModelUser.java
new file mode 100644
index 0000000..d67103f
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModelUser.java
@@ -0,0 +1,238 @@
+
+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_USER *
+ * @author genrator
+ */
+@JsonAutoDetect(fieldVisibility = JsonAutoDetect.Visibility.ANY)
+public class LWhProcureModelUser extends BasePo<LWhProcureModelUser> {
+ // 搴忓垪鍖栫増鏈彿
+ private static final long serialVersionUID = 1L;
+
+ // 涓婚敭
+ private Long id = null;
+ @JsonIgnore
+ protected boolean isset_id = false;
+
+ // 灞炴�у垪琛�
+ private Long transBusinessId = null;
+ @JsonIgnore
+ protected boolean isset_transBusinessId = false;
+
+ private Long procureModelUserRecordId = null;
+ @JsonIgnore
+ protected boolean isset_procureModelUserRecordId = false;
+
+ private Long whProcureModelId = null;
+ @JsonIgnore
+ protected boolean isset_whProcureModelId = false;
+
+ private Long baseGoodsModelsId = null;
+ @JsonIgnore
+ protected boolean isset_baseGoodsModelsId = false;
+
+ private Long nowUserPhone = null;
+ @JsonIgnore
+ protected boolean isset_nowUserPhone = false;
+
+ private String nowUserName = null;
+ @JsonIgnore
+ protected boolean isset_nowUserName = false;
+
+ private Integer goodsNum = null;
+ @JsonIgnore
+ protected boolean isset_goodsNum = false;
+
+ /**
+ * 榛樿鏋勯�犲嚱鏁�
+ */
+ public LWhProcureModelUser() {
+ }
+
+ /**
+ * 鏍规嵁涓婚敭鏋勯�犲璞�
+ */
+ public LWhProcureModelUser(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 getTransBusinessId() {
+ return this.transBusinessId;
+ }
+
+ public void setTransBusinessId(Long transBusinessId) {
+ this.transBusinessId = transBusinessId;
+ this.isset_transBusinessId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyTransBusinessId() {
+ return this.transBusinessId == null;
+ }
+
+ public Long getProcureModelUserRecordId() {
+ return this.procureModelUserRecordId;
+ }
+
+ public void setProcureModelUserRecordId(Long procureModelUserRecordId) {
+ this.procureModelUserRecordId = procureModelUserRecordId;
+ this.isset_procureModelUserRecordId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyProcureModelUserRecordId() {
+ return this.procureModelUserRecordId == null;
+ }
+
+ public Long getWhProcureModelId() {
+ return this.whProcureModelId;
+ }
+
+ public void setWhProcureModelId(Long whProcureModelId) {
+ this.whProcureModelId = whProcureModelId;
+ this.isset_whProcureModelId = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyWhProcureModelId() {
+ return this.whProcureModelId == 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 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 Integer getGoodsNum() {
+ return this.goodsNum;
+ }
+
+ public void setGoodsNum(Integer goodsNum) {
+ this.goodsNum = goodsNum;
+ this.isset_goodsNum = true;
+ }
+
+ @JsonIgnore
+ public boolean isEmptyGoodsNum() {
+ return this.goodsNum == null;
+ }
+
+ /**
+ * 閲嶅啓 toString() 鏂规硶
+ */
+ @Override
+ public String toString() {
+ return new StringBuilder()
+ .append("id=").append(this.id)
+ .append("transBusinessId=").append(this.transBusinessId)
+ .append("procureModelUserRecordId=").append(this.procureModelUserRecordId)
+ .append("whProcureModelId=").append(this.whProcureModelId)
+ .append("baseGoodsModelsId=").append(this.baseGoodsModelsId)
+ .append("nowUserPhone=").append(this.nowUserPhone)
+ .append("nowUserName=").append(this.nowUserName)
+ .append("goodsNum=").append(this.goodsNum)
+ .toString();
+ }
+
+ /**
+ * 鍏嬮殕
+ */
+ public LWhProcureModelUser $clone() {
+ LWhProcureModelUser l_wh_procure_model_user = new LWhProcureModelUser();
+
+ // 鏁版嵁搴撳悕绉�
+ //l_wh_procure_model_user.setDatabaseName_(this.getDatabaseName_());
+
+ // 涓婚敭
+ if (this.isset_id) {
+ l_wh_procure_model_user.setId(this.getId());
+ }
+ // 鏅�氬睘鎬�
+ if (this.isset_transBusinessId) {
+ l_wh_procure_model_user.setTransBusinessId(this.getTransBusinessId());
+ }
+ if (this.isset_procureModelUserRecordId) {
+ l_wh_procure_model_user.setProcureModelUserRecordId(this.getProcureModelUserRecordId());
+ }
+ if (this.isset_whProcureModelId) {
+ l_wh_procure_model_user.setWhProcureModelId(this.getWhProcureModelId());
+ }
+ if (this.isset_baseGoodsModelsId) {
+ l_wh_procure_model_user.setBaseGoodsModelsId(this.getBaseGoodsModelsId());
+ }
+ if (this.isset_nowUserPhone) {
+ l_wh_procure_model_user.setNowUserPhone(this.getNowUserPhone());
+ }
+ if (this.isset_nowUserName) {
+ l_wh_procure_model_user.setNowUserName(this.getNowUserName());
+ }
+ if (this.isset_goodsNum) {
+ l_wh_procure_model_user.setGoodsNum(this.getGoodsNum());
+ }
+ return l_wh_procure_model_user;
+ }
+}
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModelUser_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModelUser_mapper.java
new file mode 100644
index 0000000..8589382
--- /dev/null
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModelUser_mapper.java
@@ -0,0 +1,317 @@
+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_PROCURE_MODEL_USER *
+ * @author genrator
+ */
+public class LWhProcureModelUser_mapper extends LWhProcureModelUser implements BaseMapper<LWhProcureModelUser> {
+ // 搴忓垪鍖栫増鏈彿
+ private static final long serialVersionUID = 1L;
+
+ public static final RowMapper<LWhProcureModelUser> ROW_MAPPER = new LWhProcureModelUserRowMapper();
+
+ // 涓婚敭
+ public static final String Id = "id";
+ // 鏅�氬睘鎬�
+ public static final String TransBusinessId = "trans_business_id";
+ public static final String ProcureModelUserRecordId = "procure_model_user_record_id";
+ public static final String WhProcureModelId = "wh_procure_model_id";
+ public static final String BaseGoodsModelsId = "base_goods_models_id";
+ public static final String NowUserPhone = "now_user_phone";
+ public static final String NowUserName = "now_user_name";
+ public static final String GoodsNum = "goods_num";
+
+ /**
+ * 榛樿鏋勯�犲嚱鏁�
+ */
+ public LWhProcureModelUser_mapper(LWhProcureModelUser lWhProcureModelUser) {
+ if (lWhProcureModelUser == null) {
+ throw new IllegalArgumentException("po鍙傛暟涓嶅厑璁镐负绌猴紒");
+ }
+ //涓婚敭
+ if (lWhProcureModelUser.isset_id) {
+ this.setId(lWhProcureModelUser.getId());
+ }
+ //鏅�氬睘鎬�
+ if (lWhProcureModelUser.isset_transBusinessId) {
+ this.setTransBusinessId(lWhProcureModelUser.getTransBusinessId());
+ }
+ if (lWhProcureModelUser.isset_procureModelUserRecordId) {
+ this.setProcureModelUserRecordId(lWhProcureModelUser.getProcureModelUserRecordId());
+ }
+ if (lWhProcureModelUser.isset_whProcureModelId) {
+ this.setWhProcureModelId(lWhProcureModelUser.getWhProcureModelId());
+ }
+ if (lWhProcureModelUser.isset_baseGoodsModelsId) {
+ this.setBaseGoodsModelsId(lWhProcureModelUser.getBaseGoodsModelsId());
+ }
+ if (lWhProcureModelUser.isset_nowUserPhone) {
+ this.setNowUserPhone(lWhProcureModelUser.getNowUserPhone());
+ }
+ if (lWhProcureModelUser.isset_nowUserName) {
+ this.setNowUserName(lWhProcureModelUser.getNowUserName());
+ }
+ if (lWhProcureModelUser.isset_goodsNum) {
+ this.setGoodsNum(lWhProcureModelUser.getGoodsNum());
+ }
+ // 鍘绘帀锛�2022-09-07
+ // this.setDatabaseName_(l_wh_procure_model_user.getDatabaseName_());
+ }
+
+ /**
+ * 鑾峰彇琛ㄥ悕
+ */
+ @Override
+ public String getTableName_() {
+ String tableName = "l_wh_procure_model_user";
+ /**
+ 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(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+ ib.set(ProcureModelUserRecordId, this.getProcureModelUserRecordId(), this.isset_procureModelUserRecordId);
+ ib.set(WhProcureModelId, this.getWhProcureModelId(), this.isset_whProcureModelId);
+ ib.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
+ ib.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone);
+ ib.set(NowUserName, this.getNowUserName(), this.isset_nowUserName);
+ ib.set(GoodsNum, this.getGoodsNum(), this.isset_goodsNum);
+ return ib.genMapSql();
+ }
+
+ /**
+ * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
+ UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+ ub.set(ProcureModelUserRecordId, this.getProcureModelUserRecordId(), this.isset_procureModelUserRecordId);
+ ub.set(WhProcureModelId, this.getWhProcureModelId(), this.isset_whProcureModelId);
+ ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
+ ub.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone);
+ ub.set(NowUserName, this.getNowUserName(), this.isset_nowUserName);
+ ub.set(GoodsNum, this.getGoodsNum(), this.isset_goodsNum);
+ 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(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+ ub.set(ProcureModelUserRecordId, this.getProcureModelUserRecordId(), this.isset_procureModelUserRecordId);
+ ub.set(WhProcureModelId, this.getWhProcureModelId(), this.isset_whProcureModelId);
+ ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
+ ub.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone);
+ ub.set(NowUserName, this.getNowUserName(), this.isset_nowUserName);
+ ub.set(GoodsNum, this.getGoodsNum(), this.isset_goodsNum);
+ return ub.genMapSql(where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鏇存柊璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
+ UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(TransBusinessId, this.getTransBusinessId(), this.isset_transBusinessId);
+ ub.set(ProcureModelUserRecordId, this.getProcureModelUserRecordId(), this.isset_procureModelUserRecordId);
+ ub.set(WhProcureModelId, this.getWhProcureModelId(), this.isset_whProcureModelId);
+ ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
+ ub.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone);
+ ub.set(NowUserName, this.getNowUserName(), this.isset_nowUserName);
+ ub.set(GoodsNum, this.getGoodsNum(), this.isset_goodsNum);
+ 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, trans_business_id, procure_model_user_record_id, wh_procure_model_id, base_goods_models_id, now_user_phone, now_user_name, goods_num from " + this.getTableName_() + " " + where, parameters);
+ }
+
+ /**
+ * 鑾峰彇鏌ヨ璇彞鍜屽弬鏁�
+ */
+ @Override
+ public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
+ return new SqlAndParameters<>("select id, trans_business_id, procure_model_user_record_id, wh_procure_model_id, base_goods_models_id, now_user_phone, now_user_name, goods_num from " + this.getTableName_() + " " + where, parameters);
+ }
+
+ /**
+ * 灏唕esultset鐨勪竴琛岃浆鍖栦负po
+ */
+ @Override
+ public LWhProcureModelUser mapRow(ResultSet rs, int i) throws SQLException {
+ return ROW_MAPPER.mapRow(rs, i);
+ }
+
+ /**
+ * 鍏嬮殕
+ */
+ public LWhProcureModelUser toLWhProcureModelUser() {
+ return super.$clone();
+ }
+}
+
+/**
+ * l_wh_procure_model_user RowMapper
+ *
+ * @author genrator
+ */
+class LWhProcureModelUserRowMapper implements RowMapper<LWhProcureModelUser> {
+
+ @Override
+ public LWhProcureModelUser mapRow(ResultSet rs, int i) throws SQLException {
+ ResultSetUtils resultSetUtils = new ResultSetUtils();
+ LWhProcureModelUser l_wh_procure_model_user = new LWhProcureModelUser();
+ Integer columnIndex;
+ //涓婚敭
+ columnIndex = resultSetUtils.findColumn(rs, LWhProcureModelUser_mapper.Id);
+ if (columnIndex > 0) {
+ l_wh_procure_model_user.setId(rs.getLong(columnIndex));
+ }
+ //鏅�氬睘鎬�
+ columnIndex = resultSetUtils.findColumn(rs, LWhProcureModelUser_mapper.TransBusinessId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ l_wh_procure_model_user.setTransBusinessId(null);
+ } else {
+ l_wh_procure_model_user.setTransBusinessId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, LWhProcureModelUser_mapper.ProcureModelUserRecordId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ l_wh_procure_model_user.setProcureModelUserRecordId(null);
+ } else {
+ l_wh_procure_model_user.setProcureModelUserRecordId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, LWhProcureModelUser_mapper.WhProcureModelId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ l_wh_procure_model_user.setWhProcureModelId(null);
+ } else {
+ l_wh_procure_model_user.setWhProcureModelId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, LWhProcureModelUser_mapper.BaseGoodsModelsId);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ l_wh_procure_model_user.setBaseGoodsModelsId(null);
+ } else {
+ l_wh_procure_model_user.setBaseGoodsModelsId(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, LWhProcureModelUser_mapper.NowUserPhone);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ l_wh_procure_model_user.setNowUserPhone(null);
+ } else {
+ l_wh_procure_model_user.setNowUserPhone(rs.getLong(columnIndex));
+ }
+ }
+ columnIndex = resultSetUtils.findColumn(rs, LWhProcureModelUser_mapper.NowUserName);
+ if (columnIndex > 0) {
+ l_wh_procure_model_user.setNowUserName(rs.getString(columnIndex));
+ }
+ columnIndex = resultSetUtils.findColumn(rs, LWhProcureModelUser_mapper.GoodsNum);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ l_wh_procure_model_user.setGoodsNum(null);
+ } else {
+ l_wh_procure_model_user.setGoodsNum(rs.getInt(columnIndex));
+ }
+ }
+ return l_wh_procure_model_user;
+ }
+}
--
Gitblit v1.9.1