📄 frm4select.frm
字号:
VERSION 5.00
Object = "{3B008041-905A-11D1-B4AE-444553540000}#1.0#0"; "Vsocx6.ocx"
Object = "{D76D7128-4A96-11D3-BD95-D296DC2DD072}#1.0#0"; "Vsflex7.ocx"
Begin VB.Form frmSelect
Caption = "人员信息"
ClientHeight = 3195
ClientLeft = 60
ClientTop = 345
ClientWidth = 5295
BeginProperty Font
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
LinkTopic = "Form1"
ScaleHeight = 3195
ScaleWidth = 5295
StartUpPosition = 1 'CenterOwner
Begin vsOcx6LibCtl.vsElastic vsElastic1
Height = 3195
Left = 0
TabIndex = 0
TabStop = 0 'False
Top = 0
Width = 5295
_ExtentX = 9340
_ExtentY = 5636
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
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 = -2147483635
FloodColor = 192
ForeColorDisabled= -2147483631
Caption = "请选择以下人员信息："
Align = 5
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 = 3
GridCols = 3
_GridInfo = $"frm4Select.frx":0000
Begin VB.CommandButton Command4OK
Caption = "确定(&O)"
Height = 375
Left = 2220
TabIndex = 3
Top = 2730
Width = 1455
End
Begin VB.CommandButton Command4Cancel
Caption = "取消(&C)"
Height = 375
Left = 3735
TabIndex = 2
Top = 2730
Width = 1470
End
Begin VSFlex7Ctl.VSFlexGrid VSFlexGrid4Select
Height = 2400
Left = 90
TabIndex = 1
Top = 270
Width = 5115
_cx = 9022
_cy = 4233
_ConvInfo = -1
Appearance = 1
BorderStyle = 1
Enabled = -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
MousePointer = 0
BackColor = -2147483643
ForeColor = -2147483640
BackColorFixed = -2147483633
ForeColorFixed = -2147483630
BackColorSel = -2147483635
ForeColorSel = -2147483634
BackColorBkg = -2147483636
BackColorAlternate= -2147483643
GridColor = -2147483633
GridColorFixed = -2147483632
TreeColor = -2147483632
FloodColor = 192
SheetBorder = -2147483642
FocusRect = 1
HighLight = 1
AllowSelection = -1 'True
AllowBigSelection= -1 'True
AllowUserResizing= 0
SelectionMode = 0
GridLines = 1
GridLinesFixed = 2
GridLineWidth = 1
Rows = 50
Cols = 10
FixedRows = 1
FixedCols = 1
RowHeightMin = 0
RowHeightMax = 0
ColWidthMin = 0
ColWidthMax = 0
ExtendLastCol = 0 'False
FormatString = ""
ScrollTrack = 0 'False
ScrollBars = 3
ScrollTips = 0 'False
MergeCells = 0
MergeCompare = 0
AutoResize = -1 'True
AutoSizeMode = 0
AutoSearch = 0
AutoSearchDelay = 2
MultiTotals = -1 'True
SubtotalPosition= 1
OutlineBar = 0
OutlineCol = 0
Ellipsis = 0
ExplorerBar = 0
PicturesOver = 0 'False
FillStyle = 0
RightToLeft = 0 'False
PictureType = 0
TabBehavior = 0
OwnerDraw = 0
Editable = 0
ShowComboButton = -1 'True
WordWrap = 0 'False
TextStyle = 0
TextStyleFixed = 0
OleDragMode = 0
OleDropMode = 0
DataMode = 0
VirtualData = -1 'True
DataMember = ""
ComboSearch = 3
AutoSizeMouse = -1 'True
FrozenRows = 0
FrozenCols = 0
AllowUserFreezing= 0
BackColorFrozen = 0
ForeColorFrozen = 0
WallPaperAlignment= 9
End
End
End
Attribute VB_Name = "frmSelect"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Option Explicit
Public m_EmpNo4Select As Long
Public m_EmpName4Select As String
Public m_OrganNo4Select As String
Public m_OrganName4Select As String
Dim oRs4This As New ADODB.Recordset
'选择窗体的变量 '1为工资 '2为人员其它信息 '3为人员基本信息
Public m_int4SelectForm As Long
Private Sub Command4Cancel_Click()
Unload Me
End Sub
Private Sub Command4OK_Click()
With VSFlexGrid4Select
If .Row > 1 Then
m_EmpNo4Select = .TextMatrix(.Row, 1)
m_OrganNo4Select = .TextMatrix(.Row, 2)
m_EmpName4Select = .TextMatrix(.Row, 3)
m_OrganName4Select = .TextMatrix(.Row, 4)
Unload Me
Select Case m_int4SelectForm
Case 1
frmSplash.Show
DoEvents
frmWageEdit.Show 1
Case 2
' Select Case frmEmpOtherMessage.vsIndexTab4This.CurrTab
' Case 0: frmWorkAndEducationVita.Show 1
' Case 1: frmTrain.Show 1
' Case 2: frmArticle.Show 1
' Case 3: frmScientificSearch.Show 1
' Case 4: frmWorkAndEducationVita.Show 1
' Case 5: frmWorkAndEducationVita.Show 1
' Case 6: frmWorkAndEducationVita.Show 1
' Case 7: frmPunish.Show 1
' Case 8: frmReward.Show 1
' Case 9: frmAbroad.Show 1
' Case 10: frmPrepareCadre.Show 1
' Case 11: frmCadreYearCheck.Show 1
' Case 12: frmExamination.Show 1
' End Select
End Select
End If
End With
End Sub
Private Sub Form_Load()
Me.Height = 2730
Me.Width = 4780
Dim strsql As String
m_EmpNo4Select = 0
m_OrganNo4Select = ""
strsql = "select emp_no,t_emp_basic.FACTORY_ORGAN,emp_name,organ_name from t_emp_basic,t_organ where t_organ.organ_no=t_emp_basic.FACTORY_ORGAN and t_organ.ORGAN_NO='" & g_str4LoginUnit & "'"
If oRs4This.State = adStateOpen Then oRs4This.Close
oRs4This.CursorLocation = adUseClient
oRs4This.Open strsql, g_oConnection4This, adOpenKeyset, adLockOptimistic
Set VSFlexGrid4Select.DataSource = oRs4This
With VSFlexGrid4Select
.Cols = 5
.TextMatrix(0, 1) = "职工编号"
.TextMatrix(0, 2) = "organ_no"
.TextMatrix(0, 3) = "职工姓名"
.TextMatrix(0, 4) = "厂(处)级单位"
.AllowSelection = False
.SelectionMode = flexSelectionByRow
.Editable = flexEDNone
.AllowUserResizing = flexResizeColumns
.ExplorerBar = flexExSort
.ExtendLastCol = True
' .ColHidden(1) = True
.ColHidden(2) = True
.ColWidth(0) = .RowHeight(0)
.ColWidth(1) = .ClientWidth * 0.3
.ColWidth(3) = .ClientWidth * 0.3
.ColWidth(4) = .ClientWidth * 0.4
End With
Unload frmSplash
End Sub
Private Sub VSFlexGrid4Select_DblClick()
With VSFlexGrid4Select
If .Row > 1 Then
m_EmpNo4Select = .TextMatrix(.Row, 1)
m_OrganNo4Select = .TextMatrix(.Row, 2)
m_EmpName4Select = .TextMatrix(.Row, 3)
m_OrganName4Select = .TextMatrix(.Row, 4)
Unload Me
Select Case m_int4SelectForm
Case 1
frmWageEdit.Show 1
Case 2
' Select Case frmEmpOtherMessage.vsIndexTab4This.CurrTab
' Case 0: frmWorkAndEducationVita.Show 1
' Case 1: frmTrain.Show 1
' Case 2: frmArticle.Show 1
' Case 3: frmScientificSearch.Show 1
' Case 4: frmWorkAndEducationVita.Show 1
' Case 5: frmWorkAndEducationVita.Show 1
' Case 6: frmWorkAndEducationVita.Show 1
' Case 7: frmPunish.Show 1
' Case 8: frmReward.Show 1
' Case 9: frmAbroad.Show 1
' Case 10: frmPrepareCadre.Show 1
' Case 11: frmCadreYearCheck.Show 1
' Case 12: frmExamination.Show 1
' End Select
End Select
End If
End With
End Sub
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -