frmmoneydel.frm

用VB实现的一个学生管理系统

VERSION 5.00
Begin VB.Form frmmoneydel 
   BackColor       =   &H00FFFFFF&
   BorderStyle     =   1  'Fixed Single
   Caption         =   "删除学生交费资料"
   ClientHeight    =   2025
   ClientLeft      =   45
   ClientTop       =   435
   ClientWidth     =   2985
   ControlBox      =   0   'False
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   2025
   ScaleWidth      =   2985
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton Command2 
      Caption         =   "返回"
      Height          =   375
      Left            =   1680
      TabIndex        =   5
      Top             =   1440
      Width           =   975
   End
   Begin VB.CommandButton Command1 
      Caption         =   "确认删除"
      Height          =   375
      Left            =   240
      TabIndex        =   4
      Top             =   1440
      Width           =   975
   End
   Begin VB.ComboBox cobyear 
      Height          =   300
      Left            =   1320
      TabIndex        =   3
      Text            =   "cobyear"
      Top             =   840
      Width           =   1455
   End
   Begin VB.TextBox Text1 
      Height          =   270
      Left            =   1320
      TabIndex        =   1
      Text            =   "Text1"
      Top             =   360
      Width           =   1455
   End
   Begin VB.Label Label2 
      BackColor       =   &H00FFFFFF&
      Caption         =   "请选择学年："
      Height          =   255
      Left            =   120
      TabIndex        =   2
      Top             =   840
      Width           =   1095
   End
   Begin VB.Label Label1 
      BackColor       =   &H00FFFFFF&
      Caption         =   "请输入学号："
      Height          =   255
      Left            =   120
      TabIndex        =   0
      Top             =   360
      Width           =   1215
   End
End
Attribute VB_Name = "frmmoneydel"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Command1_Click()
sCon = "select * from Cost where 学号='" & Trim(Text1.Text) & "'and 学年='" & Trim(cobyear.Text) & "'"

Set adoRS = adoCon.Execute(sCon)
If adoRS.EOF Then
MsgBox Trim(Text1.Text) & "学生在" & Trim(cobyear.Text) & "年度交费资料不存在！", vbOKOnly + vbExclamation, "系统提示"
   Text1.SetFocus
   Exit Sub
Else
If MsgBox("学号：" & Trim(Text1.Text) & vbCrLf & "学年：" & Trim(cobyear.Text) & vbCrLf & "确定要删除吗？", vbYesNo + vbQuestion, "系统提示") = vbYes Then
sCon = "delete from Cost where 学号='" & Trim(Text1.Text) & "'and 学年='" & Trim(cobyear.Text) & "'"
Set adoRS = adoCon.Execute(sCon)
MsgBox "删除成功！", vbOKOnly + vbInformation, "系统提示"
Text1.Text = ""
cobyear.Text = ""
End If
End If


End Sub

Private Sub Command2_Click()
Unload Me
End Sub

Private Sub Form_Load()
Me.Move (Screen.Width - Me.Width) / 2, (Screen.Height - Me.Height) / 2 - 800
For i = 1990 To 2050
With cobyear
.AddItem i
End With
Next i
Text1.Text = ""
cobyear.ListIndex = 0
End Sub