formfttime.frm

这是一个人事管理软件

      Top             =   960
      Width           =   855
   End
   Begin VB.TextBox Text4 
      DataField       =   "stimem"
      DataSource      =   "Adcfttime"
      ForeColor       =   &H000000FF&
      Height          =   270
      Left            =   3120
      TabIndex        =   7
      Top             =   600
      Width           =   855
   End
   Begin VB.TextBox Text3 
      DataField       =   "stimeh"
      DataSource      =   "Adcfttime"
      ForeColor       =   &H000000FF&
      Height          =   270
      Left            =   1440
      TabIndex        =   5
      Top             =   600
      Width           =   855
   End
   Begin VB.TextBox Text2 
      DataField       =   "fttname"
      DataSource      =   "Adcfttime"
      ForeColor       =   &H000000FF&
      Height          =   270
      Left            =   3120
      TabIndex        =   3
      Top             =   240
      Width           =   1095
   End
   Begin VB.TextBox Text1 
      DataField       =   "fttid"
      DataSource      =   "Adcfttime"
      ForeColor       =   &H000000FF&
      Height          =   270
      Left            =   1440
      TabIndex        =   1
      Top             =   240
      Width           =   735
   End
   Begin VB.Label Label9 
      Caption         =   "限定分"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H8000000D&
      Height          =   255
      Left            =   4320
      TabIndex        =   21
      Top             =   240
      Width           =   615
   End
   Begin VB.Label Label8 
      Caption         =   "分"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H8000000D&
      Height          =   255
      Left            =   3960
      TabIndex        =   13
      Top             =   960
      Width           =   255
   End
   Begin VB.Label Label7 
      Caption         =   "点"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H8000000D&
      Height          =   255
      Left            =   2280
      TabIndex        =   11
      Top             =   960
      Width           =   255
   End
   Begin VB.Label Label6 
      Caption         =   "结束时间"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H8000000D&
      Height          =   255
      Left            =   480
      TabIndex        =   9
      Top             =   960
      Width           =   975
   End
   Begin VB.Label Label5 
      Caption         =   "点"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H8000000D&
      Height          =   255
      Left            =   2280
      TabIndex        =   8
      Top             =   600
      Width           =   255
   End
   Begin VB.Label Label4 
      Caption         =   "分"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H8000000D&
      Height          =   255
      Left            =   3960
      TabIndex        =   6
      Top             =   600
      Width           =   255
   End
   Begin VB.Label Label3 
      Caption         =   "开始时间"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H8000000D&
      Height          =   255
      Left            =   480
      TabIndex        =   4
      Top             =   600
      Width           =   855
   End
   Begin VB.Label Label2 
      Caption         =   "名称"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H8000000D&
      Height          =   255
      Left            =   2640
      TabIndex        =   2
      Top             =   240
      Width           =   495
   End
   Begin VB.Label Label1 
      Caption         =   "就餐编号"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H8000000D&
      Height          =   255
      Left            =   480
      TabIndex        =   0
      Top             =   240
      Width           =   855
   End
End
Attribute VB_Name = "Formfttime"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim vbookmark As Variant
Dim lcurrrec As Long
Dim baddnewflag As Boolean
Dim WithEvents adors As Recordset
Attribute adors.VB_VarHelpID = -1

Private Sub Cmdaction_Click(Index As Integer)
Dim response
With adors
Select Case Index
Case 0
If Not (.BOF And .EOF) Then
vbookmark = .Bookmark
End If
.AddNew
baddnewflag = True
setbuttons False
Cmdaction(3).Enabled = True
Case 1
response = MsgBox("Are you sure", vbYesNo, "delete record")
If response = vbYes Then
.Delete
.MoveNext
End If
If .EOF Then
lcurrrec = .RecordCount
.MoveLast
End If
Case 2
Dim vmbmid, vmbmname As String
.Requery
Cmdaction(3).Enabled = False

Case 3
response = MsgBox("你确信要更新", vbYesNo, "更新数据")
If response = vbYes Then
.UpdateBatch adAffectAll
lcurrrec = .RecordCount
.MoveLast
End If
setbuttons True
Cmdaction(3).Enabled = False
Case 4
Cmdaction(3).Enabled = True
End Select
End With
End Sub
Private Sub setbuttons(bval As Boolean)
Cmdaction(0).Enabled = bval
Cmdaction(1).Enabled = bval
Cmdaction(2).Enabled = bval
End Sub

Private Sub Command1_Click()
Dim iresponse As Integer
If Cmdaction(3).Enabled Then
iresponse = MsgBox("data changed ,save it?", vbYesNo, "update data?")
If iresponse = vbYes Then
adors.UpdateBatch adAffectAll
 Else
adors.CancelUpdate
End If
End If
adors.Close
Unload Me
End Sub

Private Sub DataGrid1_Change()
Cmdaction(3).Enabled = True
End Sub

Private Sub Form_Load()
Set adors = Adcfttime.Recordset

End Sub