PageRenderTime 26ms CodeModel.GetById 20ms app.highlight 2ms RepoModel.GetById 1ms app.codeStats 0ms

/HRManager/__history/CONTWORKEREDITUnit.dfm.~12~

https://github.com/oista/NPO
Unknown | 860 lines | 860 code | 0 blank | 0 comment | 0 complexity | 8156336b98408f02e72642bd80df9dc3 MD5 | raw file
  1inherited CONTWORKEREDIT: TCONTWORKEREDIT
  2  Caption = #1057#1086#1090#1088'. '#1087#1086' '#1076#1086#1075#1086#1074#1086#1088#1091'   '
  3  ClientHeight = 738
  4  ClientWidth = 521
  5  ExplicitWidth = 527
  6  ExplicitHeight = 762
  7  PixelsPerInch = 96
  8  TextHeight = 13
  9  inherited Panel1: TPanel
 10    Left = 430
 11    Height = 738
 12    ExplicitLeft = 430
 13    ExplicitHeight = 738
 14    object PKDBDictEdit4: TPKDBDictEdit
 15      Left = 11
 16      Top = 133
 17      Width = 1
 18      Height = 1
 19      Connection = DataModule1.ADConnection1
 20      Table = PKDBTable2
 21      TableField = 'CITEZENID'
 22      LookUpRool = ' id'
 23      WithoutTable = False
 24      DesignSize = (
 25        1
 26        1)
 27    end
 28    object PKDBDictEdit5: TPKDBDictEdit
 29      Left = 32
 30      Top = 168
 31      Width = 1
 32      Height = 1
 33      Connection = DataModule1.ADConnection1
 34      Table = PKDBTable2
 35      TableField = 'EMPLOYEEID'
 36      LookUpRool = ' id'
 37      WithoutTable = False
 38      DesignSize = (
 39        1
 40        1)
 41    end
 42    object PKDBDictEdit6: TPKDBDictEdit
 43      Left = 3
 44      Top = 267
 45      Width = 1
 46      Height = 1
 47      Connection = DataModule1.ADConnection1
 48      Table = PKDBTable3
 49      TableField = 'EMPLOYEEID'
 50      LookUpRool = ' id'
 51      WithoutTable = False
 52      DesignSize = (
 53        1
 54        1)
 55    end
 56    object PKDBDictEdit7: TPKDBDictEdit
 57      Left = 3
 58      Top = 294
 59      Width = 1
 60      Height = 1
 61      Connection = DataModule1.ADConnection1
 62      Table = PKDBTable1
 63      TableField = 'WORKCONTRACTID'
 64      LookUpRool = ' id'
 65      WithoutTable = False
 66      DesignSize = (
 67        1
 68        1)
 69    end
 70    object PKDBDictEdit8: TPKDBDictEdit
 71      Left = 3
 72      Top = 321
 73      Width = 1
 74      Height = 1
 75      Connection = DataModule1.ADConnection1
 76      Table = PKDBTable3
 77      TableField = 'ORDERTYPE'
 78      LookUpRool = ' id'
 79      WithoutTable = False
 80      DesignSize = (
 81        1
 82        1)
 83    end
 84    object PKDBDictEdit9: TPKDBDictEdit
 85      Left = 16
 86      Top = 215
 87      Width = 1
 88      Height = 1
 89      Connection = DataModule1.ADConnection1
 90      Table = PKDBTable1
 91      TableField = 'WORKUNITTYPE'
 92      LookUpRool = ' id'
 93      WithoutTable = False
 94      DesignSize = (
 95        1
 96        1)
 97    end
 98  end
 99  inherited PageControl1: TPageControl
100    Width = 424
101    Height = 732
102    ExplicitWidth = 424
103    ExplicitHeight = 732
104    inherited TabSheet1: TTabSheet
105      Caption = #1057#1086#1090#1088#1091#1076#1085#1080#1082#1080'  '
106      ExplicitLeft = 4
107      ExplicitTop = 24
108      ExplicitWidth = 416
109      ExplicitHeight = 704
110      object Label1: TLabel
111        Left = 15
112        Top = 6
113        Width = 57
114        Height = 13
115        Caption = #1043#1088#1072#1078#1076#1072#1085#1080#1085
116      end
117      object Label2: TLabel
118        Left = 15
119        Top = 52
120        Width = 57
121        Height = 13
122        Caption = #1044#1086#1083#1078#1085#1086#1089#1090#1100
123      end
124      object PKDBDictEdit1: TPKDBDictEdit
125        Left = 15
126        Top = 25
127        Width = 370
128        Height = 21
129        Table = PKDBTable1
130        TableField = 'CITEZENID'
131        LookUpRool = 'lastname||'#39' '#39'||name||'#39' '#39'||fathership||'#39' '#1087#1072#1089#1087#1086#1088#1090' '#8470#39'||PASSPORTNUMB'
132        DictionaryClass = 'TCITEZENLIST'
133        WithoutTable = False
134        DesignSize = (
135          370
136          21)
137      end
138      object PKDBDictEdit2: TPKDBDictEdit
139        Left = 15
140        Top = 70
141        Width = 370
142        Height = 21
143        Table = PKDBTable1
144        TableField = 'STRUCTUREID'
145        LookUpRool = #39#1055#1054#1044#1056'.'#8470#39'||DCODE||'#39' '#39'|| jobtitle||'#39' '#39'||qualification'
146        DictionaryClass = 'TVACANCY'
147        WithoutTable = False
148        DesignSize = (
149          370
150          21)
151      end
152      object PKDBLabelEdit3: TPKDBLabelEdit
153        Left = 15
154        Top = 160
155        Width = 178
156        Height = 21
157        TabOrder = 2
158        Text = #1058#1072#1073'.'#8470
159        Table = PKDBTable1
160        TableField = 'TABNUMB'
161        EditLabel.Width = 35
162        EditLabel.Height = 13
163        EditLabel.Caption = #1058#1072#1073'.'#8470
164      end
165      object PKDBLabelEdit4: TPKDBLabelEdit
166        Left = 15
167        Top = 115
168        Width = 178
169        Height = 21
170        TabOrder = 3
171        Text = #1044#1072#1090#1072' '#1087#1088#1080#1093#1086#1076#1072' '#1085#1072#1076#1086#1083#1078#1085#1086#1089#1090#1100
172        EditKind = ekDateEdit
173        Table = PKDBTable1
174        TableField = 'INDATE'
175        EditLabel.Width = 143
176        EditLabel.Height = 13
177        EditLabel.Caption = #1044#1072#1090#1072' '#1087#1088#1080#1093#1086#1076#1072' '#1085#1072#1076#1086#1083#1078#1085#1086#1089#1090#1100
178      end
179      object PKDBLabelEdit5: TPKDBLabelEdit
180        Left = 207
181        Top = 115
182        Width = 178
183        Height = 21
184        TabOrder = 4
185        Text = #1044#1072#1090#1072' '#1091#1074#1086#1083#1100#1085#1077#1085#1080#1103' '#1089' '#1076#1086#1083#1078#1085#1086#1089#1090#1080
186        EditKind = ekDateEdit
187        Table = PKDBTable1
188        TableField = 'OUTDATE'
189        EditLabel.Width = 156
190        EditLabel.Height = 13
191        EditLabel.Caption = #1044#1072#1090#1072' '#1091#1074#1086#1083#1100#1085#1077#1085#1080#1103' '#1089' '#1076#1086#1083#1078#1085#1086#1089#1090#1080
192      end
193      object GroupBox2: TGroupBox
194        Left = 9
195        Top = 188
196        Width = 398
197        Height = 393
198        Caption = '  '#1044#1086#1075#1086#1074#1086#1088'  '
199        TabOrder = 5
200        object PKDBLabelEdit2: TPKDBLabelEdit
201          Left = 204
202          Top = 82
203          Width = 178
204          Height = 21
205          TabOrder = 0
206          Text = #1044#1072#1090#1072' '#1076#1086#1075#1086#1074#1086#1088#1072
207          EditKind = ekDateEdit
208          Table = PKDBTable2
209          TableField = 'AGREEMENTDATE'
210          EditLabel.Width = 77
211          EditLabel.Height = 13
212          EditLabel.Caption = #1044#1072#1090#1072' '#1076#1086#1075#1086#1074#1086#1088#1072
213        end
214        object PKDBLabelEdit1: TPKDBLabelEdit
215          Left = 12
216          Top = 82
217          Width = 178
218          Height = 21
219          TabOrder = 1
220          Text = #1053#1086#1084#1077#1088' '#1076#1086#1075#1086#1074#1086#1088#1072
221          Table = PKDBTable2
222          TableField = 'AGREEMENTNUMB'
223          EditLabel.Width = 82
224          EditLabel.Height = 13
225          EditLabel.Caption = #1053#1086#1084#1077#1088' '#1076#1086#1075#1086#1074#1086#1088#1072
226        end
227        object PKDBLabelEdit6: TPKDBLabelEdit
228          Left = 12
229          Top = 127
230          Width = 178
231          Height = 21
232          TabOrder = 2
233          Text = #1044#1072#1090#1072' '#1085#1072#1095#1072#1083#1072' '#1089#1088#1086#1082#1072' '#1076#1077#1081#1089#1090#1074#1080#1103
234          EditKind = ekDateEdit
235          Table = PKDBTable2
236          TableField = 'INDATE'
237          EditLabel.Width = 148
238          EditLabel.Height = 13
239          EditLabel.Caption = #1044#1072#1090#1072' '#1085#1072#1095#1072#1083#1072' '#1089#1088#1086#1082#1072' '#1076#1077#1081#1089#1090#1074#1080#1103
240        end
241        object PKDBLabelEdit7: TPKDBLabelEdit
242          Left = 204
243          Top = 127
244          Width = 178
245          Height = 21
246          TabOrder = 3
247          Text = #1044#1072#1090#1072' '#1082#1086#1085#1094#1072' '#1089#1088#1086#1082#1072' '#1076#1077#1081#1089#1090#1074#1080#1103
248          EditKind = ekDateEdit
249          Table = PKDBTable2
250          TableField = 'OUTDATE'
251          EditLabel.Width = 142
252          EditLabel.Height = 13
253          EditLabel.Caption = #1044#1072#1090#1072' '#1082#1086#1085#1094#1072' '#1089#1088#1086#1082#1072' '#1076#1077#1081#1089#1090#1074#1080#1103
254        end
255        object PKDBLabelEdit8: TPKDBLabelEdit
256          Left = 12
257          Top = 264
258          Width = 178
259          Height = 21
260          TabOrder = 4
261          Text = #1054#1087#1083#1072#1090#1072
262          EditKind = ekNumberEdit
263          Table = PKDBTable2
264          TableField = 'SALARY'
265          EditLabel.Width = 38
266          EditLabel.Height = 13
267          EditLabel.Caption = #1054#1087#1083#1072#1090#1072
268        end
269        object PKDBBLabelComboBox1: TPKDBBLabelComboBox
270          Left = 12
271          Top = 172
272          Width = 370
273          Height = 21
274          ItemHeight = 0
275          TabOrder = 5
276          Text = #1058#1080#1087' '#1086#1087#1083#1072#1090#1099
277          DBTable = 'HR_FACETCONTENT'
278          PrimaryKey = 'id'
279          content = ' rowcontent'
280          constraint = ' facetid=6275847'
281          Table = PKDBTable2
282          TableField = 'SALARYTYPEID'
283          EditLabel.Width = 59
284          EditLabel.Height = 13
285          EditLabel.Caption = #1058#1080#1087' '#1086#1087#1083#1072#1090#1099
286        end
287        object PKDBBLabelComboBox5: TPKDBBLabelComboBox
288          Left = 12
289          Top = 39
290          Width = 370
291          Height = 21
292          ItemHeight = 0
293          TabOrder = 6
294          Text = #1058#1080#1087' '#1076#1086#1075#1086#1074#1086#1088#1072
295          OnChange = PKDBBLabelComboBox5Change
296          DBTable = 'HR_FACETCONTENT'
297          PrimaryKey = 'ID'
298          content = 'rowcontent'
299          constraint = ' facetid=6275938'
300          Table = PKDBTable2
301          TableField = 'CONTRACTTYPEID'
302          EditLabel.Width = 69
303          EditLabel.Height = 13
304          EditLabel.Caption = #1058#1080#1087' '#1076#1086#1075#1086#1074#1086#1088#1072
305        end
306        object PKDBBLabelComboBox3: TPKDBBLabelComboBox
307          Left = 12
308          Top = 308
309          Width = 178
310          Height = 21
311          ItemHeight = 0
312          TabOrder = 7
313          Text = #1048#1089#1087#1086#1083#1085#1080#1090#1077#1083#1100
314          DBTable = 'HR_FACETCONTENT'
315          PrimaryKey = 'ID'
316          content = 'rowcontent'
317          constraint = ' facetid=6275942'
318          Table = PKDBTable2
319          TableField = 'WORKPERSON'
320          EditLabel.Width = 66
321          EditLabel.Height = 13
322          EditLabel.Caption = #1048#1089#1087#1086#1083#1085#1080#1090#1077#1083#1100
323        end
324        object PKDBLabelEdit10: TPKDBLabelEdit
325          Left = 12
326          Top = 219
327          Width = 178
328          Height = 21
329          TabOrder = 8
330          Text = #1044#1072#1090#1072' '#1085#1072#1095#1072#1083#1072' '#1088#1072#1073#1086#1090
331          EditKind = ekDateEdit
332          Table = PKDBTable2
333          TableField = 'WORKINDATE'
334          EditLabel.Width = 98
335          EditLabel.Height = 13
336          EditLabel.Caption = #1044#1072#1090#1072' '#1085#1072#1095#1072#1083#1072' '#1088#1072#1073#1086#1090
337        end
338        object PKDBLabelEdit12: TPKDBLabelEdit
339          Left = 204
340          Top = 308
341          Width = 178
342          Height = 21
343          TabOrder = 9
344          Text = #1050#1086#1083'-'#1074#1086' '#1076#1085#1077#1081' '#1075#1072#1088#1072#1085#1090#1080#1080
345          EditKind = ekNumberEdit
346          Table = PKDBTable2
347          TableField = 'WARRANTY'
348          EditLabel.Width = 113
349          EditLabel.Height = 13
350          EditLabel.Caption = #1050#1086#1083'-'#1074#1086' '#1076#1085#1077#1081' '#1075#1072#1088#1072#1085#1090#1080#1080
351        end
352        object PKDBLabelEdit13: TPKDBLabelEdit
353          Left = 204
354          Top = 264
355          Width = 178
356          Height = 21
357          TabOrder = 10
358          Text = #1044#1085#1080' '#1076#1086' '#1086#1087#1083#1072#1090#1099
359          EditKind = ekNumberEdit
360          Table = PKDBTable2
361          TableField = 'SALARYDAYS'
362          EditLabel.Width = 77
363          EditLabel.Height = 13
364          EditLabel.Caption = #1044#1085#1080' '#1076#1086' '#1086#1087#1083#1072#1090#1099
365        end
366        object PKDBLabelEdit14: TPKDBLabelEdit
367          Left = 204
368          Top = 220
369          Width = 178
370          Height = 21
371          TabOrder = 11
372          Text = #1044#1072#1090#1072' '#1086#1082#1086#1085#1095#1072#1085#1080#1103' '#1088#1072#1073#1086#1090
373          EditKind = ekDateEdit
374          Table = PKDBTable2
375          TableField = 'WORKOUTDATE'
376          EditLabel.Width = 116
377          EditLabel.Height = 13
378          EditLabel.Caption = #1044#1072#1090#1072' '#1086#1082#1086#1085#1095#1072#1085#1080#1103' '#1088#1072#1073#1086#1090
379        end
380        object PKDBBLabelComboBox2: TPKDBBLabelComboBox
381          Left = 12
382          Top = 355
383          Width = 178
384          Height = 21
385          ItemHeight = 0
386          TabOrder = 12
387          Text = #1058#1080#1087' '#1088#1072#1073#1086#1090
388          DBTable = 'HR_FACETCONTENT'
389          PrimaryKey = 'ID'
390          content = 'rowcontent'
391          constraint = ' facetid=6275857'
392          Table = PKDBTable2
393          TableField = 'WORKTYPEID'
394          EditLabel.Width = 51
395          EditLabel.Height = 13
396          EditLabel.Caption = #1058#1080#1087' '#1088#1072#1073#1086#1090
397        end
398      end
399      object CheckBox1: TCheckBox
400        Left = 11
401        Top = 663
402        Width = 285
403        Height = 17
404        Caption = #1042#1099#1074#1077#1089#1090#1080' '#1092#1086#1088#1084#1091' '#1090#1088#1091#1076#1086#1074#1086#1075#1086' '#1076#1086#1075#1086#1074#1086#1088#1072
405        TabOrder = 6
406      end
407      object CheckBox2: TCheckBox
408        Left = 11
409        Top = 683
410        Width = 285
411        Height = 17
412        Caption = #1042#1099#1074#1077#1089#1090#1080' '#1087#1088#1080#1082#1072#1079' '#1086' '#1087#1088#1080#1077#1084#1077
413        TabOrder = 7
414      end
415      object GroupBox1: TGroupBox
416        Left = 11
417        Top = 587
418        Width = 396
419        Height = 70
420        Caption = #1055#1088#1080#1082#1072#1079' '#1086' '#1087#1088#1080#1077#1084#1077
421        TabOrder = 8
422        object PKDBLabelEdit11: TPKDBLabelEdit
423          Left = 202
424          Top = 35
425          Width = 172
426          Height = 21
427          TabOrder = 0
428          Text = #1044#1072#1090#1072' '#1087#1088#1080#1082#1072#1079#1072
429          EditKind = ekDateEdit
430          Table = PKDBTable3
431          TableField = 'ORDERDATE'
432          EditLabel.Width = 70
433          EditLabel.Height = 13
434          EditLabel.Caption = #1044#1072#1090#1072' '#1087#1088#1080#1082#1072#1079#1072
435        end
436        object PKDBLabelEdit9: TPKDBLabelEdit
437          Left = 10
438          Top = 35
439          Width = 178
440          Height = 21
441          TabOrder = 1
442          Text = #1053#1086#1084#1077#1088' '#1087#1088#1080#1082#1072#1079#1072
443          Table = PKDBTable3
444          TableField = 'ORDERNUMB'
445          EditLabel.Width = 75
446          EditLabel.Height = 13
447          EditLabel.Caption = #1053#1086#1084#1077#1088' '#1087#1088#1080#1082#1072#1079#1072
448        end
449      end
450    end
451  end
452  inherited PKDBTable1: TPKDBTable
453    Fields = <
454      item
455        FieldName = 'CITEZENID'
456        FieldLabel = #1043#1088#1072#1078#1076#1072#1085#1080#1085
457        Nullable = False
458        FieldType = ftsNumber
459        ReferencingTable = 'HR_V_CITEZEN'
460        ReferencingColumn = 'ID'
461        LookUpRool = ' id'
462        DisplayName = 'CITEZENID'
463      end
464      item
465        FieldName = 'STRUCTUREID'
466        FieldLabel = #1044#1086#1083#1078#1085#1086#1089#1090#1100
467        Nullable = False
468        FieldType = ftsNumber
469        ReferencingTable = 'CS_V_SCHEDULE_STRUCTURE'
470        ReferencingColumn = 'ID'
471        LookUpRool = ' id'
472        DisplayName = 'STRUCTUREID'
473      end
474      item
475        FieldName = 'AGREEMENTNUMB'
476        FieldLabel = #8470' '#1058#1088#1091#1076#1086#1074#1086#1075#1086' '#1076#1086#1075#1086#1074#1086#1088#1072
477        Nullable = True
478        FieldType = ftsString
479        DisplayName = 'AGREEMENTNUMB'
480      end
481      item
482        FieldName = 'PREVIOUSID'
483        FieldLabel = #1055#1088#1077#1076#1080#1076#1091#1097#1072#1103' '#1076#1086#1083#1078#1085#1086#1089#1090#1100
484        Nullable = True
485        FieldType = ftsNumber
486        DisplayName = 'PREVIOUSID'
487      end
488      item
489        FieldName = 'OUTDATE'
490        FieldLabel = #1044#1072#1090#1072' '#1091#1074#1086#1083#1100#1085#1077#1085#1080#1103' '#1089' '#1076#1086#1083#1078#1085#1086#1089#1090#1080
491        Nullable = True
492        FieldType = ftsDate
493        DisplayName = 'OUTDATE'
494      end
495      item
496        FieldName = 'CHANGESTATUSDATE'
497        FieldLabel = #1044#1072#1090#1072' '#1080#1079#1084#1077#1085#1077#1085#1080#1103' '#1089#1090#1072#1090#1091#1089#1072
498        Nullable = True
499        FieldType = ftsDate
500        DisplayName = 'CHANGESTATUSDATE'
501      end
502      item
503        FieldName = 'AGREEMENTDATE'
504        FieldLabel = #1044#1072#1090#1072' '#1090#1088#1091#1076#1086#1074#1086#1075#1086' '#1076#1086#1075#1086#1074#1086#1088#1072
505        Nullable = True
506        FieldType = ftsDate
507        DisplayName = 'AGREEMENTDATE'
508      end
509      item
510        FieldName = 'WORKUNITTYPE'
511        FieldLabel = #1058#1080#1087' '#1088#1072#1073#1086#1090#1099' ('#1086#1089#1085#1086#1074'./'#1089#1086#1074#1084'.)'
512        Nullable = True
513        FieldType = ftsNumber
514        ReferencingTable = 'CS_FACETCONTENT'
515        ReferencingColumn = 'id'
516        LookUpRool = 'id'
517        DisplayName = 'WORKUNITTYPE'
518      end
519      item
520        FieldName = 'TABNUMB'
521        FieldLabel = #1058#1072#1073#1077#1083#1100#1085#1099#1081' '#1085#1086#1084#1077#1088
522        Nullable = True
523        FieldType = ftsString
524        DisplayName = 'TABNUMB'
525      end
526      item
527        FieldName = 'ID'
528        Nullable = False
529        FieldType = ftsNumber
530        IsPrimaryKey = True
531        DisplayName = 'ID'
532      end
533      item
534        FieldName = 'INDATE'
535        FieldLabel = #1044#1072#1090#1072' '#1087#1088#1080#1093#1086#1076#1072' '#1085#1072' '#1076#1086#1083#1078#1085#1086#1089#1090#1100
536        Nullable = False
537        FieldType = ftsDate
538        DisplayName = 'INDATE'
539      end
540      item
541        FieldName = 'WORKCONTRACTID'
542        FieldLabel = #1058#1088#1091#1076#1086#1074#1086#1081' '#1076#1086#1075#1086#1074#1086#1088
543        Nullable = True
544        FieldType = ftsNumber
545        ReferencingTable = 'HR_WORKCONTRACT'
546        ReferencingColumn = 'ID'
547        LookUpRool = 'id'
548        DisplayName = 'WORKCONTRACTID'
549      end
550      item
551        FieldName = 'DESCR'
552        FieldLabel = #1054#1087#1080#1089#1072#1085#1080#1077
553        Nullable = True
554        FieldType = ftsString
555        DisplayName = 'DESCR'
556      end
557      item
558        FieldName = 'STATUS'
559        FieldLabel = #1057#1090#1072#1090#1091#1089
560        Nullable = True
561        FieldType = ftsNumber
562        DisplayName = 'STATUS'
563      end>
564    TableName = 'HR_EMPLOYEE'
565    NeedGenPrimaryKey = True
566    Connection = DataModule1.ADConnection1
567    PrimaryKeySeq = 'AE_IDSEQ'
568    Left = 440
569    Top = 88
570  end
571  object PKDBTable2: TPKDBTable
572    Fields = <
573      item
574        FieldName = 'EMPLOYEEID'
575        FieldLabel = #1057#1086#1090#1088#1091#1076#1085#1080#1082
576        Nullable = False
577        FieldType = ftsNumber
578        ReferencingTable = 'HR_EMPLOYEE'
579        ReferencingColumn = 'ID'
580        LookUpRool = ' id'
581        IsParentKey = True
582        DisplayName = 'EMPLOYEEID'
583      end
584      item
585        FieldName = 'WORKOUTDATE'
586        FieldLabel = #1044#1072#1090#1072' '#1086#1082#1086#1085#1095#1072#1085#1080#1103' '#1088#1072#1073#1086#1090
587        Nullable = True
588        FieldType = ftsDate
589        DisplayName = 'WORKOUTDATE'
590      end
591      item
592        FieldName = 'SALARYTYPEID'
593        FieldLabel = #1058#1080#1087' '#1086#1087#1083#1072#1090#1099
594        Nullable = False
595        FieldType = ftsNumber
596        ReferencingTable = 'HR_FACETCONTENT'
597        ReferencingColumn = 'id'
598        LookUpRool = ' rowcontent'
599        DisplayName = 'SALARYTYPEID'
600      end
601      item
602        FieldName = 'AGREEMENTNUMB'
603        FieldLabel = #1053#1086#1084#1077#1088' '#1076#1086#1075#1086#1074#1086#1088#1072
604        Nullable = True
605        FieldType = ftsString
606        DisplayName = 'AGREEMENTNUMB'
607      end
608      item
609        FieldName = 'OUTDATE'
610        FieldLabel = #1044#1072#1090#1072' '#1082#1086#1085#1094#1072' '#1089#1088#1086#1082#1072' '#1076#1077#1081#1089#1090#1074#1080#1103
611        Nullable = True
612        FieldType = ftsDate
613        DisplayName = 'OUTDATE'
614      end
615      item
616        FieldName = 'DESCRIPTION'
617        FieldLabel = #1054#1087#1080#1089#1072#1085#1080#1077
618        Nullable = True
619        FieldType = ftsString
620        DisplayName = 'DESCRIPTION'
621      end
622      item
623        FieldName = 'STATUSID'
624        Nullable = True
625        FieldType = ftsNumber
626        DisplayName = 'STATUSID'
627      end
628      item
629        FieldName = 'CITEZENID'
630        Nullable = True
631        FieldType = ftsNumber
632        ReferencingTable = 'HR_CITEZEN'
633        ReferencingColumn = 'ID'
634        LookUpRool = ' id'
635        DisplayName = 'CITEZENID'
636      end
637      item
638        FieldName = 'CHANGESTATUSDATE'
639        Nullable = True
640        FieldType = ftsDate
641        DisplayName = 'CHANGESTATUSDATE'
642      end
643      item
644        FieldName = 'AGREEMENTDATE'
645        FieldLabel = #1044#1072#1090#1072' '#1076#1086#1075#1086#1074#1086#1088#1072
646        Nullable = True
647        FieldType = ftsDate
648        DisplayName = 'AGREEMENTDATE'
649      end
650      item
651        FieldName = 'PASSPORTID'
652        Nullable = True
653        FieldType = ftsNumber
654        DisplayName = 'PASSPORTID'
655      end
656      item
657        FieldName = 'WORKTYPEID'
658        FieldLabel = #1058#1080#1087' '#1088#1072#1073#1086#1090
659        Nullable = True
660        FieldType = ftsNumber
661        ReferencingTable = 'HR_FACETCONTENT'
662        ReferencingColumn = 'ID'
663        LookUpRool = 'rowcontent'
664        DisplayName = 'WORKTYPEID'
665      end
666      item
667        FieldName = 'WORKINDATE'
668        FieldLabel = #1044#1072#1090#1072' '#1085#1072#1095#1072#1083#1072' '#1088#1072#1073#1086#1090
669        Nullable = True
670        FieldType = ftsDate
671        DisplayName = 'WORKINDATE'
672      end
673      item
674        FieldName = 'WORKPERSON'
675        FieldLabel = #1048#1089#1087#1086#1083#1085#1080#1090#1077#1083#1100
676        Nullable = True
677        FieldType = ftsString
678        ReferencingTable = 'HR_FACETCONTENT'
679        ReferencingColumn = 'ID'
680        LookUpRool = 'rowcontent'
681        DisplayName = 'WORKPERSON'
682      end
683      item
684        FieldName = 'ID'
685        Nullable = False
686        FieldType = ftsNumber
687        IsPrimaryKey = True
688        DisplayName = 'ID'
689      end
690      item
691        FieldName = 'CONTRACTTYPEID'
692        FieldLabel = #1058#1080#1087' '#1076#1086#1075#1086#1074#1086#1088#1072
693        Nullable = True
694        FieldType = ftsNumber
695        ReferencingTable = 'HR_FACETCONTENT'
696        ReferencingColumn = 'ID'
697        LookUpRool = 'rowcontent'
698        DisplayName = 'CONTRACTTYPEID'
699      end
700      item
701        FieldName = 'SALARYDAYS'
702        FieldLabel = #1044#1085#1080' '#1076#1086' '#1086#1087#1083#1072#1090#1099
703        Nullable = True
704        FieldType = ftsNumber
705        DisplayName = 'SALARYDAYS'
706      end
707      item
708        FieldName = 'SALARY'
709        FieldLabel = #1054#1087#1083#1072#1090#1072
710        Nullable = True
711        FieldType = ftsNumber
712        DisplayName = 'SALARY'
713      end
714      item
715        FieldName = 'INDATE'
716        FieldLabel = #1044#1072#1090#1072' '#1085#1072#1095#1072#1083#1072' '#1089#1088#1086#1082#1072' '#1076#1077#1081#1089#1090#1074#1080#1103
717        Nullable = True
718        FieldType = ftsDate
719        DisplayName = 'INDATE'
720      end
721      item
722        FieldName = 'WARRANTY'
723        FieldLabel = #1050#1086#1083'-'#1074#1086' '#1076#1085#1077#1081' '#1075#1072#1088#1072#1085#1090#1080#1080
724        Nullable = True
725        FieldType = ftsNumber
726        DisplayName = 'WARRANTY'
727      end>
728    TableName = 'HR_LABORCONTRACT'
729    NeedGenPrimaryKey = True
730    Connection = DataModule1.ADConnection1
731    PrimaryKeySeq = 'AE_IDSEQ'
732    Left = 477
733    Top = 120
734  end
735  object ADQuery1: TADQuery
736    Connection = DataModule1.ADConnection1
737    SQL.Strings = (
738      'select '
739      '  ee.workcontractid'
740      'from HR_EMPLOYEE ee where'
741      '  ee.id=:id')
742    Left = 440
743    Top = 120
744    ParamData = <
745      item
746        Name = 'ID'
747        DataType = ftInteger
748        ParamType = ptInput
749        Value = Null
750      end>
751    object ADQuery1WORKCONTRACTID: TFMTBCDField
752      FieldName = 'WORKCONTRACTID'
753      Precision = 38
754      Size = 38
755    end
756  end
757  object PKDBTable3: TPKDBTable
758    Fields = <
759      item
760        FieldName = 'EMPLOYEEID'
761        FieldLabel = #1057#1086#1090#1088#1091#1076#1085#1080#1082
762        Nullable = True
763        FieldType = ftsNumber
764        ReferencingTable = 'HR_EMPLOYEE'
765        ReferencingColumn = 'ID'
766        LookUpRool = ' id'
767        DisplayName = 'EMPLOYEEID'
768      end
769      item
770        FieldName = 'STATUSID'
771        FieldLabel = #1057#1090#1072#1090#1091#1089
772        Nullable = True
773        FieldType = ftsNumber
774        ReferencingTable = 'AE_STATUS'
775        ReferencingColumn = 'ID'
776        DisplayName = 'STATUSID'
777      end
778      item
779        FieldName = 'ORDERTYPE'
780        FieldLabel = #1058#1080#1087' '#1087#1088#1080#1082#1072#1079#1072
781        Nullable = True
782        FieldType = ftsNumber
783        ReferencingTable = 'HR_FACETCONTENT'
784        ReferencingColumn = 'ID'
785        DisplayName = 'ORDERTYPE'
786      end
787      item
788        FieldName = 'ID'
789        Nullable = False
790        FieldType = ftsNumber
791        IsPrimaryKey = True
792        DisplayName = 'ID'
793      end
794      item
795        FieldName = 'ORDERNUMB'
796        FieldLabel = #1053#1086#1084#1077#1088' '#1087#1088#1080#1082#1072#1079#1072
797        Nullable = True
798        FieldType = ftsString
799        DisplayName = 'ORDERNUMB'
800      end
801      item
802        FieldName = 'CHANGESTATUSDATE'
803        Nullable = True
804        FieldType = ftsDate
805        DisplayName = 'CHANGESTATUSDATE'
806      end
807      item
808        FieldName = 'ORDERDATE'
809        FieldLabel = #1044#1072#1090#1072' '#1087#1088#1080#1082#1072#1079#1072
810        Nullable = True
811        FieldType = ftsDate
812        DisplayName = 'ORDERDATE'
813      end
814      item
815        FieldName = 'ORDERTITLE'
816        FieldLabel = #1047#1072#1075#1086#1083#1086#1074#1086#1082
817        Nullable = True
818        FieldType = ftsString
819        DisplayName = 'ORDERTITLE'
820      end
821      item
822        FieldName = 'WORKCONTRACTID'
823        FieldLabel = #1058#1088#1091#1076#1086#1074#1086#1081' '#1076#1086#1075#1086#1074#1086#1088
824        Nullable = True
825        FieldType = ftsNumber
826        ReferencingTable = 'HR_WORKCONTRACT'
827        ReferencingColumn = 'ID'
828        LookUpRool = ' id'
829        IsParentKey = True
830        DisplayName = 'WORKCONTRACTID'
831      end>
832    TableName = 'HR_ORDER'
833    NeedGenPrimaryKey = True
834    Connection = DataModule1.ADConnection1
835    PrimaryKeySeq = 'AE_IDSEQ'
836    Left = 477
837    Top = 153
838  end
839  object ADQuery2: TADQuery
840    Connection = DataModule1.ADConnection1
841    SQL.Strings = (
842      'select o.id from  HR_ORDER o'
843      'where o.workcontractid=:ID')
844    Left = 440
845    Top = 152
846    ParamData = <
847      item
848        Name = 'ID'
849        DataType = ftInteger
850        ParamType = ptInput
851        Value = 6275986
852      end>
853    object ADQuery2ID: TFMTBCDField
854      FieldName = 'ID'
855      Required = True
856      Precision = 38
857      Size = 38
858    end
859  end
860end