private void GetData()
{
string path = "App\\data\\" + this.ProjectName + ".est";
this.limit = new BudgetaryUpperLimit(this.ProjectName);
this.ProjectCode = limit.ProjectCode;
this.MaxBudgetWithoutTax = limit.MaxBudgetWithoutTax;
this.MaxBudgetWithTax = limit.MaxBudgetWithTax;
DataTable dt = XmlHelper.GetTable(path, XmlHelper.XmlType.File, "Configure");
this.CompositeTaxRate = GetDouble(dt.DefaultView[0]["CompositeTaxRate"].ToString().Replace("%", ""));
dt = XmlHelper.GetTable(path, XmlHelper.XmlType.File, "DepartmentBudgetFilled");
this.DepartmentFilledBudgetWithTax = GetDouble(dt.DefaultView[0]["DepartmentFilledBudgetWithTax"]);
}
//预算上限计算表
public void PrintOneBudgetaryUpperLimitBlock(BudgetaryUpperLimit limit)
{
worksheet.Cells[curerntRow, "A"] = limit.ProjectCode;
worksheet.Cells[curerntRow, "B"] = limit.ProjectName;
worksheet.Cells[curerntRow, "C"] = limit.AccumulativePlan;
worksheet.Cells[curerntRow, "D"] = limit.ErpHappenedWithoutTax;
worksheet.Cells[curerntRow, "E"] = limit.DeductibleVAT;
Range rng = worksheet.Range["A" + curerntRow.ToString(), "E" + curerntRow.ToString()];
excelHelper.SetRangeBodersStyle(rng, 1);
excelHelper.SetRangeBodersThickness(rng, XlBorderWeight.xlThin);
excelHelper.SetRowHeight(rng, 20);
excelHelper.SetFontHVCenter(rng);
rng = worksheet.Range["C" + curerntRow.ToString(), "E" + curerntRow.ToString()];
excelHelper.SetRangeValueStyleNumber(rng, "#,##0.00");
curerntRow++;
}
