人事变动.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 lbl职位 As System.Windows.Forms.Label
    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 btnAdd As System.Windows.Forms.Button
    Friend WithEvents btnDelete As System.Windows.Forms.Button
    Friend WithEvents btnClose As System.Windows.Forms.Button
    Friend WithEvents edit时间 As System.Windows.Forms.TextBox
    Friend WithEvents edit变动 As System.Windows.Forms.TextBox
    Friend WithEvents edit职位 As System.Windows.Forms.TextBox
    Friend WithEvents btnNavLast 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.btnNavLast = 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(8, 8)
        Me.lbl时间.Name = "lbl时间"
        Me.lbl时间.TabIndex = 34
        Me.lbl时间.Text = "时间"
        '
        'lbl变动
        '
        Me.lbl变动.Location = New System.Drawing.Point(8, 40)
        Me.lbl变动.Name = "lbl变动"
        Me.lbl变动.TabIndex = 35
        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 = 36
        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 = 37
        Me.edit变动.Text = ""
        '
        'lbl职位
        '
        Me.lbl职位.Location = New System.Drawing.Point(8, 72)
        Me.lbl职位.Name = "lbl职位"
        Me.lbl职位.TabIndex = 38
        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 = 39
        Me.edit职位.Text = ""
        '
        'btnNavFirst
        '
        Me.btnNavFirst.Location = New System.Drawing.Point(16, 112)
        Me.btnNavFirst.Name = "btnNavFirst"
        Me.btnNavFirst.Size = New System.Drawing.Size(40, 23)
        Me.btnNavFirst.TabIndex = 40
        Me.btnNavFirst.Text = "<<"
        '
        'btnNavPrev
        '
        Me.btnNavPrev.Location = New System.Drawing.Point(56, 112)
        Me.btnNavPrev.Name = "btnNavPrev"
        Me.btnNavPrev.Size = New System.Drawing.Size(35, 23)
        Me.btnNavPrev.TabIndex = 41
        Me.btnNavPrev.Text = "<"
        '
        'lblNavLocation
        '
        Me.lblNavLocation.BackColor = System.Drawing.Color.White
        Me.lblNavLocation.Location = New System.Drawing.Point(88, 112)
        Me.lblNavLocation.Name = "lblNavLocation"
        Me.lblNavLocation.Size = New System.Drawing.Size(95, 23)
        Me.lblNavLocation.TabIndex = 42
        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 = 43
        Me.btnNavNext.Text = ">"
        '
        'btnNavLast
        '
        Me.btnNavLast.Location = New System.Drawing.Point(208, 112)
        Me.btnNavLast.Name = "btnNavLast"
        Me.btnNavLast.Size = New System.Drawing.Size(40, 23)
        Me.btnNavLast.TabIndex = 44
        Me.btnNavLast.Text = ">>"
        '
        'btnAdd
        '
        Me.btnAdd.Location = New System.Drawing.Point(16, 144)
        Me.btnAdd.Name = "btnAdd"
        Me.btnAdd.TabIndex = 45
        Me.btnAdd.Text = "添加(&A)"
        '
        'btnDelete
        '
        Me.btnDelete.Location = New System.Drawing.Point(96, 144)
        Me.btnDelete.Name = "btnDelete"
        Me.btnDelete.TabIndex = 46
        Me.btnDelete.Text = "删除(&D)"
        '
        'btnClose
        '
        Me.btnClose.Location = New System.Drawing.Point(184, 144)
        Me.btnClose.Name = "btnClose"
        Me.btnClose.TabIndex = 47
        Me.btnClose.Text = "关闭(&C)"
        '
        '人事变动
        '
        Me.AutoScaleBaseSize = New System.Drawing.Size(6, 14)
        Me.ClientSize = New System.Drawing.Size(272, 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.btnNavLast, 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
    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()
        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 btnLast_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnNavLast.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