📄 frmreport.frm
字号:
Begin vsOcx6LibCtl.vsElastic vsElastic4Top
Height = 1485
Left = 90
TabIndex = 1
TabStop = 0 'False
Top = 90
Width = 9030
_ExtentX = 15928
_ExtentY = 2619
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "Arial"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Enabled = -1 'True
Appearance = 1
MousePointer = 0
_ConvInfo = -1
Version = 600
BackColor = -2147483633
ForeColor = -2147483630
FloodColor = 192
ForeColorDisabled= -2147483631
Caption = "请输入报表条件"
Align = 0
Appearance = 1
AutoSizeChildren= 8
BorderWidth = 6
ChildSpacing = 4
Splitter = 0 'False
FloodDirection = 0
FloodPercent = 0
CaptionPos = 1
WordWrap = -1 'True
MaxChildSize = 0
MinChildSize = 0
TagWidth = 0
TagPosition = 0
Style = 1
TagSplit = 0 'False
PicturePos = 4
CaptionStyle = 0
ResizeFonts = 0 'False
GridRows = 4
GridCols = 6
_GridInfo = $"frmReport.frx":00D4
Begin VB.TextBox Text4TableEmp
Height = 315
Left = 1365
TabIndex = 4
Top = 1080
Width = 2850
End
Begin VB.TextBox Text4CompanyEmp
Height = 300
Left = 5880
TabIndex = 16
Top = 720
Width = 3060
End
Begin VB.TextBox Text4OrganEmp
Height = 300
Left = 1365
TabIndex = 14
Top = 720
Width = 2850
End
Begin VB.DriveListBox Drive4This
Height = 345
Left = 7395
TabIndex = 10
Top = 1080
Width = 1545
End
Begin MSComCtl2.DTPicker DTPicker4Time
Height = 330
Left = 5880
TabIndex = 5
Top = 330
Width = 3060
_ExtentX = 5398
_ExtentY = 582
_Version = 393216
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "Arial"
Size = 9
Charset = 0
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
CheckBox = -1 'True
Format = 69206016
CurrentDate = 37210
End
Begin ActiveInput.SSComboBoxEx SSComboBoxEx4Organ
Height = 315
Left = 1365
TabIndex = 18
Top = 330
Width = 2850
_ExtentX = 5027
_ExtentY = 556
_Version = 65536
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
MaxListItems = 0
CheckList = -1 'True
End
Begin VB.Label Label4TableEmp
Caption = "填表人"
Height = 315
Left = 90
TabIndex = 17
Top = 1080
Width = 1215
End
Begin VB.Label Label4CompanyEmp
Caption = "部门负责人"
Height = 300
Left = 4275
TabIndex = 15
Top = 720
Width = 1545
End
Begin VB.Label Label4OrganEmp
Caption = "单位负责人"
Height = 300
Left = 90
TabIndex = 13
Top = 720
Width = 1215
End
Begin VB.Label Label4Path
Caption = "生成报表存储路径"
Height = 315
Left = 5880
TabIndex = 12
Top = 1080
Width = 1455
End
Begin VB.Label Label4Time
Caption = "数据截止日期"
Height = 330
Left = 4275
TabIndex = 3
Top = 330
Width = 1545
End
Begin VB.Label Label4Organ
Caption = "机构名称"
Height = 330
Left = 90
TabIndex = 2
Top = 330
Width = 1215
End
End
End
End
Attribute VB_Name = "frmReport"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Private Const C_REPORT_NAME = 1
Private Const C_REPORT_ORGAN = 2
Private Const C_REPORT_TYPE = 3
Private Const C_REPORT_NO = 4
Private Sub Command4Close_Click()
Unload Me
End Sub
Private Sub Command4MakeReport_Click()
If Me.VSFlexGrid4Report.Row <= 0 Then Exit Sub
If Me.SSComboBoxEx4Organ.text = "" Then MsgBox "请选择机构", vbOKOnly, "提示": Exit Sub
Me.MousePointer = 11
g_str4ReportOrgan = Me.SSComboBoxEx4Organ.text
g_str4OrganEmp = Trim(Text4OrganEmp.text)
g_str4CompanyEmp = Trim(Text4CompanyEmp.text)
g_str4TableEmp = Trim(Text4TableEmp.text)
g_str4ReportTime = CheckVariant(Format(DTPicker4Time.Value, "yyyy年MM月dd日"))
With Me.VSFlexGrid4Report
Select Case .TextMatrix(.Row, 1)
'劳资报表
Case C_EMP_REMOVE
If EmpRemoveReport = False Then Me.MousePointer = 1: Exit Sub
Case C_NEW_EMP
If Getnewadd_worker = False Then Me.MousePointer = 1: Exit Sub
Case C_EMP_PUNISH
If Getpunish = False Then Me.MousePointer = 1: Exit Sub
Case C_USER_WORK
If Getsp_bureau_self_emp = False Then Me.MousePointer = 1: Exit Sub
Case C_WORKER_SEPR
If Getsp_worker_technical_and_structure = False Then Me.MousePointer = 1: Exit Sub
Case C_COMPACT_RUN
If Getcompact_run = False Then Me.MousePointer = 1: Exit Sub
Case C_LEVEL_EMP
If Getinner = False Then Me.MousePointer = 1: Exit Sub
Case C_OTHER_AGE_EDUCATION
If Getother_emp_culture_and_age = False Then Me.MousePointer = 1: Exit Sub
Case C_EMP_SEPR
If Getsp_brigade_speciality = False Then Me.MousePointer = 1: Exit Sub
Case C_DEL_COMPACT
If GetDel_Compact = False Then Me.MousePointer = 1: Exit Sub
Case C_BRIGE_EMP
If Getsp_brigade_and_emp = False Then Me.MousePointer = 1: Exit Sub
Case C_EMP_AGE_EDUCATION
If Getemp_culture_and_age = False Then Me.MousePointer = 1: Exit Sub
Case C_ORGAN
If ExportExcel(, , C_ORGAN, Me.Dir4This.Path) = False Then Me.MousePointer = 1: Exit Sub
Case C_EMP_ORGAN
If Getsp_basic_organ_and_emp(Me.SSComboBoxEx4Organ.ItemData(Me.SSComboBoxEx4Organ.ListIndex)) = False Then Me.MousePointer = 1: Exit Sub
Case C_EMP_WAGE
If Getsp_emp_wage = False Then Me.MousePointer = 1: Exit Sub
Case C_EMP_WAGE_OTHER
If Getsp_allowence = False Then Me.MousePointer = 1: Exit Sub
Case C_WORKER_SORT_YEAR
If ExportExcel(, , C_WORKER_SORT_YEAR, Me.Dir4This.Path) = False Then Me.MousePointer = 1: Exit Sub
Case C_COLLECTIVITY_ECONOMY_WAGE
If ExportExcel(, , C_COLLECTIVITY_ECONOMY_WAGE, Me.Dir4This.Path) = False Then Me.MousePointer = 1: Exit Sub
Case C_NOT_IN_WAGE_EARNING
If ExportExcel(, , C_NOT_IN_WAGE_EARNING, Me.Dir4This.Path) = False Then Me.MousePointer = 1: Exit Sub
Case C_WORKER_TECHNIC_FRAME
' 注释by bxm 2002-09-23
'If ExportExcel(, , C_WORKER_TECHNIC_FRAME, Me.Dir4This.Path) = False Then Me.MousePointer = 1: Exit Sub
If Getsp_worker_technical_and_structure = False Then Me.MousePointer = 1: Exit Sub
'干部报表
Case C_CADRE_DUTY '长庆局各类干部职务情况统计表
If ExportExcel(, , C_CADRE_DUTY, Me.Dir4This.Path) = False Then Me.MousePointer = 1: Exit Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -