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

cy

2023-12-01 01107e8aadfaf1e84a971d8eeb9ab37e1c5569f3

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

@@ -7,8 +7,6 @@
import com.walker.jdbc.sqlgen.InsertBuilder;
import com.walker.jdbc.sqlgen.SelectBuilder;
import com.walker.jdbc.sqlgen.UpdateBuilder;
import com.walker.jdbc.util.StringUtils;

import org.springframework.jdbc.core.RowMapper;

import java.sql.ResultSet;
@@ -35,6 +33,7 @@
    public static final String NowUserPhone = "now_user_phone";
    public static final String NowUserName = "now_user_name";
    public static final String GoodsNum = "goods_num";
    public static final String UseCount = "use_count";

    /**
     * 默认构造函数
@@ -68,6 +67,9 @@
        }
        if (lWhProcureModelUser.isset_goodsNum) {
            this.setGoodsNum(lWhProcureModelUser.getGoodsNum());
        }
        if (lWhProcureModelUser.isset_useCount) {
            this.setUseCount(lWhProcureModelUser.getUseCount());
        }
        // 去掉，2022-09-07
        // this.setDatabaseName_(l_wh_procure_model_user.getDatabaseName_());
@@ -119,6 +121,7 @@
        ib.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone);
        ib.set(NowUserName, this.getNowUserName(), this.isset_nowUserName);
        ib.set(GoodsNum, this.getGoodsNum(), this.isset_goodsNum);
        ib.set(UseCount, this.getUseCount(), this.isset_useCount);
        return ib.genMapSql();
    }

@@ -135,6 +138,7 @@
        ub.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone);
        ub.set(NowUserName, this.getNowUserName(), this.isset_nowUserName);
        ub.set(GoodsNum, this.getGoodsNum(), this.isset_goodsNum);
        ub.set(UseCount, this.getUseCount(), this.isset_useCount);
        ub.where(this.getPkName_(), this.getPkValue_());
        return ub.genMapSql();
    }
@@ -152,6 +156,7 @@
        ub.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone);
        ub.set(NowUserName, this.getNowUserName(), this.isset_nowUserName);
        ub.set(GoodsNum, this.getGoodsNum(), this.isset_goodsNum);
        ub.set(UseCount, this.getUseCount(), this.isset_useCount);
        return ub.genMapSql(where, parameters);
    }

@@ -168,6 +173,7 @@
        ub.set(NowUserPhone, this.getNowUserPhone(), this.isset_nowUserPhone);
        ub.set(NowUserName, this.getNowUserName(), this.isset_nowUserName);
        ub.set(GoodsNum, this.getGoodsNum(), this.isset_goodsNum);
        ub.set(UseCount, this.getUseCount(), this.isset_useCount);
        return ub.genArraySql(where, parameters);
    }

@@ -215,7 +221,7 @@
     */
    @Override
    public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) {
        return new SqlAndParameters<>("select id, trans_business_id, procure_model_user_record_id, wh_procure_model_id, base_goods_models_id, now_user_phone, now_user_name, goods_num from " + this.getTableName_() + " " + where, parameters);
        return new SqlAndParameters<>("select id, trans_business_id, procure_model_user_record_id, wh_procure_model_id, base_goods_models_id, now_user_phone, now_user_name, goods_num, use_count from " + this.getTableName_() + " " + where, parameters);
    }

    /**
@@ -223,7 +229,7 @@
     */
    @Override
    public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) {
        return new SqlAndParameters<>("select id, trans_business_id, procure_model_user_record_id, wh_procure_model_id, base_goods_models_id, now_user_phone, now_user_name, goods_num from " + this.getTableName_() + " " + where, parameters);
        return new SqlAndParameters<>("select id, trans_business_id, procure_model_user_record_id, wh_procure_model_id, base_goods_models_id, now_user_phone, now_user_name, goods_num, use_count from " + this.getTableName_() + " " + where, parameters);
    }

    /**
@@ -312,6 +318,14 @@
                l_wh_procure_model_user.setGoodsNum(rs.getInt(columnIndex));
            }
        }
        columnIndex = resultSetUtils.findColumn(rs, LWhProcureModelUser_mapper.UseCount);
        if (columnIndex > 0) {
            if (rs.getBigDecimal(columnIndex) == null) {
                l_wh_procure_model_user.setUseCount(null);
            } else {
                l_wh_procure_model_user.setUseCount(rs.getInt(columnIndex));
            }
        }
        return l_wh_procure_model_user;
    }
}