DetailItemsDM.dfm 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435
  1. object DMDetailItems: TDMDetailItems
  2. OldCreateOrder = False
  3. OnCreate = DataModuleCreate
  4. Left = 262
  5. Top = 224
  6. Height = 287
  7. Width = 696
  8. object cdsPPItems: TClientDataSet
  9. Active = True
  10. Aggregates = <>
  11. Params = <>
  12. AfterScroll = cdsPPItemsAfterScroll
  13. Left = 42
  14. Top = 160
  15. Data = {
  16. B70000009619E0BD010000001800000008000000000003000000B70002494404
  17. 0001000000000004436F646501004A0000000100055749445448020002006400
  18. 044E616D6502004A000000010005574944544802000200900105556E69747301
  19. 004A0000000100055749445448020002002800085175616E7469747908000400
  20. 0000000009556E6974507269636508000400000000000A546F74616C50726963
  21. 6508000400000000000742696C6C73494404000100000000000000}
  22. object cdsPPItemsID: TIntegerField
  23. FieldName = 'ID'
  24. end
  25. object cdsPPItemsCode: TWideStringField
  26. FieldName = 'Code'
  27. Size = 50
  28. end
  29. object cdsPPItemsName: TWideStringField
  30. FieldName = 'Name'
  31. Size = 200
  32. end
  33. object cdsPPItemsUnits: TWideStringField
  34. FieldName = 'Units'
  35. end
  36. object cdsPPItemsQuantity: TFloatField
  37. FieldName = 'Quantity'
  38. OnGetText = cdsPQBillsQuantityGetText
  39. end
  40. object cdsPPItemsUnitPrice: TFloatField
  41. FieldName = 'UnitPrice'
  42. OnGetText = cdsPQBillsQuantityGetText
  43. end
  44. object cdsPPItemsTotalPrice: TFloatField
  45. FieldName = 'TotalPrice'
  46. OnGetText = cdsPQBillsQuantityGetText
  47. end
  48. object cdsPPItemsBillsID: TIntegerField
  49. FieldName = 'BillsID'
  50. end
  51. end
  52. object cdsPPDrawQty: TClientDataSet
  53. Active = True
  54. Aggregates = <>
  55. FieldDefs = <
  56. item
  57. Name = 'Name'
  58. DataType = ftWideString
  59. Size = 200
  60. end
  61. item
  62. Name = 'Units'
  63. DataType = ftWideString
  64. Size = 20
  65. end
  66. item
  67. Name = 'Quantity'
  68. DataType = ftFloat
  69. end
  70. item
  71. Name = 'DesignQuantity'
  72. DataType = ftFloat
  73. end
  74. item
  75. Name = 'MemoStr'
  76. DataType = ftWideString
  77. Size = 200
  78. end
  79. item
  80. Name = 'BillsID'
  81. DataType = ftInteger
  82. end
  83. item
  84. Name = 'SerialNo'
  85. DataType = ftInteger
  86. end
  87. item
  88. Name = 'DQID'
  89. DataType = ftInteger
  90. end>
  91. IndexDefs = <>
  92. Params = <>
  93. StoreDefs = True
  94. BeforePost = cdsPPDrawQtyBeforePost
  95. Left = 243
  96. Top = 158
  97. Data = {
  98. BF0000009619E0BD010000001800000008000000000003000000BF00044E616D
  99. 6502004A000000010005574944544802000200900105556E69747301004A0000
  100. 000100055749445448020002002800085175616E746974790800040000000000
  101. 0E44657369676E5175616E746974790800040000000000074D656D6F53747202
  102. 004A00000001000557494454480200020090010742696C6C7349440400010000
  103. 0000000853657269616C4E6F0400010000000000044451494404000100000000
  104. 000000}
  105. object cdsPPDrawQtyName: TWideStringField
  106. FieldName = 'Name'
  107. Size = 200
  108. end
  109. object cdsPPDrawQtyUnits: TWideStringField
  110. FieldName = 'Units'
  111. end
  112. object cdsPPDrawQtyQuantity: TFloatField
  113. FieldName = 'Quantity'
  114. OnChange = cdsPPDrawQtyQuantityChange
  115. OnGetText = cdsPQBillsQuantityGetText
  116. end
  117. object cdsPPDrawQtyDesignQuantity: TFloatField
  118. FieldName = 'DesignQuantity'
  119. OnGetText = cdsPQBillsQuantityGetText
  120. end
  121. object cdsPPDrawQtyMemoStr: TWideStringField
  122. FieldName = 'MemoStr'
  123. Size = 200
  124. end
  125. object cdsPPDrawQtyBillsID: TIntegerField
  126. FieldName = 'BillsID'
  127. end
  128. object cdsPPDrawQtySerialNo: TIntegerField
  129. FieldName = 'SerialNo'
  130. end
  131. object cdsPPDrawQtyDQID: TIntegerField
  132. FieldName = 'DQID'
  133. end
  134. end
  135. object cdsPPDetailItems: TClientDataSet
  136. Active = True
  137. Aggregates = <>
  138. Params = <>
  139. AfterScroll = cdsPPDetailItemsAfterScroll
  140. Left = 138
  141. Top = 159
  142. Data = {
  143. B60000009619E0BD010000001800000008000000000003000000B60002494404
  144. 0001000000000004436F646501004A0000000100055749445448020002006400
  145. 044E616D6502004A000000010005574944544802000200900105556E69747301
  146. 004A0000000100055749445448020002002800085175616E7469747908000400
  147. 0000000009556E6974507269636508000400000000000A546F74616C50726963
  148. 650800040000000000064974656D494404000100000000000000}
  149. object cdsPPDetailItemsID: TIntegerField
  150. FieldName = 'ID'
  151. end
  152. object cdsPPDetailItemsCode: TWideStringField
  153. FieldName = 'Code'
  154. Size = 50
  155. end
  156. object cdsPPDetailItemsName: TWideStringField
  157. FieldName = 'Name'
  158. Size = 200
  159. end
  160. object cdsPPDetailItemsUnits: TWideStringField
  161. FieldName = 'Units'
  162. end
  163. object cdsPPDetailItemsQuantity: TFloatField
  164. FieldName = 'Quantity'
  165. OnGetText = cdsPQBillsQuantityGetText
  166. end
  167. object cdsPPDetailItemsUnitPrice: TFloatField
  168. FieldName = 'UnitPrice'
  169. OnGetText = cdsPQBillsQuantityGetText
  170. end
  171. object cdsPPDetailItemsTotalPrice: TFloatField
  172. FieldName = 'TotalPrice'
  173. OnGetText = cdsPQBillsQuantityGetText
  174. end
  175. object cdsPPDetailItemsItemID: TIntegerField
  176. FieldName = 'ItemID'
  177. end
  178. end
  179. object cdsPQBills: TClientDataSet
  180. Active = True
  181. Aggregates = <>
  182. Params = <>
  183. AfterScroll = cdsPQBillsAfterScroll
  184. Left = 474
  185. Top = 56
  186. Data = {
  187. 020100009619E0BD010000001800000008000000000003000000020102494404
  188. 0001000000000006425F436F646501004A000000010005574944544802000200
  189. 6400044E616D6502004A000000010005574944544802000200900105556E6974
  190. 7301004A0000000100055749445448020002006400085175616E746974790800
  191. 04000000000009556E697450726963650C0005000000020008444543494D414C
  192. 530200020004000557494454480200020013000A546F74616C50726963650C00
  193. 05000000020008444543494D414C530200020004000557494454480200020013
  194. 00074D656D6F53747204004B0000000100075355425459504502004900050054
  195. 657874000000}
  196. object cdsPQBillsID: TIntegerField
  197. FieldName = 'ID'
  198. end
  199. object cdsPQBillsCode: TWideStringField
  200. FieldName = 'B_Code'
  201. Size = 50
  202. end
  203. object cdsPQBillsName: TWideStringField
  204. FieldName = 'Name'
  205. Size = 200
  206. end
  207. object cdsPQBillsUnits: TWideStringField
  208. FieldName = 'Units'
  209. Size = 50
  210. end
  211. object cdsPQBillsQuantity: TFloatField
  212. FieldName = 'Quantity'
  213. OnGetText = cdsPQBillsQuantityGetText
  214. end
  215. object cdsPQBillsUnitPrice: TBCDField
  216. FieldName = 'UnitPrice'
  217. OnGetText = cdsPQBillsQuantityGetText
  218. Precision = 19
  219. end
  220. object cdsPQBillsTotalPrice: TBCDField
  221. FieldName = 'TotalPrice'
  222. OnGetText = cdsPQBillsQuantityGetText
  223. Precision = 19
  224. end
  225. object cdsPQBillsMemoStr: TMemoField
  226. FieldName = 'MemoStr'
  227. BlobType = ftMemo
  228. end
  229. end
  230. object cdsBills: TClientDataSet
  231. Aggregates = <>
  232. Params = <>
  233. Left = 416
  234. Top = 56
  235. object cdsBillsCode: TWideStringField
  236. FieldName = 'Code'
  237. Size = 50
  238. end
  239. object cdsBillsB_Code: TWideStringField
  240. FieldName = 'B_Code'
  241. Size = 50
  242. end
  243. object cdsBillsName: TWideStringField
  244. FieldName = 'Name'
  245. Size = 200
  246. end
  247. object cdsBillsUnits: TWideStringField
  248. FieldName = 'Units'
  249. Size = 50
  250. end
  251. object cdsBillsQuantity: TFloatField
  252. FieldName = 'Quantity'
  253. end
  254. object cdsBillsUnitPrice: TBCDField
  255. FieldName = 'UnitPrice'
  256. Precision = 19
  257. end
  258. object cdsBillsTotalPrice: TBCDField
  259. FieldName = 'TotalPrice'
  260. Precision = 19
  261. end
  262. object cdsBillsMemoStr: TMemoField
  263. FieldName = 'MemoStr'
  264. BlobType = ftMemo
  265. end
  266. end
  267. object cdsQIItems: TClientDataSet
  268. Active = True
  269. Aggregates = <>
  270. Params = <>
  271. AfterScroll = cdsQIItemsAfterScroll
  272. Left = 416
  273. Top = 158
  274. Data = {
  275. B70000009619E0BD010000001800000008000000000003000000B70002494404
  276. 0001000000000004436F646501004A0000000100055749445448020002006400
  277. 044E616D6502004A000000010005574944544802000200900105556E69747301
  278. 004A0000000100055749445448020002002800085175616E7469747908000400
  279. 0000000009556E6974507269636508000400000000000A546F74616C50726963
  280. 6508000400000000000742696C6C73494404000100000000000000}
  281. object cdsQIItemsID: TIntegerField
  282. FieldName = 'ID'
  283. end
  284. object cdsQIItemsCode: TWideStringField
  285. FieldName = 'Code'
  286. Size = 50
  287. end
  288. object cdsQIItemsName: TWideStringField
  289. FieldName = 'Name'
  290. Size = 200
  291. end
  292. object cdsQIItemsUnits: TWideStringField
  293. FieldName = 'Units'
  294. end
  295. object cdsQIItemsQuantity: TFloatField
  296. FieldName = 'Quantity'
  297. OnGetText = cdsPQBillsQuantityGetText
  298. end
  299. object cdsQIItemsUnitPrice: TFloatField
  300. FieldName = 'UnitPrice'
  301. OnGetText = cdsPQBillsQuantityGetText
  302. end
  303. object cdsQIItemsTotalPrice: TFloatField
  304. FieldName = 'TotalPrice'
  305. OnGetText = cdsPQBillsQuantityGetText
  306. end
  307. object cdsQIItemsBillsID: TIntegerField
  308. FieldName = 'BillsID'
  309. end
  310. end
  311. object cdsQIDetailItems: TClientDataSet
  312. Active = True
  313. Aggregates = <>
  314. Params = <>
  315. Left = 496
  316. Top = 158
  317. Data = {
  318. B60000009619E0BD010000001800000008000000000003000000B60002494404
  319. 0001000000000004436F646501004A0000000100055749445448020002006400
  320. 044E616D6502004A000000010005574944544802000200900105556E69747301
  321. 004A0000000100055749445448020002002800085175616E7469747908000400
  322. 0000000009556E6974507269636508000400000000000A546F74616C50726963
  323. 650800040000000000064974656D494404000100000000000000}
  324. object cdsQIDetailItemsID: TIntegerField
  325. FieldName = 'ID'
  326. end
  327. object cdsQIDetailItemsCode: TWideStringField
  328. FieldName = 'Code'
  329. Size = 50
  330. end
  331. object cdsQIDetailItemsName: TWideStringField
  332. FieldName = 'Name'
  333. Size = 200
  334. end
  335. object cdsQIDetailItemsUnits: TWideStringField
  336. FieldName = 'Units'
  337. end
  338. object cdsQIDetailItemsQuantity: TFloatField
  339. FieldName = 'Quantity'
  340. OnChange = cdsPPDrawQtyQuantityChange
  341. end
  342. object cdsQIDetailItemsUnitPrice: TFloatField
  343. FieldName = 'UnitPrice'
  344. OnChange = cdsPPDrawQtyQuantityChange
  345. end
  346. object cdsQIDetailItemsTotalPrice: TFloatField
  347. FieldName = 'TotalPrice'
  348. OnChange = cdsPPDrawQtyQuantityChange
  349. end
  350. object cdsQIDetailItemsItemID: TIntegerField
  351. FieldName = 'ItemID'
  352. end
  353. end
  354. object cdsQIDrawQty: TClientDataSet
  355. Active = True
  356. Aggregates = <>
  357. FieldDefs = <
  358. item
  359. Name = 'Name'
  360. DataType = ftWideString
  361. Size = 200
  362. end
  363. item
  364. Name = 'Units'
  365. DataType = ftWideString
  366. Size = 20
  367. end
  368. item
  369. Name = 'Quantity'
  370. DataType = ftFloat
  371. end
  372. item
  373. Name = 'DesignQuantity'
  374. DataType = ftFloat
  375. end
  376. item
  377. Name = 'MemoStr'
  378. DataType = ftWideString
  379. Size = 200
  380. end
  381. item
  382. Name = 'BillsID'
  383. DataType = ftInteger
  384. end
  385. item
  386. Name = 'SerialNo'
  387. DataType = ftInteger
  388. end
  389. item
  390. Name = 'DQID'
  391. DataType = ftInteger
  392. end>
  393. IndexDefs = <>
  394. Params = <>
  395. StoreDefs = True
  396. Left = 582
  397. Top = 158
  398. Data = {
  399. BF0000009619E0BD010000001800000008000000000003000000BF00044E616D
  400. 6502004A000000010005574944544802000200900105556E69747301004A0000
  401. 000100055749445448020002002800085175616E746974790800040000000000
  402. 0E44657369676E5175616E746974790800040000000000074D656D6F53747202
  403. 004A00000001000557494454480200020090010742696C6C7349440400010000
  404. 0000000853657269616C4E6F0400010000000000044451494404000100000000
  405. 000000}
  406. object cdsQIDrawQtyName: TWideStringField
  407. FieldName = 'Name'
  408. Size = 200
  409. end
  410. object cdsQIDrawQtyUnits: TWideStringField
  411. FieldName = 'Units'
  412. end
  413. object cdsQIDrawQtyQuantity: TFloatField
  414. FieldName = 'Quantity'
  415. OnGetText = cdsPQBillsQuantityGetText
  416. end
  417. object cdsQIDrawQtyDesignQuantity: TFloatField
  418. FieldName = 'DesignQuantity'
  419. OnGetText = cdsPQBillsQuantityGetText
  420. end
  421. object cdsQIDrawQtyMemoStr: TWideStringField
  422. FieldName = 'MemoStr'
  423. Size = 200
  424. end
  425. object cdsQIDrawQtyBillsID: TIntegerField
  426. FieldName = 'BillsID'
  427. end
  428. object cdsQIDrawQtySerialNo: TIntegerField
  429. FieldName = 'SerialNo'
  430. end
  431. object cdsQIDrawQtyDQID: TIntegerField
  432. FieldName = 'DQID'
  433. end
  434. end
  435. end