一个用Delphi开发的ERP软件
源代码在线查看： tas435_01.dfm.svn-base
inherited Tas435_01Form: TTas435_01Form
Caption = '工单完成分析'
PixelsPerInch = 96
TextHeight = 12
object Splitter1: TSplitter [0]
Left = 0
Top = 262
Width = 800
Height = 3
Cursor = crVSplit
Align = alBottom
end
inherited Panel1: TPanel
object lblDate: TLabel
Left = 277
Top = 12
Width = 48
Height = 12
Anchors = [akTop, akRight]
Caption = '起止日期'
Transparent = True
end
object lblType: TLabel
Left = 565
Top = 12
Width = 24
Height = 12
Anchors = [akTop, akRight]
Caption = '类型'
Transparent = True
end
object sbSearch: TSpeedButton
Left = 722
Top = 8
Width = 57
Height = 22
Anchors = [akTop, akRight]
Caption = '查询'
OnClick = sbSearchClick
end
object edtFromDate: TwwDBDateTimePicker
Left = 333
Top = 8
Width = 105
Height = 20
Anchors = [akTop, akRight]
CalendarAttributes.Font.Charset = DEFAULT_CHARSET
CalendarAttributes.Font.Color = clWindowText
CalendarAttributes.Font.Height = -11
CalendarAttributes.Font.Name = 'MS Sans Serif'
CalendarAttributes.Font.Style = []
Epoch = 1950
ShowButton = True
TabOrder = 0
end
object edtToDate: TwwDBDateTimePicker
Left = 445
Top = 8
Width = 105
Height = 20
Anchors = [akTop, akRight]
CalendarAttributes.Font.Charset = DEFAULT_CHARSET
CalendarAttributes.Font.Color = clWindowText
CalendarAttributes.Font.Height = -11
CalendarAttributes.Font.Name = 'MS Sans Serif'
CalendarAttributes.Font.Style = []
Epoch = 1950
ShowButton = True
TabOrder = 1
end
object cbType: TComboBox
Left = 597
Top = 8
Width = 108
Height = 20
Style = csDropDownList
Anchors = [akTop, akRight]
ItemHeight = 12
TabOrder = 2
Items.Strings = (
'按日'
'按周'
'按月')
end
end
inherited ScrollBox2: TScrollBox
Height = 182
inherited dxDBTreeList1: TdxDBTreeList
Height = 178
KeyField = 'FNo'
ParentField = 'FParent'
PopupMenu = PopupMenu1
object dxDBTreeList1FName: TdxDBTreeListMaskColumn
DisableEditor = True
HeaderAlignment = taCenter
Width = 225
BandIndex = 0
RowIndex = 0
FieldName = 'FName'
end
object dxDBTreeList1FTotal1: TdxDBTreeListMaskColumn
DisableEditor = True
HeaderAlignment = taCenter
BandIndex = 0
RowIndex = 0
FieldName = 'FTotal1'
SummaryFooterType = cstSum
SummaryFooterFormat = '0'
OnDrawSummaryFooter = dxDBTreeList1FTotal1DrawSummaryFooter
end
object dxDBTreeList1FTotal2: TdxDBTreeListMaskColumn
DisableEditor = True
HeaderAlignment = taCenter
BandIndex = 0
RowIndex = 0
FieldName = 'FTotal2'
SummaryFooterType = cstSum
SummaryFooterFormat = '0'
OnDrawSummaryFooter = dxDBTreeList1FTotal2DrawSummaryFooter
end
object dxDBTreeList1FTotal3: TdxDBTreeListMaskColumn
DisableEditor = True
HeaderAlignment = taCenter
BandIndex = 0
RowIndex = 0
FieldName = 'FTotal3'
SummaryFooterType = cstSum
SummaryFooterFormat = '0'
OnDrawSummaryFooter = dxDBTreeList1FTotal3DrawSummaryFooter
end
object dxDBTreeList1FTotal4: TdxDBTreeListMaskColumn
DisableEditor = True
HeaderAlignment = taCenter
BandIndex = 0
RowIndex = 0
FieldName = 'FTotal4'
SummaryFooterType = cstSum
SummaryFooterFormat = '0'
OnDrawSummaryFooter = dxDBTreeList1FTotal4DrawSummaryFooter
end
object dxDBTreeList1FTotal5: TdxDBTreeListMaskColumn
DisableEditor = True
HeaderAlignment = taCenter
BandIndex = 0
RowIndex = 0
FieldName = 'FTotal5'
SummaryFooterType = cstSum
SummaryFooterFormat = '0'
OnDrawSummaryFooter = dxDBTreeList1FTotal5DrawSummaryFooter
end
object dxDBTreeList1FTotal6: TdxDBTreeListMaskColumn
DisableEditor = True
HeaderAlignment = taCenter
BandIndex = 0
RowIndex = 0
FieldName = 'FTotal6'
SummaryFooterType = cstSum
SummaryFooterFormat = '0'
OnDrawSummaryFooter = dxDBTreeList1FTotal6DrawSummaryFooter
end
object dxDBTreeList1FTotal: TdxDBTreeListMaskColumn
DisableEditor = True
HeaderAlignment = taCenter
BandIndex = 0
RowIndex = 0
FieldName = 'FTotal'
SummaryFooterType = cstSum
SummaryFooterFormat = '0'
OnDrawSummaryFooter = dxDBTreeList1FTotalDrawSummaryFooter
end
end
end
object Panel2: TPanel [4]
Left = 0
Top = 265
Width = 800
Height = 288
Align = alBottom
BevelOuter = bvNone
TabOrder = 3
object Splitter2: TSplitter
Left = 373
Top = 0
Width = 3
Height = 288
Cursor = crHSplit
Align = alRight
end
object DBChart1: TDBChart
Left = 0
Top = 0
Width = 373
Height = 288
BackWall.Brush.Color = clWhite
BackWall.Brush.Style = bsClear
Title.Text.Strings = (
' ')
Align = alClient
BevelOuter = bvLowered
TabOrder = 0
object Series1: TBarSeries
Marks.ArrowLength = 20
Marks.Style = smsPercent
Marks.Visible = True
DataSource = ADODataSet2
SeriesColor = clRed
ShowInLegend = False
XLabelsSource = 'FDays'
XValues.DateTime = False
XValues.Name = 'X'
XValues.Multiplier = 1
XValues.Order = loAscending
YValues.DateTime = False
YValues.Name = 'Bar'
YValues.Multiplier = 1
YValues.Order = loNone
YValues.ValueSource = 'FTotal'
end
end
object DBChart2: TDBChart
Left = 376
Top = 0
Width = 424
Height = 288
BackWall.Brush.Color = clWhite
BackWall.Brush.Style = bsClear
Title.Text.Strings = (
' ')
Align = alRight
BevelOuter = bvLowered
TabOrder = 1
object Series2: TBarSeries
Marks.ArrowLength = 20
Marks.Style = smsPercent
Marks.Visible = True
DataSource = ADODataSet3
SeriesColor = clGreen
ShowInLegend = False
XLabelsSource = 'FName'
XValues.DateTime = False
XValues.Name = 'X'
XValues.Multiplier = 1
XValues.Order = loAscending
YValues.DateTime = False
YValues.Name = 'Bar'
YValues.Multiplier = 1
YValues.Order = loNone
YValues.ValueSource = 'FSum'
end
end
end
inherited ActionList1: TActionList
object ActOpen: TAction
Caption = '查看(&N)'
ShortCut = 16397
OnExecute = ActOpenExecute
end
end
inherited ADODataSet1: TADODataSet
CursorType = ctStatic
LockType = ltBatchOptimistic
object ADODataSet1FNo: TIntegerField
FieldName = 'FNo'
Visible = False
end
object ADODataSet1FName: TStringField
DisplayLabel = '任务类别'
FieldName = 'FName'
Size = 50
end
object ADODataSet1FParent: TIntegerField
FieldName = 'FParent'
Visible = False
end
object ADODataSet1FTotal1: TIntegerField
DisplayLabel = '一天'
FieldName = 'FTotal1'
end
object ADODataSet1FTotal2: TIntegerField
DisplayLabel = '二天'
FieldName = 'FTotal2'
end
object ADODataSet1FTotal3: TIntegerField
DisplayLabel = '三天'
FieldName = 'FTotal3'
end
object ADODataSet1FTotal4: TIntegerField
DisplayLabel = '四天'
FieldName = 'FTotal4'
end
object ADODataSet1FTotal5: TIntegerField
DisplayLabel = '五天'
FieldName = 'FTotal5'
end
object ADODataSet1FTotal6: TIntegerField
DisplayLabel = '超过五天'
FieldName = 'FTotal6'
end
object ADODataSet1FTotal: TIntegerField
DisplayLabel = '小计'
FieldName = 'FTotal'
end
end
object PopupMenu1: TPopupMenu
Left = 72
Top = 216
object N1: TMenuItem
Action = ActOpen
end
object N2: TMenuItem
Caption = '-'
end
object N4: TMenuItem
Action = ActLocate
end
object N5: TMenuItem
Action = ActSearch
end
end
object ADOQuery1: TADOQuery
Connection = SYSDM.ADOC
CursorType = ctStatic
Parameters =
SQL.Strings = (
'select count(T510_001) as FTotal,T100_001,T100_002,T100_003,T510' +
'_013 as FDays'
'from TAS510,TAS100'
'where T510_004=T100_001'
' and T510_003=3 group by T100_001,T100_002,T100_003,T510_013')
Left = 336
Top = 144
end
object ADODataSet2: TADODataSet
Connection = SYSDM.ADOC
CursorType = ctStatic
LockType = ltBatchOptimistic
FieldDefs = <
item
Name = 'FDays'
DataType = ftString
Size = 20
end
item
Name = 'FTotal'
Attributes = [faFixed]
DataType = ftInteger
end>
Parameters =
StoreDefs = True
Left = 80
Top = 392
end
object ADODataSet3: TADODataSet
Connection = SYSDM.ADOC
CursorType = ctStatic
LockType = ltBatchOptimistic
FieldDefs = <
item
Name = 'FName'
DataType = ftString
Size = 50
end
item
Name = 'FSum'
Attributes = [faFixed]
DataType = ftInteger
end>
Parameters =
StoreDefs = True
Left = 432
Top = 424
end
end
