sam0120handler.java

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

                                + " where company_code='" + companyCode + "'";
                            }
                            Debug.println("sql="+sql);

                            pageQuery.simpleUpdate(sql);

                            if (!pageQuery.simpleUpdate(updateSQL))
                                outFlag = "0" ;
                          }
                        }
                        else //无须授权,原来须授权y-->n
                        {
                          if (progCodeFather.length()<1)//父为空
                          {
                            if (isLeaf)//menu
                            {
                              sql = "update sam_user_info set menu_flag='N'"
                                + " wehre company_code='" + companyCode + "'";

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

                              pageQuery.simpleUpdate(sql);
                            }
                            sql = "delete from sam_role_prog "
                                + " where company_code='" + companyCode
                                + "' and sys_code='" + sys_code
                                + "' and prog_code='" + prog_code + "'";

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

                            pageQuery.simpleUpdate(sql);

                            sql = "delete from sam_position_prog "
                                + " where company_code='" + companyCode
                                + "' and sys_code='" + sys_code
                                + "' and prog_code='" + prog_code + "'";

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

                            pageQuery.simpleUpdate(sql);

                            sql = "delete from sam_user_prog "
                                + " where company_code='" + companyCode
                                + "' and sys_code='" + sys_code
                                + "' and prog_code='" + prog_code + "'";

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

                            pageQuery.simpleUpdate(sql);

                            sql = "delete from sam_user_prog_right "
                                + " where company_code='" + companyCode
                                + "' and sys_code='" + sys_code
                                + "' and prog_code='" + prog_code + "'";

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

                            pageQuery.simpleUpdate(sql);

                            if (!pageQuery.simpleUpdate(updateSQL))
                                outFlag = "0" ;

                          }
                          else //有父
                          {
                            if (isLeaf)
                            {
                              sql = "update sam_user_info set menu_flag='N'"
                                + " wehre company_code='" + companyCode + "'";

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

                              pageQuery.simpleUpdate(sql);
                            }
                            if (!pageQuery.simpleUpdate(updateSQL))
                                outFlag = "0" ;
                          }
                        }
                      }
                    }
                    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 prog_code = request.getParameter("prog_code");

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

                if (sys_code.length()>0 && prog_code.length()>0)
                {
                    sql = " select 1 from scg_main_menu " //主菜单
                        + " where company_code='" + companyCode
                        + "' and prog_sys_code='" + sys_code
                        + "' and prog_code='" + prog_code + "'"
                        + " union "
                        + " select 1 from scg_program " //有子程序或不可修改
                        + " where company_code='" + companyCode
                        + "' and sys_code='" + sys_code
                        + "' and (prog_code_father='" + prog_code
                        + "' or (prog_code='" + prog_code
                        + "' and mend_flag='N'))" ;

                    Debug.println("sql="+sql);
                    rs = pageQuery.getData(sql);
                    if (rs!=null && rs.next())
                    {
                        outFlag = "0" ;
                    }
                    else
                    {
                        //check right or not
                        sql = "select check_right,prog_code_father "
                            + " from " + strTables
                            + " where company_code='" + companyCode
                            + "' and sys_code='" + sys_code
                            + "' and prog_code='" + prog_code + "'" ;

                        Debug.println("sql="+sql);
                        rs = pageQuery.getData(sql);
                        if (rs!=null && rs.next())
                        {
                            String mCheckRight = rs.getString(1);
                            String mProgCodeFather = rs.getString(2);

                            mCheckRight =
                                (mCheckRight==null ? "" : mCheckRight.trim());

                            mProgCodeFather = (mProgCodeFather==null ?
                                "" : mProgCodeFather.trim());

                            //delete relatives first
                            {
                                if (mProgCodeFather.length()<1 &&
                                    mCheckRight.equalsIgnoreCase("Y"))
                                {//可能已被授权
                                    //角色
                                    sql = "delete from sam_role_prog "
                                        + " where company_code='" + companyCode
                                        + "' and sys_code='" + sys_code
                                        + "' and prog_code='" + prog_code + "'" ;

                                    pageQuery.simpleUpdate(sql);

                                    //职位
                                    sql = "delete from sam_position_prog "
                                        + " where company_code='" + companyCode
                                        + "' and sys_code='" + sys_code
                                        + "' and prog_code='" + prog_code + "'" ;

                                    pageQuery.simpleUpdate(sql);

                                    //人员
                                    sql = "delete from sam_user_prog "
                                        + " where company_code='" + companyCode
                                        + "' and sys_code='" + sys_code
                                        + "' and prog_code='" + prog_code + "'" ;

                                    pageQuery.simpleUpdate(sql);

                                    //人员权限
                                    sql = "delete from sam_user_prog_right "
                                        + " where company_code='" + companyCode
                                        + "' and sys_code='" + sys_code
                                        + "' and prog_code='" + prog_code + "'" ;

                                    pageQuery.simpleUpdate(sql);

                                }

                                sql = "delete from " + strTables
                                    + " where company_code='" + companyCode
                                    + "' and sys_code='" + sys_code
                                    + "' and prog_code='" + prog_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
                currentPage = 0;
                pageCount = 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;
    }

}