📄 frmdcy.frm
字号:
VERSION 5.00
Object = "{831FDD16-0C5C-11D2-A9FC-0000F8754DA1}#2.0#0"; "MSCOMCTL.OCX"
Object = "{BDC217C8-ED16-11CD-956C-0000C04E4C0A}#1.1#0"; "TABCTL32.OCX"
Begin VB.Form frmDcy
Caption = "点钞员管理"
ClientHeight = 8130
ClientLeft = 60
ClientTop = 345
ClientWidth = 9165
Icon = "frmDcy.frx":0000
LockControls = -1 'True
MDIChild = -1 'True
ScaleHeight = 8130
ScaleWidth = 9165
WindowState = 2 'Maximized
Begin VB.CommandButton cmdExit
Cancel = -1 'True
Caption = "退出[&X]"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 405
Left = 7050
TabIndex = 1
Top = 7200
Width = 1605
End
Begin VB.CommandButton cmdDel
Caption = "删除[&D]"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 405
Left = 5460
TabIndex = 5
Top = 7200
Width = 1605
End
Begin VB.CommandButton cmdOK
Caption = "添加[&A]"
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 405
Left = 3870
TabIndex = 0
Top = 7200
Width = 1605
End
Begin TabDlg.SSTab sstabBk
Height = 6465
Left = 240
TabIndex = 2
Top = 480
Width = 8415
_ExtentX = 14843
_ExtentY = 11404
_Version = 393216
Style = 1
Tabs = 1
TabsPerRow = 1
TabHeight = 706
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
TabCaption(0) = " 点钞员信息管理 "
TabPicture(0) = "frmDcy.frx":08CA
Tab(0).ControlEnabled= -1 'True
Tab(0).Control(0)= "Label1"
Tab(0).Control(0).Enabled= 0 'False
Tab(0).Control(1)= "Label2"
Tab(0).Control(1).Enabled= 0 'False
Tab(0).Control(2)= "Label3"
Tab(0).Control(2).Enabled= 0 'False
Tab(0).Control(3)= "Frame1"
Tab(0).Control(3).Enabled= 0 'False
Tab(0).Control(4)= "txtDcyNo"
Tab(0).Control(4).Enabled= 0 'False
Tab(0).Control(5)= "txtDcyName"
Tab(0).Control(5).Enabled= 0 'False
Tab(0).Control(6)= "txtNewOpNo"
Tab(0).Control(6).Enabled= 0 'False
Tab(0).ControlCount= 7
Begin VB.TextBox txtNewOpNo
Alignment = 1 'Right Justify
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 6900
TabIndex = 10
Top = 5670
Width = 1245
End
Begin VB.TextBox txtDcyName
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 4140
TabIndex = 7
Top = 5670
Width = 1485
End
Begin VB.TextBox txtDcyNo
BackColor = &H80000009&
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 375
Left = 1290
TabIndex = 6
Top = 5670
Width = 1455
End
Begin VB.Frame Frame1
Height = 4995
Left = 120
TabIndex = 3
Top = 480
Width = 8145
Begin MSComctlLib.ListView lstDcy
Height = 4665
Index = 0
Left = 120
TabIndex = 4
Top = 210
Visible = 0 'False
Width = 7905
_ExtentX = 13944
_ExtentY = 8229
View = 3
LabelEdit = 1
LabelWrap = -1 'True
HideSelection = -1 'True
FullRowSelect = -1 'True
_Version = 393217
ForeColor = -2147483640
BackColor = -2147483643
BorderStyle = 1
Appearance = 1
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 11.25
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
NumItems = 3
BeginProperty ColumnHeader(1) {BDD1F052-858B-11D1-B16A-00C0F0283628}
Text = "点钞员工号"
Object.Width = 2540
EndProperty
BeginProperty ColumnHeader(2) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 1
Text = "点钞员姓名"
Object.Width = 2540
EndProperty
BeginProperty ColumnHeader(3) {BDD1F052-858B-11D1-B16A-00C0F0283628}
SubItemIndex = 2
Text = "点钞员编号"
Object.Width = 2540
EndProperty
End
End
Begin VB.Label Label3
AutoSize = -1 'True
Caption = "新员工号："
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Left = 210
TabIndex = 11
Top = 5730
Width = 1200
End
Begin VB.Label Label2
AutoSize = -1 'True
Caption = "点钞员姓名："
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Left = 2820
TabIndex = 9
Top = 5730
Width = 1440
End
Begin VB.Label Label1
AutoSize = -1 'True
Caption = "点钞工号："
BeginProperty Font
Name = "宋体"
Size = 12
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 240
Left = 5790
TabIndex = 8
Top = 5730
Width = 1200
End
End
End
Attribute VB_Name = "frmDcy"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private Sub cmdDel_Click()
Dim rs As New ADODB.Recordset
On Error Resume Next
If MsgBox("确认要删除员工『" + txtDcyName + "』吗？", vbYesNo, "提示信息...") = vbYes Then
rs.Open "ZY_DELETE_DCY_INFO " + Trim(txtDcyNo), cnn, adOpenStatic, adLockOptimistic
If Err.Number <> 0 Then
MsgBox "删除失败？", vbCritical, "提示..."
Else
Call lstRef
txtDcyName = ""
txtDcyNo = ""
MsgBox "删除成功", vbInformation, "提示..."
End If
End If
End Sub
Private Sub cmdExit_Click()
Unload Me
End Sub
Private Sub cmdOK_Click()
Dim rs As New ADODB.Recordset
'On Error Resume Next
If txtDcyName.Text <> "" And txtNewOpNo.Text <> "" Then
rs.Open "SELECT EXISTSFLG=COUNT(*) FROM AMC_DCY_INFO WHERE OP_NO='" + Trim(txtDcyNo) + "'", cnn, adOpenStatic, adLockOptimistic
If rs.Fields("EXISTSFLG") <> 0 Then
' If MsgBox("此工号已存在,是否使用默认工号!及当前工号最大值?", vbYesNo, "提示信息...") = vbNo Then
' Exit Sub
' Else
' rs.Close
' rs.Open "ZYSP_INSERT_DCY_INFO '" + Trim(txtNewOpNo) + "','" + Trim(txtDcyNo) + "','" + Trim(txtDcyName) + "'", cnn, adOpenStatic, adLockOptimistic
' If Err.Number <> 0 Then
' MsgBox "添加失败？", vbCritical, "提示..."
' Else
' Call lstRef
' MsgBox "添加成功", vbInformation, "提示..."
' txtDcyName = ""
' txtDcyNo = ""
' txtNewOpNo = ""
' End If
' End If
MsgBox "此工号已存在!", vbOKOnly, "提示信息..."
rs.Close
Exit Sub
Else
rs.Close
rs.Open "ZYSP_INSERT_DCY_INFO '" + Trim(txtNewOpNo) + "','" + Trim(txtDcyNo) + "','" + Trim(txtDcyName) + "'", cnn, adOpenStatic, adLockOptimistic
If Err.Number <> 0 Then
MsgBox "添加失败？", vbCritical, "提示..."
Else
Call lstRef
MsgBox "添加成功", vbInformation, "提示..."
txtDcyName = ""
txtDcyNo = ""
txtNewOpNo = ""
End If
End If
End If
txtNewOpNo.SetFocus
End Sub
Private Sub Form_Load()
Call lstRef
End Sub
Private Sub lstDcy_DblClick(Index As Integer)
Call cmdDel_Click
End Sub
Private Sub lstDcy_ItemClick(Index As Integer, ByVal Item As MSComctlLib.ListItem)
txtDcyNo = Item.Text
txtDcyName = Item.ListSubItems(1).Text
txtNewOpNo = Item.ListSubItems(2).Text
End Sub
Private Sub lstRef()
Dim rs As New ADODB.Recordset
On Error Resume Next
Unload lstDcy(1)
Load lstDcy(1)
lstDcy(1).Visible = True
rs.Open "select op_no,opname,opno from amc_dcy_info order by opno", cnn, adOpenStatic, adLockOptimistic
i = 1
Do While Not rs.EOF
lstDcy(1).ListItems.Add , "A" + CStr(i), rs.Fields(0)
lstDcy(1).ListItems(i).ListSubItems.Add , "b" + CStr(i), rs.Fields(1)
lstDcy(1).ListItems(i).ListSubItems.Add , "c" + CStr(i), rs.Fields(2)
rs.MoveNext
i = i + 1
Loop
txtNewOpNo = lstDcy(1).ListItems.Count + 1
End Sub
Private Sub txtDcyName_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Dim rs As New ADODB.Recordset
rs.Open "select op_no,name from zz_bus_ic.dbo.zy_worker_info where name like '" & Trim(txtDcyName.Text) & "'", cnn, adOpenStatic, adLockOptimistic
If Not rs.EOF Then
txtDcyNo = Trim(rs(0).Value)
txtNewOpNo.SetFocus
Else
MsgBox "没此员工！", vbOKOnly, "系统提示"
End If
rs.Close
Set rs = Nothing
' Else
'
' cmdOK.SetFocus
End If
End Sub
Private Sub txtDcyNo_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
Dim rs As New ADODB.Recordset
rs.Open "select op_no,name from zz_bus_ic.dbo.zy_worker_info where op_no='" & IIf(Trim(txtDcyNo.Text) = "", 0, Trim(txtDcyNo.Text)) & "'", cnn, adOpenStatic, adLockOptimistic
If Not rs.EOF Then
txtDcyName = Trim(rs(1).Value)
txtDcyName.SetFocus
Else
MsgBox "没此员工号！", vbOKOnly, "系统提示"
End If
rs.Close
Set rs = Nothing
Else
KeyAscii = clsDaivd.ValiText(KeyAscii, "0123456789", True)
End If
End Sub
Private Sub txtNewOpNo_KeyPress(KeyAscii As Integer)
If KeyAscii = 13 Then
cmdOK.SetFocus
Else
KeyAscii = clsDaivd.ValiText(KeyAscii, "0123456789", True)
End If
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -