From 33032d320cb75854def7391026b0401f1bfb8360 Mon Sep 17 00:00:00 2001 From: 黎星凯 <13949086503@163.com> Date: 星期六, 11 五月 2024 17:26:02 +0800 Subject: [PATCH] 20240511修改: 分发单优化, 分类,物品,分发单明细,采购单明细数据导入 --- consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java | 36 ++++++++++++++++++++++++++++++++++-- 1 files changed, 34 insertions(+), 2 deletions(-) diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java index 60801e6..82a5613 100644 --- a/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java +++ b/consum-model-pojo/src/main/java/com/consum/model/po/LGoodsWhRecord_mapper.java @@ -30,8 +30,10 @@ // 鏅�氬睘鎬� public static final String WarehouseFlowId = "warehouse_flow_id"; public static final String WhGoodsId = "wh_goods_id"; + public static final String WarehouseType = "warehouse_type"; public static final String WarehouseId = "warehouse_id"; public static final String DealTime = "deal_time"; + public static final String LastRecord = "last_record"; /** * 榛樿鏋勯�犲嚱鏁� @@ -51,11 +53,17 @@ if (lGoodsWhRecord.isset_whGoodsId) { this.setWhGoodsId(lGoodsWhRecord.getWhGoodsId()); } + if (lGoodsWhRecord.isset_warehouseType) { + this.setWarehouseType(lGoodsWhRecord.getWarehouseType()); + } if (lGoodsWhRecord.isset_warehouseId) { this.setWarehouseId(lGoodsWhRecord.getWarehouseId()); } if (lGoodsWhRecord.isset_dealTime) { this.setDealTime(lGoodsWhRecord.getDealTime()); + } + if (lGoodsWhRecord.isset_lastRecord) { + this.setLastRecord(lGoodsWhRecord.getLastRecord()); } // 鍘绘帀锛�2022-09-07 // this.setDatabaseName_(l_goods_wh_record.getDatabaseName_()); @@ -102,8 +110,10 @@ ib.set(Id, this.getId()); ib.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId); ib.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId); + ib.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); ib.set(DealTime, this.getDealTime(), this.isset_dealTime); + ib.set(LastRecord, this.getLastRecord(), this.isset_lastRecord); return ib.genMapSql(); } @@ -115,8 +125,10 @@ UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId); ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId); + ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); 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(); } @@ -129,8 +141,10 @@ UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId); ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId); + ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); ub.set(DealTime, this.getDealTime(), this.isset_dealTime); + ub.set(LastRecord, this.getLastRecord(), this.isset_lastRecord); return ub.genMapSql(where, parameters); } @@ -142,8 +156,10 @@ UpdateBuilder ub = new UpdateBuilder(this.getTableName_()); ub.set(WarehouseFlowId, this.getWarehouseFlowId(), this.isset_warehouseFlowId); ub.set(WhGoodsId, this.getWhGoodsId(), this.isset_whGoodsId); + ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType); ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId); ub.set(DealTime, this.getDealTime(), this.isset_dealTime); + ub.set(LastRecord, this.getLastRecord(), this.isset_lastRecord); return ub.genArraySql(where, parameters); } @@ -191,7 +207,7 @@ */ @Override public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { - return new SqlAndParameters<>("select id, warehouse_flow_id, wh_goods_id, warehouse_id, deal_time from " + this.getTableName_() + " " + where, parameters); + return new SqlAndParameters<>("select id, warehouse_flow_id, wh_goods_id, warehouse_type, warehouse_id, deal_time, last_record from " + this.getTableName_() + " " + where, parameters); } /** @@ -199,7 +215,7 @@ */ @Override public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { - return new SqlAndParameters<>("select id, warehouse_flow_id, wh_goods_id, warehouse_id, deal_time from " + this.getTableName_() + " " + where, parameters); + return new SqlAndParameters<>("select id, warehouse_flow_id, wh_goods_id, warehouse_type, warehouse_id, deal_time, last_record from " + this.getTableName_() + " " + where, parameters); } /** @@ -252,6 +268,14 @@ l_goods_wh_record.setWhGoodsId(rs.getLong(columnIndex)); } } + columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.WarehouseType); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_goods_wh_record.setWarehouseType(null); + } else { + l_goods_wh_record.setWarehouseType(rs.getInt(columnIndex)); + } + } columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.WarehouseId); if (columnIndex > 0) { if (rs.getBigDecimal(columnIndex) == null) { @@ -268,6 +292,14 @@ l_goods_wh_record.setDealTime(rs.getLong(columnIndex)); } } + columnIndex = resultSetUtils.findColumn(rs, LGoodsWhRecord_mapper.LastRecord); + if (columnIndex > 0) { + if (rs.getBigDecimal(columnIndex) == null) { + l_goods_wh_record.setLastRecord(null); + } else { + l_goods_wh_record.setLastRecord(rs.getInt(columnIndex)); + } + } return l_goods_wh_record; } } -- Gitblit v1.9.1