HSKIN-MIS-SYS-LEEHSIEHJUI/GRAMS-SYS/HSKIN-MIS-SYS.vb

Imports System.IO
Public Class GRAMS_SYS
    ReadOnly ds1, ds2, ds3, ds4, ds5 As New DataSet
    Private Sub ShowNewForm(ByVal sender As Object, ByVal e As EventArgs) Handles NewWindowToolStripMenuItem.Click
        ' 建立子表單的新執行個體。
        ' 將它變成這個 MDI 表單的子表單，然後才顯示。
        Dim ChildForm As New Form With {
            .MdiParent = Me
        }
        m_ChildFormNumber += 1
        ChildForm.Text = "視窗 " & m_ChildFormNumber
        ChildForm.Show()
    End Sub
    Private Sub ExitToolsStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) Handles ExitToolStripMenuItem.Click
        Me.Close()
    End Sub
    Private Sub CascadeToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) Handles CascadeToolStripMenuItem.Click
        Me.LayoutMdi(MdiLayout.Cascade)
    End Sub
    Private Sub TileVerticalToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) Handles TileVerticalToolStripMenuItem.Click
        Me.LayoutMdi(MdiLayout.TileVertical)
    End Sub
    Private Sub TileHorizontalToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) Handles TileHorizontalToolStripMenuItem.Click
        Me.LayoutMdi(MdiLayout.TileHorizontal)
    End Sub
    Private Sub ArrangeIconsToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) Handles ArrangeIconsToolStripMenuItem.Click
        Me.LayoutMdi(MdiLayout.ArrangeIcons)
    End Sub
    Private Sub CloseAllToolStripMenuItem_Click(ByVal sender As Object, ByVal e As EventArgs) Handles CloseAllToolStripMenuItem.Click
        ' 關閉父表單的所有子表單。
        For Each ChildForm As Form In Me.MdiChildren
            ChildForm.Close()
        Next
    End Sub
    Private m_ChildFormNumber As Integer
    Private Sub Set_清單1()
        會議未簽_dgv.DataSource = Nothing : ds2.Clear()
        會議未簽_dgv.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing
        會議未簽_dgv.ColumnHeadersHeight = 25 : 會議未簽_dgv.AllowUserToAddRows = False
        SQL_會議未簽()
        da.Fill(ds2) : 會議未簽_dgv.DataSource = ds2.Tables(0) : conn.Close()

        會議未簽1_dgv.DataSource = Nothing : ds5.Clear()
        會議未簽1_dgv.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing
        會議未簽1_dgv.ColumnHeadersHeight = 25 : 會議未簽1_dgv.AllowUserToAddRows = False
        SQL_會議未簽1()
        da.Fill(ds5) : 會議未簽1_dgv.DataSource = ds5.Tables(0) : conn.Close()
    End Sub
    Private Sub Set_清單2()
        公告未簽_dgv.DataSource = Nothing : ds4.Clear()
        公告未簽_dgv.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing
        公告未簽_dgv.ColumnHeadersHeight = 25 : 公告未簽_dgv.AllowUserToAddRows = False
        SQL_文件未簽()
        da.Fill(ds4) : 公告未簽_dgv.DataSource = ds4.Tables(0) : conn.Close()
    End Sub
    Private Sub Set_加班明細()
        加班單_dgv.DataSource = Nothing : ds1.Clear()
        加班單_dgv.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing
        加班單_dgv.ColumnHeadersHeight = 40
        加班單_dgv.AllowUserToAddRows = False
        SQL_加班申請明細()
        da.Fill(ds1) : 加班單_dgv.DataSource = ds1.Tables(0) : conn.Close()
    End Sub
    Private Sub Set_請假明細()
        休假單_dgv.DataSource = Nothing : ds3.Clear()
        休假單_dgv.ColumnHeadersHeightSizeMode = DataGridViewColumnHeadersHeightSizeMode.EnableResizing
        休假單_dgv.ColumnHeadersHeight = 40
        休假單_dgv.AllowUserToAddRows = False
        SQL_休假申請明細()
        da.Fill(ds3) : 休假單_dgv.DataSource = ds3.Tables(0) : conn.Close()
    End Sub
    Private Sub GRAMS_SYS_Load(sender As Object, e As EventArgs) Handles MyBase.Load
        Me.Text = "HSKIN醫美集團 -- 黃柏翰皮膚專科/美容醫學診所 -- 管理系統 --  系統版本  :  " & 版本 & " -- 登入人員 : " & gUserName
        '---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
        系統設定_tsm.Visible = CC(1) : 系統使用者權限設定_tsm.Visible = CC(2) : 系統通用變數設定_tsm.Visible = CC(3) : ID卡配置設定_tsm.Visible = CC(4) : 人員資料表_tsm.Visible = CC(5)
        '---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
        排班管理系統_tsm.Visible = CC(6) : 排班資料_tsm.Visible = CC(6) : 醫生班表修改_tsm.Visible = CC(17) : 人員排班條件設定_tsm.Visible = CC(17)
        '---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
        加班申請_審核_tsm.Visible = CC(7) : 加班申請_tsm.Visible = CC(8) : 加班核准_tsm.Visible = CC(9) : 醫師下診時間紀錄_tsm.Visible = CC(10) : 加班申請資料_tsm.Visible = CC(24)
        '---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
        補休申請審核_tsm.Visible = CC(11) : 補休申請_tsm.Visible = CC(12) : 補休核准_tsm.Visible = CC(13) : 國定假日設定_tsm.Visible = CC(15) : 歷史休假紀錄_tsm.Visible = CC(25)
        '---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
        考勤管理_tsm.Visible = CC(14) : 考勤明細表_tsm.Visible = CC(26) : 到離職管理_tsm.Visible = CC(27) : 薪資資料設定_tsm.Visible = CC(16) : 薪資表_tsm.Visible = CC(16)
        補打卡申請_tsm.Visible = CC(8) : 補打卡審核_tsm.Visible = CC(9)
        考勤位置設定_tsm.Visible = CC(2) : 考勤位置異常清單_tsm.Visible = CC(2) : 員工手機考勤驗證管理_tsm.Visible = CC(2)
        '---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
        業務管理系統_tsm.Visible = CC(19)
        業務銷售控制表_tsm.Visible = CC(20) : 業績獎金計算表新_tsm.Visible = CC(20) : 業績銷售分析表_有金額_tsm.Visible = CC(28) : 業績銷售分析表_無金額_tsm.Visible = CC(21)
        業績獎金計算表_tsm.Visible = CC(22) : 來客資料分析表_tsm.Visible = CC(22) : 人員貢獻分析表_tsm.Visible = CC(22)
        產品銷售分析表_tsm.Visible = CC(22)
        業務系統資料管理_tsm.Visible = CC(23) : 交易明細表導入_tsm.Visible = CC(23) : 產品銷售資料導入_tsm.Visible = CC(23)
        '---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
        總務管理系統_tsm.Visible = CC(29) : 文件_tsm.Visible = CC(29)
    End Sub
    Private Sub GRAMS_SYS_Shown(sender As Object, e As EventArgs) Handles MyBase.Shown
        計算分流.Enabled = True
    End Sub
    Private Sub 計算分流_Tick(sender As Object, e As EventArgs) Handles 計算分流.Tick
        計算分流.Enabled = False
        Set_加班明細() : Set_請假明細()
        Dim 提醒(3) As String : Dim 會議未簽, 公告未簽 As String : 會議未簽 = "" : 公告未簽 = ""
        提醒(0) = "系統中還有 " & " " & 加班單_dgv.Rows.Count & " " & "筆 加班申請尚未審核"
        提醒(1) = "系統中還有 " & " " & 休假單_dgv.Rows.Count & " " & "筆 請假申請尚未審核"
        If CC(9) = True Or CC(13) = True Then
            MsgBox(提醒(0) & vbCrLf & vbCrLf &
                   提醒(1))
        End If
        If 加班單_dgv.Rows.Count <> 0 Then : 會議未簽 &= 提醒(0) & vbCrLf : End If
        If 休假單_dgv.Rows.Count <> 0 Then : 會議未簽 &= 提醒(1) & vbCrLf : End If
        If 加班單_dgv.Rows.Count <> 0 Or 休假單_dgv.Rows.Count <> 0 Then : 會議未簽 &= "=================" & vbCrLf : End If
        Dim today As DayOfWeek = DateTime.Today.DayOfWeek
        If today = DayOfWeek.Monday OrElse today = DayOfWeek.Wednesday OrElse today = DayOfWeek.Friday Then
            Set_清單1() : Set_清單2()
            If 會議未簽_dgv.Rows.Count = 0 And 公告未簽_dgv.Rows.Count = 0 Then : Else
                If 會議未簽_dgv.Rows.Count = 0 Then : 會議未簽 = "沒有未簽名的會議紀錄!!" : Else
                    會議未簽 &= "會議記錄未簽名的清單如下 : "
                    For i As Integer = 0 To 會議未簽1_dgv.Rows.Count - 1
                        會議未簽 &= vbCrLf & "---" & 會議未簽1_dgv(1, i).Value.ToString & "---" & vbCrLf
                        For J As Integer = 0 To 會議未簽_dgv.Rows.Count - 1
                            If 會議未簽1_dgv(1, i).Value.ToString = 會議未簽_dgv(0, J).Value.ToString Then
                                If J <> 會議未簽_dgv.Rows.Count - 1 Then : 會議未簽 &= 會議未簽_dgv(1, J).Value.ToString & "、"
                                Else : 會議未簽 &= 會議未簽_dgv(1, J).Value.ToString : End If
                            End If
                        Next : Dim inputString As String = 會議未簽 : If inputString.EndsWith("、") Then : 會議未簽 = inputString.Substring(0, inputString.Length - 1) : End If
                    Next
                End If
                If 公告未簽_dgv.Rows.Count = 0 Then : 公告未簽 = "沒有未簽名的公告或文件!!" : Else
                    For i As Integer = 0 To 公告未簽_dgv.Rows.Count - 1
                        If i = 0 Then
                            公告未簽 = "---" & 公告未簽_dgv(0, i).Value.ToString & "---" & vbCrLf & 公告未簽_dgv(1, i).Value.ToString
                        Else
                            公告未簽 &= vbCrLf & "---" & 公告未簽_dgv(0, i).Value.ToString & "---" & vbCrLf & 公告未簽_dgv(1, i).Value.ToString
                        End If
                    Next
                End If
                SQL_判斷是否已經通知()
                If dr.Read Then : Else
                    SQL_LOG檔清除() : LIN訊息通知_新("CC217", "診所主管", 會議未簽, 公告未簽) : SQL_到期LINE通知寫入()
                End If
            End If
        End If
    End Sub
    Private Sub GRAMS_SYS_SIZE(sender As Object, e As EventArgs) Handles MyBase.SizeChanged
        Me.BackgroundImage = My.Resources.LOGO0101 : Me.BackgroundImageLayout = 3
    End Sub
    Private Sub GRAMS_SYS_Unload(sender As Object, e As EventArgs) Handles MyBase.Closing
        '-----------------------刪除自動更新項目-----------------------------------------------------------------------------------------------------------------------------------------------
        Dim Str As String = Application.StartupPath
        If File.Exists(Str + "\SYS-UPDATE.exe") Then : File.Delete(Str + "\SYS-UPDATE.exe") : End If
        If File.Exists(Str + "\LIVE.txt") Then : File.Delete(Str + "\LIVE.txt") : End If
        LoginForm1.Close()
    End Sub
    Private Sub 系統通用變數設定_tsm_Click(sender As Object, e As EventArgs) Handles 系統通用變數設定_tsm.Click
        PA = "" : 系統設定.Show() : 系統設定.BringToFront()
    End Sub
    Private Sub 人員資料表_tsm_Click_1(sender As Object, e As EventArgs) Handles 人員資料表_tsm.Click
        PA = "" : 人員資料表.Show() : 人員資料表.BringToFront()
    End Sub
    Private Sub 系統使用者權限設定_tsm_Click(sender As Object, e As EventArgs) Handles 系統使用者權限設定_tsm.Click
        PA = "" : 系統使用者管理.ShowDialog() : 系統使用者管理.BringToFront()
    End Sub
    Private Sub 排班資料_tsm_Click_1(sender As Object, e As EventArgs) Handles 排班資料_tsm.Click
        PA = "" : 排班資料.Show() : 排班資料.BringToFront()
    End Sub
    Private Sub 醫生班表修改_tsm_Click(sender As Object, e As EventArgs) Handles 醫生班表修改_tsm.Click
        PA = "" : 醫生班表設定.Show() : 醫生班表設定.BringToFront()
    End Sub
    Private Sub 補休申請_tsm_Click(sender As Object, e As EventArgs) Handles 補休申請_tsm.Click
        PA = "" : 休假申請.ShowDialog()
    End Sub
    Private Sub 補休核准_tsm_Click(sender As Object, e As EventArgs) Handles 補休核准_tsm.Click
        PA = "" : 休假核准.ShowDialog()
    End Sub
    Private Sub 醫師下診時間紀錄_tsm_Click(sender As Object, e As EventArgs) Handles 醫師下診時間紀錄_tsm.Click
        PA = "" : 醫師下診紀錄.ShowDialog()
    End Sub
    Private Sub 加班申請_tsm_Click(sender As Object, e As EventArgs) Handles 加班申請_tsm.Click
        PA = "" : 加班申請.ShowDialog()
    End Sub
    Private Sub 業務系統資料管理_tsm_Click(sender As Object, e As EventArgs) Handles 業務系統資料管理_tsm.Click
        PA = "" : 業務系統資庫管理.Show() : 業務系統資庫管理.BringToFront()
    End Sub
    Private Sub 來客資料分析表_tsm_Click(sender As Object, e As EventArgs) Handles 來客資料分析表_tsm.Click
        PA = "" : 來客資料分析表.Show() : 來客資料分析表.BringToFront()
    End Sub
    Private Sub 產品銷售分析表_tsm_Click(sender As Object, e As EventArgs) Handles 產品銷售分析表_tsm.Click
        PA = "" : 產品銷售分析表.Show() : 產品銷售分析表.BringToFront()
    End Sub
    Private Sub 人員貢獻分析表_tsm_Click(sender As Object, e As EventArgs) Handles 人員貢獻分析表_tsm.Click
        PA = "" : 人員貢獻分析表.Show() : 人員貢獻分析表.BringToFront()
    End Sub
    Private Sub 國定假日設定_tsm_Click_1(sender As Object, e As EventArgs) Handles 國定假日設定_tsm.Click
        PA = "" : 國定假日設定.ShowDialog() : 國定假日設定.BringToFront()
    End Sub
    Private Sub 歷史休假紀錄_tsm_Click(sender As Object, e As EventArgs) Handles 歷史休假紀錄_tsm.Click
        PA = "" : 休假歷史紀錄.ShowDialog() : 休假歷史紀錄.BringToFront()
    End Sub
    Private Sub 加班申請資料_tsm_Click(sender As Object, e As EventArgs) Handles 加班申請資料_tsm.Click
        PA = "" : 加班申請資料.ShowDialog() : 加班申請資料.BringToFront()
    End Sub
    Private Sub 考勤明細表_tsm_Click(sender As Object, e As EventArgs) Handles 考勤明細表_tsm.Click
        PA = "考勤明細表" : 考勤明細表.Show() : 考勤明細表.BringToFront()
    End Sub
    Private Sub 補打卡申請_tsm_Click(sender As Object, e As EventArgs) Handles 補打卡申請_tsm.Click
        PA = "補打卡申請" : 考勤明細表.Show() : 考勤明細表.BringToFront()
    End Sub
    Private Sub 補打卡審核_tsm_Click(sender As Object, e As EventArgs) Handles 補打卡審核_tsm.Click
        PA = "補打卡審核" : 考勤明細表.Show() : 考勤明細表.BringToFront()
    End Sub
    Private Sub 到離職管理_tsm_Click(sender As Object, e As EventArgs) Handles 到離職管理_tsm.Click
        PA = "" : 到離職管理.Show() : 到離職管理.BringToFront()
    End Sub
    Private Sub 到離職核准_tsm_Click(sender As Object, e As EventArgs)
    End Sub
    Private Sub 交易明細表導入_tsm_Click(sender As Object, e As EventArgs) Handles 交易明細表導入_tsm.Click
        PA = "" : 交易明細表導入.Show() : 交易明細表導入.BringToFront()
    End Sub
    Private Sub 人員排班條件設定_tsm_Click(sender As Object, e As EventArgs) Handles 人員排班條件設定_tsm.Click
        PA = "" : 人員排班條件設定.Show() : 人員排班條件設定.BringToFront()
    End Sub
    Private Sub 加班核准_tsm_Click(sender As Object, e As EventArgs) Handles 加班核准_tsm.Click
        PA = "" : 加班審核.ShowDialog()
    End Sub
    Private Sub 薪資資料設定ToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles 薪資資料設定_tsm.Click
        PA = "" : 薪資資料設定.ShowDialog()
    End Sub
    Private Sub 薪資表_tsm_Click(sender As Object, e As EventArgs) Handles 薪資表_tsm.Click
        PA = "" : 薪資表.Show() : 薪資表.BringToFront()
    End Sub
    Private Sub 業務銷售控制表_tsm_Click(sender As Object, e As EventArgs) Handles 業務銷售控制表_tsm.Click
        PA = "" : 業務銷售控制表.Show() : 業務銷售控制表.BringToFront()
    End Sub
    Private Sub 系統綁定電腦資訊_tsm_Click(sender As Object, e As EventArgs) Handles 系統綁定電腦資訊_tsm.Click
        PA = InputBox("請輸入系統管理員密碼!!") : If PA = "0003065795" Then : PA = "" : 系統綁定電腦資訊.ShowDialog() : 系統綁定電腦資訊.BringToFront() : End If
    End Sub
    Private Sub 專案及會議提案_tsm_Click(sender As Object, e As EventArgs) Handles 專案及會議提案_tsm.Click
        PA = "" : 專案及會議提案.Show() : 專案及會議提案.BringToFront()
    End Sub
    Private Sub 專案及會議執行_tsm_Click(sender As Object, e As EventArgs) Handles 專案及會議執行_tsm.Click
        If gUserName = "*系統管理者" Or gUserName = "黃院長" Or gUserName = "呂總監" Or gUserName = "蔡紋婷" Then
            PA = "" : 專案及會議執行.Show() : 專案及會議執行.BringToFront()
        Else : MsgBox("決議會議過程必須要有主管在場，請使用 [院長]、[總監]、[特助]其中一人的帳號登入系統後執行!!") : End If
    End Sub
    Private Sub 文件ToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles 文件_tsm.Click
        文件.Show() : 文件.BringToFront()
    End Sub
    Private Sub 考勤位置設定ToolStripMenuItem_Click(sender As Object, e As EventArgs) Handles 考勤位置設定_tsm.Click
        PA = "" : 考勤位置設定.Show() : 考勤位置設定.BringToFront()
    End Sub
    Private Sub 鋼琴收藏室溫控紀錄_tsm_Click(sender As Object, e As EventArgs) Handles 鋼琴收藏室溫控紀錄_tsm.Click
        PA = "" : 鋼琴收藏室溫控紀錄.Show() : 鋼琴收藏室溫控紀錄.BringToFront()
    End Sub
    Private Sub 業績獎金計算表新_tsm_Click(sender As Object, e As EventArgs) Handles 業績獎金計算表新_tsm.Click
        PA = "" : 業績獎金計算表_新.Show() : 業績獎金計算表_新.BringToFront()
    End Sub
    Private Sub 產品銷售資料導入_tsm_Click(sender As Object, e As EventArgs) Handles 產品銷售資料導入_tsm.Click
        PA = "" : 產品銷售資料導入.Show() : 產品銷售資料導入.BringToFront()
    End Sub
    Private Sub 業績銷售分析表_tsm_Click(sender As Object, e As EventArgs) Handles 業績銷售分析表_有金額_tsm.Click
        PA = "" : 業績銷售分析表_有金額.Show() : 業績銷售分析表_有金額.BringToFront()
    End Sub
    Private Sub 業績銷售分析表_無金額_tsm_Click(sender As Object, e As EventArgs) Handles 業績銷售分析表_無金額_tsm.Click
        PA = "" : 業績銷售分析表.Show() : 業績銷售分析表.BringToFront()
    End Sub
    Private Sub 治療排程資料_tsm_Click(sender As Object, e As EventArgs) Handles 治療排程資料_tsm.Click
        PA = "" : 治療排程資料.Show() : 治療排程資料.BringToFront()
    End Sub
    Private Sub 考勤位置異常清單_tsm_Click(sender As Object, e As EventArgs) Handles 考勤位置異常清單_tsm.Click
        PA = "" : 考勤位置異常清單.Show() : 考勤位置異常清單.BringToFront()
    End Sub
    Private Sub 員工手機考勤驗證管理_tsm_Click(sender As Object, e As EventArgs) Handles 員工手機考勤驗證管理_tsm.Click
        PA = "" : 員工手機考勤驗證管理.Show() : 員工手機考勤驗證管理.BringToFront()
    End Sub
    Private Sub 業績獎金計算表_tsm_Click(sender As Object, e As EventArgs) Handles 業績獎金計算表_tsm.Click
        PA = "" : 業績獎金計算表.Show() : 業績獎金計算表.BringToFront()
    End Sub
    Private Sub 個人班表_tsm_Click(sender As Object, e As EventArgs) Handles 個人班表_tsm.Click
        PA = Year(Today) : PA1 = Month(Today) : If CInt(PA1) < 10 Then : PA1 = "0" & PA1 : End If : PA2 = gUserName
        個人班表.Show() : 個人班表.BringToFront()
    End Sub
End Class