private void BindPlanTKNL() { PlanTKNLService plangpservice = new PlanTKNLService(); DataTable tbl = new DataTable(); tbl = plangpservice.GetPlanTKNLEnerprise(memVal.OrgId, ReportId, true, true); cpRepeater.DataSource = tbl; cpRepeater.DataBind(); //PlanTKNLService plangpservice = new PlanTKNLService(); //DataTable tbl = new DataTable(); //tbl = plangpservice.GetPlanTKNLEnerprise(memVal.OrgId, ReportId, true, true); //StringBuilder sb = new StringBuilder(); //StringBuilder sbHeader = new StringBuilder(); //sbHeader.Append("<tr>"); //sbHeader.Append("<th>Năm</th>"); //for (int i = 4; i >= 0; i++) //{ // sbHeader.Append("<th>" + (ReportYear - i).ToString() + "</th>"); // DataRow[] dr = tbl.Select("Nam=" + (ReportYear - i)); // if (dr != null && dr.Count() > 0) // { // for (int j = 0; j < dr.Count(); j++) // { // sb.Append("<tr><td colspan='5'>" + dr[j]["TenGiaiPhap"] + "</td></tr>"); // sb.Append("<tr><td colspan='5'>" + dr[j]["TenGiaiPhap"] + "</td></tr>"); // } // } //} //sbHeader.Append("</tr>"); }
protected void cpRepeater_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName.Equals("delete")) { PlanTKNL rpt = new PlanTKNL(); PlanTKNLService rptbso = new PlanTKNLService(); rptbso.Delete(int.Parse(((LinkButton)e.CommandSource).CommandArgument)); BindPlanTKNL(); //ScriptManager.RegisterStartupScript(this, GetType(), "showkh", "showkehoach();", true); // ScriptManager.RegisterStartupScript(this, GetType(), "showgpkh", "showgiaiphapTKNL('1');", true); // voidbindexcel(int.Parse(((LinkButton)e.CommandSource).CommandArgument)); } else if (e.CommandName.Equals("edit")) { PlanTKNL rpt = new PlanTKNL(); PlanTKNLService rptbso = new PlanTKNLService(); rpt = rptbso.FindByKey(int.Parse(((LinkButton)e.CommandSource).CommandArgument)); txtmuctieuTKNL.Text = rpt.MucTieuGP; txtchiphidukienTKNL.Text = rpt.ChiPhiDuKien; if (rpt.IdGiaPhap > 0) { ddlSolution.SelectedValue = rpt.IdGiaPhap.ToString(); } if (rpt.LoaiNhienLieu > 0) { ddlFuelType.SelectedValue = rpt.LoaiNhienLieu.ToString(); BindMeasurement(); } if (rpt.MeasurementId > 0) { ddlMeasure.SelectedValue = rpt.MeasurementId.ToString(); } try { ddlCamKet.SelectedValue = rpt.MucCamKet; } catch { } txtvonTKNL.Text = rpt.HoanVon; txtGhiChu.Text = rpt.GhiChu; txtLoiIchKhac.Text = rpt.LoiIchKhac; txtThanhTien.Text = rpt.ThanhTien; txtNamBD.Text = rpt.NamBatDau.ToString();; txtNamKT.Text = rpt.NamKetThuc.ToString(); txtTuongDuong.Text = rpt.TuongDuong; if (rpt.ThanhTien != null) { txtThanhTien.Text = rpt.ThanhTien; } txtKhaNangTKNL.Text = rpt.KhaNangThucHien; txtTKNLMucTieuDukien.Text = rpt.MucTietKiemDuKien; hddkhtknl.Value = rpt.Id.ToString(); //BindPlanTKNL(); //ScriptManager.RegisterStartupScript(this, GetType(), "showkhdg", "showkehoach();", true); ScriptManager.RegisterStartupScript(this, GetType(), "showgpkhd", "ShowDialogSolutionPlan(" + hddkhtknl.Value + "," + hdnPlan.Value + ");", true); } }
private void BindPlanTKNL() { PlanTKNLService plangpservice = new PlanTKNLService(); DataTable tbl = new DataTable(); tbl = plangpservice.GetPlanTKNLEnerprise(memVal.OrgId, ReportId, false, true); rptSolutionPlan.DataSource = tbl; rptSolutionPlan.DataBind(); }
//3. Giải pháp tiết kiệm năng lương #region 3. Giải pháp tiết kiệm năng lương private void BindResultTKNL() { PlanTKNLService plangpservice = new PlanTKNLService(); DataTable tbl = new DataTable(); tbl = plangpservice.GetPlanTKNLEnerprise(memVal.OrgId, ReportId, false, false); rptResultTKNL.DataSource = tbl; rptResultTKNL.DataBind(); }
private void BindPlanTKNL() { PlanTKNLService plangpservice = new PlanTKNLService(); DataTable tbl = new DataTable(); tbl = plangpservice.GetPlanTKNLEnerprise(m_UserValidation.OrgId, ReportId, false, true); cpRepeater.DataSource = tbl; cpRepeater.DataBind(); }
protected void rptResultTKNL_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName.Equals("delete")) { LinkButton btnDelete = (LinkButton)e.CommandSource; btnDelete.Visible = AllowEdit; PlanTKNL rpt = new PlanTKNL(); PlanTKNLService rptbso = new PlanTKNLService(); rptbso.Delete(int.Parse(((LinkButton)e.CommandSource).CommandArgument)); BindResultTKNL(); } else if (e.CommandName.Equals("edit")) { LinkButton btnDelete = (LinkButton)e.CommandSource; //btnDelete.Visible = AllowEdit; btnDelete.Visible = true; PlanTKNL rpt = new PlanTKNL(); PlanTKNLService rptbso = new PlanTKNLService(); rpt = rptbso.FindByKey(int.Parse(((LinkButton)e.CommandSource).CommandArgument)); hddkhtknl.Value = rpt.Id.ToString(); txtMucDichGPTT.Text = rpt.MucTieuGP; txtMucTietKiemNLTT.Text = rpt.MucTKThucTe; if (rpt.IdGiaPhap > 0) { ddlSolution2.SelectedValue = rpt.IdGiaPhap.ToString(); } txtTKCPThucTe.Text = rpt.MucTKCPThucTe; txtChiPhiThucTe.Text = rpt.CPThucTe; txtGhiChuTT.Text = rpt.GhiChuTT; txtTuongDuongTT.Text = rpt.TuongDuongTT; if (!string.IsNullOrEmpty(rpt.HeThongSuDung)) { ddlUseSysName.SelectedValue = rpt.HeThongSuDung; } if (rpt.LoaiNhienLieu > 0) { ddlFuelType2.SelectedValue = rpt.LoaiNhienLieu.ToString(); BindMeasurement2(); } if (rpt.MeasurementId > 0) { ddlMeasure2.SelectedValue = rpt.MeasurementId.ToString(); } txtLoiIchKhacTT.Text = rpt.LoiIchKhacTT; //try //{ // txtKhaNangTKNL.Text = rpt.KhaNangThucHien; //} //catch { } //txtTKNLMucTieuDukien.Text = rpt.MucTietKiemDuKien; hddkhtknl.Value = rpt.Id.ToString(); ScriptManager.RegisterStartupScript(this, GetType(), "showgpkhd", "ShowDialogSolutionResultOne(" + hddkhtknl.Value + ");", true); } }
protected void rptPlanTKNL_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName.Equals("delete")) { PlanTKNL rpt = new PlanTKNL(); PlanTKNLService rptbso = new PlanTKNLService(); LinkButton btnDelete = (LinkButton)e.CommandSource; btnDelete.Visible = AllowEdit; rptbso.Delete(int.Parse(btnDelete.CommandArgument)); BindPlanTKNL(); } else if (e.CommandName.Equals("edit")) { PlanTKNL rpt = new PlanTKNL(); PlanTKNLService rptbso = new PlanTKNLService(); LinkButton btnEdit = (LinkButton)e.CommandSource; rpt = rptbso.FindByKey(int.Parse(btnEdit.CommandArgument)); txtmuctieuTKNL.Text = rpt.MucTieuGP; txtchiphidukienTKNL.Text = rpt.ChiPhiDuKien; if (rpt.IdGiaPhap > 0) { ddlSolution.SelectedValue = rpt.IdGiaPhap.ToString(); } //try //{ // ddlCamKet.SelectedValue = rpt.MucCamKet; //} //catch { } if (rpt.LoaiNhienLieu > 0) { ddlFuelType.SelectedValue = rpt.LoaiNhienLieu.ToString(); BindMeasurement(); } if (rpt.MeasurementId > 0) { ddlMeasure.SelectedValue = rpt.MeasurementId.ToString(); } txtGhiChu.Text = rpt.GhiChu; txtLoiIchKhac.Text = rpt.LoiIchKhac; txtThanhTien.Text = rpt.ThanhTien; txtTuongDuong.Text = rpt.TuongDuong; //txtKhaNangTKNL.Text = rpt.KhaNangThucHien; txtTKNLMucTieuDukien.Text = rpt.MucTietKiemDuKien; hddkhtknl.Value = rpt.Id.ToString(); ScriptManager.RegisterStartupScript(this, GetType(), "showgpkhd", "ShowDialogSolutionPlanOne(" + hddkhtknl.Value + ");", true); } }
protected void cpRepeater_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName.Equals("delete")) { PlanTKNL rpt = new PlanTKNL(); PlanTKNLService rptbso = new PlanTKNLService(); rptbso.Delete(int.Parse(((LinkButton)e.CommandSource).CommandArgument)); BindPlanTKNL(); //ScriptManager.RegisterStartupScript(this, GetType(), "showkh", "showkehoach();", true); // ScriptManager.RegisterStartupScript(this, GetType(), "showgpkh", "showgiaiphapTKNL('1');", true); // voidbindexcel(int.Parse(((LinkButton)e.CommandSource).CommandArgument)); } else if (e.CommandName.Equals("edit")) { PlanTKNL rpt = new PlanTKNL(); PlanTKNLService rptbso = new PlanTKNLService(); rpt = rptbso.FindByKey(int.Parse(((LinkButton)e.CommandSource).CommandArgument)); txtmuctieuTKNL.Text = rpt.MucTieuGP; txtchiphidukienTKNL.Text = rpt.ChiPhiDuKien; dllgiaiphap.SelectedValue = rpt.IdGiaPhap.ToString(); txtcamketTKNL.Text = rpt.MucCamKet; //txtGiaiDoanTKNL.Text = rpt.GiaiDoan; if (rpt.LoaiNhienLieu > 0) { ddlFuelType.SelectedValue = rpt.LoaiNhienLieu.ToString(); } txtGhiChu.Text = rpt.GhiChu; txtLoiIchKhac.Text = rpt.LoiIchKhac; txtThanhTien.Text = rpt.ThanhTien; try { ddlKhaNang.Text = rpt.KhaNangThucHien; } catch { } txtTKNLMucTieuDukien.Text = rpt.MucTietKiemDuKien; hddkhtknl.Value = rpt.Id.ToString(); //BindPlanTKNL(); //ScriptManager.RegisterStartupScript(this, GetType(), "showkhdg", "showkehoach();", true); ScriptManager.RegisterStartupScript(this, GetType(), "showgpkhd", "showgiaiphapTKNL('1');", true); } }
protected void rptResultTKNL_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.CommandName.Equals("delete")) { PlanTKNL rpt = new PlanTKNL(); PlanTKNLService rptbso = new PlanTKNLService(); rptbso.Delete(int.Parse(((LinkButton)e.CommandSource).CommandArgument)); BindPlanTKNL(); } else if (e.CommandName.Equals("edit")) { PlanTKNL rpt = new PlanTKNL(); PlanTKNLService rptbso = new PlanTKNLService(); rpt = rptbso.FindByKey(int.Parse(((LinkButton)e.CommandSource).CommandArgument)); hddkhtknl.Value = rpt.Id.ToString(); txtMucDichGPTT.Text = rpt.MucTieuGP; txtMucTietKiemNLTT.Text = rpt.MucTKThucTe; ddlSolution2.SelectedValue = rpt.IdGiaPhap.ToString(); txtTKCPThucTe.Text = rpt.MucTKCPThucTe; txtChiPhiThucTe.Text = rpt.CPThucTe; txtGhiChuTT.Text = rpt.GhiChuTT; txtTuongDuongTT.Text = rpt.TuongDuongTT; if (rpt.LoaiNhienLieu > 0) { ddlFuelType2.SelectedValue = rpt.LoaiNhienLieu.ToString(); } txtLoiIchKhacTT.Text = rpt.LoiIchKhacTT; try { ddlKhaNang.Text = rpt.KhaNangThucHien; } catch { } txtTKNLMucTieuDukien.Text = rpt.MucTietKiemDuKien; hddkhtknl.Value = rpt.Id.ToString(); //BindPlanTKNL(); //ScriptManager.RegisterStartupScript(this, GetType(), "showkhdg", "showkehoach();", true); ScriptManager.RegisterStartupScript(this, GetType(), "showgpkhd", "updategiaiphapTKNL();", true); } }
public void btnSaveSolutionResult_Click(object sender, EventArgs e) { PlanTKNLService planser = new PlanTKNLService(); PlanTKNL plantknl = new PlanTKNL(); plantknl.NamBatDau = ReportYear; plantknl.NamKetThuc = ReportYear; plantknl.CPThucTe = txtChiPhiThucTe.Text; plantknl.MucTieuGP = txtMucDichGPTT.Text; plantknl.MucTKCPThucTe = txtTKCPThucTe.Text; plantknl.MucTKThucTe = txtMucTietKiemNLTT.Text; plantknl.CPThucTe = txtChiPhiThucTe.Text.Trim(); plantknl.LoiIchKhacTT = txtLoiIchKhacTT.Text.Trim(); plantknl.TuongDuongTT = txtTuongDuongTT.Text.Trim(); plantknl.GhiChuTT = txtGhiChuTT.Text.Trim(); plantknl.IsFiveYear = false; plantknl.IsPlan = false; plantknl.ReportId = ReportId; plantknl.IdPlan = ReportId; plantknl.EnterpriseId = memVal.OrgId; plantknl.HeThongSuDung = ddlUseSysName.SelectedValue; if (ddlSolution2.SelectedIndex > 0) { plantknl.IdGiaPhap = Convert.ToInt32(ddlSolution2.SelectedValue); } if (ddlFuelType2.SelectedIndex > 0) { plantknl.LoaiNhienLieu = Convert.ToInt32(ddlFuelType2.SelectedValue); } if (ddlMeasure2.SelectedIndex > 0) { plantknl.MeasurementId = Convert.ToInt32(ddlMeasure2.SelectedValue); } if (hddkhtknl.Value != "" && Convert.ToInt32(hddkhtknl.Value) > 0) { plantknl.Id = Convert.ToInt32(hddkhtknl.Value); if (planser.Update(plantknl) != null) { BindResultTKNL(); hddkhtknl.Value = ""; } else { ScriptManager.RegisterStartupScript(this, GetType(), "showgpkh", "ShowDialogSolutionResultOne(" + hddkhtknl.Value + ");", true); ScriptManager.RegisterStartupScript(this, GetType(), "message", "alert('Cập nhật không thành công. Vui lòng thử lại!');", true); } } else { int i = planser.Insert(plantknl); if (i > 0) { BindResultTKNL(); } else { ScriptManager.RegisterStartupScript(this, GetType(), "showgpkh", "ShowDialogSolutionResultOne();", true); ScriptManager.RegisterStartupScript(this, GetType(), "message", "alert('Thêm mới kê hoạch không thành công. Vui lòng thử lại!');", true); } } }
public void btnSavePlan_Click(object sender, EventArgs e) { PlanTKNLService planser = new PlanTKNLService(); PlanTKNL plantknl = new PlanTKNL(); plantknl.NamBatDau = ReportYear + 1; plantknl.NamKetThuc = ReportYear + 1; plantknl.ThanhTien = txtThanhTien.Text.Trim(); plantknl.ChiPhiDuKien = txtchiphidukienTKNL.Text; plantknl.MucTieuGP = txtmuctieuTKNL.Text; //plantknl.KhaNangThucHien = txtKhaNangTKNL.Text; //plantknl.MucCamKet = ddlCamKet.SelectedValue; plantknl.MucTietKiemDuKien = txtTKNLMucTieuDukien.Text; plantknl.LoiIchKhac = txtLoiIchKhac.Text.Trim(); plantknl.TuongDuong = txtTuongDuong.Text.Trim(); plantknl.GhiChu = txtGhiChu.Text.Trim(); plantknl.IsFiveYear = false; plantknl.IsPlan = true; plantknl.HeThongSuDung = ddlUseSysNamePlan.SelectedValue; plantknl.EnterpriseId = memVal.OrgId; if (ddlSolution.SelectedIndex > 0) { plantknl.IdGiaPhap = Convert.ToInt32(ddlSolution.SelectedValue); } if (ddlFuelType.SelectedIndex > 0) { plantknl.LoaiNhienLieu = Convert.ToInt32(ddlFuelType.SelectedValue); } if (ddlMeasure.SelectedIndex > 0) { plantknl.MeasurementId = Convert.ToInt32(ddlMeasure.SelectedValue); } plantknl.IdPlan = ReportId; plantknl.ReportId = ReportId; if (hddkhtknl.Value != "" && Convert.ToInt32(hddkhtknl.Value) > 0) { plantknl.Id = Convert.ToInt32(hddkhtknl.Value); if (planser.Update(plantknl) != null) { BindPlanTKNL(); } else { ScriptManager.RegisterStartupScript(this, GetType(), "showgpkh", "ShowDialogSolutionPlanOne(" + hddkhtknl.Value + ");", true); ScriptManager.RegisterStartupScript(this, GetType(), "message", "alert('Cập nhật không thành công. Vui lòng thử lại!');", true); } } else { int i = planser.Insert(plantknl); if (i > 0) { BindPlanTKNL(); } else { ScriptManager.RegisterStartupScript(this, GetType(), "showgpkh", "ShowDialogSolutionPlanOne(0);", true); ScriptManager.RegisterStartupScript(this, GetType(), "message", "alert('Thêm mới kê hoạch không thành công. Vui lòng thử lại!');", true); } } }
public void btnSaveAddPlan_Click(object sender, EventArgs e) { PlanTKNLService planser = new PlanTKNLService(); PlanTKNL plantknl = new PlanTKNL(); if (hddkhtknl.Value != "" && Convert.ToInt32(hddkhtknl.Value) > 0) { plantknl = planser.FindByKey(Convert.ToInt32(hddkhtknl.Value)); plantknl.CPThucTe = txtChiPhiThucTe.Text; plantknl.MucTieuGP = txtMucDichGPTT.Text; plantknl.MucTKCPThucTe = txtTKCPThucTe.Text; plantknl.MucTKThucTe = txtMucTietKiemNLTT.Text; plantknl.CPThucTe = txtChiPhiThucTe.Text.Trim(); plantknl.LoiIchKhacTT = txtLoiIchKhacTT.Text.Trim(); plantknl.TuongDuongTT = txtTuongDuongTT.Text.Trim(); plantknl.GhiChuTT = txtGhiChuTT.Text.Trim(); plantknl.IsFiveYear = false; plantknl.IsPlan = false; plantknl.ReportId = ReportId; plantknl.EnterpriseId = m_UserValidation.OrgId; if (ddlFuelType.SelectedIndex > 0) { plantknl.LoaiNhienLieu = Convert.ToInt32(ddlFuelType.SelectedValue); } plantknl.IdPlan = ReportId; if (planser.Update(plantknl) != null) { BindResultTKNL(); } else { ScriptManager.RegisterStartupScript(this, GetType(), "showgpkh", "updategiaiphapTKNL();", true); ScriptManager.RegisterStartupScript(this, GetType(), "message", "alert('Cập nhật không thành công. Vui lòng thử lại!');", true); } } else { plantknl.EnterpriseId = m_UserValidation.OrgId; plantknl.IdGiaPhap = Convert.ToInt32(ddlSolution2.SelectedValue); plantknl.CPThucTe = txtChiPhiThucTe.Text; plantknl.MucTieuGP = txtMucDichGPTT.Text; plantknl.MucTKCPThucTe = txtTKCPThucTe.Text; plantknl.MucTKThucTe = txtMucTietKiemNLTT.Text; plantknl.CPThucTe = txtChiPhiThucTe.Text.Trim(); plantknl.LoiIchKhacTT = txtLoiIchKhacTT.Text.Trim(); plantknl.TuongDuongTT = txtTuongDuongTT.Text.Trim(); plantknl.GhiChuTT = txtGhiChuTT.Text.Trim(); plantknl.IsFiveYear = false; plantknl.IsPlan = false; plantknl.IsAdd = true; plantknl.IdPlan = ReportId; if (ddlFuelType.SelectedIndex > 0) { plantknl.LoaiNhienLieu = Convert.ToInt32(ddlFuelType.SelectedValue); } plantknl.IdPlan = ReportId; int i = planser.Insert(plantknl); if (i > 0) { BindResultTKNL(); } else { ScriptManager.RegisterStartupScript(this, GetType(), "showgpkh", "updategiaiphapTKNL();", true); ScriptManager.RegisterStartupScript(this, GetType(), "message", "alert('Thêm mới kê hoạch không thành công. Vui lòng thử lại!');", true); } } }
public void btnSavePlan_Click(object sender, EventArgs e) { PlanTKNLService planser = new PlanTKNLService(); PlanTKNL plantknl = new PlanTKNL(); if (hddkhtknl.Value != "") { plantknl = planser.FindByKey(Convert.ToInt32(hddkhtknl.Value)); plantknl.NamBatDau = ReportYear; plantknl.NamKetThuc = ReportYear; plantknl.ChiPhiDuKien = txtchiphidukienTKNL.Text; plantknl.MucTieuGP = txtmuctieuTKNL.Text; plantknl.KhaNangThucHien = ddlKhaNang.SelectedValue; plantknl.MucCamKet = txtcamketTKNL.Text; plantknl.MucTietKiemDuKien = txtTKNLMucTieuDukien.Text; plantknl.LoiIchKhac = txtLoiIchKhac.Text.Trim(); plantknl.TuongDuong = txtTuongDuong.Text.Trim(); plantknl.GhiChu = txtGhiChu.Text.Trim(); plantknl.IsFiveYear = false; plantknl.IsPlan = true; plantknl.EnterpriseId = m_UserValidation.OrgId; if (ddlFuelType.SelectedIndex > 0) { plantknl.LoaiNhienLieu = Convert.ToInt32(ddlFuelType.SelectedValue); } plantknl.IdPlan = ReportId; int i = planser.Update(plantknl).Id; if (i > 0) { BindPlanTKNL(); } else { ScriptManager.RegisterStartupScript(this, GetType(), "showgpkh", "showgiaiphapTKNL('1');", true); ScriptManager.RegisterStartupScript(this, GetType(), "message", "alert('Cập nhật không thành công. Vui lòng thử lại!');", true); } } else { plantknl.NamBatDau = ReportYear; plantknl.NamKetThuc = ReportYear; plantknl.ChiPhiDuKien = txtchiphidukienTKNL.Text; plantknl.MucTieuGP = txtmuctieuTKNL.Text; plantknl.KhaNangThucHien = ddlKhaNang.SelectedValue; plantknl.MucCamKet = txtcamketTKNL.Text; plantknl.MucTietKiemDuKien = txtTKNLMucTieuDukien.Text; plantknl.IdGiaPhap = Convert.ToInt32(dllgiaiphap.SelectedValue); //plantknl.GiaiDoan = txtGiaiDoanTKNL.Text; plantknl.EnterpriseId = m_UserValidation.OrgId; plantknl.LoiIchKhac = txtLoiIchKhac.Text.Trim(); plantknl.TuongDuong = txtTuongDuong.Text.Trim(); plantknl.GhiChu = txtGhiChu.Text.Trim(); plantknl.IsFiveYear = false; plantknl.IsPlan = true; if (ddlFuelType.SelectedIndex > 0) { plantknl.LoaiNhienLieu = Convert.ToInt32(ddlFuelType.SelectedValue); } plantknl.IdPlan = ReportId; int i = planser.Insert(plantknl); if (i > 0) { BindPlanTKNL(); } else { ScriptManager.RegisterStartupScript(this, GetType(), "showgpkh", "showgiaiphapTKNL('1');", true); ScriptManager.RegisterStartupScript(this, GetType(), "message", "alert('Thêm mới kê hoạch không thành công. Vui lòng thử lại!');", true); } } }
protected void btnExport_Click(object sender, EventArgs e) { #region get data WordExtend ex = new WordExtend(); string temp = "TempReport/TemMauBaoCao" + drpmaubaocao.SelectedValue + ".doc"; ex.OpenFile(Server.MapPath(ResolveUrl("~") + temp)); Enterprise or = new Enterprise(); EnterpriseService orser = new EnterpriseService(); or = orser.FindByKey(Convert.ToInt32(memVal.OrgId)); DataTable dtinfo = new DataTable(); ex.WriteToMergeField("BC_MaDN", ""); if (memVal.OrgId > 0) { dtinfo = new ReportFuelService().GetInfoReportFuel(ReportId); } if (or != null) { ex.WriteToMergeField("BC_Title", or.Title); ex.WriteToMergeField("BC_TenCoSo", or.Title); ex.WriteToMergeField("BC_TenCoSo1", or.Title); ex.WriteToMergeField("BC_TenCoSo2", or.Title); } else { ex.WriteToMergeField("BC_TenCoSo", ""); } if (dtinfo.Rows[0]["Year"] != DBNull.Value) { string NextYear = (Convert.ToInt32(dtinfo.Rows[0]["Year"]) + 1).ToString(); ex.WriteToMergeField("BC_NextYear", NextYear); ex.WriteToMergeField("BC_NextYear1", NextYear); ex.WriteToMergeField("BC_NextYear2", NextYear); ex.WriteToMergeField("BC_Year", dtinfo.Rows[0]["Year"].ToString()); ex.WriteToMergeField("BC_Year1", dtinfo.Rows[0]["Year"].ToString()); } if (dtinfo.Rows[0]["Responsible"] != DBNull.Value) { ex.WriteToMergeField("BC_ChiuTrachNhiem", dtinfo.Rows[0]["Responsible"].ToString()); } else { ex.WriteToMergeField("BC_ChiuTrachNhiem", ""); } if (dtinfo.Rows[0]["ReportDate"] != DBNull.Value) { ex.WriteToMergeField("BC_NgayLap", Convert.ToDateTime(dtinfo.Rows[0]["ReportDate"]).ToString("dd/MM/yyyy")); ex.WriteToMergeField("BC_NgayBC", Convert.ToDateTime(dtinfo.Rows[0]["ReportDate"]).ToString("dd/MM/yyyy")); } if (dtinfo.Rows[0]["ReceivedDate"] != DBNull.Value) { ex.WriteToMergeField("BC_NgayNhan", Convert.ToDateTime(dtinfo.Rows[0]["ReceivedDate"]).ToString("dd/MM/yyyy")); } else { ex.WriteToMergeField("BC_NgayNhan", ""); } if (dtinfo.Rows[0]["ConfirmedDate"] != DBNull.Value) { ex.WriteToMergeField("BC_NgayXacNhan", Convert.ToDateTime(dtinfo.Rows[0]["ConfirmedDate"]).ToString("dd/MM/yyyy")); } else { ex.WriteToMergeField("BC_NgayXacNhan", ""); } if (dtinfo.Rows[0]["SubAreaName"] != DBNull.Value) { ex.WriteToMergeField("BC_PhanNganh", dtinfo.Rows[0]["SubAreaName"].ToString()); } else { ex.WriteToMergeField("BC_PhanNganh", ""); } if (dtinfo.Rows[0]["TaxCode"] != DBNull.Value) { ex.WriteToMergeField("BC_TaxCode", dtinfo.Rows[0]["TaxCode"].ToString()); } else { ex.WriteToMergeField("BC_TaxCode", ""); } ex.WriteToMergeField("BC_Owner", ltOwner.Text); if (or.Address != null) { ex.WriteToMergeField("BC_DiaChi", or.Address); } if (dtinfo.Rows[0]["DistrictName"] != DBNull.Value) { ex.WriteToMergeField("BC_Huyen", dtinfo.Rows[0]["DistrictName"].ToString()); } else { ex.WriteToMergeField("BC_Huyen", ""); } if (dtinfo.Rows[0]["ProvinceName"] != DBNull.Value) { ex.WriteToMergeField("BC_Tinh", dtinfo.Rows[0]["ProvinceName"].ToString()); } else { ex.WriteToMergeField("BC_Tinh", ""); } if (dtinfo.Rows[0]["ReporterName"] != DBNull.Value) { ex.WriteToMergeField("BC_NguoiBC", dtinfo.Rows[0]["ReporterName"].ToString()); } else { ex.WriteToMergeField("BC_NguoiBC", ""); } if (dtinfo.Rows[0]["Fax"] != DBNull.Value) { ex.WriteToMergeField("BC_Fax", dtinfo.Rows[0]["Fax"].ToString()); } else { ex.WriteToMergeField("BC_Fax", ""); } if (dtinfo.Rows[0]["Email"] != DBNull.Value) { ex.WriteToMergeField("BC_Email", dtinfo.Rows[0]["Email"].ToString()); } else { ex.WriteToMergeField("BC_Email", ""); } if (dtinfo.Rows[0]["Phone"] != DBNull.Value) { ex.WriteToMergeField("BC_DienThoai", dtinfo.Rows[0]["Phone"].ToString()); } else { ex.WriteToMergeField("BC_DienThoai", ""); } if (dtinfo.Rows[0]["ParentName"] != DBNull.Value) { ex.WriteToMergeField("BC_TenCtyMe", dtinfo.Rows[0]["ParentName"].ToString()); } else { ex.WriteToMergeField("BC_TenCtyMe", ""); } if (dtinfo.Rows[0]["AddressParent"] != null) { ex.WriteToMergeField("BC_DiaChiP", dtinfo.Rows[0]["AddressParent"].ToString()); } else { ex.WriteToMergeField("BC_DiaChiP", ""); } if (dtinfo.Rows[0]["DistrictNameP"] != null) { ex.WriteToMergeField("BC_HuyenP", dtinfo.Rows[0]["DistrictNameP"].ToString()); } else { ex.WriteToMergeField("BC_HuyenP", ""); } if (dtinfo.Rows[0]["ProvinceNameP"] != DBNull.Value) { ex.WriteToMergeField("BC_TinhP", dtinfo.Rows[0]["ProvinceNameP"].ToString()); } else { ex.WriteToMergeField("BC_TinhP", ""); } if (dtinfo.Rows[0]["PhoneParent"] != DBNull.Value) { ex.WriteToMergeField("BC_DienThoaiP", dtinfo.Rows[0]["PhoneParent"].ToString()); } else { ex.WriteToMergeField("BC_DienThoaiP", ""); } if (dtinfo.Rows[0]["FaxParent"] != DBNull.Value) { ex.WriteToMergeField("BC_FaxP", dtinfo.Rows[0]["FaxParent"].ToString()); } else { ex.WriteToMergeField("BC_FaxP", ""); } if (dtinfo.Rows[0]["EmailParent"] != DBNull.Value) { ex.WriteToMergeField("BC_EmailP", dtinfo.Rows[0]["EmailParent"].ToString()); } else { ex.WriteToMergeField("BC_EmailP", ""); } if (or.ActiveYear > 0) { ex.WriteToMergeField("ActiveYear", or.ActiveYear.ToString()); } else { ex.WriteToMergeField("ActiveYear", ""); } Infrastructure infra = new Infrastructure(); InfrastructureService infraService = new InfrastructureService(); infra = infraService.GetInfrastructureByReport(ReportId); if (infra != null) { if (infra.ProduceAreaNo > 0) { ex.WriteToMergeField("ProduceAreaNo", infra.ProduceAreaNo.ToString()); } else { ex.WriteToMergeField("ProduceAreaNo", ""); } if (infra.OfficeAreaNo > 0) { ex.WriteToMergeField("OfficeAreaNo", infra.OfficeAreaNo.ToString()); } else { ex.WriteToMergeField("OfficeAreaNo", ""); } if (infra.ProduceEmployeeNo > 0) { ex.WriteToMergeField("ProduceEmployeeNo", infra.ProduceEmployeeNo.ToString()); } else { ex.WriteToMergeField("ProduceEmployeeNo", ""); } if (infra.OfficeEmployeeNo > 0) { ex.WriteToMergeField("OfficeEmployeeNo", infra.OfficeEmployeeNo.ToString()); } else { ex.WriteToMergeField("OfficeEmployeeNo", ""); } } else { ex.WriteToMergeField("ProduceAreaNo", ""); ex.WriteToMergeField("OfficeAreaNo", ""); ex.WriteToMergeField("ProduceEmployeeNo", ""); ex.WriteToMergeField("OfficeEmployeeNo", ""); } UsingElectrict usingElectrict = new UsingElectrict(); UsingElectrictService usingElectrictService = new UsingElectrictService(); usingElectrict = usingElectrictService.GetUsingElectrictByReport(ReportId, false); if (usingElectrict != null) { //Su dung dien 2 if (usingElectrict.Quantity > 0) { ex.WriteToMergeField("QuantityResult2", usingElectrict.Quantity.ToString()); } else { ex.WriteToMergeField("QuantityResult2", ""); } if (usingElectrict.InstalledCapacity > 0) { ex.WriteToMergeField("InstalledCapacityResult2", usingElectrict.InstalledCapacity.ToString()); } else { ex.WriteToMergeField("InstalledCapacityResult2", ""); } if (usingElectrict.Capacity > 0) { ex.WriteToMergeField("CapacityResult2", usingElectrict.Capacity.ToString()); } else { ex.WriteToMergeField("CapacityResult2", ""); } if (usingElectrict.BuyCost > 0) { ex.WriteToMergeField("BuyCostResult2", usingElectrict.BuyCost.ToString()); } else { ex.WriteToMergeField("BuyCostResult2", ""); } if (usingElectrict.BuyCost > 0 && usingElectrict.Capacity > 0) { ex.WriteToMergeField("BuyPriceResult2", Math.Round((usingElectrict.BuyCost / (usingElectrict.Capacity * 1000)), 0).ToString()); } else { ex.WriteToMergeField("BuyPriceResult2", ""); } if (usingElectrict.ProduceQty > 0) { ex.WriteToMergeField("ProduceQtyResult2", usingElectrict.ProduceQty.ToString()); } else { ex.WriteToMergeField("ProduceQtyResult2", ""); } if (usingElectrict.Technology != null) { ex.WriteToMergeField("TechnologyResult2", usingElectrict.Technology.ToString()); } else { ex.WriteToMergeField("TechnologyResult2", ""); } if (usingElectrict.FuelId > 0) { Fuel fuel = new Fuel(); fuel = new FuelService().FindByKey(usingElectrict.FuelId); if (fuel != null) { ex.WriteToMergeField("FuelNameResult2", fuel.FuelName); ex.WriteToMergeField("FuelNameResult", fuel.FuelName); } else { ex.WriteToMergeField("FuelNameResult2", ""); ex.WriteToMergeField("FuelNameResult", ""); } } else { ex.WriteToMergeField("FuelNameResult2", ""); ex.WriteToMergeField("FuelNameResult", ""); } if (usingElectrict.PriceProduce > 0) { ex.WriteToMergeField("PriceProduceResult2", usingElectrict.PriceProduce.ToString()); } else { ex.WriteToMergeField("PriceProduceResult2", ""); } //Su dung dien 1 if (usingElectrict.Quantity > 0) { ex.WriteToMergeField("QuantityResult", usingElectrict.Quantity.ToString()); } else { ex.WriteToMergeField("QuantityResult", ""); } if (usingElectrict.InstalledCapacity > 0) { ex.WriteToMergeField("InstalledCapacityResult", usingElectrict.InstalledCapacity.ToString()); } else { ex.WriteToMergeField("InstalledCapacityResult", ""); } if (usingElectrict.Capacity > 0) { ex.WriteToMergeField("CapacityResult", usingElectrict.Capacity.ToString()); } else { ex.WriteToMergeField("CapacityResult", ""); } if (usingElectrict.BuyCost > 0) { ex.WriteToMergeField("BuyCostResult", usingElectrict.BuyCost.ToString()); } else { ex.WriteToMergeField("BuyCostResult", ""); } if (usingElectrict.BuyCost > 0 && usingElectrict.Capacity > 0) { ex.WriteToMergeField("BuyPriceResult", Math.Round((usingElectrict.BuyCost / (usingElectrict.Capacity * 1000)), 0).ToString()); } else { ex.WriteToMergeField("BuyPriceResult", ""); } if (usingElectrict.ProduceQty > 0) { ex.WriteToMergeField("ProduceQtyResult", usingElectrict.ProduceQty.ToString()); } else { ex.WriteToMergeField("ProduceQtyResult", ""); } if (usingElectrict.Technology != null) { ex.WriteToMergeField("TechnologyResult", usingElectrict.Technology.ToString()); } else { ex.WriteToMergeField("TechnologyResult", ""); } if (usingElectrict.FuelId > 0) { ex.WriteToMergeField("FuelNameResult", usingElectrict.FuelId.ToString()); } else { ex.WriteToMergeField("FuelNameResult", ""); } } else { ex.WriteToMergeField("QuantityResult2", ""); ex.WriteToMergeField("InstalledCapacityResult2", ""); ex.WriteToMergeField("CapacityResult2", ""); ex.WriteToMergeField("BuyCostResult2", ""); ex.WriteToMergeField("ProduceQtyResult2", ""); ex.WriteToMergeField("TechnologyResult2", ""); ex.WriteToMergeField("FuelNameResult2", ""); ex.WriteToMergeField("PriceProduceResult2", ""); ex.WriteToMergeField("QuantityResult", ""); ex.WriteToMergeField("InstalledCapacityResult", ""); ex.WriteToMergeField("CapacityResult", ""); ex.WriteToMergeField("BuyCostResult", ""); ex.WriteToMergeField("ProduceQtyResult", ""); ex.WriteToMergeField("TechnologyResult", ""); ex.WriteToMergeField("FuelNameResult", ""); } usingElectrict = new UsingElectrict(); usingElectrict = usingElectrictService.GetUsingElectrictByReport(ReportId, true); if (usingElectrict != null) { //Su dung dien 2 if (usingElectrict.Quantity > 0) { ex.WriteToMergeField("QuantityPlan", usingElectrict.Quantity.ToString()); } else { ex.WriteToMergeField("QuantityPlan", ""); } if (usingElectrict.InstalledCapacity > 0) { ex.WriteToMergeField("InstalledCapacityPlan", usingElectrict.InstalledCapacity.ToString()); } else { ex.WriteToMergeField("InstalledCapacityPlan", ""); } if (usingElectrict.Capacity > 0) { ex.WriteToMergeField("CapacityPlan", usingElectrict.Capacity.ToString()); } else { ex.WriteToMergeField("CapacityPlan", ""); } if (usingElectrict.BuyCost > 0) { ex.WriteToMergeField("BuyCostPlan", usingElectrict.BuyCost.ToString()); } else { ex.WriteToMergeField("BuyCostPlan", ""); } if (usingElectrict.BuyCost > 0) { ex.WriteToMergeField("BuyPricePlan", usingElectrict.BuyCost.ToString()); } else { ex.WriteToMergeField("BuyPricePlan", ""); } if (usingElectrict.ProduceQty > 0) { ex.WriteToMergeField("ProduceQtyPlan", usingElectrict.ProduceQty.ToString()); } else { ex.WriteToMergeField("ProduceQtyPlan", ""); } if (usingElectrict.Technology != null) { ex.WriteToMergeField("TechnologyPlan", usingElectrict.Technology.ToString()); } else { ex.WriteToMergeField("TechnologyPlan", ""); } if (usingElectrict.FuelId > 0) { Fuel fuel = new Fuel(); fuel = new FuelService().FindByKey(usingElectrict.FuelId); if (fuel != null) { ex.WriteToMergeField("FuelNamePlan", fuel.FuelName); } else { ex.WriteToMergeField("FuelNamePlan", ""); } } else { ex.WriteToMergeField("FuelNamePlan", ""); } if (usingElectrict.PriceProduce > 0) { ex.WriteToMergeField("PriceProducePlan", usingElectrict.PriceProduce.ToString()); } else { ex.WriteToMergeField("PriceProducePlan", ""); } } else { ex.WriteToMergeField("QuantityPlan", ""); ex.WriteToMergeField("InstalledCapacityPlan", ""); ex.WriteToMergeField("CapacityPlan", ""); ex.WriteToMergeField("BuyCostPlan", ""); ex.WriteToMergeField("ProduceQtyPlan", ""); ex.WriteToMergeField("TechnologyPlan", ""); ex.WriteToMergeField("FuelNamePlan", ""); ex.WriteToMergeField("PriceProducePlan", ""); } DataTable dthientai = new DataTable(); DataTable dtdukien = new DataTable(); DataSet dshientai = new DataSet("tbl1"); DataTable dt = new DataTable(); dt = new ReportFuelDetailService().GetNoFuelDetailByReport(ReportId, false); dt.Columns.Add("dvnhietnang", typeof(string)); dt.Columns.Add("dvnhieulieu", typeof(string)); dthientai = dt.Clone(); foreach (DataRow item in dt.Rows) { DataRow workRow = null; workRow = dthientai.NewRow(); workRow = item; if (workRow["MeasurementName"].ToString().Contains("Mét khối")) { workRow["dvnhietnang"] = "kJ/m3"; } else { workRow["dvnhietnang"] = "kJ/kg"; } if (workRow["MeasurementName"].ToString().Contains("tấn") || workRow["MeasurementName"].ToString().Contains("Klg")) { workRow["dvnhieulieu"] = "kJ/tấn"; } else { workRow["dvnhieulieu"] = "đ/m3"; } workRow.AcceptChanges(); dthientai.AcceptChanges(); dthientai.ImportRow(workRow); } dt = new ReportFuelDetailService().GetNoFuelDetailByReport(ReportId, true); dt.Columns.Add("dvnhietnang", typeof(string)); dt.Columns.Add("dvnhieulieu", typeof(string)); dtdukien = dt.Clone(); foreach (DataRow item in dt.Rows) { DataRow workRow = null; workRow = dtdukien.NewRow(); workRow = item; if (workRow["MeasurementName"].ToString().Contains("Mét khối")) { workRow["dvnhietnang"] = "kJ/m3"; } else { workRow["dvnhietnang"] = "kJ/kg"; } if (workRow["MeasurementName"].ToString().Contains("tấn") || workRow["MeasurementName"].ToString().Contains("Klg")) { workRow["dvnhieulieu"] = "kJ/tấn"; } else { workRow["dvnhieulieu"] = "đ/m3"; } workRow.AcceptChanges(); dtdukien.ImportRow(workRow); dtdukien.AcceptChanges(); } ProductCapacityService productCapacityService = new ProductCapacityService(); DataTable tblProductResult = new DataTable(); tblProductResult = productCapacityService.GetDataCapacity(ReportId, false); dshientai.Merge(tblProductResult); dshientai.Tables[0].TableName = "tbl1"; dshientai.Merge(dthientai); dshientai.Tables[1].TableName = "tbl2"; //ex.WriteDataSetToMergeField(dshientai); DataTable tblProductPlan = new DataTable(); tblProductPlan = productCapacityService.GetDataCapacity(ReportId, true); dshientai.Merge(tblProductPlan); dshientai.Tables[2].TableName = "tbl3"; dshientai.Merge(dtdukien); dshientai.Tables[3].TableName = "tbl4"; //ex.WriteDataSetToMergeField(dshientai); DataSet dsData = new DataSet(); PlanTBService plangpservice = new PlanTBService(); PlanTKNLService plangTKNLservice = new PlanTKNLService(); DataTable tblGPTKNLPlan = new DataTable(); tblGPTKNLPlan = plangTKNLservice.GetPlanTKNLEnerprise(Convert.ToInt32(memVal.OrgId), ReportId, false, true); dshientai.Merge(tblGPTKNLPlan); dshientai.Tables[4].TableName = "tbl5"; DataTable tblTBPlan = new DataTable(); tblTBPlan = plangpservice.GetPlanTBEnterprise(memVal.OrgId, ReportId, false, true); dshientai.Merge(tblTBPlan); dshientai.Tables[5].TableName = "tbl6"; dshientai.Merge(tblProductPlan.Copy()); dshientai.Tables[6].TableName = "tbl7"; dshientai.Merge(dthientai.Copy()); dshientai.Tables[7].TableName = "tbl8"; DataTable tblGPTKNLResult = new DataTable(); tblGPTKNLResult = plangTKNLservice.GetPlanTKNLEnerprise(Convert.ToInt32(memVal.OrgId), ReportId, false, false); dshientai.Merge(tblGPTKNLResult); dshientai.Tables[8].TableName = "tbl9"; DataTable tblTBResult = new DataTable(); tblTBResult = plangpservice.GetPlanTBEnterprise(memVal.OrgId, ReportId, false, false); dshientai.Merge(tblTBResult); dshientai.Tables[9].TableName = "tbl10"; dshientai.Tables.Add(tblTBResult.Copy()); dshientai.Tables[10].TableName = "tbl11"; ex.WriteDataSetToMergeField(dshientai); // dsg.Tables.Add(dst); //var dt2 = ExcelExportHelper.CreateGroupInDT(dt, "DepName", "STT"); #endregion ex.Save(Server.MapPath(ResolveUrl("~") + "TempReport/" + memVal.UserName + ".Bao-cao-hang-nam-" + dtinfo.Rows[0]["Year"] + ".doc")); HttpContext.Current.Response.Redirect(string.Format("~/Download.aspx?fp={0}&fn={1}", System.IO.Path.GetFileName(Server.MapPath(ResolveUrl("~") + "TempReport/" + memVal.UserName + ".Bao-cao-hang-nam-" + dtinfo.Rows[0]["Year"] + ".doc")), "" )); }
void BindResultSolution5Year() { return; StringBuilder sb = new StringBuilder(); DataTable tbl = new DataTable(); tbl.Columns.Add("Year", typeof(string)); for (int i = 1; i <= 5; i++) { tbl.Columns.Add(i.ToString(), typeof(double)); } DataTable dtSolution = new DataTable(); dtSolution = new GiaiPhapService().GetSolutionYear(ReportYear - 4, ReportYear, memVal.OrgId); DataTable dtSolutionResult = new DataTable(); dtSolutionResult = new PlanTKNLService().GetResultSolution5Year(ReportYear - 4, ReportYear, memVal.OrgId); if (dtSolution != null && dtSolution.Rows.Count > 0) { if (dtSolutionResult != null && dtSolutionResult.Rows.Count > 0) { for (int i = 0; i < dtSolution.Rows.Count; i++) { DataTable tblTemp = tbl.Clone(); DataRow[] drResult = dtSolutionResult.Select("IdGiaPhap=" + dtSolution.Rows[i]["Id"]); if (drResult.Count() > 0) { DataRow dr0 = tbl.NewRow(); dr0["Year"] = "<b>Giải pháp " + (i + 1) + ": " + dtSolution.Rows[i]["TenGiaiPhap"] + "</b>"; tbl.Rows.Add(dr0); for (int j = 0; j < drResult.Count(); j++) { DataRow dr1 = tbl.NewRow(); dr1["Year"] = "Mức Mức tiết kiệm năng lượng - Dự kiến theo kế hoạch (kWh)"; DataRow dr2 = tbl.NewRow(); dr2["Year"] = "Mức tiết kiệm năng lượng – Thực tế đạt được (kWh)"; DataRow dr3 = tbl.NewRow(); dr3["Year"] = "Mức tiết kiệm năng lượng - Dự kiến theo kế hoạch (%)"; DataRow dr4 = tbl.NewRow(); dr4["Year"] = "Mức tiết kiệm năng lượng – Thực tế đạt được (%)"; DataRow dr5 = tbl.NewRow(); dr5["Year"] = "Mức tiết kiệm chi phí – Dự kiến theo kế hoạch (Triệu đồng)"; DataRow dr6 = tbl.NewRow(); dr6["Year"] = "Mức tiết kiệm chi phí – Thực tế đạt được (Triệu đồng)"; DataRow dr7 = tbl.NewRow(); dr7["Year"] = "Chi phí – Dự kiến theo kế họach (Triệu đồng)"; DataRow dr8 = tbl.NewRow(); dr8["Year"] = "Chi phí – Thực tế thực hiện (Triệu đồng)"; int nam = Convert.ToInt32(drResult[j]["NamBatDau"]); int indexYear = 5 - (ReportYear - nam); if (drResult[j]["MucTietKiemDuKien"] != DBNull.Value && drResult[j]["MucTietKiemDuKien"].ToString().Trim() != "") { dr1[indexYear.ToString()] = Convert.ToDouble(drResult[j]["MucTietKiemDuKien"]); } else { dr1[indexYear.ToString()] = 0; } if (drResult[j]["MucTKThucTe"] != DBNull.Value && drResult[j]["MucTKThucTe"].ToString().Trim() != "") { dr2[indexYear.ToString()] = Convert.ToDouble(drResult[j]["MucTKThucTe"]); } else { dr2[indexYear.ToString()] = 0; } if (drResult[j]["TuongDuong"] != DBNull.Value && drResult[j]["TuongDuong"].ToString().Trim() != "") { dr3[indexYear.ToString()] = Convert.ToDouble(drResult[j]["TuongDuong"]); } else { dr3[indexYear.ToString()] = 0; } if (drResult[j]["TuongDuongTT"] != DBNull.Value && drResult[j]["TuongDuongTT"].ToString().Trim() != "") { dr4[indexYear.ToString()] = Convert.ToDouble(drResult[j]["TuongDuongTT"]); } else { dr4[indexYear.ToString()] = 0; } if (drResult[j]["TKCPDuKien"] != DBNull.Value && drResult[j]["TKCPDuKien"].ToString().Trim() != "") { dr5[indexYear.ToString()] = Convert.ToDouble(drResult[j]["TKCPDuKien"]); } else { dr5[indexYear.ToString()] = 0; } if (drResult[j]["MucTKCPThucTe"] != DBNull.Value && drResult[j]["MucTKCPThucTe"].ToString().Trim() != "") { dr6[indexYear.ToString()] = Convert.ToDouble(drResult[j]["MucTKCPThucTe"]); } else { dr6[indexYear.ToString()] = 0; } if (drResult[j]["ChiPhiDuKien"] != DBNull.Value && drResult[j]["ChiPhiDuKien"].ToString().Trim() != "") { dr7[indexYear.ToString()] = Convert.ToDouble(drResult[j]["ChiPhiDuKien"]); } else { dr7[indexYear.ToString()] = 0; } if (drResult[j]["CPThucTe"] != DBNull.Value && drResult[j]["CPThucTe"].ToString().Trim() != "") { dr8[indexYear.ToString()] = Convert.ToDouble(drResult[j]["CPThucTe"]); } else { dr8[indexYear.ToString()] = 0; } tbl.Rows.Add(dr1); tbl.Rows.Add(dr2); tbl.Rows.Add(dr3); tbl.Rows.Add(dr4); tbl.Rows.Add(dr5); tbl.Rows.Add(dr6); tbl.Rows.Add(dr7); tbl.Rows.Add(dr8); } } } } } rptResultSolution.DataSource = tbl; rptResultSolution.DataBind(); }