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