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());                prog_params = (prog_params==null ? "" : prog_params.trim());                table_name = (table_name==null ? "" : table_name.trim());                prog_code_father =                    (prog_code_father==null ? "" : prog_code_father.trim());                //程序級別                prog_level = (prog_level.length()<1 ? "0" : prog_level);                //檢查權限                check_right = (check_right.length()<1 ? "N" : check_right);                //非操作程序                oper_flag = (oper_flag.length()<1 ? "N" : oper_flag);                //菜單結點                node_flag = (node_flag.length()<1 ? "N" : node_flag);                if (sys_code.length()<1 || prog_code.length()<1 )                {                    outFlag = "0" ;                }else                {                    boolean bFlag = false ; //SQL執行結果標記                    if (node_flag.equals("N")) //可執行的程序                    {                        if (prog_value.length()<1)                        {                            outFlag = "0" ;                        }                        else                        {                            sql = "insert into scg_program(company_code,sys_code,"                                + "prog_code,prog_name_cn,prog_name_en,node_flag,"                                + "prog_value,check_right,oper_flag,rst_url,"                                + "mend_flag,prog_level,prog_code_father,"                                + "prog_params,table_name) " + " values('"                                + companyCode + "','" + sys_code                                + "','" + prog_code + "','" + prog_name_cn                                + "','" + prog_name_en + "','" + node_flag                                + "','" + prog_value + "','" + check_right                                + "','" + oper_flag + "','" + rst_url                                + "','" + mend_flag + "'," + prog_level                                + ",'" + prog_code_father + "','"                                + prog_params + "','" + table_name + "')" ;                            Debug.println("sql="+sql);                            bFlag = pageQuery.simpleUpdate(sql);                            outFlag = (bFlag ? "1" : "0") ;                        }