frmdepartment.vb

师生情况管理系统

'************************************************************
'Copyright(c) 2007 长沙南方职业学院 信息系 软件2-061班
'All rights reserved
'
'程序名称：学校基本信息管理系统
'
'作者(原)：易湘陵
'完成日期：2007-11-14
'作者(改)：
'修改日期：
'************************************************************
Public Class FrmDepartment
    Inherits System.Windows.Forms.Form

#Region " Windows 窗体设计器生成的代码 "

    Public Sub New()
        MyBase.New()

        '该调用是 Windows 窗体设计器所必需的。
        InitializeComponent()
        LoadDepartment()
        '在 InitializeComponent() 调用之后添加任何初始化

    End Sub


    Public Sub New(ByVal L As Boolean)
        MyBase.New()

        '该调用是 Windows 窗体设计器所必需的。
        InitializeComponent()
        MyDoubleClickClose = L
        LoadDepartment()
        '在 InitializeComponent() 调用之后添加任何初始化

    End Sub

    '窗体重写 dispose 以清理组件列表。
    Protected Overloads Overrides Sub Dispose(ByVal disposing As Boolean)
        If disposing Then
            If Not (components Is Nothing) Then
                components.Dispose()
            End If
        End If
        MyBase.Dispose(disposing)
    End Sub

    'Windows 窗体设计器所必需的
    Private components As System.ComponentModel.IContainer

    '注意: 以下过程是 Windows 窗体设计器所必需的
    '可以使用 Windows 窗体设计器修改此过程。
    '不要使用代码编辑器修改它。
    Friend WithEvents DgDepartmentList As System.Windows.Forms.DataGrid
    Friend WithEvents ToolBarDepartment As System.Windows.Forms.ToolBar
    Friend WithEvents ImageListTool As System.Windows.Forms.ImageList
    Friend WithEvents GroupBoxDepartmentList As System.Windows.Forms.GroupBox
    Friend WithEvents ToolBarBtnAdd As System.Windows.Forms.ToolBarButton
    Friend WithEvents ToolBarBtnEdit As System.Windows.Forms.ToolBarButton
    Friend WithEvents ToolBarBtnDel As System.Windows.Forms.ToolBarButton
    Friend WithEvents BtnClose As System.Windows.Forms.Button
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Me.components = New System.ComponentModel.Container
        Dim resources As System.Resources.ResourceManager = New System.Resources.ResourceManager(GetType(FrmDepartment))
        Me.DgDepartmentList = New System.Windows.Forms.DataGrid
        Me.GroupBoxDepartmentList = New System.Windows.Forms.GroupBox
        Me.ToolBarDepartment = New System.Windows.Forms.ToolBar
        Me.ToolBarBtnAdd = New System.Windows.Forms.ToolBarButton
        Me.ToolBarBtnEdit = New System.Windows.Forms.ToolBarButton
        Me.ToolBarBtnDel = New System.Windows.Forms.ToolBarButton
        Me.ImageListTool = New System.Windows.Forms.ImageList(Me.components)
        Me.BtnClose = New System.Windows.Forms.Button
        CType(Me.DgDepartmentList, System.ComponentModel.ISupportInitialize).BeginInit()
        Me.GroupBoxDepartmentList.SuspendLayout()
        Me.SuspendLayout()
        '
        'DgDepartmentList
        '
        Me.DgDepartmentList.AllowSorting = False
        Me.DgDepartmentList.CaptionVisible = False
        Me.DgDepartmentList.DataMember = ""
        Me.DgDepartmentList.HeaderForeColor = System.Drawing.SystemColors.ControlText
        Me.DgDepartmentList.Location = New System.Drawing.Point(8, 16)
        Me.DgDepartmentList.Name = "DgDepartmentList"
        Me.DgDepartmentList.ReadOnly = True
        Me.DgDepartmentList.RowHeadersVisible = False
        Me.DgDepartmentList.Size = New System.Drawing.Size(280, 256)
        Me.DgDepartmentList.TabIndex = 0
        '
        'GroupBoxDepartmentList
        '
        Me.GroupBoxDepartmentList.Controls.Add(Me.DgDepartmentList)
        Me.GroupBoxDepartmentList.Location = New System.Drawing.Point(8, 32)
        Me.GroupBoxDepartmentList.Name = "GroupBoxDepartmentList"
        Me.GroupBoxDepartmentList.Size = New System.Drawing.Size(296, 280)
        Me.GroupBoxDepartmentList.TabIndex = 1
        Me.GroupBoxDepartmentList.TabStop = False
        Me.GroupBoxDepartmentList.Text = "系部列表"
        '
        'ToolBarDepartment
        '
        Me.ToolBarDepartment.Buttons.AddRange(New System.Windows.Forms.ToolBarButton() {Me.ToolBarBtnAdd, Me.ToolBarBtnEdit, Me.ToolBarBtnDel})
        Me.ToolBarDepartment.DropDownArrows = True
        Me.ToolBarDepartment.ImageList = Me.ImageListTool
        Me.ToolBarDepartment.Location = New System.Drawing.Point(0, 0)
        Me.ToolBarDepartment.Name = "ToolBarDepartment"
        Me.ToolBarDepartment.ShowToolTips = True
        Me.ToolBarDepartment.Size = New System.Drawing.Size(312, 28)
        Me.ToolBarDepartment.TabIndex = 2
        '
        'ToolBarBtnAdd
        '
        Me.ToolBarBtnAdd.ImageIndex = 0
        Me.ToolBarBtnAdd.ToolTipText = "添加"
        '
        'ToolBarBtnEdit
        '
        Me.ToolBarBtnEdit.ImageIndex = 3
        Me.ToolBarBtnEdit.ToolTipText = "修改"
        '
        'ToolBarBtnDel
        '
        Me.ToolBarBtnDel.ImageIndex = 1
        Me.ToolBarBtnDel.ToolTipText = "删除"
        '
        'ImageListTool
        '
        Me.ImageListTool.ColorDepth = System.Windows.Forms.ColorDepth.Depth16Bit
        Me.ImageListTool.ImageSize = New System.Drawing.Size(16, 16)
        Me.ImageListTool.ImageStream = CType(resources.GetObject("ImageListTool.ImageStream"), System.Windows.Forms.ImageListStreamer)
        Me.ImageListTool.TransparentColor = System.Drawing.Color.Transparent
        '
        'BtnClose
        '
        Me.BtnClose.Location = New System.Drawing.Point(224, 320)
        Me.BtnClose.Name = "BtnClose"
        Me.BtnClose.TabIndex = 3
        Me.BtnClose.Text = "关闭"
        '
        'FrmDepartment
        '
        Me.AcceptButton = Me.BtnClose
        Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14)
        Me.ClientSize = New System.Drawing.Size(312, 352)
        Me.Controls.Add(Me.BtnClose)
        Me.Controls.Add(Me.ToolBarDepartment)
        Me.Controls.Add(Me.GroupBoxDepartmentList)
        Me.FormBorderStyle = System.Windows.Forms.FormBorderStyle.SizableToolWindow
        Me.Icon = CType(resources.GetObject("$this.Icon"), System.Drawing.Icon)
        Me.Name = "FrmDepartment"
        Me.StartPosition = System.Windows.Forms.FormStartPosition.Manual
        Me.Text = "系部列表"
        CType(Me.DgDepartmentList, System.ComponentModel.ISupportInitialize).EndInit()
        Me.GroupBoxDepartmentList.ResumeLayout(False)
        Me.ResumeLayout(False)

    End Sub

#End Region

    Private Sub LoadDepartment()
        Dim Con As SqlClient.SqlConnection
        Dim SqlStr As String = "select DID 系编号,Dname 系名称 from DepartmentInfo"
        Try
            dsDepartment.Clear()
            Con = New SqlClient.SqlConnection(FrmMain.DBCONN.DataConStr)
            Con.Open()
            daDepartment = New SqlClient.SqlDataAdapter(SqlStr, Con)
            daDepartment.Fill(dsDepartment, "info")

            Dim MyCommandBuilder As New SqlClient.SqlCommandBuilder(daDepartment)
            DgDepartmentList.SetDataBinding(dsDepartment, "info")
        Catch ex As Exception
            MsgBox(ex.Message)
        Finally
            Con.Close()
        End Try
    End Sub


    Public DepartmentID As String = ""
    Private MyDoubleClickClose As Boolean = False
    Public dsDepartment As New DataSet
    Private daDepartment As SqlClient.SqlDataAdapter

    Private Sub FrmDepartment_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        'LoadDepartment()
        If MyDoubleClickClose Then
            BtnClose.Text = "选择"
        End If
        'AddHandler DataGridTextBoxColumn2.TextBox.MouseDown, New MouseEventHandler(AddressOf DGDoubleClick)
    End Sub

    Private Sub ToolBarDepartment_ButtonClick(ByVal sender As System.Object, ByVal e As System.Windows.Forms.ToolBarButtonClickEventArgs) Handles ToolBarDepartment.ButtonClick

        If e.Button Is Me.ToolBarBtnAdd Then
            Dim FrmDepartmentadd As New FrmAdd_Edit
            FrmDepartmentadd.ShowDialog()
            If FrmDepartmentadd.SaveZT Then
                Try
                    Dim MyRow As DataRow = dsDepartment.Tables(0).NewRow()
                    MyRow(0) = FrmDepartmentadd.ShareID
                    MyRow(1) = FrmDepartmentadd.ShareName
                    dsDepartment.Tables(0).Rows.Add(MyRow)
                    daDepartment.Update(dsDepartment, "info")
                Catch ex As Exception
                    MsgBox("添加失败！" & vbCrLf & ex.Message, 64, "失败")
                End Try
            End If
            FrmDepartmentadd = Nothing
        End If

        If e.Button Is Me.ToolBarBtnDel Then
            If DgDepartmentList.CurrentCell.RowNumber > 0 Then
                If MsgBox("你真的要删除当前所选的这一行数据吗？", 64 + 4, "删除") = 6 Then
                    Try
                        dsDepartment.Tables(0).Rows(DgDepartmentList.CurrentCell.RowNumber).Delete()
                        daDepartment.Update(dsDepartment, "info")
                    Catch ex As Exception
                        MsgBox("删除失败！" & vbCrLf & ex.Message, 64, "失败")
                    End Try
                End If
            End If
        End If

        If e.Button Is Me.ToolBarBtnEdit Then
            Dim FrmDepartmentEdit As New FrmAdd_Edit(dsDepartment.Tables(0).Rows(DgDepartmentList.CurrentCell.RowNumber).Item(0), dsDepartment.Tables(0).Rows(DgDepartmentList.CurrentCell.RowNumber).Item(1))
            FrmDepartmentEdit.ShowDialog()
            If FrmDepartmentEdit.SaveZT Then
                Try
                    dsDepartment.Tables(0).Rows(DgDepartmentList.CurrentCell.RowNumber).Item(0) = FrmDepartmentEdit.ShareID
                    dsDepartment.Tables(0).Rows(DgDepartmentList.CurrentCell.RowNumber).Item(1) = FrmDepartmentEdit.ShareName
                    daDepartment.Update(dsDepartment, "info")
                Catch ex As Exception
                    MsgBox("修改失败！" & vbCrLf & ex.Message, 64, "失败")
                End Try
            End If
            FrmDepartmentEdit = Nothing
        End If

    End Sub

    Private Sub BtnClose_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles BtnClose.Click
        If MyDoubleClickClose Then
            DepartmentID = dsDepartment.Tables(0).Rows(DgDepartmentList.CurrentCell.RowNumber).Item(0)
        End If
        Me.Close()
    End Sub
End Class