private void lbxRazon() { if (m_frmAction == frmAction.Read) { if (ddlTHBelong.SelectedValue == "2" /*=No*/) { string selectedValuesString = ""; NewSource NS = new NewSource(); DataTable Dref = new DataTable(); Dref = NS.getRef("SPR_Ref_RazonTH", m_pk_perfil); if (Dref.Rows.Count > 0) { foreach (DataRow r in Dref.Rows) { selectedValuesString += r[1].ToString() + ", "; } selectedValuesString = selectedValuesString.Substring(0, selectedValuesString.Length - 2); Dref = null; } else { selectedValuesString = "No hay valores seleccionados"; } NS = null; divRazon.Visible = false; lblRazon.Text = selectedValuesString; } else { divRazon.Visible = false; divLblRazon.Visible = false; } } else { NewSource NS = new NewSource(); DataTable Dt = new DataTable(); Dt = NS.getAll("SPR_DROP_RazonTH"); this.lbxRazonSeleccion.DataSource = Dt; this.lbxRazonSeleccion.DataValueField = "PK_Razon"; this.lbxRazonSeleccion.DataTextField = "DE_Razon"; this.lbxRazonSeleccion.DataBind(); DataTable Dref = new DataTable(); Dref = NS.getRef("SPR_Ref_RazonTH", m_pk_perfil); if (Dref.Rows.Count > 0) { foreach (DataRow r in Dref.Rows) { System.Web.UI.WebControls.ListItem li = new ListItem(r[1].ToString(), r[0].ToString()); this.lbxRazonSeleccionado.Items.Add(li); this.lbxRazonSeleccion.Items.Remove(li); } Dref = null; } Dt = null; NS = null; divLblRazon.Visible = false; } }
private void ddlCategoriasDeCentrosPrivadosALL() { NewSource NS = new NewSource(); DataTable Dt = new DataTable(); Dt = NS.getAll("SPR_DROP_CategoriasCentrosPrivados"); this.ddlCategoriasDeCentrosPrivados.DataSource = Dt; this.ddlCategoriasDeCentrosPrivados.DataValueField = "PK_CategoriaCentroPrivado"; this.ddlCategoriasDeCentrosPrivados.DataTextField = "DE_CategoriaCentroPrivado"; this.ddlCategoriasDeCentrosPrivados.DataBind(); Dt = null; NS = null; }
private void ddlTipoDeAdmisionAll() { NewSource NS = new NewSource(); DataTable Dt = new DataTable(); Dt = NS.getAll("SPR_DROP_TipoAdmision"); this.ddlTipoDeAdmision.DataSource = Dt; this.ddlTipoDeAdmision.DataValueField = "PK_TipoAdmision"; this.ddlTipoDeAdmision.DataTextField = "DE_TipoAdmision"; this.ddlTipoDeAdmision.DataBind(); Dt = null; NS = null; }
private void ddlTipoDeAdmisionAll() { NewSource NS = new NewSource(); DataTable Dt = new DataTable(); Dt = NS.getAll("SPR_DROP_TipoAdmision"); this.ddlTipoDeAdmision.DataSource = Dt; this.ddlTipoDeAdmision.DataValueField = "PK_TipoAdmision"; this.ddlTipoDeAdmision.DataTextField = "DE_TipoAdmision"; this.ddlTipoDeAdmision.DataBind(); if (UsaTipoDeAdmision(m_PK_Programa)) { this.ddlTipoDeAdmision.Items.RemoveAt(6); } Dt = null; NS = null; }
private void ddlMilitarALL() { NewSource NS = new NewSource(); DataTable Dt = new DataTable(); Dt = NS.getAll("SPR_DROP_Militar"); this.ddlMilitar.DataSource = Dt; this.ddlMilitar.DataValueField = "PK_Militar"; this.ddlMilitar.DataTextField = "DE_Militar"; try { this.ddlMilitar.DataBind(); } catch { this.ddlMilitar.SelectedValue = ""; } Dt = null; NS = null; }
private void ddlGeneroAll() { NewSource NS = new NewSource(); DataTable Dt = new DataTable(); Dt = NS.getAll("SPR_DROP_Genero"); this.ddlGenero.DataSource = Dt; this.ddlGenero.DataValueField = "PK_Genero"; this.ddlGenero.DataTextField = "DE_Genero"; this.ddlGenero.ClearSelection(); try { this.ddlGenero.DataBind(); } catch { this.ddlGenero.SelectedValue = ""; } Dt = null; NS = null; }
private void ddlEtapa() { NewSource NS = new NewSource(); DataTable Dt = new DataTable(); Dt = NS.getAll("SPR_DROP_EtapaTH"); this.ddlTHEtapa.DataSource = Dt; this.ddlTHEtapa.DataValueField = "PK_Etapa"; this.ddlTHEtapa.DataTextField = "DE_Etapa"; try { this.ddlTHEtapa.DataBind(); ListItem li = new ListItem("", "0"); this.ddlTHEtapa.Items.Insert(0, li); } catch (Exception ex) { Trace.Write("DdlFrecuenciaBotellas()::" + ex.Message); throw ex; } Dt = null; NS = null; }