Aucune description
Vous ne pouvez pas sélectionner plus de 25 sujets Les noms de sujets doivent commencer par une lettre ou un nombre, peuvent contenir des tirets ('-') et peuvent comporter jusqu'à 35 caractères.

財務_選擇帳本.vb 2.3KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253
  1. Public Class 財務_選擇帳本
  2. Private Sub Set_清單()
  3. Dim ds1 As New DataSet
  4. 清單_dgv.DataSource = Nothing : ds1.Clear() : 清單_dgv.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing
  5. 清單_dgv.ColumnHeadersHeight = 25 : 清單_dgv.AllowUserToAddRows = False : 清單_dgv.RowTemplate.Height = 30
  6. SQL_多帳本選擇()
  7. da.Fill(ds1) : 清單_dgv.DataSource = ds1.Tables(0) : conn.Close()
  8. 清單_dgv.Columns("帳本").ReadOnly = True
  9. If PA45 = "全部" Then
  10. For i As Integer = 0 To 清單_dgv.Rows.Count - 1
  11. 清單_dgv.Rows(i).Cells("選擇").Value = True
  12. Next
  13. Else
  14. For i As Integer = 0 To 清單_dgv.Rows.Count - 1
  15. For j As Integer = 0 To 清單_dgv.Rows.Count - 1
  16. If 清單_dgv.Rows(i).Cells("帳本").Value = 帳本內容(j) Then
  17. 清單_dgv.Rows(i).Cells("選擇").Value = True
  18. End If
  19. Next
  20. Next
  21. End If
  22. End Sub
  23. Private Sub 財務_選擇帳本_Load(sender As Object, e As EventArgs) Handles MyBase.Load
  24. Set_清單() : 帳本數量 = 0
  25. End Sub
  26. Private Sub 確認_bt_Click(sender As Object, e As EventArgs) Handles 確認_bt.Click
  27. For i As Integer = 1 To 99 : 帳本內容(i) = "" : Next
  28. Dim s As Integer = 1
  29. For i As Integer = 0 To 清單_dgv.Rows.Count - 1
  30. If 清單_dgv.Rows(i).Cells("選擇").Value = True Then
  31. 帳本數量 += 1
  32. 帳本內容(s) = 清單_dgv.Rows(i).Cells("帳本").Value.ToString
  33. s += 1
  34. End If
  35. Next
  36. If 清單_dgv.Rows.Count = 帳本數量 Then
  37. 全 = True
  38. Else
  39. 全 = False
  40. End If
  41. Me.Close()
  42. End Sub
  43. Private Sub 全部選擇_bt_Click(sender As Object, e As EventArgs) Handles 全部選擇_bt.Click
  44. For i As Integer = 0 To 清單_dgv.Rows.Count - 1 : 清單_dgv.Rows(i).Cells("選擇").Value = True : Next
  45. End Sub
  46. Private Sub 全部取消_bt_Click(sender As Object, e As EventArgs) Handles 全部取消_bt.Click
  47. For i As Integer = 0 To 清單_dgv.Rows.Count - 1 : 清單_dgv.Rows(i).Cells("選擇").Value = False : Next
  48. End Sub
  49. End Class