/** * (non-Javadoc) * * @see org.apache.struts.action.Action#execute(org.apache.struts.action.ActionMapping, * org.apache.struts.action.ActionForm, javax.servlet.http.HttpServletRequest, * javax.servlet.http.HttpServletResponse) */ public ActionForward executeme( ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { errors.clear(); errors.add("header", new ActionError("errors.header")); errors.add("footer", new ActionError("errors.footer")); HttpSession hs = request.getSession(); String uname = (String) hs.getAttribute("userid"); // TODO 临时用来监测用 long l_begin, l_end; l_begin = System.currentTimeMillis(); commsearch.util.CommDate cdtemp = new commsearch.util.CommDate(); commsearch.util.CommActionLog.setTempLog( Long.parseLong(cdtemp.getNow(cdtemp.FORMAT_ALL_NOSIGN)), uname, hs.getId(), "PrintEipdtl", "B", "LYC0000000", 0); if (uname == null) { errors.add("errormessage", new ActionError("NoName")); saveErrors(request, errors); // TODO 临时用来监测用 l_end = System.currentTimeMillis(); commsearch.util.CommActionLog.setTempLog( Long.parseLong(cdtemp.getNow(cdtemp.FORMAT_ALL_NOSIGN)), uname, hs.getId(), "PrintEipdtl", "E", "LYC5555555", l_end - l_begin); return (mapping.findForward("success")); } if (uname.trim().equals("")) { errors.add("errormessage", new ActionError("NoName")); saveErrors(request, errors); // TODO 临时用来监测用 l_end = System.currentTimeMillis(); commsearch.util.CommActionLog.setTempLog( Long.parseLong(cdtemp.getNow(cdtemp.FORMAT_ALL_NOSIGN)), uname, hs.getId(), "PrintEipdtl", "E", "LYC6666666", l_end - l_begin); return (mapping.findForward("success")); } try { PropertyUtils.setSimpleProperty(form, "pagerow", "32"); String temp = (String) request.getParameter("selectwhere"); String stemp = temp; if (stemp == null) stemp = ""; if (stemp.equals("")) { // TODO 临时用来监测用 l_end = System.currentTimeMillis(); commsearch.util.CommActionLog.setTempLog( Long.parseLong(cdtemp.getNow(cdtemp.FORMAT_ALL_NOSIGN)), uname, hs.getId(), "PrintEipdtl", "E", "LYC3333333", l_end - l_begin); return (mapping.findForward("err")); } // temp=CommonTools.stringReplace(temp,"'","'"); DataBean dbBean = new DataBean(); String ss = ""; if (temp.indexOf("EIVIVN") != -1) { try { dbBean.executeSelect("select eivstr,eivnum,eivtyp from eivdtl where " + temp); } catch (Exception e) { errors.add("errormessage", new ActionError("Datebase.readdb")); saveErrors(request, errors); // TODO 临时用来监测用 l_end = System.currentTimeMillis(); commsearch.util.CommActionLog.setTempLog( Long.parseLong(cdtemp.getNow(cdtemp.FORMAT_ALL_NOSIGN)), uname, hs.getId(), "PrintEipdtl", "C", "LYC9999991", l_end - l_begin); return (mapping.findForward("success")); } for (int i = 0; i < dbBean.getRowCount(); i++) { ss = ss + "OR (EIPSTR='" + dbBean.getElementValue(i, "eivstr").trim() + "' AND "; ss = ss + " EIPNUM='" + dbBean.getElementValue(i, "eivnum").trim() + "' AND "; ss = ss + " EIPTYP='" + dbBean.getElementValue(i, "eivtyp").trim() + "')"; } ss = ss.substring(2); temp = ss; } PropertyUtils.setSimpleProperty(form, "selectwhere", temp); if (setFormbeen(form, request, temp, uname).equals("0")) { saveErrors(request, errors); // TODO 临时用来监测用 l_end = System.currentTimeMillis(); commsearch.util.CommActionLog.setTempLog( Long.parseLong(cdtemp.getNow(cdtemp.FORMAT_ALL_NOSIGN)), uname, hs.getId(), "PrintEipdtl", "E", "LYC8888881", l_end - l_begin); return (mapping.findForward("success")); } log.debug("成功刷新页面"); // TODO 临时用来监测用 l_end = System.currentTimeMillis(); commsearch.util.CommActionLog.setTempLog( Long.parseLong(cdtemp.getNow(cdtemp.FORMAT_ALL_NOSIGN)), uname, hs.getId(), "PrintEipdtl", "E", "LYC8888882", l_end - l_begin); return (mapping.findForward("success")); } catch (Exception e) { e.printStackTrace(); // TODO 临时用来监测用 l_end = System.currentTimeMillis(); commsearch.util.CommActionLog.setTempLog( Long.parseLong(cdtemp.getNow(cdtemp.FORMAT_ALL_NOSIGN)), uname, hs.getId(), "PrintEipdtl", "C", "LYC9999999", l_end - l_begin); errors.add("errormessage", new ActionError("OrderIn.formbean")); saveErrors(request, errors); return (mapping.findForward("success")); } }
/** * (non-Javadoc) * * @see org.apache.struts.action.Action#execute(org.apache.struts.action.ActionMapping, * org.apache.struts.action.ActionForm, javax.servlet.http.HttpServletRequest, * javax.servlet.http.HttpServletResponse) */ public ActionForward executeme( ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws IOException, ServletException { errors.clear(); errors.add("header", new ActionError("errors.header")); errors.add("footer", new ActionError("errors.footer")); HttpSession hs = request.getSession(); String uname = (String) hs.getAttribute("userid"); // TODO 临时用来监测用 long l_begin, l_end; l_begin = System.currentTimeMillis(); commsearch.util.CommDate cdtemp = new commsearch.util.CommDate(); commsearch.util.CommActionLog.setTempLog( Long.parseLong(cdtemp.getNow(cdtemp.FORMAT_ALL_NOSIGN)), uname, hs.getId(), "ReturnOrder", "B", "LYC0000000", 0); if (uname == null) { errors.add("errormessage", new ActionError("NoName")); saveErrors(request, errors); // TODO 临时用来监测用 l_end = System.currentTimeMillis(); commsearch.util.CommActionLog.setTempLog( Long.parseLong(cdtemp.getNow(cdtemp.FORMAT_ALL_NOSIGN)), uname, hs.getId(), "ReturnOrder", "E", "LYC5555555", l_end - l_begin); return (mapping.findForward("success")); } if (uname.trim().equals("")) { errors.add("errormessage", new ActionError("NoName")); saveErrors(request, errors); // TODO 临时用来监测用 l_end = System.currentTimeMillis(); commsearch.util.CommActionLog.setTempLog( Long.parseLong(cdtemp.getNow(cdtemp.FORMAT_ALL_NOSIGN)), uname, hs.getId(), "ReturnOrder", "E", "LYC6666666", l_end - l_begin); return (mapping.findForward("success")); } try { PropertyUtils.setSimpleProperty(form, "message", "0"); Date now = new Date(); PropertyUtils.setSimpleProperty( form, "nowdate", com.idn.util.FormatDate.format(now, "yyyy-MM-dd")); String temp = request.getParameter("eponum"); String queryid = request.getParameter("queryid"); String selectwhere = request.getParameter("selectwhere"); if (selectwhere == null) { queryid = (String) PropertyUtils.getSimpleProperty(form, "queryid"); selectwhere = (String) PropertyUtils.getSimpleProperty(form, "selectwhere"); } String stemp = selectwhere; if (stemp == null) stemp = ""; if (stemp.equals("")) { // TODO 临时用来监测用 l_end = System.currentTimeMillis(); commsearch.util.CommActionLog.setTempLog( Long.parseLong(cdtemp.getNow(cdtemp.FORMAT_ALL_NOSIGN)), uname, hs.getId(), "ReturnOrder", "E", "LYC3333333", l_end - l_begin); return (mapping.findForward("err")); } PropertyUtils.setSimpleProperty(form, "queryid", queryid); PropertyUtils.setSimpleProperty(form, "selectwhere", selectwhere); String flag = ((String) PropertyUtils.getSimpleProperty(form, "flag")).trim(); if (flag.equals("")) { setFormbeen(form, request, selectwhere, uname); // TODO 临时用来监测用 l_end = System.currentTimeMillis(); commsearch.util.CommActionLog.setTempLog( Long.parseLong(cdtemp.getNow(cdtemp.FORMAT_ALL_NOSIGN)), uname, hs.getId(), "ReturnOrder", "E", "LYC8888881", l_end - l_begin); return (mapping.findForward("success")); } String epoflg = (String) PropertyUtils.getSimpleProperty(form, "epoflg"); String freeformstate = (String) PropertyUtils.getSimpleProperty(form, "freeformstate"); String eponum = (String) PropertyUtils.getSimpleProperty(form, "eponum"); String epostr = (String) PropertyUtils.getSimpleProperty(form, "epostr"); String epostn = (String) PropertyUtils.getSimpleProperty(form, "epostn"); String eposdt = (String) PropertyUtils.getSimpleProperty(form, "eposdt"); String epordt = (String) PropertyUtils.getSimpleProperty(form, "epordt"); eposdt = CommonTools.stringReplace(eposdt, "-", "").trim(); eposdt = eposdt.substring(2); epordt = CommonTools.stringReplace(epordt, "-", "").trim(); epordt = epordt.substring(2); String epordtm = (String) PropertyUtils.getSimpleProperty(form, "epordtmshow"); String epordtm2 = (String) PropertyUtils.getSimpleProperty(form, "epordtm2show"); String operator = (String) PropertyUtils.getSimpleProperty(form, "operatorid"); String operdate = (String) PropertyUtils.getSimpleProperty(form, "operdate"); String opertime = (String) PropertyUtils.getSimpleProperty(form, "opertime"); // SQLBean sis=new SQLBean(); DataBean dbBean = new DataBean(); String strsql1 = "select * from ORDERR where " + selectwhere + ""; try { dbBean.executeSelect(strsql1); } catch (Exception e) { e.printStackTrace(); errors.add("errormessage", new ActionError("Datebase.readdb")); // TODO 临时用来监测用 l_end = System.currentTimeMillis(); commsearch.util.CommActionLog.setTempLog( Long.parseLong(cdtemp.getNow(cdtemp.FORMAT_ALL_NOSIGN)), uname, hs.getId(), "ReturnOrder", "E", "LYC8888882", l_end - l_begin); return (mapping.findForward("success")); } String strsql[] = new String[1]; if (dbBean.getRowCount() == 0) { strsql[0] = "insert into ORDERR (eponum,epostr,epostn,eposdt,epordt,epordtm,epoflg,operator,operdate,opertime,epordtm2) values('" + eponum + "' ,'" + epostr + "' ,'" + epostn + "','" + eposdt + "','" + epordt + "','" + epordtm + "','0','" + operator + "','" + operdate + "','" + opertime + "','" + epordtm2 + "')"; // 第一次进入并且orderr中不存在记录 // int retrunint1=sis.executeSQL(strsql); // 写日志(XIAOAI处理) commsearch.util.CommActionLog cal = new commsearch.util.CommActionLog(); cal.setAct_user(uname); cal.setAct_from("homeworldReturnOrder"); cal.setAct_do("INS"); cal.setAct_key(temp); cal.setAct_table("ORDERR"); cal.setAct_ip(request.getRemoteAddr()); cal.setAct_memo("回复插入定单编号为" + temp); cal.setAct_me(""); cal.setActionLog(); } else { operator = uname; operdate = com.idn.util.FormatDate.format(now, "yyMMdd"); opertime = com.idn.util.FormatDate.format(now, "hh:mm:ss"); strsql[0] = "update ORDERR set epotrf='', epordt='" + epordt + "',epordtm='" + epordtm + "',epordtm2='" + epordtm2 + "', operdate='" + operdate + "',opertime='" + opertime + "',operator='" + operator + "' where eponum='" + eponum + "'"; // int returnint=sis.executeSQL(strsql); // 写日志(XIAOAI处理) commsearch.util.CommActionLog cal = new commsearch.util.CommActionLog(); cal.setAct_user(uname); cal.setAct_from("homeworldReturnOrder"); cal.setAct_do("UPD"); cal.setAct_key(temp); cal.setAct_table("ORDERR"); cal.setAct_ip(request.getRemoteAddr()); cal.setAct_memo("回复修改定单编号为" + temp); cal.setAct_me(""); cal.setActionLog(); } DynaSqlBean dybBean = new DynaSqlBean(); dybBean.setSql(strsql); dybBean.executeBatch(); // setFormbeen(form,request,selectwhere,uname); PropertyUtils.setSimpleProperty(form, "freeformstate", "0"); PropertyUtils.setSimpleProperty(form, "message", "1"); // TODO 临时用来监测用 l_end = System.currentTimeMillis(); commsearch.util.CommActionLog.setTempLog( Long.parseLong(cdtemp.getNow(cdtemp.FORMAT_ALL_NOSIGN)), uname, hs.getId(), "ReturnOrder", "E", "LYC8888888", l_end - l_begin); return (mapping.findForward("success")); } catch (Exception e) { e.printStackTrace(); errors.add("errormessage", new ActionError("Database.formbean")); saveErrors(request, errors); // TODO 临时用来监测用 l_end = System.currentTimeMillis(); commsearch.util.CommActionLog.setTempLog( Long.parseLong(cdtemp.getNow(cdtemp.FORMAT_ALL_NOSIGN)), uname, hs.getId(), "ReturnOrder", "C", "LYC9999999", l_end - l_begin); return (mapping.findForward("success")); } }