开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > 行业应用 > OA系统 > 查看源码
authority_edit.aspx.cs
资源名称：web.rar　[点击查看]
上传用户：xrffrp
上传日期：2022-03-25
资源大小：22155k
文件大小：22k
源码类别：

OA系统

开发平台：

ASP/ASPX

authority_edit.aspx.cs：源码内容
  1. using System;
  2. using System.Data;
  3. using System.Configuration;
  4. using System.Collections;
  5. using System.Web;
  6. using System.Web.Security;
  7. using System.Web.UI;
  8. using System.Web.UI.WebControls;
  9. using System.Web.UI.WebControls.WebParts;
  10. using System.Web.UI.HtmlControls;
  11. using System.Data.SqlClient;
  13. public partial class web_system_authority_edit : System.Web.UI.Page
  14. {
  15.     protected void Page_Load(object sender, EventArgs e)
  16.     {
  17.         LoginDAO.CheckLogin(Session, Response, "../", 2);
  18.         if (!IsPostBack)
  19.         {
  20.             ArrayList ids = new ArrayList();
  21.             if (Request.QueryString["g_id"] != null)
  22.             { 
  23.                 ids = this.getMenuIds(Request.QueryString["g_id"]);
  24.             }
  25.             this.AddOaTable(ids);
  26.             this.AddKmTable(ids);
  27.         }
  29.     }
  31.     protected ArrayList getMenuIds(string group_id)
  32.     {
  33.         ArrayList ids = new ArrayList();
  34.         SqlConnection conn = dbConnection.getConnection();
  35.         conn.Open();
  36.         SqlCommand cmd = new SqlCommand("select menu_id from OA_USER_GROUP_DETAIL where main_id="+group_id, conn);
  37.         SqlDataReader dr = cmd.ExecuteReader();
  38.         while (dr.Read())
  39.         {
  40.             ids.Add(dr["menu_id"].ToString());
  41.         }
  42.         dr.Close();
  44.         cmd = new SqlCommand("select name from OA_USER_GROUP_MAIN where id="+group_id, conn);
  45.         TxtName.Text = cmd.ExecuteScalar().ToString();
  47.         conn.Close();
  48.         return ids;
  49.     }
  51.     protected ArrayList GetDirEdit(string main_id)
  52.     {
  53.         ArrayList dirEdits = new ArrayList();
  54.         SqlConnection conn = dbConnection.getConnection();
  55.         conn.Open();
  57.         SqlCommand cmd = new SqlCommand("select menu_id from OA_USER_GROUP_DETAIL where main_id=" +
  58.             main_id + " and function_id='edit'", conn);
  59.         SqlDataReader dr = cmd.ExecuteReader();
  60.         while (dr.Read())
  61.         {
  62.             dirEdits.Add(dr["menu_id"].ToString());
  63.         }
  64.         dr.Close();
  66.         conn.Close();
  67.         return dirEdits;
  68.     }
  70.     //動態生成選單表格
  71.     protected void AddOaTable(ArrayList menus)
  72.     {
  73.         Table mainTable = new Table();
  74.         mainTable.BorderWidth = Unit.Pixel(1);
  75.         mainTable.HorizontalAlign = HorizontalAlign.Center;
  76.         PnlOa.Controls.Add(mainTable);
  78.         SqlConnection conn = dbConnection.getConnection();
  79.         conn.Open();
  81.         ArrayList ids = new ArrayList();
  82.         ArrayList names = new ArrayList();
  84.         SqlCommand cmd = new SqlCommand("select id, name from OA_SYS_CHILD_MENU where id=78 or id=22 or id=24 or id=161 order by name", conn);
  85.         SqlDataReader dr = cmd.ExecuteReader();
  86.         while (dr.Read())
  87.         {
  88.             ids.Add(dr["id"].ToString());
  89.             names.Add(dr["name"].ToString());
  90.         }
  91.         dr.Close();
  93.         for (int i = 0; i < ids.Count; i++)
  94.         {
  95.             TableRow tr1 = new TableRow();
  96.             tr1.BorderWidth = Unit.Pixel(1);
  98.             TableCell td1 = new TableCell();
  99.             td1.Width = Unit.Pixel(150);
  100.             tr1.HorizontalAlign = HorizontalAlign.Left;
  102.             CheckBox cb = new CheckBox();
  103.             cb.ID = "chk" + ids[i].ToString();
  104.             cb.Text = names[i].ToString();
  105.             cb.InputAttributes["parent"] = "1";
  106.             cb.InputAttributes["value"] = ids[i].ToString();
  107.             cb.InputAttributes["onclick"] = "check(" + ids[i] + ")";
  108.             cb.Checked = false;
  109.             for (int m = 0; m < menus.Count; m++)
  110.             { 
  111.                 if(menus[m].Equals(ids[i]))
  112.                 {
  113.                     cb.Checked = true;
  114.                     break;
  115.                 }
  116.             }
  117.             td1.Controls.Add(cb);
  118.             tr1.Cells.Add(td1);
  119.             td1.BorderWidth = Unit.Pixel(1);
  121.             ArrayList ids1 = new ArrayList();
  122.             ArrayList names1 = new ArrayList();
  123.             cmd = new SqlCommand("select id, name from OA_SYS_CHILD_MENU where parent_id=" + ids[i] + " and is_open='Y' order by name", conn);
  124.             dr = cmd.ExecuteReader();
  125.             while (dr.Read())
  126.             {
  127.                 ids1.Add(dr["id"].ToString());
  128.                 names1.Add(dr["name"].ToString());
  129.             }
  130.             dr.Close();
  132.             Table tb1 = new Table();
  133.             TableCell td2 = new TableCell();
  134.             td2.BorderWidth = Unit.Pixel(1);
  135.             td2.Width = Unit.Pixel(750);
  137.             for (int j = 0; j < ids1.Count; j++)
  138.             {
  139.                 TableRow tr2 = new TableRow();
  141.                 TableCell td3 = new TableCell();
  142.                 td3.BorderWidth = Unit.Pixel(1);
  143.                 td3.Width = Unit.Pixel(200);
  144.                 tr2.HorizontalAlign = HorizontalAlign.Left;
  145.                 cb = new CheckBox();
  146.                 cb.InputAttributes["parent"] = ids[i].ToString();
  147.                 cb.InputAttributes["value"] = ids1[j].ToString();
  148.                 cb.InputAttributes["onclick"] = "check(" + ids1[j] + ")";
  149.                 cb.ID = "chk" + ids1[j].ToString();
  150.                 cb.Text = names1[j].ToString();
  151.                 cb.Checked = false;
  152.                 for (int m = 0; m < menus.Count; m++)
  153.                 {
  154.                     if (menus[m].Equals(ids1[j]))
  155.                     {
  156.                         cb.Checked = true;
  157.                         break;
  158.                     }
  159.                 }
  160.                 td3.Controls.Add(cb);
  161.                 tr2.Cells.Add(td3);
  162.                 ArrayList ids2 = new ArrayList();
  163.                 ArrayList names2 = new ArrayList();
  164.                 cmd = new SqlCommand("select id, name from OA_SYS_CHILD_MENU where parent_id=" + ids1[j] + " and is_open='Y' order by name", conn);
  165.                 dr = cmd.ExecuteReader();
  166.                 while (dr.Read())
  167.                 {
  168.                     ids2.Add(dr["id"].ToString());
  169.                     names2.Add(dr["name"].ToString());
  170.                 }
  171.                 dr.Close();
  173.                 Table tb2 = new Table();
  174.                 TableCell td5 = new TableCell();
  175.                 td5.BorderWidth = Unit.Pixel(1);
  176.                 td5.Width = Unit.Pixel(500);
  177.                 for (int k = 0; k < ids2.Count; k++)
  178.                 {
  179.                     TableRow tr3 = new TableRow();
  181.                     TableCell td4 = new TableCell();
  182.                     td4.BorderWidth = Unit.Pixel(1);
  183.                     td4.Width = Unit.Pixel(220);
  184.                     tr3.HorizontalAlign = HorizontalAlign.Left;
  185.                     cb = new CheckBox();
  186.                     cb.InputAttributes["parent"] = ids1[j].ToString();
  187.                     cb.InputAttributes["value"] = ids2[k].ToString();
  188.                     cb.InputAttributes["onclick"] = "check(" + ids2[k] + ")";
  189.                     cb.ID = "chk" + ids2[k].ToString();
  190.                     cb.Text = names2[k].ToString();
  191.                     cb.Checked = false;
  192.                     for (int m = 0; m < menus.Count; m++)
  193.                     {
  194.                         if (menus[m].Equals(ids2[k]))
  195.                         {
  196.                             cb.Checked = true;
  197.                             break;
  198.                         }
  199.                     }
  200.                     td4.Controls.Add(cb);
  201.                     tr3.Cells.Add(td4);
  202.                     tb2.Rows.Add(tr3);
  203.                     ArrayList ids3 = new ArrayList();
  204.                     ArrayList names3 = new ArrayList();
  205.                     cmd = new SqlCommand("select id, name from OA_SYS_CHILD_MENU where parent_id=" + ids2[k] + " and is_open='Y' order by name", conn);
  206.                     dr = cmd.ExecuteReader();
  207.                     while (dr.Read())
  208.                     {
  209.                         ids3.Add(dr["id"].ToString());
  210.                         names3.Add(dr["name"].ToString());
  211.                     }
  212.                     dr.Close();
  214.                     TableCell td6 = new TableCell();
  215.                     td6.VerticalAlign = VerticalAlign.Top;
  216.                     Table tb3 = new Table();
  217.                     for (int l = 0; l < ids3.Count; l++)
  218.                     {
  219.                         TableRow tr4 = new TableRow();
  221.                         TableCell td7 = new TableCell();
  222.                         td7.BorderWidth = Unit.Pixel(1);
  223.                         td7.Width = Unit.Pixel(280);
  224.                         td7.VerticalAlign = VerticalAlign.Top;
  225.                         tr3.HorizontalAlign = HorizontalAlign.Left;
  226.                         cb = new CheckBox();
  227.                         cb.InputAttributes["parent"] = ids2[k].ToString();
  228.                         cb.InputAttributes["value"] = ids3[l].ToString();
  229.                         cb.InputAttributes["onclick"] = "check(" + ids3[l] + ")";
  230.                         cb.ID = "chk" + ids3[l].ToString();
  231.                         cb.Text = names3[l].ToString();
  232.                         cb.Checked = false;
  233.                         for (int m = 0; m < menus.Count; m++)
  234.                         {
  235.                             if (menus[m].Equals(ids3[l]))
  236.                             {
  237.                                 cb.Checked = true;
  238.                                 break;
  239.                             }
  240.                         }
  241.                         td7.Controls.Add(cb);
  242.                         tr4.Cells.Add(td7);
  243.                         tb3.Rows.Add(tr4);
  244.                     }
  245.                     td6.Controls.Add(tb3);
  246.                     tr3.Cells.Add(td6);
  247.                 }
  248.                 td5.Controls.Add(tb2);
  249.                 tr2.Cells.Add(td5);
  250.                 tb1.Rows.Add(tr2);
  251.             }
  252.             td2.Controls.Add(tb1);
  253.             tr1.Cells.Add(td2);
  255.             mainTable.Rows.Add(tr1);
  256.         }
  257.         mainTable.Rows.Add(new TableRow());
  258.         conn.Close();
  259.     }
  261.     protected void AddKmTable(ArrayList menus)
  262.     {
  263.         ArrayList dirEdits = this.GetDirEdit(Request.QueryString["g_id"]);
  265.         Table mainTable = new Table();
  266.         mainTable.BorderWidth = Unit.Pixel(1);
  267.         mainTable.HorizontalAlign = HorizontalAlign.Center;
  268.         PnlKm.Controls.Add(mainTable);
  270.         SqlConnection conn = dbConnection.getConnection();
  271.         conn.Open();
  273.         ArrayList ids = new ArrayList();
  274.         ArrayList names = new ArrayList();
  276.         SqlCommand cmd = new SqlCommand("select id, name from OA_SYS_CHILD_MENU where parent_id=77 and is_open='Y' order by name", conn);
  277.         SqlDataReader dr = cmd.ExecuteReader();
  278.         while (dr.Read())
  279.         {
  280.             ids.Add(dr["id"].ToString());
  281.             names.Add(dr["name"].ToString());
  282.         }
  283.         dr.Close();
  285.         for (int i = 0; i < ids.Count; i++)
  286.         {
  287.             TableRow tr1 = new TableRow();
  288.             tr1.BorderWidth = Unit.Pixel(1);
  290.             TableCell td1 = new TableCell();
  291.             td1.Width = Unit.Pixel(150);
  292.             tr1.HorizontalAlign = HorizontalAlign.Left;
  294.             CheckBox cb = new CheckBox();
  295.             cb.ID = "chk" + ids[i].ToString();
  296.             cb.Text = names[i].ToString();
  297.             cb.InputAttributes["parent"] = "1";
  298.             cb.InputAttributes["value"] = ids[i].ToString();
  299.             cb.InputAttributes["onclick"] = "check(" + ids[i] + ")";
  300.             cb.Checked = false;
  301.             for (int m = 0; m < menus.Count; m++)
  302.             {
  303.                 if (menus[m].Equals(ids[i]))
  304.                 {
  305.                     cb.Checked = true;
  306.                     break;
  307.                 }
  308.             }
  309.             td1.Controls.Add(cb);
  310.             tr1.Cells.Add(td1);
  311.             td1.BorderWidth = Unit.Pixel(1);
  313.             ArrayList ids1 = new ArrayList();
  314.             ArrayList names1 = new ArrayList();
  315.             cmd = new SqlCommand("select id, name from OA_SYS_CHILD_MENU where parent_id=" + ids[i] + " and is_open='Y' order by name", conn);
  316.             dr = cmd.ExecuteReader();
  317.             while (dr.Read())
  318.             {
  319.                 ids1.Add(dr["id"].ToString());
  320.                 names1.Add(dr["name"].ToString());
  321.             }
  322.             dr.Close();
  324.             Table tb1 = new Table();
  325.             TableCell td2 = new TableCell();
  326.             td2.BorderWidth = Unit.Pixel(1);
  327.             td2.Width = Unit.Pixel(750);
  328.             int max_dir = 0;
  330.             for (int j = 0; j < ids1.Count; j++)
  331.             {
  332.                 TableRow tr2 = new TableRow();
  334.                 TableCell td3 = new TableCell();
  335.                 td3.BorderWidth = Unit.Pixel(1);
  336.                 td3.Width = Unit.Pixel(200);
  337.                 tr2.HorizontalAlign = HorizontalAlign.Left;
  338.                 cb = new CheckBox();
  339.                 cb.InputAttributes["parent"] = ids[i].ToString();
  340.                 cb.InputAttributes["value"] = ids1[j].ToString();
  341.                 cb.InputAttributes["onclick"] = "check(" + ids1[j] + ")";
  342.                 cb.ID = "chk" + ids1[j].ToString();
  343.                 cb.Text = names1[j].ToString();
  344.                 cb.Checked = false;
  345.                 for (int m = 0; m < menus.Count; m++)
  346.                 {
  347.                     if (menus[m].Equals(ids1[j]))
  348.                     {
  349.                         cb.Checked = true;
  350.                         break;
  351.                     }
  352.                 }
  353.                 td3.Controls.Add(cb);
  354.                 tr2.Cells.Add(td3);
  355.                 ArrayList ids2 = new ArrayList();
  356.                 ArrayList names2 = new ArrayList();
  357.                 cmd = new SqlCommand("select id, name from OA_SYS_CHILD_MENU where parent_id=" + ids1[j] + " and is_open='Y' order by name", conn);
  358.                 dr = cmd.ExecuteReader();
  359.                 while (dr.Read())
  360.                 {
  361.                     ids2.Add(dr["id"].ToString());
  362.                     names2.Add(dr["name"].ToString());
  363.                 }
  364.                 dr.Close();
  366.                 Table tb2 = new Table();
  367.                 TableCell td5 = new TableCell();
  368.                 td5.BorderWidth = Unit.Pixel(1);
  369.                 td5.Width = Unit.Pixel(500);
  370.                 if (!ids[i].Equals("16"))
  371.                 {
  372.                     for (int k = 0; k < ids2.Count; k++)
  373.                     {
  374.                         TableRow tr3 = new TableRow();
  376.                         TableCell td4 = new TableCell();
  377.                         td4.BorderWidth = Unit.Pixel(1);
  378.                         td4.Width = Unit.Pixel(220);
  379.                         tr3.HorizontalAlign = HorizontalAlign.Left;
  380.                         cb = new CheckBox();
  381.                         cb.InputAttributes["parent"] = ids1[j].ToString();
  382.                         cb.InputAttributes["value"] = ids2[k].ToString();
  383.                         cb.InputAttributes["onclick"] = "check(" + ids2[k] + ")";
  384.                         cb.ID = "chk" + ids2[k].ToString();
  385.                         cb.Text = names2[k].ToString();
  386.                         cb.Checked = false;
  387.                         for (int m = 0; m < menus.Count; m++)
  388.                         {
  389.                             if (menus[m].Equals(ids2[k]))
  390.                             {
  391.                                 cb.Checked = true;
  392.                                 break;
  393.                             }
  394.                         }
  395.                         td4.Controls.Add(cb);
  396.                         tr3.Cells.Add(td4);
  397.                         tb2.Rows.Add(tr3);
  398.                         ArrayList ids3 = new ArrayList();
  399.                         ArrayList names3 = new ArrayList();
  400.                         cmd = new SqlCommand("select id, name from OA_SYS_CHILD_MENU where parent_id=" + ids2[k] + " and is_open='Y' order by name", conn);
  401.                         dr = cmd.ExecuteReader();
  402.                         while (dr.Read())
  403.                         {
  404.                             ids3.Add(dr["id"].ToString());
  405.                             names3.Add(dr["name"].ToString());
  406.                         }
  407.                         dr.Close();
  409.                         TableCell td6 = new TableCell();
  410.                         td6.VerticalAlign = VerticalAlign.Top;
  411.                         Table tb3 = new Table();
  412.                         for (int l = 0; l < ids3.Count; l++)
  413.                         {
  414.                             TableRow tr4 = new TableRow();
  416.                             TableCell td7 = new TableCell();
  417.                             td7.BorderWidth = Unit.Pixel(1);
  418.                             td7.Width = Unit.Pixel(280);
  419.                             td7.VerticalAlign = VerticalAlign.Top;
  420.                             tr3.HorizontalAlign = HorizontalAlign.Left;
  421.                             cb = new CheckBox();
  422.                             cb.InputAttributes["parent"] = ids2[k].ToString();
  423.                             cb.InputAttributes["value"] = ids3[l].ToString();
  424.                             cb.InputAttributes["onclick"] = "check(" + ids3[l] + ")";
  425.                             cb.ID = "chk" + ids3[l].ToString();
  426.                             cb.Text = names3[l].ToString();
  427.                             cb.Checked = false;
  428.                             for (int m = 0; m < menus.Count; m++)
  429.                             {
  430.                                 if (menus[m].Equals(ids3[l]))
  431.                                 {
  432.                                     cb.Checked = true;
  433.                                     break;
  434.                                 }
  435.                             }
  436.                             td7.Controls.Add(cb);
  437.                             tr4.Cells.Add(td7);
  438.                             tb3.Rows.Add(tr4);
  439.                         }
  440.                         td6.Controls.Add(tb3);
  441.                         tr3.Cells.Add(td6);
  442.                     }
  443.                 }
  444.                 else
  445.                 {
  446.                     if (Convert.ToInt32(ids1[j]) > max_dir)
  447.                     {
  448.                         max_dir = Convert.ToInt32(ids1[j]);
  449.                     }
  450.                     TableRow trDir = new TableRow();
  451.                     TableCell tdDir = new TableCell();
  452.                     tdDir.VerticalAlign = VerticalAlign.Top;
  454.                     RadioButtonList rb = new RadioButtonList();
  455.                     rb.ID = "rb" + ids1[j];
  456.                     rb.RepeatDirection = RepeatDirection.Horizontal;
  457.                     ListItem item = new ListItem();
  458.                     item.Selected = true;
  459.                     item.Value = "view" + ids1[j];
  460.                     item.Text = "瀏覽<br><br>";
  461.                     rb.Items.Add(item);
  462.                     item = new ListItem();
  463.                     for (int o = 0; o < dirEdits.Count; o++)
  464.                     {
  465.                         if (dirEdits[o].ToString().Equals(ids1[j]))
  466.                         {
  467.                             item.Selected = true;
  468.                         }
  469.                     }
  470.                     item.Value = "edit" + ids1[j];
  471.                     item.Text = "編輯<br><br>";
  472.                     rb.Items.Add(item);
  474.                     tdDir.Controls.Add(rb);
  475.                     trDir.Cells.Add(tdDir);
  476.                     tb2.Rows.Add(trDir);
  477.                     MaxDir.Value = max_dir.ToString();
  478.                 }
  479.                 td5.Controls.Add(tb2);
  480.                 tr2.Cells.Add(td5);
  481.                 tb1.Rows.Add(tr2);
  482.             }
  483.             td2.Controls.Add(tb1);
  484.             tr1.Cells.Add(td2);
  486.             mainTable.Rows.Add(tr1);
  487.         }
  488.         mainTable.Rows.Add(new TableRow());
  489.         conn.Close();
  490.     }
  491.     protected void BtnOk_Click(object sender, EventArgs e)
  492.     {
  493.         SqlConnection conn = dbConnection.getConnection();
  494.         conn.Open();
  495.         SqlTransaction tx = conn.BeginTransaction();
  496.         try
  497.         {
  498.             string id = "0";
  499.             if (Request.QueryString["g_id"] != null)
  500.             {
  501.                 id = Request.QueryString["g_id"];
  502.             }
  503.             DateMgr mgr = new DateMgr();
  504.             string time = mgr.getDateTime();
  505.             User user = new User();
  506.             if (Session["user"] != null)
  507.             {
  508.                 user = (User)Session["user"];
  509.             }
  510.             SqlCommand cmd = new SqlCommand("update OA_USER_GROUP_MAIN set name='"+TxtName.Text+"', upd_user='"+user.Emp_name+"', upd_date='"+time+"' where id="+id, conn);
  511.             cmd.Transaction = tx;
  512.             cmd.ExecuteNonQuery();
  513.             
  514.             //刪除原來的權限群組
  515.             cmd = new SqlCommand("delete from OA_USER_GROUP_DETAIL where main_id="+id, conn);
  516.             cmd.Transaction = tx;
  517.             cmd.ExecuteNonQuery();
  519.             string[] menus = Menus.Value.Split(new char[] { ',' });
  520.             for (int i = 0; i < menus.Length; i++)
  521.             {
  522.                 try
  523.                 {
  524.                     cmd = new SqlCommand("insert into OA_USER_GROUP_DETAIL(main_id, menu_id)" +
  525.                         "values(" + id + ", " + menus[i] + ")", conn);
  526.                     cmd.Transaction = tx;
  527.                     cmd.ExecuteNonQuery();
  528.                 }
  529.                 catch { }
  530.             }
  533.             //添加規章制度瀏覽權限設定
  534.             string[] dir_edit = DirEdit.Value.Split(new char[] { ';' });
  535.             for (int i = 0; i < dir_edit.Length - 1; i++)
  536.             {
  537.                 cmd = new SqlCommand("update OA_USER_GROUP_DETAIL set function_id='edit' where menu_id=" + dir_edit[i] + " and main_id=" + id, conn);
  538.                 cmd.Transaction = tx;
  539.                 cmd.ExecuteNonQuery();
  540.             }
  542.             tx.Commit();
  543.         }
  544.         catch (Exception ex)
  545.         {
  546.             tx.Rollback();
  547.             Response.Write(ex.Message);
  548.         }
  549.         Response.Redirect("authority_list.aspx");
  550.         conn.Close();
  551.     }
  552. }