📄 fixedtypelist.frm
字号:
VERSION 5.00
Object = "{5E9E78A0-531B-11CF-91F6-C2863C385E30}#1.0#0"; "MSFLXGRD.OCX"
Object = "{0D452EE1-E08F-101A-852E-02608C4D0BB4}#2.0#0"; "FM20.DLL"
Object = "{BDC217C8-ED16-11CD-956C-0000C04E4C0A}#1.1#0"; "TABCTL32.OCX"
Object = "{F6125AB1-8AB1-11CE-A77F-08002B2F4E98}#2.0#0"; "MSRDC20.OCX"
Begin VB.Form frmFixedTypeList
BackColor = &H80000004&
Caption = "固定资产编码列表"
ClientHeight = 3828
ClientLeft = 2196
ClientTop = 1812
ClientWidth = 6564
Icon = "FixedTypeList.frx":0000
KeyPreview = -1 'True
LinkTopic = "Form1"
MDIChild = -1 'True
ScaleHeight = 3930.83
ScaleMode = 0 'User
ScaleWidth = 6500
Begin MSRDC.MSRDC datItem
Height = 330
Index = 0
Left = 1380
Top = 3630
Visible = 0 'False
Width = 1200
_ExtentX = 2117
_ExtentY = 572
_Version = 393216
Options = 0
CursorDriver = 0
BOFAction = 0
EOFAction = 0
RecordsetType = 1
LockType = 3
QueryType = 0
Prompt = 3
Appearance = 1
QueryTimeout = 30
RowsetSize = 100
LoginTimeout = 15
KeysetSize = 0
MaxRows = 0
ErrorThreshold = -1
BatchSize = 15
BackColor = -2147483643
ForeColor = -2147483640
Enabled = -1 'True
ReadOnly = 0 'False
Appearance = -1 'True
DataSourceName = ""
RecordSource = ""
UserName = ""
Password = ""
Connect = ""
LogMessages = ""
Caption = "MSRDC1"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
Begin VB.CommandButton cmdAgain
BeginProperty Font
Name = "Arial"
Size = 9
Charset = 0
Weight = 700
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
Height = 300
Left = 5680
Style = 1 'Graphical
TabIndex = 4
Tag = "1017"
Top = 90
UseMaskColor = -1 'True
Width = 300
End
Begin VB.TextBox txtFind
Height = 300
Left = 4000
TabIndex = 3
Text = "Text1"
Top = 90
Width = 1695
End
Begin VB.CheckBox chkShowAll
Caption = "全部显示"
Height = 350
Left = 3880
TabIndex = 9
Top = 3270
Width = 1095
End
Begin VB.ComboBox cboFindKind
Height = 300
Left = 850
Style = 2 'Dropdown List
TabIndex = 1
Top = 90
Width = 1800
End
Begin TabDlg.SSTab sstTypAct
Height = 2625
Left = 45
TabIndex = 5
Top = 600
Width = 6105
_ExtentX = 10774
_ExtentY = 4636
_Version = 393216
Style = 1
Tabs = 2
TabsPerRow = 4
TabHeight = 529
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
TabCaption(0) = "固资类型(&N)"
TabPicture(0) = "FixedTypeList.frx":0442
Tab(0).ControlEnabled= -1 'True
Tab(0).Control(0)= "msgFixedType"
Tab(0).Control(0).Enabled= 0 'False
Tab(0).ControlCount= 1
TabCaption(1) = "变动方式(&M)"
TabPicture(1) = "FixedTypeList.frx":045E
Tab(1).ControlEnabled= 0 'False
Tab(1).Control(0)= "msgFixedMethod"
Tab(1).ControlCount= 1
Begin MSFlexGridLib.MSFlexGrid msgFixedMethod
Bindings = "FixedTypeList.frx":047A
Height = 1995
Left = -74880
TabIndex = 7
Top = 450
Width = 5925
_ExtentX = 10456
_ExtentY = 3514
_Version = 393216
Rows = 10
FixedCols = 0
BackColor = 16777215
BackColorFixed = -2147483644
BackColorSel = -2147483646
BackColorBkg = 16777215
AllowBigSelection= 0 'False
FocusRect = 0
SelectionMode = 1
End
Begin MSFlexGridLib.MSFlexGrid msgFixedType
Bindings = "FixedTypeList.frx":0493
Height = 2025
Left = 120
TabIndex = 6
Top = 450
Width = 5925
_ExtentX = 10456
_ExtentY = 3556
_Version = 393216
Rows = 10
FixedCols = 0
BackColor = 16777215
BackColorFixed = -2147483644
BackColorSel = -2147483646
BackColorBkg = 16777215
AllowBigSelection= 0 'False
FocusRect = 0
SelectionMode = 1
AllowUserResizing= 1
End
End
Begin MSRDC.MSRDC datItem
Height = 330
Index = 1
Left = 2640
Top = 3600
Visible = 0 'False
Width = 1200
_ExtentX = 2117
_ExtentY = 593
_Version = 393216
Options = 0
CursorDriver = 0
BOFAction = 0
EOFAction = 0
RecordsetType = 1
LockType = 3
QueryType = 0
Prompt = 3
Appearance = 1
QueryTimeout = 30
RowsetSize = 100
LoginTimeout = 15
KeysetSize = 0
MaxRows = 0
ErrorThreshold = -1
BatchSize = 15
BackColor = -2147483643
ForeColor = -2147483640
Enabled = -1 'True
ReadOnly = 0 'False
Appearance = -1 'True
DataSourceName = ""
RecordSource = ""
UserName = ""
Password = ""
Connect = ""
LogMessages = ""
Caption = "MSRDC1"
BeginProperty Font {0BE35203-8F91-11CE-9DE3-00AA004BB851}
Name = "宋体"
Size = 9
Charset = 134
Weight = 400
Underline = 0 'False
Italic = 0 'False
Strikethrough = 0 'False
EndProperty
End
Begin MSForms.CommandButton cmdTypact
Height = 345
Index = 2
Left = 2070
TabIndex = 11
TabStop = 0 'False
Top = 4830
Visible = 0 'False
Width = 1545
Caption = "固定资产期初(G)"
Size = "2725;609"
Accelerator = 71
FontName = "宋体"
FontHeight = 180
FontCharSet = 134
FontPitchAndFamily= 34
ParagraphAlign = 3
End
Begin VB.Label lblFind
Caption = "内容(&C)"
Height = 180
Left = 3250
TabIndex = 2
Top = 150
Width = 630
End
Begin VB.Label lblFindKind
Caption = "查找(&B)"
Height = 180
Left = 50
TabIndex = 0
Top = 150
Width = 630
End
Begin MSForms.CommandButton cmdTypact
Height = 345
Index = 0
Left = 45
TabIndex = 8
Tag = "1018"
Top = 3360
Width = 1125
Caption = "编辑"
PicturePosition = 196613
Size = "1984;609"
FontName = "宋体"
FontHeight = 180
FontCharSet = 134
FontPitchAndFamily= 34
ParagraphAlign = 3
End
Begin MSForms.CommandButton cmdTypact
Height = 345
Index = 1
Left = 810
TabIndex = 10
TabStop = 0 'False
Tag = "1018"
Top = 4920
Visible = 0 'False
Width = 1215
Caption = "报表"
PicturePosition = 196613
Size = "2143;609"
FontName = "宋体"
FontHeight = 180
FontCharSet = 134
FontPitchAndFamily= 34
ParagraphAlign = 3
End
End
Attribute VB_Name = "frmFixedTypeList"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
''''''''''''''''''''''''''''''''
' 固定资产列表
' 作者：
' 日期:1998.11.27
'1.1 所用类模块：List
'1.2 所用钩子函数：mclsSubClass，mclsSubClassForm。
''''''''''''''''''''''''''''''''
Option Explicit
Private mIsShowCard(1) As Boolean '卡片窗口显示标志
Private mblnCheckNoChange As Boolean '不需要响应chkshowAll控件Change事件
Private mblnComboxNoClick As Boolean
Private WithEvents mclsMainControl As MainControl '主控对象
Attribute mclsMainControl.VB_VarHelpID = -1
Private WithEvents mclsSubClass As SubClass32.SubClass '钩子对象
Attribute mclsSubClass.VB_VarHelpID = -1
Private WithEvents mclsSubClassform As SubClass32.SubClass
Attribute mclsSubClassform.VB_VarHelpID = -1
Private mclsList(1) As list '列表对象
Private blnIsLoad(1) As Boolean
Private intViewID(1) As Integer
Private mblnIsSaveListset(1) As Boolean 'Whether or not save lngViewID in List
'
'方法及函数
'
'产生固定资产列表记录集
Public Function GetList(ByVal intTab As Integer) As rdoResultset
Dim recRecordset As rdoResultset
Dim strSelectOfSql As String
Dim strFromOfSql As String
Dim strWhereOfSql As String
Dim strSql As String
strSelectOfSql = mclsList(intTab).ListSet.GetSelect
strFromOfSql = mclsList(intTab).ListSet.FromOfSql
strWhereOfSql = mclsList(intTab).ListSet.WhereOfSql
Select Case intTab
Case 0
strSelectOfSql = "Select FixedType.lngFixedTypeID As id,decode(FixedType.blnIsInActive,1,'√','') As ""停用""," & strSelectOfSql
If Trim(strWhereOfSql) <> "" Then
strWhereOfSql = " Where " & strWhereOfSql
End If
Case 1
strSelectOfSql = "Select FixedMethod.lngFixedMethodID As id,decode(FixedMethod.blnIsInActive,1,'√','') As ""停用""," & strSelectOfSql
If Trim(strWhereOfSql) <> "" Then
strWhereOfSql = " Where " & strWhereOfSql
End If
End Select
strSql = strSelectOfSql & strFromOfSql & strWhereOfSql
Set recRecordset = gclsBase.BaseDB.OpenResultset(strSql, rdOpenStatic)
'列表是否为空
If recRecordset.RowCount = 0 Then
mclsList(intTab).FlexGrid.HighLight = flexHighlightNever
cmdAgain.Enabled = False
Else
mclsList(intTab).FlexGrid.HighLight = flexHighlightAlways
cmdAgain.Enabled = True
End If
mclsList(intTab).ShowAll = True
Set GetList = recRecordset
End Function
Public Function ShowList(ByVal lngID As Long, Optional intTab As Integer = 0) As Boolean
Dim intCount As Integer
Dim strSortField As String
Dim strSortDec As String
Dim strSql As String
Dim recTemp As rdoResultset
Dim strofFrom As String
Dim strofWhere As String
' Me.Show
' Me.ZOrder 0
With frmMain.mnuListFixedAsset
If IsNumeric(.Tag) Then
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -