Employee_Group.cs 6.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data;
  4. using System.Windows.Forms;
  5. using UAS_MES.CustomControl.AccordionMenu;
  6. using UAS_MES.CustomControl.DataGrid_View;
  7. using UAS_MES.DataOperate;
  8. using UAS_MES.Entity;
  9. using UAS_MES.PublicMethod;
  10. namespace UAS_MES.Employee
  11. {
  12. public partial class Employee_Group : Form
  13. {
  14. DataHelper dh;
  15. DataTable dt;
  16. AutoSizeFormClass asc = new AutoSizeFormClass();
  17. public Employee_Group()
  18. {
  19. InitializeComponent();
  20. }
  21. private void 人员分组_Load(object sender, EventArgs e)
  22. {
  23. dh = new DataHelper();
  24. //手动加入第一列全选列
  25. DataGridViewCheckBoxColumn dgvc = new DataGridViewCheckBoxColumn();
  26. dgvc.AutoSizeMode = DataGridViewAutoSizeColumnMode.None;
  27. dgvc.Width = 90;
  28. dgvc.Name = "全选";
  29. DataGridViewCheckBoxHeaderCell ch1 = new DataGridViewCheckBoxHeaderCell(UserGroupDGV, dgvc);
  30. dgvc.HeaderCell = ch1;
  31. this.UserGroupDGV.Columns.Insert(0, dgvc);
  32. ug_code1.FormName = Name;
  33. ug_code1.TableName = "CS$USERGROUP";
  34. ug_code1.SelectField = "ug_code # 分组编号,ug_name # 分组名称,ug_inman # 录入人,ug_indate #录入日期";
  35. ug_code1.SetValueField = new string[] { "ug_code1" };
  36. ug_name1.FormName = Name;
  37. ug_name1.TableName = "CS$USERGROUP";
  38. ug_name1.SelectField = "ug_code # 分组编号,ug_name # 分组名称,ug_inman # 录入人,ug_indate #录入日期";
  39. ug_name1.SetValueField = new string[] { "ug_name1" };
  40. ug_code1.KeyDown += KeyDownEvent;
  41. ug_name1.KeyDown += KeyDownEvent;
  42. //asc.controllInitializeSize(this);
  43. }
  44. private void 人员分组_SizeChanged(object sender, EventArgs e)
  45. {
  46. //asc.controlAutoSize(this);
  47. }
  48. private void Screen_Click(object sender, EventArgs e)
  49. {
  50. dt = (DataTable)dh.ExecuteSql("select ug_code,ug_id,ug_name,'查看组内成员' UserSetting,'权限分配' PowerSetting from cs$usergroup " + BaseUtil.GetScreenSqlCondition(ug_code1, ug_name1) + " order by ug_code", "select");
  51. BaseUtil.FillDgvWithDataTable(UserGroupDGV, dt);
  52. }
  53. private void DeleteGroup_Click(object sender, EventArgs e)
  54. {
  55. string ConfirmDelete = MessageBox.Show(this.ParentForm, "删除分组会一并删除组员和权限,确认删除?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question).ToString();
  56. if (ConfirmDelete == "Yes")
  57. {
  58. //UserGroup的ID
  59. List<string> DeleteID = new List<string>();
  60. //分组编号
  61. List<string> DeleteCode = new List<string>();
  62. for (int i = 0; i < UserGroupDGV.Rows.Count; i++)
  63. {
  64. if (UserGroupDGV.Rows[i].Cells["全选"].FormattedValue.ToString() == "True")
  65. {
  66. DeleteID.Add(UserGroupDGV.Rows[i].Cells["ug_id"].Value.ToString());
  67. DeleteCode.Add(UserGroupDGV.Rows[i].Cells["ug_code"].Value.ToString());
  68. }
  69. }
  70. dh.BatchInsert("delete from cs$usergroup where ug_id=:ug_id", new string[] { "ug_id" }, DeleteID.ToArray());
  71. dh.BatchInsert("delete from cs$empgroup where eg_groupcode=:ug_code", new string[] { "ug_code" }, DeleteCode.ToArray());
  72. dh.BatchInsert("delete from cs$usergrouppower where ugp_groupcode=:ug_code", new string[] { "ug_code" }, DeleteCode.ToArray());
  73. MessageBox.Show("删除分组成功");
  74. Screen.PerformClick();
  75. }
  76. }
  77. private void NewGroup_Click(object sender, EventArgs e)
  78. {
  79. Employee_NewGroup NewWin = new Employee_NewGroup();
  80. BaseUtil.SetFormCenter(NewWin);
  81. NewWin.FormClosed += Screen_Click;
  82. NewWin.ShowDialog();
  83. }
  84. private void UserGroupDGV_CellClick(object sender, DataGridViewCellEventArgs e)
  85. {
  86. if (e.RowIndex >= 0 && e.ColumnIndex >= 0)
  87. {
  88. string CallerUser = "Employee!DataGroup";
  89. string CallerPower = "Employee!PowerGroup";
  90. if (UserGroupDGV.Columns[e.ColumnIndex].Name == "UserSetting" && !AccordionMenu.OpenedFormName.ContainsKey(CallerUser))
  91. {
  92. AccordionMenu.OpenedFormName.Add(CallerUser, 101);
  93. TabControl tc = (TabControl)this.Parent.Parent;
  94. TabPage tb = new TabPage { Name = CallerUser, Tag = CallerUser, Text = "人员查看" };
  95. tc.TabPages.Add(tb);
  96. string ug_code = UserGroupDGV.Rows[e.RowIndex].Cells["ug_code"].Value.ToString();
  97. string ug_name = UserGroupDGV.Rows[e.RowIndex].Cells["ug_name"].Value.ToString();
  98. Employee_ChooseUserToGroup NewUser = new Employee_ChooseUserToGroup(ug_code, ug_name);
  99. NewUser.TopLevel = false;
  100. tc.SelectedTab = tb;
  101. tb.Controls.Add(NewUser);
  102. NewUser.WindowState = FormWindowState.Maximized;
  103. NewUser.Show();
  104. }
  105. else if (UserGroupDGV.Columns[e.ColumnIndex].Name == "PowerSetting" && !AccordionMenu.OpenedFormName.ContainsKey(CallerPower))
  106. {
  107. AccordionMenu.OpenedFormName.Add(CallerPower, 101);
  108. TabControl tc = (TabControl)this.Parent.Parent;
  109. //如果窗体不存在进行打开
  110. TabPage tb = new TabPage { Tag = CallerPower, Name = CallerPower, Text = "权限控制" };
  111. tc.TabPages.Add(tb);
  112. string ug_code = UserGroupDGV.Rows[e.RowIndex].Cells["ug_code"].Value.ToString();
  113. string ug_name = UserGroupDGV.Rows[e.RowIndex].Cells["ug_name"].Value.ToString();
  114. Employee_Power NewPower = new Employee_Power(ug_code, ug_name);
  115. NewPower.TopLevel = false;
  116. tc.SelectedTab = tb;
  117. tb.Controls.Add(NewPower);
  118. NewPower.WindowState = FormWindowState.Maximized;
  119. NewPower.Show();
  120. }
  121. }
  122. }
  123. private void KeyDownEvent(object sender, KeyEventArgs e)
  124. {
  125. if (e.KeyCode == Keys.Enter)
  126. {
  127. Screen.PerformClick();
  128. }
  129. }
  130. }
  131. }