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