1.出库手续回显 2.调拨申请时库存查询更换接口 3.调拨出库时从已有物品所在的仓库中选择

futian.liu

2023-12-15 b268fd73f060108b8214ed1afcbbf03480435f3a

 consum-model-pojo/src/main/java/com/consum/model/po/LWhGoodsRecord_mapper.java

@@ -38,6 +38,7 @@
    public static final String BaseGoodsModelsId = "base_goods_models_id";
    public static final String BaseGoodsModelsName = "base_goods_models_name";
    public static final String DealTime = "deal_time";
    public static final String TotalPrice = "total_price";

    /**
     * 默认构造函数
@@ -86,6 +87,9 @@
        }
        if (lWhGoodsRecord.isset_dealTime) {
            this.setDealTime(lWhGoodsRecord.getDealTime());
        }
        if (lWhGoodsRecord.isset_totalPrice) {
            this.setTotalPrice(lWhGoodsRecord.getTotalPrice());
        }
        // 去掉，2022-09-07
        // this.setDatabaseName_(l_wh_goods_record.getDatabaseName_());
@@ -142,6 +146,7 @@
        ib.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ib.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        ib.set(DealTime, this.getDealTime(), this.isset_dealTime);
        ib.set(TotalPrice, this.getTotalPrice(), this.isset_totalPrice);
        return ib.genMapSql();
    }

@@ -163,6 +168,7 @@
        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
        ub.set(TotalPrice, this.getTotalPrice(), this.isset_totalPrice);
        ub.where(this.getPkName_(), this.getPkValue_());
        return ub.genMapSql();
    }
@@ -185,6 +191,7 @@
        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
        ub.set(TotalPrice, this.getTotalPrice(), this.isset_totalPrice);
        return ub.genMapSql(where, parameters);
    }

@@ -206,6 +213,7 @@
        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        ub.set(DealTime, this.getDealTime(), this.isset_dealTime);
        ub.set(TotalPrice, this.getTotalPrice(), this.isset_totalPrice);
        return ub.genArraySql(where, parameters);
    }

@@ -253,7 +261,7 @@
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_flow_id, initial_count, this_type, this_count, end_count, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, deal_time from " + this.getTableName_() + " " + where, parameters);
        return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_flow_id, initial_count, this_type, this_count, end_count, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, deal_time, total_price from " + this.getTableName_() + " " + where, parameters);
    }

    /**
@@ -261,7 +269,7 @@
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_flow_id, initial_count, this_type, this_count, end_count, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, deal_time from " + this.getTableName_() + " " + where, parameters);
        return new SqlAndParameters<>("select id, warehouse_type, warehouse_id, warehouse_flow_id, initial_count, this_type, this_count, end_count, base_goods_template_id, goods_template_name, base_goods_models_id, base_goods_models_name, deal_time, total_price from " + this.getTableName_() + " " + where, parameters);
    }

    /**
@@ -386,6 +394,14 @@
                l_wh_goods_record.setDealTime(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhGoodsRecord_mapper.TotalPrice);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_goods_record.setTotalPrice(null);
            } else {
                l_wh_goods_record.setTotalPrice(rs.getLong(columnIndex));
            }
        }
        return l_wh_goods_record;
    }
}