protected void ddlFuel_SelectedIndexChanged(object sender, EventArgs e)
{
if (ddlFuel.SelectedIndex == 0)
{
return;
}
txtNoTOE.Enabled = false;
txtNoTOE.Text = "";
BindMeasurement();
int _fuelId = Convert.ToInt32(ddlFuel.SelectedValue);
ReportModels rp = new ReportModels();
if (rp.DE_ReportFuelDetail.Any(x => x.FuelId == _fuelId && x.ReportId == ReportId && x.IsNextYear == false))
{
var fuelData = rp.DE_ReportFuelDetail.First(x => x.FuelId == _fuelId && x.ReportId == ReportId && x.IsNextYear == false);
hdnDetailId.Value = fuelData.Id.ToString();
BindDataDetail();
}
else
{
hdnDetailId.Value = "";
}
}
void BindFuel()
{
ReportModels rp = new ReportModels();
var list = rp.DE_Fuel.OrderBy(o => o.FuelOrder).ToList();
int GroupId = 0;
if (ddlFuelType.SelectedIndex > 0)
{
GroupId = Convert.ToInt32(ddlFuelType.SelectedValue);
}
var listSearch = from o in list where o.GroupFuelId == GroupId || GroupId == 0 select o;
ddlFuelType.DataSource = listSearch;
ddlFuelType.DataValueField = "Id";
ddlFuelType.DataTextField = "FuelName";
ddlFuelType.DataBind();
ddlFuelType.Items.Insert(0, new ListItem("---Chọn loại nhiên liệu---", ""));
ddlFuelType2.DataSource = listSearch;
ddlFuelType2.DataValueField = "Id";
ddlFuelType2.DataTextField = "FuelName";
ddlFuelType2.DataBind();
ddlFuelType2.Items.Insert(0, new ListItem("---Chọn loại nhiên liệu---", ""));
}
private void BindUsingElectrictFuture()
{
ReportModels rp = new ReportModels();
//DE_UsingElectrict
var data = rp.DE_UsingElectrict.FirstOrDefault(o => o.ReportId == ReportId && o.IsPlan == true);
if (data != null)
{
txtUsingElectrictFuture_InstalledCapacity.Text = data.InstalledCapacity != null?data.InstalledCapacity.ToString() : "0";
txtUsingElectrictFuture_Quantity.Text = data.Quantity != null?data.Quantity.ToString() : "0";
txtUsingElectrictFuture_CongSuatBanRa.Text = data.CongSuatBan != null?data.CongSuatBan.ToString() : "0";
txtUsingElectrictFuture_SanLuongBanRa.Text = data.SanLuongBan != null?data.SanLuongBan.ToString() : "0";
}
//DE_ElectrictProduce
var _eSelfProduce = (from a in rp.DE_ElectrictTechnology
join b in rp.DE_ElectrictProduce.Where(x => x.ReportId == ReportId && x.IsPlan == true) on a.TechKey equals b.TechKey into ab
from c in ab.DefaultIfEmpty()
orderby a.TechDesc ascending
select new
{
TechKey = a.TechKey,
TechName = a.TechName,
InstalledCapacity = c.InstalledCapacity != null ? c.InstalledCapacity : 0,
ProduceQty = c.ProduceQty,
}).ToList();
rptUsingElectrictFuture.DataSource = _eSelfProduce;
rptUsingElectrictFuture.DataBind();
}
private void BindFuelFuture()
{
ReportModels rp = new ReportModels();
var data = (from a in rp.DE_Fuel
join b in rp.DE_ReportFuelDetail.Where(x => x.ReportId == ReportId && x.IsNextYear == true) on a.Id equals b.FuelId into ab
from c in ab.DefaultIfEmpty()
join d in rp.DE_GroupFuel on a.GroupFuelId equals d.Id
join e in rp.DE_Measurement on a.MeasurementId equals e.Id
//where d.GroupCode != ReportKey.FuelGroupKey_POWER
where d.GroupCode == ReportKey.FuelGroupKey_GAS || d.GroupCode == ReportKey.FuelGroupKey_OIL || d.GroupCode == ReportKey.FuelGroupKey_GASONLINE
orderby a.FuelOrder ascending
select new
{
FuelId = a.Id,
FuelName = a.FuelName,
MeasurementName = e.MeasurementName,
NoFuel = c.NoFuel,
Reason = c.Reason,
GroupFuelId = d.Id,
MeasurementId = a.MeasurementId
}).ToList();
rptFuelFuture.DataSource = data;
rptFuelFuture.DataBind();
}
public List <rpSDNLHangNam> DN_Get_BaoCao(int ReportId)
{
try
{
using (var ctx = new ReportModels())
{
string rawCommand = string.Empty;
if (ctx.BC_SDNL_HangNam.Any(o => o.ReportId == ReportId))
{
rawCommand += " select a.id FuelId, a.FuelName, c.id MeasurementId, c.MeasurementName, b.TOE, ";
rawCommand += " cast(isnull(d.IdDN,0) as int) IdDN, cast(isnull(d.MucTieuThu,0) as decimal(20, 10)) as MucTieuThu, cast(isnull(d.NangLuongQuyDoi,0) as decimal(20, 10)) as NangLuongQuyDoi, cast(isnull(d.TrangThai,0) as int) TrangThai";
rawCommand += " from [dbo].[DE_Fuel] a";
rawCommand += " inner join [dbo].[DE_MeasurementFuel] b on a.Id=b.FuelId";
rawCommand += " inner join [dbo].[DE_Measurement] c on b.MeasurementId=c.Id";
rawCommand += " left join [dbo].[BC_SDNL_HangNam] d on a.id=d.FuelId and c.Id=d.MeasurementId and d.ReportId=@ReportId";
var result = ctx.Database.SqlQuery <rpSDNLHangNam>(rawCommand, new SqlParameter("@ReportId", ReportId)).ToList();
return(result);
}
else
{
rawCommand += " select a.id FuelId, a.FuelName, c.id MeasurementId, c.MeasurementName, b.TOE, ";
rawCommand += " cast(0 as int) IdDN, cast(0 as decimal(20, 10)) as MucTieuThu, cast(0 as decimal(20, 10)) as NangLuongQuyDoi, cast(0 as int) TrangThai";
rawCommand += " from [dbo].[DE_Fuel] a";
rawCommand += " inner join [dbo].[DE_MeasurementFuel] b on a.Id=b.FuelId";
rawCommand += " inner join [dbo].[DE_Measurement] c on b.MeasurementId=c.Id";
var result = ctx.Database.SqlQuery <rpSDNLHangNam>(rawCommand).ToList();
return(result);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private void GetNamBaoCao(int RpId)
{
using (var db = new ReportModels())
{
ltNamBaoCao.Text = db.BC_SDNL_DS_TheoNam.Where(o => o.AutoID == RpId).First().NamBaoCao.ToString();
}
}
private List <DE_Area> getListSubArea(int pId)
{
ReportModels rp = new ReportModels();
string sp = "de_area_get_by_parentId @Parent";
var result = rp.DE_Area.SqlQuery(sp, new SqlParameter("@Parent", pId)).ToList <DE_Area>();
return(result);
}
private DataTable CreateFuelData()
{
DataTable dtCurrent = new ReportFuelDetailService().GetNoFuelDetailByReport(ReportId, false);
ReportModels rp = new ReportModels();
var allFuel = (from a in rp.DE_Fuel
join b in rp.DE_Measurement on a.MeasurementId equals b.Id
join c in rp.DE_GroupFuel on a.GroupFuelId equals c.Id
select new
{
a.Id,
a.GroupFuelId,
a.FuelName,
b.MeasurementName,
c.GroupCode,
a.FuelOrder
}).ToList();
DataTable res = new DataTable();
res.Columns.Add("stt", typeof(string));
res.Columns.Add("FuelName", typeof(string));
res.Columns.Add("MeasurementName", typeof(string));
res.Columns.Add("NoFuel", typeof(string));
res.Columns.Add("Reason", typeof(string));
res.Columns.Add("GroupCode", typeof(string));
res.Columns.Add("FuelOrder", typeof(string));
int i = 1;
foreach (var item in allFuel)
{
DataRow r = res.NewRow();
r["stt"] = i.ToString();
r["FuelName"] = item.FuelName;
r["MeasurementName"] = item.MeasurementName;
r["GroupCode"] = item.GroupCode;
r["FuelOrder"] = item.FuelOrder;
bool check = false;
foreach (DataRow x in dtCurrent.Rows)
{
if (x["FuelId"].ToString() == item.Id.ToString())
{
check = true;
r["NoFuel"] = x["NoFuel"];
r["Reason"] = x["Reason"];
break;
}
}
if (check == false)
{
r["NoFuel"] = "";
r["Reason"] = "";
}
res.Rows.Add(r);
i++;
}
return(res);
}
protected void ddlPhanLoaiHeThongPlan_SelectedIndexChanged(object sender, EventArgs e)
{
ReportModels reportModels = new ReportModels();
var res = reportModels.DE_UsingSystem.Where(o => o.SysState == 0 && o.SysGroup == ddlPhanLoaiHeThongPlan.SelectedValue).ToList();
ddlUseSysNamePlan.DataValueField = "SysCode";
ddlUseSysNamePlan.DataTextField = "SysName";
ddlUseSysNamePlan.DataSource = res;
ddlUseSysNamePlan.DataBind();
}
void BindArea()
{
ReportModels rp = new ReportModels();
var list = rp.DE_Area.Where(x => x.ParentId == 0).ToList();
ddlArea.DataSource = list;
ddlArea.DataTextField = "AreaName";
ddlArea.DataValueField = "Id";
ddlArea.DataBind();
ddlArea.Items.Insert(0, new ListItem("---Chọn lĩnh vực---", ""));
}
private void BindComment(int ReportID)
{
using (var db = new ReportModels())
{
var comment = db.BC_SDNL_DS_TheoNam_Comment.Where(o => o.ReportID == ReportID && o.NoiDung != null).ToList();
if (comment != null && comment.Count > 0)
{
rptComment.DataSource = comment;
rptComment.DataBind();
}
}
}
void BindData()
{
ReportModels rp = new ReportModels();
var data = rp.DE_ReportFuel.FirstOrDefault(x => x.Id == ReportId && x.ReportType == ReportKey.PLAN);
if (data != null)
{
ltReportYear.Text = (data.Year - 1).ToString();
ltSolutionResult.Text = (data.Year - 1).ToString();
ltReportNext.Text = data.Year.ToString();
ltSolutionNextYear.Text = data.Year.ToString();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//if (Request.QueryString["RetUrl"] != null && Request.QueryString["RetUrl"] != "")
// ReturnUrl = Request.QueryString["RetUrl"];
//HttpCookie cookie = Request.Cookies["UserInfor_EVNTIT"];
//if (m_UserValidation.IsSigned())
//{
// if (ReturnUrl != "")
// Response.Redirect("~" + ReturnUrl);
// else
// Response.Redirect("~");
//}
//else
//{
// string err = Request.QueryString.Get("error");
// if (err == "1")
// error.Text = Resources.resource.Login_Err;
// if (err == "2")
// error.Text = Resources.resource.Login_Err_Exit;
//}
if (memberVal.IsSigned())
{
//error.Text = "<div class='alert alert-sm alert-danger bg-gradient'>Đã đăng nhập thành công</div>";
plUser.Visible = true;
plLogin.Visible = false;
lblTitle.Text = "Thông tin doanh nghiệp";
ReportModels reportModels = new ReportModels();
var eInfo = reportModels.DE_Enterprise.First(o => o.Id == memberVal.OrgId);
if (string.IsNullOrEmpty(eInfo.TaxCode))
{
ltAccountName.Text = memberVal.UserName;
}
else
{
ltAccountName.Text = eInfo.TaxCode;
}
BindUserName(memberVal.OrgId);
}
else
{
plUser.Visible = false;
plLogin.Visible = true;
lblTitle.Text = "Doanh nghiệp đăng nhập";
}
}
}
protected void BindUsingEnerySystem()
{
ReportModels reportModels = new ReportModels();
var res = reportModels.DE_UsingSystem.Where(o => o.SysState == 0 && o.SysGroup == ddlPhanLoaiHeThong.SelectedValue).ToList();
ddlUseSysName.DataValueField = "SysCode";
ddlUseSysName.DataTextField = "SysName";
ddlUseSysName.DataSource = res;
ddlUseSysName.DataBind();
ddlUseSysNamePlan.DataValueField = "SysCode";
ddlUseSysNamePlan.DataTextField = "SysName";
ddlUseSysNamePlan.DataSource = res;
ddlUseSysNamePlan.DataBind();
}
void BindData()
{
ReportModels rp = new ReportModels();
var data = rp.DE_ReportFuel.FirstOrDefault(x => x.Id == ReportId && x.ReportType == ReportKey.PLAN);
if (data != null)
{
ltReportYear.Text = (data.Year - 1).ToString();
ltSolutionResult.Text = (data.Year - 1).ToString();
ltReportNext.Text = data.Year.ToString();
ltSolutionNextYear.Text = data.Year.ToString();
}
ddlProductMeasurement.DataSource = rp.DE_Measurement.ToList();;
ddlProductMeasurement.DataValueField = "Id";
ddlProductMeasurement.DataTextField = "MeasurementName";
ddlProductMeasurement.DataBind();
}
//Binding
private void BindProductCapacity()
{
ReportModels rp = new ReportModels();
var data = (from a in rp.DE_Product
join b in rp.DE_ProductCapacity.Where(x => x.ReportId == ReportId && x.IsPlan == false) on a.Id equals b.ProductId into ab
from c in ab.DefaultIfEmpty()
join d in rp.DE_Fuel on a.FuelId equals d.Id
where a.EnterpriseId == memVal.OrgId
orderby a.ProductName ascending
select new
{
ProductId = a.Id,
ProductName = a.ProductName,
Measurement = a.Measurement,
FuelName = d.FuelName,
MaxQuantity = (c == null ? string.Empty : c.MaxQuantity.ToString()),
NangLucVanChuyenNguoi = (c == null ? string.Empty : c.NangLucVanChuyenNguoi.ToString()),
NangLucVanChuyenHang = (c == null ? string.Empty : c.NangLucVanChuyenHang.ToString())
}).ToList();
rptProductResult.DataSource = data;
rptProductResult.DataBind();
var dataNextYear = (from a in rp.DE_Product
join b in rp.DE_ProductCapacity.Where(x => x.ReportId == ReportId && x.IsPlan == true) on a.Id equals b.ProductId into ab
from c in ab.DefaultIfEmpty()
join d in rp.DE_Fuel on a.FuelId equals d.Id
where a.EnterpriseId == memVal.OrgId
orderby a.ProductOrder ascending
select new
{
ProductId = a.Id,
ProductName = a.ProductName,
Measurement = a.Measurement,
FuelName = d.FuelName,
MaxQuantity = (c == null ? string.Empty : c.MaxQuantity.ToString()),
NangLucVanChuyenNguoi = (c == null ? string.Empty : c.NangLucVanChuyenNguoi.ToString()),
NangLucVanChuyenHang = (c == null ? string.Empty : c.NangLucVanChuyenHang.ToString())
}).ToList();
rptProductPlan.DataSource = dataNextYear;
rptProductPlan.DataBind();
}
//Binding
private void BindProductCapacity()
{
ReportModels rp = new ReportModels();
var data = (from a in rp.DE_Product
join b in rp.DE_ProductCapacity.Where(x => x.ReportId == ReportId && x.IsPlan == false) on a.Id equals b.ProductId into ab
from c in ab.DefaultIfEmpty()
where a.EnterpriseId == memVal.OrgId
orderby a.ProductName ascending
select new
{
ProductId = a.Id,
ProductName = a.ProductName,
Measurement = a.Measurement != null ? a.Measurement : string.Empty,
DataReport1415 = c.DataReport1415,
MaxQuantity = (c == null ? string.Empty : c.MaxQuantity.ToString())
}).ToList();
rptProductResult.DataSource = data;
rptProductResult.DataBind();
}
void BindSubArea()
{
if (ddlArea.SelectedValue == "")
{
return;
}
ddlSubArea.Items.Clear();
int pId = Convert.ToInt32(ddlArea.SelectedValue);
if (pId > 0)
{
ReportModels rp = new ReportModels();
List <DE_Area> listArea = getListSubArea(pId);
ddlSubArea.DataSource = listArea;
ddlSubArea.DataTextField = "AreaName";
ddlSubArea.DataValueField = "Id";
ddlSubArea.DataBind();
ddlSubArea.Items.Insert(0, new ListItem("Chọn Phân ngành", ""));
}
}
protected void Page_Load(object sender, EventArgs e)
{
ReportModels rp = new ReportModels();
var en = rp.DE_Enterprise.FirstOrDefault(o => o.Id == memVal.OrgId);
var are = rp.DE_Area.FirstOrDefault(x => x.Id == en.SubAreaId);
if (are != null)
{
var temp = rp.DE_BaocaoLinhVuc.FirstOrDefault(x => x.TenMauBC.ToUpper() == are.Mau1x.ToUpper() && x.PhanLoaiBC == ReportKey.PLAN);
if (temp != null)
{
string ctName = temp.TenControl;
Control ct = LoadControl(ctName);
productYearContainer.Controls.Add(ct);
}
}
else
{
throw new Exception("Chưa cập nhật thông tin phân ngành");
}
}
void BindData()
{
//btnAddDevice.Visible = btnAddPlan.Visible = btnAddPlanDeviceNext.Visible = btnAddPlanNext.Visible = btnAddSolution.Visible = btnAddSolution2.Visible = AllowEdit;
ReportModels rp = new ReportModels();
var data = rp.DE_ReportFuel.FirstOrDefault(x => x.Id == ReportId && x.ReportType == ReportKey.PLAN);
if (data != null)
{
ltReportYear.Text = (data.Year - 1).ToString();
ltSolutionResult.Text = (data.Year - 1).ToString();
ltSolutionNextYear.Text = data.Year.ToString();
ltDuKienMucTieuThuNangLuong.Text = "2. Dự kiến mức tiêu thụ năng lượng năm " + (data.Year).ToString();
}
ddlProductMeasurement.DataSource = rp.DE_Measurement.ToList();;
ddlProductMeasurement.DataValueField = "Id";
ddlProductMeasurement.DataTextField = "MeasurementName";
ddlProductMeasurement.DataBind();
ddlProductMeasurement.Items.Insert(0, new ListItem("---Lựa chọn đơn vị tính(nếu có)---", "-1"));
}
protected void btPheDuyetBaoCao_Click(object sender, EventArgs e)
{
int RpId = 0;
if (Request.QueryString["Id"] != null)
{
int.TryParse(Request.QueryString["Id"], out RpId);
}
if (RpId > 0)
{
using (var db = new ReportModels())
{
var rp = db.BC_SDNL_DS_TheoNam.Where(o => o.AutoID == RpId).First();
rp.NoiDungPheDuyetSCT = txtNoiDungYKien.Text.Trim();
if (rdDongYBaoCao.Checked)
{
rp.TrangThai = 3; //Đồng ý phê duyệt
rp.NgayDuyetBC = DateTime.Now;
}
else
{
rp.TrangThai = 4;//Yêu cầu hiệu chỉnh
}
//Nội dung comment
BC_SDNL_DS_TheoNam_Comment comment = new BC_SDNL_DS_TheoNam_Comment();
comment.ReportID = RpId;
comment.NoiDung = txtNoiDungYKien.Text.Trim();
//comment.TaiKhoan = memberVal.UserName.ToUpper().Trim();
comment.TaiKhoan = m_UserValidation.UserName;
comment.ThoiGian = DateTime.Now;
db.BC_SDNL_DS_TheoNam_Comment.Add(comment);
db.SaveChanges();
Response.Redirect("~/Admin/SCTBaoCaoDangPheDuyet/Default.aspx");
}
}
}
public List <int> DN_Get_NamBaoCao(int id_dn)
{
try
{
List <int> result = new List <int>();
using (var ctx = new ReportModels())
{
if (ctx.BC_SDNL_HangNam.Any(o => o.IdDN == id_dn))
{
result = ctx.BC_SDNL_HangNam.GroupBy(o => new { NamBaoCao = o.NamBaoCao }).OrderByDescending(o => o.Key.NamBaoCao).Select(o => o.Key.NamBaoCao).ToList();
}
else
{
result.Add(DateTime.Now.Year);
}
return(result);
}
}
catch (Exception ex)
{
throw ex;
}
}
public List <ReportModels> GetListReport()
{
List <ReportModels> item = new List <ReportModels>();
var objData = new SqlConnection(con);
try
{
SqlCommand cmd = new SqlCommand("Report_Get", objData);
cmd.CommandType = CommandType.StoredProcedure;
objData.Open();
cmd.ExecuteNonQuery();
DataTable tbl = new DataTable();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(tbl);
foreach (DataRow row in tbl.Rows)
{
ReportModels obj = new ReportModels();
obj.ReportId = (int)row["ReportId"];
obj.Title = row["Title"].ToString();
obj.Content = row["Content"].ToString();
obj.SubmitDate = Convert.ToDateTime(row["SubmitDate"]);
obj.UserId = (int)row["UserId"];
obj.ImageUrl = row["ImageUrl"].ToString();
item.Add(obj);
}
}
catch (Exception objex)
{
throw objex;
}
finally
{
objData.Close();
}
return(item);
}
void BindFuel()
{
ReportModels rp = new ReportModels();
var list = (from a in rp.DE_Fuel
join b in rp.DE_GroupFuel on a.GroupFuelId equals b.Id
where b.GroupCode == ReportKey.FuelGroupKey_OIL || b.GroupCode == ReportKey.FuelGroupKey_GAS || b.GroupCode == ReportKey.FuelGroupKey_GASONLINE
orderby a.FuelOrder
select a).ToList();
//var list = rp.DE_Fuel.OrderBy(o => o.FuelOrder).ToList();
int GroupId = 0;
if (ddlFuelType.SelectedIndex > 0)
{
GroupId = Convert.ToInt32(ddlFuelType.SelectedValue);
}
var listSearch = from o in list where o.GroupFuelId == GroupId || GroupId == 0 select o;
ddlFuelType.DataSource = listSearch;
ddlFuelType.DataValueField = "Id";
ddlFuelType.DataTextField = "FuelName";
ddlFuelType.DataBind();
ddlFuelType.Items.Insert(0, new ListItem("---Chọn loại nhiên liệu---", ""));
ddlFuelType2.DataSource = listSearch;
ddlFuelType2.DataValueField = "Id";
ddlFuelType2.DataTextField = "FuelName";
ddlFuelType2.DataBind();
ddlFuelType2.Items.Insert(0, new ListItem("---Chọn loại nhiên liệu---", ""));
ddlProductFuel.DataSource = listSearch;
ddlProductFuel.DataValueField = "Id";
ddlProductFuel.DataTextField = "FuelName";
ddlProductFuel.DataBind();
}
/// <summary>
/// Отчет об ответах
/// </summary>
/// <param name="report">Информация о капче</param>
/// <returns></returns>
public Response Report(ReportModels report)
{
return(_request.Get(_urlRes, report.ToString()));
}
DataTable GetKQThucHienKeHoach()
{
StringBuilder sb = new StringBuilder();
DataTable tbl = new DataTable();
tbl.Columns.Add("Year", typeof(string));
for (int i = ReportYear - 5; i < ReportYear; i++)
{
tbl.Columns.Add(i.ToString(), typeof(string));
}
var firstRow = tbl.NewRow();
foreach (DataColumn col in tbl.Columns)
{
firstRow["Year"] = "Năm";
for (int i = ReportYear - 5; i < ReportYear; i++)
{
firstRow[i.ToString()] = i;
}
}
DataTable dtSolution = new DataTable();
int _startPlanYear = ReportYear - 4;
ReportModels rp = new ReportModels();
var Solution5Year = (from a in rp.DE_GiaiPhap
join b in rp.DE_PlanTKNL on a.Id equals b.IdGiaPhap
join c in rp.DE_ReportFuel on b.IdPlan equals c.Id
where c.EnterpriseId == memVal.OrgId && c.ReportType == ReportKey.PLAN && b.IsPlan == true &&
c.Year >= _startPlanYear && c.Year <= ReportYear
orderby c.Year
select new
{
DE_GiaiPhap = a,
DE_PlanTKNL = b,
DE_ReportFuel = c
}).ToList();
int _startResultYear = ReportYear - 5;
var Result5Year = (from a in rp.DE_GiaiPhap
join b in rp.DE_PlanTKNL on a.Id equals b.IdGiaPhap
join c in rp.DE_ReportFuel on b.IdPlan equals c.Id
where c.EnterpriseId == memVal.OrgId && c.ReportType == ReportKey.PLAN && b.IsPlan == false &&
c.Year >= _startResultYear && c.Year <= ReportYear && a.IsDelete == false
orderby c.Year
select new
{
DE_GiaiPhap = a,
DE_PlanTKNL = b,
DE_ReportFuel = c
}).ToList();
var ListSol = Solution5Year.Select(o => new { o.DE_GiaiPhap.Id, o.DE_GiaiPhap.TenGiaiPhap }).Distinct().ToList();
int _counter = 1;
foreach (var sol in ListSol)
{
var plan = Solution5Year.Where(o => o.DE_GiaiPhap.Id == sol.Id);
var result = Result5Year.Where(o => o.DE_GiaiPhap.Id == sol.Id);
var row1 = tbl.NewRow();
row1["Year"] = string.Format("<b>Giải pháp {0}: {1}</b>", _counter, sol.TenGiaiPhap);
var row2 = tbl.NewRow();
row2["Year"] = "Mức tiết kiệm năng lượng - Dự kiến theo kế hoạch (kWh)";
var row3 = tbl.NewRow();
row3["Year"] = "Mức tiết kiệm năng lượng - Thực tế đạt được (kWh)";
var row4 = tbl.NewRow();
row4["Year"] = "Mức tiết kiệm năng lượng - Dự kiến theo kế hoạch (%)";
var row5 = tbl.NewRow();
row5["Year"] = "Mức tiết kiệm năng lượng - Thực tế đạt được (%)";
var row6 = tbl.NewRow();
row6["Year"] = "Mức tiết kiệm chi phí - Dự kiến theo kế hoạch (Triệu đồng)";
var row7 = tbl.NewRow();
row7["Year"] = "Mức tiết kiệm chi phí - Thực tế đạt được (Triệu đồng)";
var row8 = tbl.NewRow();
row8["Year"] = "Chi phí - Dự kiến theo kế họach (Triệu đồng)";
var row9 = tbl.NewRow();
row9["Year"] = "Chi phí - Thực tế thực hiện (Triệu đồng)";
tbl.Rows.Add(row1);
tbl.Rows.Add(row2);
tbl.Rows.Add(row3);
tbl.Rows.Add(row4);
tbl.Rows.Add(row5);
tbl.Rows.Add(row6);
tbl.Rows.Add(row7);
tbl.Rows.Add(row8);
tbl.Rows.Add(row9);
//Mức tiết kiệm năng lượng - Dự kiến theo kế hoạch (kWh)
foreach (var p in plan)
{
foreach (DataColumn col in tbl.Columns)
{
if ((p.DE_ReportFuel.Year).ToString() == col.ColumnName)
{
row2[col.ColumnName] = p.DE_PlanTKNL.MucTietKiemDuKien != null ? p.DE_PlanTKNL.MucTietKiemDuKien : "";
row4[col.ColumnName] = p.DE_PlanTKNL.TuongDuong != null ? p.DE_PlanTKNL.TuongDuong : "";
row6[col.ColumnName] = p.DE_PlanTKNL.TKCPDuKien != null ? p.DE_PlanTKNL.TKCPDuKien : "";
row8[col.ColumnName] = p.DE_PlanTKNL.ChiPhiDuKien != null ? p.DE_PlanTKNL.ChiPhiDuKien : "";
}
}
}
//Mức tiết kiệm năng lượng - Thực tế đạt được (kWh)
foreach (var re in result)
{
foreach (DataColumn col in tbl.Columns)
{
if ((re.DE_ReportFuel.Year - 1).ToString() == col.ColumnName)
{
row3[col.ColumnName] = re.DE_PlanTKNL.MucTKThucTe != null ? re.DE_PlanTKNL.MucTKThucTe : "";
row5[col.ColumnName] = re.DE_PlanTKNL.TuongDuongTT != null ? re.DE_PlanTKNL.TuongDuongTT : "";
row7[col.ColumnName] = re.DE_PlanTKNL.MucTKCPThucTe != null ? re.DE_PlanTKNL.MucTKCPThucTe : "";
row9[col.ColumnName] = re.DE_PlanTKNL.CPThucTe != null ? re.DE_PlanTKNL.CPThucTe : "";
}
}
}
_counter++;
}
rptResultSolutionPlan5.DataSource = tbl;
rptResultSolutionPlan5.DataBind();
return(tbl);
}
protected void btAddElectrictFutureUpdate_Click(object sender, EventArgs e)
{
ReportModels rp = new ReportModels();
//DE_UsingElectrict
var checkUsingElectrict = rp.DE_UsingElectrict.Any(x => x.ReportId == ReportId && x.IsPlan == true);
var _usingElectrict = new DE_UsingElectrict();
if (checkUsingElectrict == true)
{
_usingElectrict = rp.DE_UsingElectrict.FirstOrDefault(x => x.ReportId == ReportId && x.IsPlan == true);
}
else
{
_usingElectrict.ReportId = ReportId;
_usingElectrict.IsPlan = true;
_usingElectrict.ReportYear = ReportYear;
_usingElectrict.FuelId = 0;
}
if (txtUsingElectrictFuture_InstalledCapacity.Text.Trim() != "")
{
_usingElectrict.InstalledCapacity = Convert.ToDecimal(txtUsingElectrictFuture_InstalledCapacity.Text.Trim(), culture);
}
if (txtUsingElectrictFuture_Quantity.Text.Trim() != "")
{
_usingElectrict.Quantity = Convert.ToDecimal(txtUsingElectrictFuture_Quantity.Text.Trim(), culture);
}
if (txtUsingElectrictFuture_CongSuatBanRa.Text.Trim() != "")
{
_usingElectrict.CongSuatBan = Convert.ToDecimal(txtUsingElectrictFuture_CongSuatBanRa.Text.Trim(), culture);
}
if (txtUsingElectrictFuture_SanLuongBanRa.Text.Trim() != "")
{
_usingElectrict.SanLuongBan = Convert.ToDecimal(txtUsingElectrictFuture_SanLuongBanRa.Text.Trim(), culture);
}
if (checkUsingElectrict == false)
{
rp.DE_UsingElectrict.Add(_usingElectrict);
}
//DE_ElectrictProduce
var checkElectrictSelfProduce = rp.DE_ElectrictProduce.Any(x => x.ReportId == ReportId);
if (checkElectrictSelfProduce == true) //Update DE_ElectrictProduce
{
var tempData = rp.DE_ElectrictProduce.Where(x => x.ReportId == ReportId).ToList();
foreach (RepeaterItem ri in rptUsingElectrictFuture.Items)
{
TextBox txtInstalledCapacity = ri.FindControl("txtInstalledCapacity") as TextBox;
TextBox txtProduceQty = ri.FindControl("txtProduceQty") as TextBox;
HiddenField hdTechKey = ri.FindControl("hdTechKey") as HiddenField;
var tmp = tempData.FirstOrDefault(x => x.TechKey == hdTechKey.Value);
if (tmp != null)
{
if (txtInstalledCapacity.Text.Trim() != "")
{
tmp.InstalledCapacity = Convert.ToDecimal(txtInstalledCapacity.Text.Trim(), culture);
}
if (txtProduceQty.Text.Trim() != "")
{
tmp.ProduceQty = Convert.ToDecimal(txtProduceQty.Text.Trim(), culture);
}
}
}
}
else //Insert DE_ElectrictProduce
{
foreach (RepeaterItem ri in rptUsingElectrictFuture.Items)
{
TextBox txtInstalledCapacity = ri.FindControl("txtInstalledCapacity") as TextBox;
TextBox txtProduceQty = ri.FindControl("txtProduceQty") as TextBox;
HiddenField hdTechKey = ri.FindControl("hdTechKey") as HiddenField;
DE_ElectrictProduce _usingElectrictInserted = new DE_ElectrictProduce();
_usingElectrictInserted.ReportId = ReportId;
_usingElectrictInserted.ReportYear = ReportYear;
_usingElectrictInserted.TechKey = hdTechKey.Value;
_usingElectrictInserted.IsPlan = true;
if (txtInstalledCapacity.Text.Trim() != "")
{
_usingElectrictInserted.InstalledCapacity = Convert.ToDecimal(txtInstalledCapacity.Text.Trim(), culture);
}
if (txtProduceQty.Text.Trim() != "")
{
_usingElectrictInserted.ProduceQty = Convert.ToDecimal(txtProduceQty.Text.Trim(), culture);
}
rp.DE_ElectrictProduce.Add(_usingElectrictInserted);
}
}
rp.SaveChanges();
btAddElectrictFutureCancel_Click(sender, e);
}
protected void btAddFuelFutureUpdate_Click(object sender, EventArgs e)
{
ReportModels rp = new ReportModels();
var listFuelDetail = rp.DE_ReportFuelDetail.Where(x => x.ReportId == ReportId && x.IsNextYear == true).ToList();
foreach (RepeaterItem ri in rptFuelFuture.Items)
{
TextBox txtNoFuel = ri.FindControl("txtNoFuel") as TextBox;
TextBox txtReason = ri.FindControl("txtReason") as TextBox;
HiddenField hdFuelId = ri.FindControl("hdFuelId") as HiddenField;
int _FuelId = Convert.ToInt32(hdFuelId.Value);
decimal tmpDecimal = 0;
if (txtNoFuel.Text != "")
{
decimal.TryParse(txtNoFuel.Text, style, culture, out tmpDecimal);
}
var _existedFuel = listFuelDetail.FirstOrDefault(o => o.FuelId == _FuelId);
if (_existedFuel != null)
{
_existedFuel.NoFuel = tmpDecimal;
_existedFuel.Reason = txtReason.Text.Trim();
}
else
{
HiddenField hdGroupFuelId = ri.FindControl("hdGroupFuelId") as HiddenField;
HiddenField hdMeasurementId = ri.FindControl("hdMeasurementId") as HiddenField;
var _insertd = new DE_ReportFuelDetail
{
FuelId = _FuelId,
NoFuel = tmpDecimal,
ReportId = ReportId,
EnterpriseId = memVal.OrgId,
Year = ReportYear,
IsNextYear = true,
Reason = txtReason.Text.Trim(),
GroupFuelId = Convert.ToInt32(hdMeasurementId.Value),
MeasurementId = Convert.ToInt32(hdMeasurementId.Value),
};
rp.DE_ReportFuelDetail.Add(_insertd);
}
}
//SaveChanges
rp.SaveChanges();
btAddFuelFuture.Visible = true;
btAddFuelFutureUpdate.Visible = false;
btAddFuelFutureCancel.Visible = false;
foreach (RepeaterItem ri in rptFuelFuture.Items)
{
TextBox txtNoFuel = ri.FindControl("txtNoFuel") as TextBox;
txtNoFuel.ReadOnly = true;
TextBox txtReason = ri.FindControl("txtReason") as TextBox;
txtReason.ReadOnly = true;
}
}
protected void btnUpdateProductResult_Click(object sender, EventArgs e)
{
ReportModels rp = new ReportModels();
if (rp.DE_ProductCapacity.Any(x => x.ReportId == ReportId && x.IsPlan == false)) //Update
{
var tempData = rp.DE_ProductCapacity.Where(x => x.ReportId == ReportId && x.IsPlan == false).ToList();
foreach (RepeaterItem ri in rptProductResult.Items)
{
TextBox txtMaxQuantity = ri.FindControl("txtMaxQuantity") as TextBox;
HiddenField hdProductId = ri.FindControl("hdProductId") as HiddenField;
TextBox txtNangLucVanChuyenNguoi = ri.FindControl("txtNangLucVanChuyenNguoi") as TextBox;
TextBox txtNangLucVanChuyenHang = ri.FindControl("txtNangLucVanChuyenHang") as TextBox;
RadioButton radio1 = ri.FindControl("radio1") as RadioButton;
RadioButton radio2 = ri.FindControl("radio2") as RadioButton;
int ProductId = Convert.ToInt32(hdProductId.Value);
var pcInfo = tempData.FirstOrDefault(x => x.ProductId == ProductId);
decimal tmpDecimal = 0;
if (decimal.TryParse(txtMaxQuantity.Text, style, culture, out tmpDecimal))
{
pcInfo.MaxQuantity = tmpDecimal;
}
else
{
pcInfo.MaxQuantity = 0;
}
if (radio1.Checked && txtNangLucVanChuyenNguoi.Text.Trim() != "")
{
pcInfo.NangLucVanChuyenNguoi = Convert.ToDecimal(txtNangLucVanChuyenNguoi.Text.Trim(), culture);
}
if (radio2.Checked && txtNangLucVanChuyenHang.Text.Trim() != "")
{
pcInfo.NangLucVanChuyenHang = Convert.ToDecimal(txtNangLucVanChuyenHang.Text.Trim(), culture);
}
}
rp.SaveChanges();
}
else //Insert
{
foreach (RepeaterItem ri in rptProductResult.Items)
{
DE_ProductCapacity pcInfo = new DE_ProductCapacity();
TextBox txtMaxQuantity = ri.FindControl("txtMaxQuantity") as TextBox;
HiddenField hdProductId = ri.FindControl("hdProductId") as HiddenField;
TextBox txtNangLucVanChuyenNguoi = ri.FindControl("txtNangLucVanChuyenNguoi") as TextBox;
TextBox txtNangLucVanChuyenHang = ri.FindControl("txtNangLucVanChuyenHang") as TextBox;
RadioButton radio1 = ri.FindControl("radio1") as RadioButton;
RadioButton radio2 = ri.FindControl("radio2") as RadioButton;
int ProductId = Convert.ToInt32(hdProductId.Value);
pcInfo.ProductId = ProductId;
pcInfo.ReportId = ReportId;
pcInfo.IsPlan = false;
pcInfo.ReportYear = ReportYear;
decimal tmpDecimal = 0;
if (decimal.TryParse(txtMaxQuantity.Text, style, culture, out tmpDecimal))
{
pcInfo.MaxQuantity = tmpDecimal;
}
else
{
pcInfo.MaxQuantity = 0;
}
if (radio1.Checked && txtNangLucVanChuyenNguoi.Text.Trim() != "")
{
pcInfo.NangLucVanChuyenNguoi = Convert.ToDecimal(txtNangLucVanChuyenNguoi.Text.Trim(), culture);
}
else
{
pcInfo.NangLucVanChuyenNguoi = 0;
}
if (radio2.Checked && txtNangLucVanChuyenHang.Text.Trim() != "")
{
pcInfo.NangLucVanChuyenHang = Convert.ToDecimal(txtNangLucVanChuyenHang.Text.Trim(), culture);
}
else
{
pcInfo.NangLucVanChuyenHang = 0;
}
rp.DE_ProductCapacity.Add(pcInfo);
}
rp.SaveChanges();
}
btnCancelProductResult_Click(sender, e);
}
protected void btnAddProductNextResultUpdate_Click(object sender, EventArgs e)
{
ReportModels rp = new ReportModels();
if (rp.DE_ProductCapacity.Any(x => x.ReportId == ReportId && x.IsPlan == true)) //Update
{
var tempData = rp.DE_ProductCapacity.Where(x => x.ReportId == ReportId && x.IsPlan == true).ToList();
foreach (RepeaterItem ri in rptProductPlan.Items)
{
TextBox txtMaxQuantity = ri.FindControl("txtMaxQuantity") as TextBox;
TextBox txtDesignQuantity = ri.FindControl("txtDesignQuantity") as TextBox;
HiddenField hdProductId = ri.FindControl("hdProductId") as HiddenField;
int ProductId = Convert.ToInt32(hdProductId.Value);
var pcInfo = tempData.FirstOrDefault(x => x.ProductId == ProductId);
decimal tmpDecimal = 0;
if (decimal.TryParse(txtMaxQuantity.Text, style, culture, out tmpDecimal))
{
pcInfo.MaxQuantity = tmpDecimal;
}
else
{
pcInfo.MaxQuantity = 0;
}
if (decimal.TryParse(txtDesignQuantity.Text, style, culture, out tmpDecimal))
{
pcInfo.DesignQuantity = tmpDecimal;
}
else
{
pcInfo.DesignQuantity = 0;
}
}
rp.SaveChanges();
}
else //Insert
{
foreach (RepeaterItem ri in rptProductPlan.Items)
{
DE_ProductCapacity pcInfo = new DE_ProductCapacity();
TextBox txtMaxQuantity = ri.FindControl("txtMaxQuantity") as TextBox;
TextBox txtDesignQuantity = ri.FindControl("txtDesignQuantity") as TextBox;
HiddenField hdProductId = ri.FindControl("hdProductId") as HiddenField;
int ProductId = Convert.ToInt32(hdProductId.Value);
pcInfo.ProductId = ProductId;
pcInfo.ReportId = ReportId;
pcInfo.IsPlan = true;
pcInfo.ReportYear = ReportYear;
decimal tmpDecimal = 0;
if (decimal.TryParse(txtMaxQuantity.Text, style, culture, out tmpDecimal))
{
pcInfo.MaxQuantity = tmpDecimal;
}
else
{
pcInfo.MaxQuantity = 0;
}
if (decimal.TryParse(txtDesignQuantity.Text, style, culture, out tmpDecimal))
{
pcInfo.DesignQuantity = tmpDecimal;
}
else
{
pcInfo.DesignQuantity = 0;
}
rp.DE_ProductCapacity.Add(pcInfo);
}
rp.SaveChanges();
}
btnAddProductNextResultCancel_Click(sender, e);
}
