📄 main_xjgl_xjtjform.~dfm
字号:
object main_xjgl_xjtj: Tmain_xjgl_xjtj
Left = 41
Top = 340
BorderIcons = []
BorderStyle = bsDialog
Caption = '学籍统计'
ClientHeight = 267
ClientWidth = 624
Color = clMenu
Font.Charset = GB2312_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = '宋体'
Font.Style = []
OldCreateOrder = False
Position = poScreenCenter
OnShow = FormShow
PixelsPerInch = 96
TextHeight = 13
object Bevel1: TBevel
Left = 0
Top = 0
Width = 624
Height = 267
Align = alClient
Style = bsRaised
end
object DecisionGrid1: TDecisionGrid
Left = 7
Top = 43
Width = 610
Height = 190
Options = [cgGridLines]
DefaultColWidth = 100
DefaultRowHeight = 20
CaptionColor = clActiveCaption
CaptionFont.Charset = GB2312_CHARSET
CaptionFont.Color = clCaptionText
CaptionFont.Height = -13
CaptionFont.Name = '宋体'
CaptionFont.Style = [fsBold]
DataColor = clInfoBk
DataSumColor = clTeal
DataFont.Charset = DEFAULT_CHARSET
DataFont.Color = clWindowText
DataFont.Height = -11
DataFont.Name = 'MS Sans Serif'
DataFont.Style = []
LabelFont.Charset = GB2312_CHARSET
LabelFont.Color = clWindowText
LabelFont.Height = -13
LabelFont.Name = '宋体'
LabelFont.Style = [fsBold, fsItalic]
LabelColor = clBtnFace
LabelSumColor = clTeal
DecisionSource = DecisionSource1
Dimensions = <
item
FieldName = '所在系名'
Color = clNone
Alignment = taCenter
Subtotals = True
end
item
FieldName = '所在年级'
Color = clNone
Alignment = taCenter
Subtotals = True
end
item
FieldName = '所在班级'
Color = clNone
Alignment = taCenter
Subtotals = True
end
item
FieldName = '性别'
Color = clNone
Alignment = taCenter
Subtotals = True
end
item
FieldName = '民族'
Color = clNone
Alignment = taCenter
Subtotals = True
end
item
FieldName = '政治面貌'
Color = clNone
Alignment = taCenter
Subtotals = True
end
item
FieldName = '所学专业'
Color = clNone
Alignment = taCenter
Subtotals = True
end
item
FieldName = '按性别统计'
Color = clNone
Alignment = taCenter
Subtotals = True
end
item
FieldName = '按民族统计'
Color = clNone
Alignment = taCenter
Subtotals = True
end
item
FieldName = '按政治面貌统计'
Color = clNone
Alignment = taCenter
Subtotals = True
end
item
FieldName = '按 所学专业统计'
Color = clNone
Alignment = taCenter
Subtotals = True
end>
Totals = True
ShowCubeEditor = False
Color = clMenu
GridLineWidth = 1
GridLineColor = clWindowText
TabOrder = 0
end
object DecisionPivot1: TDecisionPivot
Left = 9
Top = 5
Width = 608
Height = 28
ButtonAutoSize = True
DecisionSource = DecisionSource1
GroupLayout = xtHorizontal
Groups = [xtRows, xtColumns, xtSummaries]
ButtonSpacing = 0
ButtonWidth = 64
ButtonHeight = 24
GroupSpacing = 10
BorderWidth = 0
BorderStyle = bsNone
Font.Charset = GB2312_CHARSET
Font.Color = clWindowText
Font.Height = -13
Font.Name = '宋体'
Font.Style = [fsBold]
Color = clMenu
Ctl3D = True
ParentCtl3D = False
ParentFont = False
TabOrder = 1
end
object BitBtn1: TBitBtn
Left = 528
Top = 232
Width = 75
Height = 25
Caption = '&关闭'
TabOrder = 2
OnClick = BitBtn1Click
Kind = bkClose
end
object DecisionCube1: TDecisionCube
DataSet = DecisionQuery1
DimensionMap = <
item
ActiveFlag = diAsNeeded
FieldType = ftString
Fieldname = '所在系名'
BaseName = '"xj.DB".所在系名'
Name = '所在系名'
DerivedFrom = -1
DimensionType = dimDimension
BinType = binNone
ValueCount = 3
Active = True
end
item
ActiveFlag = diAsNeeded
FieldType = ftString
Fieldname = '所在年级'
BaseName = '"xj.DB".所在年级'
Name = '所在年级'
DerivedFrom = -1
DimensionType = dimDimension
BinType = binNone
ValueCount = 2
Active = True
end
item
ActiveFlag = diAsNeeded
FieldType = ftString
Fieldname = '所在班级'
BaseName = '"xj.DB".所在班级'
Name = '所在班级'
DerivedFrom = -1
DimensionType = dimDimension
BinType = binNone
ValueCount = 4
Active = True
end
item
ActiveFlag = diAsNeeded
FieldType = ftString
Fieldname = '性别'
BaseName = '"xj.DB".性别'
Name = '性别'
DerivedFrom = -1
DimensionType = dimDimension
BinType = binNone
ValueCount = 2
Active = True
end
item
ActiveFlag = diAsNeeded
FieldType = ftString
Fieldname = '民族'
BaseName = '"xj.DB".民族'
Name = '民族'
DerivedFrom = -1
DimensionType = dimDimension
BinType = binNone
ValueCount = 2
Active = True
end
item
ActiveFlag = diAsNeeded
FieldType = ftString
Fieldname = '政治面貌'
BaseName = '"xj.DB".政治面貌'
Name = '政治面貌'
DerivedFrom = -1
DimensionType = dimDimension
BinType = binNone
ValueCount = 3
Active = True
end
item
ActiveFlag = diAsNeeded
FieldType = ftString
Fieldname = '所学专业'
BaseName = '"xj.DB".所学专业'
Name = '所学专业'
DerivedFrom = -1
DimensionType = dimDimension
BinType = binNone
ValueCount = 3
Active = True
end
item
ActiveFlag = diAsNeeded
FieldType = ftInteger
Fieldname = 'COUNT OF 性别'
BaseName = '"xj.DB".性别'
Name = '按性别统计'
DerivedFrom = -1
DimensionType = dimCount
BinType = binNone
ValueCount = -1
Active = True
end
item
ActiveFlag = diAsNeeded
FieldType = ftInteger
Fieldname = 'COUNT OF 民族'
BaseName = '"xj.DB".民族'
Name = '按民族统计'
DerivedFrom = -1
DimensionType = dimCount
BinType = binNone
ValueCount = -1
Active = True
end
item
ActiveFlag = diAsNeeded
FieldType = ftInteger
Fieldname = 'COUNT OF 政治面貌'
BaseName = '"xj.DB".政治面貌'
Name = '按政治面貌统计'
DerivedFrom = -1
DimensionType = dimCount
BinType = binNone
ValueCount = -1
Active = True
end
item
ActiveFlag = diAsNeeded
FieldType = ftInteger
Fieldname = 'COUNT OF 所学专业'
BaseName = '"xj.DB".所学专业'
Name = '按 所学专业统计'
DerivedFrom = -1
DimensionType = dimCount
BinType = binNone
ValueCount = -1
Active = True
end>
ShowProgressDialog = True
MaxDimensions = 7
MaxSummaries = 10
MaxCells = 0
Left = 440
Top = 64
end
object DecisionQuery1: TDecisionQuery
DatabaseName = 'JFXT'
SQL.Strings = (
'SELECT 所在系名, 所在年级, 所在班级, 性别, 民族, 政治面貌, 所学' +
'专业, COUNT( 性别 ), COUNT( 民族 ), COUNT( 政治面貌 ), COUNT( 所' +
'学专业 )'
'FROM "xj.DB"'
'GROUP BY 所在系名, 所在年级, 所在班级, 性别, 民族, 政治面貌, 所' +
'学专业')
Left = 504
Top = 72
end
object DecisionSource1: TDecisionSource
DecisionCube = DecisionCube1
ControlType = xtCheck
SparseRows = False
SparseCols = False
Left = 448
Top = 160
DimensionCount = 7
SummaryCount = 4
CurrentSummary = 0
SparseRows = False
SparseCols = False
DimensionInfo = (
1
0
1
0
0
1
-1
2
1
-1
2
-1
2
0
0
1
-1
2
2
0
1
-1
2
3
0
1
-1
2
4
-1
1
-1
2
5
-1)
end
end
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -