📄
字号:
Key = "bcgs"
EndProperty
BeginProperty ListImage12 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":22262
Key = "mrlk"
EndProperty
BeginProperty ListImage13 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":225FC
Key = "xsxm"
EndProperty
BeginProperty ListImage14 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":22996
Key = "first"
EndProperty
BeginProperty ListImage15 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":22D30
Key = "prev"
EndProperty
BeginProperty ListImage16 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":230CA
Key = "next"
EndProperty
BeginProperty ListImage17 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":23464
Key = "last"
EndProperty
BeginProperty ListImage18 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":237FE
Key = "xx"
EndProperty
BeginProperty ListImage19 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":23B98
Key = "define"
EndProperty
BeginProperty ListImage20 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":23F32
Key = "exec"
EndProperty
BeginProperty ListImage21 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":242CC
Key = "xz"
EndProperty
BeginProperty ListImage22 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":24666
Key = "sc"
EndProperty
BeginProperty ListImage23 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":24A00
Key = "sx"
EndProperty
BeginProperty ListImage24 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":24D9A
Key = "cx"
EndProperty
BeginProperty ListImage25 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":25134
Key = "zd"
EndProperty
BeginProperty ListImage26 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":254CE
Key = "dz"
EndProperty
BeginProperty ListImage27 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":25868
Key = "ph"
EndProperty
BeginProperty ListImage28 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":25C02
Key = "fz"
EndProperty
BeginProperty ListImage29 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":25F9C
Key = "Locate"
EndProperty
BeginProperty ListImage30 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":26336
Key = "hf"
EndProperty
BeginProperty ListImage31 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":266D0
Key = "pz"
EndProperty
BeginProperty ListImage32 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":26A6A
Key = "check"
EndProperty
BeginProperty ListImage33 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":26E04
Key = "Sum"
EndProperty
BeginProperty ListImage34 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":2719E
Key = "Total"
EndProperty
BeginProperty ListImage35 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":27538
Key = "Detail"
EndProperty
BeginProperty ListImage36 {2C247F27-8591-11D1-B16A-00C0F0283628}
Picture = "查询_年龄分析列表.frx":278D2
Key = "Order"
EndProperty
EndProperty
End
End
End
Attribute VB_Name = "An_RsAgeFrm"
Attribute VB_GlobalNameSpace = False
Attribute VB_Creatable = False
Attribute VB_PredeclaredId = True
Attribute VB_Exposed = False
'**************************************************************************
'* 模 块 名 称 :年龄分析列表
'* 功 能 描 述 :显示根据定义的条件进行年龄分析的结果
'* 程序员姓名 :张洪军
'* 最后修改人 :张洪军
'* 最后修改时间:2002/01/03
'* 备 注:程序中所有依实际情况自定义部分均用[>> <<]括起
'**************************************************************************
Dim ReportTitle As String '报表主标题
Public sSqlWhere As String
Public sSqlWhereMe As String
Public sSqlWhereMore As String
Public sSqlFrom As String
Public int_CodeLevel As Integer
Dim sFieldValue() As New CFieldValue
Dim sSqlOrder As String
Dim Str_RightEdit As String '编辑(新增、修改、删除)权限索引
'以下为固定使用变量
Dim Dyymctbl As New DY_Dyymsz '打印页面窗体变量
Dim GridCode As String '显示网格网格代码
Dim GridInf() As Variant '整个网格设置信息
Dim Tsxx As String '系统提示信息
Dim Qslz As Long '网格隐藏(非操作显示)列数
Dim Sjhgd As Double '网格数据行高度
Dim Sfxshjwg As Boolean '是否显示合计网格
Dim GridBoolean() As Boolean '网格列信息(布尔型)
Dim GridStr() As String '网格列信息(字符型)
Dim GridInt() As Integer '网格列信息(整型)
Dim Szzls As Integer '数组总列数(网格列数-1)
Private Sub CxbbGrid_AfterMoveColumn(ByVal Col As Long, Position As Long)
Dim i As Integer
With Me.CxbbGrid
ReDim sFieldValue(.Cols - 1)
For i = 0 To .Cols - 1
sFieldValue(i).FieldName = Trim(.TextMatrix(1, i))
Next i
End With
End Sub
Private Sub CxbbGrid_AfterSort(ByVal Col As Long, Order As Integer)
Dim i As Long
With Me.CxbbGrid
For i = .FixedRows To .Rows - 1
.TextMatrix(i, Qslz) = i - .FixedRows + 1
Next i
End With
End Sub
Private Sub Form_Resize() '根据窗体大小来调整网格,标题栏大小(Fixed)
On Error Resume Next
With CxbbGrid
.Width = Me.Width - 160
.Height = Me.Height - .Top - 400
End With
With Pic_Title
.Width = Me.Width - 160
End With
GsToolbar.Left = Me.Width - GsToolbar.Width - 140
With Me.PB_Proc
.Left = (Me.Width - .Width) / 2
.Top = Me.Height / 2
End With
End Sub
Private Sub Form_Load() '窗体装入
On Error GoTo 0
'调入打印页面设置窗体
ReportTitle = "年龄分析"
XtReportCode = "Rs_RsAgeFrm"
Load Dyymctbl
Me.Caption = ReportTitle
Me.Lab_Title = ReportTitle
'调整标题栏及网格、格式工具条位置(Fixed)
Pic_Title.Left = 40
Pic_Title.Top = SzToolbar.Top + SzToolbar.Height - 10
CxbbGrid.Left = Pic_Title.Left
CxbbGrid.Top = Pic_Title.Top + Pic_Title.Height + 20
'调 入 网 格(Fixed)
GridCode = "Rs_RsAgeFrm"
Call BzWgcsh(CxbbGrid, GridCode, GridInf(), GridBoolean(), GridInt(), GridStr())
Me.CxbbGrid.MergeCells = flexMergeNever
Qslz = GridInf(1)
Sjhgd = GridInf(2)
Sfxshjwg = GridInf(7)
Szzls = CxbbGrid.Cols - 1
iBeginCol = Val(GridInf(1))
'初始化变量
sSqlOrder = " order by Rs_BasicInfo.DeptCode "
Me.sSqlFrom = " from Rs_BasicInfo "
Me.sSqlWhereMe = " where Rs_BasicInfo.YnStop=0 "
Me.sSqlWhereMore = ""
Me.sSqlWhere = Me.sSqlWhereMe & Me.sSqlWhereMore
'编辑(新增、修改、删除)权限索引
Str_RightEdit = "Rs_An_RsAge_Edit"
End Sub
Private Sub Form_Unload(Cancel As Integer) '窗体卸载
'卸载打印页面设置窗体
Unload Dyymctbl
Security_Log "Rs_An_RsAge", Xtczybm, 2, False '用户退出时写上机日志
End Sub
Private Sub CxbbGrid_BeforeMoveColumn(ByVal Col As Long, Position As Long) '网格列发生移动时自动交换网格索引信息
Dim i As Integer
Dim iMax As Integer
Dim iMin As Integer
Dim iStep As Integer
'编码列不允许移动
If Col <= Qslz Then
Position = Col
Exit Sub
End If
'不允许列超过编码列
If Position <= Qslz Then
Position = Qslz + 1
End If
'移动数组
With Me.CxbbGrid
If .Cols <= Qslz + 1 Then
Exit Sub
End If
If Col = Position Then
Exit Sub
End If
Dim sFieldValueT As New CFieldValue
iStep = IIf(Col > Position, -1, 1)
CFieldValueCopy sFieldValue(Col - Qslz - 1), sFieldValueT
For i = Col + iStep - Qslz - 1 To Position - Qslz - 1 Step iStep
CFieldValueCopy sFieldValue(i), sFieldValue(i - iStep)
Next i
CFieldValueCopy sFieldValueT, sFieldValue(Position - Qslz - 1)
End With
End Sub
Private Sub SzToolbar_ButtonClick(ByVal Button As MSComctlLib.Button)
Select Case Button.Key
Case "ymsz" '页面设置
Dyymctbl.Show 1
Case "yl" '预 览
bbyl (True)
Case "dy" '打 印
bbyl (False)
Case "cx" '查 询
An_RsAgeFrmQuery.Show 1
Case "DingYi" '定 义
'判断用户是否有此功能执行权限,如有则写上机日志(进入)
If Not Security_Log(Str_RightEdit, Xtczybm, 1, True) Then
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -