frmsetjiari.frm

用microsoft vb6.0写的上班考勤系统！

VERSION 5.00
Begin VB.Form FrmSetJiaRi 
   Caption         =   "设置每月休息日"
   ClientHeight    =   3810
   ClientLeft      =   60
   ClientTop       =   345
   ClientWidth     =   5460
   ControlBox      =   0   'False
   LinkTopic       =   "Form2"
   Moveable        =   0   'False
   ScaleHeight     =   4769.953
   ScaleMode       =   0  'User
   ScaleWidth      =   5460
   ShowInTaskbar   =   0   'False
   StartUpPosition =   1  '所有者中心
   Begin VB.CommandButton Command2 
      Caption         =   "结束"
      Height          =   495
      Left            =   4440
      TabIndex        =   9
      Top             =   3240
      Width           =   975
   End
   Begin VB.CommandButton Command1 
      Caption         =   "确定"
      Height          =   495
      Left            =   3480
      TabIndex        =   8
      Top             =   3240
      Width           =   975
   End
   Begin VB.Frame Frame3 
      Height          =   495
      Left            =   3600
      TabIndex        =   6
      Top             =   2520
      Width           =   1575
      Begin VB.CheckBox Check1 
         Caption         =   "是否清假"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   210
         Left            =   240
         TabIndex        =   7
         Top             =   240
         Width           =   1215
      End
   End
   Begin VB.Frame Frame2 
      Height          =   975
      Left            =   120
      TabIndex        =   3
      Top             =   1200
      Width           =   3135
      Begin VB.TextBox TianShu 
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   1680
         TabIndex        =   5
         Top             =   360
         Width           =   855
      End
      Begin VB.Label Label3 
         Caption         =   "本月休假天数："
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         Height          =   375
         Left            =   120
         TabIndex        =   4
         Top             =   360
         Width           =   1575
      End
   End
   Begin VB.Frame Frame1 
      Height          =   975
      Left            =   120
      TabIndex        =   0
      Top             =   2520
      Width           =   3255
      Begin VB.Label Label2 
         Caption         =   "注：设置该月休假天数必须在当     月的1号设置"
         BeginProperty Font 
            Name            =   "宋体"
            Size            =   10.5
            Charset         =   134
            Weight          =   400
            Underline       =   0   'False
            Italic          =   0   'False
            Strikethrough   =   0   'False
         EndProperty
         ForeColor       =   &H00FF0000&
         Height          =   495
         Left            =   120
         TabIndex        =   2
         Top             =   360
         Width           =   3015
      End
   End
   Begin VB.Label Label1 
      BackColor       =   &H00000000&
      Caption         =   "设置本月休假天数"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   26.25
         Charset         =   134
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00FFFFFF&
      Height          =   615
      Left            =   480
      TabIndex        =   1
      Top             =   120
      Width           =   4335
   End
End
Attribute VB_Name = "FrmSetJiaRi"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Public Cnn As ADODB.Connection
Public Rst As ADODB.Recordset
Public tian

Private Sub Command1_Click()
  If Check1.Value = 1 Then
                                       
    Do While Not Rst.EOF
      Rst.Fields(1) = TianShu.Text
      Rst.Update
      Rst.MoveNext
    Loop
  Else
    Do While Not Rst.EOF
      tian = Rst.Fields(1)
      Rst.Fields(1) = tian + TianShu.Text
      Rst.Update
      Rst.MoveNext
    Loop
  End If
  MsgBox "数据已保存！！", vbYesNo, "提醒！！！"
  Unload Me

End Sub

Private Sub Command2_Click()
Unload Me
End Sub

Private Sub Form_Load()
  Set Cnn = New ADODB.Connection
  Cnn.Open "kaoqin", "andy", "1234"
  Set Rst = New ADODB.Recordset
  'Rst.Open "select xingming,tianshu from qingjiatianshu ", Cnn, adOpenKeyset, adLockOptimistic, adCmdText
  Rst.Open "qingjiatianshu", Cnn, adOpenDynamic, adLockOptimistic, adCmdTable
End Sub