sam0130handler.java

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

                if (sys_code.length()>0 && menu_code.length()>0)
                {
                    sql = "company_code='" + companyCode
                        + "' and sys_code='" + sys_code
                        + "' and menu_code='" + menu_code + "'" ;

                    rs = pageQuery.getData(strFields,strTables,sql,1) ;
                    if (rs!=null && rs.next())
                    {
                        String menu_name_cn = rs.getString("menu_name_cn");
                        String menu_name_en = rs.getString("menu_name_en");
                        String menu_code_father = rs.getString("menu_code_father");
                        String menu_index = rs.getString("menu_index");
                        String leaf_flag = rs.getString("leaf_flag");
                        String prog_sys_code = rs.getString("prog_sys_code");
                        String prog_code = rs.getString("prog_code");

                        menu_name_cn = Show.getString(menu_name_cn);
                        menu_name_en = Show.getString(menu_name_en);
                        menu_code_father = Show.getString(menu_code_father);
                        menu_index = Show.getString(menu_index);
                        leaf_flag = Show.getString(leaf_flag);
                        prog_sys_code = Show.getString(prog_sys_code);
                        prog_code = Show.getString(prog_code);

                        request.setAttribute("sys_code",sys_code);
                        request.setAttribute("menu_code",menu_code);
                        request.setAttribute("menu_name_cn",menu_name_cn);
                        request.setAttribute("menu_name_en",menu_name_en);
                        request.setAttribute("menu_code_father",menu_code_father);
                        request.setAttribute("menu_index",menu_index);
                        request.setAttribute("leaf_flag",leaf_flag);
                        request.setAttribute("prog_sys_code",prog_sys_code);
                        request.setAttribute("prog_code",prog_code);

                        if (leaf_flag.equals("N"))
                        {
                          sql = "select 1 from " + strTables
                            + " where company_code='" + companyCode
                            + "' and sys_code='" + sys_code
                            + "' and menu_code_father='" + menu_code + "'";

                          rs = pageQuery.getData(sql);
                          if (rs!=null&&rs.next())
                          {
                            request.setAttribute("has_child","1");
                          }
                        }
                    }
                    else
                    {
                        outFlag = "0" ;
                    }
                }
                else
                {
                    outFlag = "0" ;
                }

                if (outFlag.equals("0")) //修改失败 query
                {
                    pageQuery.getData(strFields,strTables,strConditions,pageSize);
                    pageCount = pageQuery.pageCount ;
                    currentPage = (currentPage>pageCount ? pageCount : currentPage);
                    vct = pageQuery.dividePage(currentPage,pageSize);
                }
            }
            else if (opFlag.equals("update") || opFlag.equals("updMore")) //更新
            {
                String sys_code= request.getParameter("sys_code");
                String menu_code = request.getParameter("menu_code");

                sys_code = Show.getString(sys_code);
                menu_code = Show.getString(menu_code);

                if (sys_code.length()>0 && menu_code.length()>0)
                {
                  //修改
                  String menu_name_cn = request.getParameter("menu_name_cn");
                  String menu_name_en = request.getParameter("menu_name_en");
                  String menu_index = request.getParameter("menu_index");
                  String leaf_flag = request.getParameter("leaf_flag");
                  String prog_sys_code = request.getParameter("prog_sys_code");
                  String prog_code = request.getParameter("prog_code");
                  String menu_code_father=request.getParameter("menu_code_father");

                  menu_name_cn = Show.getString(menu_name_cn);
                  menu_name_en = Show.getString(menu_name_en);
                  menu_index = Show.getString(menu_index);
                  leaf_flag = Show.getString(leaf_flag);
                  prog_sys_code = Show.getString(prog_sys_code);
                  menu_code_father = Show.getString(menu_code_father);
                  if (menu_index.length()<1)
                    menu_index = "1" ;

                  if (leaf_flag.length()<1)
                    leaf_flag = "N" ;

                  boolean bFlag = false ;
                  if (menu_code_father.length()<1)
                  {
                    sql = "update " + strTables
                        + " set menu_name_cn='" + menu_name_cn
                        + "',menu_name_en='" + menu_name_en
                        + "',menu_code_father='',menu_level=1"
                        + ",menu_index=" + menu_index
                        + ",leaf_flag='" + leaf_flag
                        + "',prog_sys_code='" + prog_sys_code
                        + "',prog_code='" + prog_code + "'"
                        + " where company_code='" + companyCode
                        + "' and sys_code='" + sys_code
                        + "' and menu_code='" + menu_code + "'" ;
                  }
                  else
                  {
                    sql = "update " + strTables
                        + " set menu_name_cn='" + menu_name_cn
                        + "',menu_name_en='" + menu_name_en
                        + "',menu_code_father='" + menu_code_father
                        + "',menu_level="
                        + "(select menu_level+1 from " + strTables
                        + " where company_code='" + companyCode
                        + "' and sys_code='" + sys_code
                        + "' and menu_code='" + menu_code_father + "')"
                        + ",menu_index=" + menu_index
                        + ",leaf_flag='" + leaf_flag
                        + "',prog_sys_code='" + prog_sys_code
                        + "',prog_code='" + prog_code + "'"
                        + " where company_code='" + companyCode
                        + "' and sys_code='" + sys_code
                        + "' and menu_code='" + menu_code + "'" ;
                  }

                  Debug.print("sql="+sql);
                  bFlag = pageQuery.simpleUpdate(sql);
                  if (bFlag)
                  {
                    sql = "update sam_user_info set menu_flag='N'"
                        + " where company_code='" + companyCode + "'";

                    pageQuery.simpleUpdate(sql);
                  }
                  else
                  {
                    outFlag = "0" ;
                  }
                }
                else
                {
                    outFlag = "0" ;
                }

                if (outFlag.equals("1")) //查询
                {
                    if (opFlag.equals("update"))
                    {
                        pageQuery.getData(strFields,strTables,strConditions,
                            pageSize);
                        pageCount = pageQuery.pageCount ;
                        currentPage = (currentPage>pageCount ?
                            pageCount : currentPage);
                        vct = pageQuery.dividePage(currentPage,pageSize);
                    }
                }
            }
            else if (opFlag.equals("delete")) //删除
            {
                String sys_code= request.getParameter("sys_code");
                String menu_code = request.getParameter("menu_code");

                sys_code = (sys_code==null ? "" : sys_code.trim());
                menu_code = (menu_code==null ? "" : menu_code.trim());

                if (sys_code.length()>0 && menu_code.length()>0)
                {
                    sql = " select 1 from scg_main_menu " //主菜单
                        + " where company_code='" + companyCode
                        + "' and sys_code='" + sys_code
                        + "' and menu_code_father='" + menu_code + "'" ;

                    Debug.println("sql="+sql);
                    rs = pageQuery.getData(sql);
                    if (rs!=null && rs.next())
                    {
                        outFlag = "0" ;
                    }
                    else
                    {
                        sql = "delete from " + strTables
                          + " where company_code='" + companyCode
                          + "' and sys_code='" + sys_code
                          + "' and menu_code='" + menu_code + "'" ;

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

                        sql = "delete from sam_user_menu "
                          + " where company_code='" + companyCode
                          + "' and sys_code='" + sys_code
                          + "' and menu_code='" + menu_code + "'" ;

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

                //query
                pageQuery.getData(strFields,strTables,strConditions,pageSize);
                pageCount = pageQuery.pageCount ;
                currentPage = (currentPage>pageCount ? pageCount : currentPage);
                vct = pageQuery.dividePage(currentPage,pageSize);
            }
            else if (opFlag.equals("query")) //查询
            {
                pageQuery.getData(strFields,strTables,strConditions,pageSize);
                pageCount = pageQuery.pageCount ;
                currentPage = (currentPage>pageCount ? pageCount : currentPage);
                vct = pageQuery.dividePage(currentPage,pageSize);
            }
            else //刚进入
            {
                //do nothing
                pageCount = 0 ;
                currentPage = 0 ;
            }

            //取得系统代码和名称
            int sysSize = 100; //子系统数目
            sql = "company_code='" + companyCode + "'" ;
            pageQuery.getData("sys_code,sys_name","scg_system",sql,sysSize);
            sysVct = pageQuery.dividePage(1,sysSize);
        }
        catch (Exception e)
        {
            e.printStackTrace();
            outFlag = "0" ;
        }

        vct = (vct==null ? new Vector() : vct);
        sysVct = (sysVct==null ? new Vector() : sysVct);
        request.setAttribute("sysVct",sysVct);
        request.setAttribute("vct",vct);
        request.setAttribute("outFlag",outFlag);
        request.setAttribute("opFlag",opFlag);
        request.setAttribute("querySysCode",querySysCode);
        request.setAttribute("queryType",queryType);
        request.setAttribute("queryValue",queryValue);
        request.setAttribute("currentPage",currentPage+"");
        request.setAttribute("pageCount",pageCount+"");

        Debug.println("process handler over,outFlag="+outFlag);
        return null;
    }
}