frmstudent.frm

图书管理系统 欢迎大家来使用 谢谢!

VERSION 5.00
Begin VB.Form Frmstudent 
   BorderStyle     =   0  'None
   Caption         =   "Form1"
   ClientHeight    =   3870
   ClientLeft      =   0
   ClientTop       =   0
   ClientWidth     =   6270
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   3870
   ScaleWidth      =   6270
   ShowInTaskbar   =   0   'False
   StartUpPosition =   2  '屏幕中心
   Begin VB.TextBox txtPassword 
      Height          =   375
      Left            =   2400
      TabIndex        =   5
      Top             =   2280
      Width           =   2295
   End
   Begin VB.TextBox txtUserName 
      Height          =   345
      Left            =   2400
      TabIndex        =   2
      Top             =   1800
      Width           =   2325
   End
   Begin VB.CommandButton cmdOK 
      Caption         =   "确定"
      Height          =   390
      Left            =   1800
      TabIndex        =   1
      Top             =   3000
      Width           =   1140
   End
   Begin VB.CommandButton cmdCancel 
      Caption         =   "取消"
      Height          =   390
      Left            =   3840
      TabIndex        =   0
      Top             =   3000
      Width           =   1140
   End
   Begin VB.Label lblLabels 
      BackStyle       =   0  'Transparent
      Caption         =   "姓名(&U):"
      Height          =   270
      Index           =   0
      Left            =   1440
      TabIndex        =   4
      Top             =   2400
      Width           =   1080
   End
   Begin VB.Label lblLabels 
      BackStyle       =   0  'Transparent
      Caption         =   "卡号(&P):"
      Height          =   270
      Index           =   1
      Left            =   1440
      TabIndex        =   3
      Top             =   1800
      Width           =   1080
   End
   Begin VB.Image Image1 
      Height          =   3870
      Left            =   0
      Picture         =   "Frmstudent.frx":0000
      Top             =   0
      Width           =   6270
   End
End
Attribute VB_Name = "Frmstudent"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim Time As Date

Private Sub cmdCancel_Click()

Unload Me
frmSplash.Show
End Sub

Private Sub cmdOK_Click()
Open_Student_message
Do While cnn.EOF = False
If cnn.EOF = True Then
Exit Do
End If
If cnn.Fields(0).Value = txtUserName.Text And cnn.Fields(2).Value = txtPassword.Text Then
student_ic = cnn.Fields(0).Value
student_id = cnn.Fields(1).Value
student_name = cnn.Fields(2).Value
Borrow_no = cnn.Fields(5).Value
ynmoney = cnn.Fields(6).Value
student_class = cnn.Fields(7).Value
Unload Me
borrow_time
set_window  '系统设置
FrmMain.Show
Exit Sub
End If
cnn.MoveNext
Loop

'Open_Student_message
'cnn.MovePrevious
'Do While cnn.EOF = False
'If cnn.EOF = True Then
'Exit Do
'End If

'If cnn.Fields(0).Value = txtUserName.Text Then
'MsgBox " 你输入的密码有误，请重新输入！"
'End If
'If cnn.Fields(2).Value = txtPassword.Text Then
'MsgBox " 你输入的用户名有误，请重新输入！"
'End If
'cnn.MoveNext
'Loop
MsgBox "你输入有误，请重新输入！"

End Sub


Public Sub borrow_time()
Open_borrow_book
Do While cnn.EOF = False
If cnn.EOF = True Then
Exit Sub
End If

If cnn.Fields(0).Value = student_ic Then


Time = cnn.Fields(7).Value
x = DateDiff("d", Now, Time)
cnn.Fields(8) = x


End If
cnn.MoveNext
Loop
End Sub