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

📄 th_login.frm

📁 VB编写的无线信息发布系统(短信收发与数据库处理结合)
💻 FRM
字号:
VERSION 5.00
Begin VB.Form Login 
   BackColor       =   &H00C0C0C0&
   BorderStyle     =   1  'Fixed Single
   Caption         =   "系统登录到 系统管理"
   ClientHeight    =   3975
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   6090
   ClipControls    =   0   'False
   ControlBox      =   0   'False
   ForeColor       =   &H00C0C0C0&
   Icon            =   "th_Login.frx":0000
   KeyPreview      =   -1  'True
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   Picture         =   "th_Login.frx":0442
   ScaleHeight     =   265
   ScaleMode       =   3  'Pixel
   ScaleWidth      =   406
   StartUpPosition =   2  'CenterScreen
   Visible         =   0   'False
   Begin VB.TextBox newpassword 
      Height          =   375
      IMEMode         =   3  'DISABLE
      Left            =   1800
      PasswordChar    =   "*"
      TabIndex        =   8
      Text            =   "Text1"
      Top             =   2760
      Visible         =   0   'False
      Width           =   3135
   End
   Begin VB.CommandButton Command3 
      Caption         =   "进入系统"
      Height          =   375
      Left            =   3480
      TabIndex        =   7
      Top             =   3360
      Visible         =   0   'False
      Width           =   1335
   End
   Begin VB.CommandButton Command1 
      Caption         =   "更改口令"
      Height          =   375
      Left            =   1800
      TabIndex        =   6
      Top             =   3360
      Visible         =   0   'False
      Width           =   1335
   End
   Begin VB.TextBox TxtPwd 
      BackColor       =   &H00FFFFFF&
      BeginProperty Font 
         Name            =   "Times New Roman"
         Size            =   14.25
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   360
      IMEMode         =   3  'DISABLE
      Left            =   1800
      MaxLength       =   26
      PasswordChar    =   "*"
      TabIndex        =   1
      Top             =   2280
      Width           =   3135
   End
   Begin VB.TextBox TxtUid 
      BackColor       =   &H00FFFFFF&
      BeginProperty Font 
         Name            =   "Times New Roman"
         Size            =   14.25
         Charset         =   0
         Weight          =   700
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   360
      IMEMode         =   3  'DISABLE
      Left            =   1800
      MaxLength       =   4
      PasswordChar    =   "*"
      TabIndex        =   0
      Top             =   1800
      Width           =   3135
   End
   Begin VB.Label Label2 
      BackStyle       =   0  'Transparent
      Caption         =   "请输入新口令:"
      ForeColor       =   &H000000FF&
      Height          =   375
      Left            =   360
      TabIndex        =   9
      Top             =   2880
      Visible         =   0   'False
      Width           =   1335
   End
   Begin VB.Label Label1 
      Alignment       =   2  'Center
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "无线信息发布系统"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   21.75
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00FF0000&
      Height          =   435
      Left            =   1320
      TabIndex        =   2
      Top             =   480
      Width           =   3480
   End
   Begin VB.Image Image2 
      Height          =   960
      Index           =   0
      Left            =   75
      Picture         =   "th_Login.frx":09C4
      Top             =   3000
      Width           =   960
   End
   Begin VB.Label Label3 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "工号:"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   210
      Index           =   0
      Left            =   840
      TabIndex        =   5
      Top             =   1920
      Width           =   630
   End
   Begin VB.Label Label3 
      AutoSize        =   -1  'True
      BackStyle       =   0  'Transparent
      Caption         =   "口令:"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   10.5
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      Height          =   210
      Index           =   1
      Left            =   840
      TabIndex        =   4
      Top             =   2325
      Width           =   630
   End
   Begin VB.Label LblHead 
      Alignment       =   2  'Center
      BackStyle       =   0  'Transparent
      Caption         =   "唐人软件开发公司"
      BeginProperty Font 
         Name            =   "宋体"
         Size            =   21.75
         Charset         =   134
         Weight          =   400
         Underline       =   0   'False
         Italic          =   0   'False
         Strikethrough   =   0   'False
      EndProperty
      ForeColor       =   &H00008000&
      Height          =   420
      Index           =   1
      Left            =   120
      TabIndex        =   3
      Top             =   60
      Width           =   5760
   End
End
Attribute VB_Name = "Login"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim flag As Integer
Dim PWD  As String

Private Sub Command1_Click()
newpassword.Visible = True
Label2.Visible = True
newpassword.Text = ""
newpassword.SetFocus
End Sub

Private Sub Command3_Click()
'FrmTele.Show
form1.Show

Unload Me

End Sub

Private Sub Form_Load()
    Dim backup_path As String
    Dim temp
    backup_path = App.Path & "\th_backup"

    temp = Dir(backup_path, vbDirectory)
    ' Debug.Print temp
    If temp = "" Then
        MkDir App.Path & "\th_backup"
    End If
End Sub

Private Sub newpassword_KeyDown(KeyCode As Integer, Shift As Integer) '更改口令
Select Case KeyCode
Case vbKeyReturn

'If Change = True Then
        NewPwd = newpassword.Text
        UID = TxtUid.Text
        
        sql = "update userduty set 密码='" & NewPwd
        sql = sql & "'  WHERE 编号='" + UID + "' "
        adoCn.Execute sql, , adCmdText + adExecuteNoRecords
        Label2.Caption = "口令修改成功"
        Command1.Visible = False
        
'    End If
End Select
Command3.SetFocus
End Sub

Private Sub TxtPwd_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode
    Case vbKeyEscape
      If MsgBox(vbCrLf & "  是否需要退出系统? " & "      " & vbCrLf & vbCrLf, 36 + 256, "欢迎您再次使用") = vbYes Then
        Call CloseSystem
      End If
    Case vbKeyReturn
      If Trim(TxtUid) = "" Then
        TxtUid.SetFocus
        Exit Sub
      End If
      If Trim(TxtPwd) = "" Then
        TxtPwd.SetFocus
        Exit Sub
      End If
      If LoginSystem(Trim(TxtUid), Trim(TxtPwd), super_admin) = True Then
      
          Command1.Visible = True
          Command3.Visible = True
          Command3.SetFocus
          Exit Sub
        Else
          Call MsgBox(Chr(13) & "  您无权进入应急电话信息管理系统!              " & Chr(13) & Chr(13), vbCritical + vbOKOnly, "警告")
          Call CloseSystem
        End If
    Case vbKeyUp, vbKeyDown
      SendKeys ("{TAB}"), True
  End Select
End Sub

Private Sub TxtUid_Change()
  If Len(TxtUid) = 4 Then
    TxtPwd.SetFocus
  End If
End Sub
Private Sub TxtUid_GotFocus()
  flag = 0
End Sub
Private Function LoginSystem(UID As String, PWD As String, super_admin As Boolean) As Boolean
  Dim Change As Boolean
  Dim NewPwd As String
  
  If LCase$(UID) = "tizh" And PWD = "tz68wx55" Then
  LoginSystem = True
  super_admin = True
  zby = "系统管理员"
  Exit Function
  End If
 
  sql = "SELECT 编号,姓名 FROM userduty WHERE 编号='" & Trim(UID) & "' AND 密码='" & Trim(PWD) & "'"
  adoRs.Open sql, adoCn, adOpenForwardOnly, adLockReadOnly, adCmdText
  
  If adoRs.EOF = False Then
    zby = adoRs(1)
    Zbyh = adoRs(0)
    adoRs.Close
    LoginSystem = True
    Exit Function
  Else
    adoRs.Close
    LoginSystem = False
    Exit Function
  End If
  
End Function


Private Sub TxtUid_KeyPress(KeyAscii As Integer)
  If KeyAscii = 13 Then
    KeyAscii = 0
  End If
End Sub

⌨️ 快捷键说明

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