?? ad_qry_totaldepreciationsubject.dfm
字號:
inherited Frm_Ad_Qry_TotalDepreciationSubject: TFrm_Ad_Qry_TotalDepreciationSubject
Left = 3
Top = 73
Caption = '折舊計提匯總表_按費用科目'
ClientHeight = 444
ClientWidth = 780
PixelsPerInch = 96
TextHeight = 12
inherited ControlBar: TControlBar
Width = 780
inherited ToolBar: TToolBar
inherited TlBtn_Sum: TToolButton
Action = Act_Delete
end
end
end
inherited Pnl_Title: TPanel
Width = 780
Caption = '折舊計提匯總表_按費用科目'
inherited Image2: TImage
Width = 780
end
end
inherited Pnl_Head: TPanel
Width = 780
inherited Image1: TImage
Width = 780
end
inherited Lbl_Order: TLabel
Left = 75
Width = 48
Caption = '科目代碼'
end
end
inherited Pnl_Hint: TPanel
Top = 418
Width = 780
inherited Image4: TImage
Width = 780
end
end
inherited Pnl_Body: TPanel
Width = 780
Height = 321
inherited Image3: TImage
Width = 780
Height = 321
end
inherited DBGridEh: TDBGridEh
Width = 780
Height = 321
FooterRowCount = 1
SumList.Active = True
Columns = <
Item
FieldName = 'KmFlag'
PickList.Strings = ()
Title.Alignment = taCenter
Title.Caption = '費用科目標識'
Width = 300
Footer.Color = clYellow
Footer.ValueType = fvtStaticText
Footer.Value = '合計'
KeyList.Strings = ()
end
Item
FieldName = 'SumDepreciation'
PickList.Strings = ()
Title.Alignment = taCenter
Title.Caption = '折舊額'
Width = 150
Footer.Alignment = tArightJustify
Footer.Color = clYellow
Footer.ValueType = fvtSum
Footer.FieldName = 'SumDepreciation'
KeyList.Strings = ()
end
Item
FieldName = 'SDepreciation'
PickList.Strings = ()
Title.Alignment = taCenter
Title.Caption = '占折舊總額(%)'
Width = 150
Footer.Alignment = tArightJustify
Footer.Color = clYellow
Footer.ValueType = fvtSum
Footer.FieldName = 'SDepreciation'
KeyList.Strings = ()
end>
end
end
inherited AdoQry_Tmp: TAdoQuery
Left = 445
Top = 283
end
inherited ActionList: TActionList
Left = 440
Top = 200
inherited Act_Delete: TAction
Enabled = False
Visible = False
end
end
inherited AdoQry_Main: TAdoQuery
ConnectionString =
'Provider=SQLOLEDB.1;Password=mdrcmrm;Persist Security Info=True;' +
'User ID=mdrcmrm;Initial Catalog=Mrpii_Standard;Data Source=192.1' +
'68.0.151;Use procedure for Prepare=1;Auto Translate=True;Packet ' +
'Size=4096;Workstation ID=XYB'
CurSorType = ctStatic
SQL.Strings = (
'select Ad_Depreciation_Subject.KMCode,Gl_AccountSubject.KmName,A' +
'D_Depreciation_Subject.KMCode+'#39' '#39'+Gl_AccountSubject.KmName KmFla' +
'g,Sum(Depreciation) SumDepreciation '
' ,Sum(Depreciation)/(Select Sum(Depreciation) from Ad_Depreciati' +
'on_Subject Where DepreciationMonth Between '#39'2001.01'#39' And '#39'2001.' +
'01'#39' And KmCode Between '#39'01'#39' And '#39'01'#39' ) SDepreciation '
' from Ad_Depreciation_Subject,Gl_AccountSubject '
' Where Ad_Depreciation_Subject.KmCode Between '#39'01'#39' And '#39'01'#39
' And DepreciationMonth Between '#39'2001.01'#39' And '#39'2001.01'#39
' And Ad_Depreciation_Subject.KmCode=Gl_AccountSubject.KmCode '
' Group By Ad_Depreciation_Subject.KmCode,Gl_AccountSubject.KmNam' +
'e')
Left = 312
Top = 241
end
inherited DataSource: TDataSource
Left = 368
Top = 257
end
inherited PopuPmenu: TPopuPmenu
Left = 232
Top = 225
end
end
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -