StageDm.pas 35 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045
  1. unit StageDm;
  2. // 原报、审核数据通用
  3. // 原报 - Refer
  4. // 审核 - Audit1, Audit2 ...
  5. interface
  6. uses
  7. mDataRecord, BillsTree,
  8. SysUtils, Classes, sdDB, sdProvider, ADODB, ZhAPI, sdIDTree;
  9. type
  10. TStageData = class(TDataModule)
  11. sdpStage: TsdADOProvider;
  12. sddStage: TsdDataSet;
  13. procedure sddStageAfterValueChanged(AValue: TsdValue);
  14. procedure sddStageBeforeValueChange(AValue: TsdValue;
  15. const NewValue: Variant; var Allow: Boolean);
  16. procedure sddStageGetRecordClass(var ARecordClass: TsdRecordClass);
  17. private
  18. FPhaseData: TObject;
  19. FIndex: Integer;
  20. FBeforeChangeQuantity: Double;
  21. FBeforeChangeTotalPrice: Double;
  22. procedure UpdateParentRecord(ABillsID: Integer; ATotalPrice: Double; const AFieldName: string);
  23. procedure UpdateComplete(ABillsID: Integer; AQuantity, ATotalPrice: Double);
  24. function HasPriceMarginBills: Boolean;
  25. // 向父项增量--PM_TotalPrice
  26. procedure UpdateParentPriceMargin(ABillsID: Integer; ADiffer: Double);
  27. // 向价差调整节点增量--GatherTotalPrice
  28. procedure UpdatePriceMarginNode(ADiffer: Double);
  29. // 重新计算相关的项目工料的价差数据
  30. procedure UpdateProjectGL(ABillsID: Integer);
  31. procedure CalculateDeal(ABillsID: Integer);
  32. procedure CalculateQuantityChange(ABillsID: Integer);
  33. procedure CalculatePriceChange(ABillsID: Integer);
  34. procedure CalculateGather(ABillsID: Integer);
  35. procedure CalculateParent(ANode: TMeasureBillsIDTreeNode);
  36. procedure CalculateLeaf(ANode: TMeasureBillsIDTreeNode);
  37. procedure CalculateSpecialLeaf(ANode: TMeasureBillsIDTreeNode);
  38. function GetTotalPrice(ABillsID, AType, AStageIndex: Integer): Double;
  39. function GetCalcType(ABillsID: Integer): Integer;
  40. function GetBillsUnitPriceMargin(ABillsID: Integer): Double;
  41. function GetBillsPrice(ABillsID: Integer): Double;
  42. function GetBillsNewPrice(ABillsID: Integer): Double;
  43. function GetBillsPriceDiffer(ABillsID: Integer): Double;
  44. function GetMainBillsTree: TBillsIDTree;
  45. function GetBuildLoadInterest(AType, AIndex: Integer): Double;
  46. function GetFirstPart(AType, AIndex: Integer): Double;
  47. function GetOtherFee(AType, AIndex: Integer): Double;
  48. function GetOtherProjectFee(AType, AIndex: Integer): Double;
  49. function GetRecyclingFee(AType, AIndex: Integer): Double;
  50. function GetReservedFee(AType, AIndex: Integer): Double;
  51. function GetSecondPart(AType, AIndex: Integer): Double;
  52. function GetStageSettlement(AType, AIndex: Integer): Double;
  53. function GetThirdPart(AType, AIndex: Integer): Double;
  54. function GetActive: Boolean;
  55. procedure SetTableName(const Value: string);
  56. function GetChapterStageGather(AChapter: Integer): Double;
  57. function GetPriceMargin(AType, AIndex: Integer): Double;
  58. public
  59. constructor Create(APhaseData: TObject);
  60. destructor Destroy; override;
  61. procedure Open(AConnection: TADOConnection);
  62. procedure Save;
  63. procedure BeforeBatchOperation;
  64. procedure AfterBatchOperation;
  65. // 计算任一清单节点的价差金额,并增量汇总至父项
  66. procedure CalculatePriceMargin(ABillsID: Integer);
  67. // 计算材料调差节点
  68. procedure CalculatePriceMarginNode;
  69. procedure CalculateNode(ANode: TsdIDTreeNode);
  70. procedure CalculateAll;
  71. function AddPhaseData(ABillsID: Integer;
  72. const AField, ANewValue: string): Boolean;
  73. function AddStageRecord(ABillsID: Integer): TStageRecord;
  74. procedure DeletePhaseRecord(ABillsID: Integer);
  75. procedure ReCalculate(ABillsID: Integer);
  76. procedure UpdateBGLInfo(ARec: TsdDataRecord; const AType: string);
  77. // 查找
  78. function StageRecord(ABillsID: Integer): TStageRecord;
  79. // 查找,如未找到则新增
  80. function StageRecordWithAdd(ABillsID: Integer): TStageRecord;
  81. // 将Bills表中存的累计计量数据拷贝至截止本期计量、截止上期计量,除新增一期计量外不可调用
  82. procedure CopyPrePhaseData;
  83. property Active: Boolean read GetActive;
  84. property TableName: string Write SetTableName;
  85. property MainBillsTree: TBillsIDTree read GetMainBillsTree;
  86. property PhaseData: TObject read FPhaseData;
  87. {可选计算数}
  88. // AType表示不同类型,取值如下:
  89. // 1: 本期数据 2: 截止本期数据 3: 截止上期数据
  90. // AIndex表示AType下不同数据类型,取值如下:
  91. // 1: 合同计量 2: 数量变更计量 3: 单价变更计量 4: 完成计量
  92. // 第一部分
  93. property FirstPart[AType, AIndex: Integer]: Double read GetFirstPart;
  94. // 第二部分
  95. property SecondPart[AType, AIndex: Integer]: Double read GetSecondPart;
  96. // 第三部分
  97. property ThirdPart[AType, AIndex: Integer]: Double read GetThirdPart;
  98. // 预留费用
  99. property ReservedFee[AType, AIndex: Integer]: Double read GetReservedFee;
  100. // 其他费用项目
  101. property OtherFee[AType, AIndex: Integer]: Double read GetOtherFee;
  102. // 建设期贷款利息
  103. property BuildLoadInterest[AType, AIndex: Integer]: Double read GetBuildLoadInterest;
  104. // 回收金额
  105. property RecyclingFee[AType, AIndex: Integer]: Double read GetRecyclingFee;
  106. // 公路工程以外的工程费用
  107. property OtherProjectFee[AType, AIndex: Integer]: Double read GetOtherProjectFee;
  108. // 本期结算价
  109. property StageSettlement[AType, AIndex: Integer]: Double read GetStageSettlement;
  110. // 价差
  111. property PriceMargin[AType, AIndex: Integer]: Double read GetPriceMargin;
  112. // 100/200/.../900章本期完成计量
  113. property ChapterStageGather[AChapter: Integer]: Double read GetChapterStageGather;
  114. end;
  115. implementation
  116. uses
  117. ProjectData, BillsDm, PhaseData, Math, BGLDm, BillsMeasureDm,
  118. UtilMethods, ConditionalDefines, FormulaCalc, DetailGLDm, ConstUnit,
  119. ProjectGLDm;
  120. {$R *.dfm}
  121. { TPhaseData }
  122. function TStageData.AddPhaseData(ABillsID: Integer;
  123. const AField, ANewValue: string): Boolean;
  124. procedure SetPhaseRecord(ARec: TsdDataRecord; const AField, AValue: string);
  125. begin
  126. if CheckNumeric(ANewValue) then
  127. ARec.ValueByName(AField).AsString := AValue
  128. else
  129. begin
  130. ARec.ValueByName(AField).AsFloat := EvaluateExprs(AValue);
  131. ARec.ValueByName(StringReplace(AField, 'Quantity', 'Flag', [])).AsInteger := 1;
  132. ARec.ValueByName(StringReplace(AField, 'Quantity', 'Formula', [])).AsString := AValue;
  133. end;
  134. end;
  135. var
  136. Rec: TsdDataRecord;
  137. begin
  138. if Assigned(sddStage.FindKey('idxBID', ABillsID)) then Exit;
  139. Rec := sddStage.Add;
  140. Rec.ValueByName('BillsID').AsInteger := ABillsID;
  141. SetPhaseRecord(Rec, AField, ANewValue);
  142. end;
  143. function TStageData.AddStageRecord(ABillsID: Integer): TStageRecord;
  144. begin
  145. Result := TStageRecord(sddStage.FindKey('idxBID', ABillsID));
  146. if Assigned(Result) then Exit;
  147. Result := TStageRecord(sddStage.Add(True));
  148. try
  149. Result.ValueByName('BillsID').AsInteger := ABillsID;
  150. finally
  151. Result.EndUpdate;
  152. end;
  153. end;
  154. procedure TStageData.CalculateDeal(ABillsID: Integer);
  155. var
  156. Rec: TsdDataRecord;
  157. fQtyDiffer, fTPDiffer: Double;
  158. begin
  159. Rec := sddStage.FindKey('idxBID', ABillsID);
  160. if GetCalcType(ABillsID) = 0 then
  161. Rec.ValueByName('DealTotalPrice').AsFloat :=
  162. TotalPriceRoundTo(Rec.ValueByName('DealQuantity').AsFloat * GetBillsPrice(ABillsID));
  163. fQtyDiffer := Rec.ValueByName('DealQuantity').AsFloat - FBeforeChangeQuantity;
  164. fTPDiffer := Rec.ValueByName('DealTotalPrice').AsFloat - FBeforeChangeTotalPrice;
  165. Rec.ValueByName('EndDealQuantity').AsFloat := QuantityRoundTo(
  166. Rec.ValueByName('EndDealQuantity').AsFloat + fQtyDiffer);
  167. Rec.ValueByName('EndDealTotalPrice').AsFloat := TotalPriceRoundTo(
  168. Rec.ValueByName('EndDealTotalPrice').AsFloat + fTPDiffer);
  169. UpdateParentRecord(ABillsID, fTPDiffer, 'DealTotalPrice');
  170. UpdateComplete(ABillsID, fQtyDiffer, fTPDiffer);
  171. if TPhaseData(FPhaseData).IsLastStage then
  172. with TProjectData(TPhaseData(FPhaseData).ProjectData).BillsMeasureData do
  173. UpdateRecordDeal(ABillsID, fQtyDiffer, fTPDiffer);
  174. CalculatePriceMargin(ABillsID);
  175. if ABillsID = iPriceMarginID then
  176. CalculateGather(ABillsID);
  177. TPhaseData(FPhaseData).PhasePayData.CalculateAll;
  178. end;
  179. procedure TStageData.CalculatePriceChange(ABillsID: Integer);
  180. var
  181. Rec: TsdDataRecord;
  182. fQtyDiffer, fTPDiffer: Double;
  183. begin
  184. Rec := sddStage.FindKey('idxBID', ABillsID);
  185. if GetCalcType(ABillsID) < 2 then
  186. Rec.ValueByName('PcTotalPrice').AsFloat :=
  187. TotalPriceRoundTo(Rec.ValueByName('PcQuantity').AsFloat * GetBillsPriceDiffer(ABillsID));
  188. fQtyDiffer := Rec.ValueByName('PcQuantity').AsFloat - FBeforeChangeQuantity;
  189. fTPDiffer := Rec.ValueByName('PcTotalPrice').AsFloat - FBeforeChangeTotalPrice;
  190. Rec.ValueByName('EndPcQuantity').AsFloat := QuantityRoundTo(
  191. Rec.ValueByName('EndPcQuantity').AsFloat + fQtyDiffer);
  192. Rec.ValueByName('EndPcTotalPrice').AsFloat := TotalPriceRoundTo(
  193. Rec.ValueByName('EndPcTotalPrice').AsFloat + fTPDiffer);
  194. UpdateParentRecord(ABillsID, fTPDiffer, 'PcTotalPrice');
  195. UpdateComplete(ABillsID, 0, fTPDiffer);
  196. if TPhaseData(FPhaseData).IsLastStage then
  197. with TProjectData(TPhaseData(FPhaseData).ProjectData).BillsMeasureData do
  198. UpdateRecordPc(ABillsID, fQtyDiffer, fTPDiffer);
  199. TPhaseData(FPhaseData).PhasePayData.CalculateAll;
  200. end;
  201. procedure TStageData.CalculateQuantityChange(ABillsID: Integer);
  202. var
  203. Rec: TsdDataRecord;
  204. fQtyDiffer, fTPDiffer: Double;
  205. begin
  206. Rec := sddStage.FindKey('idxBID', ABillsID);
  207. if GetCalcType(ABillsID) = 0 then
  208. Rec.ValueByName('QcTotalPrice').AsFloat :=
  209. TotalPriceRoundTo(Rec.ValueByName('QcQuantity').AsFloat * GetBillsPrice(ABillsID));
  210. fQtyDiffer := Rec.ValueByName('QcQuantity').AsFloat - FBeforeChangeQuantity;
  211. fTPDiffer := Rec.ValueByName('QcTotalPrice').AsFloat - FBeforeChangeTotalPrice;
  212. Rec.ValueByName('EndQcQuantity').AsFloat := QuantityRoundTo(
  213. Rec.ValueByName('EndQcQuantity').AsFloat + fQtyDiffer);
  214. Rec.ValueByName('EndQcTotalPrice').AsFloat := TotalPriceRoundTo(
  215. Rec.ValueByName('EndQcTotalPrice').AsFloat + fTPDiffer);
  216. UpdateParentRecord(ABillsID, fTPDiffer, 'QcTotalPrice');
  217. UpdateComplete(ABillsID, fQtyDiffer, fTPDiffer);
  218. if TPhaseData(FPhaseData).IsLastStage then
  219. with TProjectData(TPhaseData(FPhaseData).ProjectData).BillsMeasureData do
  220. UpdateRecordQc(ABillsID, fQtyDiffer, fTPDiffer);
  221. CalculatePriceMargin(ABillsID);
  222. if ABillsID = iPriceMarginID then
  223. CalculateGather(ABillsID);
  224. TPhaseData(FPhaseData).PhasePayData.CalculateAll;
  225. end;
  226. constructor TStageData.Create(APhaseData: TObject);
  227. begin
  228. inherited Create(nil);
  229. FPhaseData := APhaseData;
  230. end;
  231. procedure TStageData.DeletePhaseRecord(ABillsID: Integer);
  232. var
  233. Rec: TsdDataRecord;
  234. begin
  235. Rec := sddStage.FindKey('idxBID', ABillsID);
  236. if Assigned(Rec) then
  237. sddStage.Remove(Rec);
  238. end;
  239. destructor TStageData.Destroy;
  240. begin
  241. inherited;
  242. end;
  243. function TStageData.GetBillsNewPrice(ABillsID: Integer): Double;
  244. begin
  245. Result := MainBillsTree.FindNode(ABillsID).Rec.ValueByName('NewPrice').AsFloat;
  246. end;
  247. function TStageData.GetBillsPrice(ABillsID: Integer): Double;
  248. begin
  249. Result := MainBillsTree.FindNode(ABillsID).Rec.ValueByName('Price').AsFloat;
  250. end;
  251. procedure TStageData.Open(AConnection: TADOConnection);
  252. begin
  253. sdpStage.Connection := AConnection;
  254. sddStage.Open;
  255. if not Assigned(sddStage.IndexList.FindByName('idxBID')) then
  256. sddStage.AddIndex('idxBID', 'BillsID');
  257. sddStage.FieldByName('DealQuantity').ValidChars := sddStage.FieldByName('DealQuantity').ValidChars + ArithmeticCharSet;
  258. sddStage.FieldByName('DealTotalPrice').ValidChars := sddStage.FieldByName('DealQuantity').ValidChars;
  259. end;
  260. function TStageData.StageRecord(ABillsID: Integer): TStageRecord;
  261. begin
  262. Result := nil;
  263. if Assigned(sddStage.IndexList.FindByName('idxBID')) then
  264. Result := TStageRecord(sddStage.FindKey('idxBID', ABillsID));
  265. end;
  266. procedure TStageData.ReCalculate(ABillsID: Integer);
  267. var
  268. Rec: TsdDataRecord;
  269. fDiffer: Double;
  270. begin
  271. Rec := sddStage.FindKey('idxBID', ABillsID);
  272. if not Assigned(Rec) then Exit;
  273. if Rec.ValueByName('DealFlag').AsInteger = 1 then
  274. Rec.ValueByName('DealQuantity').AsFloat := QuantityRoundTo(
  275. EvaluateExprs(Rec.ValueByName('DealFormula').AsString));
  276. if Rec.ValueByName('DealFlag').AsInteger < 2 then
  277. begin
  278. fDiffer := Rec.ValueByName('DealQuantity').AsFloat * GetBillsPrice(ABillsID)
  279. - Rec.ValueByName('DealTotalPrice').AsFloat;
  280. Rec.ValueByName('DealTotalPrice').AsFloat := TotalPriceRoundTo(
  281. Rec.ValueByName('DealQuantity').AsFloat * GetBillsPrice(ABillsID));
  282. end;
  283. Rec.ValueByName('EndDealQuantity').AsFloat := QuantityRoundTo(
  284. Rec.ValueByName('PreDealQuantity').AsFloat + Rec.ValueByName('DealQuantity').AsFloat);
  285. Rec.ValueByName('EndDealTotalPrice').AsFloat := TotalPriceRoundTo(
  286. Rec.ValueByName('PreDealTotalPrice').AsFloat + Rec.ValueByName('DealTotalPrice').AsFloat);
  287. if Rec.ValueByName('QcFlag').AsInteger = 1 then
  288. Rec.ValueByName('QcQuantity').AsFloat := QuantityRoundTo(
  289. EvaluateExprs(Rec.ValueByName('QcFormula').AsString));
  290. if Rec.ValueByName('QcFlag').AsInteger < 2 then
  291. begin
  292. fDiffer := Rec.ValueByName('QcQuantity').AsFloat * GetBillsPrice(ABillsID)
  293. - Rec.ValueByName('QcTotalPrice').AsFloat;
  294. Rec.ValueByName('QcTotalPrice').AsFloat := TotalPriceRoundTo(
  295. Rec.ValueByName('QcQuantity').AsFloat * GetBillsPrice(ABillsID));
  296. end;
  297. Rec.ValueByName('EndQcQuantity').AsFloat := QuantityRoundTo(
  298. Rec.ValueByName('PreQcQuantity').AsFloat + Rec.ValueByName('QcQuantity').AsFloat);
  299. Rec.ValueByName('EndQcTotalPrice').AsFloat := TotalPriceRoundTo(
  300. Rec.ValueByName('PreQcTotalPrice').AsFloat + Rec.ValueByName('QcTotalPrice').AsFloat);
  301. if Rec.ValueByName('PcFlag').AsInteger = 1 then
  302. Rec.ValueByName('PcQuantity').AsFloat := QuantityRoundTo(
  303. EvaluateExprs(Rec.ValueByName('PcFormula').AsString));
  304. if Rec.ValueByName('DealFlag').AsInteger < 2 then
  305. begin
  306. fDiffer := Rec.ValueByName('PcQuantity').AsFloat * GetBillsNewPrice(ABillsID)
  307. - Rec.ValueByName('PcTotalPrice').AsFloat;
  308. Rec.ValueByName('PcTotalPrice').AsFloat := TotalPriceRoundTo(
  309. Rec.ValueByName('PcQuantity').AsFloat * GetBillsNewPrice(ABillsID));
  310. end;
  311. Rec.ValueByName('EndPcQuantity').AsFloat := QuantityRoundTo(
  312. Rec.ValueByName('PrePcQuantity').AsFloat + Rec.ValueByName('PcQuantity').AsFloat);
  313. Rec.ValueByName('EndPcTotalPrice').AsFloat := TotalPriceRoundTo(
  314. Rec.ValueByName('PrePcTotalPrice').AsFloat + Rec.ValueByName('PcTotalPrice').AsFloat);
  315. end;
  316. procedure TStageData.Save;
  317. begin
  318. sddStage.Save;
  319. end;
  320. procedure TStageData.sddStageAfterValueChanged(AValue: TsdValue);
  321. function LeafCurHasMeasure(ANode: TMeasureBillsIDTreeNode): Boolean;
  322. begin
  323. Result := Assigned(ANode.StageRec) and
  324. ((ANode.StageRec.DealQuantity.AsFloat <> 0) or
  325. (ANode.StageRec.DealTotalPrice.AsFloat <> 0) or
  326. (ANode.StageRec.QcQuantity.AsFloat <> 0) or
  327. (ANode.StageRec.QcTotalPrice.AsFloat <> 0) or
  328. (ANode.StageRec.PcQuantity.AsFloat <> 0) or
  329. (ANode.StageRec.PcTotalPrice.AsFloat <> 0));
  330. end;
  331. function ParentCurHasMeasure(ANode: TBillsIDTreeNode): Boolean;
  332. var
  333. i: Integer;
  334. vChild: TBillsIDTreeNode;
  335. begin
  336. Result := False;
  337. for i := 0 to ANode.ChildCount - 1 do
  338. begin
  339. vChild := TMeasureBillsIDTreeNode(ANode.ChildNodes[i]);
  340. if vChild.Rec.CurHasMeasure.AsBoolean then
  341. begin
  342. Result := True;
  343. Break;
  344. end;
  345. end;
  346. end;
  347. procedure RecalcNodeCurHasMeasure(ANode: TBillsIDTreeNode);
  348. begin
  349. if not Assigned(ANode) then Exit;
  350. if ANode.HasChildren then
  351. ANode.Rec.CurHasMeasure.AsBoolean := ParentCurHasMeasure(ANode)
  352. else
  353. ANode.Rec.CurHasMeasure.AsBoolean := LeafCurHasMeasure(TMeasureBillsIDTreeNode(ANode));
  354. RecalcNodeCurHasMeasure(TBillsIDTreeNode(ANode.Parent));
  355. end;
  356. var
  357. iBillsID: Integer;
  358. stnNode: TsdIDTreeNode;
  359. begin
  360. iBillsID := AValue.Owner.ValueByName('BillsID').AsInteger;
  361. stnNode := MainBillsTree.FindNode(iBillsID);
  362. if not Assigned(stnNode) or stnNode.HasChildren then Exit;
  363. if (AValue.FieldName = 'DealQuantity') or
  364. (AValue.FieldName = 'DealFormula') or
  365. (AValue.FieldName = 'DealTotalPrice') then
  366. CalculateDeal(iBillsID);
  367. if (AValue.FieldName = 'QcQuantity') or
  368. (AValue.FieldName = 'QcFormula') or
  369. (AValue.FieldName = 'QcTotalPrice') then
  370. CalculateQuantityChange(iBillsID);
  371. if (AValue.FieldName = 'PcQuantity') or
  372. (AValue.FieldName = 'PcFormula') or
  373. (AValue.FieldName = 'PcTotalPrice') then
  374. CalculatePriceChange(iBillsID);
  375. if (AValue.FieldName = 'DealQuantity') or
  376. (AValue.FieldName = 'QcQuantity') then
  377. UpdateProjectGL(iBillsID);
  378. RecalcNodeCurHasMeasure(TBillsIDTreeNode(stnNode));
  379. end;
  380. function TStageData.GetMainBillsTree: TBillsIDTree;
  381. begin
  382. with TProjectData(TPhaseData(FPhaseData).ProjectData) do
  383. Result := BillsMeasureData.BillsMeasureTree;
  384. end;
  385. procedure TStageData.sddStageBeforeValueChange(AValue: TsdValue;
  386. const NewValue: Variant; var Allow: Boolean);
  387. procedure SetBeforeChangeValue(const AType: string);
  388. begin
  389. if SameText(AValue.FieldName, AType + 'Quantity') or
  390. SameText(AValue.FieldName, AType + 'Formula') or
  391. SameText(AValue.FieldName, AType + 'TotalPrice') then
  392. begin
  393. FBeforeChangeQuantity := AValue.Owner.ValueByName(AType + 'Quantity').AsFloat;
  394. FBeforeChangeTotalPrice := AValue.Owner.ValueByName(AType + 'TotalPrice').AsFloat;
  395. end;
  396. end;
  397. procedure CheckOverRange;
  398. var
  399. vNode: TsdIDTreeNode;
  400. fAvailableQty: Double;
  401. begin
  402. if SameText(AValue.FieldName, 'DealQuantity') then
  403. begin
  404. vNode := MainBillsTree.FindNode(AValue.Owner.ValueByName('BillsID').AsInteger);
  405. fAvailableQty := vNode.Rec.ValueByName('Quantity').AsFloat
  406. - vNode.Rec.ValueByName('AddDealQuantity').AsFloat + AValue.AsFloat;
  407. if VarToFloatDef(NewValue, 0) > fAvailableQty then
  408. DataSetErrorMessage(Allow, '不可超过0号台账合同数量!');
  409. end;
  410. end;
  411. begin
  412. // 不检查超计
  413. //CheckOverRange;
  414. SetBeforeChangeValue('Deal');
  415. SetBeforeChangeValue('Qc');
  416. SetBeforeChangeValue('Pc');
  417. end;
  418. procedure TStageData.AfterBatchOperation;
  419. begin
  420. sddStage.EndUpdate;
  421. sddStage.BeforeValueChange := sddStageBeforeValueChange;
  422. sddStage.AfterValueChanged := sddStageAfterValueChanged;
  423. end;
  424. procedure TStageData.BeforeBatchOperation;
  425. begin
  426. sddStage.BeginUpdate;
  427. sddStage.BeforeValueChange := nil;
  428. sddStage.AfterValueChanged := nil;
  429. end;
  430. function TStageData.GetBillsPriceDiffer(ABillsID: Integer): Double;
  431. begin
  432. with MainBillsTree.FindNode(ABillsID).Rec do
  433. Result := ValueByName('NewPrice').AsFloat - ValueByName('Price').AsFloat;
  434. end;
  435. procedure TStageData.UpdateComplete(ABillsID: Integer; AQuantity,
  436. ATotalPrice: Double);
  437. var
  438. Rec: TStageRecord;
  439. begin
  440. if ABillsID = -1 then Exit;
  441. Rec := StageRecord(ABillsID);
  442. Rec.GatherQuantity.AsFloat := QuantityRoundTo(Rec.GatherQuantity.AsFloat + AQuantity);
  443. Rec.GatherTotalPrice.AsFloat := TotalPriceRoundTo(Rec.GatherTotalPrice.AsFloat + ATotalPrice);
  444. Rec.EndGatherQuantity.AsFloat := QuantityRoundTo(Rec.EndGatherQuantity.AsFloat + AQuantity);
  445. Rec.EndGatherTotalPrice.AsFloat := TotalPriceRoundTo(Rec.EndGatherTotalPrice.AsFloat + ATotalPrice);
  446. // 数量不向上汇总
  447. UpdateParentRecord(ABillsID, ATotalPrice, 'GatherTotalPrice');
  448. end;
  449. procedure TStageData.UpdateParentRecord(ABillsID: Integer;
  450. ATotalPrice: Double; const AFieldName: string);
  451. var
  452. vNode: TMeasureBillsIDTreeNode;
  453. iParentID: Integer;
  454. Rec: TsdDataRecord;
  455. begin
  456. iParentID := MainBillsTree.FindNode(ABillsID).ParentID;
  457. if iParentID = -1 then Exit;
  458. vNode := TMeasureBillsIDTreeNode(MainBillsTree.FindNode(iParentID));
  459. Rec := StageRecordWithAdd(iParentID);
  460. vNode.StageRec := TStageRecord(Rec);
  461. Rec.ValueByName(AFieldName).AsFloat := TotalPriceRoundTo(
  462. Rec.ValueByName(AFieldName).AsFloat + ATotalPrice);
  463. Rec.ValueByName('End' + AFieldName).AsFloat := TotalPriceRoundTo(
  464. Rec.ValueByName('End' + AFieldName).AsFloat + ATotalPrice);
  465. UpdateParentRecord(iParentID, ATotalPrice, AFieldName);
  466. end;
  467. function TStageData.GetBuildLoadInterest(AType, AIndex: Integer): Double;
  468. begin
  469. Result := GetTotalPrice(34, AType, AIndex);
  470. end;
  471. function TStageData.GetFirstPart(AType, AIndex: Integer): Double;
  472. begin
  473. Result := GetTotalPrice(1, AType, AIndex);
  474. end;
  475. function TStageData.GetOtherFee(AType, AIndex: Integer): Double;
  476. begin
  477. Result := GetTotalPrice(15, AType, AIndex);
  478. end;
  479. function TStageData.GetOtherProjectFee(AType, AIndex: Integer): Double;
  480. begin
  481. Result := GetTotalPrice(9, AType, AIndex);
  482. end;
  483. function TStageData.GetRecyclingFee(AType, AIndex: Integer): Double;
  484. begin
  485. Result := GetTotalPrice(16, AType, AIndex);
  486. end;
  487. function TStageData.GetReservedFee(AType, AIndex: Integer): Double;
  488. begin
  489. Result := GetTotalPrice(7, AType, AIndex);
  490. end;
  491. function TStageData.GetSecondPart(AType, AIndex: Integer): Double;
  492. begin
  493. Result := GetTotalPrice(2, AType, AIndex);
  494. end;
  495. function TStageData.GetStageSettlement(AType, AIndex: Integer): Double;
  496. begin
  497. // 全国
  498. // 第一部分+第二部分+第三部分+预备费+新增加费用项目(其他费用_广东)-回收金额
  499. Result := FirstPart[AType, AIndex] + SecondPart[AType, AIndex] + ThirdPart[AType, AIndex]
  500. + ReservedFee[AType, AIndex] + OtherFee[AType, AIndex] - RecyclingFee[AType, AIndex];
  501. // 广东
  502. // 全国的基础上+建设期贷款利息+公路功能以外的项目
  503. if _IsGuangDong then
  504. Result := Result + BuildLoadInterest[AType, AIndex] + OtherProjectFee[AType, AIndex]
  505. end;
  506. function TStageData.GetThirdPart(AType, AIndex: Integer): Double;
  507. begin
  508. Result := GetTotalPrice(3, AType, AIndex);
  509. end;
  510. function TStageData.GetTotalPrice(ABillsID, AType, AStageIndex: Integer): Double;
  511. var
  512. Rec: TsdDataRecord;
  513. sFieldName: string;
  514. begin
  515. Result := 0;
  516. Rec := StageRecord(ABillsID);
  517. if not Assigned(Rec) then Exit;
  518. case AType of
  519. 1: sFieldName := '';
  520. 2: sFieldName := 'End';
  521. 3: sFieldName := 'Pre';
  522. end;
  523. case AStageIndex of
  524. 1: sFieldName := sFieldName + 'DealTotalPrice';
  525. 2: sFieldName := sFieldName + 'QcTotalPrice';
  526. 3: sFieldName := sFieldName + 'PcTotalPrice';
  527. 4: sFieldName := sFieldName + 'GatherTotalPrice';
  528. end;
  529. Result := Rec.ValueByName(sFieldName).AsFloat;
  530. end;
  531. procedure TStageData.CopyPrePhaseData;
  532. var
  533. iRecord: Integer;
  534. Rec: TBillsRecord;
  535. NewRec: TStageRecord;
  536. begin
  537. BeforeBatchOperation;
  538. try
  539. with TProjectData(TPhaseData(FPhaseData).ProjectData).BillsData do
  540. for iRecord := 0 to sddBills.RecordCount - 1 do
  541. begin
  542. Rec := TBillsRecord(sddBills.Records[iRecord]);
  543. if (Rec.AddGatherTotalPrice.AsFloat = 0) and
  544. (Rec.AddDealTotalPrice.AsFloat = 0) and
  545. (Rec.AddQcTotalPrice.AsFloat = 0) and
  546. (Rec.AddPcTotalPrice.AsFloat = 0) and
  547. (Rec.PM_AddTotalPrice.AsFloat = 0) then Continue;
  548. NewRec := TStageRecord(sddStage.Add);
  549. NewRec.BillsID.AsInteger := Rec.ID.AsInteger;
  550. NewRec.EndDealQuantity.AsFloat := Rec.AddDealQuantity.AsFloat;
  551. NewRec.EndDealTotalPrice.AsFloat := Rec.AddDealTotalPrice.AsFloat;
  552. NewRec.EndQcQuantity.AsFloat := Rec.AddQcQuantity.AsFloat;
  553. NewRec.EndQcTotalPrice.AsFloat := Rec.AddQcTotalPrice.AsFloat;
  554. NewRec.EndQcBGLCode.AsString := Rec.AddQcBGLCode.AsString;
  555. NewRec.EndQcBGLNum.AsString := Rec.AddQcBGLNum.AsString;
  556. NewRec.EndPcQuantity.AsFloat := Rec.AddPcQuantity.AsFloat;
  557. NewRec.EndPcTotalPrice.AsFloat := Rec.AddPcTotalPrice.AsFloat;
  558. NewRec.EndPcBGLCode.AsString := Rec.AddPcBGLCode.AsString;
  559. NewRec.EndPcBGLNum.AsString := Rec.AddPcBGLNum.AsString;
  560. NewRec.EndGatherQuantity.AsFloat := Rec.AddGatherQuantity.AsFloat;
  561. NewRec.EndGatherTotalPrice.AsFloat := Rec.AddGatherTotalPrice.AsFloat;
  562. NewRec.PreDealQuantity.AsFloat := Rec.AddDealQuantity.AsFloat;
  563. NewRec.PreDealTotalPrice.AsFloat := Rec.AddDealTotalPrice.AsFloat;
  564. NewRec.PreQcQuantity.AsFloat := Rec.AddQcQuantity.AsFloat;
  565. NewRec.PreQcTotalPrice.AsFloat := Rec.AddQcTotalPrice.AsFloat;
  566. NewRec.PreQcBGLCode.AsString := Rec.AddQcBGLCode.AsString;
  567. NewRec.PreQcBGLNum.AsString := Rec.AddQcBGLNum.AsString;
  568. NewRec.PrePcQuantity.AsFloat := Rec.AddPcQuantity.AsFloat;
  569. NewRec.PrePcTotalPrice.AsFloat := Rec.AddPcTotalPrice.AsFloat;
  570. NewRec.PrePcBGLCode.AsString := Rec.AddPcBGLCode.AsString;
  571. NewRec.PrePcBGLNum.AsString := Rec.AddPcBGLNum.AsString;
  572. NewRec.PreGatherQuantity.AsFloat := Rec.AddGatherQuantity.AsFloat;
  573. NewRec.PreGatherTotalPrice.AsFloat := Rec.AddGatherTotalPrice.AsFloat;
  574. NewRec.PM_PreTotalPrice.AsFloat := Rec.PM_AddTotalPrice.AsFloat;
  575. end;
  576. finally
  577. AfterBatchOperation;
  578. end;
  579. end;
  580. procedure TStageData.UpdateBGLInfo(ARec: TsdDataRecord; const AType: string);
  581. var
  582. sPreBGLCode, sPreBGLNum, sCurBGLCode, sCurBGLNum: string;
  583. begin
  584. sPreBGLCode := ARec.ValueByName('Pre' + AType + 'BGLCode').AsString;
  585. sPreBGLNum := ARec.ValueByName('Pre' + AType + 'BGLNum').AsString;
  586. sCurBGLCode := ARec.ValueByName(AType + 'BGLCode').AsString;
  587. sCurBGLNum := ARec.ValueByName(AType + 'BGLNum').AsString;
  588. MergeRelaBGLAndNum(sPreBGLCode, sPreBGLNum, sCurBGLCode, sCurBGLNum);
  589. ARec.ValueByName('End' + AType + 'BGLCode').AsString := sPreBGLCode;
  590. ARec.ValueByName('End' + AType + 'BGLNum').AsString := sPreBGLNum;
  591. end;
  592. procedure TStageData.CalculateAll;
  593. begin
  594. BeforeBatchOperation;
  595. CalculateNode(MainBillsTree.FirstNode);
  596. AfterBatchOperation;
  597. end;
  598. procedure TStageData.CalculateNode(ANode: TsdIDTreeNode);
  599. function IsSpecialNode: Boolean;
  600. begin
  601. //Result := ANode.ID = iPriceMarginID;
  602. Result := False;
  603. end;
  604. begin
  605. if not Assigned(ANode) then Exit;
  606. if ANode.HasChildren then
  607. begin
  608. CalculateNode(ANode.FirstChild);
  609. CalculateParent(TMeasureBillsIDTreeNode(ANode));
  610. end
  611. else
  612. begin
  613. if IsSpecialNode then
  614. CalculateSpecialLeaf(TMeasureBillsIDTreeNode(ANode))
  615. else
  616. CalculateLeaf(TMeasureBillsIDTreeNode(ANode));
  617. end;
  618. CalculateNode(ANode.NextSibling);
  619. end;
  620. procedure TStageData.CalculateParent(ANode: TMeasureBillsIDTreeNode);
  621. var
  622. iChild: Integer;
  623. ChildNode: TMeasureBillsIDTreeNode;
  624. fDeal, fQc, fPc, fTotal, fPM: Double;
  625. begin
  626. if not Assigned(ANode.StageRec) then
  627. ANode.StageRec := AddStageRecord(ANode.ID);
  628. fDeal := 0;
  629. fQc := 0;
  630. fPc := 0;
  631. fPM := 0;
  632. for iChild := 0 to ANode.ChildCount - 1 do
  633. begin
  634. ChildNode := TMeasureBillsIDTreeNode(ANode.ChildNodes[iChild]);
  635. if not Assigned(ChildNode.StageRec) then Continue;
  636. fDeal := TotalPriceRoundTo(fDeal + ChildNode.StageRec.DealTotalPrice.AsFloat);
  637. fQc := TotalPriceRoundTo(fQc + ChildNode.StageRec.QcTotalPrice.AsFloat);
  638. fPc := TotalPriceRoundTo(fPc + ChildNode.StageRec.PcTotalPrice.AsFloat);
  639. fPM := TotalPriceRoundTo(fPM + ChildNode.StageRec.PM_TotalPrice.AsFloat);
  640. end;
  641. fTotal := TotalPriceRoundTo(fDeal + fQc + fPc);
  642. with ANode.StageRec do
  643. begin
  644. if DealTotalPrice.AsFloat <> fDeal then
  645. begin
  646. DealTotalPrice.AsFloat := fDeal;
  647. EndDealTotalPrice.AsFloat := TotalPriceRoundTo(PreDealTotalPrice.AsFloat + fDeal);
  648. end;
  649. if QcTotalPrice.AsFloat <> fQc then
  650. begin
  651. QcTotalPrice.AsFloat := fQc;
  652. EndQcTotalPrice.AsFloat := TotalPriceRoundTo(PreQcTotalPrice.AsFloat + fQc);
  653. end;
  654. if PcTotalPrice.AsFloat <> fPc then
  655. begin
  656. PcTotalPrice.AsFloat := fPc;
  657. EndPcTotalPrice.AsFloat := TotalPriceRoundTo(PrePcTotalPrice.AsFloat + fPc);
  658. end;
  659. if GatherTotalPrice.AsFloat <> fTotal then
  660. begin
  661. GatherTotalPrice.AsFloat := fTotal;
  662. EndGatherTotalPrice.AsFloat := TotalPriceRoundTo(PreGatherTotalPrice.AsFloat + fTotal);
  663. end;
  664. if PM_TotalPrice.AsFloat <> fPM then
  665. PM_TotalPrice.AsFloat := fPM;
  666. end;
  667. end;
  668. procedure TStageData.CalculateLeaf(ANode: TMeasureBillsIDTreeNode);
  669. procedure CalculateMeasure(ARec: TsdDataRecord; const AType: string);
  670. begin
  671. if GetCalcType(ANode.ID) = 0 then
  672. begin
  673. if ARec.ValueByName(AType + 'Formula').AsString <> '' then
  674. ARec.ValueByName(AType + 'Quantity').AsFloat :=
  675. EvaluateExprs(ARec.ValueByName(AType + 'Formula').AsString);
  676. ARec.ValueByName(AType + 'TotalPrice').AsFloat := TotalPriceRoundTo(
  677. ARec.ValueByName(AType + 'Quantity').AsFloat * GetBillsPrice(ANode.ID));
  678. end;
  679. ARec.ValueByName('End' + AType + 'Quantity').AsFloat := QuantityRoundTo(
  680. ARec.ValueByName('Pre' + AType + 'Quantity').AsFloat + ARec.ValueByName(AType + 'Quantity').AsFloat);
  681. ARec.ValueByName('End' + AType + 'TotalPrice').AsFloat := TotalPriceRoundTo(
  682. ARec.ValueByName('Pre' + AType + 'TotalPrice').AsFloat + ARec.ValueByName(AType + 'TotalPrice').AsFloat);
  683. end;
  684. procedure CalculatePriceMargin(ARec: TStageRecord);
  685. var
  686. fPrice: Double;
  687. begin
  688. fPrice := GetBillsUnitPriceMargin(ARec.BillsID.AsInteger);
  689. ARec.SetFloatValue(ARec.PM_TotalPrice, TotalPriceRoundTo(ARec.GatherQuantity.AsFloat * fPrice));
  690. end;
  691. var
  692. Rec: TStageRecord;
  693. begin
  694. Rec := ANode.StageRec;
  695. if not Assigned(Rec) then Exit;
  696. CalculateMeasure(Rec, 'Deal');
  697. CalculateMeasure(Rec, 'Pc');
  698. CalculateMeasure(Rec, 'Qc');
  699. Rec.GatherQuantity.AsFloat := QuantityRoundTo(
  700. Rec.DealQuantity.AsFloat + Rec.QcQuantity.AsFloat);
  701. Rec.GatherTotalPrice.AsFloat := TotalPriceRoundTo(
  702. Rec.DealTotalPrice.AsFloat + Rec.QcTotalPrice.AsFloat + Rec.PcTotalPrice.AsFloat);
  703. Rec.EndGatherQuantity.AsFloat := QuantityRoundTo(
  704. Rec.PreGatherQuantity.AsFloat + Rec.GatherQuantity.AsFloat);
  705. Rec.EndGatherTotalPrice.AsFloat := TotalPriceRoundTo(
  706. Rec.PreGatherTotalPrice.AsFloat + Rec.GatherTotalPrice.AsFloat);
  707. CalculatePriceMargin(Rec);
  708. end;
  709. function TStageData.GetActive: Boolean;
  710. begin
  711. Result := sddStage.Active;
  712. end;
  713. procedure TStageData.SetTableName(const Value: string);
  714. begin
  715. sdpStage.TableName := Value;
  716. end;
  717. procedure TStageData.sddStageGetRecordClass(
  718. var ARecordClass: TsdRecordClass);
  719. begin
  720. ARecordClass := TStageRecord;
  721. end;
  722. function TStageData.GetChapterStageGather(AChapter: Integer): Double;
  723. function CheckCodeChapter(const ACode: string): Boolean;
  724. var
  725. iFirst: Integer;
  726. sgs: TStrings;
  727. begin
  728. sgs := TStringList.Create;
  729. try
  730. sgs.Delimiter := '-';
  731. sgs.DelimitedText := ACode;
  732. if sgs.Count > 1 then
  733. begin
  734. iFirst := StrToIntDef(sgs[0], 0) div 100;
  735. Result := iFirst = AChapter;
  736. end
  737. else
  738. Result := False;
  739. finally
  740. sgs.Free;
  741. end;
  742. end;
  743. var
  744. iIndex: Integer;
  745. Rec: TsdDataRecord;
  746. stnNode: TsdIDTreeNode;
  747. begin
  748. Result := 0;
  749. for iIndex := 0 to sddStage.RecordCount - 1 do
  750. begin
  751. Rec := sddStage.Records[iIndex];
  752. stnNode := MainBillsTree.FindNode(Rec.ValueByName('BillsID').AsInteger);
  753. if not stnNode.HasChildren and CheckCodeChapter(stnNode.Rec.ValueByName('B_Code').AsString) then
  754. Result := Result + Rec.ValueByName('GatherTotalPrice').AsFloat;
  755. end;
  756. end;
  757. function TStageData.GetCalcType(ABillsID: Integer): Integer;
  758. begin
  759. Result := MainBillsTree.FindNode(ABillsID).Rec.ValueByName('CalcType').AsInteger;
  760. end;
  761. procedure TStageData.CalculatePriceMarginNode;
  762. var
  763. Rec: TStageRecord;
  764. fDiffer: Double;
  765. begin
  766. if not HasPriceMarginBills then Exit;
  767. with TProjectData(TPhaseData(FPhaseData).ProjectData) do
  768. begin
  769. Rec := StageRecord(iPriceMarginID);
  770. if not Assigned(Rec) then
  771. Rec := AddStageRecord(iPriceMarginID);
  772. fDiffer := TotalPriceRoundTo(ProjectGLData.PM_TotalPrice - Rec.GatherTotalPrice.AsFloat);
  773. if fDiffer <> 0 then
  774. begin
  775. Rec.AddDifferValue(Rec.GatherTotalPrice, fDiffer);
  776. Rec.AddDifferValue(Rec.EndGatherTotalPrice, fDiffer);
  777. UpdateParentRecord(Rec.BillsID.AsInteger, fDiffer, 'GatherTotalPrice');
  778. end;
  779. end;
  780. end;
  781. function TStageData.GetBillsUnitPriceMargin(ABillsID: Integer): Double;
  782. var
  783. vGLs: TList;
  784. iGL: Integer;
  785. GLRec: TDetailGLRecord;
  786. begin
  787. Result := 0;
  788. vGLs := TList.Create;
  789. try
  790. with TProjectData(TPhaseData(FPhaseData).ProjectData).DetailGLData do
  791. LoadDetailGLs(ABillsID, vGLs);
  792. for iGL := 0 to vGLs.Count - 1 do
  793. begin
  794. GLRec := TDetailGLRecord(vGLs.Items[iGL]);
  795. Result := Result + GLRec.Quantity.AsFloat * GLRec.RelaProjectGL.ValidDeltaPrice.AsFloat;
  796. end;
  797. finally
  798. vGLs.Free;
  799. end;
  800. end;
  801. procedure TStageData.CalculatePriceMargin(ABillsID: Integer);
  802. var
  803. Rec: TStageRecord;
  804. fPM, fPMDiffer: Double;
  805. begin
  806. //if not HasPriceMarginBills then Exit;
  807. Rec := StageRecord(ABillsID);
  808. if not Assigned(Rec) then Exit;
  809. fPM := TotalPriceRoundTo(Rec.GatherQuantity.AsFloat * GetBillsUnitPriceMargin(ABillsID));
  810. if fPM <> Rec.PM_TotalPrice.AsFloat then
  811. begin
  812. fPMDiffer := fPM - Rec.PM_TotalPrice.AsFloat;
  813. Rec.PM_TotalPrice.AsFloat := fPM;
  814. UpdateParentPriceMargin(ABillsID, fPMDiffer);
  815. //UpdatePriceMarginNode(fPMDiffer);
  816. with TProjectData(TPhaseData(FPhaseData).ProjectData).BillsMeasureData do
  817. UpdateRecordPM(ABillsID, fPMDiffer);
  818. end;
  819. end;
  820. procedure TStageData.UpdatePriceMarginNode(ADiffer: Double);
  821. var
  822. Rec: TStageRecord;
  823. begin
  824. Rec := StageRecordWithAdd(iPriceMarginID);
  825. Rec.AddDifferValue(Rec.GatherTotalPrice, ADiffer);
  826. Rec.AddDifferValue(Rec.EndGatherTotalPrice, ADiffer);
  827. UpdateParentRecord(iPriceMarginID, ADiffer, 'GatherTotalPrice');
  828. with TProjectData(TPhaseData(FPhaseData).ProjectData).BillsMeasureData do
  829. UpdateGather(Rec.BillsID.AsInteger, ADiffer);
  830. end;
  831. procedure TStageData.UpdateParentPriceMargin(ABillsID: Integer; ADiffer: Double);
  832. var
  833. iParentID: Integer;
  834. Rec: TStageRecord;
  835. begin
  836. iParentID := MainBillsTree.FindNode(ABillsID).ParentID;
  837. if iParentID = -1 then Exit;
  838. Rec := StageRecordWithAdd(iParentID);
  839. Rec.PM_TotalPrice.AsFloat := TotalPriceRoundTo(Rec.PM_TotalPrice.AsFloat + ADiffer);
  840. UpdateParentPriceMargin(iParentID, ADiffer);
  841. end;
  842. function TStageData.StageRecordWithAdd(ABillsID: Integer): TStageRecord;
  843. begin
  844. Result := StageRecord(ABillsID);
  845. if not Assigned(Result) then
  846. Result := AddStageRecord(ABillsID);
  847. end;
  848. procedure TStageData.UpdateProjectGL(ABillsID: Integer);
  849. var
  850. vGLs: TList;
  851. iGL: Integer;
  852. GLRec: TDetailGLRecord;
  853. begin
  854. vGLs := TList.Create;
  855. try
  856. with TProjectData(TPhaseData(FPhaseData).ProjectData) do
  857. begin
  858. DetailGLData.LoadDetailGLs(ABillsID, vGLs);
  859. ProjectGLData.CalculateGLs_PM(vGLs);
  860. ProjectGLData.RefreshGatherData;
  861. end;
  862. finally
  863. vGLs.Free;
  864. end;
  865. end;
  866. procedure TStageData.CalculateSpecialLeaf(ANode: TMeasureBillsIDTreeNode);
  867. procedure GatherPriceMargin(ARec: TStageRecord);
  868. begin
  869. with TProjectData(TPhaseData(FPhaseData).ProjectData).ProjectGLData do
  870. ARec.SetFloatValue(ARec.GatherTotalPrice, PM_TotalPrice);
  871. ARec.SetFloatValue(ARec.EndGatherTotalPrice,
  872. ARec.PreGatherTotalPrice.AsFloat + ARec.GatherTotalPrice.AsFloat);
  873. end;
  874. var
  875. StageRec: TStageRecord;
  876. begin
  877. StageRec := ANode.StageRec;
  878. if not Assigned(StageRec) then Exit;
  879. case ANode.ID of
  880. iPriceMarginID: GatherPriceMargin(StageRec);
  881. end;
  882. end;
  883. function TStageData.HasPriceMarginBills: Boolean;
  884. var
  885. vPM_Node: TsdIDTreeNode;
  886. begin
  887. vPM_Node := MainBillsTree.FindNode(iPriceMarginID);
  888. Result := Assigned(vPM_Node);
  889. end;
  890. procedure TStageData.CalculateGather(ABillsID: Integer);
  891. var
  892. Rec: TStageRecord;
  893. fQuantity, fTotalPrice: Double;
  894. begin
  895. Rec := TStageRecord(sddStage.FindKey('idxBID', ABillsID));
  896. if not Assigned(Rec) then Exit;
  897. fQuantity := QuantityRoundTo(Rec.DealQuantity.AsFloat + Rec.QcQuantity.AsFloat) - Rec.GatherQuantity.AsFloat;
  898. fTotalPrice := TotalPriceRoundTo(
  899. Rec.DealTotalPrice.AsFloat + Rec.QcTotalPrice.AsFloat + Rec.PcTotalPrice.AsFloat) - Rec.GatherTotalPrice.AsFloat;
  900. UpdateComplete(ABillsID, fQuantity, fTotalPrice);
  901. end;
  902. function TStageData.GetPriceMargin(AType, AIndex: Integer): Double;
  903. begin
  904. Result := GetTotalPrice(iPriceMarginID, AType, AIndex);
  905. end;
  906. end.