毕业设计javajsp保险理财ssm-qlkrp源码工具包

package com.kwxy.insurance.controller; import java.io.File; import java.util.Date; import java.util.HashMap; import java.util.List; import java.util.Map; import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Controller; import org.springframework.ui.Model; import org.springframework.web.bind.annotation.RequestMapping; import org.springframework.web.bind.annotation.RequestMethod; import org.springframework.web.bind.annotation.RequestParam; import org.springframework.web.bind.annotation.ResponseBody; import org.springframework.web.multipart.MultipartFile; import org.springframework.web.multipart.commons.CommonsMultipartFile; import com.alibaba.fastjson.JSON; import com.alibaba.fastjson.JSONObject; import com.kwxy.insurance.base.BaseController; import com.kwxy.insurance.po.*; import com.kwxy.insurance.utils.DateUtil; import com.kwxy.insurance.utils.HttpClientUtil; import com.kwxy.insurance.utils.HttpClientUtil2; import com.kwxy.insurance.utils.Pager; import com.kwxy.insurance.utils.UUIDUtils; import java.util.*; import com.kwxy.insurance.po.*; import com.kwxy.insurance.mapper.*; import com.kwxy.insurance.service.*; /** * @ClassName: * @Description: * @author - - admin * @date - 2018年10月29日 21时07分19秒 */ @Controller @RequestMapping("/workOrder") public class WorkOrderController extends BaseController { @Autowired private BxService bxService; /** * 依赖注入 start dao/service/=== */ @Autowired private WorkOrderService workOrderService; @Autowired private BxOrderService bxOrderService; /** * 分页查询 返回list对象(通过对By Sql) * * @param request * @param response * @return */ @RequestMapping(value = "/findBySql") public String findBySql(WorkOrder workOrder, Model model, HttpServletRequest request, HttpServletResponse response) { //分页查询 Object attribute = request.getSession().getAttribute("userId"); if (attribute == null){ return "redirect:/login/login.action"; } Integer userId = Integer.valueOf(attribute.toString()); String sql = "SELECT * FROM work_order WHERE userId= "+userId; if(!isEmpty(workOrder.getUserId())){ sql += " and userId like '%"+workOrder.getUserId()+"%'"; } if(!isEmpty(workOrder.getCode())){ sql += " and code like '%"+workOrder.getCode()+"%'"; } if(!isEmpty(workOrder.getAddress())){ sql += " and address like '%"+workOrder.getAddress()+"%'"; } if(!isEmpty(workOrder.getShrId())){ sql += " and shrId like '%"+workOrder.getShrId()+"%'"; } if(!isEmpty(workOrder.getWprId())){ sql += " and wprId like '%"+workOrder.getWprId()+"%'"; } if(!isEmpty(workOrder.getCwrId())){ sql += " and cwrId like '%"+workOrder.getCwrId()+"%'"; } if(!isEmpty(workOrder.getStatus())){ sql += " and status like '%"+workOrder.getStatus()+"%'"; } if(!isEmpty(workOrder.getMoney())){ sql += " and money like '%"+workOrder.getMoney()+"%'"; } if(!isEmpty(workOrder.getContent())){ sql += " and content like '%"+workOrder.getContent()+"%'"; } sql += " ORDER BY ID DESC "; Pager<WorkOrder> pagers = workOrderService.findBySqlRerturnEntity(sql); model.addAttribute("pagers", pagers); //存储查询条件 model.addAttribute("obj", workOrder); return "workOrder/workOrder"; } /** * 审核员事故认定审核 * @param workOrder * @param model * @param request * @param response * @return */ //shfindBySql1 @RequestMapping(value = "/shfindBySql1") public String shfindBySql1(WorkOrder workOrder, Model model, HttpServletRequest request, HttpServletResponse response) { //分页查询 Object attribute = request.getSession().getAttribute("userId"); if (attribute == null){ return "redirect:/login/login.action"; } Integer userId = Integer.valueOf(attribute.toString()); String sql = "SELECT * FROM work_order WHERE status = 1 "; if(!isEmpty(workOrder.getUserId())){ sql += " and userId like '%"+workOrder.getUserId()+"%'"; } if(!isEmpty(workOrder.getCode())){ sql += " and code like '%"+workOrder.getCode()+"%'"; } if(!isEmpty(workOrder.getAddress())){ sql += " and address like '%"+workOrder.getAddress()+"%'"; } if(!isEmpty(workOrder.getShrId())){ sql += " and shrId like '%"+workOrder.getShrId()+"%'"; } if(!isEmpty(workOrder.getWprId())){ sql += " and wprId like '%"+workOrder.getWprId()+"%'"; } if(!isEmpty(workOrder.getCwrId())){ sql += " and cwrId like '%"+workOrder.getCwrId()+"%'"; } if(!isEmpty(workOrder.getStatus())){ sql += " and status like '%"+workOrder.getStatus()+"%'"; } if(!isEmpty(workOrder.getMoney())){ sql += " and money like '%"+workOrder.getMoney()+"%'"; } if(!isEmpty(workOrder.getContent())){ sql += " and content like '%"+workOrder.getContent()+"%'"; } sql += " ORDER BY ID DESC "; Pager<WorkOrder> pagers = workOrderService.findBySqlRerturnEntity(sql); model.addAttribute("pagers", pagers); //存储查询条件 model.addAttribute("obj", workOrder); return "workOrder/shfindBySql1"; } /** * 理赔审核 * @param workOrder * @param model * @param request * @param response * @return */ //shfindBySql2 @RequestMapping(value = "/shfindBySql2") public String shfindBySql2(WorkOrder workOrder, Model model, HttpServletRequest request, HttpServletResponse response) { //分页查询 Object attribute = request.getSession().getAttribute("userId"); if (attribute == null){ return "redirect:/login/login.action"; } Integer userId = Integer.valueOf(attribute.toString()); String sql = "SELECT * FROM work_order WHERE shrId= "+userId +" and (status = 4 or status = 6) "; if(!isEmpty(workOrder.getUserId())){ sql += " and userId like '%"+workOrder.getUserId()+"%'"; } if(!isEmpty(workOrder.getCode())){ sql += " and code like '%"+workOrder.getCode()+"%'"; } if(!isEmpty(workOrder.getAddress())){ sql += " and address like '%"+workOrder.getAddress()+"%'"; } if(!isEmpty(workOrder.getShrId())){ sql += " and shrId like '%"+workOrder.getShrId()+"%'"; } if(!isEmpty(workOrder.getWprId())){ sql += " and wprId like '%"+workOrder.getWprId()+"%'"; } if(!isEmpty(workOrder.getCwrId())){ sql += " and cwrId like '%"+workOrder.getCwrId()+"%'"; } if(!isEmpty(workOrder.getStatus())){ sql += " and status like '%"+workOrder.getStatus()+"%'"; } if(!isEmpty(workOrder.getMoney())){ sql += " and money like '%"+workOrder.getMoney()+"%'"; } if(!isEmpty(workOrder.getContent())){ sql += " and content like '%"+workOrder.getContent()+"%'"; } sql += " ORDER BY ID DESC "; Pager<WorkOrder> pagers = workOrderService.findBySqlRerturnEntity(sql); model.addAttribute("pagers", pagers); //存储查询条件 model.addAttribute("obj", workOrder); return "workOrder/shfindBySql2"; } /** * wprfindBySql * 外派人员 */ @RequestMapping(value = "/wprfindBySql") public String wprfindBySql(WorkOrder workOrder, Model model, HttpServletRequest request, HttpServletResponse response) { //分页查询 Object attribute = request.getSession().getAttribute("userId"); if (attribute == null){ return "redirect:/login/login.action"; } Integer userId = Integer.valueOf(attribute.toString()); String sql = "SE