/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

  1. inherited 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
  860. end