| | |
| | | return select(sql.toString(), paramts, new MapperUtil()); |
| | | } |
| | | |
| | | @Override |
| | | public List<BaseGoodsModels> queryGoodsModelByGoodsTemplatesId(Long baseGoodsModelsId) { |
| | | StringBuilder sql = new StringBuilder("select * from base_goods_models where states != 3 "); |
| | | HashMap<String, Object> param = new HashMap<>(); |
| | | if (baseGoodsModelsId != null) { |
| | | sql.append("and goods_templates_id=:baseGoodsModelsId"); |
| | | param.put("baseGoodsModelsId", baseGoodsModelsId); |
| | | } |
| | | return select(sql.toString(), param, new BaseGoodsModels()); |
| | | } |
| | | |
| | | } |