void BindFuelMearsurement() { EnergyQuotaService consumseService = new EnergyQuotaService(); int ProductId = 0; if (ddlProduct.SelectedIndex > 0) { ProductId = Convert.ToInt32(ddlProduct.SelectedValue); } int FuelId = 0; if (ddlFuel.SelectedIndex > 0) { FuelId = Convert.ToInt32(ddlFuel.SelectedValue); } DataTable dt = consumseService.GetDataByFuel(ReportId, ProductId, FuelId); if (dt != null && dt.Rows.Count > 0) { if (dt.Rows[0]["Quantity"] != null) { txtQuantity.Text = dt.Rows[0]["Quantity"].ToString(); } ddlMeasure.SelectedValue = dt.Rows[0]["MeasurementId"].ToString(); } else { txtQuantity.Text = ""; } }
void BindQuota() { EnergyQuotaService consumseService = new EnergyQuotaService(); int ProductId = 0; if (ddlProduct.SelectedIndex > 0) { ProductId = Convert.ToInt32(ddlProduct.SelectedValue); } DataTable dt = consumseService.GetDataByFuel(ReportId, ProductId); rptDataQuota.DataSource = dt; rptDataQuota.DataBind(); }
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(); } }