📄 frmczy.frm
字号:
VERSION 5.00
Begin VB.Form frmCZY
BorderStyle = 1 'Fixed Single
Caption = "登陆用户管理"
ClientHeight = 4545
ClientLeft = 45
ClientTop = 435
ClientWidth = 7320
BeginProperty Font
Name = "Arial"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
LinkTopic = "Form1"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 4545
ScaleWidth = 7320
StartUpPosition = 2 '屏幕中心
Begin VB.PictureBox Picture1
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 4560
Left = 0
ScaleHeight = 4500
ScaleWidth = 1755
TabIndex = 13
Top = 0
Width = 1815
End
Begin VB.Frame frame2
Caption = "操作员编辑"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 4215
Left = 4080
TabIndex = 1
Top = 165
Width = 3015
Begin VB.PictureBox Picture2
BorderStyle = 0 'None
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 3855
Left = 120
ScaleHeight = 3855
ScaleWidth = 2775
TabIndex = 2
Top = 240
Width = 2775
Begin VB.CommandButton cmdSC
Caption = "删除"
Enabled = 0 'False
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 1800
TabIndex = 12
Top = 3360
Width = 855
End
Begin VB.CommandButton cmdBC
Caption = "新增"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 840
TabIndex = 11
Top = 3360
Width = 855
End
Begin VB.CheckBox Check1
Caption = "数据管理"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 5
Left = 720
TabIndex = 10
Top = 2520
Width = 2055
End
Begin VB.CheckBox Check1
Caption = "登陆用户管理"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 4
Left = 720
TabIndex = 9
Top = 2160
Width = 2055
End
Begin VB.CheckBox Check1
Caption = "系统参数"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 3
Left = 720
TabIndex = 8
Top = 1800
Width = 2055
End
Begin VB.CheckBox Check1
Caption = "单位设置"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 2
Left = 720
TabIndex = 7
Top = 1440
Width = 2055
End
Begin VB.CheckBox Check1
Caption = "工资管理"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 1
Left = 720
TabIndex = 6
Top = 1080
Width = 2055
End
Begin VB.CheckBox Check1
Caption = "基础档案"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Index = 0
Left = 720
TabIndex = 5
Top = 720
Width = 2055
End
Begin VB.TextBox txtCZY
Height = 345
Left = 720
TabIndex = 3
Top = 120
Width = 1935
End
Begin VB.Label Label1
Caption = "登陆名"
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 120
TabIndex = 4
Top = 180
Width = 570
End
End
End
Begin VB.ListBox List1
Height = 4110
Left = 2040
TabIndex = 0
Top = 255
Width = 1845
End
End
Attribute VB_Name = "frmCZY"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'****************************************************************************
'人人为我，我为人人
'枕善居收藏整理
'发布日期：2007/12/17
'描 述：企事业单位人事管理系统 Ver 2007
'网 站：http://www.Mndsoft.com/ (VB6源码博客)
'网 站：http://www.VbDnet.com/ (VB.NET源码博客,主要基于.NET2005)
'e-mail ：Mndsoft@163.com
'e-mail ：Mndsoft@126.com
'OICQ ：88382850
' 如果您有新的好的代码别忘记给枕善居哦!
'****************************************************************************
Dim qx As String '权限
Private Sub cmdBC_Click() '保存按钮
If Trim(Me.txtCZY.Text) = "" Then
MsgBox "登陆名不能为空！", 48, "提示"
Exit Sub
End If
If Me.cmdBC.Caption = "新增" Then
For i = 0 To Me.List1.ListCount
If Trim(Me.txtCZY.Text) = Me.List1.List(i) Then
MsgBox "该用户已经存在！", 48, "提示"
Exit Sub
End If
Next
Call OpenConn
SQL = "select * from 系统用户表"
rs.Open SQL, cn, 3, 3
rs.AddNew
rs!czy = Trim(Me.txtCZY.Text)
rs!pass = zhuan("123456")
For i = 0 To 5
qx = qx & Me.Check1(i).Value
Next
rs!czyqx = qx
rs.Update
Call CloseConn
qx = ""
MsgBox "操作员添加成功，初始密码为123456，请注意修改！", 64, "提示"
Me.txtCZY.Enabled = True
Me.cmdSC.Enabled = False
Else
Call OpenConn
SQL = "select * from 系统用户表 where czy='" & Me.txtCZY.Text & "'"
rs.Open SQL, cn, 3, 3
For i = 0 To 5
qx = qx & Me.Check1(i).Value
Next
rs!czyqx = qx
rs.Update
Call CloseConn
qx = "" '清空变量
MsgBox "保存成功！", 64, "提示"
Me.cmdBC.Caption = "新增"
Me.txtCZY.Enabled = True
Me.cmdSC.Enabled = False
End If
Call addLIST
Me.txtCZY.Text = ""
For i = 0 To 5
Me.Check1(i).Value = 0
Next
End Sub
Private Sub cmdSC_Click()
If Me.txtCZY.Text = "" Then
MsgBox "请选择要删除的操作员！", 48, "提示"
Exit Sub
End If
If Me.List1.ListCount <= 1 Then
MsgBox "只有一个操作员了，不能再删除！", 48, "提示"
Exit Sub
End If
Call OpenConn
cn.Execute ("delete * from 系统用户表 where czy='" & Me.List1.Text & "'")
Call CloseConn
Call addLIST '刷新列表
Me.txtCZY.Text = ""
Me.txtCZY.Enabled = True
Me.cmdSC.Enabled = False
Me.cmdBC.Caption = "新增"
For i = 0 To 5
Me.Check1(i).Value = 0
Next
End Sub
Private Sub Form_Initialize()
Call InitCommonControls 'XP效果
End Sub
Private Sub Form_Load()
Me.Icon = MDIfrm.Icon
Me.Picture1.Picture = LoadPicture(App.Path & "\bg\bg2.jpg")
Call addLIST
End Sub
Private Sub addLIST()
Me.List1.Clear
Call OpenConn
SQL = "select * from 系统用户表"
rs.Open SQL, cn, 1, 1
Do While Not rs.EOF
Me.List1.AddItem rs!czy
rs.MoveNext
Loop
Call CloseConn
End Sub
Private Sub List1_Click()
If Me.List1.Text = "" Then Exit Sub '检测--------------------------
Call OpenConn
SQL = "select * from 系统用户表 where czy='" & Me.List1.Text & "'"
rs.Open SQL, cn, 1, 1
Me.txtCZY.Text = rs!czy
For i = 0 To 5
Me.Check1(i).Value = Mid(rs!czyqx, i + 1, 1)
Next
Call CloseConn
Me.txtCZY.Enabled = False
Me.cmdBC.Caption = "保存"
Me.cmdSC.Enabled = True
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -