| 1 |
tony |
37 |
object SelectDeptDlg: TSelectDeptDlg
|
| 2 |
|
|
Left = 677
|
| 3 |
|
|
Height = 449
|
| 4 |
|
|
Top = 296
|
| 5 |
|
|
Width = 485
|
| 6 |
|
|
BorderStyle = bsDialog
|
| 7 |
|
|
Caption = 'Select Department'
|
| 8 |
|
|
ClientHeight = 449
|
| 9 |
|
|
ClientWidth = 485
|
| 10 |
|
|
OnClose = FormClose
|
| 11 |
|
|
OnShow = FormShow
|
| 12 |
|
|
LCLVersion = '1.2.6.0'
|
| 13 |
|
|
object Label1: TLabel
|
| 14 |
|
|
Left = 16
|
| 15 |
|
|
Height = 15
|
| 16 |
|
|
Top = 16
|
| 17 |
|
|
Width = 79
|
| 18 |
|
|
Caption = 'Departments'
|
| 19 |
|
|
ParentColor = False
|
| 20 |
|
|
end
|
| 21 |
|
|
object DeptsTreeView: TIBTreeView
|
| 22 |
|
|
Left = 19
|
| 23 |
|
|
Height = 399
|
| 24 |
|
|
Top = 37
|
| 25 |
|
|
Width = 359
|
| 26 |
|
|
TextField = 'DEPARTMENT'
|
| 27 |
|
|
DataSource = DataSource1
|
| 28 |
|
|
DefaultItemHeight = 18
|
| 29 |
|
|
HasChildField = 'CHILDCOUNT'
|
| 30 |
|
|
KeyField = 'DEPT_NO'
|
| 31 |
|
|
ParentField = 'HEAD_DEPT'
|
| 32 |
|
|
ReadOnly = True
|
| 33 |
|
|
RelationName = 'A'
|
| 34 |
|
|
TabOrder = 0
|
| 35 |
|
|
OnDblClick = DeptsTreeViewDblClick
|
| 36 |
|
|
Options = [tvoAutoItemHeight, tvoHideSelection, tvoKeepCollapsedNodes, tvoReadOnly, tvoShowButtons, tvoShowLines, tvoShowRoot, tvoToolTips, tvoThemedDraw]
|
| 37 |
|
|
end
|
| 38 |
|
|
object Button1: TButton
|
| 39 |
|
|
Left = 394
|
| 40 |
|
|
Height = 30
|
| 41 |
|
|
Top = 37
|
| 42 |
|
|
Width = 75
|
| 43 |
|
|
Caption = 'OK'
|
| 44 |
|
|
Default = True
|
| 45 |
|
|
ModalResult = 1
|
| 46 |
|
|
TabOrder = 1
|
| 47 |
|
|
end
|
| 48 |
|
|
object Button2: TButton
|
| 49 |
|
|
Left = 394
|
| 50 |
|
|
Height = 30
|
| 51 |
|
|
Top = 72
|
| 52 |
|
|
Width = 75
|
| 53 |
|
|
Cancel = True
|
| 54 |
|
|
Caption = 'Cancel'
|
| 55 |
|
|
ModalResult = 2
|
| 56 |
|
|
TabOrder = 2
|
| 57 |
|
|
end
|
| 58 |
|
|
object Depts: TIBQuery
|
| 59 |
|
|
Database = Form1.IBDatabase1
|
| 60 |
|
|
Transaction = Form1.IBTransaction1
|
| 61 |
|
|
BufferChunks = 1000
|
| 62 |
|
|
CachedUpdates = False
|
| 63 |
|
|
GenerateParamNames = False
|
| 64 |
|
|
GeneratorField.ApplyOnEvent = gaeOnNewRecord
|
| 65 |
|
|
SQL.Strings = (
|
| 66 |
|
|
'Select A.DEPT_NO, A.DEPARTMENT, A.HEAD_DEPT,count(B.DEPT_NO)'
|
| 67 |
|
|
'as ChildCount '
|
| 68 |
|
|
'From DEPARTMENT A'
|
| 69 |
|
|
'Left Outer JOIN DEPARTMENT B '
|
| 70 |
|
|
' On B.HEAD_DEPT = A.DEPT_NO'
|
| 71 |
|
|
'Group By A.DEPT_NO, A.DEPARTMENT, A.HEAD_DEPT'
|
| 72 |
|
|
)
|
| 73 |
|
|
Params = <>
|
| 74 |
|
|
left = 432
|
| 75 |
|
|
top = 125
|
| 76 |
|
|
end
|
| 77 |
|
|
object DataSource1: TDataSource
|
| 78 |
|
|
DataSet = Depts
|
| 79 |
|
|
left = 392
|
| 80 |
|
|
top = 125
|
| 81 |
|
|
end
|
| 82 |
|
|
end
|
