void BindFuel() { ddlFuel.Items.Clear(); IList <Fuel> list = new List <Fuel>(); if (!AspNetCache.CheckCache(Constants.Cache_ReportFuel_Fuel_All)) { list = new FuelService().FindAll(); AspNetCache.SetCache(Constants.Cache_ReportFuel_Fuel_All, list); } else { list = (IList <Fuel>)AspNetCache.GetCache(Constants.Cache_ReportFuel_Fuel_All); } //int GroupId = 0; //if (ddlFuelType.SelectedIndex > 0) // GroupId = Convert.ToInt32(ddlFuelType.SelectedValue); //ddlFuelType.DataSource = list; var listSearch = from o in list orderby o.FuelName ascending select o; ddlFuel.DataSource = listSearch; ddlFuel.DataValueField = "Id"; ddlFuel.DataTextField = "FuelName"; ddlFuel.DataBind(); ddlFuel.Items.Insert(0, new ListItem("---Chọn nhiên liệu---", "")); if (ddlFuel.Items.Count == 2) { ddlFuel.SelectedIndex = 1; } BindMeasurement(); }
void BindFuel() { ddlFuelType.Items.Clear(); IList <Fuel> list = new List <Fuel>(); if (!AspNetCache.CheckCache(Constants.Cache_ReportFuel_Fuel_All)) { list = new FuelService().FindAll(); AspNetCache.SetCache(Constants.Cache_ReportFuel_Fuel_All, list); } else { list = (IList <Fuel>)AspNetCache.GetCache(Constants.Cache_ReportFuel_Fuel_All); } 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---", "")); }
protected void grvFuel_RowCommand(object sender, GridViewCommandEventArgs e) { string aId = e.CommandArgument.ToString(); string aName = e.CommandName.ToLower(); int fid = 0; try { fid = Convert.ToInt32(aId); } catch { } if (fid > 0) { Fuel fuel = new FuelService().FindByKey(fid); if (fuel != null) { if (aName.Contains("_edit")) { hdnEditId.Value = fid.ToString(); txtTitle.Text = fuel.FuelName; try { if (fuel.GroupFuelId > 0) { ddlGroupFuel.SelectedValue = fuel.GroupFuelId.ToString(); } } catch { } try { if (fuel.MeasurementId > 0) { ddlMeasurement.SelectedValue = fuel.MeasurementId.ToString(); } } catch { } ScriptManager.RegisterStartupScript(this, GetType(), "showform", "updateFuel();", true); } else if (aName.Contains("_delete")) { long iDelete = 0; iDelete = new FuelService().Delete(fid); if (iDelete > 0) { BindData(); } } } } }
void BindData() { FuelService objFuelService = new FuelService(); DataTable list = new DataTable(); ePower.Core.PagingInfo paging = new ePower.Core.PagingInfo(PageSize, CurrentPage); int groupId = 0; string strKey = string.Empty; if (txtKeyword.Text != "" && txtKeyword.Text.Trim() != "") { strKey = txtKeyword.Text.Trim(); } if (ddlParent.SelectedIndex > 0) { groupId = Convert.ToInt32(ddlParent.SelectedValue); } list = objFuelService.FindFuelList(strKey, 0, groupId, paging, true); if (list != null && list.Rows.Count > 0) { paging.RowsCount = Convert.ToInt32(list.Rows[0]["Total"]); Paging.PageSize = PageSize; Paging.CurrentPage = CurrentPage; Paging.TotalRecord = Convert.ToInt32(list.Rows[0]["Total"]); Paging.DataLoad(); if (paging.PagesCount <= 1) { ltrTotal.Text = "Tổng số " + paging.RowsCount + " nhiên liệu"; Paging.Visible = false; } else { int st = (CurrentPage - 1) * PageSize + 1; long end = CurrentPage * PageSize; if (end > paging.RowsCount) { end = paging.RowsCount; } ltrTotal.Text = "Đang xem trang " + CurrentPage + ". Hiển thị từ " + st + " - " + end + " trên tổng số " + paging.RowsCount + " nhiên liệu"; Paging.Visible = true; } } else { ltrTotal.Text = ""; Paging.Visible = false; } grvFuel.DataSource = list; grvFuel.DataBind(); }
protected void rptAuditReport_ItemDataBound(object sender, RepeaterItemEventArgs e) { Literal ltSaveTOE = (Literal)e.Item.FindControl("ltSaveTOE"); Literal ltTotalTOE = (Literal)e.Item.FindControl("ltTotalTOE"); StringBuilder sb = new StringBuilder(); DataRowView dr = (DataRowView)e.Item.DataItem; if (dr != null) { int eID = Convert.ToInt32(dr["Id"]); DataSet dsFuel = new AuditReportService().GetTOEByAuditReport(eID); IList <Fuel> listFuel = new List <Fuel>(); if (!AspNetCache.CheckCache(Constants.Cache_ReportFuel_Fuel_All)) { listFuel = new FuelService().FindAll(); AspNetCache.SetCache(Constants.Cache_ReportFuel_Fuel_All, listFuel); } else { listFuel = (IList <Fuel>)AspNetCache.GetCache(Constants.Cache_ReportFuel_Fuel_All); } decimal dsum = 0; decimal NoTOE = 0; decimal dsumTK = 0; decimal NoTOETK = 0; if (dsFuel != null && dsFuel.Tables.Count > 0) { for (int i = 0; i < dsFuel.Tables[0].Rows.Count; i++) { dsum = dsum + Convert.ToDecimal(dsFuel.Tables[0].Rows[i]["NoCO2"]); NoTOE = NoTOE + Convert.ToDecimal(dsFuel.Tables[0].Rows[i]["NoTOE"]); } for (int i = 0; i < dsFuel.Tables[1].Rows.Count; i++) { dsumTK = dsumTK + Convert.ToDecimal(dsFuel.Tables[1].Rows[i]["NoCO2"]); NoTOETK = NoTOETK + Convert.ToDecimal(dsFuel.Tables[1].Rows[i]["NoTOE"]); } } decimal rate = 0; if (NoTOE > 0) { rate = Math.Round((NoTOETK / NoTOE) * 100, 2); } ltSaveTOE.Text = rate.ToString() + "%"; ltTotalTOE.Text = Tool.ConvertDecimalToString(NoTOE, 2); } }
void BindData() { FuelService objFuelService = new FuelService(); DataTable list = new DataTable(); ePower.Core.PagingInfo paging = new ePower.Core.PagingInfo(1000, 1); int groupId = 0; string strKey = string.Empty; if (ddlParent.SelectedIndex > 0) { groupId = Convert.ToInt32(ddlParent.SelectedValue); } list = objFuelService.FindFuelList(strKey, 0, groupId, paging, true); grvFuel.DataSource = list; grvFuel.DataBind(); }
private ReportFuelDetail ReceiveHtmlDetail() { ReportFuelDetail rep = new ReportFuelDetail(); if (ddlFuel.SelectedIndex > 0) { rep.FuelId = Convert.ToInt32(ddlFuel.SelectedValue); } if (rep.FuelId > 0) { Fuel fuel = new FuelService().FindByKey(rep.FuelId); if (fuel != null) { rep.GroupFuelId = fuel.GroupFuelId; } } //if (ddlFuel.SelectedIndex > 0) // rep.GroupFuelId = Convert.ToInt32(ddlFuelType.SelectedValue); if (ddlMeasure.SelectedIndex > 0) { rep.MeasurementId = Convert.ToInt32(ddlMeasure.SelectedValue); } if (txtNoFuel.Text.Trim() != "") { rep.NoFuel = Convert.ToDecimal(txtNoFuel.Text.Trim()); } if (txtNoTOE.Text.Trim() != "") { rep.No_RateTOE = Convert.ToDecimal(txtNoTOE.Text.Trim()); } rep.Reason = txtPropose.Text.Trim(); if (txtPrice.Text.Trim() != "") { rep.Price = Convert.ToDecimal(txtPrice.Text.Trim()); } rep.IsNextYear = (hdnNextYear.Value == "1"); rep.Year = ReportYear; rep.ReportId = ReportId; rep.EnterpriseId = memVal.OrgId; rep.NoFuel_TOE = rep.NoFuel * rep.No_RateTOE; return(rep); }
void BindFuel() { ddlFuelType.Items.Clear(); IList <Fuel> list = new List <Fuel>(); if (!AspNetCache.CheckCache(Constants.Cache_ReportFuel_Fuel_All)) { list = new FuelService().FindAll(); AspNetCache.SetCache(Constants.Cache_ReportFuel_Fuel_All, list); } else { list = (IList <Fuel>)AspNetCache.GetCache(Constants.Cache_ReportFuel_Fuel_All); } var listSearch = from o in list orderby o.FuelName ascending 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---", "")); }
public FuelServiceTestBase() { fuelService = new FuelService(); }
protected void btnSave_Click(object sender, EventArgs e) { FuelService fuelService = new FuelService(); Fuel fuel = new Fuel(); int FuelId = 0; if (hdnEditId.Value != "") { try { FuelId = Convert.ToInt32(hdnEditId.Value.Trim()); } catch { } } fuel.FuelName = txtTitle.Text.Trim(); if (ddlGroupFuel.SelectedIndex > 0) { fuel.GroupFuelId = Convert.ToInt32(ddlGroupFuel.SelectedValue); } if (ddlMeasurement.SelectedIndex > 0) { fuel.MeasurementId = Convert.ToInt32(ddlMeasurement.SelectedValue); } if (FuelId > 0) { fuel.Id = FuelId; if (fuelService.Update(fuel) != null) { BindData(); hdnEditId.Value = "0"; } else { ScriptManager.RegisterStartupScript(this, GetType(), "showform", "updateFuel();", true); } } else { int id = fuelService.Insert(fuel); if (id > 0) { MeasurementFuelService measurementFuelService = new MeasurementFuelService(); MeasurementFuel objMeasurementFuel = new MeasurementFuel(); if (txtNoCO2_S.Text != "") { objMeasurementFuel.NoCO2 = Convert.ToDecimal(txtNoCO2_S.Text.Trim()); } if (txtFromTOE_S.Text != "" && txtToTOE_S.Text.Trim() != "" && ddlMeasurement.SelectedValue != "" && id > 0) { if (ddlMeasurement.SelectedValue != "") { objMeasurementFuel.MeasurementId = Convert.ToInt32(ddlMeasurement.SelectedValue); } objMeasurementFuel.FuelId = fuel.Id; decimal dfrom = 0; decimal dto = 0; try { dfrom = Convert.ToDecimal(txtFromTOE_S.Text); } catch { } if (txtToTOE_S.Text != "" && txtToTOE_S.Text.Trim() != "") { try { dto = Convert.ToDecimal(txtToTOE_S.Text.Trim()); } catch { } } if (dfrom > 0) { objMeasurementFuel.From_TOE = dfrom; objMeasurementFuel.TOE = dfrom; } if (dto >= 0 && dto > dfrom) { objMeasurementFuel.To_TOE = dto; } } measurementFuelService.UpdateTOE(objMeasurementFuel.FuelId, objMeasurementFuel.MeasurementId, objMeasurementFuel.From_TOE, objMeasurementFuel.To_TOE); BindData(); } else { ScriptManager.RegisterStartupScript(this, GetType(), "showform", "addFuel();", true); } } }
public Task UpdateFuelServiceAsync(FuelService fuelService) { return(_db.UpdateAsync(fuelService)); }
//void BindEnterprise() //{ // int EnterpriseId = 1; // Enterprise enter = new Enterprise(); // enter = new EnterpriseService().FindByKey(EnterpriseId); // if (enter != null) // { // txtEnterpriseName.Text = enter.Title; // if (enter.SubAreaId > 0) // ddlSubArea.SelectedValue = enter.SubAreaId.ToString(); // if (enter.AreaId > 0) // ddlArea.SelectedValue = enter.AreaId.ToString(); // if (enter.ProvinceId > 0) // ddlProvince.SelectedValue = enter.ProvinceId.ToString(); // if (enter.DistrictId > 0) // ddlDistrict.SelectedValue = enter.DistrictId.ToString(); // txtAddress.Text = enter.Address; // txtEmail.Text = enter.Email; // txtFax.Text = enter.Fax; // txtPhone.Text = enter.Phone; // txtReportName.Text = enter.ManPerson; // if (enter.ManProvinceId > 0) // ddlProvinceReporter.SelectedValue = enter.ManProvinceId.ToString(); // if (enter.ManDistrictId > 0) // ddlDistrictReporter.SelectedValue = enter.ManDistrictId.ToString(); // txtAddressReporter.Text = enter.ManAddress; // txtEmail.Text = enter.ManEmail; // txtFaxReporter.Text = enter.ManFax; // txtPhoneReporter.Text = enter.ManPhone; // } //} //void BindOrganization() //{ // IList<Organization> list = new List<Organization>(); // if (!AspNetCache.CheckCache(Constants.Cache_ReportFuel_Organization_All)) // { // list = new OrganizationService().FindAll(); // AspNetCache.SetCache(Constants.Cache_ReportFuel_Organization_All, list); // } // else // list = (IList<Organization>)AspNetCache.GetCache(Constants.Cache_ReportFuel_Organization_All); // ddlOrg.DataSource = list; // ddlOrg.DataTextField = "Title"; // ddlOrg.DataValueField = "Id"; // ddlOrg.DataBind(); // ddlOrg.Items.Insert(0, new ListItem("---Tất cả---", "")); //} private void BindData() { ltData.Text = ""; IList <Fuel> listFuel = new List <Fuel>(); if (!AspNetCache.CheckCache(Constants.Cache_ReportFuel_Fuel_All)) { listFuel = new FuelService().FindAll(); AspNetCache.SetCache(Constants.Cache_ReportFuel_Fuel_All, listFuel); } else { listFuel = (IList <Fuel>)AspNetCache.GetCache(Constants.Cache_ReportFuel_Fuel_All); } //IList<GroupFuel> listGroupFuel = new List<GroupFuel>(); //if (!AspNetCache.CheckCache(Constants.Cache_ReportFuel_GroupFuel_All)) //{ // listGroupFuel = new GroupFuelService().FindAll(); // AspNetCache.SetCache(Constants.Cache_ReportFuel_GroupFuel_All, listGroupFuel); //} //else // listGroupFuel = (IList<GroupFuel>)AspNetCache.GetCache(Constants.Cache_ReportFuel_GroupFuel_All); ReportFuelService comBSO = new ReportFuelService(); DataTable list = new DataTable(); int AreaId = 0; int DistrictId = 0; int Year = 0; if (ddlArea.SelectedIndex > 0) { AreaId = Convert.ToInt32(ddlArea.SelectedValue); } if (ddlDistrict.SelectedIndex > 0) { DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue); } if (ddlYear.SelectedIndex > 0) { Year = Convert.ToInt32(ddlYear.SelectedValue); } ePower.Core.PagingInfo paging = new ePower.Core.PagingInfo(PageSize, CurrentPage); list = comBSO.FindList(false, AreaId, 0, m_UserValidation.OrgId, 0, DistrictId, 0, -1, true, Year, null, null, txtKeyword.Text.Trim(), paging); ltHeader.Text = ""; //foreach (GroupFuel group in listGroupFuel) //{ // ltHeader.Text = ltHeader.Text + "<th>" + group.Title + " (" + group.MeasurementName + ")</th>"; //} foreach (Fuel fuel in listFuel) { ltHeader.Text = ltHeader.Text + "<th>" + fuel.FuelName + "</th>"; } if (list != null && list.Rows.Count > 0) { StringBuilder sb = new StringBuilder(); for (int i = 0; i < list.Rows.Count; i++) { sb.Append("<tr><td class='text-center'>" + (i + 1) + "</td>"); sb.Append("<td>" + list.Rows[i]["Title"] + "</td>"); sb.Append("<td>" + list.Rows[i]["Address"] + "</td>"); //sb.Append("<td>" + list.Rows[i]["ProvinceName"] + "</td>"); //sb.Append("<td></td>");//Vung //sb.Append("<td>" + list.Rows[i]["RegionName"] + "</td>");//Vung sb.Append("<td>" + list.Rows[i]["ParentAreaName"] + "</td>"); sb.Append("<td>" + list.Rows[i]["AreaName"] + "</td>"); if (list.Rows[i]["Id"] != null && list.Rows[i]["Id"].ToString() != "") { int ReportId = Convert.ToInt32(list.Rows[i]["Id"]); if (ReportId > 0) { DataTable listDetail = new ReportFuelDetailService().GetFuelTOEByReport(ReportId, false); int SumTOE = 0; if (listDetail != null && listDetail.Rows.Count > 0) { foreach (Fuel fuel in listFuel) { DataRow[] dr = listDetail.Select("FuelId=" + fuel.Id); if (dr != null && dr.Count() > 0) { sb.Append("<td>"); for (int j = 0; j < dr.Count(); j++) { if (dr[j]["NoFuel_TOE"] != DBNull.Value) { SumTOE = SumTOE + Convert.ToInt32(dr[j]["NoFuel_TOE"]); sb.Append(dr[j]["NoFuel"] + " (" + dr[j]["MeasurementName"] + ")"); } } sb.Append("</td>"); } else { sb.Append("<td>0</td>"); } } sb.Append("<td>" + SumTOE + "</td>"); } else { for (int j = 0; j < listFuel.Count; j++) { sb.Append("<td>0</td>"); } sb.Append("<td>0</td>"); } } sb.Append("</tr>"); } } ltData.Text = sb.ToString(); paging.RowsCount = Convert.ToInt32(list.Rows[0]["Total"]); Paging.PageSize = PageSize; Paging.CurrentPage = CurrentPage; Paging.TotalRecord = Convert.ToInt32(list.Rows[0]["Total"]); Paging.DataLoad(); if (paging.PagesCount <= 1) { ltNotice.Text = "Có tổng số " + paging.RowsCount + " báo cáo"; Paging.Visible = false; } else { ltNotice.Text = "Có" + list.Rows.Count + " trong tổng số " + paging.RowsCount + " báo cáo"; Paging.Visible = true; } } else { ltNotice.Text = ""; Paging.Visible = false; } }
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 BindElectrictPlan() { UsingElectrict usingElectrict = new UsingElectrict(); UsingElectrictService usingElectrictService = new UsingElectrictService(); try { usingElectrict = usingElectrictService.GetUsingElectrictByReport(ReportId, true); if (usingElectrict != null) { if (usingElectrict.InstalledCapacity > 0) { ltInstalledCapacityPlan.Text = usingElectrict.InstalledCapacity.ToString() + "(kV)"; } else { ltInstalledCapacityPlan.Text = ""; } if (usingElectrict.Capacity > 0) { ltCapacityPlan.Text = usingElectrict.Capacity.ToString() + "(kV)"; } else { ltCapacityPlan.Text = ""; } if (usingElectrict.BuyCost > 0) { ltPriceBuyPlan.Text = usingElectrict.BuyCost.ToString() + "(đồng/kWh)"; } else { ltPriceBuyPlan.Text = ""; } if (usingElectrict.ProduceQty > 0) { ltQuantityProducePlan.Text = usingElectrict.ProduceQty.ToString() + "(10<sup>6</sup> kWh/năm)"; } else { ltQuantityProducePlan.Text = ""; } if (usingElectrict.Technology != null) { ltTecnologyPlan.Text = usingElectrict.Technology.ToString(); } if (usingElectrict.Quantity > 0) { ltQuantityElectrictPlan.Text = usingElectrict.Quantity.ToString() + "(10<sup>6</sup> kWh/năm)"; } else { ltQuantityElectrictPlan.Text = ""; } if (usingElectrict.PriceProduce > 0) { ltPriceProducePlan.Text = usingElectrict.PriceProduce.ToString() + "(đồng/kWh)"; } else { ltPriceProducePlan.Text = ""; } Fuel fuel = new Fuel(); if (usingElectrict.FuelId > 0) { fuel = new FuelService().FindByKey(usingElectrict.FuelId); if (fuel != null) { ltFuelPlan.Text = fuel.FuelName; } } } } catch { } }
void BindElectrictResult() { UsingElectrict usingElectrict = new UsingElectrict(); UsingElectrictService usingElectrictService = new UsingElectrictService(); try { usingElectrict = usingElectrictService.GetUsingElectrictByReport(ReportId, false); if (usingElectrict != null) { if (usingElectrict.InstalledCapacity > 0) { ltInstalledResult.Text = usingElectrict.InstalledCapacity.ToString() + "(kV)"; } else { ltInstalledResult.Text = ""; } if (usingElectrict.Capacity > 0) { ltCapacityResult.Text = usingElectrict.Capacity.ToString() + "(kV)"; } else { ltCapacityResult.Text = ""; } if (usingElectrict.BuyCost > 0) { ltCostTotalResult.Text = usingElectrict.BuyCost.ToString() + "(10<sup>3</sup>đồng)"; } else { ltCostTotalResult.Text = ""; } if (usingElectrict.ProduceQty > 0) { ltQuantityProduceResult.Text = usingElectrict.ProduceQty.ToString() + "(10<sup>6</sup> kWh/năm)"; } else { ltQuantityProduceResult.Text = ""; } if (usingElectrict.Technology != null) { ltTechnologyResult.Text = usingElectrict.Technology.ToString(); } if (usingElectrict.Quantity > 0) { ltQuantityResult.Text = usingElectrict.Quantity.ToString() + "(10<sup>6</sup> kWh/năm)"; } else { ltQuantityResult.Text = ""; } Fuel fuel = new Fuel(); if (usingElectrict.FuelId > 0) { fuel = new FuelService().FindByKey(usingElectrict.FuelId); if (fuel != null) { ltFuelResult.Text = fuel.FuelName; } } } } catch { } }
public async Task <int> AddFuelServiceAsync(FuelService fuelService) { await _db.InsertAsync(fuelService); return(fuelService.Id); }
protected void btnExport_Click(object sender, EventArgs e) { Response.ContentType = "application/force-download"; Response.AddHeader("content-disposition", "attachment; filename=Bao-cao-sct-" + ddlYear.SelectedValue + ".xls"); Response.Write("<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">"); Response.Write("<head>"); Response.Write("<META http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">"); Response.Write("<!--[if gte mso 9]><xml>"); Response.Write("<x:ExcelWorkbook>"); Response.Write("<x:ExcelWorksheets>"); Response.Write("<x:ExcelWorksheet>"); Response.Write("<x:Name>Report Data</x:Name>"); Response.Write("<x:WorksheetOptions>"); Response.Write("<x:Print>"); Response.Write("<x:ValidPrinterInfo/>"); Response.Write("</x:Print>"); Response.Write("</x:WorksheetOptions>"); Response.Write("</x:ExcelWorksheet>"); Response.Write("</x:ExcelWorksheets>"); Response.Write("</x:ExcelWorkbook>"); Response.Write("</xml>"); Response.Write("<![endif]--> "); Response.Write("</head><body>"); //IList<GroupFuel> listGroupFuel = new List<GroupFuel>(); //if (!AspNetCache.CheckCache(Constants.Cache_ReportFuel_GroupFuel_All)) //{ // listGroupFuel = new GroupFuelService().FindAll(); // AspNetCache.SetCache(Constants.Cache_ReportFuel_GroupFuel_All, listGroupFuel); //} //else // listGroupFuel = (IList<GroupFuel>)AspNetCache.GetCache(Constants.Cache_ReportFuel_GroupFuel_All); IList <Fuel> listFuel = new List <Fuel>(); if (!AspNetCache.CheckCache(Constants.Cache_ReportFuel_Fuel_All)) { listFuel = new FuelService().FindAll(); AspNetCache.SetCache(Constants.Cache_ReportFuel_Fuel_All, listFuel); } else { listFuel = (IList <Fuel>)AspNetCache.GetCache(Constants.Cache_ReportFuel_Fuel_All); } ReportFuelService comBSO = new ReportFuelService(); DataTable list = new DataTable(); int AreaId = 0; int SubAreaId = 0; int Year = 0; if (ddlYear.SelectedIndex > 0) { Year = Convert.ToInt32(ddlYear.SelectedValue); } ePower.Core.PagingInfo paging = new ePower.Core.PagingInfo(2000, CurrentPage); list = comBSO.FindList(false, AreaId, SubAreaId, m_UserValidation.OrgId, 0, 0, 0, -1, true, Year, null, null, "", paging); string strHeader = ""; foreach (Fuel group in listFuel) { strHeader = strHeader + "<th>" + group.FuelName + "</th>"; } StringBuilder sb = new StringBuilder(); sb.Append("<table class='table table-bordered table-hover mbn' width='100%'>"); sb.Append("<tr class='primary fs12'>"); sb.Append("<th style='width:5%'>STT</th>"); sb.Append("<th style='width:35%'>Tên doanh nghiệp</th>"); sb.Append("<th style='width:10%'>Địa chỉ</th>"); sb.Append("<th style='width:10%'>Tỉnh/TP</th>"); sb.Append("<th style='width:10%'>Vùng</th>"); sb.Append("<th style='width:10%'>Lĩnh vực SX</th>"); sb.Append("<th style='width:10%'>Ngành nghề SX,KD</th>"); sb.Append(strHeader); sb.Append("<th style='width:10%'>Năng lượng tiêu thụ quy đổi (TOE)</th>"); sb.Append("</tr>"); if (list != null && list.Rows.Count > 0) { for (int i = 0; i < list.Rows.Count; i++) { sb.Append("<tr><td>" + (i + 1) + "</td>"); sb.Append("<td>" + list.Rows[i]["Title"] + "</td>"); sb.Append("<td>" + list.Rows[i]["Address"] + "</td>"); //sb.Append("<td>" + list.Rows[i]["ProvinceName"] + "</td>"); //sb.Append("<td></td>");//Vung //sb.Append("<td>" + list.Rows[i]["RegionName"] + "</td>");//Vung sb.Append("<td>" + list.Rows[i]["ParentAreaName"] + "</td>"); sb.Append("<td>" + list.Rows[i]["AreaName"] + "</td>"); if (list.Rows[i]["Id"] != null && list.Rows[i]["Id"].ToString() != "") { int ReportId = Convert.ToInt32(list.Rows[i]["Id"]); if (ReportId > 0) { DataTable listDetail = new ReportFuelDetailService().GetFuelTOEByReport(ReportId, false); int SumTOE = 0; if (listDetail != null && listDetail.Rows.Count > 0) { foreach (Fuel group in listFuel) { DataRow[] dr = listDetail.Select("FuelId=" + group.Id); if (dr != null && dr.Count() > 0) { sb.Append("<td>"); for (int j = 0; j < dr.Count(); j++) { sb.Append(dr[j]["NoFuel"] + " (" + dr[j]["MeasurementName"] + ")"); } sb.Append("</td>"); } else { sb.Append("<td>0</td>"); } } sb.Append("<td>" + SumTOE + "</td>"); } else { for (int j = 0; j < listFuel.Count; j++) { sb.Append("<td>0</td>"); } sb.Append("<td>0</td>"); } } sb.Append("</tr>"); } } } sb.Append("</table>"); Response.Write(sb.ToString()); Response.Write("</body></html>"); Response.End(); }
public Task DeleteFuelServiceAsync(FuelService fuelService) { return(_db.DeleteAsync <FuelService>(fuelService.Id)); }
private void BindData() { IList <Fuel> listFuel = new List <Fuel>(); if (!AspNetCache.CheckCache(Constants.Cache_ReportFuel_Fuel_All)) { listFuel = new FuelService().FindAll(); AspNetCache.SetCache(Constants.Cache_ReportFuel_Fuel_All, listFuel); } else { listFuel = (IList <Fuel>)AspNetCache.GetCache(Constants.Cache_ReportFuel_Fuel_All); } foreach (Fuel fuel in listFuel) { ltHeaderFuel.Text = ltHeaderFuel.Text + "<th>" + fuel.FuelName + "</th>"; } ePower.Core.PagingInfo paging = new ePower.Core.PagingInfo(PageSize, CurrentPage); //if (m_UserValidation.OrgId > 0) //{ int AuditYear = 0; if (ddlYear.SelectedIndex > 0) { AuditYear = Convert.ToInt32(ddlYear.SelectedValue); } int AreaId = 0; if (ddlArea.SelectedIndex > 0) { AreaId = Convert.ToInt32(ddlArea.SelectedValue); } int DistrictId = 0; //if (ddlDistrict.SelectedIndex > 0) // DistrictId = Convert.ToInt32(ddlDistrict.SelectedValue); DataTable list = new AuditReportService().FindList(AreaId, 0, 0, 0, 0, DistrictId, Convert.ToInt32(AuditReportStatus.CONFIRMED), AuditYear, txtKeyword.Text.Trim(), paging); rptAuditReport.DataSource = list; rptAuditReport.DataBind(); if (list != null && list.Rows.Count > 0) { Paging.TotalRecord = Convert.ToInt32(list.Rows[0]["Total"]); Paging.PageSize = PageSize; Paging.DataLoad(); Paging2.TotalRecord = Convert.ToInt32(list.Rows[0]["Total"]); Paging2.PageSize = PageSize; Paging2.DataLoad(); if (Paging.TotalPages > 1) { ltTotal.Text = "Có " + list.Rows.Count + " trong tổng số " + list.Rows[0]["Total"] + " báo cáo"; Paging2.Visible = Paging.Visible = true; } else { ltTotal.Text = "Có tổng số " + list.Rows[0]["Total"] + " báo cáo"; Paging2.Visible = Paging.Visible = false; } } else { Paging2.Visible = Paging.Visible = false; } //} }
void BindData() { IList <Fuel> listFuel = new List <Fuel>(); if (!AspNetCache.CheckCache(Constants.Cache_ReportFuel_Fuel_All)) { listFuel = new FuelService().FindAll(); AspNetCache.SetCache(Constants.Cache_ReportFuel_Fuel_All, listFuel); } else { listFuel = (IList <Fuel>)AspNetCache.GetCache(Constants.Cache_ReportFuel_Fuel_All); } var listSearchFuel = from o in listFuel orderby o.FuelName ascending select o; IList <Product> list = new List <Product>(); list = new ProductService().GetListByEnterprise(memVal.OrgId); var listProduct = from o in list where o.IsProduct == true select o; EnergyQuotaService consumseService = new EnergyQuotaService(); DataTable dt = consumseService.GetDataByFuel(ReportId); if (listProduct != null && listProduct.Count() > 0) { StringBuilder sb = new StringBuilder(); StringBuilder sbSub = new StringBuilder(); StringBuilder sbData = new StringBuilder(); sb.Append("<table class='table table-bordered table-hover mbn' width='100%'>"); sb.Append("<thead>"); sb.Append("<tr>"); sb.Append("<th>Sản phẩm</th>"); for (int i = 0; i < listSearchFuel.Count(); i++) { sb.Append("<th>" + listSearchFuel.ToList()[i].FuelName + "</th>"); } sb.Append("</tr>"); sb.Append("</thead>"); for (int j = 0; j < listProduct.Count(); j++) { sbData.Append("<tr>"); sbData.Append("<td>" + listProduct.ToList()[j].ProductName + "</td>"); for (int i = 0; i < listSearchFuel.Count(); i++) { DataRow[] dr = dt.Select("FuelId=" + listSearchFuel.ToList()[i].Id.ToString() + " AND ProductId=" + listProduct.ToList()[j].Id); if (dr != null && dr.Count() > 0) { sbData.Append("<td class='text-right'>" + dr[0]["Quantity"] + "</td>"); } else { sbData.Append("<td class='text-right'>-</td>"); } } sbData.Append("</tr>"); } sb.Append(sbData.ToString()); sb.Append("</table>"); ltQuota.Text = sb.ToString(); } }
protected void rptAuditReport_ItemDataBound(object sender, RepeaterItemEventArgs e) { Literal ltNoTOE = (Literal)e.Item.FindControl("ltNoTOE"); Literal ltTotalTOE = (Literal)e.Item.FindControl("ltTotalTOE"); StringBuilder sb = new StringBuilder(); DataRowView dr = (DataRowView)e.Item.DataItem; if (dr != null) { int eID = Convert.ToInt32(dr["Id"]); DataTable dtFuel = new AuditReportService().GetCO2ByReport(eID); IList <Fuel> listFuel = new List <Fuel>(); if (!AspNetCache.CheckCache(Constants.Cache_ReportFuel_Fuel_All)) { listFuel = new FuelService().FindAll(); AspNetCache.SetCache(Constants.Cache_ReportFuel_Fuel_All, listFuel); } else { listFuel = (IList <Fuel>)AspNetCache.GetCache(Constants.Cache_ReportFuel_Fuel_All); } decimal dsum = 0; decimal NoTOE = 0; if (dtFuel != null && dtFuel.Rows.Count > 0) { for (int i = 0; i < dtFuel.Rows.Count; i++) { dsum = dsum + Convert.ToDecimal(dtFuel.Rows[i]["NoCO2"]); NoTOE = NoTOE + Convert.ToDecimal(dtFuel.Rows[i]["NoTOE"]); } } foreach (Fuel fuel in listFuel) { sb.Append("<td class='text-right'>"); if (dtFuel != null && dtFuel.Rows.Count > 0) { DataRow[] drows = dtFuel.Select("FuelId=" + fuel.Id); if (drows != null && drows.Count() > 0) { decimal rate = 0; if (NoTOE > 0) { rate = Math.Round((Convert.ToDecimal(drows[0]["NoTOE"]) / NoTOE) * 100, 2); } //sb.Append(Tool.ConvertDecimalToString(Math.Round(Convert.ToDecimal(drows[0]["NoTOE"]), 2)) + "(" + rate + "%)"); if (rate > 50) { sb.Append("<b>" + rate + "%</b>"); } else { sb.Append(rate + "%"); } } else { sb.Append("-"); } } else { sb.Append("-"); } sb.Append("</td>"); } ltNoTOE.Text = sb.ToString(); ltTotalTOE.Text = Tool.ConvertDecimalToString(NoTOE, 2); } }