protected void grvFuel_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Literal ltTOE = (Literal)e.Row.FindControl("ltTOE");
int fid = Convert.ToInt32(grvFuel.DataKeys[e.Row.RowIndex].Values[0]);
DataTable dt = new MeasurementFuelService().GetMeasurementByFuel(fid);
if (dt != null && dt.Rows.Count > 0)
{
StringBuilder sb = new StringBuilder();
decimal dfrom = 0;
decimal dto = 0;
string strscript = string.Empty;
for (int i = 0; i < dt.Rows.Count; i++)
{
try { dfrom = Convert.ToDecimal(dt.Rows[i]["From_TOE"]); }
catch { }
try { dto = Convert.ToDecimal(dt.Rows[i]["To_TOE"]); }
catch { }
if (dfrom < dto)
{
strscript = "'" + dt.Rows[i]["Id"].ToString() + "','" + dt.Rows[i]["FuelName"].ToString() + "','" + dt.Rows[i]["FuelId"].ToString() + "','" + dfrom + "','" + dto + "','" + dt.Rows[i]["MeasurementId"].ToString() + "'";
sb.Append("<p><strong>" + dt.Rows[i]["MeasurementName"] + "</strong>: " + dfrom.ToString("G29") + " - " + dto.ToString("G29") + "</p>");
}
else
{
strscript = "'" + dt.Rows[i]["Id"].ToString() + "','" + dt.Rows[i]["FuelName"].ToString() + "','" + dt.Rows[i]["FuelId"].ToString() + "','" + dfrom + "','','" + dt.Rows[i]["MeasurementId"].ToString() + "'";
sb.Append("<p><strong>" + dt.Rows[i]["MeasurementName"] + "</strong>: " + dfrom.ToString("G29") + "</p>");
}
}
ltTOE.Text = sb.ToString();
}
}
}
void BindMeasurement()
{
ddlMeasure.Items.Clear();
IList <MeasurementFuel> list = new List <MeasurementFuel>();
if (!AspNetCache.CheckCache(Constants.Cache_ReportFuel_Measurement_All))
{
list = new MeasurementFuelService().FindAll();
AspNetCache.SetCache(Constants.Cache_ReportFuel_Measurement_All, list);
}
else
{
list = (IList <MeasurementFuel>)AspNetCache.GetCache(Constants.Cache_ReportFuel_Measurement_All);
}
int FuelId = 0;
if (ddlFuel.SelectedIndex > 0)
{
FuelId = Convert.ToInt32(ddlFuel.SelectedValue);
}
var listSearch = from o in list where o.FuelId == FuelId || FuelId == 0 select o;
ddlMeasure.DataSource = listSearch;
ddlMeasure.DataValueField = "Id";
ddlMeasure.DataTextField = "MeasurementName";
ddlMeasure.DataBind();
ddlMeasure.Items.Insert(0, new ListItem("---Chọn đơn vị tính---", ""));
if (ddlMeasure.Items.Count == 2)
{
ddlMeasure.SelectedIndex = 1;
BindTOE();
}
}
void BindTOE()
{
rvNoTOE.MaximumValue = "10";
rvNoTOE.MinimumValue = "0";
rvNoTOE.Text = "Nhập hệ số chuyển đổi từ 0 đến 10";
txtNoTOE.Enabled = false;
if (ddlMeasure.SelectedIndex > 0)
{
MeasurementFuel mea = new MeasurementFuelService().FindByKey(Convert.ToInt32(ddlMeasure.SelectedValue));
if (mea != null)
{
if (mea.From_TOE < mea.To_TOE)
{
txtNoTOE.Text = mea.TOE.ToString();
txtNoTOE.Enabled = false;
}
else
{
txtNoTOE.Enabled = true;
rvNoTOE.Text = "Nhập hệ số chuyển đổi từ " + mea.From_TOE + " đến " + mea.To_TOE;
rvNoTOE.MaximumValue = mea.To_TOE.ToString();
rvNoTOE.MinimumValue = mea.From_TOE.ToString();
}
}
}
}
void BindTOE()
{
txtNoTOE.Enabled = false;
if (ddlMeasure.SelectedIndex > 0)
{
DataTable mea = new MeasurementFuelService().GetTOE(Convert.ToInt32(ddlFuel.SelectedValue), Convert.ToInt32(ddlMeasure.SelectedValue));
if (mea != null && mea.Rows.Count > 0)
{
txtNoTOE.Text = TypeHelper.ToDecimal(mea.Rows[0]["TOE"].ToString()).ToString();
txtNoTOE.Enabled = false;
if (mea.Rows[0]["From_TOE"].ToString() != mea.Rows[0]["To_TOE"].ToString())
{
rvNoTOE.Enabled = true;
txtNoTOE.Enabled = true;
//rvNoTOE.Text = "Nhập hệ số chuyển đổi từ " + mea.From_TOE + " đến " + mea.To_TOE;
rvNoTOE.MaximumValue = mea.Rows[0]["To_TOE"].ToString();
rvNoTOE.MinimumValue = mea.Rows[0]["From_TOE"].ToString();
rvNoTOE.Text = string.Format("Nhập hệ số chuyển đổi từ {0} đến {1}", TypeHelper.ToDecimal(mea.Rows[0]["From_TOE"].ToString()), TypeHelper.ToDecimal(mea.Rows[0]["To_TOE"].ToString()));
}
else
{
txtNoTOE.Enabled = false;
if (mea.Rows[0]["TOE"] != DBNull.Value)
{
txtNoTOE.Text = string.Format("{0:0.#########}", mea.Rows[0]["TOE"]);
rvNoTOE.Enabled = false;
rvNoTOE.MaximumValue = mea.Rows[0]["TOE"].ToString();
rvNoTOE.MinimumValue = rvNoTOE.MaximumValue;
rvNoTOE.Text = "Nhập hệ số chuyển đổi từ " + rvNoTOE.MinimumValue;
}
}
}
}
}
protected void grvFuel_RowDataBound(object sender, GridViewRowEventArgs e)
{
if (e.Row.RowType == DataControlRowType.DataRow)
{
Literal ltTOE = (Literal)e.Row.FindControl("ltTOE");
Literal ltCO2 = (Literal)e.Row.FindControl("ltCO2");
int fid = Convert.ToInt32(grvFuel.DataKeys[e.Row.RowIndex].Values[0]);
DataTable dt = new MeasurementFuelService().GetMeasurementByFuel(fid);
if (dt != null && dt.Rows.Count > 0)
{
StringBuilder sb = new StringBuilder();
StringBuilder sbCO2 = new StringBuilder();
decimal dfrom = 0;
decimal dto = 0;
string strscript = string.Empty;
for (int i = 0; i < dt.Rows.Count; i++)
{
try { dfrom = Convert.ToDecimal(dt.Rows[i]["From_TOE"]); }
catch { }
try { dto = Convert.ToDecimal(dt.Rows[i]["To_TOE"]); }
catch { }
if (dfrom < dto)
{
strscript = "'" + dt.Rows[i]["Id"].ToString() + "','" + dt.Rows[i]["FuelName"].ToString() + "','" + dt.Rows[i]["FuelId"].ToString() + "','" + Tool.ConvertDecimalToString(dfrom) + "','" + Tool.ConvertDecimalToString(dto) + "','" + (dt.Rows[i]["NoCO2"] != DBNull.Value ? Tool.ConvertDecimalToString(dt.Rows[i]["NoCO2"]) : "") + "','" + dt.Rows[i]["MeasurementId"].ToString() + "'";
sb.Append("<p><strong>" + dt.Rows[i]["MeasurementName"] + "</strong>: " + Tool.ConvertDecimalToString(dfrom) + " - " + Tool.ConvertDecimalToString(dto) + "<a class='pull-right' title='Xóa hệ số quy đổi' onclick=\"javascript:updatetoefuel(" + strscript + ");return false;\"><span class='glyphicons glyphicons-remove_2 fs18 text-danger'></span></a><a class='pull-right' title='Cập nhật hệ số quy đổi' onclick=\"javascript:updatetoefuel(" + strscript + ");return false;\"><span class='glyphicons glyphicons-edit fs18'></span> </a></p><hr/>");
}
else
{
strscript = "'" + dt.Rows[i]["Id"].ToString() + "','" + dt.Rows[i]["FuelName"].ToString() + "','" + dt.Rows[i]["FuelId"].ToString() + "','" + Tool.ConvertDecimalToString(dfrom) + "','','" + (dt.Rows[i]["NoCO2"] != DBNull.Value ? Tool.ConvertDecimalToString(dt.Rows[i]["NoCO2"]) : "") + "','" + dt.Rows[i]["MeasurementId"].ToString() + "'";
sb.Append("<p><strong>" + dt.Rows[i]["MeasurementName"] + "</strong>: " + Tool.ConvertDecimalToString(dfrom) + "<a class='pull-right' title='Xóa hệ số quy đổi' onclick=\"javascript:updatetoefuel(" + strscript + ");return false;\"><span class='glyphicons glyphicons-remove_2 fs18 text-danger'></span></a><a class='pull-right' title='Cập nhật hệ số quy đổi' onclick=\"javascript:updatetoefuel(" + strscript + ");return false;\"><span class='glyphicons glyphicons-edit fs18'></span> </a></p><hr/>");
}
if (dt.Rows[i]["NoCO2"] != DBNull.Value)
{
sbCO2.Append("<p><strong>" + dt.Rows[i]["MeasurementName"] + "</strong>: " + Tool.ConvertDecimalToString(dt.Rows[i]["NoCO2"]) + "<a class='pull-right' title='Xóa hệ số quy đổi' onclick=\"javascript:updatetoefuel(" + strscript + ");return false;\"><span class='glyphicons glyphicons-remove_2 fs18 text-danger'></span></a><a class='pull-right' title='Cập nhật hệ số quy đổi' onclick=\"javascript:updatetoefuel(" + strscript + ");return false;\"><span class='glyphicons glyphicons-edit fs18'></span> </a></p><hr/>");
}
}
ltTOE.Text = sb.ToString();
ltCO2.Text = sbCO2.ToString();
}
}
}
void BindMeasurement()
{
ddlMeasure.Items.Clear();
DataTable list = new DataTable();
if (ddlFuelType.SelectedIndex > 0)
{
list = new MeasurementFuelService().GetListMeasurement(Convert.ToInt32(ddlFuelType.SelectedValue));
}
ddlMeasure.DataSource = list;
ddlMeasure.DataValueField = "Id";
ddlMeasure.DataTextField = "MeasurementName";
ddlMeasure.DataBind();
ddlMeasure.Items.Insert(0, new ListItem("---Chọn đơn vị tính---", ""));
if (ddlMeasure.Items.Count >= 2)
{
ddlMeasure.SelectedIndex = 1;
}
}
protected void btnDeleteTOE_Click(object sender, EventArgs e)
{
int mId = 0;
if (hdnToeId.Value != "")
{
try
{
mId = Convert.ToInt32(hdnToeId.Value.Trim());
}
catch
{ }
if (mId > 0)
{
long iDelete = 0;
iDelete = new MeasurementFuelService().Delete(mId);
if (iDelete > 0)
{
BindData();
}
}
}
}
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);
}
}
}
protected void btnSaveTOE_Click(object sender, EventArgs e)
{
MeasurementFuelService measurementFuelService = new MeasurementFuelService();
MeasurementFuel objMeasurementFuel = new MeasurementFuel();
int mId = 0;
int fid = 0;
if (hdnToeId.Value != "")
{
try
{
mId = Convert.ToInt32(hdnToeId.Value.Trim());
}
catch
{ }
}
if (hdnfuelid.Value != "")
{
try
{
fid = Convert.ToInt32(hdnfuelid.Value.Trim());
}
catch
{ }
}
if (txtNoCO2.Text != "")
{
objMeasurementFuel.NoCO2 = Convert.ToDecimal(txtNoCO2.Text.Trim());
}
if (txttoeFrom.Text != "" && txttoeFrom.Text.Trim() != "" && ddlMeasurement1.SelectedValue != "" && fid > 0)
{
if (ddlMeasurement1.SelectedValue != "")
{
objMeasurementFuel.MeasurementId = Convert.ToInt32(ddlMeasurement1.SelectedValue);
}
objMeasurementFuel.FuelId = fid;
decimal dfrom = 0;
decimal dto = 0;
try
{
dfrom = Convert.ToDecimal(txttoeFrom.Text);
}
catch
{
}
if (txttoeto.Text != "" && txttoeto.Text.Trim() != "")
{
try
{
dto = Convert.ToDecimal(txttoeto.Text.Trim());
}
catch
{
}
}
if (dfrom > 0)
{
objMeasurementFuel.From_TOE = dfrom;
objMeasurementFuel.TOE = dfrom;
}
if (dto >= 0 && dto > dfrom)
{
objMeasurementFuel.To_TOE = dto;
}
if (mId > 0)
{
objMeasurementFuel.Id = mId;
if (measurementFuelService.Update(objMeasurementFuel) != null)
{
BindData();
hdnToeId.Value = "0";
hdnfuelid.Value = "0";
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showform", "showupdatetoefuel();", true);
}
}
else
{
if (measurementFuelService.Insert(objMeasurementFuel) > 0)
{
BindData();
hdnToeId.Value = "0";
hdnfuelid.Value = "0";
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "showform", "addtoefuel();", true);
}
}
}
}
