Nessuna descrizione
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.

GCM-CPV-ERP-SYS.vb 20KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271
  1. Imports System.IO
  2. Public Class ICS_ASMS_ERP_SYS
  3. Dim 系統關閉 As Boolean = False
  4. Private Sub ICS_ASMS_ERP_SYS_FormClosed(sender As Object, e As FormClosedEventArgs) Handles MyBase.FormClosed
  5. Dim pdfFolderPath As String = Path.Combine(Application.StartupPath, "pdf") ' 設定您的 PDF 資料夾路徑
  6. If Directory.Exists(pdfFolderPath) Then ' 檢查資料夾是否存在
  7. Try ' 獲取資料夾中的所有檔案
  8. Dim asd As String() = Directory.GetFiles(pdfFolderPath) ' 一一刪除檔案
  9. For Each qwe In asd : File.Delete(qwe) : Next
  10. Catch ex As Exception ' 處理刪除檔案時的例外
  11. Console.WriteLine($"無法刪除檔案: {ex.Message}")
  12. End Try
  13. End If
  14. End Sub
  15. Private Sub ICS_ASMS_ERP_SYS_Load(sender As Object, e As EventArgs) Handles MyBase.Load
  16. Dim pdfFolderPath As String = Path.Combine(Application.StartupPath, "pdf") ' 檢查資料夾是否存在
  17. If Directory.Exists(pdfFolderPath) Then
  18. Try ' 獲取資料夾中的所有檔案
  19. Dim asd As String() = Directory.GetFiles(pdfFolderPath) ' 一一刪除檔案
  20. For Each qwe In asd : File.Delete(qwe) : Next
  21. Catch ex As Exception ' 處理刪除檔案時的例外
  22. Console.WriteLine($"無法刪除檔案: {ex.Message}")
  23. End Try
  24. End If
  25. SQL_取得主頁圖檔()
  26. ' 設置開始時間
  27. Dim startTime As DateTime = DateTime.Now
  28. Dim timeOut As TimeSpan = TimeSpan.FromSeconds(10) ' 設置10秒超時時間
  29. While dr.Read() = True
  30. ' 檢查是否超時
  31. If DateTime.Now - startTime > timeOut Then
  32. Exit While ' 超時,跳出循環
  33. End If
  34. Dim unused As Byte() = New Byte(-1) {}
  35. Dim bytes As Byte() = DirectCast(dr.Item("簽名檔圖片"), Byte())
  36. Dim oStream As New MemoryStream(bytes)
  37. Me.BackgroundImage = Bitmap.FromStream(oStream)
  38. End While
  39. 廟 = CC(105) : 公司 = CC(106)
  40. '------------------------工程管理系統---------------------------------------------------------------------------------------------------------------------------------------------------
  41. 公函與簽呈_tsm.Visible = CC(8) : 公函_tsm.Visible = CC(67) : 簽呈_tsm.Visible = CC(68) : 疏文_tsm.Visible = CC(108)
  42. 公告_tsm.Visible = CC(109) : 文件_tsm.Visible = CC(110)
  43. '------------------------財務管理系統---------------------------------------------------------------------------------------------------------------------------------------------------
  44. If CC(91) = False And CC(92) = False And CC(93) = False And CC(94) = False And CC(95) = False And CC(96) = False And CC(97) = False Then
  45. 財務管理系統_tsm.Visible = False
  46. End If
  47. 財務收支單申請_tsm.Visible = CC(91) : 財務收支單審核_tsm.Visible = CC(92) : 財務收支單一覽表_tsm.Visible = CC(93) : 財務收支單對帳表_tsm.Visible = CC(94)
  48. 財務收支決算表_tsm.Visible = CC(95) : 匯率管理_tsm.Visible = CC(96) : 會計科目管理_tsm.Visible = CC(97) : 流動資產申請_tsm.Visible = CC(91)
  49. If CC(96) = False And CC(97) = False Then : ToolStripSeparator10.Visible = False : End If
  50. If CC(94) = False And CC(95) = False Then : ToolStripSeparator9.Visible = False : End If
  51. '------------------------採購管理系統---------------------------------------------------------------------------------------------------------------------------------------------------
  52. 採購管理系統_tsm.Visible = CC(11) : 採購對帳表_tsm.Visible = CC(65)
  53. '------------------------業務管理系統---------------------------------------------------------------------------------------------------------------------------------------------------
  54. 業務系統管理_tsm.Visible = CC(99) : 車輛銷售管理_tsm.Visible = CC(64) : 車輛銷售報表_tsm.Visible = CC(63) : 估價單_tsm.Visible = CC(62)
  55. '------------------------倉儲管理系統---------------------------------------------------------------------------------------------------------------------------------------------------
  56. 倉儲管理系統_tsm.Visible = CC(70) : 倉儲控制表_tsm.Visible = CC(46) : 物料入庫系統_tsm.Visible = CC(66)
  57. '------------------------資料庫管理系統-------------------------------------------------------------------------------------------------------------------------------------------------
  58. 資料庫系統管理_tsm.Visible = CC(1) : 簽名檔管理_tsm.Visible = CC(21)
  59. 系統使用者管理_tsm.Visible = CC(2) : 系統權限預設表_tsm.Visible = CC(84) : 系統組織架構設定_tsm.Visible = CC(41) : 部門權限設定_tsm.Visible = CC(87)
  60. 系統通用變數管理_tsm.Visible = CC(43) : 系統編碼規則_tsm.Visible = CC(10) : 系統對應電腦註冊_tsm.Visible = CC(44) : 系統執行檔版本管理_tsm.Visible = CC(4)
  61. '------------------------信眾管理系統-------------------------------------------------------------------------------------------------------------------------------------------------
  62. 信眾管理系統_tsm.Visible = CC(22) : 信眾資料表_tsm.Visible = CC(23) : 點燈系統_tsm.Visible = CC(24)
  63. 燈位基本資料_tsm.Visible = CC(24) : 自動點燈_tsm.Visible = CC(24)
  64. If gUserName = "李協叡" Then : 感謝狀_tsm.Visible = True : Else : 感謝狀_tsm.Visible = False : End If
  65. '------------------------人事管理系統-------------------------------------------------------------------------------------------------------------------------------------------------
  66. 人事管理系統_tsm.Visible = CC(114) : 考勤文件導入_tsm.Visible = CC(18) : 薪資試算表_tsm.Visible = CC(32) : 拆帳制薪資彙總表_tsm.Visible = CC(32)
  67. '----
  68. 載入系統語言()
  69. Dim filePath As String = Path.Combine(Application.StartupPath, "NOTAUTO.txt")
  70. If File.Exists(filePath) Then
  71. Me.Text = "GF" & 資料庫編號 & "-ERP-SYS 版本號 : " & 版本
  72. Else
  73. Me.Text = "GF" & 資料庫編號 & "-ERP-SYS Line : M"
  74. End If
  75. End Sub
  76. Private Sub ICS_ASMS_ERP_SYS_Unload(sender As Object, e As EventArgs) Handles MyBase.Closing
  77. 系統關閉 = True : If 判斷重登 = True Then : 判斷重登 = False : Else : 判斷重登 = False : 系統選擇.Close() : End If
  78. 登入畫面.Close()
  79. End Sub
  80. '-------------系統語言---------------------------------------------------------------------------------------------------------------------------
  81. Private Sub 載入系統語言()
  82. If 系統語言 = "Indonesian" Then : ElseIf 系統語言 = "繁體中文" Then : End If
  83. End Sub
  84. Private Sub 重置()
  85. 首次開啟 = True
  86. BBL1 = "" : BBL2 = "" : BBL3 = "" : BBL4 = "" : BBL5 = "" : BBL6 = "" : PA = "" : PA1 = "" : PA2 = "" : PA3 = "" : PA4 = "" : PA5 = "" : PA6 = "" : PA7 = "" : PA8 = "" : PA9 = ""
  87. PA10 = "" : PA11 = "" : PA12 = "" : PA13 = "" : PA14 = "" : PA15 = "" : PA16 = "" : PA17 = "" : PA18 = "" : PA19 = "" : PA20 = "" : PA21 = "" : PA22 = "" : PA23 = "" : PA24 = ""
  88. PA25 = "" : PA26 = "" : PA27 = "" : PA28 = "" : PA29 = "" : PA30 = "" : PA31 = "" : PA32 = "" : PA33 = "" : PA34 = "" : PA35 = "" : PA36 = "" : PA37 = "" : PA38 = "" : PA39 = ""
  89. PA40 = "" : PA41 = "" : PA42 = "" : PA43 = "" : PA44 = "" : PA45 = "" : PA46 = "" : PA47 = "" : DTP = "" : DTP1 = "" : DTP2 = ""
  90. DTP3 = "" : 列印用SQL = ""
  91. End Sub
  92. '----資料庫系統管理----------------------------------------------------------------------------------------------------------------------------
  93. Private Sub 系統使用者管理_tsm_Click(sender As Object, e As EventArgs) Handles 系統使用者管理_tsm.Click
  94. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  95. 重置() : 系統使用者管理.Show() : 系統使用者管理.BringToFront()
  96. End Sub
  97. Private Sub 系統組織架構設定_tsm_Click(sender As Object, e As EventArgs) Handles 系統組織架構設定_tsm.Click
  98. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  99. 重置() : 系統組織架構設定.Show() : 系統組織架構設定.BringToFront()
  100. End Sub
  101. Private Sub 系統通用變數管理_tsm_Click(sender As Object, e As EventArgs) Handles 系統通用變數管理_tsm.Click
  102. 重置() : 系統通用變數管理.ShowDialog() : 系統通用變數管理.BringToFront()
  103. End Sub
  104. Private Sub 系統權限預設表_tsm_Click(sender As Object, e As EventArgs) Handles 系統權限預設表_tsm.Click
  105. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  106. 重置() : 系統權限預設表.Show() : 系統權限預設表.BringToFront()
  107. End Sub
  108. Private Sub 部門權限設定_tsm_Click(sender As Object, e As EventArgs) Handles 部門權限設定_tsm.Click
  109. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  110. 重置() : 部門權限設定.Show() : 部門權限設定.BringToFront()
  111. End Sub
  112. Private Sub 系統編碼規則_tsm_Click(sender As Object, e As EventArgs) Handles 系統編碼規則_tsm.Click
  113. 系統編碼規則.Show() : 系統編碼規則.BringToFront()
  114. End Sub
  115. Private Sub TEST_FORM_tsm_Click(sender As Object, e As EventArgs) Handles TEST_FORM_tsm.Click
  116. 測試頁面.Show() : 測試頁面.BringToFront()
  117. End Sub
  118. Private Sub 系統對應電腦註冊_tsm_Click(sender As Object, e As EventArgs) Handles 系統對應電腦註冊_tsm.Click
  119. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  120. 重置() : 系統對應電腦註冊.Show() : 系統對應電腦註冊.BringToFront()
  121. End Sub
  122. Private Sub 系統執行檔版本管理_tsm_Click(sender As Object, e As EventArgs) Handles 系統執行檔版本管理_tsm.Click
  123. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  124. 重置() : 系統執行檔版本管理.Show() : 系統執行檔版本管理.BringToFront()
  125. End Sub
  126. Private Sub 簽名檔管理_tsm_Click(sender As Object, e As EventArgs) Handles 簽名檔管理_tsm.Click
  127. 重置() : 簽名檔管理.ShowDialog() : 簽名檔管理.BringToFront()
  128. End Sub
  129. Private Sub 物料資料庫_tsm_Click(sender As Object, e As EventArgs) Handles 物料資料庫_tsm.Click
  130. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  131. 重置() : 物料資料庫.Show() : 物料資料庫.BringToFront()
  132. End Sub
  133. Private Sub 物料供應商_tsm_Click(sender As Object, e As EventArgs) Handles 物料供應商_tsm.Click
  134. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  135. 重置() : 物料供應商.Show() : 物料供應商.BringToFront()
  136. End Sub
  137. Private Sub 客戶資料表_tsm_Click(sender As Object, e As EventArgs) Handles 客戶資料表_tsm.Click
  138. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  139. 重置() : 客戶資料表.Show() : 客戶資料表.BringToFront()
  140. End Sub
  141. Private Sub 財務收支單申請_tsm_Click(sender As Object, e As EventArgs) Handles 財務收支單申請_tsm.Click
  142. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  143. 重置() : 財務_收支單申請.Show() : 財務_收支單申請.BringToFront()
  144. End Sub
  145. Private Sub 匯率管理_tsm_Click(sender As Object, e As EventArgs) Handles 匯率管理_tsm.Click
  146. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  147. 重置() : 匯率管理.Show() : 匯率管理.BringToFront()
  148. End Sub
  149. Private Sub 會計科目管理_tsm_Click(sender As Object, e As EventArgs) Handles 會計科目管理_tsm.Click
  150. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  151. 重置() : 會計科目管理.Show() : 會計科目管理.BringToFront()
  152. End Sub
  153. Private Sub 財務收支單審核_tsm_Click(sender As Object, e As EventArgs) Handles 財務收支單審核_tsm.Click
  154. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  155. 重置() : 財務_收支單審核.Show() : 財務_收支單審核.BringToFront()
  156. End Sub
  157. Private Sub 財務收支單一覽表_tsm_Click(sender As Object, e As EventArgs) Handles 財務收支單一覽表_tsm.Click
  158. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  159. 重置() : PA18 = "" : PA19 = "" : PA20 = "" : 財務_收支單一覽表.Show() : 財務_收支單一覽表.BringToFront()
  160. End Sub
  161. Private Sub 財務收支單對帳表_tsm_Click(sender As Object, e As EventArgs) Handles 財務收支單對帳表_tsm.Click
  162. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  163. 重置() : PA18 = "" : PA19 = "" : PA20 = "" : 財務_對帳表.Show() : 財務_對帳表.BringToFront()
  164. End Sub
  165. Private Sub 財務系統說明書_tsm_Click(sender As Object, e As EventArgs) Handles 財務系統說明書_tsm.Click
  166. Process.Start("https://gcm-smart.com/2024/03/10/faip1/")
  167. End Sub
  168. Private Sub 財務收支決算表_tsm_Click(sender As Object, e As EventArgs) Handles 財務收支決算表_tsm.Click
  169. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  170. 重置() : 財務_決算表.Show() : 財務_決算表.BringToFront()
  171. End Sub
  172. Private Sub 車輛銷售管理_tsm_Click(sender As Object, e As EventArgs) Handles 車輛銷售管理_tsm.Click
  173. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  174. 重置() : 車輛銷售管理.Show() : 車輛銷售管理.BringToFront()
  175. End Sub
  176. Private Sub 物料入庫系統_tsm_Click(sender As Object, e As EventArgs) Handles 物料入庫系統_tsm.Click
  177. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  178. 重置() : 物料入庫系統.Show() : 物料入庫系統.BringToFront()
  179. End Sub
  180. Private Sub 採購對帳表ToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles 採購對帳表_tsm.Click
  181. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  182. 重置() : 倉儲對帳表.Show() : 倉儲對帳表.BringToFront()
  183. End Sub
  184. Private Sub 車輛銷售報表_tsm_Click(sender As Object, e As EventArgs) Handles 車輛銷售報表_tsm.Click
  185. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  186. 重置() : 車輛銷售報表.Show() : 車輛銷售報表.BringToFront()
  187. End Sub
  188. Private Sub 公函ToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles 公函_tsm.Click
  189. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  190. 重置() : 公函.Show() : 公函.BringToFront()
  191. End Sub
  192. Private Sub 簽呈ToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles 簽呈_tsm.Click
  193. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  194. 重置() : 簽呈.Show() : 簽呈.BringToFront()
  195. End Sub
  196. Private Sub 公告ToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles 公告_tsm.Click
  197. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  198. 重置() : 公告.Show() : 公告.BringToFront()
  199. End Sub
  200. Private Sub 文件ToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles 文件_tsm.Click
  201. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  202. 重置() : 文件.Show() : 文件.BringToFront()
  203. End Sub
  204. Private Sub 蘇文ToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles 疏文_tsm.Click
  205. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  206. 重置() : 疏文.Show() : 疏文.BringToFront()
  207. End Sub
  208. Private Sub 信眾資料表_tsm_Click(sender As Object, e As EventArgs) Handles 信眾資料表_tsm.Click
  209. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  210. 重置() : 信眾資料表.Show() : 信眾資料表.BringToFront()
  211. End Sub
  212. Private Sub 點燈系統_tsm_Click(sender As Object, e As EventArgs) Handles 點燈系統_tsm.Click
  213. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  214. 重置() : 點燈系統.Show() : 點燈系統.BringToFront()
  215. End Sub
  216. Private Sub 燈位基本資料_tsm_Click(sender As Object, e As EventArgs) Handles 燈位基本資料_tsm.Click
  217. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  218. 重置() : 燈位基本資料.Show() : 燈位基本資料.BringToFront()
  219. End Sub
  220. Private Sub 估價單ToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles 估價單_tsm.Click
  221. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  222. 重置() : 估價單.Show() : 估價單.BringToFront()
  223. End Sub
  224. Private Sub 程式鎖定ToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles 程式鎖定ToolStripMenuItem.Click
  225. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  226. 鎖定視窗.ShowDialog() : 鎖定視窗.BringToFront()
  227. End Sub
  228. Private Sub 流動資產申請ToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles 流動資產申請_tsm.Click
  229. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  230. 重置() : 財務_流動資產申請.Show() : 財務_流動資產申請.BringToFront()
  231. End Sub
  232. Private Sub 倉儲控制表_tsm_Click(sender As Object, e As EventArgs) Handles 倉儲控制表_tsm.Click
  233. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  234. 重置() : 倉儲明細表查詢.Show() : 倉儲明細表查詢.BringToFront()
  235. End Sub
  236. Private Sub 自動點燈ToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles 自動點燈_tsm.Click
  237. 重置() : 自動點燈系統.ShowDialog() : 自動點燈系統.BringToFront()
  238. End Sub
  239. Private Sub 點燈系統說明書_tsm_Click(sender As Object, e As EventArgs) Handles 點燈系統說明書_tsm.Click
  240. Process.Start("https://gcm-smart.com/2024/03/09/ptlip1/")
  241. End Sub
  242. Private Sub 考勤文件導入_tsm_Click(sender As Object, e As EventArgs) Handles 考勤文件導入_tsm.Click
  243. 重置() : 拆帳制考勤文件導入.ShowDialog() : 拆帳制考勤文件導入.BringToFront()
  244. End Sub
  245. Private Sub 薪資試算表_tsm_Click(sender As Object, e As EventArgs) Handles 薪資試算表_tsm.Click
  246. For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  247. 重置() : 拆帳制薪資試算表.Show() : 拆帳制薪資試算表.BringToFront()
  248. End Sub
  249. Private Sub 感謝狀_tsm_Click(sender As Object, e As EventArgs) Handles 感謝狀_tsm.Click
  250. 重置() : 感謝狀.Show() : 感謝狀.BringToFront()
  251. End Sub
  252. Private Sub 拆帳制薪資彙總表_tsm_Click(sender As Object, e As EventArgs) Handles 拆帳制薪資彙總表_tsm.Click
  253. 'For Each ChildForm As Form In Me.MdiChildren : ChildForm.Close() : Next
  254. 重置() : 拆帳制薪資試算表.Show() : 拆帳制薪資會總表.Show() : 拆帳制薪資會總表.BringToFront()
  255. End Sub
  256. End Class