📄 frm_user_add.frm
字号:
VERSION 5.00
Begin VB.Form Frm_User_Add
BorderStyle = 1 'Fixed Single
Caption = "添加用户"
ClientHeight = 4125
ClientLeft = 3735
ClientTop = 4365
ClientWidth = 6930
Icon = "Frm_User_Add.frx":0000
LinkTopic = "Form2"
LockControls = -1 'True
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 4125
ScaleWidth = 6930
Begin VB.ComboBox Cob_Department
Height = 300
Left = 1755
Style = 2 'Dropdown List
TabIndex = 3
Top = 1560
Width = 4815
End
Begin VB.CommandButton Cmd_Close
Caption = "关闭(&O)"
Height = 375
Left = 5273
TabIndex = 7
Top = 3600
Width = 1095
End
Begin VB.CommandButton Cmd_Creat
Caption = "创建(&E)"
Height = 375
Left = 3953
TabIndex = 6
Top = 3600
Width = 1095
End
Begin VB.TextBox Txt_fields
Height = 300
IMEMode = 3 'DISABLE
Index = 4
Left = 1755
PasswordChar = "*"
TabIndex = 5
Text = "Text1"
Top = 2760
Width = 4815
End
Begin VB.TextBox Txt_fields
Height = 300
IMEMode = 3 'DISABLE
Index = 3
Left = 1755
PasswordChar = "*"
TabIndex = 4
Text = "Text1"
Top = 2280
Width = 4815
End
Begin VB.TextBox Txt_fields
Height = 300
Index = 2
Left = 1755
TabIndex = 2
Text = "Text1"
Top = 1080
Width = 4815
End
Begin VB.TextBox Txt_fields
Height = 300
Index = 1
Left = 1755
TabIndex = 1
Text = "Text1"
Top = 600
Width = 4815
End
Begin VB.TextBox Txt_fields
Height = 300
Index = 0
Left = 1755
TabIndex = 0
Text = "Text1"
Top = 180
Width = 4815
End
Begin VB.Label Label6
AutoSize = -1 'True
Caption = "所在部门(&G)："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 180
Left = 360
TabIndex = 13
Top = 1620
Width = 1290
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "用户名(&U)："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 180
Left = 360
TabIndex = 12
Top = 240
Width = 1095
End
Begin VB.Label Label2
AutoSize = -1 'True
Caption = "全名(&F)："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 180
Left = 360
TabIndex = 11
Top = 660
Width = 900
End
Begin VB.Label Label3
AutoSize = -1 'True
Caption = "描述(&D)："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 180
Left = 360
TabIndex = 10
Top = 1140
Width = 900
End
Begin VB.Label Label4
AutoSize = -1 'True
Caption = "密码(&P)："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 180
Left = 360
TabIndex = 9
Top = 2340
Width = 900
End
Begin VB.Label Label5
AutoSize = -1 'True
Caption = "确认密码(&C)："
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 180
Left = 360
TabIndex = 8
Top = 2820
Width = 1290
End
Begin VB.Line Line1
BorderColor = &H00FFFFFF&
Index = 1
X1 = 158
X2 = 6758
Y1 = 3360
Y2 = 3360
End
Begin VB.Line Line1
BorderColor = &H00FFFFFF&
Index = 0
X1 = 158
X2 = 6713
Y1 = 2040
Y2 = 2040
End
End
Attribute VB_Name = "Frm_User_Add"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub Cmd_Close_Click()
Unload Me
End Sub
Private Sub Cmd_Creat_Click()
On Error GoTo err
If User_Add = True And User_Edit = False Then
If Trim(Me.txt_Fields(3).text) = Trim(Me.txt_Fields(4).text) Then
Set Cn_Common = New ADODB.Connection
Cn_Common.Open Cs
Set Rs_Common = New ADODB.Recordset
Rs_Common.Open "select * from operator", Cn_Common, adOpenKeyset, adLockOptimistic, adCmdText
If Rs_Common.RecordCount <> 0 Then
Rs_Common.MoveLast
Rs_Common.AddNew
Rs_Common!用户名 = Trim(Me.txt_Fields(0).text)
Rs_Common!全名 = Trim(Me.txt_Fields(1).text)
Rs_Common!描述 = Trim(Me.txt_Fields(2).text)
Rs_Common!所在部门 = Trim(Me.Cob_Department.text)
Rs_Common!权限级别 = "5"
Rs_Common!密码 = Trim(Me.txt_Fields(3).text)
Rs_Common.Update
Rs_Common.Close
Rs_Common.Open "select 用户名,全名,描述,所在部门,权限级别 from Operator", Cn_Common, adOpenKeyset, adLockOptimistic, adCmdText
Set Frm_Group_User.DataGrd_Group_User.DataSource = Rs_Common
Me.txt_Fields(0).SetFocus
Else
Rs_Common.AddNew
Rs_Common!operator_name = Trim(Me.txt_Fields(0).text)
Rs_Common!operator_all_name = Trim(Me.txt_Fields(1).text)
Rs_Common!operator_depiction = Trim(Me.txt_Fields(2).text)
Rs_Common!operator_department = Trim(Me.Cob_Department.text)
Rs_Common!operator_password = Trim(Me.txt_Fields(3).text)
Rs_Common!private_level = "5"
Rs_Common.Update
Rs_Common.Close
Rs_Common.Open "select operator_name as 用户名,operator_all_name as 全名, operator_depiction as 描述, operator_department as 所在部门,private_level as 级别,private_press_machine_code as 印刷机号权,private_edition_state as 版状态权,private_expert_color_ink as 专色油墨权,private_color_stylebook as 颜色样本权,private_badness_rate as 不良率权,private_remain_good_count as 剩余良品数权 from Operator", Cn_Common, adOpenKeyset, adLockOptimistic, adCmdText
Set Frm_Group_User.DataGrd_Group_User.DataSource = Rs_Common
Me.txt_Fields(0).SetFocus
End If
Me.txt_Fields(0).text = ""
Me.txt_Fields(1).text = ""
Me.txt_Fields(2).text = ""
Me.txt_Fields(3).text = ""
Me.txt_Fields(4).text = ""
Else
MsgBox "两次输入的密码有误!" + Chr(13) + "请重新输入!", vbCritical, "错误提示"
Me.txt_Fields(3).text = "": Me.txt_Fields(4).text = ""
Me.txt_Fields(3).SetFocus
Exit Sub
End If
End If
If User_Add = False And User_Edit = True Then
Rs_Common!用户名 = Me.txt_Fields(0).text
Rs_Common!全名 = Me.txt_Fields(1).text
Rs_Common!描述 = Me.txt_Fields(2).text
Rs_Common!所在部门 = Me.Cob_Department.text
Rs_Common.Update
Unload Me
End If
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
Private Sub Cob_Department_KeyPress(KeyAscii As Integer)
On Error GoTo err
Call ENTER(KeyAscii)
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
Private Sub Form_Load()
On Error GoTo err
Set Cn_Customer_Riches = New ADODB.Connection
Cn_Customer_Riches.Open Cs
Set Rs_CR = New ADODB.Recordset
Rs_CR.Open "select * from Department", Cn_Customer_Riches, adOpenKeyset, adLockOptimistic, adCmdText
If Rs_CR.RecordCount <> 0 Then
Rs_CR.MoveFirst
For i = 1 To Rs_CR.RecordCount
Me.Cob_Department.AddItem Rs_CR!部门名称
Rs_CR.MoveNext
Next i
Else
MsgBox "请先添加部门后,再添加用户!", vbCritical
Unload Me
End If
Rs_CR.Close
If User_Add = True And User_Edit = False Then
For i = 0 To 4
Me.txt_Fields(i).text = ""
Next
Me.txt_Fields(3).Enabled = True
Me.txt_Fields(4).Enabled = True
End If
If User_Add = False And User_Edit = True Then
Me.Caption = "编辑用户"
If IsNull(Rs_Common!用户名) = False Then Me.txt_Fields(0).text = Rs_Common!用户名 Else Me.txt_Fields(0).text = ""
If IsNull(Rs_Common!全名) = False Then Me.txt_Fields(1).text = Rs_Common!全名 Else Me.txt_Fields(1).text = ""
If IsNull(Rs_Common!描述) = False Then Me.txt_Fields(2).text = Rs_Common!描述 Else Me.txt_Fields(2).text = ""
If IsNull(Rs_Common!所在部门) = False Then Me.Cob_Department.text = Rs_Common!所在部门 Else Me.Cob_Department.text = ""
' If IsNull(Rs_Common!部门) = False Then Me.Txt_fields(0).text = Rs_Common!部门 Else Me.Txt_fields(0).text = ""
' If IsNull(Rs_Common!部门描述) = False Then Me.Txt_fields(1).text = Rs_Common!部门描述 Else Me.Txt_fields(1).text = ""
Me.txt_Fields(3).Enabled = False
Me.txt_Fields(4).Enabled = False
Me.Cmd_Creat.Caption = "保存(&Save)"
End If
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
Private Sub Txt_Fields_KeyPress(Index As Integer, KeyAscii As Integer)
On Error GoTo err
Call ENTER(KeyAscii)
Exit Sub
err:
MsgBox err.Description, vbCritical
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -