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

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

OA系统

开发平台：

ASP/ASPX

authority.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 : 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.             this.AddOaTable();
  21.             this.AddKmTable();
  22.         }
  24.     }
  25.     //動態生成選單表格
  26.     protected void AddOaTable()
  27.     {
  28.         Table mainTable = new Table();
  29.         mainTable.BorderWidth = Unit.Pixel(1);
  30.         mainTable.HorizontalAlign = HorizontalAlign.Center;
  31.         PnlOa.Controls.Add(mainTable);
  33.         SqlConnection conn = dbConnection.getConnection();
  34.         conn.Open();
  36.         ArrayList ids = new ArrayList();
  37.         ArrayList names = new ArrayList();
  39.         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);
  40.         SqlDataReader dr = cmd.ExecuteReader();
  41.         while (dr.Read())
  42.         {
  43.             ids.Add(dr["id"].ToString());
  44.             names.Add(dr["name"].ToString());
  45.         }
  46.         dr.Close();
  48.         for (int i = 0; i < ids.Count; i++)
  49.         {
  50.             TableRow tr1 = new TableRow();
  51.             tr1.BorderWidth = Unit.Pixel(1);
  53.             TableCell td1 = new TableCell();
  54.             td1.Width = Unit.Pixel(150);
  55.             tr1.HorizontalAlign = HorizontalAlign.Left;
  57.             CheckBox cb = new CheckBox();
  58.             cb.ID = "chk" + ids[i].ToString();
  59.             cb.Text = names[i].ToString();
  60.             cb.InputAttributes["parent"] = "1";
  61.             cb.InputAttributes["value"] = ids[i].ToString();
  62.             cb.InputAttributes["onclick"] = "check("+ids[i]+")";
  63.             td1.Controls.Add(cb);
  64.             tr1.Cells.Add(td1);
  65.             td1.BorderWidth = Unit.Pixel(1);
  67.             ArrayList ids1 = new ArrayList();
  68.             ArrayList names1 = new ArrayList();
  69.             cmd = new SqlCommand("select id, name from OA_SYS_CHILD_MENU where parent_id=" + ids[i] + " and is_open='Y' order by name", conn);
  70.             dr = cmd.ExecuteReader();
  71.             while (dr.Read())
  72.             {
  73.                 ids1.Add(dr["id"].ToString());
  74.                 names1.Add(dr["name"].ToString());
  75.             }
  76.             dr.Close();
  78.             Table tb1 = new Table();
  79.             TableCell td2 = new TableCell();
  80.             td2.BorderWidth = Unit.Pixel(1);
  81.             td2.Width = Unit.Pixel(750);
  83.             for (int j = 0; j < ids1.Count; j++)
  84.             {
  85.                 TableRow tr2 = new TableRow();
  87.                 TableCell td3 = new TableCell();
  88.                 td3.BorderWidth = Unit.Pixel(1);
  89.                 td3.Width = Unit.Pixel(200);
  90.                 tr2.HorizontalAlign = HorizontalAlign.Left;
  91.                 cb = new CheckBox();
  92.                 cb.InputAttributes["parent"] = ids[i].ToString();
  93.                 cb.InputAttributes["value"] = ids1[j].ToString();
  94.                 cb.InputAttributes["onclick"] = "check(" + ids1[j] + ")";
  95.                 cb.ID = "chk" + ids1[j].ToString();
  96.                 cb.Text = names1[j].ToString();
  97.                 td3.Controls.Add(cb);
  98.                 tr2.Cells.Add(td3);
  99.                 ArrayList ids2 = new ArrayList();
  100.                 ArrayList names2 = new ArrayList();
  101.                 cmd = new SqlCommand("select id, name from OA_SYS_CHILD_MENU where parent_id=" + ids1[j] + " and is_open='Y' order by name", conn);
  102.                 dr = cmd.ExecuteReader();
  103.                 while (dr.Read())
  104.                 {
  105.                     ids2.Add(dr["id"].ToString());
  106.                     names2.Add(dr["name"].ToString());
  107.                 }
  108.                 dr.Close();
  110.                 Table tb2 = new Table();
  111.                 TableCell td5 = new TableCell();
  112.                 td5.BorderWidth = Unit.Pixel(1);
  113.                 td5.Width = Unit.Pixel(500);
  114.                 for (int k = 0; k < ids2.Count; k++)
  115.                 {
  116.                     TableRow tr3 = new TableRow();
  118.                     TableCell td4 = new TableCell();
  119.                     td4.BorderWidth = Unit.Pixel(1);
  120.                     td4.Width = Unit.Pixel(220);
  121.                     tr3.HorizontalAlign = HorizontalAlign.Left;
  122.                     cb = new CheckBox();
  123.                     cb.InputAttributes["parent"] = ids1[j].ToString();
  124.                     cb.InputAttributes["value"] = ids2[k].ToString();
  125.                     cb.InputAttributes["onclick"] = "check(" + ids2[k] + ")";
  126.                     cb.ID = "chk" + ids2[k].ToString();
  127.                     cb.Text = names2[k].ToString();
  128.                     td4.Controls.Add(cb);
  129.                     tr3.Cells.Add(td4);
  130.                     tb2.Rows.Add(tr3);
  131.                     ArrayList ids3 = new ArrayList();
  132.                     ArrayList names3 = new ArrayList();
  133.                     cmd = new SqlCommand("select id, name from OA_SYS_CHILD_MENU where parent_id=" + ids2[k] + " and is_open='Y' order by name", conn);
  134.                     dr = cmd.ExecuteReader();
  135.                     while (dr.Read())
  136.                     {
  137.                         ids3.Add(dr["id"].ToString());
  138.                         names3.Add(dr["name"].ToString());
  139.                     }
  140.                     dr.Close();
  142.                     TableCell td6 = new TableCell();
  143.                     td6.VerticalAlign = VerticalAlign.Top;
  144.                     Table tb3 = new Table();
  145.                     for (int l = 0; l < ids3.Count; l++)
  146.                     {
  147.                         TableRow tr4 = new TableRow();
  149.                         TableCell td7 = new TableCell();
  150.                         td7.BorderWidth = Unit.Pixel(1);
  151.                         td7.Width = Unit.Pixel(280);
  152.                         td7.VerticalAlign = VerticalAlign.Top;
  153.                         tr3.HorizontalAlign = HorizontalAlign.Left;
  154.                         cb = new CheckBox();
  155.                         cb.InputAttributes["parent"] = ids2[k].ToString();
  156.                         cb.InputAttributes["value"] = ids3[l].ToString();
  157.                         cb.InputAttributes["onclick"] = "check(" + ids3[l] + ")";
  158.                         cb.ID = "chk" + ids3[l].ToString();
  159.                         cb.Text = names3[l].ToString();
  160.                         td7.Controls.Add(cb);
  161.                         tr4.Cells.Add(td7);
  162.                         tb3.Rows.Add(tr4);
  163.                     }
  164.                     td6.Controls.Add(tb3);
  165.                     tr3.Cells.Add(td6);
  166.                 }
  167.                 td5.Controls.Add(tb2);
  168.                 tr2.Cells.Add(td5);
  169.                 tb1.Rows.Add(tr2);
  170.             }
  171.             td2.Controls.Add(tb1);
  172.             tr1.Cells.Add(td2);
  174.             mainTable.Rows.Add(tr1);
  175.         }
  176.         mainTable.Rows.Add(new TableRow());
  177.         conn.Close();
  178.     }
  179.     protected void AddKmTable()
  180.     {
  181.         Table mainTable = new Table();
  182.         mainTable.ID = "TblKm";
  183.         mainTable.BorderWidth = Unit.Pixel(1);
  184.         mainTable.HorizontalAlign = HorizontalAlign.Center;
  185.         PnlKm.Controls.Add(mainTable);
  187.         SqlConnection conn = dbConnection.getConnection();
  188.         conn.Open();
  190.         ArrayList ids = new ArrayList();
  191.         ArrayList names = new ArrayList();
  193.         SqlCommand cmd = new SqlCommand("select id, name from OA_SYS_CHILD_MENU where parent_id=77 and is_open='Y'  order by name", conn);
  194.         SqlDataReader dr = cmd.ExecuteReader();
  195.         while (dr.Read())
  196.         {
  197.             ids.Add(dr["id"].ToString());
  198.             names.Add(dr["name"].ToString());
  199.         }
  200.         dr.Close();
  202.         for (int i = 0; i < ids.Count; i++)
  203.         {
  204.             TableRow tr1 = new TableRow();
  205.             tr1.BorderWidth = Unit.Pixel(1);
  207.             TableCell td1 = new TableCell();
  208.             td1.Width = Unit.Pixel(150);
  209.             tr1.HorizontalAlign = HorizontalAlign.Left;
  211.             CheckBox cb = new CheckBox();
  212.             cb.ID = "chk" + ids[i].ToString();
  213.             cb.Text = names[i].ToString();
  214.             cb.InputAttributes["parent"] = "1";
  215.             cb.InputAttributes["value"] = ids[i].ToString();
  216.             cb.InputAttributes["onclick"] = "check(" + ids[i] + ")";
  217.             td1.Controls.Add(cb);
  218.             tr1.Cells.Add(td1);
  219.             td1.BorderWidth = Unit.Pixel(1);
  221.             ArrayList ids1 = new ArrayList();
  222.             ArrayList names1 = new ArrayList();
  223.             cmd = new SqlCommand("select id, name from OA_SYS_CHILD_MENU where parent_id=" + ids[i] + " and is_open='Y' order by name", conn);
  224.             dr = cmd.ExecuteReader();
  225.             while (dr.Read())
  226.             {
  227.                 ids1.Add(dr["id"].ToString());
  228.                 names1.Add(dr["name"].ToString());
  229.             }
  230.             dr.Close();
  232.             Table tb1 = new Table();
  233.             TableCell td2 = new TableCell();
  234.             td2.BorderWidth = Unit.Pixel(1);
  235.             td2.Width = Unit.Pixel(750);
  236.             int max_dir = 0;
  237.             for (int j = 0; j < ids1.Count; j++)
  238.             {
  239.                 TableRow tr2 = new TableRow();
  241.                 TableCell td3 = new TableCell();
  242.                 td3.BorderWidth = Unit.Pixel(1);
  243.                 td3.Width = Unit.Pixel(200);
  244.                 tr2.HorizontalAlign = HorizontalAlign.Left;
  245.                 cb = new CheckBox();
  246.                 cb.InputAttributes["parent"] = ids[i].ToString();
  247.                 cb.InputAttributes["value"] = ids1[j].ToString();
  248.                 cb.InputAttributes["onclick"] = "check(" + ids1[j] + ")";
  249.                 cb.ID = "chk" + ids1[j].ToString();
  250.                 cb.Text = names1[j].ToString();
  251.                 td3.Controls.Add(cb);
  252.                 tr2.Cells.Add(td3);
  253.                 ArrayList ids2 = new ArrayList();
  254.                 ArrayList names2 = new ArrayList();
  255.                 cmd = new SqlCommand("select id, name from OA_SYS_CHILD_MENU where parent_id=" + ids1[j] + " and is_open='Y' order by name", conn);
  256.                 dr = cmd.ExecuteReader();
  257.                 while (dr.Read())
  258.                 {
  259.                     ids2.Add(dr["id"].ToString());
  260.                     names2.Add(dr["name"].ToString());
  261.                 }
  262.                 dr.Close();
  264.                 Table tb2 = new Table();
  265.                 TableCell td5 = new TableCell();
  266.                 td5.BorderWidth = Unit.Pixel(1);
  267.                 td5.Width = Unit.Pixel(500);
  268.                 if (!ids[i].Equals("16"))
  269.                 {
  270.                     for (int k = 0; k < ids2.Count; k++)
  271.                     {
  272.                         TableRow tr3 = new TableRow();
  274.                         TableCell td4 = new TableCell();
  275.                         td4.BorderWidth = Unit.Pixel(1);
  276.                         td4.Width = Unit.Pixel(220);
  277.                         tr3.HorizontalAlign = HorizontalAlign.Left;
  278.                         cb = new CheckBox();
  279.                         cb.InputAttributes["parent"] = ids1[j].ToString();
  280.                         cb.InputAttributes["value"] = ids2[k].ToString();
  281.                         cb.InputAttributes["onclick"] = "check(" + ids2[k] + ")";
  282.                         cb.ID = "chk" + ids2[k].ToString();
  283.                         cb.Text = names2[k].ToString();
  284.                         td4.Controls.Add(cb);
  285.                         tr3.Cells.Add(td4);
  286.                         tb2.Rows.Add(tr3);
  287.                         ArrayList ids3 = new ArrayList();
  288.                         ArrayList names3 = new ArrayList();
  289.                         cmd = new SqlCommand("select id, name from OA_SYS_CHILD_MENU where parent_id=" + ids2[k] + " and is_open='Y' order by name", conn);
  290.                         dr = cmd.ExecuteReader();
  291.                         while (dr.Read())
  292.                         {
  293.                             ids3.Add(dr["id"].ToString());
  294.                             names3.Add(dr["name"].ToString());
  295.                         }
  296.                         dr.Close();
  298.                         TableCell td6 = new TableCell();
  299.                         td6.VerticalAlign = VerticalAlign.Top;
  300.                         Table tb3 = new Table();
  301.                         for (int l = 0; l < ids3.Count; l++)
  302.                         {
  303.                             TableRow tr4 = new TableRow();
  305.                             TableCell td7 = new TableCell();
  306.                             td7.BorderWidth = Unit.Pixel(1);
  307.                             td7.Width = Unit.Pixel(280);
  308.                             td7.VerticalAlign = VerticalAlign.Top;
  309.                             tr3.HorizontalAlign = HorizontalAlign.Left;
  310.                             cb = new CheckBox();
  311.                             cb.InputAttributes["parent"] = ids2[k].ToString();
  312.                             cb.InputAttributes["value"] = ids3[l].ToString();
  313.                             cb.InputAttributes["onclick"] = "check(" + ids3[l] + ")";
  314.                             cb.ID = "chk" + ids3[l].ToString();
  315.                             cb.Text = names3[l].ToString();
  316.                             td7.Controls.Add(cb);
  317.                             tr4.Cells.Add(td7);
  318.                             tb3.Rows.Add(tr4);
  319.                         }
  320.                         td6.Controls.Add(tb3);
  321.                         tr3.Cells.Add(td6);
  322.                     }
  323.                 }
  324.                 else
  325.                 {
  326.                     if (Convert.ToInt32(ids1[j]) > max_dir)
  327.                     {
  328.                         max_dir = Convert.ToInt32(ids1[j]);
  329.                     }
  330.                     TableRow trDir = new TableRow();
  331.                     TableCell tdDir = new TableCell();
  332.                     tdDir.VerticalAlign = VerticalAlign.Top;
  334.                     RadioButtonList rb = new RadioButtonList();
  335.                     rb.ID = "rb" + ids1[j];
  336.                     rb.RepeatDirection = RepeatDirection.Horizontal;
  337.                     ListItem item = new ListItem();
  338.                     item.Selected = true;
  339.                     item.Value = "view" + ids1[j];
  340.                     item.Text = "瀏覽<br><br>";
  341.                     rb.Items.Add(item);
  342.                     item = new ListItem();
  343.                     item.Value = "edit" + ids1[j];
  344.                     item.Text = "編輯<br><br>";
  345.                     rb.Items.Add(item);
  347.                     tdDir.Controls.Add(rb);
  348.                     trDir.Cells.Add(tdDir);
  349.                     tb2.Rows.Add(trDir);
  350.                     MaxDir.Value = max_dir.ToString();
  351.                 }
  352.                 td5.Controls.Add(tb2);
  353.                 tr2.Cells.Add(td5);
  354.                 tb1.Rows.Add(tr2);
  355.             }
  356.             td2.Controls.Add(tb1);
  357.             tr1.Cells.Add(td2);
  359.             mainTable.Rows.Add(tr1);
  360.         }
  361.         mainTable.Rows.Add(new TableRow());
  362.         conn.Close();
  363.     }
  364.     protected void BtnOk_Click(object sender, EventArgs e)
  365.     {
  366.         SqlConnection conn = dbConnection.getConnection();
  367.         conn.Open();
  368.         SqlTransaction tx = conn.BeginTransaction();
  369.         try
  370.         {
  371.             SqlCommand cmd = new SqlCommand("select count(*) from OA_USER_GROUP_MAIN where name='" + TxtName.Text + "'", conn);
  372.             cmd.Transaction = tx;
  373.             int count = Convert.ToInt32(cmd.ExecuteScalar());
  375.             if (count == 0)
  376.             {
  377.                 int main_id = 1;
  378.                 cmd = new SqlCommand("select max(id) from OA_USER_GROUP_MAIN", conn);
  379.                 try
  380.                 {
  381.                     cmd.Transaction = tx;
  382.                     main_id = Convert.ToInt32(cmd.ExecuteScalar()) + 1;
  383.                 }
  384.                 catch { }
  386.                 DateMgr mgr = new DateMgr();
  387.                 string time = mgr.getDateTime();
  388.                 User user = new User();
  389.                 if (Session["user"] != null)
  390.                 {
  391.                     user = (User)Session["user"];
  392.                 }
  393.                 cmd = new SqlCommand("insert into OA_USER_GROUP_MAIN(id, name, department_id, cre_user, cre_date)" +
  394.                     "values(" + main_id + ",'" + TxtName.Text + "',0,'" + user.Emp_name + "','" + time + "')", conn);
  395.                 cmd.Transaction = tx;
  396.                 cmd.ExecuteNonQuery();
  398.                 string[] menus = Menus.Value.Split(new char[] { ',' });
  399.                 for (int i = 0; i < menus.Length; i++)
  400.                 {
  401.                     cmd = new SqlCommand("insert into OA_USER_GROUP_DETAIL(main_id, menu_id)" +
  402.                         "values(" + main_id + ", '" + menus[i] + "')", conn);
  403.                     cmd.Transaction = tx;
  404.                     cmd.ExecuteNonQuery();
  405.                 }
  407.                 //添加規章制度瀏覽權限設定
  408.                 string[] dir_edit = DirEdit.Value.Split(new char[] { ';' });
  409.                 for (int i = 0; i < dir_edit.Length-1; i++)
  410.                 {
  411.                     cmd = new SqlCommand("update OA_USER_GROUP_DETAIL set function_id='edit' where menu_id=" + dir_edit[i]+" and main_id="+main_id, conn);
  412.                     cmd.Transaction = tx;
  413.                     cmd.ExecuteNonQuery();
  414.                 }
  416.                 tx.Commit();
  417.             }
  418.             else
  419.             {
  420.                 this.AddOaTable();
  421.                 this.AddKmTable();
  422.                 TxtName.Focus();
  423.                 Response.Write("<script language='javascript'>alert('已存在相同名稱的權限群組, 請重新輸入');</script>");
  424.             }
  425.         }
  426.         catch (Exception ex)
  427.         {
  428.             tx.Rollback();        
  429.             Response.Write(ex.Message);
  430.         }
  431.         Response.Redirect("authority_list.aspx");
  432.         conn.Close();
  433.     }
  434. }