| | |
| | | public List<LWhProcureModel> getModelByForm(WhBusinessEnum businessType, Long businessId) { |
| | | StringBuilder sql = new StringBuilder(GET_MODEL_BY_FORM); |
| | | HashMap<String, Object> paramts = new HashMap<>(); |
| | | // 项目阶段id |
| | | if (businessType != null) { |
| | | sql.append(" and BUSINESS_TYPE=:businessType "); |
| | | paramts.put("businessType", businessType.getValue()); |
| | |
| | | public List<Map<String, Object>> getFfOrderByGoodsIdAndDept(Long goodsTemplateId, Long departmentId) { |
| | | StringBuilder sql = new StringBuilder(GET_FF_ORDER_BY_GOODS_ID_AND_DEPT); |
| | | HashMap<String, Object> paramts = new HashMap<>(); |
| | | // 项目阶段id |
| | | if (goodsTemplateId != null) { |
| | | sql.append(" AND baseTemp.ID=:goodsTemplateId "); |
| | | paramts.put("goodsTemplateId", goodsTemplateId); |
| | |
| | | }); |
| | | return goodsModelList; |
| | | } |
| | | |
| | | @Override |
| | | public List<LWhProcureModel> getModelByForm1(WhBusinessEnum businessType, Long businessId) { |
| | | StringBuilder sql = new StringBuilder("SELECT * FROM L_WH_PROCURE_MODEL WHERE 1=1 "); |
| | | HashMap<String, Object> paramts = new HashMap<>(); |
| | | if (businessType != null) { |
| | | sql.append(" and BUSINESS_TYPE=:businessType "); |
| | | paramts.put("businessType", businessType.getValue()); |
| | | } |
| | | if (businessId != null) { |
| | | sql.append(" and BUSINESS_ID=:businessId "); |
| | | paramts.put("businessId", businessId); |
| | | } |
| | | List<LWhProcureModel> select = select(sql.toString(), paramts, new LWhProcureModel()); |
| | | return select; |
| | | } |
| | | } |