manage_matter.frm

vc考试系统vc在线 考试系统vc在线 考试系统

VERSION 5.00
Begin VB.Form Form8 
   Caption         =   "系统设置"
   ClientHeight    =   4215
   ClientLeft      =   60
   ClientTop       =   450
   ClientWidth     =   4770
   LinkTopic       =   "Form8"
   ScaleHeight     =   4215
   ScaleWidth      =   4770
   StartUpPosition =   3  '窗口缺省
   Begin VB.CommandButton cclean 
      Caption         =   "清除已过期的订单"
      Height          =   495
      Left            =   840
      TabIndex        =   9
      Top             =   3240
      Width           =   2895
   End
   Begin VB.Frame Frame1 
      Height          =   2775
      Left            =   360
      TabIndex        =   0
      Top             =   120
      Width           =   3975
      Begin VB.CommandButton cok 
         Caption         =   "确 定"
         Default         =   -1  'True
         Height          =   375
         Left            =   1200
         TabIndex        =   8
         Top             =   2160
         Width           =   1455
      End
      Begin VB.TextBox Text1 
         Height          =   375
         IMEMode         =   3  'DISABLE
         Index           =   2
         Left            =   1920
         PasswordChar    =   "*"
         TabIndex        =   4
         Top             =   1560
         Width           =   1695
      End
      Begin VB.TextBox Text1 
         Height          =   375
         IMEMode         =   3  'DISABLE
         Index           =   0
         Left            =   1920
         PasswordChar    =   "*"
         TabIndex        =   1
         Top             =   600
         Width           =   1695
      End
      Begin VB.TextBox Text1 
         Height          =   375
         IMEMode         =   3  'DISABLE
         Index           =   1
         Left            =   1920
         PasswordChar    =   "*"
         TabIndex        =   2
         Top             =   1080
         Width           =   1695
      End
      Begin VB.Label Label1 
         Caption         =   "更改密码"
         Height          =   255
         Index           =   3
         Left            =   1680
         TabIndex        =   7
         Top             =   240
         Width           =   855
      End
      Begin VB.Label Label1 
         Caption         =   "再次输入新密码："
         Height          =   255
         Index           =   2
         Left            =   360
         TabIndex        =   6
         Top             =   1680
         Width           =   1455
      End
      Begin VB.Label Label1 
         Caption         =   "请输入新密码："
         Height          =   255
         Index           =   0
         Left            =   360
         TabIndex        =   5
         Top             =   1200
         Width           =   1335
      End
      Begin VB.Label Label1 
         Caption         =   "请输入旧密码："
         Height          =   255
         Index           =   1
         Left            =   360
         TabIndex        =   3
         Top             =   720
         Width           =   1335
      End
   End
End
Attribute VB_Name = "Form8"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cclean_Click()
'询问确认清除
Dim stemp As Integer
stemp = False
stemp = MsgBox("你确定清除已经投放完毕的过期订单吗？", 1 + 32 + 256, "确定清除")
If stemp = 2 Then
   Exit Sub
End If
'删除订阅期过了的订单
If rso.State <> adStateOpen Then
rso.CursorLocation = adUseClient
rso.Open "select * from porder", adodc1, adOpenKeyset, adLockPessimistic
End If
rso.MoveFirst
Do Until rso.EOF
   If rso("time_end") < Date Then
      rso.Delete
   End If
   rso.MoveNext
Loop
MsgBox "投放完毕的过期订单清除完成！", 0, "清除完成"
End Sub

Private Sub cok_Click()
If rstemp.State <> adStateOpen Then
rstemp.CursorLocation = adUseClient
rstemp.Open "select * from manage", adodc1, adOpenKeyset, adLockPessimistic
End If
rstemp.MoveFirst
If rstemp("mpassword") = DigestStrToHexStr(Text1(0).Text) Then
    If Text1(1).Text <> Text1(2).Text Or Text1(1).Text = "" Then
       MsgBox "新密码两次输入不同！请重新输入", 0, "新密码两次输入不同"
       Exit Sub
    End If
Else
    MsgBox "旧密码输入错误！", 0, "旧密码输入错误"
    Exit Sub
End If
'询问确认更改
Dim stemp As Integer
stemp = False
stemp = MsgBox("你确定更改密码吗？", 1 + 32 + 256, "确定更改")
If stemp = 2 Then
   Exit Sub
End If
rstemp("mpassword") = DigestStrToHexStr(Text1(1).Text)
rstemp.Update
MsgBox "更改密码成功！", 0, "更改密码成功"
End Sub