⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 frmchgpwd.frm

📁 管理文档的原代码,可以把扫描的文档归类,便于查询
💻 FRM
字号:
VERSION 5.00
Begin VB.Form FrmChgPwd 
   BorderStyle     =   3  'Fixed Dialog
   Caption         =   "柜员密码修改"
   ClientHeight    =   3165
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   4260
   Icon            =   "FrmChgPwd.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   3165
   ScaleWidth      =   4260
   ShowInTaskbar   =   0   'False
   StartUpPosition =   2  'CenterScreen
   Begin VB.PictureBox Picture2 
      BorderStyle     =   0  'None
      Height          =   135
      Left            =   0
      Picture         =   "FrmChgPwd.frx":0442
      ScaleHeight     =   135
      ScaleWidth      =   7455
      TabIndex        =   12
      Top             =   600
      Width           =   7455
      Begin VB.PictureBox Picture3 
         BorderStyle     =   0  'None
         Height          =   135
         Left            =   1920
         Picture         =   "FrmChgPwd.frx":1CA8
         ScaleHeight     =   135
         ScaleWidth      =   5655
         TabIndex        =   13
         Top             =   0
         Width           =   5655
      End
   End
   Begin VB.Frame Frame1 
      Height          =   125
      Left            =   0
      TabIndex        =   11
      Top             =   2535
      Width           =   4215
   End
   Begin VB.TextBox TxtCZYDH 
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   315
      Left            =   1800
      TabIndex        =   0
      Top             =   840
      Width           =   2295
   End
   Begin VB.TextBox TxtPassWord 
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   315
      IMEMode         =   3  'DISABLE
      Left            =   1800
      PasswordChar    =   "*"
      TabIndex        =   6
      Top             =   1275
      Width           =   2295
   End
   Begin VB.TextBox TxtNewPass 
      Height          =   315
      IMEMode         =   3  'DISABLE
      Left            =   1800
      PasswordChar    =   "*"
      TabIndex        =   5
      Top             =   1725
      Width           =   2295
   End
   Begin VB.TextBox TxtConfirmPass 
      Height          =   315
      IMEMode         =   3  'DISABLE
      Left            =   1800
      PasswordChar    =   "*"
      TabIndex        =   4
      Top             =   2160
      Width           =   2295
   End
   Begin VB.PictureBox Picture1 
      BorderStyle     =   0  'None
      Height          =   615
      Left            =   0
      Picture         =   "FrmChgPwd.frx":34D2
      ScaleHeight     =   615
      ScaleWidth      =   4935
      TabIndex        =   3
      Top             =   0
      Width           =   4935
      Begin VB.Timer Timer1 
         Interval        =   50
         Left            =   240
         Top             =   120
      End
   End
   Begin VB.CommandButton CmdCancel 
      Caption         =   "返回(&R)"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9.75
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   315
      Left            =   3240
      TabIndex        =   2
      Top             =   2760
      Width           =   855
   End
   Begin VB.CommandButton CmdOK 
      Caption         =   "确定(&O)"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9.75
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   315
      Left            =   2280
      TabIndex        =   1
      Top             =   2760
      Width           =   855
   End
   Begin VB.Label Label1 
      Caption         =   "操 作 员:"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9.75
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   195
      Index           =   0
      Left            =   720
      TabIndex        =   10
      Top             =   900
      Width           =   1095
   End
   Begin VB.Label Label1 
      Caption         =   "旧 密 码:"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9.75
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   195
      Index           =   1
      Left            =   720
      TabIndex        =   9
      Top             =   1335
      Width           =   1095
   End
   Begin VB.Label Label2 
      BackStyle       =   0  'Transparent
      Caption         =   "确认密码:"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9.75
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   195
      Left            =   720
      TabIndex        =   8
      Top             =   2220
      Width           =   1095
   End
   Begin VB.Label Label4 
      BackStyle       =   0  'Transparent
      Caption         =   "新 密 码:"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   9.75
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   195
      Left            =   720
      TabIndex        =   7
      Top             =   1785
      Width           =   1095
   End
   Begin VB.Image Image1 
      Height          =   480
      Left            =   120
      Picture         =   "FrmChgPwd.frx":D874
      Top             =   840
      Width           =   480
   End
End
Attribute VB_Name = "FrmChgPwd"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit

'使用本模块需包含 MdlLogin的定义

Private Sub CmdCancel_Click()
Unload Me
End Sub

Private Sub CmdOK_Click()
On Error GoTo Err

Dim t_Rtn_String As String
Dim t_Rtn_Code As Integer
Dim t_User_Info As User_Info

t_Rtn_Code = Login(Trim(TxtCZYDH.Text), TxtPassWord.Text, t_Rtn_String, t_User_Info)

Set GblRdoRes = GblRdoCon.OpenResultset("select * from user_table where upper(login_name)='" + UCase(TxtCZYDH) + "'", _
                             rdOpenDynamic, rdConcurRowVer)
If GblRdoRes.EOF Then GoTo Err
'函数返回:1 登录成功 非1登录失败 2  操作员被锁定   3   口令不正确
'4  3次不正确,锁定   5  操作员不存在 6 系统无操作员 7操作员正在使用中

If t_Rtn_Code <> 1 And t_Rtn_Code <> 7 Then '登录不成功
   Select Case t_Rtn_Code
      Case 2, 5, 6
           MsgBox t_Rtn_String, vbExclamation, "密码修改提示"
           TxtCZYDH.SetFocus
      Case 3
           MsgBox t_Rtn_String, vbExclamation, "密码修改提示"
           TxtPassWord.SetFocus
      Case 4, 6
           Unload Me
           Exit Sub
   End Select
   Exit Sub
End If

If TxtNewPass.Text <> TxtConfirmPass.Text Then
   MsgBox "请确认输入的新口令是否一致", vbQuestion, "密码修改提示"
   TxtNewPass.SetFocus
   Exit Sub
End If

GblRdoCon.Execute "update user_table set password='" & _
                  Des(TxtNewPass, CStr(GblRdoRes.rdoColumns("user_id")), 1) & _
                  "' where upper(login_name)='" + UCase(TxtCZYDH) + "'"
MsgBox "您已经成功修改了密码,下次登录时将启用新密码", vbExclamation, "密码修改提示"

Call SaveEventLog("6011", 0, "", "", "修改密码")

Unload Me
Exit Sub
Err:
   MsgBox "用户密码修改失败,请与管理员联系", vbExclamation, "密码修改提示"
End Sub

Private Sub Form_Load()
TxtCZYDH = g_User_Info.Login_Name

End Sub

Private Sub Timer1_Timer()
   Picture3.Left = Picture3.Left + 50
   If Picture3.Left > Picture2.Left + Picture2.Width Then
      Picture3.Left = Picture2.Left - Picture3.Width
   End If
End Sub

Private Sub TxtNewPass_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 13 Then
TxtConfirmPass.SetFocus
ElseIf KeyCode = 38 Then
TxtPassWord.SetFocus
End If
End Sub

Private Sub TxtConfirmPass_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 13 Then
CmdOK.SetFocus
ElseIf KeyCode = 38 Then
TxtNewPass.SetFocus
End If
End Sub

Private Sub TxtCZYDH_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 13 Or KeyCode = 40 Then
   TxtPassWord.SetFocus
End If
End Sub

Private Sub TxtPassWord_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = 13 Then
TxtNewPass.SetFocus
ElseIf KeyCode = 38 Then
TxtCZYDH.SetFocus
End If
End Sub

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -