DelphiCS/uDept.dfm at master · devgearedu/DelphiCS · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
object DeptForm: TDeptForm
  Left = 0
  Top = 0
  Caption = #48512#49436#44288#47532
  ClientHeight = 415
  ClientWidth = 478
  Color = clBtnFace
  Font.Charset = DEFAULT_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Tahoma'
  Font.Style = []
  OldCreateOrder = False
  OnClose = FormClose
  OnCreate = FormCreate
  DesignSize = (
    478
    415)
  PixelsPerInch = 96
  TextHeight = 13
  object Label4: TLabel
    Left = 136
    Top = 208
    Width = 31
    Height = 13
    Caption = 'Label4'
  end
  object DBNavigator1: TDBNavigator
    Left = 8
    Top = 8
    Width = 410
    Height = 49
    DataSource = dm.DeptSource
    Anchors = [akLeft, akTop, akRight]
    TabOrder = 0
  end
  object DBGrid1: TDBGrid
    Left = 8
    Top = 72
    Width = 456
    Height = 113
    Anchors = [akLeft, akTop, akRight]
    DataSource = dm.DeptSource
    Options = [dgEditing, dgAlwaysShowEditor, dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgConfirmDelete, dgCancelOnExit, dgTitleClick, dgTitleHotTrack]
    TabOrder = 1
    TitleFont.Charset = DEFAULT_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'Tahoma'
    TitleFont.Style = []
  end
  object PageControl1: TPageControl
    Left = 8
    Top = 200
    Width = 462
    Height = 207
    ActivePage = TabSheet2
    Anchors = [akLeft, akTop, akRight, akBottom]
    TabOrder = 2
    object TabSheet1: TTabSheet
      Caption = #49345#49464#51312#54924
      object DBGrid2: TDBGrid
        Left = 0
        Top = 0
        Width = 454
        Height = 179
        Align = alClient
        Options = [dgEditing, dgAlwaysShowEditor, dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgConfirmDelete, dgCancelOnExit, dgTitleClick, dgTitleHotTrack]
        TabOrder = 0
        TitleFont.Charset = DEFAULT_CHARSET
        TitleFont.Color = clWindowText
        TitleFont.Height = -11
        TitleFont.Name = 'Tahoma'
        TitleFont.Style = []
      end
    end
    object TabSheet2: TTabSheet
      Caption = #51064#50896#49688
      ImageIndex = 1
      object StringGrid1: TStringGrid
        Left = 0
        Top = 0
        Width = 454
        Height = 179
        Align = alClient
        ColCount = 3
        DrawingStyle = gdsClassic
        Options = [goFixedVertLine, goFixedHorzLine, goVertLine, goHorzLine, goRangeSelect, goRowSelect]
        TabOrder = 0
        OnDrawCell = StringGrid1DrawCell
        ExplicitTop = 3
      end
    end
    object TabSheet3: TTabSheet
      Caption = #46321#47197'('#51200#51109#54532#47196#49884#51200')'
      ImageIndex = 2
      object Label1: TLabel
        Left = 64
        Top = 32
        Width = 44
        Height = 13
        Caption = #48512#49436#53076#46300
      end
      object Label2: TLabel
        Left = 64
        Top = 64
        Width = 33
        Height = 13
        Caption = #48512#49436#47749
      end
      object Label3: TLabel
        Left = 64
        Top = 104
        Width = 22
        Height = 13
        Caption = #54016#47749
      end
      object Edit1: TEdit
        Left = 136
        Top = 24
        Width = 121
        Height = 21
        MaxLength = 4
        TabOrder = 0
        OnChange = Edit1Change
      end
      object Edit2: TEdit
        Left = 136
        Top = 59
        Width = 121
        Height = 21
        MaxLength = 6
        TabOrder = 1
        OnChange = Edit1Change
      end
      object Edit3: TEdit
        Left = 136
        Top = 96
        Width = 121
        Height = 21
        MaxLength = 8
        TabOrder = 2
        OnChange = Edit1Change
      end
      object Button1: TButton
        Left = 272
        Top = 72
        Width = 153
        Height = 49
        Caption = #46321#47197
        TabOrder = 3
        OnClick = Button1Click
      end
    end
    object TabSheet4: TTabSheet
      Caption = #49828#53944#47553#44536#47532#46300'('#52404#53356#48149#49828')'
      ImageIndex = 3
      object StringGrid2: TStringGrid
        Left = 0
        Top = 0
        Width = 454
        Height = 179
        Align = alClient
        TabOrder = 0
      end
    end
  end
  object Button2: TButton
    Left = 424
    Top = 8
    Width = 46
    Height = 49
    Anchors = [akLeft, akTop, akRight]
    Caption = #50641#49472#47196
    TabOrder = 3
    OnClick = Button2Click
  end
  object Tot_Query: TFDQuery
    Connection = dm.FDConnection1
    SQL.Strings = (
      'select count(id) as total'
      'from insa'
      'where dept_code like :code')
    Left = 372
    Top = 128
    ParamData = <
      item
        Name = 'CODE'
        ParamType = ptInput
      end>
  end
  object FDStoredProc1: TFDStoredProc
    Connection = dm.FDConnection1
    StoredProcName = 'INSERT_DEPT'
    Left = 288
    Top = 128
    ParamData = <
      item
        Position = 1
        Name = 'PCODE'
        DataType = ftString
        ParamType = ptInput
        Size = 4
      end
      item
        Position = 2
        Name = 'PDEPT'
        DataType = ftString
        ParamType = ptInput
        Size = 6
      end
      item
        Position = 3
        Name = 'PSECTION'
        DataType = ftString
        ParamType = ptInput
        Size = 8
      end>
  end
end