CRM

1，登录

@Resourceprivate UserService userService;/** * 用户登录 * @param user * @param request * @return * @throws Exception */@RequestMapping("/login")public String login(User user,HttpServletRequest request)throws Exception{User resultUser=userService.login(user);if(resultUser==null){request.setAttribute("user", user);request.setAttribute("errorMsg", "用户名或密码错误！");return "login";}else{HttpSession session=request.getSession();session.setAttribute("currentUser", resultUser);return "redirect:/main.jsp";}}

2，分页查询用户

/** * 分页条件查询用户 * @param page * @param rows * @param s_user * @param response * @return * @throws Exception */@RequestMapping("/list")public String list(@RequestParam(value="page",required=false)String page,@RequestParam(value="rows",required=false)String rows,User s_user,HttpServletResponse response)throws Exception{PageBean pageBean=new PageBean(Integer.parseInt(page),Integer.parseInt(rows));Map<String,Object> map=new HashMap<String,Object>();map.put("userName", StringUtil.formatLike(s_user.getUserName()));map.put("start", pageBean.getStart());map.put("size", pageBean.getPageSize());List<User> userList=userService.find(map);Long total=userService.getTotal(map);JSONObject result=new JSONObject();JSONArray jsonArray=JSONArray.fromObject(userList);result.put("rows", jsonArray);result.put("total", total);ResponseUtil.write(response, result);return null;}

3，获取数据库信息，下拉框数据用到

/** * 获取客户经理信息 下拉框数据用到 * @param response * @return * @throws Exception */@RequestMapping("/customerManagerComboList")public String customerManagerComboList(HttpServletResponse response)throws Exception{Map<String,Object> map=new HashMap<String,Object>();map.put("roleName", "客户经理");List<User> userList=userService.find(map);JSONArray row=JSONArray.fromObject(userList);ResponseUtil.write(response, row);return null;}

4，添加或修改用户

/** * 添加或者修改用户 * @param user * @param response * @return * @throws Exception */@RequestMapping("/save")public String save(User user,HttpServletResponse response)throws Exception{int resultTotal=0; // 操作的记录条数if(user.getId()==null){resultTotal=userService.add(user);}else{resultTotal=userService.update(user);}JSONObject result=new JSONObject();if(resultTotal>0){result.put("success", true);}else{result.put("success", false);}ResponseUtil.write(response, result);return null;}

5，删除用户

/** * 删除用户 * @param ids * @param response * @return * @throws Exception */@RequestMapping("/delete")public String delete(@RequestParam(value="ids")String ids,HttpServletResponse response)throws Exception{String []idsStr=ids.split(",");for(int i=0;i<idsStr.length;i++){userService.delete(Integer.parseInt(idsStr[i]));}JSONObject result=new JSONObject();result.put("success", true);ResponseUtil.write(response, result);return null;}

6，用户注销

/** * 用户注销 * @param session * @return * @throws Exception */@RequestMapping("/logout")public String logout(HttpSession session)throws Exception{session.invalidate();return "redirect:/login.jsp";}

7，通过ID查找实体

/** * 通过ID查找实体 * @param id * @param response * @return * @throws Exception */@RequestMapping("/findById")public String findById(@RequestParam(value="id")String id,HttpServletResponse response)throws Exception{SaleChance saleChance=saleChanceService.findById(Integer.parseInt(id));JsonConfig jsonConfig=new JsonConfig();jsonConfig.registerJsonValueProcessor(java.util.Date.class, new DateJsonValueProcessor("yyyy-MM-dd HH:mm"));JSONObject jsonObject=JSONObject.fromObject(saleChance, jsonConfig);ResponseUtil.write(response, jsonObject);return null;}

8，修改用户状态

/** * 通过ID查找实体 * @param id * @param response * @return * @throws Exception */@RequestMapping("/findById")public String findById(@RequestParam(value="id")String id,HttpServletResponse response)throws Exception{CustomerLoss customerLoss=customerLossService.findById(Integer.parseInt(id));JsonConfig jsonConfig=new JsonConfig();jsonConfig.registerJsonValueProcessor(java.util.Date.class, new DateJsonValueProcessor("yyyy-MM-dd"));JSONObject jsonObject=JSONObject.fromObject(customerLoss,jsonConfig);ResponseUtil.write(response, jsonObject);return null;}