feat: 部门退回/报废公用接口

cy

2023-12-01 01107e8aadfaf1e84a971d8eeb9ab37e1c5569f3

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

@@ -14,7 +14,8 @@
import java.util.Map;

/**
 * 表名:L_WH_PROCURE_MODEL *
 * 表名:L_WH_PROCURE_MODEL
 *
 * @author genrator
 */
public class LWhProcureModel_mapper extends LWhProcureModel implements BaseMapper<LWhProcureModel> {
@@ -31,11 +32,12 @@
    public static final String BusinessId = "business_id";
    public static final String BaseGoodsModelsId = "base_goods_models_id";
    public static final String BaseGoodsModelsName = "base_goods_models_name";
    public static final String Unit = "unit";
    public static final String Price = "price";
    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";
    public static final String UseCount = "use_count";

    /**
     * 默认构造函数
@@ -64,9 +66,6 @@
        if (lWhProcureModel.isset_baseGoodsModelsName) {
            this.setBaseGoodsModelsName(lWhProcureModel.getBaseGoodsModelsName());
        }
        if (lWhProcureModel.isset_unit) {
            this.setUnit(lWhProcureModel.getUnit());
        }
        if (lWhProcureModel.isset_price) {
            this.setPrice(lWhProcureModel.getPrice());
        }
@@ -78,6 +77,12 @@
        }
        if (lWhProcureModel.isset_supplier) {
            this.setSupplier(lWhProcureModel.getSupplier());
        }
        if (lWhProcureModel.isset_totalAmount) {
            this.setTotalAmount(lWhProcureModel.getTotalAmount());
        }
        if (lWhProcureModel.isset_useCount) {
            this.setUseCount(lWhProcureModel.getUseCount());
        }
        // 去掉，2022-09-07
        // this.setDatabaseName_(l_wh_procure_model.getDatabaseName_());
@@ -127,11 +132,12 @@
        ib.set(BusinessId, this.getBusinessId(), this.isset_businessId);
        ib.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ib.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        ib.set(Unit, this.getUnit(), this.isset_unit);
        ib.set(Price, this.getPrice(), this.isset_price);
        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);
        ib.set(UseCount, this.getUseCount(), this.isset_useCount);
        return ib.genMapSql();
    }

@@ -146,11 +152,12 @@
        ub.set(BusinessId, this.getBusinessId(), this.isset_businessId);
        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        ub.set(Unit, this.getUnit(), this.isset_unit);
        ub.set(Price, this.getPrice(), this.isset_price);
        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.set(UseCount, this.getUseCount(), this.isset_useCount);
        ub.where(this.getPkName_(), this.getPkValue_());
        return ub.genMapSql();
    }
@@ -166,11 +173,12 @@
        ub.set(BusinessId, this.getBusinessId(), this.isset_businessId);
        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        ub.set(Unit, this.getUnit(), this.isset_unit);
        ub.set(Price, this.getPrice(), this.isset_price);
        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.set(UseCount, this.getUseCount(), this.isset_useCount);
        return ub.genMapSql(where, parameters);
    }

@@ -185,11 +193,12 @@
        ub.set(BusinessId, this.getBusinessId(), this.isset_businessId);
        ub.set(BaseGoodsModelsId, this.getBaseGoodsModelsId(), this.isset_baseGoodsModelsId);
        ub.set(BaseGoodsModelsName, this.getBaseGoodsModelsName(), this.isset_baseGoodsModelsName);
        ub.set(Unit, this.getUnit(), this.isset_unit);
        ub.set(Price, this.getPrice(), this.isset_price);
        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.set(UseCount, this.getUseCount(), this.isset_useCount);
        return ub.genArraySql(where, parameters);
    }

@@ -237,7 +246,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, unit, 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, use_count from " + this.getTableName_() + " " + where, parameters);
    }

    /**
@@ -245,7 +254,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, unit, 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, use_count from " + this.getTableName_() + " " + where, parameters);
    }

    /**
@@ -318,16 +327,12 @@
        if (columnIndex > 0) {
            l_wh_procure_model.setBaseGoodsModelsName(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.Unit);
        if (columnIndex > 0) {
            l_wh_procure_model.setUnit(rs.getString(columnIndex));
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.Price);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_procure_model.setPrice(null);
            } else {
                l_wh_procure_model.setPrice(rs.getDouble(columnIndex));
                l_wh_procure_model.setPrice(rs.getLong(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.Counts);
@@ -350,6 +355,22 @@
        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));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhProcureModel_mapper.UseCount);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_procure_model.setUseCount(null);
            } else {
                l_wh_procure_model.setUseCount(rs.getInt(columnIndex));
            }
        }
        return l_wh_procure_model;
    }
}