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.CrnBean; import com.slcf.pojo.SysLogBean; import com.slcf.service.CrnService; import com.slcf.service.RoleService; import com.slcf.service.SysLogService; import com.slcf.util.AuthorityCode; /** * 堆垛机控制器层 * @author admin * @date 2018年11月6日 */ @Controller @RequestMapping("/basic") public class CrnController { @Resource CrnService crnService; @Autowired SysLogService sysLogService; @Autowired RoleService roleService; @RequestMapping("/goCrn.action") public String goCrnPage(HttpServletRequest request){ try { String rid = request.getSession().getAttribute("ROLEID").toString(); String authCode = roleService.getAuthListByRoleMenu(Integer.parseInt(rid), AuthorityCode.CrnCode); 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("goCrn.action"); sysLog.setTts_keyname("访问:堆垛机管理"); sysLog.setModi_user(user.getUser_account()); sysLogService.insertSysLog(sysLog); }catch (Exception e) { System.out.println(e.getMessage()); } return "crn"; } // /** // * 部门名称验证 // * @param name // * @param id // * @return // */ // @ResponseBody // @RequestMapping("/valid.action") // public Map validCrn( // @RequestParam("name")String name, // @RequestParam(value="id",defaultValue="0",required=false)Integer id){ // // Mapmap=new HashMap(); // map.put("name", name); // map.put("id", id); // boolean flag=crnService.validCrn(map); // // Mapmaps=new HashMap(); // if(flag){ // maps.put("i", 1); // maps.put("msg", "此部门名称可用"); // }else{ // maps.put("i", 0); // maps.put("msg", "此部门名称不可用"); // } // return maps; // } /** * 添加工作状态 * @param Crn * @param request * @return */ @ResponseBody @RequestMapping("/addCrn.action") public Integer insertCrn(CrnBean crn,HttpServletRequest request){ int result=0; try { UserBean user=(UserBean)request.getSession().getAttribute("USER"); crn.setModi_user(user.getUser_account()); if(crn.getIn_enable()==null) { crn.setIn_enable("N"); } if(crn.getOut_enable()==null) { crn.setOut_enable("N"); } result=crnService.insertCrn(crn); // 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("addCrn.action"); sysLog.setTts_keyname("添加堆垛机:" + crn.getCrn_no()); 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("/crnList.action") public Map queryCrnListByPages( @RequestParam(value="pageNumber",defaultValue="1",required=false)int pageNumber, @RequestParam("pageSize")int pageSize){ Mapmap=new HashMap(); try { int count=crnService.queryCrnCount(); Listdlist=crnService.queryCrnList((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("/queryCrnById.action") public CrnBean queryCrnById(@RequestParam("did")int id){ try { return crnService.queryCrnById(id); }catch(Exception e) { System.out.println(e.getMessage()); return null; } } /** * 验证工作代号是否唯一 * @param did * @return */ @ResponseBody @RequestMapping("/checkCrn.action") public Map checkCrn(@RequestParam("did")int id){ Map map=new HashMap(); // boolean flag=userService.validUserAccount(account, uid); try { CrnBean Crn = crnService.queryCrnById(id); if(Crn==null){ map.put("msg", "代号可用"); }else{ map.put("msg", "代号不可用"); } }catch(Exception e) { System.out.println(e.getMessage()); } return map; } /** * 修改信息 * @param Crn * @return */ @ResponseBody @RequestMapping("/upCrn.action") public Integer upCrn(CrnBean crn,HttpServletRequest request){ int result = 0; try { UserBean user=(UserBean)request.getSession().getAttribute("USER"); crn.setModi_user(user.getUser_account()); if(crn.getIn_enable()==null) { crn.setIn_enable("N"); } if(crn.getOut_enable()==null) { crn.setOut_enable("N"); } result=crnService.upCrn(crn); 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("upCrn.action"); sysLog.setTts_keyname("修改堆垛机:" + crn.getCrn_no()); sysLog.setModi_user(user.getUser_account()); sysLogService.insertSysLog(sysLog); } }catch(Exception e) { System.out.println(e.getMessage()); } return result; } /** * 删除信息 * @param id * @return */ @ResponseBody @RequestMapping("/delCrn.action") public int delCrn(@RequestParam("did")int id,HttpServletRequest request){ int result = 0; try { result=crnService.delCrn(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("upCrn.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("/getCrn.action") public Map getCrn(){ Map map=new HashMap(); try { map.put("rows",crnService.getCrnList()); }catch(Exception e) { System.out.println(e.getMessage()); } return map; } }