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/LWhProcureModel_mapper.java | 26 ++++++++++++++++++++++---- 1 files changed, 22 insertions(+), 4 deletions(-) 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 index cf1b78e..5ba06f0 100644 --- 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 @@ -7,13 +7,15 @@ 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; -import org.springframework.jdbc.core.RowMapper; /** - * 琛ㄥ悕:L_WH_PROCURE_MODEL * + * 琛ㄥ悕:L_WH_PROCURE_MODEL + * * @author genrator */ public class LWhProcureModel_mapper extends LWhProcureModel implements BaseMapper<LWhProcureModel> { @@ -35,6 +37,7 @@ public static final String WorehouseCount = "worehouse_count"; public static final String Supplier = "supplier"; public static final String TotalAmount = "total_amount"; + public static final String UseCount = "use_count"; /** * 榛樿鏋勯�犲嚱鏁� @@ -77,6 +80,9 @@ } if (lWhProcureModel.isset_totalAmount) { this.setTotalAmount(lWhProcureModel.getTotalAmount()); + } + if (lWhProcureModel.isset_useCount) { + this.setUseCount(lWhProcureModel.getUseCount()); } // 鍘绘帀锛�2022-09-07 // this.setDatabaseName_(l_wh_procure_model.getDatabaseName_()); @@ -131,6 +137,7 @@ ib.set(WorehouseCount, this.getWorehouseCount(), this.isset_worehouseCount); ib.set(Supplier, this.getSupplier(), this.isset_supplier); ib.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount); + ib.set(UseCount, this.getUseCount(), this.isset_useCount); return ib.genMapSql(); } @@ -150,6 +157,7 @@ ub.set(WorehouseCount, this.getWorehouseCount(), this.isset_worehouseCount); ub.set(Supplier, this.getSupplier(), this.isset_supplier); ub.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount); + ub.set(UseCount, this.getUseCount(), this.isset_useCount); ub.where(this.getPkName_(), this.getPkValue_()); return ub.genMapSql(); } @@ -170,6 +178,7 @@ ub.set(WorehouseCount, this.getWorehouseCount(), this.isset_worehouseCount); ub.set(Supplier, this.getSupplier(), this.isset_supplier); ub.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount); + ub.set(UseCount, this.getUseCount(), this.isset_useCount); return ub.genMapSql(where, parameters); } @@ -189,6 +198,7 @@ ub.set(WorehouseCount, this.getWorehouseCount(), this.isset_worehouseCount); ub.set(Supplier, this.getSupplier(), this.isset_supplier); ub.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount); + ub.set(UseCount, this.getUseCount(), this.isset_useCount); return ub.genArraySql(where, parameters); } @@ -236,7 +246,7 @@ */ @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, price, counts, worehouse_count, supplier, total_amount from " + this.getTableName_() + " " + where, parameters); + return new SqlAndParameters<>("select id, from_procure_goods_id, business_type, business_id, base_goods_models_id, base_goods_models_name, price, counts, worehouse_count, supplier, total_amount, use_count from " + this.getTableName_() + " " + where, parameters); } /** @@ -244,7 +254,7 @@ */ @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, price, counts, worehouse_count, supplier, total_amount from " + this.getTableName_() + " " + where, parameters); + return new SqlAndParameters<>("select id, from_procure_goods_id, business_type, business_id, base_goods_models_id, base_goods_models_name, price, counts, worehouse_count, supplier, total_amount, use_count from " + this.getTableName_() + " " + where, parameters); } /** @@ -353,6 +363,14 @@ l_wh_procure_model.setTotalAmount(rs.getLong(columnIndex)); } } + columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.UseCount); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_procure_model.setUseCount(null); + } else { + l_wh_procure_model.setUseCount(rs.getInt(columnIndex)); + } + } return l_wh_procure_model; } } -- Gitblit v1.9.1