package com.huiton.cerp.sam;/** * Title:       角色選擇 * Description: * Copyright:    Copyright  Reserved By BRITC * Company: * @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.*;import com.huiton.cerp.sam.*;public class SelectRoleHandler extends RequestHandlerSupport{    public SelectRoleHandler()    {    }    public CERPEvent processRequest(HttpServletRequest request)        throws Exception, DuplicateRecordException, SQLException    {        Debug.println("----SelectRoleHandler: 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 opFlag = null; //operation flag        String outFlag = "1"; // outcome flag, 1 means succeeds        Vector vct = 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 = "1=1";  // set query Condition to nothing        String querySql = request.getParameter("querySql");        querySql = (querySql==null ? "" : querySql.trim());        String param = request.getParameter("param");//傳入參數，由傳入者處理        param = (param==null ? "" : param.trim());        String querySql_bak = querySql;        strConditions = "(" + condition + ") "          + " and company_code='" + companyCode          + "' order by role_code";        strFields = "role_code,role_name" ;        strTables = "sam_role";        Debug.println("----opFlag=" + opFlag);        try        {            PageQuery pageQuery = DBOperators.getPageQuery(request,                sessionCode,SubsystemKeys.SAM, "SelectRoleHandler");            //查詢            pageQuery.getData(strFields,strTables,strConditions,pageSize);            pageCount = pageQuery.pageCount ;            currentPage = (currentPage>pageCount ? pageCount : currentPage);            vct = pageQuery.dividePage(currentPage,pageSize);        }        catch (Exception e)        {          e.printStackTrace();          outFlag = "0" ;        }        vct = (vct==null ? new Vector() : vct);        request.setAttribute("vct",vct);        request.setAttribute("opFlag",opFlag);        request.setAttribute("param",param);        request.setAttribute("querySql",querySql_bak);        request.setAttribute("currentPage",currentPage+"");        request.setAttribute("pageCount",pageCount+"");        Debug.println("process handler over,outFlag="+outFlag);        return null;    }}