private void ObtenerPlaya(bool forzarBD) { if (ViewState["lista"] == null || forzarBD) { PlayaBC zona = new PlayaBC(); DataTable dt = zona.ObtenerXSite(int.Parse(ddl_site.SelectedValue)); ViewState["lista"] = dt; ViewState.Remove("filtrados"); } DataView dw; if (ViewState["filtrados"] == null) { dw = new DataView((DataTable)ViewState["lista"]); } else { dw = new DataView((DataTable)ViewState["filtrados"]); } if (ViewState["sortExpresion"] != null && ViewState["sortExpresion"].ToString() != "") { dw.Sort = (String)ViewState["sortExpresion"]; } this.gv_listar.DataSource = dw; this.gv_listar.DataBind(); }
private void ObtenerDestinos(bool forzarBD) { PlayaBC p = new PlayaBC(); DataTable playas; if (ViewState["playas"] == null || forzarBD) { playas = p.ObtenerXSite(int.Parse(hf_idSite.Value)); ViewState["playas"] = playas; } playas = (DataTable)ViewState["playas"]; DataView playasNS = playas.AsDataView(); string filtros = ""; filtros += "ZONA_ID = " + ddl_destinoZona.SelectedValue; if (!string.IsNullOrEmpty(hf_seleccionados.Value)) { filtros += " AND PLAY_ID NOT IN (" + hf_seleccionados.Value + ")"; } playasNS.RowFilter = filtros; ViewState["nosel"] = playasNS.ToTable(); gv_noSeleccionados.DataSource = playasNS.ToTable(); gv_noSeleccionados.DataBind(); }
private void ObtenerDestinos(bool forzarBD) { PlayaBC p = new PlayaBC(); DataTable playas; if (this.ViewState["playas"] == null || forzarBD) { playas = p.ObtenerXSite(Convert.ToInt32(this.ddl_destinoSite.SelectedValue)); this.ViewState["playas"] = playas; } playas = (DataTable)this.ViewState["playas"]; //DataView playasS = playas.AsDataView(); //playasS.RowFilter = "ID IN (" + hf_seleccionados.Value + ")"; //gv_seleccionados.DataSource = (DataTable)ViewState["seleccionados"]; //gv_seleccionados.DataBind(); DataView playasNS = playas.AsDataView(); string filtros = ""; filtros += string.Format("ZONA_ID = {0}", this.ddl_destinoZona.SelectedValue); if (!string.IsNullOrEmpty(this.hf_seleccionados.Value)) { filtros += string.Format(" AND PLAY_ID NOT IN ({0})", this.hf_seleccionados.Value); } playasNS.RowFilter = filtros; this.ViewState["nosel"] = playasNS.ToTable(); this.gv_noSeleccionados.DataSource = playasNS.ToTable(); this.gv_noSeleccionados.DataBind(); }
public void Playa_Todos(System.Web.UI.WebControls.DropDownList ddl, int zona_id = 0, int site_id = 0) { UtilsWeb u = new UtilsWeb(); DataTable dt; if (zona_id != 0) { dt = p.ObtenerXZona(zona_id); } else if (site_id != 0) { dt = p.ObtenerXSite(site_id); } else { dt = p.ObtenerTodas(); } DataView dw = dt.AsDataView(); dw.Sort = "DESCRIPCION ASC"; u.CargaDropTodos(ddl, "ID", "DESCRIPCION", dw.ToTable()); }
private void ObtenerPlayas(bool forzarBD) { if (this.ViewState["playas"] == null || forzarBD) { PlayaBC p = new PlayaBC(); DataTable playas = p.ObtenerXSite(Convert.ToInt32(this.hf_idSite.Value)); this.ViewState["playas"] = playas; } DataView playasNS = new DataView((DataTable)this.ViewState["playas"]); string filtro = string.Format("ZONA_ID = {0}", this.ddl_asignarZona.SelectedValue); if (!string.IsNullOrEmpty(hf_seleccionados.Value)) { filtro += string.Format(" AND PLAY_ID NOT IN ({0})", hf_seleccionados.Value); } playasNS.RowFilter = filtro; this.ViewState["nosel"] = playasNS.ToTable(); this.gv_noSeleccionados.DataSource = this.ViewState["nosel"]; this.gv_noSeleccionados.DataBind(); ObtenerSeleccionados(false); }