package com.slcf.controller; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; import com.slcf.pojo.UserBean; import com.slcf.pojo.RowNoBean; import com.slcf.pojo.SysLogBean; import com.slcf.service.RoleService; import com.slcf.service.RowNoService; import com.slcf.service.SysLogService; import com.slcf.util.AuthorityCode; /** * 库位排号控制器层 * @author admin * @date 2018年11月6日 */ @Controller @RequestMapping("/basic") public class RowNoController { @Resource RowNoService rowNoService; @Autowired SysLogService sysLogService; @Autowired RoleService roleService; @RequestMapping("/goRowNo.action") public String goRowNoPage(HttpServletRequest request){ try { String rid = request.getSession().getAttribute("ROLEID").toString(); String authCode = roleService.getAuthListByRoleMenu(Integer.parseInt(rid), AuthorityCode.RowNoCode); request.getSession().setAttribute("AUTHCODE",authCode); // 插入日志 UserBean user = (UserBean) request.getSession().getAttribute("USER"); SysLogBean sysLog = new SysLogBean(); sysLog.setLogin_no(user.getUser_account()); sysLog.setMachine_ip(request.getRemoteAddr()); sysLog.setForm_no("goRowNo.action"); sysLog.setTts_keyname("访问:库位排号分配"); sysLog.setModi_user(user.getUser_account()); sysLogService.insertSysLog(sysLog); }catch (Exception e) { System.out.println(e.getMessage()); } return "rowNo"; } /** * 添加工作状态 * @param RowNo * @param request * @return */ @ResponseBody @RequestMapping("/addRowNo.action") public Integer insertRowNo(RowNoBean rowNo,HttpServletRequest request){ int result=0; try { UserBean user=(UserBean)request.getSession().getAttribute("USER"); rowNo.setModi_user(user.getUser_account()); if(rowNo.getWrk_mk()==null) { rowNo.setWrk_mk("0"); } result=rowNoService.insertRowNo(rowNo); // System.out.println(i+"++++++++++++"); if(result>0) { // 插入日志 // UserBean user = (UserBean) request.getSession().getAttribute("USER"); SysLogBean sysLog = new SysLogBean(); sysLog.setLogin_no(user.getUser_account()); sysLog.setMachine_ip(request.getRemoteAddr()); sysLog.setForm_no("addRowNo.action"); sysLog.setTts_keyname("添加排号分配仓库别:" + rowNo.getWhs_type()); sysLog.setModi_user(user.getUser_account()); sysLogService.insertSysLog(sysLog); } }catch(Exception e) { System.out.println(e.getMessage()); } return result; } /** * 分页查询所有 * @param pageNumber * @param pageSize * @return */ @ResponseBody @RequestMapping("/rowNoList.action") public Map queryRowNoListByPages( @RequestParam(value="pageNumber",defaultValue="1",required=false)int pageNumber, @RequestParam("pageSize")int pageSize){ Mapmap=new HashMap(); try { int count=rowNoService.queryRowNoCount(); Listdlist=rowNoService.queryRowNoList((pageNumber-1)*pageSize, pageSize); map.put("total", count); map.put("rows", dlist); }catch(Exception e) { System.out.println(e.getMessage()); } return map; } /** * 根据id查询信息 * @param id * @return */ @ResponseBody @RequestMapping("/queryRowNoById.action") public RowNoBean queryRowNoById(@RequestParam("did")int id){ try { return rowNoService.queryRowNoById(id); }catch(Exception e) { System.out.println(e.getMessage()); return null; } } /** * 验证工作代号是否唯一 * @param did * @return */ @ResponseBody @RequestMapping("/checkRowNo.action") public Map checkRowNo(@RequestParam("did")int id){ Map map=new HashMap(); // boolean flag=userService.validUserAccount(account, uid); try { RowNoBean RowNo = rowNoService.queryRowNoById(id); if(RowNo==null){ map.put("msg", "代号可用"); }else{ map.put("msg", "代号不可用"); } }catch(Exception e) { System.out.println(e.getMessage()); } return map; } /** * 修改信息 * @param RowNo * @return */ @ResponseBody @RequestMapping("/upRowNo.action") public Integer upRowNo(RowNoBean rowNo,HttpServletRequest request){ int result = 0; try { UserBean user=(UserBean)request.getSession().getAttribute("USER"); rowNo.setModi_user(user.getUser_account()); if(rowNo.getWrk_mk()==null) { rowNo.setWrk_mk("0"); } result=rowNoService.upRowNo(rowNo); if(result>0) { // 插入日志 // UserBean user = (UserBean) request.getSession().getAttribute("USER"); SysLogBean sysLog = new SysLogBean(); sysLog.setLogin_no(user.getUser_account()); sysLog.setMachine_ip(request.getRemoteAddr()); sysLog.setForm_no("upRowNo.action"); sysLog.setTts_keyname("修改排号分配仓库别:" + rowNo.getWhs_type()); sysLog.setModi_user(user.getUser_account()); sysLogService.insertSysLog(sysLog); } }catch(Exception e) { System.out.println(e.getMessage()); } return result; } /** * 删除信息 * @param id * @return */ @ResponseBody @RequestMapping("/delRowNo.action") public int delRowNo(@RequestParam("did")int id,HttpServletRequest request){ int result = 0; try { result=rowNoService.delRowNo(id); if(result>0) { // 插入日志 UserBean user = (UserBean) request.getSession().getAttribute("USER"); SysLogBean sysLog = new SysLogBean(); sysLog.setLogin_no(user.getUser_account()); sysLog.setMachine_ip(request.getRemoteAddr()); sysLog.setForm_no("addRowNo.action"); sysLog.setTts_keyname("删除排号分配仓库别,ID:" + id); sysLog.setModi_user(user.getUser_account()); sysLogService.insertSysLog(sysLog); } }catch(Exception e) { System.out.println(e.getMessage()); } return result; } /** * 查询所有 * @return */ @ResponseBody @RequestMapping("/getRowNo.action") public List getRowNo(){ try { return rowNoService.getRowNoList(); }catch(Exception e) { System.out.println(e.getMessage()); return null; } } }