Sin descripción
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 23KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287
  1. Option Strict Off
  2. Imports System.IO
  3. Public Class 倉儲入庫驗收
  4. Dim 對話框(1) As String : Dim 物料規格 As String
  5. Private Sub Set_清單()
  6. Dim ds As New DataSet : 清單_dgv.DataSource = Nothing : ds.Clear()
  7. 清單_dgv.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing
  8. 清單_dgv.ColumnHeadersHeight = 40 : 清單_dgv.AllowUserToAddRows = False
  9. If 小間距_ch.Checked = False And 中間距_ch.Checked = False And 大間距_ch.Checked = True Then : 清單_dgv.RowTemplate.Height = 65
  10. ElseIf 小間距_ch.Checked = False And 中間距_ch.Checked = True And 大間距_ch.Checked = False Then : 清單_dgv.RowTemplate.Height = 45
  11. ElseIf 小間距_ch.Checked = True And 中間距_ch.Checked = False And 大間距_ch.Checked = False Then : 清單_dgv.RowTemplate.Height = 25 : End If
  12. SQL_倉儲入庫驗收_清單()
  13. da.Fill(ds) : 清單_dgv.DataSource = ds.Tables(0) : conn.Close()
  14. If 低網速模式 = False Then
  15. 清單_dgv.Columns(25).FillWeight = 60 : 清單_dgv.Columns(25).Visible = True
  16. Dim mycol As DataGridViewImageColumn = 清單_dgv.Columns("Image")
  17. mycol.ImageLayout = DataGridViewImageCellLayout.Zoom
  18. Else : If 清單_dgv.Columns.Count = 26 Then : 清單_dgv.Columns(25).Visible = False : End If : End If
  19. 清單_dgv.Columns(0).Visible = False : 清單_dgv.Columns(1).FillWeight = 120 : 清單_dgv.Columns(2).Visible = False : 清單_dgv.Columns(3).FillWeight = 100
  20. 清單_dgv.Columns(4).Visible = False : 清單_dgv.Columns(5).FillWeight = 276 : 清單_dgv.Columns(6).FillWeight = 276 : 清單_dgv.Columns(7).FillWeight = 80
  21. 清單_dgv.Columns(8).Visible = False : 清單_dgv.Columns(9).FillWeight = 90 : 清單_dgv.Columns(10).FillWeight = 150 : 清單_dgv.Columns(11).FillWeight = 90
  22. 清單_dgv.Columns(12).FillWeight = 150 : 清單_dgv.Columns(13).Visible = False : 清單_dgv.Columns(14).Visible = False : 清單_dgv.Columns(15).Visible = False
  23. 清單_dgv.Columns(16).Visible = False : 清單_dgv.Columns(17).Visible = False : 清單_dgv.Columns(18).Visible = False : 清單_dgv.Columns(19).FillWeight = 80
  24. 清單_dgv.Columns(20).Visible = False : 清單_dgv.Columns(21).Visible = False : 清單_dgv.Columns(22).Visible = False : 清單_dgv.Columns(23).Visible = False
  25. 清單_dgv.Columns(7).DefaultCellStyle.Format = "#,##0"
  26. 清單_dgv.Columns(7).DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter
  27. 清單_dgv.Columns(7).HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter
  28. For i As Integer = 0 To 清單_dgv.Rows.Count - 1
  29. 資料數 = 清單_dgv.Rows.Count : MyMod.進度條()
  30. 清單_dgv.Rows(i).Cells(表頭(44)).Value = False : PA3 = 清單_dgv.Rows(i).Cells("規格庫抬頭指定").Value
  31. If i = 0 Then : SQL_規格庫抬頭讀取()
  32. If dr.Read() Then
  33. AAA1 = dr("A1") : AAA2 = dr("A2") : AAA3 = dr("A3") : AAA4 = dr("A4") : AAA5 = dr("A5") : AAA6 = dr("A6") : AAA7 = dr("A7") : AAA8 = dr("A8")
  34. End If : conn.Close()
  35. Else
  36. If 清單_dgv.Rows(i).Cells("規格庫抬頭指定").Value.ToString <> 清單_dgv.Rows(i - 1).Cells("規格庫抬頭指定").Value.ToString Then
  37. SQL_規格庫抬頭讀取()
  38. If dr.Read() Then
  39. AAA1 = dr("A1") : AAA2 = dr("A2") : AAA3 = dr("A3") : AAA4 = dr("A4") : AAA5 = dr("A5") : AAA6 = dr("A6") : AAA7 = dr("A7") : AAA8 = dr("A8")
  40. End If : conn.Close()
  41. End If
  42. End If
  43. Dim ds3 As New DataSet : 規格合併_dgv.DataSource = Nothing : ds3.Clear() : PA4 = 清單_dgv.Rows(i).Cells("料號").Value
  44. SQL_規格庫抬頭讀取二()
  45. da.Fill(ds3) : 規格合併_dgv.DataSource = ds3.Tables(0) : conn.Close()
  46. Dim ZA1, ZA2, ZA3, ZA4, ZA5, ZA6, ZA7, ZA8 As String : 物料規格 = ""
  47. If 詳細資料2_ch.Checked = True Then
  48. If 規格合併_dgv.Rows(0).Cells("A1").Value.ToString <> "" Then
  49. ZA1 = AAA1 & "=" & 規格合併_dgv.Rows(0).Cells("A1").Value.ToString : 物料規格 = ZA1 : End If
  50. If 規格合併_dgv.Rows(0).Cells("A2").Value.ToString <> "" Then : ZA2 = AAA2 & "=" & 規格合併_dgv.Rows(0).Cells("A2").Value
  51. If 物料規格 = "" Then : 物料規格 = ZA2 : Else : 物料規格 = 物料規格 + "、" + ZA2 : End If : End If
  52. If 規格合併_dgv.Rows(0).Cells("A3").Value.ToString <> "" Then : ZA3 = AAA3 & "=" & 規格合併_dgv.Rows(0).Cells("A3").Value
  53. If 物料規格 = "" Then : 物料規格 = ZA3 : Else : 物料規格 = 物料規格 + "、" + ZA3 : End If : End If
  54. If 規格合併_dgv.Rows(0).Cells("A4").Value.ToString <> "" Then : ZA4 = AAA4 & "=" & 規格合併_dgv.Rows(0).Cells("A4").Value
  55. If 物料規格 = "" Then : 物料規格 = ZA4 : Else : 物料規格 = 物料規格 + "、" + ZA4 : End If : End If
  56. If 規格合併_dgv.Rows(0).Cells("A5").Value.ToString <> "" Then : ZA5 = AAA5 & "=" & 規格合併_dgv.Rows(0).Cells("A5").Value
  57. If 物料規格 = "" Then : 物料規格 = ZA5 : Else : 物料規格 = 物料規格 + "、" + ZA5 : End If : End If
  58. If 規格合併_dgv.Rows(0).Cells("A6").Value.ToString <> "" Then : ZA6 = AAA6 & "=" & 規格合併_dgv.Rows(0).Cells("A6").Value
  59. If 物料規格 = "" Then : 物料規格 = ZA6 : Else : 物料規格 = 物料規格 + "、" + ZA6 : End If : End If
  60. If 規格合併_dgv.Rows(0).Cells("A7").Value.ToString <> "" Then : ZA7 = AAA7 & "=" & 規格合併_dgv.Rows(0).Cells("A7").Value
  61. If 物料規格 = "" Then : 物料規格 = ZA7 : Else : 物料規格 = 物料規格 + "、" + ZA7 : End If : End If
  62. If 規格合併_dgv.Rows(0).Cells("A8").Value.ToString <> "" Then : ZA8 = AAA8 & "=" & 規格合併_dgv.Rows(0).Cells("A8").Value
  63. If 物料規格 = "" Then : 物料規格 = ZA8 : Else : 物料規格 = 物料規格 + "、" + ZA8 : End If : End If
  64. Else
  65. If 規格合併_dgv.Rows(0).Cells("A1").Value.ToString <> "" Then : ZA1 = 規格合併_dgv.Rows(0).Cells("A1").Value.ToString : 物料規格 = ZA1 : End If
  66. If 規格合併_dgv.Rows(0).Cells("A2").Value.ToString <> "" Then
  67. ZA2 = 規格合併_dgv.Rows(0).Cells("A2").Value : If 物料規格 = "" Then : 物料規格 = ZA2 : Else : 物料規格 = 物料規格 + "、" + ZA2 : End If : End If
  68. If 規格合併_dgv.Rows(0).Cells("A3").Value.ToString <> "" Then
  69. ZA3 = 規格合併_dgv.Rows(0).Cells("A3").Value : If 物料規格 = "" Then : 物料規格 = ZA3 : Else : 物料規格 = 物料規格 + "、" + ZA3 : End If : End If
  70. If 規格合併_dgv.Rows(0).Cells("A4").Value.ToString <> "" Then
  71. ZA4 = 規格合併_dgv.Rows(0).Cells("A4").Value : If 物料規格 = "" Then : 物料規格 = ZA4 : Else : 物料規格 = 物料規格 + "、" + ZA4 : End If : End If
  72. If 規格合併_dgv.Rows(0).Cells("A5").Value.ToString <> "" Then
  73. ZA5 = 規格合併_dgv.Rows(0).Cells("A5").Value : If 物料規格 = "" Then : 物料規格 = ZA5 : Else : 物料規格 = 物料規格 + "、" + ZA5 : End If : End If
  74. If 規格合併_dgv.Rows(0).Cells("A6").Value.ToString <> "" Then
  75. ZA6 = 規格合併_dgv.Rows(0).Cells("A6").Value : If 物料規格 = "" Then : 物料規格 = ZA6 : Else : 物料規格 = 物料規格 + "、" + ZA6 : End If : End If
  76. If 規格合併_dgv.Rows(0).Cells("A7").Value.ToString <> "" Then
  77. ZA7 = 規格合併_dgv.Rows(0).Cells("A7").Value : If 物料規格 = "" Then : 物料規格 = ZA7 : Else : 物料規格 = 物料規格 + "、" + ZA7 : End If : End If
  78. If 規格合併_dgv.Rows(0).Cells("A8").Value.ToString <> "" Then
  79. ZA8 = 規格合併_dgv.Rows(0).Cells("A8").Value : If 物料規格 = "" Then : 物料規格 = ZA8 : Else : 物料規格 = 物料規格 + "、" + ZA8 : End If : End If
  80. End If
  81. 清單_dgv.Rows(i).Cells(表頭(13)).Value = 物料規格
  82. Next i : HX_PGS_ERP_SYS.ToolStripProgressBar1.Value = 0 : 最終數 = 0
  83. End Sub
  84. Private Sub 指定倉庫_cb_下拉表單資料載入()
  85. SQL_倉儲分區控制表_倉級指定倉名() : 指定倉庫_cb.Items.Clear() : While (dr.Read()) : 指定倉庫_cb.Items.Add(dr("倉名")) : End While : conn.Close()
  86. End Sub
  87. Private Sub 語言轉換讀取()
  88. If 系統語言 = "繁體中文" Then : 語言 = "CH" : ElseIf 系統語言 = "English" Then : 語言 = "EN" : ElseIf 系統語言 = "Indonesian" Then : 語言 = "IN" : End If
  89. Me.Text = 系統語言字典("H001-223-" & 語言) : ToolTip1.ToolTipTitle = 系統語言字典("G000-108-" & 語言)
  90. 入庫單號_lb.Text = 系統語言字典("H502-100-" & 語言) : 全部取消_tsm.Text = 系統語言字典("H502-101-" & 語言) : 全部選擇_tsm.Text = 系統語言字典("H502-102-" & 語言)
  91. 同級別全資料_ch.Text = 系統語言字典("H502-103-" & 語言) : 依據入庫單號全部選擇_tsm.Text = 系統語言字典("H502-104-" & 語言)
  92. 指定倉庫_lb.Text = 系統語言字典("H502-105-" & 語言) : 重新整理_tsm.Text = 系統語言字典("H502-106-" & 語言)
  93. 表頭(45) = 系統語言字典("H502-107-" & 語言) : 表頭(71) = 系統語言字典("H502-108-" & 語言) : 表頭(12) = 系統語言字典("H502-109-" & 語言)
  94. 表頭(48) = 系統語言字典("H502-110-" & 語言) : 表頭(47) = 系統語言字典("H502-111-" & 語言) : 表頭(24) = 系統語言字典("H502-112-" & 語言)
  95. 表頭(13) = 系統語言字典("H502-113-" & 語言) : 表頭(14) = 系統語言字典("H502-114-" & 語言) : 表頭(16) = 系統語言字典("H502-115-" & 語言)
  96. 表頭(44) = 系統語言字典("H502-116-" & 語言) : 對話框(0) = 系統語言字典("H502-117-" & 語言) : 確認收料入庫_tsm.Text = 系統語言字典("H502-118-" & 語言)
  97. 詳細資料2_ch.Text = 系統語言字典("H502-119-" & 語言) : 對話框(1) = 系統語言字典("H502-120-" & 語言)
  98. End Sub
  99. Private Sub 確認收料入庫_bt_MouseEnter(sender As Object, e As EventArgs) Handles 確認收料入庫_bt.MouseEnter
  100. ToolTip1.SetToolTip(Me.確認收料入庫_bt, 系統語言字典("H512-121-" & 語言))
  101. End Sub
  102. Private Sub 依據入庫單號全部選擇_bt_MouseEnter(sender As Object, e As EventArgs) Handles 依據入庫單號全部選擇_bt.MouseEnter
  103. ToolTip1.SetToolTip(Me.依據入庫單號全部選擇_bt, 系統語言字典("H502-104-" & 語言))
  104. End Sub
  105. Private Sub 全部選擇_bt_MouseEnter(sender As Object, e As EventArgs) Handles 全部選擇_bt.MouseEnter
  106. ToolTip1.SetToolTip(Me.全部選擇_bt, 系統語言字典("G000-115-" & 語言))
  107. End Sub
  108. Private Sub 全部取消_bt_MouseEnter(sender As Object, e As EventArgs) Handles 全部取消_bt.MouseEnter
  109. ToolTip1.SetToolTip(Me.全部取消_bt, 系統語言字典("G000-116-" & 語言))
  110. End Sub
  111. Private Sub 切換倉庫級別_bt_MouseEnter(sender As Object, e As EventArgs) Handles 切換倉庫級別_bt.MouseEnter
  112. ToolTip1.SetToolTip(Me.切換倉庫級別_bt, 系統語言字典("H502-121-" & 語言))
  113. End Sub
  114. Private Sub 倉儲入庫驗收_Load(sender As Object, e As EventArgs) Handles MyBase.Load
  115. Me.MdiParent = HX_PGS_ERP_SYS : Me.WindowState = 2 : Me.AutoScroll = True
  116. 風格() : H(502) = True : 介面 = "H502" : 語言轉換讀取() : 顯示說明(999, True)
  117. SQL_清單欄位查詢()
  118. If Acdr.Read() Then
  119. 小間距_ch.Checked = Acdr("L_1_1") : 中間距_ch.Checked = Acdr("L_2_1") : 大間距_ch.Checked = Acdr("L_3_1")
  120. End If : Access1.Close()
  121. 規格合併_dgv.Visible = False : Panel1.SendToBack()
  122. 指定倉庫_cb_下拉表單資料載入() : 同級別全資料_ch.Checked = True
  123. 倉儲入庫驗收_Size()
  124. End Sub
  125. Private Sub 倉儲入庫驗收_SizeChanged(sender As Object, e As EventArgs) Handles MyBase.SizeChanged
  126. 倉儲入庫驗收_Size()
  127. End Sub
  128. Private Sub 倉儲入庫驗收_Size()
  129. MyMod.清單字體大小調整()
  130. 清單_dgv.RowsDefaultCellStyle.Font = New System.Drawing.Font("微軟正黑體", HX_PGS_ERP_SYS.字體_NUD.Value)
  131. End Sub
  132. Private Sub 倉儲入庫驗收_Closed(sender As Object, e As EventArgs) Handles MyBase.Closed
  133. H(502) = False : MyMod.虛擬桌面開啟()
  134. End Sub
  135. Private Sub 語轉扭_bt_Click(sender As Object, e As EventArgs) Handles 語轉扭_bt.Click
  136. 介面 = "H502" : 語言轉換讀取() : Set_清單()
  137. End Sub
  138. Private Sub 登入閒置控制_MouseMove(sender As Object, e As EventArgs) Handles MyBase.MouseMove
  139. timeNow = 0 : HX_PGS_ERP_SYS.Timer1.Enabled = False : HX_PGS_ERP_SYS.Timer1.Enabled = True
  140. End Sub
  141. Private Sub 登入閒置控制_KeyPress(sender As Object, e As EventArgs) Handles MyBase.KeyPress
  142. timeNow = 0 : HX_PGS_ERP_SYS.Timer1.Enabled = False : HX_PGS_ERP_SYS.Timer1.Enabled = True
  143. End Sub
  144. Private Sub 清單_dgv_CellClick(ByVal sender As System.Object, ByVal e As DataGridViewCellEventArgs) Handles 清單_dgv.CellClick
  145. If e.RowIndex = -1 Then : Else
  146. 入庫單號_tb.Text = 清單_dgv.Rows(e.RowIndex).Cells("" & 表頭(47) & "").Value : 圖片檔1_pb.Image = Nothing
  147. PA2 = 清單_dgv.Rows(e.RowIndex).Cells("料號原則").Value : SQL_物料圖庫_圖檔讀取一()
  148. While dr.Read() = True
  149. Dim unused As Byte() = New Byte(-1) {}
  150. Dim bytes As Byte() = DirectCast(dr.Item("圖檔"), Byte())
  151. Dim oStream As New MemoryStream(bytes)
  152. 圖片檔1_pb.Image = Bitmap.FromStream(oStream)
  153. End While : conn.Close() : 圖片檔1_pb.SizeMode = 4
  154. End If
  155. If 清單_dgv(表頭(44), e.RowIndex).Value = True Then : 清單_dgv(表頭(44), e.RowIndex).Value = False
  156. Else : 清單_dgv(表頭(44), e.RowIndex).Value = True : End If
  157. End Sub
  158. Private Sub 清單_dgv_RowPostPaint(ByVal sender As Object, ByVal e As DataGridViewRowPostPaintEventArgs) Handles 清單_dgv.RowPostPaint
  159. Dim linePen As New Pen(Color.Blue, 2)
  160. If e.RowIndex = 清單_dgv.Rows.Count - 1 Then : Exit Sub : Else
  161. If 清單_dgv(1, e.RowIndex).Value.ToString <> 清單_dgv(1, e.RowIndex + 1).Value.ToString Then
  162. Dim startX As Integer = IIf(清單_dgv.RowHeadersVisible, 清單_dgv.RowHeadersWidth, 0)
  163. Dim startY As Integer = e.RowBounds.Top + e.RowBounds.Height - 1
  164. Dim endX As Integer = startX + 清單_dgv.Columns.GetColumnsWidth(DataGridViewElementStates.Visible) - 清單_dgv.HorizontalScrollingOffset
  165. e.Graphics.DrawLine(linePen, startX, startY, endX, startY)
  166. Exit Sub
  167. End If
  168. End If
  169. End Sub
  170. Private Sub 指定倉庫_cb_SelectedIndexChanged(sender As Object, e As EventArgs) Handles 指定倉庫_cb.SelectedIndexChanged
  171. Set_清單()
  172. End Sub
  173. Private Sub 指定倉庫_cb_Click(sender As Object, e As EventArgs) Handles 指定倉庫_cb.Click
  174. CB選擇清單(指定倉庫_cb, 指定倉庫_cb.Text)
  175. End Sub
  176. Private Sub 同級別全資料_ch_CheckedChanged(sender As Object, e As EventArgs) Handles 同級別全資料_ch.CheckedChanged
  177. Set_清單()
  178. End Sub
  179. Private Sub Set_日期格式轉換()
  180. DTP = Format(Today(), "yyyy/MM/dd")
  181. End Sub
  182. Private Sub 確認收料入庫_bt_Click(sender As Object, e As EventArgs) Handles 確認收料入庫_bt.Click
  183. Dim cc As Boolean = False
  184. For i As Integer = 0 To 清單_dgv.Rows.Count - 1 : If 清單_dgv.Rows(i).Cells(表頭(44)).Value = True Then : cc = True : Exit For : End If : Next
  185. If cc = False Then : MGB(對話框(1), 1) : Else
  186. Set_日期格式轉換()
  187. For i As Integer = 0 To 清單_dgv.Rows.Count - 1
  188. 資料數 = 清單_dgv.Rows.Count : MyMod.進度條()
  189. If 清單_dgv.Rows(i).Cells(表頭(44)).Value = True Then
  190. PA8 = 清單_dgv.Rows(i).Cells("" & 表頭(24) & "").Value : PA9 = 清單_dgv.Rows(i).Cells("料號").Value : SQL_採購單明細表_已入庫() : conn.Close()
  191. End If
  192. If 清單_dgv.Rows(i).Cells(表頭(44)).Value = True Then
  193. PA8 = 清單_dgv.Rows(i).Cells("資料流水號").Value : SQL_倉儲明細表_倉庫作業() : conn.Close()
  194. End If
  195. Next : Set_清單() : MGB(對話框(0), 1) : HX_PGS_ERP_SYS.ToolStripProgressBar1.Value = 0 : 最終數 = 0
  196. End If
  197. End Sub
  198. Private Sub 全部選擇_bt_Click(sender As Object, e As EventArgs) Handles 全部選擇_bt.Click
  199. For i As Integer = 0 To 清單_dgv.Rows.Count - 1 : 清單_dgv.Rows(i).Cells(表頭(44)).Value = True : Next i
  200. End Sub
  201. Private Sub 全部取消_bt_Click(sender As Object, e As EventArgs) Handles 全部取消_bt.Click
  202. For i As Integer = 0 To 清單_dgv.Rows.Count - 1 : 清單_dgv.Rows(i).Cells(表頭(44)).Value = False : Next i
  203. End Sub
  204. Private Sub 切換倉庫級別_bt_Click(sender As Object, e As EventArgs) Handles 切換倉庫級別_bt.Click
  205. 倉儲分區選擇.ShowDialog() : 指定倉庫_cb_下拉表單資料載入() : Set_清單()
  206. End Sub
  207. Private Sub 依據入庫單號全部選擇_bt_Click(sender As Object, e As EventArgs) Handles 依據入庫單號全部選擇_bt.Click
  208. 依據入庫單號全部選擇_tsm.PerformClick()
  209. End Sub
  210. Private Sub 小間距_ch_CheckedChanged(sender As Object, e As EventArgs) Handles 小間距_ch.Click
  211. 小間距_ch.Checked = True : 中間距_ch.Checked = False : 大間距_ch.Checked = False : MyMod.間距設定存檔_1() : Set_清單()
  212. End Sub
  213. Private Sub 中間距_ch_CheckedChanged(sender As Object, e As EventArgs) Handles 中間距_ch.Click
  214. 小間距_ch.Checked = False : 中間距_ch.Checked = True : 大間距_ch.Checked = False : MyMod.間距設定存檔_2() : Set_清單()
  215. End Sub
  216. Private Sub 大間距_ch_CheckedChanged(sender As Object, e As EventArgs) Handles 大間距_ch.Click
  217. 小間距_ch.Checked = False : 中間距_ch.Checked = False : 大間距_ch.Checked = True : MyMod.間距設定存檔_3() : Set_清單()
  218. End Sub
  219. Private Sub 圖片檔1_pb_Click(sender As Object, e As EventArgs) Handles 圖片檔1_pb.Click
  220. If IsNothing(圖片檔1_pb.Image) = False Then : 圖片傳遞 = 圖片檔1_pb.Image : 圖片放大視窗.ShowDialog() : End If
  221. End Sub
  222. Private Sub 詳細資料2_ch_CheckedChanged(sender As Object, e As EventArgs) Handles 詳細資料2_ch.Click
  223. If 詳細資料2_ch.Checked = True Then : 詳細資料2_ch.Checked = True : Else : 詳細資料2_ch.Checked = False : End If : Set_清單()
  224. End Sub
  225. '-----------------------------滑鼠右鍵--------------------------------------------------------------------------------------------------------------------------------------
  226. Private Sub 重新整理_tsm_Click(sender As Object, e As EventArgs) Handles 重新整理_tsm.Click
  227. Set_清單()
  228. End Sub
  229. Private Sub 確認收料入庫_tsm_Click(sender As Object, e As EventArgs) Handles 確認收料入庫_tsm.Click
  230. Me.確認收料入庫_bt.PerformClick()
  231. End Sub
  232. Private Sub 全部選擇_tsm_Click(sender As Object, e As EventArgs) Handles 全部選擇_tsm.Click
  233. Me.全部選擇_bt.PerformClick()
  234. End Sub
  235. Private Sub 全部取消_tsm_Click(sender As Object, e As EventArgs) Handles 全部取消_tsm.Click
  236. Me.全部取消_bt.PerformClick()
  237. End Sub
  238. Private Sub 依據入庫單號全部選擇_tsm_Click(sender As Object, e As EventArgs) Handles 依據入庫單號全部選擇_tsm.Click
  239. For i As Integer = 0 To 清單_dgv.Rows.Count - 1
  240. If 入庫單號_tb.Text = 清單_dgv.Rows(i).Cells("" & 表頭(47) & "").Value.ToString Then : 清單_dgv.Rows(i).Cells(表頭(44)).Value = True : End If
  241. Next i
  242. End Sub
  243. Private Sub 風格()
  244. If 深色風格 = False Then
  245. Me.BackColor = SystemColors.Control
  246. 同級別全資料_ch.ForeColor = Color.Black : 入庫單號_lb.ForeColor = Color.Black : 指定倉庫_lb.ForeColor = Color.Black
  247. 詳細資料2_ch.ForeColor = Color.Black : 小間距_ch.ForeColor = Color.Black : 中間距_ch.ForeColor = Color.Black : 大間距_ch.ForeColor = Color.Black
  248. 入庫單號_tb.BackColor = Color.White : 入庫單號_tb.ForeColor = Color.Black : 語轉扭_bt.BackColor = Color.White : 語轉扭_bt.ForeColor = Color.Black
  249. 指定倉庫_cb.BackColor = Color.White : 指定倉庫_cb.ForeColor = Color.Black
  250. 確認收料入庫_bt.BackColor = Color.White : 依據入庫單號全部選擇_bt.BackColor = Color.White : 全部選擇_bt.BackColor = Color.White : 全部取消_bt.BackColor = Color.White
  251. 切換倉庫級別_bt.BackColor = Color.White
  252. 清單_dgv.EnableHeadersVisualStyles = True : 清單_dgv.BackgroundColor = Color.White : 清單_dgv.ColumnHeadersDefaultCellStyle.ForeColor = Color.Black
  253. 清單_dgv.AlternatingRowsDefaultCellStyle.BackColor = Color.LightPink
  254. 清單_dgv.DefaultCellStyle.BackColor = Color.White : 清單_dgv.DefaultCellStyle.ForeColor = Color.Black
  255. Else
  256. Me.BackColor = Color.Black
  257. 同級別全資料_ch.ForeColor = Color.White : 入庫單號_lb.ForeColor = Color.White : 指定倉庫_lb.ForeColor = Color.White
  258. 詳細資料2_ch.ForeColor = Color.White : 小間距_ch.ForeColor = Color.White : 中間距_ch.ForeColor = Color.White : 大間距_ch.ForeColor = Color.White
  259. 入庫單號_tb.BackColor = Color.DimGray : 入庫單號_tb.ForeColor = Color.White : 語轉扭_bt.BackColor = Color.DimGray : 語轉扭_bt.ForeColor = Color.White
  260. 指定倉庫_cb.BackColor = Color.DimGray : 指定倉庫_cb.ForeColor = Color.White
  261. 確認收料入庫_bt.BackColor = Color.DimGray : 依據入庫單號全部選擇_bt.BackColor = Color.DimGray : 全部選擇_bt.BackColor = Color.DimGray : 全部取消_bt.BackColor = Color.DimGray
  262. 切換倉庫級別_bt.BackColor = Color.DimGray
  263. 清單_dgv.EnableHeadersVisualStyles = False : 清單_dgv.BackgroundColor = Color.DimGray : 清單_dgv.ColumnHeadersDefaultCellStyle.ForeColor = Color.White
  264. 清單_dgv.ColumnHeadersDefaultCellStyle.BackColor = Color.Black : 清單_dgv.AlternatingRowsDefaultCellStyle.BackColor = Color.DimGray
  265. 清單_dgv.DefaultCellStyle.BackColor = Color.Black : 清單_dgv.DefaultCellStyle.ForeColor = Color.White
  266. End If
  267. End Sub
  268. End Class