⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 frmevaedit.frm

📁 vb与access数据库的操作实例
💻 FRM
字号:
VERSION 5.00
Begin VB.Form FrmEvaEdit 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "编辑考评信息"
   ClientHeight    =   4875
   ClientLeft      =   45
   ClientTop       =   345
   ClientWidth     =   9075
   Icon            =   "FrmEvaEdit.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   4875
   ScaleWidth      =   9075
   StartUpPosition =   2  '屏幕中心
   Begin VB.Frame Frame2 
      Caption         =   "总体评价"
      Height          =   1095
      Left            =   120
      TabIndex        =   19
      Top             =   2880
      Width           =   4335
      Begin VB.TextBox txtZt 
         Height          =   735
         Left            =   120
         MaxLength       =   200
         MultiLine       =   -1  'True
         ScrollBars      =   2  'Vertical
         TabIndex        =   20
         Top             =   240
         Width           =   4095
      End
   End
   Begin VB.Frame Frame9 
      Caption         =   "本月奖励"
      Height          =   1695
      Left            =   120
      TabIndex        =   14
      Top             =   1080
      Width           =   4335
      Begin VB.TextBox txtJl 
         Height          =   855
         Left            =   1200
         MaxLength       =   200
         MultiLine       =   -1  'True
         ScrollBars      =   2  'Vertical
         TabIndex        =   16
         Top             =   240
         Width           =   3015
      End
      Begin VB.TextBox txtJlamount 
         Alignment       =   1  'Right Justify
         Height          =   270
         Left            =   1200
         MaxLength       =   15
         TabIndex        =   15
         Top             =   1200
         Width           =   1455
      End
      Begin VB.Label Label39 
         AutoSize        =   -1  'True
         Caption         =   "奖励事由"
         Height          =   180
         Left            =   240
         TabIndex        =   18
         Top             =   360
         Width           =   720
      End
      Begin VB.Label Label40 
         AutoSize        =   -1  'True
         BackColor       =   &H00FFC0C0&
         BackStyle       =   0  'Transparent
         Caption         =   "奖励金额"
         Height          =   180
         Left            =   240
         TabIndex        =   17
         Top             =   1245
         Width           =   720
      End
   End
   Begin VB.Frame Frame8 
      Caption         =   "备注"
      Height          =   1095
      Left            =   4440
      TabIndex        =   12
      Top             =   2880
      Width           =   4335
      Begin VB.TextBox txtMemo1 
         Height          =   735
         Left            =   120
         MaxLength       =   200
         MultiLine       =   -1  'True
         ScrollBars      =   2  'Vertical
         TabIndex        =   13
         Top             =   240
         Width           =   4095
      End
   End
   Begin VB.Frame Frame3 
      Caption         =   "本月处罚"
      Height          =   1695
      Left            =   4440
      TabIndex        =   7
      Top             =   1080
      Width           =   4335
      Begin VB.TextBox txtCfamount 
         Alignment       =   1  'Right Justify
         Height          =   270
         Left            =   1200
         MaxLength       =   15
         TabIndex        =   9
         Top             =   1200
         Width           =   1455
      End
      Begin VB.TextBox txtCf 
         Height          =   855
         Left            =   1200
         MaxLength       =   200
         MultiLine       =   -1  'True
         ScrollBars      =   2  'Vertical
         TabIndex        =   8
         Top             =   240
         Width           =   3015
      End
      Begin VB.Label Label41 
         AutoSize        =   -1  'True
         BackColor       =   &H00FFC0C0&
         BackStyle       =   0  'Transparent
         Caption         =   "处罚金额"
         Height          =   180
         Left            =   240
         TabIndex        =   11
         Top             =   1245
         Width           =   720
      End
      Begin VB.Label Label42 
         AutoSize        =   -1  'True
         Caption         =   "处罚事由"
         Height          =   180
         Left            =   240
         TabIndex        =   10
         Top             =   360
         Width           =   720
      End
   End
   Begin VB.Frame Frame1 
      Caption         =   "基本信息"
      Height          =   855
      Left            =   120
      TabIndex        =   3
      Top             =   120
      Width           =   8655
      Begin VB.ComboBox ComboName 
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   9
            Charset         =   0
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   300
         ItemData        =   "FrmEvaEdit.frx":0CCA
         Left            =   3960
         List            =   "FrmEvaEdit.frx":0CCC
         TabIndex        =   2
         Text            =   "ComboName"
         Top             =   300
         Width           =   1335
      End
      Begin VB.Label Label1 
         AutoSize        =   -1  'True
         BackStyle       =   0  'Transparent
         Caption         =   "考评月份"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   9
            Charset         =   0
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H00000000&
         Height          =   180
         Left            =   240
         TabIndex        =   6
         Top             =   360
         Width           =   720
      End
      Begin VB.Label Label8 
         AutoSize        =   -1  'True
         BackColor       =   &H00FFC0C0&
         BackStyle       =   0  'Transparent
         Caption         =   "员工姓名"
         Height          =   180
         Left            =   2880
         TabIndex        =   5
         Top             =   360
         Width           =   720
      End
      Begin VB.Label lblMonth 
         AutoSize        =   -1  'True
         BackStyle       =   0  'Transparent
         Caption         =   "2002-9"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   9
            Charset         =   0
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H00000000&
         Height          =   180
         Left            =   1560
         TabIndex        =   4
         Top             =   360
         Width           =   540
      End
   End
   Begin VB.CommandButton Cmd_Cancel 
      Cancel          =   -1  'True
      Caption         =   "取 消"
      Height          =   400
      Left            =   5027
      MouseIcon       =   "FrmEvaEdit.frx":0CCE
      MousePointer    =   99  'Custom
      Style           =   1  'Graphical
      TabIndex        =   1
      Top             =   4200
      Width           =   1300
   End
   Begin VB.CommandButton Cmd_OK 
      Caption         =   "确 定"
      Default         =   -1  'True
      Height          =   400
      Left            =   2747
      MouseIcon       =   "FrmEvaEdit.frx":0FD8
      MousePointer    =   99  'Custom
      Style           =   1  'Graphical
      TabIndex        =   0
      Top             =   4200
      Width           =   1300
   End
End
Attribute VB_Name = "FrmEvaEdit"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public OriEmpId As Long  '考评员工编号
Public TmpOk As Boolean

Private Sub Cmd_Cancel_Click()
  TmpOk = False
  Unload Me
End Sub

Private Sub Cmd_OK_Click()
  If UpperEmp.EmpId <= 0 Then
    MsgBox "请选择员工"
    Exit Sub
  End If
  If Trim(txtZt) = "" Then
    MsgBox "请输入总体评价"
    Exit Sub
  End If
  With MyEva
  .EvaMonth = lblMonth          '考评月份
  .EmpId = UpperEmp.EmpId       '考评员工编号
  .ztEva = MakeStr(txtZt)       '总体评价
  .jlReason = MakeStr(txtJl)    '奖励原因
  .jlAmount = Val(txtJlamount)  '奖励金额
  .cfReason = MakeStr(txtCf)    '处罚原因
  .cfAmount = Val(txtCfamount)  '处罚金额
  .Memo1 = MakeStr(txtMemo1)    '备注
  '如果当前记录存在,则修改,否则添加
  If .In_DB(lblMonth, UpperEmp.EmpId) Then
    Call .Update(lblMonth, OriEmpId)
  Else
    .Insert
  End If
  End With
  TmpOk = True
  MsgBox "数据保存成功"
  Unload Me
End Sub

Private Sub ComboName_GotFocus()
  txtZt.SetFocus
  '设置FrmEmpSel窗体的位置
  FrmEmpSel.Left = Me.Left + ComboName.Left + 350 - FrmEmpSel.Width
  FrmEmpSel.Top = Me.Top + ComboName.Top + ComboName.Height + 450
  FrmEmpSel.Show 1
  '将选择的员工姓名显示到ComboUpper控件中
  ComboName.Text = UpperEmp.EmpName
  OriEmpId = UpperEmp.EmpId
End Sub

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -