BillsGatherDm.pas 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361
  1. unit BillsGatherDm;
  2. interface
  3. uses
  4. SysUtils, Classes, DB, DBClient, sdIDTree, sdDB, sdProvider,
  5. GclBillsGatherModel;
  6. type
  7. TBillsGatherData = class(TDataModule)
  8. smpGclBills: TsdMemoryProvider;
  9. sddGclBills: TsdDataSet;
  10. sdvGclBills: TsdDataView;
  11. smpDetailGclBills: TsdMemoryProvider;
  12. sddDetailGclBills: TsdDataSet;
  13. sdvDetailGclBills: TsdDataView;
  14. smpDetailDealBills: TsdMemoryProvider;
  15. sddDetailDealBills: TsdDataSet;
  16. sdvDetailDealBills: TsdDataView;
  17. smpDetailBGLBills: TsdMemoryProvider;
  18. sddDetailBGLBills: TsdDataSet;
  19. sdvDetailBGLBills: TsdDataView;
  20. procedure sdvGclBillsCurrentChanged(ARecord: TsdDataRecord);
  21. procedure sdvDetailGclBillsFilterRecord(ARecord: TsdDataRecord;
  22. var Allow: Boolean);
  23. procedure sdvGclBillsGetText(var Text: String; ARecord: TsdDataRecord;
  24. AValue: TsdValue; AColumn: TsdViewColumn; DisplayText: Boolean);
  25. private
  26. FProjectData: TObject;
  27. procedure WriteGatherRecord(AGcls: TList);
  28. function GetMainBillsTree: TsdIDTree;
  29. public
  30. constructor Create(AProjectData: TObject);
  31. destructor Destroy; override;
  32. procedure RefreshBills;
  33. property ProjectData: TObject read FProjectData;
  34. property MainBillsTree: TsdIDTree read GetMainBillsTree;
  35. end;
  36. implementation
  37. uses
  38. ProjectData, PhaseData, StageDm, BillsDm, UtilMethods,
  39. ZhAPI, BillsCompileDm, DealBillsDm, BGLDm, BillsTree, BillsMeasureDm;
  40. {$R *.dfm}
  41. { TBillsGatherData }
  42. constructor TBillsGatherData.Create(AProjectData: TObject);
  43. begin
  44. inherited Create(nil);
  45. FProjectData := AProjectData;
  46. sddGclBills.Open;
  47. if not Assigned(sddGclBills.FindIndex('idxIndexCode')) then
  48. sddGclBills.AddIndex('idxIndexCode', 'IndexCode');
  49. sdvGclBills.Open;
  50. sdvGclBills.IndexName := 'idxIndexCode';
  51. sddDetailGclBills.Open;
  52. if not Assigned(sddDetailGclBills.FindIndex('idxSerialNo')) then
  53. sddDetailGclBills.AddIndex('idxSerialNo', 'BillsID;TreeSerialNo');
  54. if not Assigned(sddDetailGclBills.FindIndex('idxRelaBills')) then
  55. sddDetailGclBills.AddIndex('idxRelaBills', 'RelaBillsID');
  56. sdvDetailGclBills.Open;
  57. sdvDetailGclBills.IndexName := 'idxSerialNo';
  58. sddDetailDealBills.Open;
  59. if not Assigned(sddDetailDealBills.FindIndex('idxDeal')) then
  60. sddDetailDealBills.AddIndex('idxDeal', 'DealID');
  61. sdvDetailDealBills.Open;
  62. sdvDetailDealBills.IndexName := 'idxDeal';
  63. sddDetailBGLBills.Open;
  64. if not Assigned(sddDetailBGLBills.FindIndex('idxBGL')) then
  65. sddDetailBGLBills.AddIndex('idxBGL', 'BGLID');
  66. sdvDetailBGLBills.Open;
  67. sdvDetailBGLBills.IndexName := 'idxBGL';
  68. end;
  69. destructor TBillsGatherData.Destroy;
  70. begin
  71. inherited;
  72. end;
  73. function TBillsGatherData.GetMainBillsTree: TsdIDTree;
  74. begin
  75. Result := TProjectData(FProjectData).BillsMeasureData.BillsMeasureTree;
  76. end;
  77. procedure TBillsGatherData.RefreshBills;
  78. var
  79. vGather: TGclGatherModel;
  80. begin
  81. vGather := TGclGatherModel.Create(FProjectData);
  82. try
  83. vGather.GatherDeal := True;
  84. vGather.GatherBGL := True;
  85. vGather.WriteGatherData := WriteGatherRecord;
  86. vGather.Execute;
  87. finally
  88. vGather.Free;
  89. end;
  90. end;
  91. procedure TBillsGatherData.WriteGatherRecord(AGcls: TList);
  92. procedure DisableAndClearDataSet(ADataSet: TsdDataSet);
  93. begin
  94. ADataSet.DisableControls;
  95. ADataSet.BeginUpdate;
  96. ADataSet.DeleteAll;
  97. end;
  98. procedure EnableDataSet(ADataSet: TsdDataSet);
  99. begin
  100. ADataSet.EndUpdate;
  101. ADataSet.EnableControls;
  102. end;
  103. procedure BeforeWrite;
  104. begin
  105. sdvDetailGclBills.Filtered := False;
  106. sdvDetailDealBills.Filtered := False;
  107. sdvDetailBGLBills.Filtered := False;
  108. DisableAndClearDataSet(sddGclBills);
  109. DisableAndClearDataSet(sddDetailGclBills);
  110. DisableAndClearDataSet(sddDetailDealBills);
  111. DisableAndClearDataSet(sddDetailBGLBills);
  112. end;
  113. procedure AfterWrite;
  114. begin
  115. EnableDataSet(sddDetailBGLBills);
  116. EnableDataSet(sddDetailDealBills);
  117. EnableDataSet(sddDetailGclBills);
  118. EnableDataSet(sddGclBills);
  119. sdvGclBills.LocateInControl(sddGclBills.Records[0]);
  120. sdvDetailGclBills.Filtered := True;
  121. sdvDetailDealBills.Filtered := True;
  122. sdvDetailBGLBills.Filtered := True;
  123. end;
  124. procedure WriteDetailDealNode(AGclNode: TGclNode);
  125. var
  126. iDeal: Integer;
  127. vDeal: TDetailDealNode;
  128. Rec: TsdDataRecord;
  129. begin
  130. for iDeal := 0 to AGclNode.DetailDealCount - 1 do
  131. begin
  132. vDeal := AGclNode.DetailDeal[iDeal];
  133. Rec := sddDetailDealBills.Add;
  134. Rec.ValueByName('ID').AsInteger := vDeal.ID;
  135. Rec.ValueByName('BillsID').AsInteger := AGclNode.ID;
  136. Rec.ValueByName('DealID').AsInteger := vDeal.DealID;
  137. Rec.ValueByName('B_Code').AsString := AGclNode.B_Code;
  138. Rec.ValueByName('Name').AsString := AGclNode.Name;
  139. Rec.ValueByName('Units').AsString := AGclNode.Units;
  140. Rec.ValueByName('Price').AsFloat := AGclNode.Price;
  141. Rec.ValueByName('Quantity').AsFloat := vDeal.Quantity;
  142. Rec.ValueByName('TotalPrice').AsFloat := vDeal.TotalPrice;
  143. end;
  144. end;
  145. procedure WriteDetailBGLNode(AGclNode: TGclNode);
  146. var
  147. iBGL: Integer;
  148. vBGL: TDetailBGLNode;
  149. Rec: TsdDataRecord;
  150. begin
  151. for iBGL := 0 to AGclNode.DetailBGLCount - 1 do
  152. begin
  153. vBGL := AGclNode.DetailBGL[iBGL];
  154. Rec := sddDetailBGLBills.Add;
  155. Rec.ValueByName('ID').AsInteger := vBGL.ID;
  156. Rec.ValueByName('BillsID').AsInteger := AGclNode.ID;
  157. Rec.ValueByName('BGBillsID').AsInteger := vBGL.BGBillsID;
  158. Rec.ValueByName('BGLID').AsInteger := vBGL.BGLID;
  159. Rec.ValueByName('BGLCode').AsString := vBGL.BGLCode;
  160. Rec.ValueByName('BGLName').AsString := vBGL.BGLName;
  161. Rec.ValueByName('BGLApprovalCode').AsString := vBGL.BGLApprovalCode;
  162. Rec.ValueByName('BGLDrawingCode').AsString := vBGL.BGLDrawingCode;
  163. Rec.ValueByName('Quantity').AsFloat := vBGL.Quantity;
  164. Rec.ValueByName('TotalPrice').AsFloat := vBGL.TotalPrice;
  165. end;
  166. end;
  167. procedure WriteDetailGclNode(AGclNode: TGclNode);
  168. var
  169. iDetailGcl: Integer;
  170. vDetailGcl: TDetailGclNode;
  171. Rec: TsdDataRecord;
  172. begin
  173. for iDetailGcl := 0 to AGclNode.DetailGclCount -1 do
  174. begin
  175. vDetailGcl := AGclNode.DetailGcl[iDetailGcl];
  176. Rec := sddDetailGclBills.Add;
  177. Rec.ValueByName('ID').AsInteger := vDetailGcl.ID;
  178. Rec.ValueByName('BillsID').AsInteger := AGclNode.ID;
  179. Rec.ValueByName('TreeSerialNo').AsInteger := vDetailGcl.TreeSerialNo;
  180. Rec.ValueByName('RelaBillsID').AsInteger := vDetailGcl.BillsID;
  181. if Assigned(vDetailGcl.LeafXmj) then
  182. begin
  183. Rec.ValueByName('LeafXmjID').AsInteger := vDetailGcl.LeafXmj.ID;
  184. Rec.ValueByName('XmjCode').AsString := vDetailGcl.LeafXmj.XmjCode;
  185. Rec.ValueByName('XmjName').AsString := vDetailGcl.LeafXmj.XmjName;
  186. Rec.ValueByName('XmjUnits').AsString := vDetailGcl.LeafXmj.XmjUnits;
  187. Rec.ValueByName('NameDanWei').AsString := vDetailGcl.LeafXmj.NameDanWei;
  188. Rec.ValueByName('NameFenXiang').AsString := vDetailGcl.LeafXmj.NameFenXiang;
  189. Rec.ValueByName('NameFenBu').AsString := vDetailGcl.LeafXmj.NameFenBu;
  190. Rec.ValueByName('NameUnit').AsString := vDetailGcl.LeafXmj.NameUnit;
  191. Rec.ValueByName('Peg').AsString := vDetailGcl.LeafXmj.Peg;
  192. Rec.ValueByName('Position').AsString := vDetailGcl.LeafXmj.Position;
  193. Rec.ValueByName('DrawingCode').AsString := vDetailGcl.LeafXmj.DrawingCode;
  194. end;
  195. Rec.ValueByName('Quantity').AsFloat := vDetailGcl.Quantity;
  196. Rec.ValueByName('TotalPrice').AsFloat := vDetailGcl.TotalPrice;
  197. Rec.ValueByName('CurDealQuantity').AsFloat := vDetailGcl.CurDealQuantity;
  198. Rec.ValueByName('CurDealTotalPrice').AsFloat := vDetailGcl.CurDealTotalPrice;
  199. Rec.ValueByName('CurQcQuantity').AsFloat := vDetailGcl.CurQcQuantity;
  200. Rec.ValueByName('CurQcTotalPrice').AsFloat := vDetailGcl.CurQcTotalPrice;
  201. Rec.ValueByName('CurGatherQuantity').AsFloat := vDetailGcl.CurGatherQuantity;
  202. Rec.ValueByName('CurGatherTotalPrice').AsFloat := vDetailGcl.CurGatherTotalPrice;
  203. Rec.ValueByName('PreDealQuantity').AsFloat := vDetailGcl.PreDealQuantity;
  204. Rec.ValueByName('PreDealTotalPrice').AsFloat := vDetailGcl.PreDealTotalPrice;
  205. Rec.ValueByName('PreQcQuantity').AsFloat := vDetailGcl.PreQcQuantity;
  206. Rec.ValueByName('PreQcTotalPrice').AsFloat := vDetailGcl.PreQcTotalPrice;
  207. Rec.ValueByName('PreGatherQuantity').AsFloat := vDetailGcl.PreGatherQuantity;
  208. Rec.ValueByName('PreGatherTotalPrice').AsFloat := vDetailGcl.PreGatherTotalPrice;
  209. Rec.ValueByName('EndDealQuantity').AsFloat := vDetailGcl.EndDealQuantity;
  210. Rec.ValueByName('EndDealTotalPrice').AsFloat := vDetailGcl.EndDealTotalPrice;
  211. Rec.ValueByName('EndQcQuantity').AsFloat := vDetailGcl.EndQcQuantity;
  212. Rec.ValueByName('EndQcTotalPrice').AsFloat := vDetailGcl.EndQcTotalPrice;
  213. Rec.ValueByName('EndGatherQuantity').AsFloat := vDetailGcl.EndGatherQuantity;
  214. Rec.ValueByName('EndGatherTotalPrice').AsFloat := vDetailGcl.EndGatherTotalPrice;
  215. Rec.ValueByName('AddDealQuantity').AsFloat := vDetailGcl.AddDealQuantity;
  216. Rec.ValueByName('AddDealTotalPrice').AsFloat := vDetailGcl.AddDealTotalPrice;
  217. Rec.ValueByName('AddQcQuantity').AsFloat := vDetailGcl.AddQcQuantity;
  218. Rec.ValueByName('AddQcTotalPrice').AsFloat := vDetailGcl.AddQcTotalPrice;
  219. Rec.ValueByName('AddGatherQuantity').AsFloat := vDetailGcl.AddGatherQuantity;
  220. Rec.ValueByName('AddGatherTotalPrice').AsFloat := vDetailGcl.AddGatherTotalPrice;
  221. end;
  222. end;
  223. procedure WriteGclNode(AGclNode: TGclNode);
  224. var
  225. Rec: TsdDataRecord;
  226. begin
  227. Rec := sddGclBills.Add;
  228. Rec.ValueByName('ID').AsInteger := AGclNode.ID;
  229. Rec.ValueByName('IndexCode').AsString := AGclNode.IndexCode;
  230. Rec.ValueByName('B_Code').AsString := AGclNode.B_Code;
  231. Rec.ValueByName('Name').AsString := AGclNode.Name;
  232. Rec.ValueByName('Units').AsString := AGclNode.Units;
  233. Rec.ValueByName('Price').AsFloat := AGclNode.Price;
  234. Rec.ValueByName('DealQuantity').AsFloat := AGclNode.DealQuantity;
  235. Rec.ValueByName('DealTotalPrice').AsFloat := AGclNode.DealTotalPrice;
  236. Rec.ValueByName('BGLQuantity').AsFloat := AGclNode.BGLQuantity;
  237. Rec.ValueByName('BGLTotalPrice').AsFloat := AGclNode.BGLTotalPrice;
  238. Rec.ValueByName('Quantity').AsFloat := AGclNode.Quantity;
  239. Rec.ValueByName('TotalPrice').AsFloat := AGclNode.TotalPrice;
  240. Rec.ValueByName('CurDealQuantity').AsFloat := AGclNode.CurDealQuantity;
  241. Rec.ValueByName('CurDealTotalPrice').AsFloat := AGclNode.CurDealTotalPrice;
  242. Rec.ValueByName('CurQcQuantity').AsFloat := AGclNode.CurQcQuantity;
  243. Rec.ValueByName('CurQcTotalPrice').AsFloat := AGclNode.CurQcTotalPrice;
  244. Rec.ValueByName('CurGatherQuantity').AsFloat := AGclNode.CurGatherQuantity;
  245. Rec.ValueByName('CurGatherTotalPrice').AsFloat := AGclNode.CurGatherTotalPrice;
  246. Rec.ValueByName('PreDealQuantity').AsFloat := AGclNode.PreDealQuantity;
  247. Rec.ValueByName('PreDealTotalPrice').AsFloat := AGclNode.PreDealTotalPrice;
  248. Rec.ValueByName('PreQcQuantity').AsFloat := AGclNode.PreQcQuantity;
  249. Rec.ValueByName('PreQcTotalPrice').AsFloat := AGclNode.PreQcTotalPrice;
  250. Rec.ValueByName('PreGatherQuantity').AsFloat := AGclNode.PreGatherQuantity;
  251. Rec.ValueByName('PreGatherTotalPrice').AsFloat := AGclNode.PreGatherTotalPrice;
  252. Rec.ValueByName('EndDealQuantity').AsFloat := AGclNode.EndDealQuantity;
  253. Rec.ValueByName('EndDealTotalPrice').AsFloat := AGclNode.EndDealTotalPrice;
  254. Rec.ValueByName('EndQcQuantity').AsFloat := AGclNode.EndQcQuantity;
  255. Rec.ValueByName('EndQcTotalPrice').AsFloat := AGclNode.EndQcTotalPrice;
  256. Rec.ValueByName('EndGatherQuantity').AsFloat := AGclNode.EndGatherQuantity;
  257. Rec.ValueByName('EndGatherTotalPrice').AsFloat := AGclNode.EndGatherTotalPrice;
  258. Rec.ValueByName('AddDealQuantity').AsFloat := AGclNode.AddDealQuantity;
  259. Rec.ValueByName('AddDealTotalPrice').AsFloat := AGclNode.AddDealTotalPrice;
  260. Rec.ValueByName('AddQcQuantity').AsFloat := AGclNode.AddQcQuantity;
  261. Rec.ValueByName('AddQcTotalPrice').AsFloat := AGclNode.AddQcTotalPrice;
  262. Rec.ValueByName('AddGatherQuantity').AsFloat := AGclNode.AddGatherQuantity;
  263. Rec.ValueByName('AddGatherTotalPrice').AsFloat := AGclNode.AddGatherTotalPrice;
  264. Rec.ValueByName('Deal_BGLQuantity').AsFloat := AGclNode.Deal_BGLQuantity;
  265. Rec.ValueByName('Deal_BGLTotalPrice').AsFloat := AGclNode.Deal_BGLTotalPrice;
  266. Rec.ValueByName('Deal_BGLPercent').AsFloat := AGclNode.Deal_BGLPercent;
  267. WriteDetailGclNode(AGclNode);
  268. WriteDetailDealNode(AGclNode);
  269. WriteDetailBGLNode(AGclNode);
  270. end;
  271. var
  272. iGcl: Integer;
  273. vGclNode: TGclNode;
  274. begin
  275. BeforeWrite;
  276. try
  277. for iGcl := 0 to AGcls.Count - 1 do
  278. begin
  279. vGclNode := TGclNode(AGcls.Items[iGcl]);
  280. WriteGclNode(vGclNode);
  281. end;
  282. finally
  283. AfterWrite;
  284. end;
  285. end;
  286. procedure TBillsGatherData.sdvGclBillsCurrentChanged(
  287. ARecord: TsdDataRecord);
  288. begin
  289. sdvDetailGclBills.RefreshFilter;
  290. sdvDetailDealBills.RefreshFilter;
  291. sdvDetailBGLBills.RefreshFilter;
  292. end;
  293. procedure TBillsGatherData.sdvDetailGclBillsFilterRecord(
  294. ARecord: TsdDataRecord; var Allow: Boolean);
  295. begin
  296. if Assigned(ARecord) and Assigned(sdvGclBills.Current) then
  297. Allow := ARecord.ValueByName('BillsID').AsInteger = sdvGclBills.Current.ValueByName('ID').AsInteger
  298. else
  299. Allow := False;
  300. end;
  301. procedure TBillsGatherData.sdvGclBillsGetText(var Text: String;
  302. ARecord: TsdDataRecord; AValue: TsdValue; AColumn: TsdViewColumn;
  303. DisplayText: Boolean);
  304. begin
  305. if Assigned(AValue) and (AValue.Field.DataType = ftFloat) and (AValue.AsFloat = 0) then
  306. Text := '';
  307. end;
  308. end.