From 01107e8aadfaf1e84a971d8eeb9ab37e1c5569f3 Mon Sep 17 00:00:00 2001 From: cy <1664593601@qq.com> Date: 星期五, 01 十二月 2023 09:38:56 +0800 Subject: [PATCH] feat: 部门退回/报废公用接口 --- consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModelUser_mapper.java | 22 ++++++++++++++++++---- 1 files changed, 18 insertions(+), 4 deletions(-) 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 index 8589382..5baed7b 100644 --- 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 @@ -7,8 +7,6 @@ import com.walker.jdbc.sqlgen.InsertBuilder; import com.walker.jdbc.sqlgen.SelectBuilder; import com.walker.jdbc.sqlgen.UpdateBuilder; -import com.walker.jdbc.util.StringUtils; - import org.springframework.jdbc.core.RowMapper; import java.sql.ResultSet; @@ -35,6 +33,7 @@ public static final String NowUserPhone = "now_user_phone"; public static final String NowUserName = "now_user_name"; public static final String GoodsNum = "goods_num"; + public static final String UseCount = "use_count"; /** * 榛樿鏋勯�犲嚱鏁� @@ -68,6 +67,9 @@ } if (lWhProcureModelUser.isset_goodsNum) { this.setGoodsNum(lWhProcureModelUser.getGoodsNum()); + } + if (lWhProcureModelUser.isset_useCount) { + this.setUseCount(lWhProcureModelUser.getUseCount()); } // 鍘绘帀锛�2022-09-07 // this.setDatabaseName_(l_wh_procure_model_user.getDatabaseName_()); @@ -119,6 +121,7 @@ ib.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone); ib.set(NowUserName, this.getNowUserName(), this.isset_nowUserName); ib.set(GoodsNum, this.getGoodsNum(), this.isset_goodsNum); + ib.set(UseCount, this.getUseCount(), this.isset_useCount); return ib.genMapSql(); } @@ -135,6 +138,7 @@ 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.set(UseCount, this.getUseCount(), this.isset_useCount); ub.where(this.getPkName_(), this.getPkValue_()); return ub.genMapSql(); } @@ -152,6 +156,7 @@ 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.set(UseCount, this.getUseCount(), this.isset_useCount); return ub.genMapSql(where, parameters); } @@ -168,6 +173,7 @@ 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.set(UseCount, this.getUseCount(), this.isset_useCount); return ub.genArraySql(where, parameters); } @@ -215,7 +221,7 @@ */ @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); + 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, use_count from " + this.getTableName_() + " " + where, parameters); } /** @@ -223,7 +229,7 @@ */ @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); + 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, use_count from " + this.getTableName_() + " " + where, parameters); } /** @@ -312,6 +318,14 @@ l_wh_procure_model_user.setGoodsNum(rs.getInt(columnIndex)); } } + columnIndex = resultSetUtils.findColumn(rs, LWhProcureModelUser_mapper.UseCount); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_procure_model_user.setUseCount(null); + } else { + l_wh_procure_model_user.setUseCount(rs.getInt(columnIndex)); + } + } return l_wh_procure_model_user; } } -- Gitblit v1.9.1