📄
字号:
Top = 330
Width = 4455
Begin VB.TextBox LrText
Height = 300
IMEMode = 3 'DISABLE
Index = 0
Left = 1110
MaxLength = 20
PasswordChar = "*"
TabIndex = 7
Top = 420
Width = 3210
End
Begin VB.CommandButton MmqdCommand
Caption = "确定(&O)"
Height = 300
Left = 1110
TabIndex = 10
Top = 2160
Width = 1120
End
Begin VB.CommandButton MmqxCommand
Caption = "取消(&C)"
Height = 300
Left = 2280
TabIndex = 14
Top = 2160
Width = 1125
End
Begin VB.TextBox LrText
Height = 300
IMEMode = 3 'DISABLE
Index = 1
Left = 1110
MaxLength = 20
PasswordChar = "*"
TabIndex = 8
Top = 810
Width = 3210
End
Begin VB.TextBox LrText
Height = 300
IMEMode = 3 'DISABLE
Index = 2
Left = 1110
MaxLength = 20
PasswordChar = "*"
TabIndex = 9
Top = 1200
Width = 3210
End
Begin VB.Line Line1
Index = 2
X1 = 240
X2 = 4290
Y1 = 1770
Y2 = 1770
End
Begin VB.Label TsLabel
AutoSize = -1 'True
Caption = "旧密码:"
Height = 180
Index = 14
Left = 240
TabIndex = 17
Top = 480
Width = 630
End
Begin VB.Label TsLabel
AutoSize = -1 'True
Caption = "新密码:"
Height = 180
Index = 15
Left = 240
TabIndex = 16
Top = 870
Width = 630
End
Begin VB.Label TsLabel
AutoSize = -1 'True
Caption = "确认密码:"
Height = 180
Index = 16
Left = 240
TabIndex = 15
Top = 1260
Width = 810
End
Begin VB.Line Line1
BorderColor = &H00FFFFFF&
Index = 3
X1 = 240
X2 = 4260
Y1 = 1800
Y2 = 1800
End
End
End
End
Attribute VB_Name = "XT_login"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Dim Xtsjljc As String '系统数据服务器连接串
Dim ErpPassWord As String '系统连接密码
Dim Cslj As New ADODB.Connection '测试连接(为屏蔽提示信息)
Dim Tsxx As String '系统提示信息
Dim Czyrec As New ADODB.Recordset '操作员动态集
Dim Xtrlrec As New ADODB.Recordset '系统日历动态集
Dim Ztdqsjk As String '所选帐套当前数据库
Private Function Ljyxxpd() As Boolean '数据服务器(系统基本信息库)连接有效性测试
Ljyxxpd = False
If Len(Trim(ServerText.Text)) = 0 Then
Tsxx = "数据服务器名不能为空!"
Call Xtxxts(Tsxx, 0, 1)
ServerText.SetFocus
Exit Function
End If
Xtsjljc = "Provider=SQLOLEDB.1;"
Xtsjljc = Xtsjljc + "Persist Security Info=False;"
Xtsjljc = Xtsjljc + "Data Source=" + Trim(ServerText.Text) + ";"
Xtsjljc = Xtsjljc + " Initial Catalog=" + "Master" + ";"
If Cslj.State = 1 Then Cslj.Close
DdtsLabel = "系统正在连接数据服务器,请稍等..."
DdtsLabel.Refresh
With Me.Animation1
.Visible = True
.Open App.Path + "\Ljcs.avi"
.Play
End With
On Error GoTo Cwcl
If Cslj.State = 1 Then Cslj.Close
Cslj.Open Xtsjljc, "Hxxd", ErpPassWord
Animation1.Stop
Animation1.Visible = False
DdtsLabel = ""
DdtsLabel.Refresh
Ljyxxpd = True
Exit Function
Cwcl:
Animation1.Visible = False
Animation1.Stop
DdtsLabel = ""
Tsxx = "数据服务器连接测试失败!"
Call Xtxxts(Tsxx, 0, 1)
Exit Function
End Function
Private Sub CzrqText_KeyPress(KeyAscii As Integer) '录入日期限制
Call Lrrqxz(KeyAscii)
End Sub
Private Sub Form_KeyPress(KeyAscii As Integer) '控 制 焦 点 转 移
Dim jdzygs As Integer
jdzygs = 12
Select Case KeyAscii
Case vbKeyReturn
If Kjjdzy(jdzygs) Then
KeyAscii = 0
End If
Case 39 '屏蔽"'"
KeyAscii = 0
End Select
End Sub
Private Sub Form_Load()
App.HelpFile = App.Path + "\考核管理.chm"
XtMenuList = "23%" '子系统菜单系统代号
ErpPassWord = "123"
Call Qcljnr '读入连接内容
With StTab
.TabEnabled(0) = False
Frame1(0).Enabled = False
.TabEnabled(1) = True
Frame1(1).Enabled = True
.TabEnabled(2) = False
Frame1(2).Enabled = False
StTab.Tab = 1
End With
End Sub
Private Sub GgszCommand_Click()
With Me.StTab
.TabEnabled(0) = False
Frame1(0).Enabled = False
.TabEnabled(1) = True
Frame1(1).Enabled = True
.Tab = 1
End With
' 让数据服务器设置文本框得到焦点
ServerText.SetFocus
ServerText.SelStart = 0
ServerText.SelLength = Len(ServerText.Text)
End Sub
Private Sub LjqdCommand_Click() '保 存 设 置
If Ljyxxpd Then
If Cw_DataEnvi.BaseInfoConnect.State = 1 Then Cw_DataEnvi.BaseInfoConnect.Close
Cw_DataEnvi.BaseInfoConnect.Open Xtsjljc, "Hxxd", ErpPassWord
Tsxx = "连接测试成功!"
Call Xtxxts(Tsxx, 0, 4)
StTab.TabEnabled(1) = False
Frame1(1).Enabled = False
StTab.TabEnabled(0) = True
Frame1(0).Enabled = True
StTab.Tab = 0
Call Tcztxx
If ZtCombo.ListCount > 0 Then
ZtCombo.ListIndex = 0
End If
End If
End Sub
Private Sub Qcljnr() '取 出 数 据
Dim Fsote As New FileSystemObject, Tste As TextStream
Dim Dqhs As Integer, Dqnr As String
Dqhs = 5
On Error GoTo Cwcl:
Set Tste = Fsote.OpenTextFile(App.Path + "\百利erp.txt", 1)
For Jsqte = 1 To Dqhs
Dqnr = Trim(Tste.ReadLine)
If InStr(1, UCase(Dqnr), "SQLSERVER=") <> 0 Then
ServerText.Text = Mid(Dqnr, InStr(1, UCase(Dqnr), "SQLSERVER=") + 10, Len(Dqnr))
End If
If InStr(1, UCase(Dqnr), "ACCOUNT=") <> 0 Then
str_Account = Mid(Dqnr, InStr(1, UCase(Dqnr), "ACCOUNT=") + 8, Len(Dqnr))
Dim int_Count As Integer
For int_Count = 0 To ZtCombo.ListCount - 1
If UCase(Mid(ZtCombo.List(int_Count), 1, InStr(ZtCombo.List(int_Count), "-") - 1)) = UCase(Mid(str_Account, 1, InStr(str_Account, "-") - 1)) Then
ZtCombo.ListIndex = int_Count
End If
Next int_Count
End If
Next Jsqte
Exit Sub
Cwcl:
Exit Sub
End Sub
Private Sub QdCommand_Click() '确定进入系统
If Trim(CzyCombo.Text) = "" Then Exit Sub
Set Czyrec = Cw_DataEnvi.DataConnect.Execute("Select * From gy_czygl where czybm='" + Trim(CzyCombo.Text) + "' or czymc='" & Trim(CzyCombo.Text) & "' or rtrim(czybm)+'-'+rtrim(czymc)='" & Trim(CzyCombo.Text) & "'")
With Czyrec
If Not .EOF Then
CzyCombo.Text = Trim(.Fields("czybm")) + "-" + Trim(.Fields("czymc"))
Else
Tsxx = "无此用户名!"
Call Xtxxts(Tsxx, 0, 1)
Exit Sub
End If
End With
Czyrec.Close
Set Czyrec = Nothing
If Xtyxxpd Then
If Ljyxxpd1 Then
If Cw_DataEnvi.DataConnect.State = 1 Then Cw_DataEnvi.DataConnect.Close
Cw_DataEnvi.DataConnect.Open Xtsjljc, "Hxxd", ErpPassWord
End If
QdCheck.Value = 1
Me.Hide
Dim Fsote As New FileSystemObject, Tste As TextStream
Set Tste = Fsote.CreateTextFile(App.Path + "\百利erp.txt", True)
Tste.WriteLine "Sqlserver=" + Trim(ServerText.Text)
Tste.WriteLine "Account=" + Trim(ZtCombo.Text)
Tste.Close
CtdrCheck.Value = 1
GgszCommand.Enabled = False
XT_Main.Show
Xt_Control.tvTreeView.Visible = False
Xt_Control.tvTreeView.Nodes.Clear
Xt_Control.Cshgns
Xt_Control.tvTreeView.Refresh
Xt_Control.tvTreeView.Visible = True
End If
End Sub
Private Sub QxCommand_Click() '取消进入系统
If CtdrCheck.Value <> 1 Then
Unload Me
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -