function CellEndEdit(e) {
var record = e.record;//当前行
var gridList = mini.get("CJ_PAY_ProjectGauge_Content"); //子表的表格
if (e.field == "ContractorDeclare" || e.field == "SupervisorApproval" || e.field == "OwnerApproval" || e.field == "CurrentFiles") {
//输入子表业主本期核准量时同步更新本期审计量
var OwnerApproval = parseFloat(record["OwnerApproval"]); //业主本期核准量
gridList.updateRow(record, { CurrentFiles: (OwnerApproval) });//更新本期审计量
//子表内容汇总到主表
var d = gridList.data;
var CContractorDeclare = 0;
var CSupervisorApproval = 0;
var COwnerApproval = 0;
var CCurrentFiles = 0
for (var i = 0; i < d.length; i++) {
CContractorDeclare += parseFloat(d[i].ContractorDeclare);
CSupervisorApproval += parseFloat(d[i].SupervisorApproval);
COwnerApproval += parseFloat(d[i].OwnerApproval);
CCurrentFiles += parseFloat(d[i].CurrentFiles);
}
// 主表承包商本期申报量(元)
mini.get("CJ_PAY_ProjectGauge.ContractorDeclare").setValue(CContractorDeclare);
// 主表监理本期核准量(元)
mini.get("CJ_PAY_ProjectGauge.SupervisorApproval").setValue(CSupervisorApproval);
// 主表业主本期核准量(元)
mini.get("CJ_PAY_ProjectGauge.OwnerApproval").setValue(COwnerApproval);
// 主表本期审计量(元)
mini.get("CJ_PAY_ProjectGauge.CurrentFiles").setValue(CCurrentFiles);
//主表合同未完成量:合同总金额 - 累计完成量
mini.get("ContractCompleted").setValue(mini.get("ContractGrandTotal").getValue() - mini.get("CJ_PAY_ProjectGauge.CumulativeCompletion").getValue());
}
}
Joker3211910
BekeyChao
随时随地看视频慕课网APP
相关分类