sam0120handler.java

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

                    }
                    else  //菜单结点
                    {
                        sql = "insert into scg_program(company_code,sys_code,"
                            + "prog_code,prog_name_cn,prog_name_en,node_flag,"
                            + "mend_flag) "
                            + " values('" + companyCode + "','" + sys_code
                            + "','" + prog_code + "','" + prog_name_cn
                            + "','" + prog_name_en + "','" + node_flag
                            + "','" + mend_flag+ "')" ;

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

                //查询
                if (outFlag.equals("1"))
                {
                    if (opFlag.equals("insert"))
                    {
                        pageQuery.getData(strFields,strTables,strConditions,
                            pageSize);
                        pageCount = pageQuery.pageCount ;
                        currentPage =
                            (currentPage>pageCount ? pageCount : currentPage);
                        vct = pageQuery.dividePage(currentPage,pageSize);
                    }
                }
            }
            else if (opFlag.equals("modify"))
            {
                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 = "company_code='" + companyCode
                        + "' and sys_code='" + sys_code
                        + "' and prog_code='" + prog_code + "'" ;

                    rs = pageQuery.getData(strFields,strTables,sql,1) ;
                    if (rs!=null && rs.next())
                    {
                        String prog_name_cn = rs.getString("prog_name_cn");
                        String prog_name_en = rs.getString("prog_name_en");
                        String prog_value = rs.getString("prog_value");
                        String prog_params = rs.getString("prog_params");
                        String prog_code_father =
                            rs.getString("prog_code_father");
                        String prog_level = rs.getString("prog_level");
                        String check_right = rs.getString("check_right");
                        String rst_url = rs.getString("rst_url");
                        String mend_flag = rs.getString("mend_flag");
                        String oper_flag = rs.getString("oper_flag");
                        String node_flag = rs.getString("node_flag");
                        String table_name = rs.getString("table_name");

                        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());

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

                        request.setAttribute("sys_code",sys_code);
                        request.setAttribute("prog_code",prog_code);
                        request.setAttribute("prog_name_cn",prog_name_cn);
                        request.setAttribute("prog_name_en",prog_name_en);
                        request.setAttribute("prog_value",prog_value);
                        request.setAttribute("prog_level",prog_level);
                        request.setAttribute("check_right",check_right);
                        request.setAttribute("oper_flag",oper_flag);
                        request.setAttribute("rst_url",rst_url);
                        request.setAttribute("node_flag",node_flag);
                        request.setAttribute("prog_params",prog_params);
                        request.setAttribute("prog_code_father",prog_code_father);
                        request.setAttribute("mend_flag",mend_flag);
                        request.setAttribute("table_name",table_name);
                    }
                    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 prog_code = request.getParameter("prog_code");

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

                String node_flag = request.getParameter("node_flag");
                node_flag = (node_flag==null ? "" : node_flag.trim());

                if (sys_code.length()>0 && prog_code.length()>0)
                {
                  if (node_flag.equals("Y")) //菜单结点
                  {
                    String prog_name_cn = request.getParameter("prog_name_cn");
                    String prog_name_en = request.getParameter("prog_name_en");

                    prog_name_cn = Show.getString(prog_name_cn);
                    prog_name_en = Show.getString(prog_name_en);

                    sql = "update " + strTables
                      + " set prog_name_cn='" + prog_name_cn
                      + "', prog_name_en='" + prog_name_en
                      + "' where company_code='" + companyCode
                      + "' and sys_code='" + sys_code
                      + "' and prog_code='" + prog_code + "'";

                    Debug.println("sql="+sql);
                    if (!pageQuery.simpleUpdate(sql))
                      outFlag = "0" ;
                  }
                  else //程序
                  {
                    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 prog_params = request.getParameter("prog_params");
                    String table_name = request.getParameter("table_name");

                    table_name = (table_name==null ? "" : table_name.trim());
                    prog_name_cn = Show.getString(prog_name_cn);
                    prog_name_en = Show.getString(prog_name_en);
                    prog_value = Show.getString(prog_value);
                    check_right = Show.getString(check_right);
                    if (check_right.equals(""))
                      check_right = "N" ;

                    oper_flag = Show.getString(oper_flag);
                    if (oper_flag.equals(""))
                      oper_flag = "N" ;

                    rst_url = Show.getString(rst_url);
                    prog_params = Show.getString(prog_params);

                    String updateSQL = "update " + strTables
                                + " set prog_name_cn='" + prog_name_cn
                                + "',prog_name_en='" + prog_name_en
                                + "',prog_value='" + prog_value
                                + "',prog_level=" + prog_level
                                + ",oper_flag='" + oper_flag
                                + "',rst_url='" + rst_url
                                + "',prog_params='" + prog_params
                                + "',check_right='" + check_right
                                + "',table_name='" + table_name + "'"
                                + " where company_code='" + companyCode
                                + "' and sys_code='" + sys_code
                                + "' and prog_code='" + prog_code + "'";

                    Debug.println("updateSQl="+updateSQL);

                    String checkRight = null;
                    String progCodeFather = null ;

                    //get check_right first
                    sql = "select check_right,prog_code_father "
                      + " from scg_program "
                      + " 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())
		            {
                      checkRight = rs.getString(1);
                      progCodeFather = rs.getString(2);

                      checkRight = Show.getString(checkRight);
                      progCodeFather = Show.getString(progCodeFather);

                      //检查权限有无变化
                      if (checkRight.equals(check_right))
                      {
                        if (!pageQuery.simpleUpdate(updateSQL))
                          outFlag = "0" ;
                      }
                      else  //有变化
                      {
                        //是否菜单
                        boolean  isLeaf = false;
                        sql = "select 1 from scg_main_menu "
                          + " where company_code='" + companyCode
                          + "' and prog_sys_code='" + sys_code
                          + "' and prog_code='" + prog_code + "'";

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

                        rs = pageQuery.getData(sql);
                        if (rs!=null&&rs.next())
                          isLeaf = true ;

                        if (check_right.equals("Y"))//须授权,原来不用授权n-->y
                        {
                          if (progCodeFather.length()<1)//无父
                          {
                            if (isLeaf)//是菜单
                            {
                              sql = "delete from scg_main_menu "
                                + " where company_code='" + companyCode
                                + "' and prog_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 prog_flag='N',menu_flag='N'"
                                + " where company_code='" + companyCode + "'";
                            }
                            else
                            {
                              sql = "update sam_user_info "
                                + " set prog_flag='N'"