/HRManager/__history/CONTWORKEREDITUnit.dfm.~12~
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