这是一个功能齐全的,代码完整的ERP企业信息管理系统,现在上传和大家分享
源代码在线查看： sys300_01.dfm.svn-base
object Sys300_01Form: TSys300_01Form
Left = -4
Top = -4
Width = 808
Height = 580
Caption = #19978#26426#26085#24535#26126#32454
Color = clBtnFace
Font.Charset = DEFAULT_CHARSET
Font.Color = clWindowText
Font.Height = -12
Font.Name = #23435#20307
Font.Pitch = fpFixed
Font.Style = []
KeyPreview = True
OldCreateOrder = False
Position = poMainFormCenter
OnClose = FormClose
OnCreate = FormCreate
OnKeyDown = FormKeyDown
PixelsPerInch = 96
TextHeight = 12
object Panel1: TPanel
Left = 0
Top = 43
Width = 800
Height = 37
Align = alTop
BevelInner = bvRaised
BevelOuter = bvLowered
TabOrder = 0
DesignSize = (
800
37)
object Image1: TImage
Left = 2
Top = 2
Width = 796
Height = 33
Align = alClient
Stretch = True
end
object lblUser: TLabel
Left = 218
Top = 14
Width = 48
Height = 12
Anchors = [akTop, akRight]
Caption = #29992#25143#21517#31216
Transparent = True
end
object lblDate: TLabel
Left = 410
Top = 14
Width = 48
Height = 12
Anchors = [akTop, akRight]
Caption = #25805#20316#26085#26399
Transparent = True
end
object sbSearch: TSpeedButton
Left = 728
Top = 8
Width = 57
Height = 22
Anchors = [akTop, akRight]
Caption = #26597#35810
OnClick = sbSearchClick
end
object cbUser: TComboBox
Left = 274
Top = 9
Width = 121
Height = 20
Style = csDropDownList
Anchors = [akTop, akRight]
ItemHeight = 12
TabOrder = 0
OnChange = cbUserChange
end
object edtFromDate: TwwDBDateTimePicker
Left = 466
Top = 9
Width = 121
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 = []
CalendarAttributes.PopupYearOptions.ShowEditYear = True
Epoch = 1950
ShowButton = True
TabOrder = 1
DisplayFormat = 'yyyy-mm-dd'
end
object edtToDate: TwwDBDateTimePicker
Left = 594
Top = 9
Width = 121
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 = []
CalendarAttributes.PopupYearOptions.ShowEditYear = True
Epoch = 1950
ShowButton = True
TabOrder = 2
DisplayFormat = 'yyyy-mm-dd'
end
end
object CoolBar1: TCoolBar
Left = 0
Top = 0
Width = 800
Height = 43
AutoSize = True
Bands = <
item
Control = ToolBar2
ImageIndex = -1
MinHeight = 39
Width = 796
end>
object ToolBar2: TToolBar
Left = 9
Top = 0
Width = 783
Height = 39
AutoSize = True
ButtonHeight = 39
ButtonWidth = 31
Caption = 'ToolBar2'
EdgeBorders = []
Flat = True
Images = SYSDM.imgBtn
ParentShowHint = False
ShowCaptions = True
ShowHint = True
TabOrder = 0
object tlbFirst: TToolButton
Left = 0
Top = 0
Action = ActFirst
AutoSize = True
end
object tlbPrior: TToolButton
Left = 35
Top = 0
Action = ActPrior
AutoSize = True
end
object tlbNext: TToolButton
Left = 70
Top = 0
Action = ActNext
AutoSize = True
end
object tlbLast: TToolButton
Left = 105
Top = 0
Action = ActLast
AutoSize = True
end
object ToolButton1: TToolButton
Left = 140
Top = 0
Width = 8
Caption = 'ToolButton1'
ImageIndex = 13
Style = tbsSeparator
end
object ToolButton2: TToolButton
Left = 148
Top = 0
Action = ActDelete
AutoSize = True
end
object ToolButton3: TToolButton
Left = 183
Top = 0
Width = 8
Caption = 'ToolButton3'
ImageIndex = 16
Style = tbsSeparator
end
object tlbRefresh: TToolButton
Left = 191
Top = 0
Action = ActRefresh
AutoSize = True
end
object tlbLocate: TToolButton
Left = 226
Top = 0
Action = ActLocate
AutoSize = True
end
object ToolButton5: TToolButton
Left = 261
Top = 0
Action = ActSearch
AutoSize = True
end
object tlbPrint: TToolButton
Left = 296
Top = 0
Action = ActPrint
AutoSize = True
DropdownMenu = PopupMenu1
Style = tbsDropDown
end
object ToolButton6: TToolButton
Left = 344
Top = 0
Width = 8
Caption = 'ToolButton6'
ImageIndex = 16
Style = tbsSeparator
end
object tlbExit: TToolButton
Left = 352
Top = 0
Action = ActExit
AutoSize = True
end
end
end
object ScrollBox1: TScrollBox
Left = 0
Top = 80
Width = 800
Height = 473
Align = alClient
TabOrder = 2
object dxDBGrid1: TdxDBGrid
Left = 0
Top = 0
Width = 796
Height = 469
Bands = <
item
end>
DefaultLayout = True
HeaderPanelRowCount = 1
KeyField = 'S500A_002'
ShowGroupPanel = True
SummaryGroups =
SummarySeparator = ', '
Align = alClient
BorderStyle = bsNone
TabOrder = 0
DataSource = dsSys300
Filter.Criteria = {00000000}
HeaderColor = 15262169
HideFocusRect = True
LookAndFeel = lfUltraFlat
OptionsDB = [edgoCancelOnExit, edgoCanNavigation, edgoConfirmDelete, edgoUseBookmarks]
OptionsView = [edgoBandHeaderWidth, edgoIndicator, edgoUseBitmap]
OnBackgroundDrawEvent = dxDBGrid1BackgroundDrawEvent
object dxDBGrid1S500A_002: TdxDBGridMaskColumn
DisableEditor = True
HeaderAlignment = taCenter
BandIndex = 0
RowIndex = 0
FieldName = 'S500A_002'
end
object dxDBGrid1S500D_001: TdxDBGridMaskColumn
DisableEditor = True
HeaderAlignment = taCenter
Width = 88
BandIndex = 0
RowIndex = 0
FieldName = 'S500D_001'
end
object dxDBGrid1Program: TdxDBGridLookupColumn
DisableEditor = True
HeaderAlignment = taCenter
Width = 237
BandIndex = 0
RowIndex = 0
FieldName = 'Program'
end
object dxDBGrid1S300_004: TdxDBGridDateColumn
DisableEditor = True
HeaderAlignment = taCenter
Width = 146
BandIndex = 0
RowIndex = 0
FieldName = 'S300_004'
end
object dxDBGrid1S300_005: TdxDBGridMaskColumn
DisableEditor = True
HeaderAlignment = taCenter
Width = 119
BandIndex = 0
RowIndex = 0
FieldName = 'S300_005'
end
end
end
object dsSys300: TDataSource
DataSet = qrySys300
Left = 56
Top = 136
end
object qrySys300: TADOQuery
CacheSize = 1000
Connection = SYSDM.ADOC
CursorType = ctStatic
AfterScroll = qrySys300AfterScroll
Parameters =
SQL.Strings = (
'select S500A_002,S500D_001,S300_004,S300_005 '
'from SYS300,SYS500D,SYS500A '
'where S300_002=S500D_011 and S300_001=S500A_001')
Left = 56
Top = 192
object qrySys300S500A_002: TWideStringField
DisplayLabel = #29992#25142#21517#31281
FieldName = 'S500A_002'
end
object qrySys300S500D_001: TStringField
DisplayLabel = #31243#24207#32534#21495
FieldName = 'S500D_001'
Size = 10
end
object qrySys300Program: TStringField
DisplayLabel = #31243#24207#21517#31216
FieldKind = fkLookup
FieldName = 'Program'
LookupDataSet = SYSDM.qryProgram
LookupKeyFields = 'LangID'
LookupResultField = 'Name'
KeyFields = 'S500D_001'
Size = 50
Lookup = True
end
object qrySys300S300_004: TDateTimeField
DisplayLabel = #25805#20316#26085#26399
FieldName = 'S300_004'
end
object qrySys300S300_005: TStringField
DisplayLabel = #25805#20316#35828#26126
FieldName = 'S300_005'
Size = 50
end
end
object qrySys500A: TADOQuery
CacheSize = 1000
Connection = SYSDM.ADOC
Parameters =
SQL.Strings = (
'select * from SYS500A')
Left = 456
Top = 48
end
object PopupMenu1: TPopupMenu
Left = 512
Top = 8
object mmiPrint: TMenuItem
Action = ActPrint
end
object mmiExport: TMenuItem
Action = ActExport
end
end
object ActionList1: TActionList
Images = SYSDM.imgBtn
Left = 448
Top = 8
object ActFirst: TAction
Caption = #26368#21069
Hint = #31227#21040#31532#19968#26465#35760#24405
ImageIndex = 0
ShortCut = 32838
OnExecute = ActFirstExecute
end
object ActPrior: TAction
Caption = #19978#31227
Hint = #31227#21040#19978#19968#26465#35760#24405
ImageIndex = 1
ShortCut = 32848
OnExecute = ActPriorExecute
end
object ActNext: TAction
Caption = #19979#31227
Hint = #31227#21040#19979#19968#26465#35760#24405
ImageIndex = 2
ShortCut = 32846
OnExecute = ActNextExecute
end
object ActLast: TAction
Caption = #26368#21518
Hint = #31227#21040#26368#21518#19968#26465#35760#24405
ImageIndex = 3
ShortCut = 32844
OnExecute = ActLastExecute
end
object ActDelete: TAction
Caption = #28165#31354
Hint = #28165#38500#25152#26377#35760#24405
ImageIndex = 6
ShortCut = 32836
OnExecute = ActDeleteExecute
end
object ActRefresh: TAction
Caption = #21047#26032
Hint = #21462#24471#26368#26032#30340#25968#25454
ImageIndex = 9
ShortCut = 32850
OnExecute = ActRefreshExecute
end
object ActLocate: TAction
Caption = #26597#25214
Hint = #24555#36895#23450#20301#35760#24405
ImageIndex = 10
ShortCut = 32847
OnExecute = ActLocateExecute
end
object ActSearch: TAction
Caption = #26597#35810
Hint = #25353#26465#20214#26597#35810#25968#25454
ImageIndex = 11
ShortCut = 32849
OnExecute = ActSearchExecute
end
object ActPrint: TAction
Caption = #25171#21360
Hint = #23558#25968#25454#25171#21360#20986#26469
ImageIndex = 12
ShortCut = 32848
OnExecute = ActPrintExecute
end
object ActExport: TAction
Caption = #23548#20986#21040'Excel'
Hint = #23548#20986#21040'Excel'#25991#20214#20013
ShortCut = 32852
OnExecute = ActExportExecute
end
object ActExit: TAction
Caption = #36864#20986
Hint = #20851#38381#24403#21069#31383#21475
ImageIndex = 15
ShortCut = 32856
OnExecute = ActExitExecute
end
end
end
