| | |
| | | public static final String Counts = "counts"; |
| | | public static final String GoodsUserName = "goods_user_name"; |
| | | public static final String Beiz = "beiz"; |
| | | public static final String TotalAmount = "total_amount"; |
| | | |
| | | /** |
| | | * 默认构造函数 |
| | |
| | | if (depFormScrappedModel.isset_beiz) { |
| | | this.setBeiz(depFormScrappedModel.getBeiz()); |
| | | } |
| | | if (depFormScrappedModel.isset_totalAmount) { |
| | | this.setTotalAmount(depFormScrappedModel.getTotalAmount()); |
| | | } |
| | | // 去掉,2022-09-07 |
| | | // this.setDatabaseName_(dep_form_scrapped_model.getDatabaseName_()); |
| | | } |
| | |
| | | ib.set(Counts, this.getCounts(), this.isset_counts); |
| | | ib.set(GoodsUserName, this.getGoodsUserName(), this.isset_goodsUserName); |
| | | ib.set(Beiz, this.getBeiz(), this.isset_beiz); |
| | | ib.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount); |
| | | return ib.genMapSql(); |
| | | } |
| | | |
| | |
| | | ub.set(Counts, this.getCounts(), this.isset_counts); |
| | | ub.set(GoodsUserName, this.getGoodsUserName(), this.isset_goodsUserName); |
| | | ub.set(Beiz, this.getBeiz(), this.isset_beiz); |
| | | ub.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount); |
| | | ub.where(this.getPkName_(), this.getPkValue_()); |
| | | return ub.genMapSql(); |
| | | } |
| | |
| | | ub.set(Counts, this.getCounts(), this.isset_counts); |
| | | ub.set(GoodsUserName, this.getGoodsUserName(), this.isset_goodsUserName); |
| | | ub.set(Beiz, this.getBeiz(), this.isset_beiz); |
| | | ub.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount); |
| | | return ub.genMapSql(where, parameters); |
| | | } |
| | | |
| | |
| | | ub.set(Counts, this.getCounts(), this.isset_counts); |
| | | ub.set(GoodsUserName, this.getGoodsUserName(), this.isset_goodsUserName); |
| | | ub.set(Beiz, this.getBeiz(), this.isset_beiz); |
| | | ub.set(TotalAmount, this.getTotalAmount(), this.isset_totalAmount); |
| | | return ub.genArraySql(where, parameters); |
| | | } |
| | | |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { |
| | | return new SqlAndParameters<>("select id, dep_form_scrapped_id, dep_form_scrapped_goods_id, scrapped_code, scrapped_name, base_goods_template_id, base_goods_template_name, classification, unit, base_goods_models_id, base_goods_models_name, procure_model_user_id, initial_count, use_count, counts, goods_user_name, beiz from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, dep_form_scrapped_id, dep_form_scrapped_goods_id, scrapped_code, scrapped_name, base_goods_template_id, base_goods_template_name, classification, unit, base_goods_models_id, base_goods_models_name, procure_model_user_id, initial_count, use_count, counts, goods_user_name, beiz, total_amount from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { |
| | | return new SqlAndParameters<>("select id, dep_form_scrapped_id, dep_form_scrapped_goods_id, scrapped_code, scrapped_name, base_goods_template_id, base_goods_template_name, classification, unit, base_goods_models_id, base_goods_models_name, procure_model_user_id, initial_count, use_count, counts, goods_user_name, beiz from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, dep_form_scrapped_id, dep_form_scrapped_goods_id, scrapped_code, scrapped_name, base_goods_template_id, base_goods_template_name, classification, unit, base_goods_models_id, base_goods_models_name, procure_model_user_id, initial_count, use_count, counts, goods_user_name, beiz, total_amount from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | if (columnIndex > 0) { |
| | | dep_form_scrapped_model.setBeiz(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, DepFormScrappedModel_mapper.TotalAmount); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |
| | | dep_form_scrapped_model.setTotalAmount(null); |
| | | } else { |
| | | dep_form_scrapped_model.setTotalAmount(rs.getInt(columnIndex)); |
| | | } |
| | | } |
| | | return dep_form_scrapped_model; |
| | | } |
| | | } |