public static void CostBudgetDtlCalcAllRow(DataTable tb, m_DynamicRowType RowType, DataRow drArea, int iStartY, int iEndY) { try { foreach (DataRow row in tb.Rows) { CostBudgetDtlCalcField(row, RowType, drArea, iStartY, iEndY); } } catch (Exception exception) { throw exception; } }
public static void CostBudgetDtlCalcField(DataRow dr, m_DynamicRowType RowType, DataRow drArea, int iStartY, int iEndY) { try { dr["ContractTotalMoney"] = (ConvertRule.ToDecimal(dr["ContractMoney"]) + ConvertRule.ToDecimal(dr["ContractChangeMoney"])) + ConvertRule.ToDecimal(dr["ContractApplyMoney"]); if ((RowType == m_DynamicRowType.CBS) && dr.Table.Columns.Contains("ContractBudgetBalance")) { dr["ContractBudgetBalance"] = ConvertRule.ToDecimal(dr["ContractTotalMoney"]) - ConvertRule.ToDecimal(dr["BudgetMoney"]); } dr["ContractPayBalance"] = ConvertRule.ToDecimal(dr["ContractTotalMoney"]) - ConvertRule.ToDecimal(dr["ContractPay"]); dr["ContractPayRealBalance"] = ConvertRule.ToDecimal(dr["ContractPay"]) - ConvertRule.ToDecimal(dr["ContractPayReal"]); CalcPercent(dr, drArea); } catch (Exception exception) { throw exception; } }