public String querylist() throws Exception {
Gzdx setGzdx = new Gzdx();
gzdx = (Gzdx) this.setClass(setGzdx, null);
Map map = new HashMap();
map.put("xm", gzdx.getXm());
map.put("xb", gzdx.getXb());
map.put("zjhm", gzdx.getZjhm());
map.put("csrq", gzdx.getCsrq());
map.put("csrq2", gzdx.getCsrq2());
map.put("mzdm", gzdx.getMzdm());
map.put("hjdxzqhdm", gzdx.getHjdxzqhdm());
map.put("hylbdm", gzdx.getHylbdm());
User user = (User) this.getRequest().getSession().getAttribute(Constants.userKey);
if (user != null) {
String dqdwbm = user.getDepartment().getDepartcode();
int level = user.getDepartment().getDepartlevel().intValue();
if (level >= 3) map.put("tbdabm", StringUtil.trimEven0(dqdwbm) + "%");
map.put("dqdwbm", dqdwbm);
}
// 如果查询菜单是注销管理，则应该要加一个默认条件为未注销
if ("cancel".equals(gzdx.getFlag())) {
map.put("zxbz", "0");
}
// 如果选择了姓名拼音的同音查询，则需要得到姓名的拼音
if ("1".equals(gzdx.getTyCheck())) {
map.put("xmpy", PinYinUtil.getHanyuPingYin(gzdx.getXm()));
map.put("xm", "");
}
Page page = gzdxService.getListForPage(map, pagesize, pagerow, sort, dir);
totalpage = page.getTotalPages();
totalrows = page.getTotalRows();
lGzdx = page.getData();
setTabledata(lGzdx);
this.result = "success";
return "success";
}
public String queryForExport() {
ActionContext ctx = ActionContext.getContext();
HttpServletRequest request = (HttpServletRequest) ctx.get(ServletActionContext.HTTP_REQUEST);
HttpSession session = request.getSession();
session.removeAttribute("gzdxExportResult");
// User user= (User)session.getAttribute(Constants.userKey);
Globalpar glo = this.getCacheGlobalpar("exportmaxrows");
String maxRows = glo.getGlobalparvalue();
try {
Gzdx setGzdx = new Gzdx();
gzdx = (Gzdx) this.setClass(setGzdx, null);
Map map = new HashMap();
// map.put("xm", gzdx.getXm());
// map.put("xb", gzdx.getXb());
// map.put("zjhm", gzdx.getZjhm());
// map.put("csrq", gzdx.getCsrq());
// map.put("csrq2", gzdx.getCsrq2());
// map.put("mzdm", gzdx.getMzdm());
// map.put("hjdxzqhdm", gzdx.getHjdxzqhdm());
// //如果选择了姓名拼音的同音查询，则需要得到姓名的拼音
// if("1".equals(gzdx.getTyCheck())){
// map.put("xmpy", PinYinUtil.getHanyuPingYin(gzdx.getXm()));
// map.put("xm", "");
// }
map.put("xm", gzdx.getXm());
map.put("xb", gzdx.getXb());
map.put("zjhm", gzdx.getZjhm());
map.put("csrq", gzdx.getCsrq());
map.put("csrq2", gzdx.getCsrq2());
map.put("mzdm", gzdx.getMzdm());
map.put("hjdxzqhdm", gzdx.getHjdxzqhdm());
map.put("hylbdm", gzdx.getHylbdm());
User user = (User) this.getRequest().getSession().getAttribute(Constants.userKey);
if (user != null) {
String dqdwbm = user.getDepartment().getDepartcode();
int level = user.getDepartment().getDepartlevel().intValue();
if (level >= 3) map.put("tbdabm", StringUtil.trimEven0(dqdwbm) + "%");
map.put("dqdwbm", dqdwbm);
}
// 如果查询菜单是注销管理，则应该要加一个默认条件为未注销
if ("cancel".equals(gzdx.getFlag())) {
map.put("zxbz", "0");
}
// 如果选择了姓名拼音的同音查询，则需要得到姓名的拼音
if ("1".equals(gzdx.getTyCheck())) {
map.put("xmpy", PinYinUtil.getHanyuPingYin(gzdx.getXm()));
map.put("xm", "");
}
map.put("endRow", maxRows);
// Excel输出
lGzdx = gzdxService.getListExportGzdx(map, sort, dir);
// ///cache 替换
List lPro = new ArrayList();
lPro.add("xm");
lPro.add("zjhm");
lPro.add("xb");
lPro.add("csrq");
lPro.add("minzu");
lPro.add("whcd");
lPro.add("hjdxzqh");
lPro.add("hjdxz");
List lcache = new ArrayList();
/*List lcache_mz = this.getDictItemCacheList("minzu", "dm_mz", "0"); //民族替换 "0"为不加列 "1"替换列
lcache.add(lcache_mz);
List lcache_xb = this.getDictItemCacheList("xingbie", "dm_xb", "0"); // 性别 "0"为不加列 "1"替换列
lcache.add(lcache_xb);*/
Gzdx getGzdx = new Gzdx();
lGzdx = this.getResultCache(getGzdx.getClass().getName(), lPro, lGzdx, lcache);
session.setAttribute("gzdxExportResult", lGzdx);
this.result = "success";
} catch (IOException e) {
e.printStackTrace();
this.result = e.getMessage();
} catch (Exception e) {
e.printStackTrace();
this.result = e.getMessage();
}
return "success";
}