哈工大CERP系统.zip

package com.huiton.cerp.sam; /** * Title: SCG2200 程序定义 * Description: 程序定义，包括增加，修改，删除 * Copyright: Copyright Reserved By BRITC * Company: BRITC * @author 张爱军 * @version 1.0 */ import com.huiton.cerp.pub.util.*; import com.huiton.cerp.pub.util.functions.*; import com.huiton.mainframe.control.event.CERPEvent; import com.huiton.mainframe.control.exceptions.DuplicateRecordException; import com.huiton.mainframe.control.web.CustomerWebImpl; import com.huiton.mainframe.control.web.ModelManager; import com.huiton.mainframe.control.web.handlers.RequestHandlerSupport; import com.huiton.mainframe.util.tracer.Debug; import com.huiton.pub.dbx.*; import java.sql.*; import java.util.*; import javax.servlet.*; import javax.servlet.http.*; public class SAM0120Handler extends RequestHandlerSupport { public SAM0120Handler() { } public CERPEvent processRequest(HttpServletRequest request) throws Exception, DuplicateRecordException, SQLException { Debug.println("----SAM0120Handler: processRequest()"); HttpSession session = request.getSession(); ModelManager mm = (ModelManager)session.getAttribute("mm"); CustomerWebImpl customer = mm.getCustomerWebImpl(); String companyCode = customer.getCompanyCode(); String sessionCode = customer.getSessionCode(); String userUniqueNo = customer.getUserUniqueNo(); String lang = customer.getLanguage(); String opFlag = null; //operation flag String outFlag = "1"; // outcome flag, 1 means succeeds Vector vct = null; //保存记录 Vector sysVct = null ; String sql = null; int currentPage = 1; //当前页 int pageCount = 1; //总页数 int pageSize = 16; ResultSet rs = null; String strFields = null; String strTables = null; String strConditions = null; opFlag = request.getParameter("opFlag"); opFlag = (opFlag==null ? "" : opFlag.trim()); //进入时不查询 //opFlag = (opFlag.length()<1 ? "query" : opFlag); // get currentPage and pageCount String m_currentPage = request.getParameter("currentPage"); m_currentPage = (m_currentPage==null ? "1" : m_currentPage.trim()); currentPage = Integer.parseInt(m_currentPage); currentPage = (currentPage < 1 ? 1 : currentPage); m_currentPage = request.getParameter("pageCount"); m_currentPage = (m_currentPage==null ? "1" : m_currentPage.trim()); pageCount = Integer.parseInt(m_currentPage); pageCount = (pageCount < 1 ? 1 : pageCount); //查询条件 String condition = ""; // set query Condition to nothing String queryType = request.getParameter("queryType");//查询方式 queryType = (queryType==null ? "" : queryType.trim()); String queryValue = request.getParameter("queryValue");//查询值 queryValue = (queryValue==null ? "" : queryValue.trim()); String querySysCode = request.getParameter("querySysCode");//子系统代码 querySysCode = (querySysCode==null ? "" : querySysCode.trim()); //查询条件的处理 if (querySysCode.length()>0) { condition = "sys_code='" + querySysCode + "'"; } else { condition = "1=1"; } if (queryValue.length()>0 && queryType.length()>0) { if (queryType.equals("progCode")) { condition += " and prog_code like '%" + queryValue + "%'" ; } else if (queryType.equals("progNameCn")) { condition += " and prog_name_cn like '%" + queryValue + "%'" ; } else if (queryType.equals("progNameEn")) { condition += " and prog_name_en like '%" + queryValue + "%'" ; } else if (queryType.equals("checkRight")) { condition += " and check_right='" + queryValue + "'" ; } else if (queryType.equals("mendFlag")) { condition += " and mend_flag='" + queryValue + "'" ; } else if (queryType.equals("progLevel")) { if (queryValue.indexOf("=")>-1 || queryValue.indexOf(">")>-1 || queryValue.indexOf("<")>-1) { condition += " and prog_level" + queryValue ; }else { condition += " and prog_level=" + queryValue ; } } else if (queryType.equals("progValue")) { condition += " and prog_value like '%" + queryValue + "%'"; } else if (queryType.equals("nodeFlag")) { condition += " and node_flag='" + queryValue + "'"; } else if (queryType.equals("progCodeFather")) { condition += " and prog_code_father like '%" + queryValue + "%'"; } else { //do nothing } } if (condition.length()>0) { strConditions = "(" + condition + ") and company_code='" + companyCode + "' order by sys_code,prog_code_father,prog_code"; } else { strConditions = "company_code='" + companyCode + "' order by sys_code,prog_code_father,prog_code"; } strTables = "scg_program" ; strFields = "sys_code,prog_code,prog_name_cn,prog_name_en,prog_value," + "prog_params,prog_code_father,prog_level,check_right,rst_url," + "mend_flag,oper_flag,node_flag,table_name"; Debug.println("----opFlag=" + opFlag); try { PageQuery pageQuery = DBOperators.getPageQuery(request, sessionCode, SubsystemKeys.SAM, "SAM0120Handler"); if (opFlag.equals("addNew")) //新增 { } else if (opFlag.equals("insert") || opFlag.equals("insMore")) //插入 { String sys_code= request.getParameter("sys_code"); String prog_code = request.getParameter("prog_code"); String prog_name_cn = request.getParameter("prog_name_cn"); String prog_name_en = request.getParameter("prog_name_en"); String prog_value = request.getParameter("prog_value"); String prog_level = request.getParameter("prog_level"); String check_right = request.getParameter("check_right"); String oper_flag = request.getParameter("oper_flag"); String rst_url = request.getParameter("rst_url"); String node_flag = request.getParameter("node_flag"); String prog_params = request.getParameter("prog_params"); String table_name = request.getParameter("table_name"); String prog_code_father = request.getParameter("prog_code_father"); String mend_flag = "Y" ; //用户增加的程序默认可维护 sys_code = (sys_code==null ? "" : sys_code.trim()); prog_code = (prog_code==null ? "" : prog_code.trim()); prog_name_cn = (prog_name_cn==null ? "" : prog_name_cn.trim()); prog_name_en = (prog_name_en==null ? "" : prog_name_en.trim()); prog_value = (prog_value==null ? "" : prog_value.trim()); prog_level = (prog_level==null ? "" : prog_level.trim()); check_right = (check_right==null ? "" : check_right.trim()); oper_flag = (oper_flag==null ? "" : oper_flag.trim()); rst_url = (rst_url==null ? "" : rst_url.trim()); node_flag = (node_flag==null ? "" : node_flag.trim()); pro