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

📄

📁 VB开发的ERP系统
💻
📖 第 1 页 / 共 2 页
字号:
VERSION 5.00
Object = "{86CF1D34-0C5F-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCT2.OCX"
Object = "{BDC217C8-ED16-11CD-956C-0000C04E4C0A}#1.1#0"; "TABCTL32.OCX"
Begin VB.Form XT_login 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "百利/ERP5.0-成本核算登录"
   ClientHeight    =   3765
   ClientLeft      =   45
   ClientTop       =   330
   ClientWidth     =   4770
   ControlBox      =   0   'False
   Icon            =   "系统_登录窗体.frx":0000
   KeyPreview      =   -1  'True
   LinkTopic       =   "Form2"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   3765
   ScaleWidth      =   4770
   StartUpPosition =   2  '屏幕中心
   Begin VB.CheckBox QdCheck 
      Caption         =   "是否修改"
      Height          =   825
      Left            =   4980
      TabIndex        =   11
      Top             =   1260
      Value           =   1  'Checked
      Width           =   705
   End
   Begin VB.CheckBox CtdrCheck 
      Caption         =   "非第一次调入窗体"
      Height          =   735
      Left            =   4980
      TabIndex        =   0
      Top             =   390
      Width           =   705
   End
   Begin TabDlg.SSTab StTab 
      Height          =   3705
      Left            =   60
      TabIndex        =   12
      Top             =   30
      Width           =   4665
      _ExtentX        =   8229
      _ExtentY        =   6535
      _Version        =   393216
      Style           =   1
      TabHeight       =   520
      TabCaption(0)   =   "帐套选择及身份验证"
      TabPicture(0)   =   "系统_登录窗体.frx":1042
      Tab(0).ControlEnabled=   -1  'True
      Tab(0).Control(0)=   "Frame1(0)"
      Tab(0).Control(0).Enabled=   0   'False
      Tab(0).ControlCount=   1
      TabCaption(1)   =   "数据服务器连接设置"
      TabPicture(1)   =   "系统_登录窗体.frx":105E
      Tab(1).ControlEnabled=   0   'False
      Tab(1).Control(0)=   "Frame1(1)"
      Tab(1).ControlCount=   1
      TabCaption(2)   =   "更改密码"
      TabPicture(2)   =   "系统_登录窗体.frx":107A
      Tab(2).ControlEnabled=   0   'False
      Tab(2).Control(0)=   "Frame1(2)"
      Tab(2).ControlCount=   1
      Begin VB.Frame Frame1 
         Height          =   3255
         Index           =   0
         Left            =   90
         TabIndex        =   19
         Top             =   330
         Width           =   4455
         Begin VB.CommandButton QxCommand 
            Caption         =   "取消(&C)"
            Height          =   300
            Left            =   3210
            TabIndex        =   23
            Top             =   2790
            Width           =   1120
         End
         Begin VB.CommandButton QdCommand 
            Caption         =   "确定(&O)"
            Height          =   300
            Left            =   2040
            TabIndex        =   6
            Top             =   2790
            Width           =   1120
         End
         Begin VB.ComboBox ZtCombo 
            Height          =   300
            Left            =   1050
            Style           =   2  'Dropdown List
            TabIndex        =   1
            Top             =   210
            Width           =   3315
         End
         Begin VB.ComboBox KjyearCombo 
            Height          =   300
            Left            =   1050
            Style           =   2  'Dropdown List
            TabIndex        =   2
            Top             =   600
            Width           =   3315
         End
         Begin VB.TextBox CzrqText 
            Height          =   300
            Left            =   1050
            MaxLength       =   10
            TabIndex        =   3
            Top             =   990
            Width           =   2985
         End
         Begin VB.CommandButton Rlcommand 
            CausesValidation=   0   'False
            Height          =   300
            Left            =   4050
            Picture         =   "系统_登录窗体.frx":1096
            Style           =   1  'Graphical
            TabIndex        =   22
            Top             =   990
            Width           =   300
         End
         Begin VB.ComboBox CzyCombo 
            Height          =   300
            Left            =   1050
            TabIndex        =   4
            Top             =   1380
            Width           =   3315
         End
         Begin VB.TextBox MmText 
            Height          =   300
            IMEMode         =   3  'DISABLE
            Left            =   1050
            MaxLength       =   20
            PasswordChar    =   "*"
            TabIndex        =   5
            Top             =   1770
            Width           =   2730
         End
         Begin VB.Timer Timer1 
            Interval        =   100
            Left            =   420
            Top             =   2550
         End
         Begin VB.CommandButton XgmaCommand 
            Caption         =   "修改密码(&M)"
            Height          =   300
            Left            =   2040
            TabIndex        =   21
            Top             =   2430
            Width           =   1120
         End
         Begin VB.CommandButton GgszCommand 
            Caption         =   "更改设置(&A)"
            Height          =   300
            Left            =   3210
            TabIndex        =   20
            Top             =   2430
            Width           =   1120
         End
         Begin VB.Label TsLabel 
            Alignment       =   1  'Right Justify
            Caption         =   "操作日期:"
            Height          =   345
            Index           =   3
            Left            =   150
            TabIndex        =   28
            Top             =   1050
            Width           =   825
         End
         Begin VB.Label TsLabel 
            Alignment       =   1  'Right Justify
            Caption         =   "会计年度:"
            Height          =   345
            Index           =   1
            Left            =   150
            TabIndex        =   27
            Top             =   660
            Width           =   825
         End
         Begin VB.Label TsLabel 
            Alignment       =   1  'Right Justify
            Caption         =   "公司帐套:"
            Height          =   255
            Index           =   0
            Left            =   120
            TabIndex        =   26
            Top             =   270
            Width           =   855
         End
         Begin VB.Label TsLabel 
            Alignment       =   1  'Right Justify
            AutoSize        =   -1  'True
            Caption         =   "用户名:"
            Height          =   180
            Index           =   2
            Left            =   165
            TabIndex        =   25
            Top             =   1410
            Width           =   630
         End
         Begin VB.Label TsLabel 
            Caption         =   "密码:"
            Height          =   345
            Index           =   4
            Left            =   180
            TabIndex        =   24
            Top             =   1830
            Width           =   585
         End
         Begin VB.Line Line1 
            Index           =   0
            X1              =   180
            X2              =   4320
            Y1              =   2280
            Y2              =   2280
         End
         Begin VB.Line Line1 
            BorderColor     =   &H00FFFFFF&
            Index           =   1
            X1              =   180
            X2              =   4320
            Y1              =   2310
            Y2              =   2310
         End
         Begin VB.Image Image1 
            Height          =   480
            Left            =   3870
            Picture         =   "系统_登录窗体.frx":1420
            Top             =   1740
            Width           =   480
         End
      End
      Begin VB.Frame Frame1 
         Height          =   3255
         Index           =   1
         Left            =   -74910
         TabIndex        =   18
         Top             =   330
         Width           =   4455
         Begin VB.CommandButton LjqxCommand 
            Caption         =   "取 消"
            Height          =   300
            Left            =   2580
            TabIndex        =   31
            Top             =   1440
            Width           =   1120
         End
         Begin VB.CommandButton LjqdCommand 
            Caption         =   "确 定"
            Height          =   300
            Left            =   1410
            TabIndex        =   30
            Top             =   1440
            Width           =   1120
         End
         Begin VB.TextBox ServerText 
            Height          =   300
            Left            =   1800
            TabIndex        =   29
            Top             =   660
            Width           =   1905
         End
         Begin MSComCtl2.Animation Animation1 
            Height          =   615
            Left            =   150
            TabIndex        =   32
            Top             =   1290
            Visible         =   0   'False
            Width           =   705
            _ExtentX        =   1244
            _ExtentY        =   1085
            _Version        =   393216
            Center          =   -1  'True
            BackStyle       =   1
            FullWidth       =   47
            FullHeight      =   41
         End
         Begin VB.Label DdtsLabel 
            ForeColor       =   &H00FF0000&
            Height          =   255
            Left            =   1110
            TabIndex        =   34
            Top             =   2490
            Width           =   3045
         End
         Begin VB.Label TsLabel 
            Alignment       =   1  'Right Justify
            AutoSize        =   -1  'True
            Caption         =   "数据服务器:"
            Height          =   180
            Index           =   7
            Left            =   765
            TabIndex        =   33
            Top             =   720
            Width           =   990
         End
      End
      Begin VB.Frame Frame1 
         Height          =   3255
         Index           =   2
         Left            =   -74910
         TabIndex        =   13
         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

⌨️ 快捷键说明

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