From b4de1386f34734fa0e4155ed9a21ea7b7163a006 Mon Sep 17 00:00:00 2001 From: futian.liu <liufutianyoo@163.com> Date: 星期一, 13 十一月 2023 17:36:40 +0800 Subject: [PATCH] 增加表字段 --- consum-model-pojo/src/main/java/com/consum/model/po/LWhProcureModel_mapper.java | 25 +++++++++++++++++++------ 1 files changed, 19 insertions(+), 6 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 df53323..cf1b78e 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,10 @@ 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; +import org.springframework.jdbc.core.RowMapper; /** * 琛ㄥ悕:L_WH_PROCURE_MODEL * @@ -37,6 +34,7 @@ public static final String Counts = "counts"; public static final String WorehouseCount = "worehouse_count"; public static final String Supplier = "supplier"; + public static final String TotalAmount = "total_amount"; /** * 榛樿鏋勯�犲嚱鏁� @@ -76,6 +74,9 @@ } if (lWhProcureModel.isset_supplier) { this.setSupplier(lWhProcureModel.getSupplier()); + } + if (lWhProcureModel.isset_totalAmount) { + this.setTotalAmount(lWhProcureModel.getTotalAmount()); } // 鍘绘帀锛�2022-09-07 // this.setDatabaseName_(l_wh_procure_model.getDatabaseName_()); @@ -129,6 +130,7 @@ ib.set(Counts, this.getCounts(), this.isset_counts); ib.set(WorehouseCount, this.getWorehouseCount(), this.isset_worehouseCount); ib.set(Supplier, this.getSupplier(), this.isset_supplier); + ib.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount); return ib.genMapSql(); } @@ -147,6 +149,7 @@ 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.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount); ub.where(this.getPkName_(), this.getPkValue_()); return ub.genMapSql(); } @@ -166,6 +169,7 @@ 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.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount); return ub.genMapSql(where, parameters); } @@ -184,6 +188,7 @@ 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.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount); return ub.genArraySql(where, parameters); } @@ -231,7 +236,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 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 from " + this.getTableName_() + " " + where, parameters); } /** @@ -239,7 +244,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 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 from " + this.getTableName_() + " " + where, parameters); } /** @@ -340,6 +345,14 @@ if (columnIndex > 0) { l_wh_procure_model.setSupplier(rs.getString(columnIndex)); } + columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.TotalAmount); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_wh_procure_model.setTotalAmount(null); + } else { + l_wh_procure_model.setTotalAmount(rs.getLong(columnIndex)); + } + } return l_wh_procure_model; } } -- Gitblit v1.9.1