protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable reportTable = this.getReportTable();
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
list.Add(ExcelHeader.Create("本月数", 1, 6, 3, 0));
list.Add(ExcelHeader.Create("累计数", 1, 6, 9, 0));
list.Add(ExcelHeader.Create("目标成本", 2, 2, 3, 0));
list.Add(ExcelHeader.Create("实际成本", 2, 2, 5, 0));
list.Add(ExcelHeader.Create("目标成本 ", 2, 2, 9, 0));
list.Add(ExcelHeader.Create("实际成本 ", 2, 2, 11, 0));
foreach (DataColumn dataColumn in reportTable.Columns)
{
if ((dataColumn.Ordinal > 2 && dataColumn.Ordinal <= 6) || (dataColumn.Ordinal >= 9 && dataColumn.Ordinal <= 12))
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 3, 0, 0, 0));
}
else
{
if (dataColumn.Ordinal <= 2)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 3, 0, 0, 3));
}
else
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 3, 0, 0, 2));
}
}
}
ExcelHelper.ExportExcel(reportTable, "目标成本执行情况分析", "目标成本执行情况分析", "目标成本执行情况分析.xls", list, null, 1, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
int?depId = null;
if (!string.IsNullOrEmpty(this.tvwDep.SelectedValue.Trim()))
{
depId = new int?(System.Convert.ToInt32(this.tvwDep.SelectedValue.Trim()));
}
DataTable table = this.GetTable(depId, 0, 0);
DataTable dataTable = this.Replace(table);
if (table.Rows.Count > 0)
{
int days = this.GetDays();
DataRow dataRow = dataTable.NewRow();
dataRow["v_xm"] = "合计";
for (int i = 1; i <= days; i++)
{
dataRow[i + 2] = table.Compute("sum([" + i.ToString() + "])", "1>0").ToString();
}
dataRow["TotalLeaveDays"] = table.Compute("sum(TotalLeaveDays)", "1>0");
dataTable.Rows.Add(dataRow);
}
dataTable = this.GetTitleByTable(dataTable);
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
foreach (DataColumn dataColumn in dataTable.Columns)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 1, 0, 0, 0));
}
ExcelHelper.ExportExcel(dataTable, "人员请假统计表", "人员请假统计表", "人员请假统计表.xls", list, null, 0, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable reportTable = this.getReportTable();
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
list.Add(ExcelHeader.Create("本月数", 1, 4, 2, 0));
list.Add(ExcelHeader.Create("累计数", 1, 4, 6, 0));
foreach (DataColumn dataColumn in reportTable.Columns)
{
if (dataColumn.Ordinal >= 2)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 0));
}
else
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 2));
}
}
System.Collections.Generic.List <int> list2 = new System.Collections.Generic.List <int>();
list2.Add(2);
list2.Add(3);
list2.Add(6);
list2.Add(7);
ExcelHelper.ExportExcel(reportTable, "机械费分析表", "机械费分析表", "机械费分析表.xls", list, null, 2, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable completedMonthlyReport = EReport.GetCompletedMonthlyReport(this.taskId, System.Convert.ToDateTime(this.date), this.hfldIsWBSRelevance.Value);
DataTable dataTable = this.formatData(completedMonthlyReport, true);
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
list.Add(ExcelHeader.Create("金额(元)", 1, 2, 5, 0));
list.Add(ExcelHeader.Create("上期末完成", 1, 2, 7, 0));
list.Add(ExcelHeader.Create("本期完成", 1, 2, 9, 0));
list.Add(ExcelHeader.Create("本期末完成", 1, 2, 11, 0));
System.Collections.Generic.List <int> list2 = new System.Collections.Generic.List <int>();
foreach (DataColumn dataColumn in dataTable.Columns)
{
if (dataColumn.Ordinal >= 4)
{
list2.Add(dataColumn.Ordinal);
}
if (dataColumn.Ordinal < 4)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 2));
}
else
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 0));
}
}
ExcelHelper.ExportExcel(dataTable, this.title, this.title, this.title + ".xls", list, null, 0, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable dataTable = new DataTable();
dataTable = ConstructReport.GetLaborAnalysis(this.txtTaskCode.Text.Trim(), this.txtTaskName.Text.Trim(), this.prjId, 0, 0);
if (dataTable.Rows.Count > 0)
{
DataRow dataRow = dataTable.NewRow();
dataRow["Num"] = "合计";
dataRow["CurrentLaborBudCost"] = dataTable.Compute("sum(CurrentLaborBudCost)", "1>0");
dataRow["CurrentLaborConsCost"] = dataTable.Compute("sum(CurrentLaborConsCost)", "1>0");
dataRow["CurrentReductionAmount"] = dataTable.Compute("sum(CurrentReductionAmount)", "1>0");
dataRow["LaborBudCost"] = dataTable.Compute("sum(LaborBudCost)", "1>0");
dataRow["LaborConsCost"] = dataTable.Compute("sum(LaborConsCost)", "1>0");
dataRow["ReductionAmount"] = dataTable.Compute("sum(ReductionAmount)", "1>0");
if (System.Convert.ToDecimal(dataRow["CurrentLaborBudCost"]) != 0m)
{
decimal d = System.Convert.ToDecimal(dataRow["CurrentReductionAmount"]) / System.Convert.ToDecimal(dataRow["CurrentLaborBudCost"]);
dataRow["CurrentReductionRate"] = (decimal.Floor(d * 10000m) / 100m).ToString("0.00") + "%";
}
else
{
dataRow["CurrentReductionRate"] = "0.00%";
}
if (System.Convert.ToDecimal(dataRow["LaborBudCost"]) != 0m)
{
decimal d2 = System.Convert.ToDecimal(dataRow["ReductionAmount"]) / System.Convert.ToDecimal(dataRow["LaborBudCost"]);
dataRow["ReductionRate"] = (decimal.Floor(d2 * 10000m) / 100m).ToString("0.00") + "%";
}
else
{
dataRow["ReductionRate"] = "0.00%";
}
dataTable.Rows.Add(dataRow);
}
dataTable = this.GetTitleByTable(dataTable);
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
list.Add(ExcelHeader.Create("本月数", 1, 4, 3, 0));
list.Add(ExcelHeader.Create("累计数", 1, 4, 7, 0));
System.Collections.Generic.List <int> list2 = new System.Collections.Generic.List <int>();
foreach (DataColumn dataColumn in dataTable.Columns)
{
if (dataColumn.Ordinal >= 3)
{
list2.Add(dataColumn.Ordinal);
}
if (dataColumn.Ordinal < 3)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 2));
}
else
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 0));
}
}
ExcelHelper.ExportExcel(dataTable, "人工分析表", "人工分析表", "人工分析表.xls", list, null, 2, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable formatDataTable = this.GetFormatDataTable();
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
foreach (DataColumn dataColumn in formatDataTable.Columns)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 1, 0, 0, 0));
}
ExcelHelper.ExportExcel(formatDataTable, this.hfldPrjName.Value + "费用查询(财务)", "sheet1", "费用查询(财务).xls", list, null, 3, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable dataTable = new DataTable();
dataTable = ConstructReport.GetEvenAnalysis(this.txtPrjCode.Text.Trim(), this.txtPrjName.Text.Trim(), 0, 0, base.UserCode, this.hfldIsWBSRelevance.Value);
if (dataTable.Rows.Count > 0)
{
DataRow dataRow = dataTable.NewRow();
dataRow["Num"] = "合计";
dataRow["ContractBud"] = dataTable.Compute("sum(ContractBud)", "1>0");
dataRow["DirectCost"] = dataTable.Compute("sum(DirectCost)", "1>0");
dataRow["IndirectCost"] = dataTable.Compute("sum(IndirectCost)", "1>0");
dataRow["GainLoss"] = dataTable.Compute("sum(GainLoss)", "1>0");
if (System.Convert.ToDecimal(dataRow["ContractBud"]) != 0m)
{
decimal d = System.Convert.ToDecimal(dataRow["GainLoss"]) / System.Convert.ToDecimal(dataRow["ContractBud"]);
dataRow["RatioGainLoss"] = (decimal.Floor(d * 10000m) / 100m).ToString() + "%";
}
else
{
dataRow["RatioGainLoss"] = "0.00%";
}
dataTable.Rows.Add(dataRow);
}
dataTable = this.GetTitleByTable(dataTable);
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
list.Add(ExcelHeader.Create("累计数", 1, 5, 3, 0));
list.Add(ExcelHeader.Create("实际成本", 2, 2, 4, 0));
System.Collections.Generic.List <int> list2 = new System.Collections.Generic.List <int>();
foreach (DataColumn dataColumn in dataTable.Columns)
{
if (dataColumn.Ordinal >= 3)
{
list2.Add(dataColumn.Ordinal);
}
if (dataColumn.Ordinal < 3)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 3, 0, 0, 3));
}
else
{
if (dataColumn.Ordinal > 3 && dataColumn.Ordinal < 6)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 3, 0, 0, 0));
}
else
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 2));
}
}
}
ExcelHelper.ExportExcel(dataTable, "盈亏分析", "盈亏分析", "盈亏分析.xls", list, null, 3, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable dataTable = this.budTaskResSer.GetResPriceDifference(this.prjId, 0, 0);
dataTable = this.GetTitleByTable(dataTable);
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
foreach (DataColumn dataColumn in dataTable.Columns)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 1, 0, 0, 0));
}
ExcelHelper.ExportExcel(dataTable, "资源价差表", "资源价差表", "资源价差表.xls", list, null, 0, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
if (!string.IsNullOrEmpty(this.txtStartDate.Text.Trim()))
{
this.startDate = this.txtStartDate.Text.Trim();
}
if (!string.IsNullOrEmpty(this.txtEndDate.Text.Trim()))
{
this.endDate = this.txtEndDate.Text.Trim();
}
if (!string.IsNullOrEmpty(this.txtShipCode.Text.Trim()))
{
this.shipCode = this.txtShipCode.Text.Trim();
}
DataTable dataTable = this.applySer.GetApplyTable(this.startDate, this.endDate, this.shipCode, 0, 0);
if (dataTable.Rows.Count > 0)
{
DataRow dataRow = dataTable.NewRow();
dataRow["EquipmentCode"] = "合计";
dataRow["TotalRefuel"] = dataTable.Compute("sum(TotalRefuel)", "1>0");
dataRow["StockQuantity"] = dataTable.Compute("sum(StockQuantity)", "1>0");
dataRow["ApplyQuantity"] = dataTable.Compute("sum(ApplyQuantity)", "1>0");
dataRow["BudCompleteQuantity"] = dataTable.Compute("sum(BudCompleteQuantity)", "1>0");
dataRow["Ratio"] = dataTable.Compute("sum(Ratio)", "1>0");
dataRow["Sump"] = dataTable.Compute("sum(Sump)", "1>0");
dataRow["RatifyQuantity"] = dataTable.Compute("sum(RatifyQuantity)", "1>0");
dataTable.Rows.Add(dataRow);
}
dataTable = this.GetTitleByTable(dataTable);
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
list.Add(ExcelHeader.Create("加油概况", 1, 10, 1, 0));
list.Add(ExcelHeader.Create("审核栏", 1, 3, 11, 0));
System.Collections.Generic.List <int> list2 = new System.Collections.Generic.List <int>();
foreach (DataColumn dataColumn in dataTable.Columns)
{
if (dataColumn.Ordinal >= 1)
{
list2.Add(dataColumn.Ordinal);
}
if (dataColumn.Ordinal < 1)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 1, 0, 0, 2));
}
else
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 0));
}
}
ExcelHelper.ExportExcel(dataTable, "加油申请单", "加油申请单", "加油申请单.xls", list, null, 0, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable dataTable = new DataTable();
dataTable = ConstructReport.GetLSMTaskAnalysis(this.txtTaskCode.Text.Trim(), this.txtTaskName.Text.Trim(), this.prjId, 0, 0);
if (dataTable.Rows.Count > 0)
{
DataRow dataRow = dataTable.NewRow();
dataRow["Num"] = "合计";
dataRow["LaborBudCost"] = System.Convert.ToDecimal(dataTable.Compute("sum(LaborBudCost)", "1>0")).ToString("0.000");
dataRow["StuffBudCost"] = System.Convert.ToDecimal(dataTable.Compute("sum(StuffBudCost)", "1>0")).ToString("0.000");
dataRow["MachineBudCost"] = System.Convert.ToDecimal(dataTable.Compute("sum(MachineBudCost)", "1>0")).ToString("0.000");
dataRow["BudTotal"] = System.Convert.ToDecimal(dataTable.Compute("sum(BudTotal)", "1>0")).ToString("0.000");
dataRow["LaborConsCost"] = System.Convert.ToDecimal(dataTable.Compute("sum(LaborConsCost)", "1>0")).ToString("0.000");
dataRow["StuffConsCost"] = System.Convert.ToDecimal(dataTable.Compute("sum(StuffConsCost)", "1>0")).ToString("0.000");
dataRow["MachineConsCost"] = System.Convert.ToDecimal(dataTable.Compute("sum(MachineConsCost)", "1>0")).ToString("0.000");
dataRow["ConsTotal"] = System.Convert.ToDecimal(dataTable.Compute("sum(ConsTotal)", "1>0")).ToString("0.000");
dataRow["DiffTotal"] = System.Convert.ToDecimal(dataTable.Compute("sum(DiffTotal)", "1>0")).ToString("0.000");
dataTable.Rows.Add(dataRow);
}
dataTable = this.GetTitleByTable(dataTable);
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
list.Add(ExcelHeader.Create("目标成本", 1, 4, 3, 0));
list.Add(ExcelHeader.Create("报量成本", 1, 4, 7, 0));
System.Collections.Generic.List <int> list2 = new System.Collections.Generic.List <int>();
foreach (DataColumn dataColumn in dataTable.Columns)
{
if (dataColumn.Ordinal >= 3 && dataColumn.Ordinal < 11)
{
list2.Add(dataColumn.Ordinal);
}
if (dataColumn.Ordinal < 3)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 2));
}
else
{
if (dataColumn.Ordinal > 10)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 2));
}
else
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 0));
}
}
}
ExcelHelper.ExportExcel(dataTable, "人材机成本明细表", "人材机成本明细表", "人材机成本明细表.xls", list, null, 2, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable dataTable = ConstructReport.GetProfitInfo(this.txtPrjCode.Text.Trim(), this.txtPrjName.Text.Trim(), base.UserCode, this.dropPrjState.SelectedValue, this.txtPrjPeopleName.Text.Trim(), this.txtPrjStartDate.Text.Trim(), this.txtPrjEndDate.Text.Trim(), 0, 0, this.hfldIsWBSRelevance.Value);
this.SetPrjStates(dataTable);
if (dataTable.Rows.Count > 0)
{
DataRow dataRow = dataTable.NewRow();
dataRow["Num"] = "合计";
dataRow["ContractCost"] = dataTable.Compute("sum(ContractCost)", "1>0");
dataRow["BudCost"] = dataTable.Compute("sum(BudCost)", "1>0");
dataRow["ConsTotal"] = dataTable.Compute("sum(ConsTotal)", "1>0");
dataRow["StuffCost"] = dataTable.Compute("sum(StuffCost)", "1>0");
dataRow["LaborCost"] = dataTable.Compute("sum(LaborCost)", "1>0");
dataRow["MachineCost"] = dataTable.Compute("sum(MachineCost)", "1>0");
dataRow["OutSourceCost"] = dataTable.Compute("sum(OutSourceCost)", "1>0");
dataRow["ElseCBSCost"] = dataTable.Compute("sum(ElseCBSCost)", "1>0");
dataRow["DirectCost"] = dataTable.Compute("sum(DirectCost)", "1>0");
dataRow["IndirectCost"] = dataTable.Compute("sum(IndirectCost)", "1>0");
dataRow["TargetProfit"] = dataTable.Compute("sum(TargetProfit)", "1>0");
dataRow["RealityProfit"] = dataTable.Compute("sum(RealityProfit)", "1>0");
dataTable.Rows.Add(dataRow);
}
dataTable = this.GetTitleByTable(dataTable);
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
list.Add(ExcelHeader.Create("直接费用", 1, 6, 10, 0));
list.Add(ExcelHeader.Create("利润", 1, 2, 17, 0));
System.Collections.Generic.List <int> list2 = new System.Collections.Generic.List <int>();
foreach (DataColumn dataColumn in dataTable.Columns)
{
if (dataColumn.Ordinal >= 10)
{
list2.Add(dataColumn.Ordinal);
}
if (dataColumn.Ordinal < 10 || dataColumn.Ordinal == 16)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 2));
}
else
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 0));
}
}
ExcelHelper.ExportExcel(dataTable, "利润分析", "利润分析", "利润分析.xls", list, null, 3, base.Request.Browser.Browser);
}
protected void btnExecl_Click(object sender, System.EventArgs e)
{
DataTable prjByCondition = ProjectInfo.GetPrjByCondition(this.txtName.Text.Trim(), this.txtCode.Text.Trim(), this.txtManager.Value.Trim(), this.txtPrjPlace.Value.Trim(), this.txtPrjDutyPerson.Value.Trim(), this.txtStartTime.Text.Trim(), this.txtEndTime.Text.Trim(), base.UserCode, 0, 0);
if (prjByCondition.Rows.Count > 0)
{
DataRow dataRow = prjByCondition.NewRow();
dataRow["Num"] = "合计";
dataRow["ContractPrice"] = System.Convert.ToDecimal(prjByCondition.Compute("sum(ContractPrice)", "1>0")).ToString("0.000");
dataRow["BudTotal"] = System.Convert.ToDecimal(prjByCondition.Compute("sum(BudTotal)", "1>0")).ToString("0.000");
dataRow["ConsTotal"] = System.Convert.ToDecimal(prjByCondition.Compute("sum(ConsTotal)", "1>0")).ToString("0.000");
dataRow["ConsResTotal"] = System.Convert.ToDecimal(prjByCondition.Compute("sum(ConsResTotal)", "1>0")).ToString("0.000");
dataRow["ClearingPrice"] = System.Convert.ToDecimal(prjByCondition.Compute("sum(ClearingPrice)", "1>0")).ToString("0.000");
dataRow["SurplusClearingPrice"] = System.Convert.ToDecimal(prjByCondition.Compute("sum(SurplusClearingPrice)", "1>0")).ToString("0.000");
dataRow["CurrentCllectionPrice"] = System.Convert.ToDecimal(prjByCondition.Compute("sum(CurrentCllectionPrice)", "1>0")).ToString("0.000");
dataRow["CllectionPrice"] = System.Convert.ToDecimal(prjByCondition.Compute("sum(CllectionPrice)", "1>0")).ToString("0.000");
dataRow["CurrentPaymentMoney"] = System.Convert.ToDecimal(prjByCondition.Compute("sum(CurrentPaymentMoney)", "1>0")).ToString("0.000");
dataRow["PaymentMoney"] = System.Convert.ToDecimal(prjByCondition.Compute("sum(PaymentMoney)", "1>0")).ToString("0.000");
dataRow["ManagementMargin"] = System.Convert.ToDecimal(prjByCondition.Compute("sum(ManagementMargin)", "1>0")).ToString("0.000");
dataRow["MigrantQualityMarginRate"] = System.Convert.ToDecimal(prjByCondition.Compute("sum(MigrantQualityMarginRate)", "1>0")).ToString("0.000");
dataRow["PerformanceBond"] = System.Convert.ToDecimal(prjByCondition.Compute("sum(PerformanceBond)", "1>0")).ToString("0.000");
dataRow["ElseMargin"] = System.Convert.ToDecimal(prjByCondition.Compute("sum(ElseMargin)", "1>0")).ToString("0.000");
prjByCondition.Rows.Add(dataRow);
}
DataTable dataTable = this.FormatTable(prjByCondition, false);
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
list.Add(ExcelHeader.Create("回款", 1, 2, 24, 0));
list.Add(ExcelHeader.Create("支出", 1, 2, 26, 0));
list.Add(ExcelHeader.Create("公司预留款", 1, 5, 28, 0));
new System.Collections.Generic.List <int>();
foreach (DataColumn dataColumn in dataTable.Columns)
{
if (dataColumn.Ordinal < 24)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 2));
}
else
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 0));
}
}
ExcelHelper.ExportExcel(dataTable, "工程基础汇总表", "工程基础汇总表", "工程基础汇总表.xls", list, null, 0, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable dataTable = new DataTable();
dataTable = ConstructReport.GetMajorStuffDiffAnalysis(this.txtResourceCode.Text.Trim(), this.txtResourceName.Text.Trim(), this.prjId, 0, 0);
if (dataTable.Rows.Count > 0)
{
DataRow dataRow = dataTable.NewRow();
dataRow["Num"] = "合计";
dataRow["CurrentBudCost"] = dataTable.Compute("sum(CurrentBudCost)", "1>0");
dataRow["CurrentConsCost"] = dataTable.Compute("sum(CurrentConsCost)", "1>0");
dataRow["CurrentDiffPrice"] = dataTable.Compute("sum(CurrentDiffPrice)", "1>0");
dataRow["CurrentReductionAmount"] = dataTable.Compute("sum(CurrentReductionAmount)", "1>0");
dataRow["BudCost"] = dataTable.Compute("sum(BudCost)", "1>0");
dataRow["ConsCost"] = dataTable.Compute("sum(ConsCost)", "1>0");
dataRow["DiffQuantity"] = dataTable.Compute("sum(DiffQuantity)", "1>0");
dataRow["DiffPrice"] = dataTable.Compute("sum(DiffPrice)", "1>0");
dataRow["ReductionAmount"] = dataTable.Compute("sum(ReductionAmount)", "1>0");
dataTable.Rows.Add(dataRow);
}
dataTable = this.GetTitleByTable(dataTable);
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
list.Add(ExcelHeader.Create("本月数", 1, 4, 7, 0));
list.Add(ExcelHeader.Create("累计数", 1, 5, 11, 0));
System.Collections.Generic.List <int> list2 = new System.Collections.Generic.List <int>();
foreach (DataColumn dataColumn in dataTable.Columns)
{
if (dataColumn.Ordinal >= 7)
{
list2.Add(dataColumn.Ordinal);
}
if (dataColumn.Ordinal < 7)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 2));
}
else
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 0));
}
}
ExcelHelper.ExportExcel(dataTable, "主材差异分析表", "主材差异分析表", "主材差异分析表.xls", list, null, 2, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable exportData = this.GetExportData();
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
list.Add(ExcelHeader.Create("本月数", 1, 4, 7, 0));
list.Add(ExcelHeader.Create("累计数", 1, 4, 3, 0));
foreach (DataColumn dataColumn in exportData.Columns)
{
if (dataColumn.Ordinal <= 2)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 2));
}
else
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 0));
}
}
ExcelHelper.ExportExcel(exportData, "分项工程成本对比表", "分项工程成本对比表", "分项工程成本对比表.xls", list, null, 1, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable formatDataTable = this.GetFormatDataTable(true);
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
list.Add(ExcelHeader.Create("目标成本", 1, 2, 5, 0));
list.Add(ExcelHeader.Create("实际成本", 1, 2, 7, 0));
foreach (DataColumn dataColumn in formatDataTable.Columns)
{
if (dataColumn.Ordinal <= 4 || dataColumn.Ordinal >= 9)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 2));
}
else
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 0));
}
}
ExcelHelper.ExportExcel(formatDataTable, "三算分析总表", "sheet1", "三算分析总表.xls", list, null, 4, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable formatDataTable = this.GetFormatDataTable();
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
list.Add(ExcelHeader.Create("本月数", 1, 4, 3, 0));
list.Add(ExcelHeader.Create("累计数", 1, 4, 7, 0));
foreach (DataColumn dataColumn in formatDataTable.Columns)
{
if (dataColumn.Ordinal <= 2)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 2));
}
else
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 0));
}
}
ExcelHelper.ExportExcel(formatDataTable, this.prjName + "-间接费用分析报表", "sheet1", "间接费用分析.xls", list, null, 3, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable dataTable = this.applySer.GetRefuelRecord(this.txtStartDate.Text.Trim(), this.txtEndDate.Text.Trim(), this.txtShipCode.Text.Trim(), 0, 0);
if (dataTable.Rows.Count > 0)
{
DataRow dataRow = dataTable.NewRow();
dataRow["EquipmentCode"] = "合计";
dataRow["StockQuantity"] = dataTable.Compute("sum(StockQuantity)", "1>0");
dataRow["ApplyQuantity"] = dataTable.Compute("sum(ApplyQuantity)", "1>0");
dataRow["AfterQuantity"] = dataTable.Compute("sum(AfterQuantity)", "1>0");
dataTable.Rows.Add(dataRow);
}
dataTable = this.GetTitleByTable(dataTable);
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
foreach (DataColumn dataColumn in dataTable.Columns)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 1, 0, 0, 0));
}
ExcelHelper.ExportExcel(dataTable, "单船加油量记录表", "单船加油量记录表", "单船加油量记录表.xls", list, null, 0, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable dataTable = new DataTable();
dataTable = ConstructReport.GetStuffInfo(this.txtCode.Text.Trim(), this.txtName.Text.Trim(), this.txtSpecification.Text.Trim(), this.txtBrand.Text.Trim(), this.txtUnitName.Text.Trim(), this.prjId, 0, 0, this.hfldIsWBSRelevance.Value);
if (dataTable.Rows.Count > 0)
{
DataRow dataRow = dataTable.NewRow();
dataRow["Num"] = "合计";
dataRow["BudQuantity"] = dataTable.Compute("sum(BudQuantity)", "1>0");
dataRow["ConsQuantity"] = dataTable.Compute("sum(ConsQuantity)", "1>0");
dataRow["RealityNumber"] = dataTable.Compute("sum(RealityNumber)", "1>0");
dataRow["BudTotal"] = dataTable.Compute("sum(BudTotal)", "1>0");
dataRow["ConsTotal"] = dataTable.Compute("sum(ConsTotal)", "1>0");
dataRow["RealityTotal"] = dataTable.Compute("sum(RealityTotal)", "1>0");
dataTable.Rows.Add(dataRow);
}
dataTable = this.GetTitleByTable(dataTable);
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
list.Add(ExcelHeader.Create("材料数量", 1, 3, 6, 0));
list.Add(ExcelHeader.Create("材料价格", 1, 3, 9, 0));
list.Add(ExcelHeader.Create("材料金额", 1, 3, 12, 0));
System.Collections.Generic.List <int> list2 = new System.Collections.Generic.List <int>();
foreach (DataColumn dataColumn in dataTable.Columns)
{
if (dataColumn.Ordinal >= 6)
{
list2.Add(dataColumn.Ordinal);
}
if (dataColumn.Ordinal < 6)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 2));
}
else
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 0));
}
}
ExcelHelper.ExportExcel(dataTable, "材料明细", "材料明细", "材料明细.xls", list, null, 3, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable dataTable = new DataTable();
dataTable = this.GetFormatDataTable();
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
list.Add(ExcelHeader.Create("入库", 1, 4, 3, 0));
list.Add(ExcelHeader.Create("出库（安港）小计", 1, 2, 7, 0));
list.Add(ExcelHeader.Create("出库（外租）小计", 1, 2, 9, 0));
list.Add(ExcelHeader.Create("出库合计", 1, 2, 11, 0));
list.Add(ExcelHeader.Create("库存合计", 1, 2, 13, 0));
foreach (DataColumn dataColumn in dataTable.Columns)
{
if (dataColumn.Ordinal < 3 || dataColumn.Ordinal >= 15)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 2));
}
else
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 0));
}
}
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable dataTable = this.applySer.GetAnalysisTable(this.txtStartDate.Text.Trim(), this.txtEndDate.Text.Trim(), this.txtProjectName.Text.Trim(), this.txtShipCode.Text.Trim(), 0, 0);
if (dataTable.Rows.Count > 0)
{
DataRow dataRow = dataTable.NewRow();
dataRow["PrjName"] = "合计";
dataRow["Qty"] = System.Convert.ToDecimal(dataTable.Compute("sum(Qty)", "1>0")).ToString("0.00");
dataRow["Sump"] = System.Convert.ToDecimal(dataTable.Compute("sum(Sump)", "1>0")).ToString("0.00");
dataRow["BudOilWear"] = System.Convert.ToDecimal(dataTable.Compute("sum(BudOilWear)", "1>0")).ToString("0.00");
dataRow["ApplyQuantity"] = System.Convert.ToDecimal(dataTable.Compute("sum(ApplyQuantity)", "1>0")).ToString("0.00");
dataRow["Diff"] = System.Convert.ToDecimal(dataTable.Compute("sum(Diff)", "1>0")).ToString("0.00");
dataTable.Rows.Add(dataRow);
}
dataTable = this.GetFormatDataTable(dataTable);
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
foreach (DataColumn dataColumn in dataTable.Columns)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 1, 0, 0, 0));
}
ExcelHelper.ExportExcel(dataTable, "单船油耗分析", "单船油耗分析", "单船油耗分析.xls", list, null, 3, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
this.GetTable(0, 0);
DataTable dataTable = (DataTable)this.ViewState["dtReport"];
DataView dataView = dataTable.AsDataView();
dataView.Sort = "OrderNumber";
dataTable = dataView.ToTable();
int arg_44_0 = dataTable.Rows.Count;
dataTable = this.GetTitleByTable(dataTable);
if (dataTable.Columns.Contains("TaskId"))
{
dataTable.Columns.Remove("TaskId");
}
if (dataTable.Columns.Contains("OrderNumber"))
{
dataTable.Columns.Remove("OrderNumber");
}
dataTable.AcceptChanges();
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
list.Add(ExcelHeader.Create("目标成本组成", 1, 3, 9, 0));
new System.Collections.Generic.List <int>();
foreach (DataColumn dataColumn in dataTable.Columns)
{
if (dataColumn.Ordinal <= 8 || dataColumn.Ordinal > 11)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 1, 0, 0, 2));
}
else
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 0));
}
}
ExcelHelper.ExportExcel(dataTable, "目标成本产出", "目标成本产出", "目标成本产出.xls", list, null, 0, base.Request.Browser.Browser);
}
protected void btnExcel_Click(object sender, System.EventArgs e)
{
DataTable dt1 = this.treasuryStockBll.GetStuffInfo(this.txtCode.Text.Trim(), this.txtName.Text.Trim(), this.hfldPrjId.Value.Trim(), 0, 0, this.hfldIsWBSRelevance.Value, this.txtSpecification.Text.Trim(), this.txtBrand.Text.Trim(), this.txtModelNumber.Text.Trim());
string strSql = string.Format(@" with t1 as( SELECT t.TaskId, t.TaskName,t.ResourceId,t.ResourceCode scode,t.ResourceQuantity,w.numberIng--,sws.number--sum(sws.number) numberIng-- ,sws.wpcode
FROM (SELECT PrjGuid,TaskId,ResourceId,TaskName,ResourceCode,sum(ResourceQuantity) ResourceQuantity FROM (
SELECT btr.PrjGuid,btr.TaskId,btr.ResourceId,bt.TaskName,rs.ResourceCode,btr.ResourceQuantity
FROM Bud_TaskResource btr
LEFT JOIN Res_Resource rs on btr.ResourceId=rs.ResourceId
LEFT JOIN Bud_Task bt on btr.TaskId=bt.TaskId
where btr.PrjGuid='{0}'
UNION ALL SELECT bm.PrjId,bmt.TaskId,bmts.ResourceId,bt.TaskName,rs.ResourceCode,bmts.ResourceQuantity FROM Bud_ModifyTaskRes bmts
LEFT JOIN Bud_ModifyTask bmt ON bmts.ModifyTaskId=bmt.ModifyTaskId
LEFT JOIN Bud_Modify bm ON bmt.ModifyId=bm.ModifyId
LEFT JOIN Bud_Task bt on bmt.TaskId=bt.TaskId
LEFT JOIN Res_Resource rs on bmts.ResourceId=rs.ResourceId
WHERE bm.flowstate !=-2 and bm.PrjId='{0}' ) s
GROUP BY PrjGuid,TaskId,ResourceId,TaskName,ResourceCode )t
LEFT JOIN
( SELECT sws.scode,sws.TaskId,sum(sws.number) numberIng from Sm_Wantplan_Stock sws --sw.flowstate,sw.swcode,
LEFT JOIN Sm_Wantplan sw ON sws.wpcode=sw.swcode
WHERE sw.flowstate !=-2 and sw.swcode !=''
GROUP BY sws.scode,sws.TaskId ) w ON w.scode=t.ResourceCode AND w.TaskId=t.TaskId)
SELECT t1.*,t2.*,rs.ResourceName from t1 LEFT JOIN ( select sws.scode,sum(sws.number) nums,sw.procode,(select sum(sos.number) outNums from Sm_out_Stock sos WHERE sos.wpcode in( select sws.wpcode from Sm_Wantplan_Stock sws LEFT JOIN Sm_Wantplan sw ON sws.wpcode=sw.swcode
where sw.procode='{0}' ) and sos.scode=sws.scode) outNums
from Sm_Wantplan_Stock sws LEFT JOIN Sm_Wantplan sw ON sws.wpcode=sw.swcode
where sw.procode='{0}'
GROUP BY sws.scode,sw.procode )
t2 on t1.scode=t2.scode
LEFT JOIN Res_Resource rs on t1.ResourceId=rs.ResourceId " , this.hfldPrjId.Value);
DataTable dt2 = publicDbOpClass.DataTableQuary(strSql);
DataTable stuffInfo = new DataTable();
stuffInfo = dt1.Clone();
stuffInfo.Columns.Add("nums");
stuffInfo.Columns["nums"].DataType = Type.GetType("System.Decimal");
stuffInfo.Columns.Add("outNums");
stuffInfo.Columns["outNums"].DataType = Type.GetType("System.Decimal");
for (int ii = 0; ii < dt1.Rows.Count; ii++)
{
stuffInfo.Rows.Add(dt1.Rows[ii].ItemArray);
}
foreach (DataRow dr1 in stuffInfo.Rows)
{
foreach (DataRow dr2 in dt2.Rows)
{
if (dr1["ResourceCode"].ToString() == dr2["scode"].ToString())
{
if (!string.IsNullOrEmpty(dr2["nums"].ToString()))
{
dr1["nums"] = Convert.ToDecimal(dr2["nums"].ToString());
}
else
{
dr1["nums"] = 0;
}
if (!string.IsNullOrEmpty(dr2["outNums"].ToString()))
{
dr1["outNums"] = Convert.ToDecimal(dr2["outNums"].ToString());
}
else
{
dr1["outNums"] = 0;
}
}
}
}
foreach (DataRow dr1 in stuffInfo.Rows)
{
if (string.IsNullOrEmpty(dr1["nums"].ToString()))
{
dr1["nums"] = 0;
}
if (string.IsNullOrEmpty(dr1["outNums"].ToString()))
{
dr1["outNums"] = 0;
}
}
if (stuffInfo.Rows.Count > 0)
{
DataRow dataRow = stuffInfo.NewRow();
dataRow["Num"] = "合计";
dataRow["BudQuantity"] = stuffInfo.Compute("sum(BudQuantity)", "1>0");
dataRow["BudTotal"] = stuffInfo.Compute("sum(BudTotal)", "1>0");
dataRow["PurchaseNumber"] = stuffInfo.Compute("sum(PurchaseNumber)", "1>0");
dataRow["PurchaseCost"] = stuffInfo.Compute("sum(PurchaseCost)", "1>0");
dataRow["StorageNumber"] = stuffInfo.Compute("sum(StorageNumber)", "1>0");
dataRow["StorageCost"] = stuffInfo.Compute("sum(StorageCost)", "1>0");
dataRow["RealityNumber"] = stuffInfo.Compute("sum(RealityNumber)", "1>0");
dataRow["RealityTotal"] = stuffInfo.Compute("sum(RealityTotal)", "1>0");
dataRow["ProfitLossNumber"] = stuffInfo.Compute("sum(ProfitLossNumber)", "1>0");
dataRow["ProfitLossCost"] = stuffInfo.Compute("sum(ProfitLossCost)", "1>0");
dataRow["BalanceNumber"] = stuffInfo.Compute("sum(BalanceNumber)", "1>0");
dataRow["BalanceCost"] = stuffInfo.Compute("sum(BalanceCost)", "1>0");
dataRow["nums"] = stuffInfo.Compute("sum(nums)", "1>0");
dataRow["outNums"] = stuffInfo.Compute("sum(outNums)", "1>0");
stuffInfo.Rows.Add(dataRow);
}
stuffInfo = this.GetTitleByTable(stuffInfo);
System.Collections.Generic.List <ExcelHeader> list = new System.Collections.Generic.List <ExcelHeader>();
list.Add(ExcelHeader.Create("目标成本", 1, 3, 6, 0));
list.Add(ExcelHeader.Create("在途成本", 1, 5, 9, 0));
list.Add(ExcelHeader.Create("实际成本", 1, 3, 14, 0));
list.Add(ExcelHeader.Create("盈亏", 1, 2, 17, 0));
list.Add(ExcelHeader.Create("结存", 1, 2, 19, 0));
System.Collections.Generic.List <int> list2 = new System.Collections.Generic.List <int>();
foreach (DataColumn dataColumn in stuffInfo.Columns)
{
if (dataColumn.Ordinal >= 6)
{
list2.Add(dataColumn.Ordinal);
}
if (dataColumn.Ordinal < 6)
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 2));
}
else
{
list.Add(ExcelHeader.Create(dataColumn.ColumnName, 2, 0, 0, 0));
}
}
ExcelHelper.ExportExcel(stuffInfo, "材料分析", "材料分析", "材料分析.xls", list, null, 3, base.Request.Browser.Browser);
}
