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