| | |
| | | @Select("select * from fd_repertory_nexus where sdepartNo=#{sdepartNo} ") |
| | | public List<FdRepertoryNexus> getBySdepartNo(String sdepartNo); |
| | | |
| | | @Select("select b.name+'('+a.name+')' ckName,b.code+'_'+a.depotNo as code from repertory a LEFT JOIN nc_ywdy b on a.pk_org =b.pkid where a.depotNo LIKE 'C%' and b.code in ('101','102','103','113','111') ORDER BY b.code ASC ") |
| | | @Select("select b.name+'('+a.name+')' ckName,b.code+'_'+a.depotNo as code from repertory a LEFT JOIN nc_ywdy b on a.pk_org =b.pkid where a.depotNo LIKE 'C%' and b.code in ('101','102','103','113','111','114') ORDER BY b.code ASC ") |
| | | public List<Map<String, Object>> getAllCk(); |
| | | |
| | | |
| | |
| | | @RequestMapping(value = "/getallCkList.htm", method = {RequestMethod.POST }) |
| | | @ResponseBody |
| | | public String getList(HttpServletRequest r,HttpServletResponse re){ |
| | | |
| | | |
| | | |
| | | // 此处需要改成可以配置的,可以配置的厂区仓库 |
| | | List<Map<String, Object>> ckList = rnper.getAllCk(); |
| | | PageResult<Map<String, Object>> prr=new PageResult<Map<String,Object>>(); |
| | | prr.setCode(0); |