📄 frmemployee.frm
字号:
VERSION 5.00
Object = "{809F5ECB-E545-4F7D-A8A8-CBFF5617AADC}#1.0#0"; "xCombox.ocx"
Object = "{E11E7285-4386-40E5-A4D4-F55704D4D491}#1.0#0"; "sSuperGrid.ocx"
Object = "{060B05EA-F4F5-4255-9BFC-9295B6A89D11}#3.0#0"; "Sinour050715.ocx"
Object = "{2DCFDEBF-F3C7-4735-B263-99E2ADF554F0}#1.0#0"; "ACRptEngineX.ocx"
Object = "{F9043C88-F6F2-101A-A3C9-08002B2F49FB}#1.2#0"; "comdlg32.ocx"
Begin VB.Form frmEmployee
Caption = "员工资料"
ClientHeight = 6570
ClientLeft = 60
ClientTop = 345
ClientWidth = 9525
LinkTopic = "Form3"
MDIChild = -1 'True
ScaleHeight = 6570
ScaleWidth = 9525
Begin ACRptEngineX.ACRptEngine ACRptEngine1
Height = 735
Left = 5085
TabIndex = 6
Top = 3195
Visible = 0 'False
Width = 780
Object.Visible = -1 'True
DoubleBuffered = 0 'False
Enabled = -1 'True
End
Begin MSComDlg.CommonDialog ComDlg
Left = 4500
Top = 3195
_ExtentX = 847
_ExtentY = 847
_Version = 393216
End
Begin SSUPERGRIDLib.SSuperGrid Grid
Height = 2715
Left = 405
TabIndex = 0
Top = 450
Width = 5460
_Version = 65536
_ExtentX = 9631
_ExtentY = 4789
_StockProps = 132
End
Begin Sinour_Controls.sButton cmdEdit
Height = 375
Left = 315
TabIndex = 1
Top = 4320
Width = 1095
_ExtentX = 1931
_ExtentY = 661
BTYPE = 7
TX = "编辑(&E) "
ENAB = -1 'True
BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
COLTYPE = 1
FOCUSR = 0 'False
BCOL = 13160660
BCOLO = 13160660
FCOL = 0
FCOLO = 0
MCOL = 12632256
MPTR = 1
MICON = "frmEmployee.frx":0000
PICN = "frmEmployee.frx":001C
UMCOL = -1 'True
SOFT = 0 'False
PICPOS = 1
NGREY = 0 'False
FX = 0
HAND = 0 'False
CHECK = 0 'False
VALUE = 0 'False
End
Begin Sinour_Controls.sButton cmdFind
Height = 330
Left = 7155
TabIndex = 2
Top = 4590
Width = 915
_ExtentX = 1614
_ExtentY = 582
BTYPE = 2
TX = "查找 "
ENAB = -1 'True
BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
COLTYPE = 1
FOCUSR = -1 'True
BCOL = 14215660
BCOLO = 14215660
FCOL = 0
FCOLO = 0
MCOL = 12632256
MPTR = 1
MICON = "frmEmployee.frx":00BE
UMCOL = -1 'True
SOFT = 0 'False
PICPOS = 0
NGREY = 0 'False
FX = 0
HAND = 0 'False
CHECK = 0 'False
VALUE = 0 'False
End
Begin XCOMBOXLib.XCombox cmbEmployee
Height = 300
Left = 5085
TabIndex = 3
Top = 4590
Width = 1950
_Version = 65536
_ExtentX = 3440
_ExtentY = 300
_StockProps = 68
End
Begin Sinour_Controls.sButton cmdExpor
Height = 375
Left = 2700
TabIndex = 4
Top = 4320
Width = 1095
_ExtentX = 1931
_ExtentY = 661
BTYPE = 7
TX = "导出 "
ENAB = -1 'True
BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "MS Sans Serif"
Size = 8.25
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
COLTYPE = 1
FOCUSR = -1 'True
BCOL = 14215660
BCOLO = 14215660
FCOL = 0
FCOLO = 0
MCOL = 12632256
MPTR = 1
MICON = "frmEmployee.frx":00DA
UMCOL = -1 'True
SOFT = 0 'False
PICPOS = 0
NGREY = 0 'False
FX = 0
HAND = 0 'False
CHECK = 0 'False
VALUE = 0 'False
End
Begin Sinour_Controls.sButton cmdPrint
Height = 375
Left = 1485
TabIndex = 5
Top = 4320
Width = 1095
_ExtentX = 1931
_ExtentY = 661
BTYPE = 7
TX = "打印(&P) "
ENAB = -1 'True
BeginProperty FONT {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
COLTYPE = 1
FOCUSR = 0 'False
BCOL = 13160660
BCOLO = 13160660
FCOL = 0
FCOLO = 0
MCOL = 12632256
MPTR = 1
MICON = "frmEmployee.frx":00F6
PICN = "frmEmployee.frx":0112
UMCOL = -1 'True
SOFT = 0 'False
PICPOS = 1
NGREY = 0 'False
FX = 0
HAND = 0 'False
CHECK = 0 'False
VALUE = 0 'False
End
End
Attribute VB_Name = "frmEmployee"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Dim recGrid As New ADODB.Recordset
Dim recExec As New ADODB.Recordset
Public Sub AddBill()
frmEmployeeEdit.ZOrder
frmEmployeeEdit.AddBill
End Sub
Public Sub EditBill()
If Grid.RecordCount = 0 Then
Message "没有可用信息!"
Exit Sub
End If
If Grid.CurRow = -1 Then
Message "请先选中数据!"
Exit Sub
End If
If (IsNull(recGrid.Fields("EmployeeID"))) Or (Trim(recGrid.Fields("EmployeeID")) = "") Then Exit Sub
frmEmployeeEdit.ZOrder
frmEmployeeEdit.EditBill recGrid.Fields("EmployeeID")
End Sub
Public Sub RefreshBill()
Dim i As Integer
If Grid.CurRow <> -1 Then i = Grid.CurRow
recGrid.Requery
Grid.ReFetch
If i >= Grid.RecordCount Then Exit Sub
Grid.CurRow = i
End Sub
Public Sub DelBill()
On Error GoTo DelErr
If Grid.RecordCount = 0 Then
Message "没有可用信息!"
Exit Sub
End If
If Grid.CurRow = -1 Then
Message "请先选中数据!"
Exit Sub
End If
If QueryDly("确定删除?") = False Then Exit Sub
Dim EmployeeID As Long
EmployeeID = Trim(recGrid.Fields("EmployeeID"))
con.Execute "delete from Employee where EmployeeID=" & EmployeeID
RefreshBill
' Grid.Delete
' Grid.DataSource.Properties.Item("Unique Table") = "Employee"
' Grid.DataSource.UpdateBatch
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -