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.SysLogBean; import com.slcf.pojo.UserBean; import com.slcf.pojo.WorkNoBean; import com.slcf.service.RoleService; import com.slcf.service.SysLogService; import com.slcf.service.WorkNoService; import com.slcf.util.AuthorityCode; /** * 工作号控制器层 * @author admin * @date 2018年11月7日 */ @Controller @RequestMapping("/basic") public class WorkNoController { @Resource WorkNoService workNoService; @Autowired SysLogService sysLogService; @Autowired RoleService roleService; @RequestMapping("/goWorkNo.action") public String goWorkNoPage(HttpServletRequest request){ try { String rid = request.getSession().getAttribute("ROLEID").toString(); String authCode = roleService.getAuthListByRoleMenu(Integer.parseInt(rid), AuthorityCode.WorkNoCode); 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("goWorkNo.action"); sysLog.setTts_keyname("访问:工作序号查询"); sysLog.setModi_user(user.getUser_account()); sysLogService.insertSysLog(sysLog); }catch (Exception e) { System.out.println(e.getMessage()); } return "workNo"; } /** * 添加工作状态 * @param workNo * @param request * @return */ @ResponseBody @RequestMapping("/addWorkNo.action") public Integer insertWorkNo(WorkNoBean workNo,HttpServletRequest request){ int result=0; try { UserBean user=(UserBean)request.getSession().getAttribute("USER"); workNo.setModi_user(user.getUser_account()); result=workNoService.insertWorkNo(workNo); // 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("addWorkNo.action"); sysLog.setTts_keyname("添加工作号分配:" + workNo.getWrk_mk()); 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("/workNoList.action") public Map queryWorkNoListByPages( @RequestParam(value="pageNumber",defaultValue="1",required=false)int pageNumber, @RequestParam("pageSize")int pageSize){ Mapmap=new HashMap(); try { int count=workNoService.queryWorkNoCount(); Listdlist=workNoService.queryWorkNoList((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("/queryWorkNoById.action") public WorkNoBean queryWorkNoById(@RequestParam("did")int id){ try { return workNoService.queryWorkNoById(id); }catch(Exception e) { System.out.println(e.getMessage()); return null; } } /** * 验证工作代号是否唯一 * @param did * @return */ @ResponseBody @RequestMapping("/checkWorkNo.action") public Map checkWorkNo(@RequestParam("did")int id){ Map map=new HashMap(); // boolean flag=userService.validUserAccount(account, uid); try { WorkNoBean workNo = workNoService.queryWorkNoById(id); if(workNo==null){ map.put("msg", "代号可用"); }else{ map.put("msg", "代号不可用"); } }catch(Exception e) { System.out.println(e.getMessage()); } return map; } /** * 修改信息 * @param workNo * @return */ @ResponseBody @RequestMapping("/upWorkNo.action") public Integer upWorkNo(WorkNoBean workNo,HttpServletRequest request){ int result = 0; try { UserBean user=(UserBean)request.getSession().getAttribute("USER"); workNo.setModi_user(user.getUser_account()); result=workNoService.upWorkNo(workNo); 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("upWorkNo.action"); sysLog.setTts_keyname("修改工作号分配:" + workNo.getWrk_mk()); sysLog.setModi_user(user.getUser_account()); sysLogService.insertSysLog(sysLog); } }catch(Exception e) { System.out.println(e.getMessage()); } return result; } /** * 删除信息 * @param id * @return */ @ResponseBody @RequestMapping("/delWorkNo.action") public int delWorkNo(@RequestParam("did")int id,HttpServletRequest request){ int result = 0; try { result=workNoService.delWorkNo(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("delWorkNo.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("/getWorkNo.action") public List getWorkNo(){ try { return workNoService.getWorkNoList(); }catch(Exception e) { System.out.println(e.getMessage()); return null; } } }