67,513
社区成员
发帖
与我相关
我的任务
分享
public List<Map<String, Object>> getServItemByMecNo(String mecNo) {
Map<String, Object> map =new HashMap<String,Object>();
map.put("mecNo", mecNo);
map.put("delflag", HinsEnum.DelFlagStatus.NOT_DELETE.getValue());
return this.find("select servItemNo as servItemNo ,servItemName as servItemName from ServItem where mecNo=:mecNo and delflag=:delflag group by servItemNo,servItemName", map);
}