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/LWhGoods_mapper.java | 22 +++++++++++++++++++---
1 files changed, 19 insertions(+), 3 deletions(-)
diff --git a/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java
index 9fc5e76..d923b0c 100644
--- a/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java
+++ b/consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java
@@ -28,6 +28,7 @@
// 涓婚敭
public static final String Id = "id";
// 鏅�氬睘鎬�
+ public static final String WarehouseType = "warehouse_type";
public static final String WarehouseId = "warehouse_id";
public static final String WarehouseName = "warehouse_name";
public static final String CostType = "cost_type";
@@ -54,6 +55,9 @@
this.setId(lWhGoods.getId());
}
//鏅�氬睘鎬�
+ if (lWhGoods.isset_warehouseType) {
+ this.setWarehouseType(lWhGoods.getWarehouseType());
+ }
if (lWhGoods.isset_warehouseId) {
this.setWarehouseId(lWhGoods.getWarehouseId());
}
@@ -136,6 +140,7 @@
public SqlAndParameters<Map<String, Object>> getInsertSql_() {
InsertBuilder ib = new InsertBuilder(this.getTableName_());
ib.set(Id, this.getId());
+ ib.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
ib.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
ib.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
ib.set(CostType, this.getCostType(), this.isset_costType);
@@ -158,6 +163,7 @@
@Override
public SqlAndParameters<Map<String, Object>> getUpdateSql_() {
UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
ub.set(CostType, this.getCostType(), this.isset_costType);
@@ -181,6 +187,7 @@
@Override
public SqlAndParameters<Map<String, Object>> getUpdateSql_(String where, Map<String, Object> parameters) {
UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
ub.set(CostType, this.getCostType(), this.isset_costType);
@@ -203,6 +210,7 @@
@Override
public SqlAndParameters<Object[]> getUpdateSql_(String where, Object[] parameters) {
UpdateBuilder ub = new UpdateBuilder(this.getTableName_());
+ ub.set(WarehouseType, this.getWarehouseType(), this.isset_warehouseType);
ub.set(WarehouseId, this.getWarehouseId(), this.isset_warehouseId);
ub.set(WarehouseName, this.getWarehouseName(), this.isset_warehouseName);
ub.set(CostType, this.getCostType(), this.isset_costType);
@@ -263,7 +271,7 @@
*/
@Override
public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
- return new SqlAndParameters<>("select id, warehouse_id, warehouse_name, cost_type, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, supplier, buy_type, unit, price, procure_date, states from " + this.getTableName_() + " " + where, parameters);
+ return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_name, cost_type, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, supplier, buy_type, unit, price, procure_date, states from " + this.getTableName_() + " " + where, parameters);
}
/**
@@ -271,7 +279,7 @@
*/
@Override
public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
- return new SqlAndParameters<>("select id, warehouse_id, warehouse_name, cost_type, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, supplier, buy_type, unit, price, procure_date, states from " + this.getTableName_() + " " + where, parameters);
+ return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_name, cost_type, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, supplier, buy_type, unit, price, procure_date, states from " + this.getTableName_() + " " + where, parameters);
}
/**
@@ -308,6 +316,14 @@
l_wh_goods.setId(rs.getLong(columnIndex));
}
//鏅�氬睘鎬�
+ columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.WarehouseType);
+ if (columnIndex > 0) {
+ if (rs.getBigDecimal(columnIndex) == null) {
+ l_wh_goods.setWarehouseType(null);
+ } else {
+ l_wh_goods.setWarehouseType(rs.getInt(columnIndex));
+ }
+ }
columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.WarehouseId);
if (columnIndex > 0) {
if (rs.getBigDecimal(columnIndex) == null) {
@@ -373,7 +389,7 @@
if (rs.getBigDecimal(columnIndex) == null) {
l_wh_goods.setPrice(null);
} else {
- l_wh_goods.setPrice(rs.getDouble(columnIndex));
+ l_wh_goods.setPrice(rs.getLong(columnIndex));
}
}
columnIndex = resultSetUtils.findColumn(rs, LWhGoods_mapper.ProcureDate);
--
Gitblit v1.9.1