Bez popisu
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

系統使用者管理.vb 65KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693
  1. Option Explicit On
  2. Imports System.IO
  3. Public Class 系統使用者管理
  4. Dim 資料長度, 資料寬度, BBNN1, FG As Integer
  5. Dim 權限代號, QQW(11), 權限名稱, HH As String
  6. Dim 權限選取 As Boolean = False
  7. Dim xlApp As Microsoft.Office.Interop.Excel.Application
  8. Dim xlSheet As Microsoft.Office.Interop.Excel.Worksheet
  9. Dim file_name As String = ""
  10. Dim RI As Integer = -1
  11. Dim SK As String = "要查找的 KEY"
  12. Dim Str As String = Application.StartupPath
  13. DIM 對話框(36) As String
  14. Private Sub Set_權限清單()
  15. Dim ds1 As New DataSet
  16. 預設權限_dgv.DataSource = Nothing : ds1.Clear()
  17. 預設權限_dgv.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing
  18. 預設權限_dgv.ColumnHeadersHeight = 25 : 預設權限_dgv.AllowUserToAddRows = False : 預設權限_dgv.RowTemplate.Height = 35
  19. PA40 = 職稱_cb.Text : SQL_系統權限預設表_單一讀取()
  20. da.Fill(ds1) : 預設權限_dgv.DataSource = ds1.Tables(0) : conn.Close()
  21. End Sub
  22. Private Sub Set_使用者清單()
  23. Dim ds, ds1 As New DataSet
  24. 清單_dgv.DataSource = Nothing : ds.Clear() : ds1.Clear()
  25. 清單_dgv.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing
  26. 清單_dgv.ColumnHeadersHeight = 25 : 清單_dgv.AllowUserToAddRows = False : 清單_dgv.RowTemplate.Height = 35
  27. 清單1_dgv.DataSource = Nothing
  28. 清單1_dgv.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing
  29. 清單1_dgv.ColumnHeadersHeight = 25 : 清單1_dgv.AllowUserToAddRows = False : 清單1_dgv.RowTemplate.Height = 35
  30. If 小間距1_ch.Checked = False And 中間距1_ch.Checked = False And 大間距1_ch.Checked = True Then : 清單1_dgv.RowTemplate.Height = 75
  31. ElseIf 小間距1_ch.Checked = False And 中間距1_ch.Checked = True And 大間距1_ch.Checked = False Then : 清單1_dgv.RowTemplate.Height = 45
  32. ElseIf 小間距1_ch.Checked = True And 中間距1_ch.Checked = False And 大間距1_ch.Checked = False Then : 清單1_dgv.RowTemplate.Height = 25 : End If
  33. SQL_系統使用者管理_使用者清單()
  34. da.Fill(ds) : 清單_dgv.DataSource = ds.Tables(0) : da.Fill(ds1) : 清單1_dgv.DataSource = ds1.Tables(0) : conn.Close() : Set_grid()
  35. If 系統語言 = "繁體中文" Then : 清單1_dgv.Columns(6).Visible = True : Else : 清單1_dgv.Columns(6).Visible = False : End If
  36. For i As Integer = 0 To 清單1_dgv.Rows.Count - 1
  37. Dim 驗證 As String = "" : Dim 取變數 As String
  38. 取變數 = 清單1_dgv.Rows(i).Cells(3).Value.ToString : NN1 = 0
  39. For ii As Integer = 1 To 20
  40. If ii = 1 Then : 驗證 = Strings.Left(取變數, ii) : NN1 += 1 : Else
  41. If Strings.Mid(取變數, ii, 1) = " " Then : Exit For : Else : 驗證 &= Strings.Mid(取變數, ii, 1) : NN1 += 1 : End If
  42. End If
  43. Next
  44. If 系統語言 = "繁體中文" Then : 清單1_dgv.Rows(i).Cells(3).Value = 驗證 : Else
  45. If Strings.Left(清單1_dgv.Rows(i).Cells(3).Value.ToString, 2) = "0." Then : 清單1_dgv.Rows(i).Cells(3).Value = "0.NA" : Else
  46. 清單1_dgv.Rows(i).Cells(3).Value = Strings.Left(清單1_dgv.Rows(i).Cells(3).Value.ToString, 2) & Strings.Mid(清單1_dgv.Rows(i).Cells(3).Value.ToString, NN1 + 2, 100)
  47. End If
  48. End If
  49. 取變數 = 清單1_dgv.Rows(i).Cells(4).Value.ToString : NN1 = 0
  50. For ii As Integer = 1 To 20
  51. If ii = 1 Then : 驗證 = Strings.Left(取變數, ii) : NN1 += 1 : Else
  52. If Strings.Mid(取變數, ii, 1) = " " Then : Exit For : Else : 驗證 &= Strings.Mid(取變數, ii, 1) : NN1 += 1 : End If
  53. End If
  54. Next
  55. If 系統語言 = "繁體中文" Then : 清單1_dgv.Rows(i).Cells(4).Value = 驗證 : Else
  56. If Strings.Left(清單1_dgv.Rows(i).Cells(4).Value.ToString, 3) = "00." Then : 清單1_dgv.Rows(i).Cells(4).Value = "00.NA" : Else
  57. 清單1_dgv.Rows(i).Cells(4).Value = Strings.Left(清單1_dgv.Rows(i).Cells(4).Value.ToString, 3) & Strings.Mid(清單1_dgv.Rows(i).Cells(4).Value.ToString, NN1 + 2, 100)
  58. End If
  59. End If
  60. 取變數 = 清單1_dgv.Rows(i).Cells(5).Value.ToString : NN1 = 0
  61. For ii As Integer = 1 To 20
  62. If ii = 1 Then : 驗證 = Strings.Left(取變數, ii) : NN1 += 1 : Else
  63. If Strings.Mid(取變數, ii, 1) = " " Then : Exit For : Else : 驗證 &= Strings.Mid(取變數, ii, 1) : NN1 += 1 : End If
  64. End If
  65. Next
  66. If 系統語言 = "繁體中文" Then : 清單1_dgv.Rows(i).Cells(5).Value = 驗證 : Else
  67. If Strings.Left(清單1_dgv.Rows(i).Cells(5).Value.ToString, 4) = "000." Then : 清單1_dgv.Rows(i).Cells(5).Value = "000.NA" : Else
  68. 清單1_dgv.Rows(i).Cells(5).Value = Strings.Left(清單1_dgv.Rows(i).Cells(5).Value.ToString, 4) & Strings.Mid(清單1_dgv.Rows(i).Cells(5).Value.ToString, NN1 + 2, 100)
  69. End If
  70. End If
  71. 取變數 = 清單1_dgv.Rows(i).Cells(7).Value.ToString : NN1 = 0
  72. For ii As Integer = 1 To 20
  73. If ii = 1 Then : 驗證 = Strings.Left(取變數, ii) : NN1 += 1 : Else
  74. If Strings.Mid(取變數, ii, 1) = "/" Then : Exit For : Else : 驗證 &= Strings.Mid(取變數, ii, 1) : NN1 += 1 : End If
  75. End If
  76. Next
  77. If 系統語言 = "繁體中文" Then : 清單1_dgv.Rows(i).Cells(7).Value = 驗證 : Else
  78. If Strings.Left(清單1_dgv.Rows(i).Cells(7).Value.ToString, 6) = "00000." Then : 清單1_dgv.Rows(i).Cells(7).Value = "00000.NA" : Else
  79. 清單1_dgv.Rows(i).Cells(7).Value = Strings.Left(清單1_dgv.Rows(i).Cells(7).Value.ToString, 6) & Strings.Mid(清單1_dgv.Rows(i).Cells(7).Value.ToString, NN1 + 2, 100)
  80. End If
  81. End If
  82. Next
  83. End Sub
  84. Private Sub Set_grid()
  85. 清單1_dgv.Columns(0).FillWeight = 90 : 清單1_dgv.Columns(1).Visible = False : 清單1_dgv.Columns(2).Visible = False : 清單1_dgv.Columns(3).FillWeight = 70
  86. 清單1_dgv.Columns(4).FillWeight = 80 : 清單1_dgv.Columns(5).FillWeight = 80 : 清單1_dgv.Columns(6).FillWeight = 50 : 清單1_dgv.Columns(7).FillWeight = 90
  87. 清單1_dgv.Columns(8).Visible = False : 清單1_dgv.Columns(9).FillWeight = 25 : 清單1_dgv.Columns(10).FillWeight = 55 : 清單1_dgv.Columns(11).FillWeight = 35
  88. For i As Integer = 0 To 權限數量 - 1
  89. 清單1_dgv.Columns(i + 12).Visible = False
  90. Next
  91. If 顯示密碼_bt.Enabled = True And 隱藏密碼_bt.Enabled = False Then
  92. For i As Integer = 0 To 清單1_dgv.Rows.Count - 1
  93. 清單_dgv(2, i).Value = "**********"
  94. Next
  95. End If
  96. For i As Integer = 0 To 清單1_dgv.Rows.Count - 1
  97. If 深色風格 = False Then
  98. If 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "01" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.LightGoldenrodYellow
  99. ElseIf 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "02" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.LightGreen
  100. ElseIf 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "03" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.LightPink
  101. ElseIf 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "04" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.LightBlue
  102. ElseIf 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "05" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.LightBlue : End If
  103. Else
  104. If 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "01" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.Purple
  105. ElseIf 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "02" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.DarkGreen
  106. ElseIf 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "03" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.DarkRed
  107. ElseIf 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "04" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.DarkBlue
  108. ElseIf 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "05" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.DarkBlue : End If
  109. End If
  110. Next
  111. If 登入人級別 = "00" Then : 清單1_dgv.Columns("CC63").Visible = True : 清單1_dgv.Columns("CC63").FillWeight = 10 : End If
  112. End Sub
  113. Private Sub Set_格式設定()
  114. 隱藏密碼_bt.Enabled = False
  115. For no As Integer = 1 To 權限數量
  116. Dim 選擇 As CheckBox = CType(Me.Controls.Find("CheckBox" + no.ToString(), True)(0), CheckBox)
  117. 選擇.Checked = False
  118. Next
  119. End Sub
  120. Private Sub Set_格式設定1()
  121. For no As Integer = 0 To LINE_權限數量 - 1
  122. HH = no + 200
  123. Dim 選擇 As CheckBox = CType(Me.Controls.Find("CheckBox" + HH.ToString(), True)(0), CheckBox)
  124. 選擇.Checked = False
  125. Next
  126. End Sub
  127. Private Sub 下拉清單_職稱()
  128. PA47 = 部門_cb.Text : PA48 = 處別_cb.Text : SQL_系統使用者管理_下拉清單_職稱()
  129. 級別_cb.Items.Clear() : 職稱_cb.Items.Clear() : 職稱1_cb.Items.Clear()
  130. While (dr.Read()) : 職稱_cb.Items.Add(dr("職稱")) : 級別_cb.Items.Add(dr("級別"))
  131. Dim 驗證 As String = "" : Dim 取變數 As String : NN1 = 0
  132. 取變數 = dr("職稱")
  133. For ii As Integer = 1 To 20
  134. If ii = 1 Then : 驗證 = Strings.Left(取變數, ii) : NN1 += 1 : Else
  135. If Strings.Mid(取變數, ii, 1) = "/" Then : Exit For : Else : 驗證 &= Strings.Mid(取變數, ii, 1) : NN1 += 1 : End If
  136. End If
  137. Next
  138. If 系統語言 = "繁體中文" Then : 職稱1_cb.Items.Add(驗證) : Else
  139. 驗證 = Strings.Left(dr("職稱"), 6) & Strings.Mid(dr("職稱"), NN1 + 2, 100)
  140. If 驗證 = "00000." Then : 職稱1_cb.Items.Add("00000.NA") : Else : 職稱1_cb.Items.Add(驗證) : End If
  141. End If
  142. End While : conn.Close()
  143. End Sub
  144. Private Sub ComboBox1下拉表單資料載入()
  145. SQL_系統使用者管理_下拉清單_部門() : 部門_cb.Items.Clear() : 部門_cb.Items.Add("") : 部門1_cb.Items.Clear() : 部門1_cb.Items.Add("")
  146. While (dr.Read()) : 部門_cb.Items.Add(dr("部門"))
  147. Dim 驗證 As String = "" : Dim 取變數 As String : NN1 = 0
  148. 取變數 = dr("部門")
  149. For ii As Integer = 1 To 20
  150. If ii = 1 Then : 驗證 = Strings.Left(取變數, ii) : NN1 += 1 : Else
  151. If Strings.Mid(取變數, ii, 1) = " " Then : Exit For : Else : 驗證 &= Strings.Mid(取變數, ii, 1) : NN1 += 1 : End If
  152. End If
  153. Next
  154. If 系統語言 = "繁體中文" Then : 部門1_cb.Items.Add(驗證) : Else
  155. 驗證 = Strings.Left(dr("部門"), 2) & Strings.Mid(dr("部門"), NN1 + 2, 100)
  156. If 驗證 = "0." Then : 部門1_cb.Items.Add("0.NA") : Else : 部門1_cb.Items.Add(驗證) : End If
  157. End If
  158. End While : conn.Close()
  159. End Sub
  160. Private Sub ComboBox5下拉表單資料載入()
  161. PA20 = Strings.Left(部門_cb.Text, 1) : SQL_系統使用者管理_下拉清單_處別()
  162. 處別_cb.Items.Clear() : 處別_cb.Items.Add("") : 處別1_cb.Items.Clear() : 處別1_cb.Items.Add("")
  163. While (dr.Read()) : 處別_cb.Items.Add(dr("處"))
  164. Dim 驗證 As String = "" : Dim 取變數 As String : NN1 = 0
  165. 取變數 = dr("處")
  166. For ii As Integer = 1 To 20
  167. If ii = 1 Then : 驗證 = Strings.Left(取變數, ii) : NN1 += 1 : Else
  168. If Strings.Mid(取變數, ii, 1) = " " Then : Exit For : Else : 驗證 &= Strings.Mid(取變數, ii, 1) : NN1 += 1 : End If
  169. End If
  170. Next
  171. If 系統語言 = "繁體中文" Then : 處別1_cb.Items.Add(驗證) : Else
  172. 驗證 = Strings.Left(dr("處"), 3) & Strings.Mid(dr("處"), NN1 + 2, 100)
  173. If 驗證 = "00." Then : 處別1_cb.Items.Add("00.NA") : Else : 處別1_cb.Items.Add(驗證) : End If
  174. End If
  175. End While : conn.Close()
  176. End Sub
  177. Private Sub ComboBox3下拉表單資料載入()
  178. PA20 = Strings.Left(處別_cb.Text, 2) : SQL_系統使用者管理_下拉清單_課別()
  179. 課別_cb.Items.Clear() : 課別_cb.Items.Add("") : 課別1_cb.Items.Clear() : 課別1_cb.Items.Add("")
  180. While (dr.Read()) : 課別_cb.Items.Add(dr("課別"))
  181. Dim 驗證 As String = "" : Dim 取變數 As String : NN1 = 0
  182. 取變數 = dr("課別")
  183. For ii As Integer = 1 To 20
  184. If ii = 1 Then : 驗證 = Strings.Left(取變數, ii) : NN1 += 1 : Else
  185. If Strings.Mid(取變數, ii, 1) = " " Then : Exit For : Else : 驗證 &= Strings.Mid(取變數, ii, 1) : NN1 += 1 : End If
  186. End If
  187. Next
  188. If 系統語言 = "繁體中文" Then : 課別1_cb.Items.Add(驗證) : Else
  189. 驗證 = Strings.Left(dr("課別"), 4) & Strings.Mid(dr("課別"), NN1 + 2, 100)
  190. If 驗證 = "000." Then : 課別1_cb.Items.Add("000.NA") : Else : 課別1_cb.Items.Add(驗證) : End If
  191. End If
  192. End While : conn.Close()
  193. End Sub
  194. Private Sub ComboBox4下拉表單資料載入()
  195. PA20 = Strings.Left(課別_cb.Text, 3) : SQL_系統使用者管理_下拉清單_組別()
  196. 組別_cb.Items.Clear() : 組別_cb.Items.Add("") : 組別1_cb.Items.Clear() : 組別1_cb.Items.Add("")
  197. While (dr.Read()) : 組別_cb.Items.Add(dr("組別"))
  198. If 系統語言 = "繁體中文" Then
  199. 組別1_cb.Items.Add(dr("組別"))
  200. Else
  201. If Strings.Mid(dr("組別").ToString, 6, 2) = "工務" Then : 組別1_cb.Items.Add(Strings.Left(dr("組別").ToString, 5) & 對話框(20))
  202. ElseIf Strings.Mid(dr("組別").ToString, 6, 2) = "製圖" Then : 組別1_cb.Items.Add(Strings.Left(dr("組別").ToString, 5) & 對話框(21))
  203. ElseIf Strings.Mid(dr("組別").ToString, 6, 2) = "銷售" Then : 組別1_cb.Items.Add(Strings.Left(dr("組別").ToString, 5) & 對話框(22))
  204. ElseIf Strings.Mid(dr("組別").ToString, 6, 2) = "會計" Then : 組別1_cb.Items.Add(Strings.Left(dr("組別").ToString, 5) & 對話框(23))
  205. ElseIf Strings.Mid(dr("組別").ToString, 6, 2) = "稅務" Then : 組別1_cb.Items.Add(Strings.Left(dr("組別").ToString, 5) & 對話框(24))
  206. ElseIf Strings.Mid(dr("組別").ToString, 6, 2) = "財務" Then : 組別1_cb.Items.Add(Strings.Left(dr("組別").ToString, 5) & 對話框(25))
  207. ElseIf Strings.Mid(dr("組別").ToString, 6, 2) = "總務" Then : 組別1_cb.Items.Add(Strings.Left(dr("組別").ToString, 5) & 對話框(26))
  208. ElseIf Strings.Mid(dr("組別").ToString, 6, 2) = "倉管" Then : 組別1_cb.Items.Add(Strings.Left(dr("組別").ToString, 5) & 對話框(27))
  209. ElseIf Strings.Mid(dr("組別").ToString, 6, 2) = "資安" Then : 組別1_cb.Items.Add(Strings.Left(dr("組別").ToString, 5) & 對話框(28))
  210. ElseIf Strings.Mid(dr("組別").ToString, 6, 2) = "文管" Then : 組別1_cb.Items.Add(Strings.Left(dr("組別").ToString, 5) & 對話框(29))
  211. ElseIf Strings.Mid(dr("組別").ToString, 6, 2) = "人資" Then : 組別1_cb.Items.Add(Strings.Left(dr("組別").ToString, 5) & 對話框(30))
  212. ElseIf Strings.Mid(dr("組別").ToString, 6, 2) = "實習" Then : 組別1_cb.Items.Add(Strings.Left(dr("組別").ToString, 5) & 對話框(31))
  213. ElseIf Strings.Mid(dr("組別").ToString, 6, 2) = "管理" Then : 組別1_cb.Items.Add(Strings.Left(dr("組別").ToString, 5) & 對話框(32))
  214. ElseIf Strings.Mid(dr("組別").ToString, 6, 2) = "採購" Then : 組別1_cb.Items.Add(Strings.Left(dr("組別").ToString, 5) & 對話框(33))
  215. ElseIf Strings.Mid(dr("組別").ToString, 6, 2) = "出納" Then : 組別1_cb.Items.Add(Strings.Left(dr("組別").ToString, 5) & 對話框(34))
  216. ElseIf Strings.Mid(dr("組別").ToString, 6, 2) = "報價" Then : 組別1_cb.Items.Add(Strings.Left(dr("組別").ToString, 5) & 對話框(35))
  217. Else : 組別1_cb.Items.Add(dr("組別"))
  218. End If
  219. End If
  220. End While : conn.Close()
  221. End Sub
  222. Private Sub 語言轉換讀取()
  223. If 系統語言 = "繁體中文" Then : 語言 = "CH" : ElseIf 系統語言 = "English" Then : 語言 = "EN" : ElseIf 系統語言 = "Indonesian" Then : 語言 = "IN" : End If
  224. Me.Text = 系統語言字典("H001-146-" & 語言)
  225. ToolTip1.ToolTipTitle = 系統語言字典("G000-108-" & 語言) : 對話框(0) = 系統語言字典("G000-109-" & 語言) : 工人_ch.Text = 系統語言字典("G000-159-" & 語言)
  226. 姓名_lb.Text = 系統語言字典("H002-103-" & 語言) : 帳號_lb.Text = 系統語言字典("H002-104-" & 語言) : 密碼_lb.Text = 系統語言字典("H002-105-" & 語言)
  227. NAS帳號_lb.Text = 系統語言字典("H002-106-" & 語言) : NAS密碼_lb.Text = 系統語言字典("H002-107-" & 語言) : 部門_lb.Text = 系統語言字典("H002-108-" & 語言)
  228. 處別_lb.Text = 系統語言字典("H002-109-" & 語言) : 課別_lb.Text = 系統語言字典("H002-110-" & 語言) : 組別_lb.Text = 系統語言字典("H002-111-" & 語言)
  229. 職稱_lb.Text = 系統語言字典("H002-112-" & 語言) : CheckBox63.Text = 系統語言字典("H002-116-" & 語言)
  230. 對話框(1) = 系統語言字典("G000-110-" & 語言) : 對話框(2) = 系統語言字典("G000-111-" & 語言) : 對話框(3) = 系統語言字典("G000-112-" & 語言) : 對話框(4) = 系統語言字典("H002-100-" & 語言)
  231. 對話框(5) = 系統語言字典("H002-101-" & 語言) : 對話框(6) = 系統語言字典("G000-113-" & 語言) : 對話框(7) = 系統語言字典("G000-114-" & 語言) : 對話框(8) = 系統語言字典("H000-102-" & 語言)
  232. 對話框(9) = 系統語言字典("G000-118-" & 語言) : 對話框(10) = 系統語言字典("G000-121-" & 語言) : 對話框(11) = 系統語言字典("G000-126-" & 語言) : 對話框(12) = 系統語言字典("H002-113-" & 語言)
  233. 對話框(13) = 系統語言字典("G000-127-" & 語言) : 對話框(14) = 系統語言字典("G000-120-" & 語言) : 對話框(15) = 系統語言字典("G000-124-" & 語言) : 對話框(16) = 系統語言字典("G000-119-" & 語言)
  234. 對話框(17) = 系統語言字典("G000-117-" & 語言) : 對話框(18) = 系統語言字典("H002-114-" & 語言) : 對話框(19) = 系統語言字典("G000-259-" & 語言) : 對話框(20) = 系統語言字典("G000-128-" & 語言)
  235. 對話框(21) = 系統語言字典("G000-129-" & 語言) : 對話框(22) = 系統語言字典("G000-130-" & 語言) : 對話框(23) = 系統語言字典("G000-131-" & 語言) : 對話框(24) = 系統語言字典("G000-132-" & 語言)
  236. 對話框(25) = 系統語言字典("G000-133-" & 語言) : 對話框(26) = 系統語言字典("G000-134-" & 語言) : 對話框(27) = 系統語言字典("G000-135-" & 語言) : 對話框(28) = 系統語言字典("G000-136-" & 語言)
  237. 對話框(29) = 系統語言字典("G000-137-" & 語言) : 對話框(30) = 系統語言字典("G000-138-" & 語言) : 對話框(31) = 系統語言字典("G000-139-" & 語言) : 對話框(32) = 系統語言字典("G000-140-" & 語言)
  238. 對話框(33) = 系統語言字典("G000-141-" & 語言) : 對話框(34) = 系統語言字典("G000-142-" & 語言) : 對話框(35) = 系統語言字典("G000-143-" & 語言) : 對話框(36) = 系統語言字典("H002-117-" & 語言)
  239. '------------------------業務管理系統-------------------------------------------------------------------------------------------------------------------------------------------------
  240. 業務權限_tp.Text = 系統語言字典("H001-204-" & 語言) : CheckBox5.Text = 系統語言字典("H001-204-" & 語言) & "-005" : CheckBox60.Text = 系統語言字典("H001-121-" & 語言) & "-060"
  241. CheckBox116.Text = 系統語言字典("H001-124-" & 語言) & "-116" : CheckBox107.Text = 系統語言字典("H001-125-" & 語言) & "-107" : CheckBox98.Text = 系統語言字典("H001-128-" & 語言) & "-098"
  242. CheckBox123.Text = 系統語言字典("H001-130-" & 語言) & "-123" : CheckBox124.Text = 系統語言字典("H001-131-" & 語言) & "-124" : CheckBox125.Text = 系統語言字典("H001-132-" & 語言) & "-125"
  243. CheckBox126.Text = 系統語言字典("H001-133-" & 語言) & "-126" : CheckBox127.Text = 系統語言字典("H001-122-" & 語言) & "-127" : CheckBox61.Text = 系統語言字典("H001-119-" & 語言) & "-061"
  244. CheckBox128.Text = 系統語言字典("H001-126-" & 語言) & "-128" : CheckBox62.Text = 系統語言字典("H001-120-" & 語言) & "-062" : CheckBox52.Text = 系統語言字典("H001-109-" & 語言) & "-052"
  245. CheckBox114.Text = 系統語言字典("H001-103-" & 語言) & "-114" : CheckBox99.Text = 系統語言字典("H001-165-" & 語言) & "-099" : CheckBox101.Text = 系統語言字典("H001-260-" & 語言) & "-101"
  246. CheckBox102.Text = 系統語言字典("H001-261-" & 語言) & "-102" : CheckBox103.Text = 系統語言字典("H001-262-" & 語言) & "-103"
  247. '------------------------採購管理系統-------------------------------------------------------------------------------------------------------------------------------------------------
  248. 採購權限_tp.Text = 系統語言字典("H001-189-" & 語言) : CheckBox6.Text = 系統語言字典("H001-189-" & 語言) & "-006" : CheckBox33.Text = 系統語言字典("H001-174-" & 語言) & "-033"
  249. CheckBox34.Text = 系統語言字典("H001-175-" & 語言) & "-034" : CheckBox35.Text = 系統語言字典("H001-173-" & 語言) & "-035" : CheckBox20.Text = 系統語言字典("H001-190-" & 語言) & "-020"
  250. CheckBox36.Text = 系統語言字典("H001-171-" & 語言) & "-036" : CheckBox73.Text = 系統語言字典("H001-168-" & 語言) & "-073" : CheckBox37.Text = 系統語言字典("H001-170-" & 語言) & "-037"
  251. CheckBox38.Text = 系統語言字典("H001-169-" & 語言) & "-038" : CheckBox39.Text = 系統語言字典("H001-166-" & 語言) & "-039" : CheckBox25.Text = 系統語言字典("H001-143-" & 語言) & "-025"
  252. CheckBox26.Text = 系統語言字典("H001-144-" & 語言) & "-026" : CheckBox27.Text = 系統語言字典("H001-142-" & 語言) & "-027" : CheckBox28.Text = 系統語言字典("H001-140-" & 語言) & "-028"
  253. CheckBox72.Text = 系統語言字典("H001-137-" & 語言) & "-072" : CheckBox29.Text = 系統語言字典("H001-139-" & 語言) & "-029" : CheckBox30.Text = 系統語言字典("H001-138-" & 語言) & "-030"
  254. CheckBox31.Text = 系統語言字典("H001-136-" & 語言) & "-031" : CheckBox11.Text = 系統語言字典("H001-167-" & 語言) & "-011" : CheckBox42.Text = 系統語言字典("H001-135-" & 語言) & "-042"
  255. CheckBox51.Text = 系統語言字典("H001-160-" & 語言) & "-051" : CheckBox12.Text = 系統語言字典("H001-263-" & 語言) & "-012" : CheckBox13.Text = 系統語言字典("H001-264-" & 語言) & "-013"
  256. CheckBox14.Text = 系統語言字典("H001-265-" & 語言) & "-014" : CheckBox74.Text = 系統語言字典("H001-274-" & 語言) & "-074" : CheckBox75.Text = 系統語言字典("H001-275-" & 語言) & "-075"
  257. '------------------------工程管理系統-------------------------------------------------------------------------------------------------------------------------------------------------
  258. 工程權限_tp.Text = 系統語言字典("H001-106-" & 語言) : CheckBox8.Text = 系統語言字典("H001-106-" & 語言) & "-008" : CheckBox105.Text = 系統語言字典("H001-133-" & 語言) & "-105"
  259. CheckBox108.Text = 系統語言字典("H001-132-" & 語言) & "-108" : CheckBox109.Text = 系統語言字典("H001-126-" & 語言) & "-109" : CheckBox110.Text = 系統語言字典("H001-108-" & 語言) & "-110"
  260. CheckBox106.Text = 系統語言字典("H001-176-" & 語言) & "-106" : CheckBox104.Text = 系統語言字典("H001-104-" & 語言) & "-104" : CheckBox53.Text = 系統語言字典("H001-107-" & 語言) & "-053"
  261. CheckBox54.Text = 系統語言字典("H001-110-" & 語言) & "-054"
  262. '------------------------倉儲管理系統-------------------------------------------------------------------------------------------------------------------------------------------------
  263. 倉儲權限_tp.Text = 系統語言字典("H001-180-" & 語言) : CheckBox9.Text = 系統語言字典("H001-180-" & 語言) & "-009" : CheckBox46.Text = 系統語言字典("H001-227-" & 語言) & "-046"
  264. CheckBox47.Text = 系統語言字典("H001-223-" & 語言) & "-047" : CheckBox48.Text = 系統語言字典("H001-224-" & 語言) & "-048" : CheckBox49.Text = 系統語言字典("H001-225-" & 語言) & "-049"
  265. CheckBox50.Text = 系統語言字典("H001-226-" & 語言) & "-050" : CheckBox56.Text = 系統語言字典("H001-186-" & 語言) & "-056" : CheckBox57.Text = 系統語言字典("H001-187-" & 語言) & "-057"
  266. CheckBox58.Text = 系統語言字典("H001-185-" & 語言) & "-058" : CheckBox59.Text = 系統語言字典("H001-159-" & 語言) & "-059" : CheckBox70.Text = 系統語言字典("H001-161-" & 語言) & "-070"
  267. CheckBox71.Text = 系統語言字典("H001-179-" & 語言) & "-071" : CheckBox69.Text = 系統語言字典("H001-181-" & 語言) & "-069" : CheckBox85.Text = 系統語言字典("H001-213-" & 語言) & "-085"
  268. CheckBox86.Text = 系統語言字典("H001-214-" & 語言) & "-086" : CheckBox40.Text = 系統語言字典("H001-299-" & 語言) & "-040"
  269. '------------------------財務管理系統-------------------------------------------------------------------------------------------------------------------------------------------------
  270. 財務權限_tp.Text = 系統語言字典("H001-182-" & 語言) : CheckBox7.Text = 系統語言字典("H001-182-" & 語言) & "-007" : CheckBox91.Text = 系統語言字典("H001-220-" & 語言) & "-091"
  271. CheckBox92.Text = 系統語言字典("H001-222-" & 語言) & "-092" : CheckBox93.Text = 系統語言字典("H001-219-" & 語言) & "-093" : CheckBox94.Text = 系統語言字典("H001-221-" & 語言) & "-094"
  272. CheckBox95.Text = 系統語言字典("H001-218-" & 語言) & "-095" : CheckBox96.Text = 系統語言字典("H001-201-" & 語言) & "-096" : CheckBox97.Text = 系統語言字典("H001-202-" & 語言) & "-097"
  273. CheckBox18.Text = 系統語言字典("H001-210-" & 語言) & "-018" : CheckBox64.Text = 系統語言字典("H001-207-" & 語言) & "-064" : CheckBox65.Text = 系統語言字典("H001-208-" & 語言) & "-065"
  274. CheckBox66.Text = 系統語言字典("H001-211-" & 語言) & "-066" : CheckBox90.Text = 系統語言字典("H001-209-" & 語言) & "-090" : CheckBox78.Text = 系統語言字典("H001-113-" & 語言) & "-078"
  275. CheckBox79.Text = 系統語言字典("H001-115-" & 語言) & "-079" : CheckBox76.Text = 系統語言字典("H001-112-" & 語言) & "-076" : CheckBox77.Text = 系統語言字典("H001-114-" & 語言) & "-077"
  276. CheckBox68.Text = 系統語言字典("H001-297-" & 語言) & "-068"
  277. '------------------------人事管理系統-------------------------------------------------------------------------------------------------------------------------------------------------
  278. 人事權限_tp.Text = 系統語言字典("H001-101-" & 語言) : CheckBox22.Text = 系統語言字典("H001-101-" & 語言) & "-022" : CheckBox55.Text = 系統語言字典("H001-146-" & 語言) & "-055"
  279. CheckBox23.Text = 系統語言字典("H001-102-" & 語言) & "-023" : CheckBox24.Text = 系統語言字典("H001-266-" & 語言) & "-024" : CheckBox89.Text = 系統語言字典("H001-151-" & 語言) & "-089"
  280. CheckBox111.Text = 系統語言字典("H001-158-" & 語言) & "-111" : CheckBox112.Text = 系統語言字典("H001-162-" & 語言) & "-112" : CheckBox113.Text = 系統語言字典("H001-183-" & 語言) & "-113"
  281. CheckBox17.Text = 系統語言字典("H001-269-" & 語言) & "-017" : CheckBox16.Text = 系統語言字典("H001-270-" & 語言) & "-016" : CheckBox15.Text = 系統語言字典("H001-271-" & 語言) & "-015"
  282. CheckBox80.Text = 系統語言字典("H000-121-" & 語言) & "-080" : CheckBox81.Text = 系統語言字典("H001-272-" & 語言) & "-081" : CheckBox100.Text = 系統語言字典("H000-122-" & 語言) & "-100"
  283. CheckBox67.Text = 系統語言字典("H000-124-" & 語言) & "-067" : CheckBox82.Text = 系統語言字典("H001-196-" & 語言) & "-082" : CheckBox122.Text = 系統語言字典("H001-300-" & 語言) & "-122"
  284. CheckBox83.Text = 系統語言字典("H001-304-" & 語言) & "-083"
  285. '------------------------資料庫管理系統-------------------------------------------------------------------------------------------------------------------------------------------------
  286. 資料庫權限_tp.Text = 系統語言字典("H001-205-" & 語言) : CheckBox1.Text = 系統語言字典("H001-205-" & 語言) & "-001" : CheckBox2.Text = 系統語言字典("H001-146-" & 語言) & "-002"
  287. CheckBox84.Text = 系統語言字典("H001-156-" & 語言) & "-084" : CheckBox41.Text = 系統語言字典("H001-150-" & 語言) & "-041" : CheckBox87.Text = 系統語言字典("H001-195-" & 語言) & "-087"
  288. CheckBox43.Text = 系統語言字典("H001-152-" & 語言) & "-043" : CheckBox10.Text = 系統語言字典("H001-155-" & 語言) & "-010" : CheckBox44.Text = 系統語言字典("H001-154-" & 語言) & "-044"
  289. CheckBox4.Text = 系統語言字典("H001-149-" & 語言) & "-004" : CheckBox3.Text = 系統語言字典("H001-100-" & 語言) & "-003" : CheckBox19.Text = 系統語言字典("H001-153-" & 語言) & "-019"
  290. CheckBox21.Text = 系統語言字典("H001-232-" & 語言) & "-021" : CheckBox45.Text = 系統語言字典("H001-267-" & 語言) & "-045" : CheckBox88.Text = 系統語言字典("H001-268-" & 語言) & "-088"
  291. End Sub
  292. Private Sub 新增_bt_MouseEnter(sender As Object, e As EventArgs) Handles 新增_bt.MouseEnter
  293. ToolTip1.SetToolTip(Me.新增_bt, 對話框(0))
  294. End Sub
  295. Private Sub 確認新增_bt_MouseEnter(sender As Object, e As EventArgs) Handles 確認新增_bt.MouseEnter
  296. ToolTip1.SetToolTip(Me.確認新增_bt, 對話框(1))
  297. End Sub
  298. Private Sub 修改1_bt_MouseEnter(sender As Object, e As EventArgs) Handles 修改1_bt.MouseEnter
  299. ToolTip1.SetToolTip(Me.修改1_bt, 對話框(2))
  300. End Sub
  301. Private Sub 修改_bt_MouseEnter(sender As Object, e As EventArgs) Handles 修改_bt.MouseEnter
  302. ToolTip1.SetToolTip(Me.修改_bt, 對話框(1))
  303. End Sub
  304. Private Sub 刪除_bt_MouseEnter(sender As Object, e As EventArgs) Handles 刪除_bt.MouseEnter
  305. ToolTip1.SetToolTip(Me.刪除_bt, 對話框(3))
  306. End Sub
  307. Private Sub 顯示密碼_bt_MouseEnter(sender As Object, e As EventArgs) Handles 顯示密碼_bt.MouseEnter
  308. ToolTip1.SetToolTip(Me.顯示密碼_bt, 對話框(4))
  309. End Sub
  310. Private Sub 隱藏密碼_bt_MouseEnter(sender As Object, e As EventArgs) Handles 隱藏密碼_bt.MouseEnter
  311. ToolTip1.SetToolTip(Me.隱藏密碼_bt, 對話框(5))
  312. End Sub
  313. Private Sub 查詢_bt_MouseEnter(sender As Object, e As EventArgs) Handles 查詢_bt.MouseEnter
  314. ToolTip1.SetToolTip(Me.查詢_bt, 對話框(6))
  315. End Sub
  316. Private Sub 指定預設權限_bt_MouseEnter(sender As Object, e As EventArgs) Handles 指定預設權限_bt.MouseEnter
  317. ToolTip1.SetToolTip(Me.指定預設權限_bt, 對話框(8))
  318. End Sub
  319. Private Sub 系統使用者管理_Load(sender As Object, e As EventArgs) Handles MyBase.Load
  320. Me.MdiParent = HX_PGS_ERP_SYS : Me.WindowState = 2 : Me.AutoScroll = True
  321. 風格() : H(2) = True : 介面 = "H002" : 語言轉換讀取() : Panel1.SendToBack() : 顯示說明(999, True)
  322. If BL = False Then : 資料庫權限_tp.Enabled = True : 財務權限_tp.Enabled = True : Else : 資料庫權限_tp.Enabled = False : 財務權限_tp.Enabled = False : End If
  323. 在職 = True
  324. SQL_清單欄位查詢()
  325. If Acdr.Read() Then
  326. 小間距1_ch.Checked = Acdr("L_1_1") : 中間距1_ch.Checked = Acdr("L_2_1") : 大間距1_ch.Checked = Acdr("L_3_1")
  327. End If : Access1.Close()
  328. PA = "" : 預設權限_dgv.Visible = False : 修改_bt.Enabled = False : 確認新增_bt.Enabled = False
  329. MyMod.清單字體大小調整()
  330. 清單1_dgv.RowsDefaultCellStyle.Font = New System.Drawing.Font("微軟正黑體", HX_PGS_ERP_SYS.字體_NUD.Value)
  331. End Sub
  332. Private Sub 系統使用者管理_Shown(sender As Object, e As EventArgs) Handles MyBase.Shown
  333. 分流計算.Enabled = True
  334. End Sub
  335. Private Sub 分流計算_Tick(sender As Object, e As EventArgs) Handles 分流計算.Tick
  336. 分流計算.Enabled = False
  337. ComboBox1下拉表單資料載入() : ComboBox3下拉表單資料載入() : ComboBox4下拉表單資料載入() : ComboBox5下拉表單資料載入() : 下拉清單_職稱()
  338. Set_格式設定() : Set_使用者清單() : Set_grid()
  339. End Sub
  340. Private Sub 系統使用者管理_Closed(sender As Object, e As EventArgs) Handles MyBase.Closed
  341. MyMod.虛擬桌面開啟()
  342. End Sub
  343. Private Sub 系統使用者管理_SizeChanged(sender As Object, e As EventArgs) Handles MyBase.SizeChanged
  344. MyMod.清單字體大小調整()
  345. 清單1_dgv.RowsDefaultCellStyle.Font = New System.Drawing.Font("微軟正黑體", HX_PGS_ERP_SYS.字體_NUD.Value)
  346. End Sub
  347. Private Sub 登入閒置控制_MouseMove(sender As Object, e As EventArgs) Handles MyBase.MouseMove
  348. timeNow = 0 : HX_PGS_ERP_SYS.Timer1.Enabled = False : HX_PGS_ERP_SYS.Timer1.Enabled = True
  349. End Sub
  350. Private Sub 登入閒置控制_KeyPress(sender As Object, e As EventArgs) Handles MyBase.KeyPress
  351. timeNow = 0 : HX_PGS_ERP_SYS.Timer1.Enabled = False : HX_PGS_ERP_SYS.Timer1.Enabled = True
  352. End Sub
  353. Private Sub 部門_cb_SelectedIndexChanged(sender As Object, e As EventArgs) Handles 部門_cb.SelectedIndexChanged
  354. 部門1_cb.SelectedIndex = 部門_cb.SelectedIndex : ComboBox5下拉表單資料載入() : 下拉清單_職稱()
  355. End Sub
  356. Private Sub 處別_cb_SelectedIndexChanged(sender As Object, e As EventArgs) Handles 處別_cb.SelectedIndexChanged
  357. 處別1_cb.SelectedIndex = 處別_cb.SelectedIndex : ComboBox3下拉表單資料載入() : 下拉清單_職稱()
  358. End Sub
  359. Private Sub 課別_cb_SelectedIndexChanged(sender As Object, e As EventArgs) Handles 課別_cb.SelectedIndexChanged
  360. 課別1_cb.SelectedIndex = 課別_cb.SelectedIndex : ComboBox4下拉表單資料載入()
  361. End Sub
  362. Private Sub 職稱_cb_SelectedIndexChanged(sender As Object, e As EventArgs) Handles 職稱_cb.SelectedIndexChanged
  363. 職稱1_cb.SelectedIndex = 職稱_cb.SelectedIndex : 級別_cb.SelectedIndex = 職稱_cb.SelectedIndex : Set_權限清單() : Dim S1, S2, S3, S4 As String
  364. PA = 職稱_cb.Text : SQL_系統使用者管理_組織帶入() : PA = ""
  365. If dr.Read() Then : S1 = dr("部") : S2 = dr("處") : S3 = dr("課") : S4 = dr("組") : End If : conn.Close()
  366. 部門_cb.Text = S1 : 處別_cb.Text = S2 : 課別_cb.Text = S3 : 組別_cb.Text = S4
  367. End Sub
  368. Private Sub 級別_cb_SelectedIndexChanged(sender As Object, e As EventArgs) Handles 級別_cb.SelectedIndexChanged
  369. 職稱_cb.SelectedIndex = 級別_cb.SelectedIndex : Set_權限清單()
  370. End Sub
  371. Private Sub 清單1_dgv_RowPostPaint(ByVal sender As Object, ByVal e As DataGridViewRowPostPaintEventArgs) Handles 清單1_dgv.RowPostPaint
  372. Dim linePen As New Pen(Color.Blue, 2)
  373. If e.RowIndex = 清單1_dgv.Rows.Count - 1 Then
  374. Exit Sub
  375. Else
  376. If 清單1_dgv("級別", e.RowIndex).Value.ToString <> 清單1_dgv("級別", e.RowIndex + 1).Value.ToString Then
  377. Dim startX As Integer = IIf(清單1_dgv.RowHeadersVisible, 清單1_dgv.RowHeadersWidth, 0)
  378. Dim startY As Integer = e.RowBounds.Top + e.RowBounds.Height - 1
  379. Dim endX As Integer = startX + 清單1_dgv.Columns.GetColumnsWidth(DataGridViewElementStates.Visible) - 清單1_dgv.HorizontalScrollingOffset
  380. e.Graphics.DrawLine(linePen, startX, startY, endX, startY)
  381. Exit Sub
  382. End If
  383. End If
  384. For i As Integer = 0 To 清單1_dgv.Rows.Count - 1
  385. If 深色風格 = False Then
  386. If 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "01" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.LightGoldenrodYellow
  387. ElseIf 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "02" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.LightGreen
  388. ElseIf 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "03" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.LightPink
  389. ElseIf 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "04" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.LightBlue
  390. ElseIf 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "05" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.LightBlue : End If
  391. Else
  392. If 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "01" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.Purple
  393. ElseIf 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "02" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.DarkGreen
  394. ElseIf 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "03" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.DarkRed
  395. ElseIf 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "04" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.DarkBlue
  396. ElseIf 清單1_dgv.Rows(i).Cells("級別").Value.ToString = "05" Then : 清單1_dgv.Rows(i).DefaultCellStyle.BackColor = Color.DarkBlue : End If
  397. End If
  398. Next
  399. End Sub
  400. Private Sub 清單1_dgv_CellContentClick(sender As Object, e As DataGridViewCellEventArgs) Handles 清單1_dgv.CellClick
  401. If e.RowIndex = -1 Then : Else
  402. 部門_cb.Text = "" : 處別_cb.Text = ""
  403. 姓名_tb.Text = 清單_dgv.Rows(e.RowIndex).Cells("姓名").Value.ToString : 帳號_tb.Text = 清單_dgv.Rows(e.RowIndex).Cells("帳號").Value.ToString
  404. 密碼_tb.Text = 清單_dgv.Rows(e.RowIndex).Cells("密碼").Value.ToString : 職稱_cb.Text = 清單_dgv.Rows(e.RowIndex).Cells("職稱").Value.ToString
  405. NAS帳號_tb.Text = 清單_dgv.Rows(e.RowIndex).Cells("NAS帳號").Value.ToString : NAS密碼_tb.Text = 清單_dgv.Rows(e.RowIndex).Cells("NAS密碼").Value.ToString
  406. If 顯示密碼_bt.Enabled = False Then
  407. PA39 = 姓名_tb.Text : PA38 = 帳號_tb.Text : SQL_系統使用者密碼顯示()
  408. If dr.Read() Then : 密碼_tb.Text = dr("密碼") : End If : conn.Close()
  409. End If
  410. For no As Integer = 1 To 權限數量
  411. If no < 10 Then : HH = "0" & no : ElseIf no >= 10 Then : HH = no : End If
  412. Dim 選擇 As CheckBox = CType(Me.Controls.Find("CheckBox" + no.ToString(), True)(0), CheckBox)
  413. 選擇.Checked = 清單_dgv.Rows(e.RowIndex).Cells("CC" & HH).Value
  414. Next
  415. Set_權限清單() : 職稱_cb.Text = 清單_dgv.Rows(e.RowIndex).Cells("職稱").Value.ToString
  416. End If
  417. End Sub
  418. Private Sub 指定預設權限_bt_Click_1(sender As Object, e As EventArgs) Handles 指定預設權限_bt.Click
  419. If 姓名_tb.Text = "" Or 帳號_tb.Text = "" Or 密碼_tb.Text = "" Then : MGB(對話框(10), 1) : Else
  420. For no As Integer = 1 To 權限數量
  421. If no < 10 Then : HH = "0" & no : ElseIf no >= 10 Then : HH = no : End If
  422. Dim 選擇 As CheckBox = CType(Me.Controls.Find("CheckBox" + no.ToString(), True)(0), CheckBox)
  423. If HH = 63 Then : Else
  424. 選擇.Checked = 預設權限_dgv.Rows(0).Cells("CC" & HH).Value
  425. End If
  426. Next
  427. End If
  428. End Sub
  429. Private Sub 新增_bt_Click(sender As Object, e As EventArgs) Handles 新增_bt.Click
  430. If 姓名_tb.Text = "" Or 帳號_tb.Text = "" Or 密碼_tb.Text = "" Then : MGB(對話框(10), 1) : Else
  431. If 級別_cb.Text = "00" Or 級別_cb.Text = "01" Or 級別_cb.Text = "02" Or 級別_cb.Text = "03" Or 級別_cb.Text = "04" Then
  432. If 登入人級別 = "00" Then
  433. 姓名_tb.Text = "" : 帳號_tb.Text = "" : 密碼_tb.Text = "" : 新增_bt.Enabled = False : 確認新增_bt.Enabled = True
  434. Set_格式設定()
  435. Else
  436. MGB(對話框(19), 1)
  437. End If
  438. Else
  439. 姓名_tb.Text = "" : 帳號_tb.Text = "" : 密碼_tb.Text = "" : 新增_bt.Enabled = False : 確認新增_bt.Enabled = True
  440. Set_格式設定()
  441. End If
  442. End If
  443. End Sub
  444. Private Sub 確認新增_bt_Click(sender As Object, e As EventArgs) Handles 確認新增_bt.Click
  445. If 姓名_tb.Text = "" Or 帳號_tb.Text = "" Or 密碼_tb.Text = "" Then : MGB(對話框(10), 1) : Else
  446. If 級別_cb.Text = "00" Or 級別_cb.Text = "01" Or 級別_cb.Text = "02" Or 級別_cb.Text = "03" Or 級別_cb.Text = "04" Then
  447. If 登入人級別 = "00" Then
  448. MGB(對話框(18), 2) : If 訊息回應 = "YES" Then : 指定預設權限_bt.PerformClick() : End If
  449. DTP = Strings.Format(Today().AddMonths(2), "yyyy/MM/dd") : SQL_系統使用者新增() : SQL_系統使用者修改() : conn.Close()
  450. MGB(對話框(9), 1)
  451. Set_使用者清單() : Set_grid()
  452. 確認新增_bt.Enabled = False : 新增_bt.Enabled = True : 顯示密碼_bt.Enabled = True : 隱藏密碼_bt.Enabled = False
  453. Else
  454. MGB(對話框(19), 1)
  455. End If
  456. Else
  457. MGB(對話框(18), 2) : If 訊息回應 = "YES" Then : 指定預設權限_bt.PerformClick() : End If
  458. DTP = Strings.Format(Today().AddMonths(2), "yyyy/MM/dd") : SQL_系統使用者新增() : SQL_系統使用者修改() : conn.Close()
  459. MGB(對話框(9), 1)
  460. Set_使用者清單() : Set_grid()
  461. 確認新增_bt.Enabled = False : 新增_bt.Enabled = True : 顯示密碼_bt.Enabled = True : 隱藏密碼_bt.Enabled = False
  462. End If
  463. End If
  464. End Sub
  465. Private Sub 修改1_bt_Click(sender As Object, e As EventArgs) Handles 修改1_bt.Click
  466. If 姓名_tb.Text = "" Or 帳號_tb.Text = "" Or 密碼_tb.Text = "" Then : MGB(對話框(17), 1) : Else
  467. 修改_bt.Enabled = True
  468. End If
  469. End Sub
  470. Private Sub 修改_bt_Click(sender As Object, e As EventArgs) Handles 修改_bt.Click
  471. If 姓名_tb.Text = "" Or 帳號_tb.Text = "" Or 密碼_tb.Text = "" Then : MGB(對話框(17), 1) : Else
  472. MGB(對話框(18), 2) : If 訊息回應 = "YES" Then : 指定預設權限_bt.PerformClick() : End If
  473. If 密碼_tb.Text = "**********" Then : PA9 = "" : Else : PA9 = ", 密碼 = '" & 密碼_tb.Text & "'" : End If
  474. SQL_系統使用者修改() : conn.Close() : MGB(對話框(16), 1)
  475. 修改_bt.Enabled = False
  476. End If : PA = "" : Set_使用者清單() : Set_grid()
  477. End Sub
  478. Private Sub 刪除_bt_Click(sender As Object, e As EventArgs) Handles 刪除_bt.Click
  479. If 姓名_tb.Text = "" And 帳號_tb.Text = "" And 密碼_tb.Text = "" Then : MGB(對話框(17), 1) : Else
  480. If 登入人級別 = "00" Then
  481. MGB(對話框(36), 2)
  482. If 訊息回應 = "YES" Then
  483. CheckBox63.Checked = True : SQL_系統使用者修改() : conn.Close() : MGB(對話框(14), 1)
  484. Else
  485. PA37 = 帳號_tb.Text : SQL_系統使用者刪除() : conn.Close() : MGB(對話框(14), 1)
  486. End If
  487. 姓名_tb.Text = "" : 帳號_tb.Text = "" : 帳號_tb.Text = "" : 修改_bt.Enabled = False : 確認新增_bt.Enabled = False
  488. Else
  489. MGB(對話框(15), 2)
  490. If 訊息回應 = "YES" Then : CheckBox63.Checked = True : SQL_系統使用者修改() : conn.Close() : MGB(對話框(14), 1) : End If
  491. 修改_bt.Enabled = False : 確認新增_bt.Enabled = False
  492. End If : PA = "" : Set_使用者清單() : Set_grid()
  493. End If
  494. End Sub
  495. Private Sub 隱藏密碼_bt_Click(sender As Object, e As EventArgs) Handles 隱藏密碼_bt.Click
  496. 顯示密碼_bt.Enabled = True : 隱藏密碼_bt.Enabled = False : 密碼_tb.Text = "**********"
  497. End Sub
  498. Private Sub 顯示密碼_bt_Click(sender As Object, e As EventArgs) Handles 顯示密碼_bt.Click
  499. 顯示密碼_bt.Enabled = False : 隱藏密碼_bt.Enabled = True
  500. PA39 = 姓名_tb.Text : PA38 = 帳號_tb.Text : SQL_系統使用者密碼顯示()
  501. If dr.Read() Then : 密碼_tb.Text = dr("密碼") : End If : conn.Close()
  502. End Sub
  503. Private Sub 查詢_bt_Click(sender As Object, e As EventArgs) Handles 查詢_bt.Click
  504. PA = InputBox(對話框(13)) : Set_使用者清單() : PA = ""
  505. End Sub
  506. Private Sub 權限名稱取得()
  507. Dim 選擇 As CheckBox = CType(Me.Controls.Find("CheckBox" + 權限代號.ToString(), True)(0), CheckBox) : 權限名稱 = 選擇.Text : 權限選取 = 選擇.Checked
  508. End Sub
  509. Private Sub 自動生成_bt_Click(sender As Object, e As EventArgs) Handles 自動生成_bt.Click
  510. Dim random As New Random() : Dim randomNumber As Integer = random.Next(10, 99)
  511. Dim rando As New Random() : Dim randomNum As Integer = rando.Next(0, 9)
  512. Dim rand As New Random() : Dim randomNu As Integer = rand.Next(0, 9)
  513. Dim DFG As String
  514. For QAZ = 0 To 999
  515. QQW(0) = randomNumber : QQW(1) = Strings.Right(Year(Today), 2) : QQW(2) = Strings.Left(Year(Today), 2) : QQW(3) = Month(Today) + 9
  516. QQW(4) = Strings.Right(QQW(0), 1) : QQW(5) = Strings.Left(QQW(0), 1) : QQW(6) = Strings.Right(QQW(1), 1) : QQW(7) = Strings.Left(QQW(1), 1) : QQW(8) = Strings.Right(QQW(2), 1)
  517. QQW(9) = Strings.Left(QQW(2), 1) : QQW(10) = Strings.Right(QQW(3), 1) : QQW(11) = Strings.Left(QQW(3), 1)
  518. For RT = 4 To 11 : If RT = 9 Or RT = 5 Or RT = 4 Or RT = 8 Then : FG = RT : 轉換() : End If : Next
  519. Dim ran1 = New Random(DateTime.Now.Millisecond) : Dim NUM2 As Integer = ran1.Next(1, 4096)
  520. For I = 0 To 4096 : If NUM2 > 99 Then : NUM2 -= 49 : ElseIf NUM2 < 99 Then : I = 4096 : End If : Next
  521. DFG = QQW(9) & QQW(7) & QQW(5) & QQW(11) & QQW(4) & QQW(6) & QQW(8) & QQW(10) & NUM2
  522. PA41 = DFG : SQL_系統使用者ID卡號()
  523. If dr.Read() = True Then : Else : QAZ = 999 : End If : conn.Close()
  524. Next
  525. If 密碼_tb.Text = "" Then : 密碼_tb.Text = Strings.Left(DFG, 9) & randomNu : End If
  526. End Sub
  527. Private Sub 轉換()
  528. If QQW(FG) = "1" Then : QQW(FG) = "A" : ElseIf QQW(FG) = "2" Then : QQW(FG) = "B"
  529. ElseIf QQW(FG) = "3" Then : QQW(FG) = "C" : ElseIf QQW(FG) = "4" Then : QQW(FG) = "D"
  530. ElseIf QQW(FG) = "5" Then : QQW(FG) = "E" : ElseIf QQW(FG) = "6" Then : QQW(FG) = "F"
  531. ElseIf QQW(FG) = "7" Then : QQW(FG) = "G" : ElseIf QQW(FG) = "8" Then : QQW(FG) = "H"
  532. ElseIf QQW(FG) = "9" Then : QQW(FG) = "I" : ElseIf QQW(FG) = "0" Then : QQW(FG) = "J" : End If
  533. End Sub
  534. Private Sub 小間距1_ch_CheckedChanged(sender As Object, e As EventArgs) Handles 小間距1_ch.Click
  535. 小間距1_ch.Checked = True : 中間距1_ch.Checked = False : 大間距1_ch.Checked = False : MyMod.間距設定存檔_1() : Set_使用者清單()
  536. End Sub
  537. Private Sub 中間距1_ch_CheckedChanged(sender As Object, e As EventArgs) Handles 中間距1_ch.Click
  538. 小間距1_ch.Checked = False : 中間距1_ch.Checked = True : 大間距1_ch.Checked = False : MyMod.間距設定存檔_2() : Set_使用者清單()
  539. End Sub
  540. Private Sub 大間距1_ch_CheckedChanged(sender As Object, e As EventArgs) Handles 大間距1_ch.Click
  541. 小間距1_ch.Checked = False : 中間距1_ch.Checked = False : 大間距1_ch.Checked = True : MyMod.間距設定存檔_3() : Set_使用者清單()
  542. End Sub
  543. Private Sub 部門1_cb_SelectedIndexChanged(sender As Object, e As EventArgs) Handles 部門1_cb.SelectedIndexChanged
  544. 部門_cb.SelectedIndex = 部門1_cb.SelectedIndex
  545. End Sub
  546. Private Sub 處別1_cb_SelectedIndexChanged(sender As Object, e As EventArgs) Handles 處別1_cb.SelectedIndexChanged
  547. 處別_cb.SelectedIndex = 處別1_cb.SelectedIndex
  548. End Sub
  549. Private Sub 課別1_cb_SelectedIndexChanged(sender As Object, e As EventArgs) Handles 課別1_cb.SelectedIndexChanged
  550. 課別_cb.SelectedIndex = 課別1_cb.SelectedIndex
  551. End Sub
  552. Private Sub 組別1_cb_SelectedIndexChanged(sender As Object, e As EventArgs) Handles 組別1_cb.SelectedIndexChanged
  553. 組別_cb.SelectedIndex = 組別1_cb.SelectedIndex
  554. End Sub
  555. Private Sub 職稱1_cb_SelectedIndexChanged(sender As Object, e As EventArgs) Handles 職稱1_cb.SelectedIndexChanged
  556. 職稱_cb.SelectedIndex = 職稱1_cb.SelectedIndex
  557. If 確認新增_bt.Enabled = True Or 修改_bt.Enabled = True Then : 指定預設權限_bt.PerformClick() : End If
  558. End Sub
  559. Private Sub 組別_cb_SelectedIndexChanged(sender As Object, e As EventArgs) Handles 組別_cb.SelectedIndexChanged
  560. 組別1_cb.SelectedIndex = 組別_cb.SelectedIndex
  561. End Sub
  562. Private Sub 工人_ch_CheckedChanged(sender As Object, e As EventArgs) Handles 工人_ch.Click
  563. If 工人_ch.Checked = True Then : 工人 = True : Else : 工人 = False : End If : Set_使用者清單()
  564. End Sub
  565. Private Sub 語轉扭_bt_Click(sender As Object, e As EventArgs) Handles 語轉扭_bt.Click
  566. 介面 = "H002" : 語言轉換讀取()
  567. ComboBox1下拉表單資料載入() : ComboBox3下拉表單資料載入() : ComboBox4下拉表單資料載入() : ComboBox5下拉表單資料載入() : 下拉清單_職稱()
  568. Set_格式設定() : Set_使用者清單() : Set_grid()
  569. End Sub
  570. Private Sub 風格()
  571. If 深色風格 = False Then
  572. Me.BackColor = SystemColors.Control : 業務權限_tp.BackColor = SystemColors.Control : 採購權限_tp.BackColor = SystemColors.Control
  573. 工程權限_tp.BackColor = SystemColors.Control : 倉儲權限_tp.BackColor = SystemColors.Control : 財務權限_tp.BackColor = SystemColors.Control
  574. 人事權限_tp.BackColor = SystemColors.Control : 資料庫權限_tp.BackColor = SystemColors.Control
  575. '----------------黑-------------------------------------------
  576. 小間距1_ch.ForeColor = Color.Black : 中間距1_ch.ForeColor = Color.Black : 大間距1_ch.ForeColor = Color.Black : 姓名_lb.ForeColor = Color.Black
  577. 帳號_lb.ForeColor = Color.Black : 密碼_lb.ForeColor = Color.Black : NAS帳號_lb.ForeColor = Color.Black : NAS密碼_lb.ForeColor = Color.Black
  578. 部門_lb.ForeColor = Color.Black : 處別_lb.ForeColor = Color.Black : 課別_lb.ForeColor = Color.Black : 組別_lb.ForeColor = Color.Black
  579. 職稱_lb.ForeColor = Color.Black : CheckBox1.ForeColor = Color.Black : CheckBox22.ForeColor = Color.Black : CheckBox7.ForeColor = Color.Black
  580. CheckBox9.ForeColor = Color.Black : CheckBox8.ForeColor = Color.Black : CheckBox6.ForeColor = Color.Black : CheckBox5.ForeColor = Color.Black
  581. '----------------紅-------------------------------------------
  582. CheckBox74.ForeColor = Color.Red : CheckBox75.ForeColor = Color.Red : CheckBox2.ForeColor = Color.Red : CheckBox45.ForeColor = Color.Red
  583. CheckBox84.ForeColor = Color.Red : CheckBox41.ForeColor = Color.Red : CheckBox87.ForeColor = Color.Red : CheckBox88.ForeColor = Color.Red
  584. CheckBox43.ForeColor = Color.Red : CheckBox10.ForeColor = Color.Red : CheckBox44.ForeColor = Color.Red : CheckBox4.ForeColor = Color.Red
  585. CheckBox3.ForeColor = Color.Red : CheckBox23.ForeColor = Color.Red : CheckBox24.ForeColor = Color.Red : CheckBox89.ForeColor = Color.Red
  586. CheckBox91.ForeColor = Color.Red : CheckBox92.ForeColor = Color.Red : CheckBox93.ForeColor = Color.Red : CheckBox94.ForeColor = Color.Red
  587. CheckBox95.ForeColor = Color.Red : CheckBox96.ForeColor = Color.Red : CheckBox97.ForeColor = Color.Red : CheckBox46.ForeColor = Color.Red
  588. CheckBox47.ForeColor = Color.Red : CheckBox48.ForeColor = Color.Red : CheckBox49.ForeColor = Color.Red : CheckBox50.ForeColor = Color.Red
  589. CheckBox25.ForeColor = Color.Red : CheckBox26.ForeColor = Color.Red : CheckBox27.ForeColor = Color.Red : CheckBox60.ForeColor = Color.Red
  590. CheckBox116.ForeColor = Color.Red : CheckBox107.ForeColor = Color.Red : CheckBox98.ForeColor = Color.Red : CheckBox101.ForeColor = Color.Red
  591. CheckBox103.ForeColor = Color.Red : CheckBox102.ForeColor = Color.Red : CheckBox33.ForeColor = Color.Red : CheckBox34.ForeColor = Color.Red
  592. CheckBox35.ForeColor = Color.Red : CheckBox90.ForeColor = Color.Red : CheckBox15.ForeColor = Color.Red : CheckBox16.ForeColor = Color.Red
  593. CheckBox17.ForeColor = Color.Red : CheckBox109.ForeColor = Color.Red : CheckBox108.ForeColor = Color.Red : CheckBox105.ForeColor = Color.Red
  594. CheckBox53.ForeColor = Color.Red : CheckBox104.ForeColor = Color.Red : CheckBox106.ForeColor = Color.Red : CheckBox110.ForeColor = Color.Red
  595. CheckBox54.ForeColor = Color.Red : CheckBox55.ForeColor = Color.Red : CheckBox59.ForeColor = Color.Red : CheckBox40.ForeColor = Color.Red
  596. '----------------藍-------------------------------------------
  597. CheckBox61.ForeColor = Color.Blue : CheckBox99.ForeColor = Color.Blue
  598. CheckBox62.ForeColor = Color.Blue : CheckBox114.ForeColor = Color.Blue : CheckBox52.ForeColor = Color.Blue : CheckBox51.ForeColor = Color.Blue
  599. CheckBox42.ForeColor = Color.Blue : CheckBox11.ForeColor = Color.Blue : CheckBox12.ForeColor = Color.Blue : CheckBox13.ForeColor = Color.Blue
  600. CheckBox14.ForeColor = Color.Blue : CheckBox100.ForeColor = Color.Blue : CheckBox69.ForeColor = Color.Blue : CheckBox70.ForeColor = Color.Blue
  601. CheckBox71.ForeColor = Color.Blue : CheckBox18.ForeColor = Color.Blue : CheckBox111.ForeColor = Color.Blue : CheckBox112.ForeColor = Color.Blue
  602. CheckBox113.ForeColor = Color.Blue : CheckBox19.ForeColor = Color.Blue : CheckBox21.ForeColor = Color.Blue : CheckBox76.ForeColor = Color.Blue
  603. CheckBox67.ForeColor = Color.Blue : CheckBox65.ForeColor = Color.Blue : CheckBox79.ForeColor = Color.Blue : CheckBox77.ForeColor = Color.Blue
  604. CheckBox68.ForeColor = Color.Blue : CheckBox66.ForeColor = Color.Blue : CheckBox64.ForeColor = Color.Blue : CheckBox78.ForeColor = Color.Blue
  605. CheckBox63.ForeColor = Color.Blue : CheckBox32.ForeColor = Color.Blue
  606. '----------------綠-------------------------------------------
  607. CheckBox123.ForeColor = Color.Green : CheckBox124.ForeColor = Color.Green : CheckBox125.ForeColor = Color.Green : CheckBox126.ForeColor = Color.Green
  608. CheckBox127.ForeColor = Color.Green : CheckBox128.ForeColor = Color.Green : CheckBox20.ForeColor = Color.Green : CheckBox36.ForeColor = Color.Green
  609. CheckBox73.ForeColor = Color.Green : CheckBox37.ForeColor = Color.Green : CheckBox38.ForeColor = Color.Green : CheckBox39.ForeColor = Color.Green
  610. CheckBox28.ForeColor = Color.Green : CheckBox72.ForeColor = Color.Green : CheckBox29.ForeColor = Color.Green : CheckBox30.ForeColor = Color.Green
  611. CheckBox31.ForeColor = Color.Green : CheckBox82.ForeColor = Color.Green : CheckBox83.ForeColor = Color.Green : CheckBox81.ForeColor = Color.Green
  612. CheckBox80.ForeColor = Color.Green : CheckBox58.ForeColor = Color.Green : CheckBox57.ForeColor = Color.Green : CheckBox56.ForeColor = Color.Green
  613. CheckBox86.ForeColor = Color.Green : CheckBox115.ForeColor = Color.Green : CheckBox85.ForeColor = Color.Green
  614. CheckBox121.ForeColor = Color.Green : CheckBox119.ForeColor = Color.Green : CheckBox118.ForeColor = Color.Green : CheckBox117.ForeColor = Color.Green
  615. CheckBox122.ForeColor = Color.Green : CheckBox120.ForeColor = Color.Green
  616. NAS帳號_tb.BackColor = Color.White : NAS帳號_tb.ForeColor = Color.Black : NAS密碼_tb.BackColor = Color.White : NAS密碼_tb.ForeColor = Color.Black
  617. 帳號_tb.BackColor = Color.White : 帳號_tb.ForeColor = Color.Black : 密碼_tb.BackColor = Color.White : 密碼_tb.ForeColor = Color.Black
  618. 語轉扭_bt.BackColor = Color.White : 語轉扭_bt.ForeColor = Color.Black : 姓名_tb.BackColor = Color.White : 姓名_tb.ForeColor = Color.Black
  619. 查詢_bt.BackColor = Color.White : 隱藏密碼_bt.BackColor = Color.White : 顯示密碼_bt.BackColor = Color.White
  620. 刪除_bt.BackColor = Color.White : 修改_bt.BackColor = Color.White : 修改1_bt.BackColor = Color.White : 確認新增_bt.BackColor = Color.White
  621. 指定預設權限_bt.BackColor = Color.White : 新增_bt.BackColor = Color.White
  622. 清單1_dgv.EnableHeadersVisualStyles = True : 清單1_dgv.BackgroundColor = Color.White : 清單1_dgv.ColumnHeadersDefaultCellStyle.ForeColor = Color.Black
  623. 清單1_dgv.DefaultCellStyle.BackColor = Color.White : 清單1_dgv.DefaultCellStyle.ForeColor = Color.Black
  624. Else
  625. Me.BackColor = Color.Black : 業務權限_tp.BackColor = Color.DimGray : 採購權限_tp.BackColor = Color.DimGray
  626. 工程權限_tp.BackColor = Color.DimGray : 倉儲權限_tp.BackColor = Color.DimGray : 財務權限_tp.BackColor = Color.DimGray
  627. 人事權限_tp.BackColor = Color.DimGray : 資料庫權限_tp.BackColor = Color.DimGray
  628. '----------------黑-------------------------------------------
  629. 小間距1_ch.ForeColor = Color.White : 中間距1_ch.ForeColor = Color.White : 大間距1_ch.ForeColor = Color.White : 姓名_lb.ForeColor = Color.White
  630. 帳號_lb.ForeColor = Color.White : 密碼_lb.ForeColor = Color.White : NAS帳號_lb.ForeColor = Color.White : NAS密碼_lb.ForeColor = Color.White
  631. 部門_lb.ForeColor = Color.White : 處別_lb.ForeColor = Color.White : 課別_lb.ForeColor = Color.White : 組別_lb.ForeColor = Color.White
  632. 職稱_lb.ForeColor = Color.White : CheckBox1.ForeColor = Color.White : CheckBox22.ForeColor = Color.White : CheckBox7.ForeColor = Color.White
  633. CheckBox9.ForeColor = Color.White : CheckBox8.ForeColor = Color.White : CheckBox6.ForeColor = Color.White : CheckBox5.ForeColor = Color.White
  634. '----------------紅-------------------------------------------
  635. CheckBox74.ForeColor = Color.LightPink : CheckBox75.ForeColor = Color.LightPink : CheckBox2.ForeColor = Color.LightPink : CheckBox45.ForeColor = Color.LightPink
  636. CheckBox84.ForeColor = Color.LightPink : CheckBox41.ForeColor = Color.LightPink : CheckBox87.ForeColor = Color.LightPink : CheckBox88.ForeColor = Color.LightPink
  637. CheckBox43.ForeColor = Color.LightPink : CheckBox10.ForeColor = Color.LightPink : CheckBox44.ForeColor = Color.LightPink : CheckBox4.ForeColor = Color.LightPink
  638. CheckBox3.ForeColor = Color.LightPink : CheckBox23.ForeColor = Color.LightPink : CheckBox24.ForeColor = Color.LightPink : CheckBox89.ForeColor = Color.LightPink
  639. CheckBox91.ForeColor = Color.LightPink : CheckBox92.ForeColor = Color.LightPink : CheckBox93.ForeColor = Color.LightPink : CheckBox94.ForeColor = Color.LightPink
  640. CheckBox95.ForeColor = Color.LightPink : CheckBox96.ForeColor = Color.LightPink : CheckBox97.ForeColor = Color.LightPink : CheckBox46.ForeColor = Color.LightPink
  641. CheckBox47.ForeColor = Color.LightPink : CheckBox48.ForeColor = Color.LightPink : CheckBox49.ForeColor = Color.LightPink : CheckBox50.ForeColor = Color.LightPink
  642. CheckBox25.ForeColor = Color.LightPink : CheckBox26.ForeColor = Color.LightPink : CheckBox27.ForeColor = Color.LightPink : CheckBox60.ForeColor = Color.LightPink
  643. CheckBox116.ForeColor = Color.LightPink : CheckBox107.ForeColor = Color.LightPink : CheckBox98.ForeColor = Color.LightPink : CheckBox101.ForeColor = Color.LightPink
  644. CheckBox103.ForeColor = Color.LightPink : CheckBox102.ForeColor = Color.LightPink : CheckBox33.ForeColor = Color.LightPink : CheckBox34.ForeColor = Color.LightPink
  645. CheckBox35.ForeColor = Color.LightPink : CheckBox90.ForeColor = Color.LightPink : CheckBox15.ForeColor = Color.LightPink : CheckBox16.ForeColor = Color.LightPink
  646. CheckBox17.ForeColor = Color.LightPink : CheckBox109.ForeColor = Color.LightPink : CheckBox108.ForeColor = Color.LightPink : CheckBox105.ForeColor = Color.LightPink
  647. CheckBox53.ForeColor = Color.LightPink : CheckBox104.ForeColor = Color.LightPink : CheckBox106.ForeColor = Color.LightPink : CheckBox110.ForeColor = Color.LightPink
  648. CheckBox54.ForeColor = Color.LightPink : CheckBox55.ForeColor = Color.LightPink : CheckBox59.ForeColor = Color.LightPink : CheckBox40.ForeColor = Color.LightPink
  649. '----------------藍-------------------------------------------
  650. CheckBox61.ForeColor = Color.LightBlue : CheckBox99.ForeColor = Color.LightBlue
  651. CheckBox62.ForeColor = Color.LightBlue : CheckBox114.ForeColor = Color.LightBlue : CheckBox52.ForeColor = Color.LightBlue : CheckBox51.ForeColor = Color.LightBlue
  652. CheckBox42.ForeColor = Color.LightBlue : CheckBox11.ForeColor = Color.LightBlue : CheckBox12.ForeColor = Color.LightBlue : CheckBox13.ForeColor = Color.LightBlue
  653. CheckBox14.ForeColor = Color.LightBlue : CheckBox100.ForeColor = Color.LightBlue : CheckBox69.ForeColor = Color.LightBlue : CheckBox70.ForeColor = Color.LightBlue
  654. CheckBox71.ForeColor = Color.LightBlue : CheckBox18.ForeColor = Color.LightBlue : CheckBox111.ForeColor = Color.LightBlue : CheckBox112.ForeColor = Color.LightBlue
  655. CheckBox113.ForeColor = Color.LightBlue : CheckBox19.ForeColor = Color.LightBlue : CheckBox21.ForeColor = Color.LightBlue : CheckBox76.ForeColor = Color.LightBlue
  656. CheckBox67.ForeColor = Color.LightBlue : CheckBox65.ForeColor = Color.LightBlue : CheckBox79.ForeColor = Color.LightBlue : CheckBox77.ForeColor = Color.LightBlue
  657. CheckBox68.ForeColor = Color.LightBlue : CheckBox66.ForeColor = Color.LightBlue : CheckBox64.ForeColor = Color.LightBlue : CheckBox78.ForeColor = Color.LightBlue
  658. CheckBox63.ForeColor = Color.LightBlue : CheckBox32.ForeColor = Color.LightBlue
  659. '----------------綠-------------------------------------------
  660. CheckBox123.ForeColor = Color.LightGreen : CheckBox124.ForeColor = Color.LightGreen : CheckBox125.ForeColor = Color.LightGreen : CheckBox126.ForeColor = Color.LightGreen
  661. CheckBox127.ForeColor = Color.LightGreen : CheckBox128.ForeColor = Color.LightGreen : CheckBox20.ForeColor = Color.LightGreen : CheckBox36.ForeColor = Color.LightGreen
  662. CheckBox73.ForeColor = Color.LightGreen : CheckBox37.ForeColor = Color.LightGreen : CheckBox38.ForeColor = Color.LightGreen : CheckBox39.ForeColor = Color.LightGreen
  663. CheckBox28.ForeColor = Color.LightGreen : CheckBox72.ForeColor = Color.LightGreen : CheckBox29.ForeColor = Color.LightGreen : CheckBox30.ForeColor = Color.LightGreen
  664. CheckBox31.ForeColor = Color.LightGreen : CheckBox82.ForeColor = Color.LightGreen : CheckBox83.ForeColor = Color.LightGreen : CheckBox81.ForeColor = Color.LightGreen
  665. CheckBox80.ForeColor = Color.LightGreen : CheckBox58.ForeColor = Color.LightGreen : CheckBox57.ForeColor = Color.LightGreen : CheckBox56.ForeColor = Color.LightGreen
  666. CheckBox86.ForeColor = Color.LightGreen : CheckBox115.ForeColor = Color.LightGreen : CheckBox85.ForeColor = Color.LightGreen
  667. CheckBox121.ForeColor = Color.LightGreen : CheckBox119.ForeColor = Color.LightGreen : CheckBox118.ForeColor = Color.LightGreen : CheckBox117.ForeColor = Color.LightGreen
  668. CheckBox122.ForeColor = Color.LightGreen : CheckBox120.ForeColor = Color.LightGreen
  669. NAS帳號_tb.BackColor = Color.DimGray : NAS帳號_tb.ForeColor = Color.White : NAS密碼_tb.BackColor = Color.DimGray : NAS密碼_tb.ForeColor = Color.White
  670. 帳號_tb.BackColor = Color.DimGray : 帳號_tb.ForeColor = Color.White : 密碼_tb.BackColor = Color.DimGray : 密碼_tb.ForeColor = Color.White
  671. 語轉扭_bt.BackColor = Color.DimGray : 語轉扭_bt.ForeColor = Color.White : 姓名_tb.BackColor = Color.DimGray : 姓名_tb.ForeColor = Color.White
  672. 查詢_bt.BackColor = Color.DimGray : 隱藏密碼_bt.BackColor = Color.DimGray : 顯示密碼_bt.BackColor = Color.DimGray
  673. 刪除_bt.BackColor = Color.DimGray : 修改_bt.BackColor = Color.DimGray : 修改1_bt.BackColor = Color.DimGray : 確認新增_bt.BackColor = Color.DimGray
  674. 指定預設權限_bt.BackColor = Color.DimGray : 新增_bt.BackColor = Color.DimGray
  675. 清單1_dgv.EnableHeadersVisualStyles = False : 清單1_dgv.BackgroundColor = Color.DimGray : 清單1_dgv.ColumnHeadersDefaultCellStyle.ForeColor = Color.White
  676. 清單1_dgv.ColumnHeadersDefaultCellStyle.BackColor = Color.Black
  677. 清單1_dgv.DefaultCellStyle.BackColor = Color.Black : 清單1_dgv.DefaultCellStyle.ForeColor = Color.White
  678. End If
  679. End Sub
  680. End Class