📄 zͩ
字号:
VERSION 5.00
Begin VB.Form ZBFX_BaseGuideLineSeach
BorderStyle = 1 'Fixed Single
Caption = "指标分析_基本财务指标分析查询条件"
ClientHeight = 1905
ClientLeft = 45
ClientTop = 330
ClientWidth = 5535
Icon = "z指标分析_基本财务指标分析查询条件1.frx":0000
KeyPreview = -1 'True
LinkTopic = "Form2"
MaxButton = 0 'False
MinButton = 0 'False
ScaleHeight = 1905
ScaleWidth = 5535
StartUpPosition = 2 '屏幕中心
Begin VB.Frame Frame1
Caption = "数据录入"
Height = 2475
Index = 2
Left = 5925
TabIndex = 5
Top = 2985
Width = 3120
Begin VB.TextBox lrText
Height = 300
Index = 4
Left = 1470
TabIndex = 15
Text = "0"
Top = 1950
Width = 1485
End
Begin VB.TextBox lrText
Height = 300
Index = 3
Left = 1470
TabIndex = 14
Text = "0"
Top = 1530
Width = 1485
End
Begin VB.TextBox lrText
Height = 300
Index = 2
Left = 1470
TabIndex = 13
Text = "0"
Top = 1110
Width = 1485
End
Begin VB.TextBox lrText
Height = 300
Index = 1
Left = 1470
TabIndex = 12
Text = "0"
Top = 690
Width = 1485
End
Begin VB.TextBox lrText
Height = 300
Index = 0
Left = 1470
TabIndex = 11
Text = "0"
Top = 270
Width = 1485
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "优先股股数:"
Height = 180
Index = 4
Left = 465
TabIndex = 10
Top = 2010
Width = 990
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "优先股权益:"
Height = 180
Index = 3
Left = 465
TabIndex = 9
Top = 1590
Width = 990
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "每股盈余:"
Height = 180
Index = 2
Left = 645
TabIndex = 8
Top = 1170
Width = 810
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "每股市价:"
Height = 180
Index = 1
Left = 645
TabIndex = 7
Top = 750
Width = 810
End
Begin VB.Label Label1
AutoSize = -1 'True
BackStyle = 0 'Transparent
Caption = "普通股平均股数:"
Height = 180
Index = 0
Left = 105
TabIndex = 6
Top = 330
Width = 1350
End
End
Begin VB.Frame Frame1
Caption = "比较日期"
Height = 1185
Index = 1
Left = 2880
TabIndex = 4
Top = 165
Width = 2565
Begin VB.ComboBox Combo_CompDate
Height = 300
Left = 135
Style = 2 'Dropdown List
TabIndex = 19
Top = 705
Width = 2325
End
Begin VB.ComboBox Combo_SelYear
Height = 300
Left = 120
Style = 2 'Dropdown List
TabIndex = 18
Top = 225
Width = 2325
End
End
Begin VB.Frame Frame1
Caption = "分析日期"
Height = 1185
Index = 0
Left = 105
TabIndex = 3
Top = 165
Width = 2535
Begin VB.ComboBox Combo_BaseDate
Height = 300
Left = 120
Style = 2 'Dropdown List
TabIndex = 17
Top = 705
Width = 2325
End
Begin VB.ComboBox Combo_Type
Height = 300
Left = 105
Style = 2 'Dropdown List
TabIndex = 16
Top = 210
Width = 2325
End
End
Begin VB.CommandButton QdCommand
Caption = "确定(&O)"
Height = 300
Left = 3060
TabIndex = 2
Top = 1500
Width = 1120
End
Begin VB.CommandButton QxCommand
Caption = "取消(&C)"
Height = 300
Left = 4305
TabIndex = 0
Top = 1500
Width = 1120
End
Begin VB.CheckBox UnloadCheck
Caption = "卸载窗体"
Height = 615
Left = 8250
TabIndex = 1
Top = 720
Visible = 0 'False
Width = 825
End
End
Attribute VB_Name = "ZBFX_BaseGuideLineSeach"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
Private UsedYear() As String '已使用年数据，如：UsedYear(0)="1999",UsedYear(1)="2000"
Private iHowManyYears As Integer '已使用的年数
Private iMaxMonth As Integer '最大使用月份
Dim Combo_Change_Locked As Boolean 'Combo控件变化锁(是否被锁，False没有锁，
'这时锁是开着的；True锁定，被锁住了，
'锁住时，Click事件不起作用，默认锁是开着的，
'默认值为False)
Private Tsxx As String '系统提示信息
'以下为固定使用变量(文本框)
Private Textvar() As Variant '存储变体型文本框信息
Private Textboolean() As Boolean '存储布尔型文本框信息
Private Textint() As Integer '存储整型文本框信息
Private Textstr() As String '存储字符型文本框信息
Private Max_Text_Index As Integer '最大录入文本框索引值
Private TextGroupCode As String '文本框录入分组编码
Private TextValiLock As Boolean '文本框失去焦点是否进行有效性控制判断
Private TextValiJudgeLock() As Boolean '文本框录入有效性判断控制锁
Private CurTextIndex As Integer '当前文本框索引值
Private TextChangeLock As Boolean '文本框内容变换控制锁
Private Bln_Cancel As Boolean '取消按钮信息传递
Private Sub Form_KeyPress(KeyAscii As Integer) '控 制 焦 点 转 移
Dim jdzygs As Integer '控件焦点转移个数
jdzygs = 30
Select Case KeyAscii
Case vbKeyReturn
If Kjjdzy(jdzygs) Then
KeyAscii = 0
End If
Case 39 '屏蔽"'"
KeyAscii = 0
End Select
End Sub
Private Sub Form_Load()
Call GetUsedYear
Call GetUsedMonth
'填充
Call FillCombo(Combo_Type, "BaseGuideLineSeach", "", 0)
Call FillThisYear(Combo_BaseDate)
Call FillYear(Combo_SelYear)
'以下为文本框处理程序
TextGroupCode = "cwfx_BaseGuideLineSeach"
Call Drwbkxx(TextGroupCode, Textvar(), Textboolean(), Textint(), Textstr()) '读入文本框录入信息
Call Wbkcsh
End Sub
Private Sub FillThisYear(PastComb As ComboBox)
With PastComb
.Clear
.AddItem Xtyear
.ListIndex = 0
End With
End Sub
Private Sub FillYear(PastComb As ComboBox)
Dim i As Integer
With PastComb
.Clear
.AddItem ""
For i = 0 To iHowManyYears
.AddItem UsedYear(i)
Next
End With
End Sub
Private Sub FillMonth(PastComb As ComboBox, ByVal PastYear As String)
Dim i As Integer
With PastComb
.Clear
If iMaxMonth < 1 Then Exit Sub
For i = 1 To iMaxMonth
.AddItem PastYear & "." & Format(i, "00")
Next
End With
End Sub
Private Sub FillThreeMonth(PastComb As ComboBox, ByVal PastYear As String)
Dim i As Integer
With PastComb
.Clear
If iMaxMonth < 1 Then Exit Sub
For i = 1 To 4
.AddItem PastYear & "." & Format(((i - 1) * 3 + 1), "00") & "-" & PastYear & "." & Format((i * 3), "00")
Next
End With
End Sub
Private Sub GetUsedYear()
'由Form_Load 调用,得到此帐套已使用的年度，存于UsedYear()数据中
Dim temRs As New ADODB.Recordset
Dim strSql As String
Dim i As Integer
strSql = "SELECT DISTINCT kjyear AS cYear FROM xt_kjrlb"
Set temRs = Cw_DataEnvi.DataConnect.Execute(strSql)
iHowManyYears = temRs.RecordCount - 1
ReDim UsedYear(iHowManyYears)
With temRs
Do Until .EOF
UsedYear(i) = !cYear
i = i + 1
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -