From a30a15f292e24f3e93253aec6dcc41b5cc3cc420 Mon Sep 17 00:00:00 2001
From: cy <1664593601@qq.com>
Date: 星期二, 31 十月 2023 11:27:40 +0800
Subject: [PATCH] feat: 盘点单/进出库流水总表/库存物品详情/物品仓库保管记录 实体类
---
consum-model-pojo/src/main/java/com/consum/model/po/LWhGoods_mapper.java | 20 ++++++++++++++++++--
1 files changed, 18 insertions(+), 2 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 0c08812..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) {
--
Gitblit v1.9.1