www.pudn.com > new xsc.rar > frmupbanji.frm

VERSION 5.00 
Begin VB.Form frmupbanji  
   Caption         =   "修改班级设置" 
   ClientHeight    =   3195 
   ClientLeft      =   60 
   ClientTop       =   345 
   ClientWidth     =   4680 
   LinkTopic       =   "Form1" 
   MaxButton       =   0   'False 
   MDIChild        =   -1  'True 
   ScaleHeight     =   3195 
   ScaleWidth      =   4680 
   Begin VB.CommandButton Command2  
      Caption         =   "取消" 
      Height          =   495 
      Left            =   2640 
      TabIndex        =   5 
      Top             =   2280 
      Width           =   1095 
   End 
   Begin VB.CommandButton Command1  
      Caption         =   "确定" 
      Height          =   495 
      Left            =   840 
      TabIndex        =   4 
      Top             =   2280 
      Width           =   1095 
   End 
   Begin VB.TextBox Text1  
      Height          =   375 
      Left            =   2160 
      TabIndex        =   3 
      Top             =   1440 
      Width           =   1575 
   End 
   Begin VB.ComboBox Combo1  
      Height          =   300 
      Left            =   2160 
      TabIndex        =   1 
      Text            =   "选择" 
      Top             =   480 
      Width           =   1575 
   End 
   Begin VB.Label Label2  
      Caption         =   "班级人数" 
      Height          =   375 
      Left            =   720 
      TabIndex        =   2 
      Top             =   1560 
      Width           =   855 
   End 
   Begin VB.Label Label1  
      AutoSize        =   -1  'True 
      Caption         =   "班级名称" 
      Height          =   180 
      Left            =   720 
      TabIndex        =   0 
      Top             =   480 
      Width           =   720 
   End 
End 
Attribute VB_Name = "frmupbanji" 
Attribute VB_GlobalNameSpace = False 
Attribute VB_Creatable = False 
Attribute VB_PredeclaredId = True 
Attribute VB_Exposed = False 
Private Sub Command1_Click() 
  Dim mr As ADODB.Recordset 
  Dim msgtext As String 
    If Trim(Combo1) = "选择" Then 
    MsgBox "请选择要修改的班级名称！", vbOKOnly + vbExclamation, "警告" 
     Exit Sub 
  End If 
  If Trim(Text1.Text & "") = "" Then 
    MsgBox "请输入班级名称！", vbOKOnly + vbExclamation, "警告" 
    Text1.SetFocus 
     Exit Sub 
  End If 
  If Not IsNumeric(Trim(Text1.Text)) Then 
     MsgBox "班级人数必须为数字！", vbOKOnly + vbExclamation, "警告" 
     Text2.SetFocus 
     Exit Sub 
  End If 
  txtSQL = "delete from class where id='" & Trim(Combo1) & "'" 
  Set mr = ExecuteSQL(txtSQL, msgtext) 
  txtSQL = "execute addbanji'" 
  txtSQL = txtSQL & Combo1 & "','" 
  txtSQL = txtSQL & Trim(Text1.Text) & "'" 
  Set mr = ExecuteSQL(txtSQL, msgtext) 
  Text1.Text = "" 
  Combo1 = "选择" 
  MsgBox "纪录修改成功！", vbOKOnly + vbExclamation, "提示" 
End Sub 
 
 
Private Sub Command2_Click() 
  Unload Me 
End Sub 
 
Private Sub Form_Load() 
  Me.Height = 3600 
  Me.Width = 4800 
  Me.Top = frmmdi.Height / 2 - 2400 
  Me.Left = frmmdi.Width / 2 - 2400 
  Dim mrccc1 As ADODB.Recordset 
  Dim msgtext1 As String 
  Dim txtSQL As String 
  txtSQL = "select id from class" 
  Set mrccc1 = ExecuteSQL(txtSQL, msgtext1) 
 
   Do While Not mrccc1.EOF 
    Combo1.AddItem mrccc1.Fields(0) 
    mrccc1.MoveNext 
   Loop 
   mrccc1.Close 
   
End Sub