frmlogin.frm

民间标会的会员管理用的软件。是为一个顾客定做的！

VERSION 5.00
Begin VB.Form frmLogin 
   BorderStyle     =   1  'Fixed Single
   Caption         =   "系统登录"
   ClientHeight    =   2475
   ClientLeft      =   45
   ClientTop       =   450
   ClientWidth     =   4035
   Icon            =   "frmLogin.frx":0000
   LinkTopic       =   "Form1"
   MaxButton       =   0   'False
   MinButton       =   0   'False
   ScaleHeight     =   2475
   ScaleWidth      =   4035
   StartUpPosition =   2  'CenterScreen
   Begin VB.CommandButton Command2 
      Cancel          =   -1  'True
      Caption         =   "退出"
      Height          =   435
      Left            =   2520
      TabIndex        =   3
      Top             =   1980
      Width           =   675
   End
   Begin VB.CommandButton Command1 
      Caption         =   "确定"
      Default         =   -1  'True
      Height          =   435
      Left            =   780
      TabIndex        =   2
      Top             =   1980
      Width           =   675
   End
   Begin VB.Frame Frame1 
      Height          =   1815
      Left            =   60
      TabIndex        =   1
      Top             =   60
      Width           =   3915
      Begin VB.PictureBox Picture1 
         BorderStyle     =   0  'None
         Height          =   1455
         Left            =   120
         ScaleHeight     =   1455
         ScaleWidth      =   3675
         TabIndex        =   4
         Top             =   240
         Width           =   3675
         Begin VB.TextBox txtPwd 
            Height          =   255
            IMEMode         =   3  'DISABLE
            Left            =   1080
            PasswordChar    =   "*"
            TabIndex        =   0
            Top             =   1020
            Width           =   1995
         End
         Begin VB.Label Label2 
            Caption         =   "密 码："
            Height          =   315
            Left            =   420
            TabIndex        =   6
            Top             =   1080
            Width           =   675
         End
         Begin VB.Label Label1 
            Caption         =   "您必须提供密码才可以使用本软件，请在下面输入您的密码！"
            Height          =   555
            Left            =   840
            TabIndex        =   5
            Top             =   240
            Width           =   2595
         End
         Begin VB.Image Image1 
            Height          =   765
            Left            =   0
            Picture         =   "frmLogin.frx":08CA
            Stretch         =   -1  'True
            Top             =   0
            Width           =   780
         End
      End
   End
End
Attribute VB_Name = "frmLogin"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim Pwd As String


Private Sub Command1_Click()

    If Pwd = GetPWD(Trim(txtPwd)) Then
        Unload Me
        frmMain.Show
    Else
        MsgBox "密码错误!"
    End If
    
End Sub

Private Sub Command2_Click()
End
End Sub



Private Sub Form_Initialize()
    InitCommonControls
End Sub

Private Sub Form_Load()


Pwd = GetSetting(App.EXEName, "Settings", "Key", "")
DataFile = App.Path & "\Record.db"

conStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & DataFile & ";Persist Security Info=False"
'JM '简单加密，使用次数限制（呵呵……小儿科）
If Pwd = "" Then
    frmMain.Show
    Unload Me
End If

End Sub

Private Sub JM() '简单加密，使用次数限制（呵呵……小儿科）
    Dim bgDate As Date
    Dim Rs As Recordset
    Dim SQL As String
    
Set Rs = GetRecord("SELECT * FROM SYSTEM")

If Not Rs.EOF Then
     bgDate = Rs.Fields("SYSTEM1")
     
     If bgDate > VBA.Date Then
        MsgBox "你的系统时间错误请从新设置"
        End
     Else
        If Rs.Fields("SYSTEM2").Value <> -1 Then
            If VBA.Date - bgDate >= 30 Then
                MsgBox "你使用的版本已经过期!"
                End
            Else
                If Rs.Fields("SYSTEM2").Value >= 100 Then
                    MsgBox "你使用的版本已经过期!"
                    End
                Else
                    SQL = "UPDATE SYSTEM SET SYSTEM2=SYSTEM2+1"
                    ExecSQL SQL
                End If
            End If
        End If
     End If
    Else
        SQL = "insert into SYSTEM(SYSTEM1,SYSTEM2) values(#" & VBA.Date & "#,1)"
        ExecSQL SQL
    End If
End Sub