@RequestMapping(value = "/AjaxQuery_detail.html") public String AjaxQueryDetail(HttpServletRequest request, HttpServletResponse response) { foreigner foreign = null; String id = Untils.NotNull(request.getParameter("foreign_id")) ? request.getParameter("foreign_id") : ""; foreignServices = (ForeignServices) springContextUtil.getBean("ForeignServices"); if (Untils.NotNull(id)) { foreign = foreignServices.QueryByid(id); } List list = new ArrayList(); if (foreign != null) { JSONObject object = new JSONObject(); object.put("id", foreign.getId()); object.put("name", foreign.getName()); object.put("sex", foreign.getSex()); object.put("birthday", foreign.getBirthday()); object.put("country", foreign.getCountry()); object.put("company_department", foreign.getCompany_department()); object.put("passport_id", foreign.getPassport_id()); object.put("passport_exp_date", foreign.getPassport_exp_date()); object.put("post", foreign.getPost()); object.put("role", foreign.getRole()); object.put("fk_pp", foreign.getFk_pp_attachment_id()); object.put("expert_evidence", foreign.getExpert_evidence()); object.put("fk_ee", foreign.getFk_ee_attachment_id()); object.put("fk_invitation", foreign.getFk_invitation_id()); object.put("fk_permit", foreign.getFk_rp_permit_id()); object.put("is_here", foreign.getIs_here()); object.put("status", foreign.getStatus()); object.put("rp_id", foreign.getResidence_permit_id()); object.put("rp_kind", foreign.getResidence_permit_kind()); object.put("rp_exp_enddate", foreign.getRp_exp_endDate()); object.put("rp_address", foreign.getRp_Address()); list.add(object); } response.setContentType("text/Xml;charset=utf-8"); response.setHeader("Cache-Control", "no-cache"); response.setHeader("pragma", "no-cache"); response.setDateHeader("expires", 0); PrintWriter out = null; try { out = response.getWriter(); out.println(list); } catch (IOException ex1) { ex1.printStackTrace(); } finally { out.close(); } return null; }
@RequestMapping(value = "/foreign_hereis.html") public String Edit_hereis(HttpServletRequest request, HttpServletResponse response) { String id = Untils.NotNull(request.getParameter("inhere_id_list")) ? request.getParameter("inhere_id_list") : ""; String status = Untils.NotNull(request.getParameter("is_here_status")) ? request.getParameter("is_here_status") : ""; foreignServices = (ForeignServices) springContextUtil.getBean("ForeignServices"); String s = ""; JSONObject object = new JSONObject(); String message = ""; try { if (Untils.NotNull(id)) { if (Untils.NotNull(status)) { String[] array = id.split(","); for (int i = 0; i < array.length; i++) { if (Untils.NotNull(array[i])) { FiForeigner foreign_ = foreignServices.QueryByid_fi(array[i]); foreign_.setIsHere(Integer.parseInt(status)); foreignServices.UpdataObject(foreign_); } } } } message = "是否再连信息保存成功!"; } catch (Exception e) { message = "是否再连信息保存失败!"; } finally { response.setContentType("text/Xml;charset=utf-8"); response.setHeader("Cache-Control", "no-cache"); response.setHeader("pragma", "no-cache"); response.setDateHeader("expires", 0); PrintWriter out = null; try { out = response.getWriter(); JSONObject object1 = new JSONObject(); object1.put("message", message); out.println(object1); } catch (IOException ex1) { ex1.printStackTrace(); } finally { out.close(); } // return new String(message.getBytes("utf-8"),"ISO-8859-1"); return null; } }
@RequestMapping(value = "/AjaxQuery.html") public String AjaxQuery( @RequestParam(value = "entryValue") String entryValue, HttpServletRequest request, HttpServletResponse response) { List<FiForeigner> foreignlist = null; String value = Untils.NotNull(entryValue) ? entryValue : ""; if (Untils.NotNull(value)) { foreignServices = (ForeignServices) springContextUtil.getBean("ForeignServices"); foreignlist = foreignServices.QueryByName("%" + value + "%"); } List list = new ArrayList(); if (foreignlist != null && foreignlist.size() > 0) { for (FiForeigner forei : foreignlist) { JSONObject object = new JSONObject(); // System.out.println(forei.getName()+" , "+forei.getPassportId()); if (Untils.NotNull(value)) { object.put("name", forei.getName()); object.put("pp_id", forei.getPassportId()); object.put("id", forei.getId()); } list.add(object); } } response.setContentType("text/Xml;charset=utf-8"); response.setHeader("Cache-Control", "no-cache"); response.setHeader("pragma", "no-cache"); response.setDateHeader("expires", 0); PrintWriter out = null; try { out = response.getWriter(); out.println(list); } catch (IOException ex1) { ex1.printStackTrace(); } finally { out.close(); } return null; }
@RequestMapping(value = "/AjaxQuery_inout.html") public String AjaxQueryInOut(HttpServletRequest request, HttpServletResponse response) { foreigner foreign = null; String id = Untils.NotNull(request.getParameter("foreign_id")) ? request.getParameter("foreign_id") : ""; foreignServices = (ForeignServices) springContextUtil.getBean("ForeignServices"); List<FiInout> inout = null; if (Untils.NotNull(id)) { foreign = foreignServices.QueryByid(id); inout = foreignServices.QueryByInOut(id); } List<JSONObject> list = new ArrayList(); // List list=new ArrayList(); if (foreign != null) { // Map object = new HashMap(); JSONObject object = new JSONObject(); object.put("foreign", foreign); object.put("inout_list", inout); list.add(object); } response.setContentType("text/Xml;charset=utf-8"); response.setHeader("Cache-Control", "no-cache"); response.setHeader("pragma", "no-cache"); response.setDateHeader("expires", 0); PrintWriter out = null; try { out = response.getWriter(); out.println(list); } catch (IOException ex1) { ex1.printStackTrace(); } finally { out.close(); } return null; }
@RequestMapping(value = "/search_list.html") public String QueryList( @RequestParam("kind") String kind, HttpServletRequest request, HttpServletResponse response, Model model) { // @RequestMapping(value = "/AjaxQuery_list.html") // public String AjaxQueryList(HttpServletRequest request, // HttpServletResponse response) { List<FiForeigner> foreignlist = null; // var // url="name:"+name+" id:"+id+" contry:"+contry+" numb:"+numb+" post:"+post; String foreignname = Untils.NotNull(request.getParameter("foreign_name")) ? request.getParameter("foreign_name") : ""; String passport_id = Untils.NotNull(request.getParameter("passport_id_q")) ? request.getParameter("passport_id_q") : ""; String contry_from = Untils.NotNull(request.getParameter("contry_q")) ? request.getParameter("contry_q") : ""; String numb_invitation = Untils.NotNull(request.getParameter("invitation_numb")) ? request.getParameter("invitation_numb") : ""; String post = Untils.NotNull(request.getParameter("post_q")) ? request.getParameter("post_q") : ""; String is_here_ = Untils.NotNull(request.getParameter("is_here_")) ? request.getParameter("is_here_") : ""; String now_page = Untils.NotNull(request.getParameter("nowpage")) ? request.getParameter("nowpage") : ""; String page_size = Untils.NotNull(request.getParameter("pagesize")) ? request.getParameter("pagesize") : ""; String kinds = Untils.NotNull(kind) ? kind : ""; foreignServices = (ForeignServices) springContextUtil.getBean("ForeignServices"); String query_sql = foreignServices.getsql( foreignname, passport_id, contry_from, numb_invitation, post, is_here_); PageMybatis page = foreignServices.QueryCount(query_sql); if (Untils.NotNull(now_page) && now_page != "1") { page.setNowpage(Long.parseLong(now_page)); } else { page.setNowpage(Long.parseLong("1")); } if (Untils.NotNull(page_size) && now_page != "1") { page.setPagesize(Long.parseLong(page_size)); } if (Untils.NotNull(query_sql)) { page.setQuerysql(query_sql); } foreignlist = foreignServices.QueryList(page); model.addAttribute("foreign_list", foreignlist); page.setPageurl(Untils.requestPath(request)); model.addAttribute("page", page); if (kinds.equals("edit")) { return "/foreign/foreign_edit"; } else if (kinds.equals("inout")) { return "/foreign/foreign_inout"; } else if (kinds.equals("ishere")) { return "/foreign/foreign_ishere"; } else if (kinds.equals("extension")) { return "/foreign/foreign_extension"; } else if (kinds.equals("query")) { return "/query/queryforeign"; } else if (kinds.equals("foreigninoutquery")) { return "/query/queryforeigninout"; } else { return ""; } // List list = new ArrayList(); // if (foreignlist != null && foreignlist.size() > 0) { // for (FiForeigner forei : foreignlist) { // JSONObject object = new JSONObject(); // object.put("id", forei.getId()); // object.put("name", forei.getName()); // object.put("sex", forei.getSex()); // object.put("country", forei.getCountry()); // object.put("companydepartment", forei.getCompanyDepartment()); // object.put("passportid", forei.getPassportId()); // object.put("role", forei.getRole()); // object.put("isHere", forei.getIsHere()); // list.add(object); // } // } // response.setContentType("text/Xml;charset=utf-8"); // response.setHeader("Cache-Control", "no-cache"); // response.setHeader("pragma", "no-cache"); // response.setDateHeader("expires", 0); // PrintWriter out = null; // try { // out = response.getWriter(); // out.println(list); // // } catch (IOException ex1) { // ex1.printStackTrace(); // } finally { // out.close(); // } // return null; }