奖惩情况.vb

公司的人事变动,人事基本信息,人事的管理

Public Class 奖惩情况
    Inherits System.Windows.Forms.Form

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

    Public Sub New()
        MyBase.New()

        '该调用是 Windows 窗体设计器所必需的。
        InitializeComponent()

        '在 InitializeComponent() 调用之后添加任何初始化

    End Sub

    '窗体重写处置以清理组件列表。
    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 lbl类别 As System.Windows.Forms.Label
    Friend WithEvents lbl时间 As System.Windows.Forms.Label
    Friend WithEvents edit类别 As System.Windows.Forms.TextBox
    Friend WithEvents edit时间 As System.Windows.Forms.TextBox
    Friend WithEvents lbl详细内容 As System.Windows.Forms.Label
    Friend WithEvents edit详细内容 As System.Windows.Forms.TextBox
    Friend WithEvents btnNavFirst As System.Windows.Forms.Button
    Friend WithEvents btnNavPrev As System.Windows.Forms.Button
    Friend WithEvents lblNavLocation As System.Windows.Forms.Label
    Friend WithEvents btnNavNext As System.Windows.Forms.Button
    Friend WithEvents btnLast As System.Windows.Forms.Button
    Friend WithEvents btnAdd As System.Windows.Forms.Button
    Friend WithEvents btnDelete As System.Windows.Forms.Button
    Friend WithEvents btnClose As System.Windows.Forms.Button
    <System.Diagnostics.DebuggerStepThrough()> Private Sub InitializeComponent()
        Me.lbl类别 = New System.Windows.Forms.Label()
        Me.lbl时间 = New System.Windows.Forms.Label()
        Me.edit类别 = New System.Windows.Forms.TextBox()
        Me.edit时间 = New System.Windows.Forms.TextBox()
        Me.lbl详细内容 = New System.Windows.Forms.Label()
        Me.edit详细内容 = New System.Windows.Forms.TextBox()
        Me.btnNavFirst = New System.Windows.Forms.Button()
        Me.btnNavPrev = New System.Windows.Forms.Button()
        Me.lblNavLocation = New System.Windows.Forms.Label()
        Me.btnNavNext = New System.Windows.Forms.Button()
        Me.btnLast = New System.Windows.Forms.Button()
        Me.btnAdd = New System.Windows.Forms.Button()
        Me.btnDelete = New System.Windows.Forms.Button()
        Me.btnClose = New System.Windows.Forms.Button()
        Me.SuspendLayout()
        '
        'lbl类别
        '
        Me.lbl类别.Location = New System.Drawing.Point(16, 8)
        Me.lbl类别.Name = "lbl类别"
        Me.lbl类别.TabIndex = 20
        Me.lbl类别.Text = "类别"
        '
        'lbl时间
        '
        Me.lbl时间.Location = New System.Drawing.Point(16, 40)
        Me.lbl时间.Name = "lbl时间"
        Me.lbl时间.TabIndex = 21
        Me.lbl时间.Text = "时间"
        '
        'edit类别
        '
        Me.edit类别.Location = New System.Drawing.Point(112, 8)
        Me.edit类别.Name = "edit类别"
        Me.edit类别.Size = New System.Drawing.Size(136, 21)
        Me.edit类别.TabIndex = 22
        Me.edit类别.Text = ""
        '
        'edit时间
        '
        Me.edit时间.Location = New System.Drawing.Point(112, 40)
        Me.edit时间.Name = "edit时间"
        Me.edit时间.Size = New System.Drawing.Size(136, 21)
        Me.edit时间.TabIndex = 23
        Me.edit时间.Text = ""
        '
        'lbl详细内容
        '
        Me.lbl详细内容.Location = New System.Drawing.Point(16, 72)
        Me.lbl详细内容.Name = "lbl详细内容"
        Me.lbl详细内容.TabIndex = 24
        Me.lbl详细内容.Text = "详细内容"
        '
        'edit详细内容
        '
        Me.edit详细内容.Location = New System.Drawing.Point(112, 72)
        Me.edit详细内容.Name = "edit详细内容"
        Me.edit详细内容.Size = New System.Drawing.Size(136, 21)
        Me.edit详细内容.TabIndex = 25
        Me.edit详细内容.Text = ""
        '
        'btnNavFirst
        '
        Me.btnNavFirst.Location = New System.Drawing.Point(8, 112)
        Me.btnNavFirst.Name = "btnNavFirst"
        Me.btnNavFirst.Size = New System.Drawing.Size(40, 23)
        Me.btnNavFirst.TabIndex = 26
        Me.btnNavFirst.Text = "<<"
        '
        'btnNavPrev
        '
        Me.btnNavPrev.Location = New System.Drawing.Point(48, 112)
        Me.btnNavPrev.Name = "btnNavPrev"
        Me.btnNavPrev.Size = New System.Drawing.Size(35, 23)
        Me.btnNavPrev.TabIndex = 27
        Me.btnNavPrev.Text = "<"
        '
        'lblNavLocation
        '
        Me.lblNavLocation.BackColor = System.Drawing.Color.White
        Me.lblNavLocation.Location = New System.Drawing.Point(80, 112)
        Me.lblNavLocation.Name = "lblNavLocation"
        Me.lblNavLocation.Size = New System.Drawing.Size(95, 23)
        Me.lblNavLocation.TabIndex = 28
        Me.lblNavLocation.Text = "无记录"
        Me.lblNavLocation.TextAlign = System.Drawing.ContentAlignment.MiddleCenter
        '
        'btnNavNext
        '
        Me.btnNavNext.Location = New System.Drawing.Point(176, 112)
        Me.btnNavNext.Name = "btnNavNext"
        Me.btnNavNext.Size = New System.Drawing.Size(35, 23)
        Me.btnNavNext.TabIndex = 29
        Me.btnNavNext.Text = ">"
        '
        'btnLast
        '
        Me.btnLast.Location = New System.Drawing.Point(208, 112)
        Me.btnLast.Name = "btnLast"
        Me.btnLast.Size = New System.Drawing.Size(40, 23)
        Me.btnLast.TabIndex = 30
        Me.btnLast.Text = ">>"
        '
        'btnAdd
        '
        Me.btnAdd.Location = New System.Drawing.Point(8, 144)
        Me.btnAdd.Name = "btnAdd"
        Me.btnAdd.TabIndex = 31
        Me.btnAdd.Text = "添加(&A)"
        '
        'btnDelete
        '
        Me.btnDelete.Location = New System.Drawing.Point(90, 144)
        Me.btnDelete.Name = "btnDelete"
        Me.btnDelete.TabIndex = 32
        Me.btnDelete.Text = "删除(&D)"
        '
        'btnClose
        '
        Me.btnClose.Location = New System.Drawing.Point(172, 144)
        Me.btnClose.Name = "btnClose"
        Me.btnClose.TabIndex = 33
        Me.btnClose.Text = "关闭(&C)"
        '
        '奖惩情况
        '
        Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14)
        Me.ClientSize = New System.Drawing.Size(256, 173)
        Me.Controls.AddRange(New System.Windows.Forms.Control() {Me.lbl类别, Me.lbl时间, Me.edit类别, Me.edit时间, Me.lbl详细内容, Me.edit详细内容, Me.btnNavFirst, Me.btnNavPrev, Me.lblNavLocation, Me.btnNavNext, Me.btnLast, Me.btnAdd, Me.btnDelete, Me.btnClose})
        Me.Name = "奖惩情况"
        Me.Text = "奖惩情况"
        Me.ResumeLayout(False)

    End Sub

#End Region

    Dim TempRS As ADODB.Recordset

    Private Sub 奖惩情况_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        TempRS = New ADODB.Recordset()
        TempRS.Open("Select * From 奖惩 Where 编号=" + RecNo.ToString, MyCnn, ADODB.CursorTypeEnum.adOpenStatic, ADODB.LockTypeEnum.adLockOptimistic)
        '获得记录集
        If TempRS.RecordCount > 0 Then
            TempRS.MoveFirst()
            Me.edit时间.Text = TempRS.Fields(2).Value.ToString
            Me.edit类别.Text = TempRS.Fields(3).Value.ToString
            Me.edit详细内容.Text = TempRS.Fields(4).Value.ToString
            Me.lblNavLocation.Text = TempRS.AbsolutePosition.ToString + "/" + TempRS.RecordCount.ToString()
        End If
        '如果记录集不为空，显示记录数据

        If User权限 = "普通用户" Then
            Me.btnAdd.Enabled = False
            Me.btnDelete.Enabled = False
        End If
        '如果用户为普通用户，将“添加”和“删除”按钮设置为无效
    End Sub

    Private Sub btnAdd_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnAdd.Click
        TempRS.AddNew()
        TempRS.Fields(1).Value = RecNo.ToString
        TempRS.Fields(2).Value = Me.edit时间.Text
        TempRS.Fields(3).Value = Me.edit类别.Text
        TempRS.Fields(4).Value = Me.edit详细内容.Text
        TempRS.Update()
        奖惩情况_Load(sender, e)
    End Sub

    Private Sub btnNavPrev_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNavPrev.Click
        If TempRS.RecordCount < 1 Then Exit Sub
        If Not TempRS.BOF Then
            TempRS.MovePrevious()
        Else
            TempRS.MoveFirst()
        End If
        If TempRS.BOF Then
            TempRS.MoveFirst()
        End If

        Me.lblNavLocation.Text = TempRS.AbsolutePosition.ToString + "/" + TempRS.RecordCount.ToString()
        Me.edit时间.Text = TempRS.Fields(2).Value.ToString
        Me.edit类别.Text = TempRS.Fields(3).Value.ToString
        Me.edit详细内容.Text = TempRS.Fields(4).Value.ToString
    End Sub

    Private Sub btnNavFirst_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNavFirst.Click
        If TempRS.RecordCount < 1 Then Exit Sub
        TempRS.MoveFirst()
        Me.lblNavLocation.Text = TempRS.AbsolutePosition.ToString + "/" + TempRS.RecordCount.ToString()
        Me.edit时间.Text = TempRS.Fields(2).Value.ToString
        Me.edit类别.Text = TempRS.Fields(3).Value.ToString
        Me.edit详细内容.Text = TempRS.Fields(4).Value.ToString
    End Sub

    Private Sub btnNavNext_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNavNext.Click
        If TempRS.RecordCount < 1 Then Exit Sub
        '如果没有记录，退出此事件过程
        If Not TempRS.EOF Then
            TempRS.MoveNext()
        Else
            TempRS.MoveLast()
        End If
        '如果当前记录指针不是在最后一条记录之后
        '将记录指针移到下一条记录
        '如果当前记录指针在最后一条记录之后
        '将记录指针移到最后一条记录

        If TempRS.EOF Then
            TempRS.MoveLast()
        End If
        '移动记录指针后，如果记录指针在最后一条记录之后
        '将记录指针移到最后一条记录

        Me.lblNavLocation.Text = TempRS.AbsolutePosition.ToString + "/" + TempRS.RecordCount.ToString()
        '在lblNavLocation控件中显示当前记录指针的位置和总记录数
        Me.edit时间.Text = TempRS.Fields(2).Value.ToString
        Me.edit类别.Text = TempRS.Fields(3).Value.ToString
        Me.edit详细内容.Text = TempRS.Fields(4).Value.ToString
        '在各TextBox控件中显示记录指针所指的记录(当前记录)各字段的值
    End Sub

    Private Sub btnLast_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnLast.Click
        If TempRS.RecordCount < 1 Then Exit Sub
        TempRS.MoveLast()
        Me.lblNavLocation.Text = TempRS.AbsolutePosition.ToString + "/" + TempRS.RecordCount.ToString()
        Me.edit时间.Text = TempRS.Fields(2).Value.ToString
        Me.edit类别.Text = TempRS.Fields(3).Value.ToString
        Me.edit详细内容.Text = TempRS.Fields(4).Value.ToString
    End Sub

    Private Sub btnClose_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnClose.Click
        Me.Hide()
    End Sub
End Class