addfavorhandler.java

哈工大CERP系统Java源码及开发说明.rar 内容十分详尽

                    m_url = m_url.substring(idxPos); // get substring
                    Debug.println("after trimed m_url="+m_url);

                    int sepPos = m_url.indexOf("::");
                    sepPos = (sepPos<0 ? m_url.length() : sepPos);
                    String progValue = m_url.substring(0,sepPos);
                    String[] value = (new CerpSAM()).getSysAndProgCode(progValue,companyCode);
                    String mm_sys_code = value[0];
                    String mm_prog_code = value[1];

                    // check if it exists already
                    sql = "select 1 from sam_user_favor_v "
                        + " where company_code='" + companyCode
                        + "' and user_unique_no='" + userUniqueNo
                        + "' and sys_code='" + mm_sys_code
                        + "' and prog_code='" + mm_prog_code+ "'";

                    Debug.println(sql);
                    ResultSet rs = pageQuery.getData(sql);
                    if (rs !=null && rs.next())
                    {
                        outFlag = "0";
                    }else
                    {
                        sql = "select " + prog_name
                            + " from scg_program "
                            + " where company_code='" + companyCode
                            + "' and sys_code='" + mm_sys_code
                            + "' and prog_code='" + mm_prog_code + "'" ;

                        Debug.println("mm_sys_code="+mm_sys_code+",mm_prog_code="+mm_prog_code);
                        Debug.println(sql);
                        rs = pageQuery.getData(sql);

                        if (rs != null && rs.next())
                        {
                            String m_favor_name = rs.getString(1);
                            request.setAttribute("m_favor_name",m_favor_name);
                            request.setAttribute("mm_sys_code",mm_sys_code);
                            request.setAttribute("mm_prog_code",mm_prog_code);
                        }else
                        {
                            outFlag = "0";
                        }
                    }
                }
                vct = new Vector();
            }
            else if (opFlag.equalsIgnoreCase("insert"))
            {
                // insert
                String mm_sys_code = request.getParameter("mm_sys_code");
                String mm_prog_code = request.getParameter("mm_prog_code");
                String m_favor_name = request.getParameter("m_favor_name");
                String favor_type = request.getParameter("favor_type");

                Debug.println("mm_sys_code="+mm_sys_code+",mm_prog_code="+mm_prog_code+",m_favor_name="+m_favor_name);

                String favor_index = "0";
                mm_sys_code = (mm_sys_code==null ? "" : mm_sys_code.trim());
                mm_prog_code = (mm_prog_code==null ? "" : mm_prog_code.trim());
                favor_type = (favor_type==null ? "" : favor_type.trim());
                m_favor_name = (m_favor_name==null ? "" : m_favor_name.trim());

                sql = "select 1 from sam_user_favor "
                    + " where company_code='" + companyCode
                    + "' and user_unique_no='" + userUniqueNo
                    + "' and sys_code='" + mm_sys_code
                    + "' and prog_code='" + mm_prog_code + "'";

                Debug.println("sql=" + sql);

                ResultSet rs = pageQuery.getData(sql);
                if (rs != null && rs.next())
                {
                    outFlag = "0";
                }else
                {
                    sql = "insert into sam_user_favor(company_code,user_unique_no,sys_code,prog_code,favor_name_cn,favor_name_en,favor_name_tw,favor_type,favor_index) "
                        + " select '" + companyCode + "','" + userUniqueNo + "','"
                        + mm_sys_code + "','" + mm_prog_code + "',prog_name_cn,prog_name_en,prog_name_tw,'" + favor_type + "'," + favor_index
                        + " from scg_program where company_code='" +companyCode+ "' and sys_code='" + mm_sys_code + "' and prog_code='" + mm_prog_code + "'";

                    Debug.println("sql=" + sql);
                    boolean bFlag = pageQuery.simpleUpdate(sql);

                    if  (bFlag)
                    {
                        sql = "update sam_user_favor set " + favor_name + "='" + m_favor_name
                            + "' where company_code='" + companyCode + "' and user_unique_no='" + userUniqueNo
                            + "' and sys_code='" + mm_sys_code + "' and prog_code='" + mm_prog_code + "'";

                        Debug.println("sql=" + sql);
                        bFlag = pageQuery.simpleUpdate(sql);
                        outFlag = (bFlag ? "1" : "0");
                    }else
                    {
                        outFlag = "0";
                    }
                }

                if (outFlag.equals("1"))
                {
                    // show data
                    String strFields =  "sys_code,prog_code," + favor_name + ",favor_type" ;
                    String strConditions = null;
                    if (condition.length()<1)
                    {
                        strConditions = " company_code='"+companyCode
                            + "' and user_unique_no='"+userUniqueNo
                            + "' order by favor_type,favor_index ";
                    }else
                    {
                        strConditions = condition + " and (company_code='"+companyCode
                            + "' and user_unique_no='"+userUniqueNo
                            + "') order by favor_type,favor_index ";
                    }

                    String strTables = "sam_user_favor_v";

                    pageQuery.getData(strFields,strTables,strConditions,pageSize);
                    pageCount = pageQuery.pageCount;
                    pageCount = (pageCount < 1 ? 1 : pageCount);
                    currentPage = (currentPage > pageCount ? pageCount : currentPage);
                    vct = pageQuery.dividePage(currentPage,pageSize);
                }else
                {
                    vct = new Vector();
                }
            }
            else if (opFlag.equalsIgnoreCase("update"))
            {
                // update
                String mm_sys_code = request.getParameter("mm_sys_code");
                String mm_prog_code = request.getParameter("mm_prog_code");
                String m_favor_name = request.getParameter("m_favor_name");
                String favor_type = request.getParameter("favor_type");

                mm_sys_code = (mm_sys_code==null ? "" : mm_sys_code.trim());
                mm_prog_code = (mm_prog_code==null ? "" : mm_prog_code.trim());
                favor_type = (favor_type==null ? "" : favor_type.trim());
                m_favor_name = (m_favor_name==null ? "" : m_favor_name.trim());

                sql = "update sam_user_favor "
                    + " set " + favor_name + "='" + m_favor_name
                    + "',favor_type='" + favor_type
                    + "' where company_code='" + companyCode
                    + "' and user_unique_no='" + userUniqueNo
                    + "' and sys_code='" + mm_sys_code
                    + "' and prog_code='" + mm_prog_code + "'";

                boolean bFlag = pageQuery.simpleUpdate(sql);
                outFlag = (bFlag ? "1" : "0");

                // show data
                String strFields =  "sys_code,prog_code," + favor_name + ",favor_type" ;
                String strConditions = null;
                if (condition.length()<1)
                {
                    strConditions = " company_code='"+companyCode
                        + "' and user_unique_no='"+userUniqueNo
                        + "' order by favor_type,favor_index ";
                }else
                {
                    strConditions = condition + " and (company_code='"+companyCode
                        + "' and user_unique_no='"+userUniqueNo
                        + "') order by favor_type,favor_index ";
                }

                String strTables = "sam_user_favor_v";

                pageQuery.getData(strFields,strTables,strConditions,pageSize);
                pageCount = pageQuery.pageCount;
                pageCount = (pageCount < 1 ? 1 : pageCount);
                currentPage = (currentPage > pageCount ? pageCount : currentPage);
                vct = pageQuery.dividePage(currentPage,pageSize);

            }
            else // unknown situation
            {
                vct = new Vector();
            }

            request.setAttribute("vct",vct);
            request.setAttribute("opFlag",opFlag);
            request.setAttribute("outFlag",outFlag);
            request.setAttribute("pageCount",pageCount+"");
            request.setAttribute("currentPage",currentPage+"");
            request.setAttribute("selectAll",selectAll);
        }
        catch(Exception e)
        {

        }
        return null;
    }
}