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); }