From e80a199894f078f3b0ead5b052ea3ce5d2b9d96e Mon Sep 17 00:00:00 2001
From: luqingyang <lqy5492@163.com>
Date: 星期三, 01 十一月 2023 17:36:06 +0800
Subject: [PATCH] 库存盘点 相关代码
---
consum-model-pojo/src/main/java/com/consum/model/po/LGoodsUserRecord_mapper.java | 22 ++++++++++++++++++++--
1 files changed, 20 insertions(+), 2 deletions(-)
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 61f751e..1dc58a5 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
@@ -7,6 +7,8 @@
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;
@@ -34,6 +36,7 @@
public static final String OperatorId = "operator_id";
public static final String OperatorName = "operator_name";
public static final String DealTime = "deal_time";
+ public static final String LastRecord = "last_record";
/**
* 榛樿鏋勯�犲嚱鏁�
@@ -70,6 +73,9 @@
}
if (lGoodsUserRecord.isset_dealTime) {
this.setDealTime(lGoodsUserRecord.getDealTime());
+ }
+ if (lGoodsUserRecord.isset_lastRecord) {
+ this.setLastRecord(lGoodsUserRecord.getLastRecord());
}
// 鍘绘帀锛�2022-09-07
// this.setDatabaseName_(l_goods_user_record.getDatabaseName_());
@@ -122,6 +128,7 @@
ib.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
ib.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
ib.set(DealTime, this.getDealTime(), this.isset_dealTime);
+ ib.set(LastRecord, this.getLastRecord(), this.isset_lastRecord);
return ib.genMapSql();
}
@@ -139,6 +146,7 @@
ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
+ ub.set(LastRecord, this.getLastRecord(), this.isset_lastRecord);
ub.where(this.getPkName_(), this.getPkValue_());
return ub.genMapSql();
}
@@ -157,6 +165,7 @@
ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
+ ub.set(LastRecord, this.getLastRecord(), this.isset_lastRecord);
return ub.genMapSql(where, parameters);
}
@@ -174,6 +183,7 @@
ub.set(OperatorId, this.getOperatorId(), this.isset_operatorId);
ub.set(OperatorName, this.getOperatorName(), this.isset_operatorName);
ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
+ ub.set(LastRecord, this.getLastRecord(), this.isset_lastRecord);
return ub.genArraySql(where, parameters);
}
@@ -221,7 +231,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 from " + this.getTableName_() + " " + where, 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);
}
/**
@@ -229,7 +239,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 from " + this.getTableName_() + " " + where, 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);
}
/**
@@ -322,6 +332,14 @@
l_goods_user_record.setDealTime(rs.getLong(columnIndex));
}
}
+ columnIndex = resultSetUtils.findColumn(rs, LGoodsUserRecord_mapper.LastRecord);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ l_goods_user_record.setLastRecord(null);
+ } else {
+ l_goods_user_record.setLastRecord(rs.getInt(columnIndex));
+ }
+ }
return l_goods_user_record;
}
}
--
Gitblit v1.9.1