| | |
| | | public static final String Classification = "classification"; |
| | | public static final String States = "states"; |
| | | public static final String CategoryId = "category_id"; |
| | | public static final String CategoryName = "category_name"; |
| | | public static final String FAgencyId = "f_agency_id"; |
| | | public static final String SAgencyId = "s_agency_id"; |
| | | public static final String TAgencyId = "t_agency_id"; |
| | |
| | | } |
| | | if (baseGoodsTemplate.isset_categoryId) { |
| | | this.setCategoryId(baseGoodsTemplate.getCategoryId()); |
| | | } |
| | | if (baseGoodsTemplate.isset_categoryName) { |
| | | this.setCategoryName(baseGoodsTemplate.getCategoryName()); |
| | | } |
| | | if (baseGoodsTemplate.isset_fAgencyId) { |
| | | this.setFAgencyId(baseGoodsTemplate.getFAgencyId()); |
| | |
| | | ib.set(Classification, this.getClassification(), this.isset_classification); |
| | | ib.set(States, this.getStates(), this.isset_states); |
| | | ib.set(CategoryId, this.getCategoryId(), this.isset_categoryId); |
| | | ib.set(CategoryName, this.getCategoryName(), this.isset_categoryName); |
| | | ib.set(FAgencyId, this.getFAgencyId(), this.isset_fAgencyId); |
| | | ib.set(SAgencyId, this.getSAgencyId(), this.isset_sAgencyId); |
| | | ib.set(TAgencyId, this.getTAgencyId(), this.isset_tAgencyId); |
| | |
| | | ub.set(Classification, this.getClassification(), this.isset_classification); |
| | | ub.set(States, this.getStates(), this.isset_states); |
| | | ub.set(CategoryId, this.getCategoryId(), this.isset_categoryId); |
| | | ub.set(CategoryName, this.getCategoryName(), this.isset_categoryName); |
| | | ub.set(FAgencyId, this.getFAgencyId(), this.isset_fAgencyId); |
| | | ub.set(SAgencyId, this.getSAgencyId(), this.isset_sAgencyId); |
| | | ub.set(TAgencyId, this.getTAgencyId(), this.isset_tAgencyId); |
| | |
| | | ub.set(Classification, this.getClassification(), this.isset_classification); |
| | | ub.set(States, this.getStates(), this.isset_states); |
| | | ub.set(CategoryId, this.getCategoryId(), this.isset_categoryId); |
| | | ub.set(CategoryName, this.getCategoryName(), this.isset_categoryName); |
| | | ub.set(FAgencyId, this.getFAgencyId(), this.isset_fAgencyId); |
| | | ub.set(SAgencyId, this.getSAgencyId(), this.isset_sAgencyId); |
| | | ub.set(TAgencyId, this.getTAgencyId(), this.isset_tAgencyId); |
| | |
| | | ub.set(Classification, this.getClassification(), this.isset_classification); |
| | | ub.set(States, this.getStates(), this.isset_states); |
| | | ub.set(CategoryId, this.getCategoryId(), this.isset_categoryId); |
| | | ub.set(CategoryName, this.getCategoryName(), this.isset_categoryName); |
| | | ub.set(FAgencyId, this.getFAgencyId(), this.isset_fAgencyId); |
| | | ub.set(SAgencyId, this.getSAgencyId(), this.isset_sAgencyId); |
| | | ub.set(TAgencyId, this.getTAgencyId(), this.isset_tAgencyId); |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Map<String, Object>> getSelectSql_(String where, Map<String, Object> parameters) { |
| | | return new SqlAndParameters<>("select id, goods_code, goods_name, classification, states, category_id, f_agency_id, s_agency_id, t_agency_id, parent_agency_id, agency_level, agency_id, agency_name, create_date, d_time, d_user_id, d_user_name from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, goods_code, goods_name, classification, states, category_id, category_name, f_agency_id, s_agency_id, t_agency_id, parent_agency_id, agency_level, agency_id, agency_name, create_date, d_time, d_user_id, d_user_name from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | */ |
| | | @Override |
| | | public SqlAndParameters<Object[]> getSelectSql_(String where, Object[] parameters) { |
| | | return new SqlAndParameters<>("select id, goods_code, goods_name, classification, states, category_id, f_agency_id, s_agency_id, t_agency_id, parent_agency_id, agency_level, agency_id, agency_name, create_date, d_time, d_user_id, d_user_name from " + this.getTableName_() + " " + where, parameters); |
| | | return new SqlAndParameters<>("select id, goods_code, goods_name, classification, states, category_id, category_name, f_agency_id, s_agency_id, t_agency_id, parent_agency_id, agency_level, agency_id, agency_name, create_date, d_time, d_user_id, d_user_name from " + this.getTableName_() + " " + where, parameters); |
| | | } |
| | | |
| | | /** |
| | |
| | | base_goods_template.setCategoryId(rs.getLong(columnIndex)); |
| | | } |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.CategoryName); |
| | | if (columnIndex > 0) { |
| | | base_goods_template.setCategoryName(rs.getString(columnIndex)); |
| | | } |
| | | columnIndex = resultSetUtils.findColumn(rs, BaseGoodsTemplate_mapper.FAgencyId); |
| | | if (columnIndex > 0) { |
| | | if (rs.getBigDecimal(columnIndex) == null) { |