public int buttonEvent( SessionContext ctx, DatabaseConnection conn, FormInstance instance, String button, ErrorMessages msgs, EventManager manager) { /* ctx.setAttribute("SUPERFORMID", instance.getFormid()); ctx.setAttribute("BUTTONNAME", button); if (button != null && button.equals(SessionAttributes.REQUEST_EDIT_BUTTON_VALUE)) { ctx.setAttribute("BUTTONNAME", ctx.getParameter(SessionAttributes.CLICK_COLUMN_NAME)); trigger(manager, "FDCUTPAYDETLPAGE", null); } */ // check if (button != null && (button.equals("CHECKBUTTON"))) { try { String sql = "select gthtb_htbh,gthtb_dwbh,xdkhzd_khmc,gthtb_qsrq,gthtb_dqrq,gthtb_htje,gthtb_tyckzh,gthtb_htnm " + "from gthtb@haier_shengchan a,xdkhzd@haier_shengchan b " + " where a.gthtb_dwbh=b.xdkhzd_khbh " + " and (a.gthtb_htbh like 'GC%' or a.gthtb_htbh like 'GQ%' or a.gthtb_htbh like 'GSQ%' or a.gthtb_htbh like 'GT%' ) " + " and (a.gthtb_htbh != 'GQ20090405' and a.gthtb_htbh != 'GQ20090728') " + " and a.gthtb_tyckzh='801000026101041001' "; logger.info("SQL=" + sql); RecordSet rs = conn.executeQuery(sql); int count = 0; msgs.add("<br>帐号检查结果如下:"); while (rs.next()) { String dwbh = rs.getString("gthtb_dwbh"); String actno = rs.getString("gthtb_tyckzh"); String htbh = rs.getString("gthtb_htbh"); String khmc = rs.getString("xdkhzd_khmc"); String promptStr = dwbh + " " + khmc + " " + htbh + " " + actno; count++; msgs.add("<br>" + count + ":" + promptStr); /* if (dwbh.startsWith("GC")) { if (!"801000026701041001".equals(actno)) { count++; msgs.add("<br>" + count + ":" + promptStr); } } else if (dwbh.startsWith("GQ")) { if (!"801000026701041001".equals(actno)) { count++; msgs.add("<br>" + count + ":" + promptStr); } } else if (dwbh.startsWith("GSQ")) { if (!"801000026701041001".equals(actno)) { count++; msgs.add("<br>" + count + ":" + promptStr); } } else if (dwbh.startsWith("GT")) { if ("GT001".equals(dwbh)) { if (!"801000026701041001".equals(actno)) { count++; msgs.add("<br>" + count + ":" + promptStr); } } else { if (!"801000026101041001".equals(actno)) { count++; msgs.add("<br>" + count + ":" + promptStr); } } } */ } if (count == 0) { msgs.add("<br>未发现帐号错误!"); } msgs.add("<br>检查完成。"); } catch (Exception e) { Debug.debug(e); msgs.add("帐号检查时出现问题,请通知系统管理人员!"); return 0; } finally { ctx.setRequestAtrribute("msg", msgs.getAllMessages()); ctx.setRequestAtrribute("flag", "1"); ctx.setRequestAtrribute("isback", "0"); ctx.setTarget("/showinfo.jsp"); instance.setReadonly(true); } } // 设定帐号 if (button != null && (button.equals("PROCESSBUTTON"))) { // rigger(manager, "FDSYSWHLIST", null); try { String sql = "update gthtb@haier_shengchan a " + " set a.gthtb_tyckzh = '801000026701041001' " + " where (a.gthtb_dwbh like 'GC%' or a.gthtb_dwbh like 'GQ%' or a.gthtb_dwbh like 'GSQ%' or a.gthtb_dwbh like 'GT%' ) " + " and (a.gthtb_htbh != 'GQ20090405' and a.gthtb_htbh != 'GQ20090728') " + " and a.gthtb_tyckzh='801000026101041001' "; conn.setAuto(false); conn.begin(); int rtn = conn.executeUpdate(sql); msgs.add("已成功更新 " + rtn + " 笔同业存款帐号。"); conn.commit(); } catch (Exception e) { conn.rollback(); logger.error(e); msgs.add("同业帐号更新时出现问题,请通知系统管理人员!"); return 0; } finally { ctx.setRequestAtrribute("msg", msgs.getAllMessages()); ctx.setRequestAtrribute("flag", "1"); ctx.setRequestAtrribute("isback", "0"); ctx.setTarget("/showinfo.jsp"); instance.setReadonly(true); } } return 0; }