?? frmresult.frm
字號:
VERSION 5.00
Object = "{BDC217C8-ED16-11CD-956C-0000C04E4C0A}#1.1#0"; "Tabctl32.ocx"
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Begin VB.Form frmResult
Caption = "修改工資信息"
ClientHeight = 9510
ClientLeft = 60
ClientTop = 345
ClientWidth = 15240
ControlBox = 0 'False
LinkTopic = "Form1"
MDIChild = -1 'True
ScaleHeight = 9510
ScaleWidth = 15240
WindowState = 2 'Maximized
Begin VB.CommandButton cmdCheckAll
Caption = "查詢所有"
Height = 375
Left = 5880
TabIndex = 7
Top = 480
Width = 1335
End
Begin VB.CommandButton cmdOK
Caption = "查詢單人"
Height = 375
Left = 4320
TabIndex = 3
Top = 480
Width = 1335
End
Begin VB.ComboBox comID
BeginProperty Font
Name = "楷體_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 360
Left = 1800
TabIndex = 2
Top = 480
Width = 2055
End
Begin TabDlg.SSTab SSTab1
Height = 7575
Left = 120
TabIndex = 0
Top = 1200
Width = 14895
_ExtentX = 26273
_ExtentY = 13361
_Version = 393216
Style = 1
TabHeight = 520
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "楷體_GB2312"
Size = 14.25
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
TabCaption(0) = "員工基本工資列表"
TabPicture(0) = "frmResult.frx":0000
Tab(0).ControlEnabled= -1 'True
Tab(0).Control(0)= "MSFlexGrid2"
Tab(0).Control(0).Enabled= 0 'False
Tab(0).ControlCount= 1
TabCaption(1) = "員工其他項目列表"
TabPicture(1) = "frmResult.frx":001C
Tab(1).ControlEnabled= 0 'False
Tab(1).Control(0)= "MSFlexGrid3"
Tab(1).ControlCount= 1
TabCaption(2) = "員工工資統計列表"
TabPicture(2) = "frmResult.frx":0038
Tab(2).ControlEnabled= 0 'False
Tab(2).Control(0)= "MSFlexGrid1"
Tab(2).ControlCount= 1
Begin MSFlexGridLib.MSFlexGrid MSFlexGrid3
Height = 6495
Left = -74760
TabIndex = 6
Top = 720
Width = 14295
_ExtentX = 25215
_ExtentY = 11456
_Version = 393216
Cols = 7
FixedCols = 0
FillStyle = 1
End
Begin MSFlexGridLib.MSFlexGrid MSFlexGrid1
Height = 6615
Left = -74760
TabIndex = 5
Top = 600
Width = 14205
_ExtentX = 25056
_ExtentY = 11668
_Version = 393216
Cols = 15
FixedCols = 0
FillStyle = 1
End
Begin MSFlexGridLib.MSFlexGrid MSFlexGrid2
Height = 6735
Left = 240
TabIndex = 4
Top = 600
Width = 14295
_ExtentX = 25215
_ExtentY = 11880
_Version = 393216
Cols = 5
FixedCols = 0
FillStyle = 1
End
End
Begin VB.Label Label1
Caption = "員工編號"
BeginProperty Font
Name = "楷體_GB2312"
Size = 12
Charset = 134
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 255
Left = 600
TabIndex = 1
Top = 480
Width = 1095
End
End
Attribute VB_Name = "frmResult"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private iclickflag As Integer
Private Sub cmdCheckAll_Click()
Dim sql As String
Select Case Me.SSTab1.Tab
Case 0
sql = "select * from SalarySetting"
Call BasicTopic
Call showBasic(sql)
Case 1
sql = "select * from SalaryOther"
Call OtherTopic
Call showOther(sql)
Case 2
sql = "select * from SalaryStatistics order by ID desc"
Call ListTopic
Call ShowData(sql)
End Select
iclickflag = 2
End Sub
Private Sub cmdOK_Click()
Dim sql As String
Select Case Me.SSTab1.Tab
Case 0
sql = "select * from SalarySetting where StuffID='" & Me.comID.Text & "'"
Call BasicTopic
Call showBasic(sql)
Case 1
sql = "select * from SalaryOther where StuffID='" & Me.comID.Text & "'"
Call OtherTopic
Call showOther(sql)
Case 2
sql = "select * from SalaryStatistics where StuffID='" & Me.comID.Text & "'"
Call ListTopic
Call ShowData(sql)
End Select
iclickflag = 1
End Sub
Private Sub Form_Load()
Dim sql As String
Dim rs As New ADODB.Recordset
sql = "select StuffID from SalarySetting"
Set rs = getRS(sql, "Salary")
If rs.EOF = False Then
While Not rs.EOF
Me.comID.AddItem rs(0)
rs.MoveNext
Wend
rs.Close
End If
Me.comID.ListIndex = 0
Select Case Me.SSTab1.Tab
Case 0
sql = "select * from SalarySetting"
Call BasicTopic
Call showBasic(sql)
Case 1
sql = "select * from SalaryOther"
Call OtherTopic
Call showOther(sql)
Case 2
sql = "select * from SalaryStatistics order by ID desc"
Call ListTopic
Call ShowData(sql)
End Select
End Sub
Public Sub BasicTopic()
Dim i As Integer
With Me.MSFlexGrid2 '設置表頭
.TextMatrix(0, 0) = "記錄編號"
.TextMatrix(0, 1) = "員工編號"
.TextMatrix(0, 2) = "員工姓名"
.TextMatrix(0, 3) = "員工職務"
.TextMatrix(0, 4) = "基本工資"
For i = 0 To 4 '設置所有表格對齊方式
.ColAlignment(i) = 4
Next i
For i = 0 To 4 '設置每列寬度
.ColWidth(i) = 1000
Next i
End With
End Sub
Public Sub showBasic(strQuery As String)
Dim rs As New ADODB.Recordset
Dim rs1 As New ADODB.Recordset
Dim sql As String
Set rs = getRS(strQuery, "Salary")
If rs.RecordCount = 0 Then
MsgBox "沒有工資設置！", vbOKOnly + vbExclamation, "提示！"
frmBasicSetting.Show
frmBasicSetting.ZOrder 0
Else
With Me.MSFlexGrid2
.Rows = 1
While Not rs.EOF
.Rows = .Rows + 1
.TextMatrix(.Rows - 1, 0) = rs(0)
.TextMatrix(.Rows - 1, 1) = rs(1)
sql = "select SName from StuffInfo where SID='" & rs(1) & "'"
Set rs1 = getRS(sql, "Salary")
.TextMatrix(.Rows - 1, 2) = rs1(0)
rs1.Close
.TextMatrix(.Rows - 1, 3) = rs(2)
.TextMatrix(.Rows - 1, 4) = rs(3) & "元"
rs.MoveNext
Wend
End With
rs.Close
End If
End Sub
Public Sub ListTopic()
Dim i As Integer
With Me.MSFlexGrid1 '設置表頭
.TextMatrix(0, 0) = "記錄編號"
.TextMatrix(0, 1) = "員工編號"
.TextMatrix(0, 2) = "員工姓名"
.TextMatrix(0, 3) = "統計日期"
.TextMatrix(0, 4) = "基本工資"
.TextMatrix(0, 5) = "獎 金"
.TextMatrix(0, 6) = "福 利"
.TextMatrix(0, 7) = "津 貼"
.TextMatrix(0, 8) = "扣 發"
.TextMatrix(0, 9) = "遲到早退"
.TextMatrix(0, 10) = "曠工扣發"
.TextMatrix(0, 11) = "加班費"
.TextMatrix(0, 12) = "出差費"
.TextMatrix(0, 13) = "其 他"
.TextMatrix(0, 14) = "總 額"
For i = 0 To 14 '設置所有表格對齊方式
.ColAlignment(i) = 4
Next i
For i = 0 To 14 '設置每列寬度
.ColWidth(i) = 1000
Next i
End With
End Sub
Public Sub ShowData(strQuery As String)
Dim rs As New ADODB.Recordset
Set rs = getRS(strQuery, "Salary")
If rs.EOF = False Then
With Me.MSFlexGrid1
.Rows = 1
While Not rs.EOF
.Rows = .Rows + 1
.TextMatrix(.Rows - 1, 0) = rs(0)
.TextMatrix(.Rows - 1, 1) = rs(1)
.TextMatrix(.Rows - 1, 2) = rs(2)
.TextMatrix(.Rows - 1, 3) = rs(3)
.TextMatrix(.Rows - 1, 4) = rs(4) & "元"
.TextMatrix(.Rows - 1, 5) = rs(5) & "元"
.TextMatrix(.Rows - 1, 6) = rs(6) & "元"
.TextMatrix(.Rows - 1, 7) = rs(7) & "元"
.TextMatrix(.Rows - 1, 8) = rs(8) & "元"
.TextMatrix(.Rows - 1, 9) = rs(9) & "元"
.TextMatrix(.Rows - 1, 10) = rs(10) & "元"
.TextMatrix(.Rows - 1, 11) = rs(11) & "元"
.TextMatrix(.Rows - 1, 12) = rs(12) & "元"
.TextMatrix(.Rows - 1, 13) = rs(13) & "元"
.TextMatrix(.Rows - 1, 14) = rs(14) & "元"
rs.MoveNext
Wend
End With
rs.Close
End If
End Sub
Public Sub OtherTopic()
Dim i As Integer
With Me.MSFlexGrid3 '設置表頭
.TextMatrix(0, 0) = "記錄編號"
.TextMatrix(0, 1) = "員工編號"
.TextMatrix(0, 2) = "員工姓名"
.TextMatrix(0, 3) = "添加日期"
.TextMatrix(0, 4) = "名 稱"
.TextMatrix(0, 5) = "金 額"
.TextMatrix(0, 6) = "備 注"
For i = 0 To 6 '設置所有表格對齊方式
.ColAlignment(i) = 4
Next i
For i = 0 To 6 '設置每列寬度
.ColWidth(i) = 1000
Next i
End With
End Sub
Public Sub showOther(strQuery As String)
Dim rs As New ADODB.Recordset
Dim rs1 As New ADODB.Recordset
Dim sql As String
Set rs = getRS(strQuery, "Salary")
If rs.EOF = False Then
With Me.MSFlexGrid3
.Rows = 1
While Not rs.EOF
.Rows = .Rows + 1
.TextMatrix(.Rows - 1, 0) = rs(0)
.TextMatrix(.Rows - 1, 1) = rs(1)
sql = "select SName from StuffInfo where SID='" & rs(1) & "'"
Set rs1 = getRS(sql, "Salary")
.TextMatrix(.Rows - 1, 2) = rs1(0)
rs1.Close
.TextMatrix(.Rows - 1, 3) = rs(2)
.TextMatrix(.Rows - 1, 4) = rs(4)
.TextMatrix(.Rows - 1, 5) = rs(5) & "元"
.TextMatrix(.Rows - 1, 6) = rs(6)
rs.MoveNext
Wend
End With
rs.Close
End If
End Sub
Private Sub MSFlexGrid2_MouseUp(Button As Integer, Shift As Integer, x As Single, y As Single)
If Shift = 0 And Button = 2 Then
PopupMenu frmpopMenu.PopMenu
End If
End Sub
Private Sub MSFlexGrid3_MouseUp(Button As Integer, Shift As Integer, x As Single, y As Single)
If Shift = 0 And Button = 2 Then
PopupMenu frmpopMenu.popmenu2
End If
End Sub
Private Sub SSTab1_Click(PreviousTab As Integer)
Dim sql As String
If iclickflag = 1 Then
Select Case Me.SSTab1.Tab
Case 0
sql = "select * from SalarySetting where StuffID='" & Me.comID.Text & "'"
Call BasicTopic
Call showBasic(sql)
Case 1
sql = "select * from SalaryOther where StuffID='" & Me.comID.Text & "'"
Call OtherTopic
Call showOther(sql)
Case 2
sql = "select * from SalaryStatistics where StuffID='" & Me.comID.Text & "'"
Call ListTopic
Call ShowData(sql)
End Select
Else
Select Case Me.SSTab1.Tab
Case 0
sql = "select * from SalarySetting"
Call BasicTopic
Call showBasic(sql)
Case 1
sql = "select * from SalaryOther"
Call OtherTopic
Call showOther(sql)
Case 2
sql = "select * from SalaryStatistics order by ID desc"
Call ListTopic
Call ShowData(sql)
End Select
End If
End Sub
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -