public void ConsultarRepresentantesDet(RikUen representante, string Conexion, ref List <RikUen> lc) { try { SqlDataReader dr = null; CapaDatos.CD_Datos CapaDatos = new CapaDatos.CD_Datos(Conexion); string[] Parametros = { "@Id_Emp", "@Id_Cd", "@Id_Rik" }; object[] Valores = { representante.Id_Emp, representante.Id_Cd, representante.Id_Rik }; SqlCommand sqlcmd = CapaDatos.GenerarSqlCommand("spCatRikUen_Consulta", ref dr, Parametros, Valores); RikUen comun = default(RikUen); while (dr.Read()) { comun = new RikUen(); comun.Id_Rik = (int)dr.GetValue(dr.GetOrdinal("RIK")); comun.Id_Uen = (int)dr.GetValue(dr.GetOrdinal("UEN")); comun.DescripcionUEN = (string)dr.GetValue(dr.GetOrdinal("Descripcion")); lc.Add(comun); } CapaDatos.LimpiarSqlcommand(ref sqlcmd); } catch (Exception ex) { throw ex; } }
public void ConsultarRepresentantesDet(RikUen representante, string Conexion, ref List <RikUen> lc) { try { CD_CatRepresentantes claseCapaDatos = new CD_CatRepresentantes(); claseCapaDatos.ConsultarRepresentantesDet(representante, Conexion, ref lc); } catch (Exception ex) { throw ex; } }
protected void rg1_ItemCommand(object source, Telerik.Web.UI.GridCommandEventArgs e) { try { ErrorManager(); if (e.CommandName.ToString() == "Modificar") { Nuevo(); Sesion Sesion = new Sesion(); Sesion = (Sesion)Session["Sesion" + Session.SessionID]; Int32 item = default(Int32); item = e.Item.ItemIndex; if (item >= 0) { CN__Comun.RemoverValidadores(Validators); HF_ID.Value = rg1.Items[item]["Id_Rik"].Text; txtClave.Text = rg1.Items[item]["Id_Rik"].Text; txtClave.Enabled = false; txtNombre.Text = rg1.Items[item]["Nombre"].Text; txtCalle.Text = rg1.Items[item]["Calle"].Text.Replace(" ", string.Empty); txtNumero.Text = rg1.Items[item]["Numero"].Text == "0" ? string.Empty : rg1.Items[item]["Numero"].Text; txtColonia.Text = rg1.Items[item]["Colonia"].Text.Replace(" ", string.Empty);; txtTelefono.Text = rg1.Items[item]["Telefono"].Text.Replace(" ", string.Empty);; if (Convert.ToDateTime(rg1.Items[item]["Fecha_Alta"].Text) == DateTime.MinValue) { dpFecha.DateInput.Text = string.Empty; dpFecha.SelectedDate = null; } else { dpFecha.SelectedDate = Convert.ToDateTime(rg1.Items[item]["Fecha_Alta"].Text); } txtContribucion.Text = rg1.Items[item]["Contribucion"].Text; txtCompensacion.Text = rg1.Items[item]["Compensacion"].Text; //txtGte.Text = rg1.Items[item]["Gte"].Text; //cmbGte.SelectedIndex = cmbGte.FindItemIndexByValue(rg1.Items[item]["Gte"].Text); chkPertenece.Checked = Convert.ToBoolean(rg1.Items[item]["Pertenece"].Text); chkActivo.Checked = Convert.ToBoolean(rg1.Items[item]["Estatus"].Text); //txtClave.Enabled = false; List <RikUen> lc = new List <RikUen>(); CN_CatRepresentantes clsCatRepresentantes = new CN_CatRepresentantes(); RikUen representante = new RikUen(); representante.Id_Emp = Sesion.Id_Emp; representante.Id_Cd = Sesion.Id_Cd_Ver; representante.Id_Rik = Convert.ToInt32(rg1.Items[item]["Id_Rik"].Text); clsCatRepresentantes.ConsultarRepresentantesDet(representante, Sesion.Emp_Cnx, ref lc); //lbUen.Items.FindChildByValue<ControlItem>(lc[0].Id_Uen.ToString(), true).; foreach (RikUen rikuen in lc) { lbUen.FindItemByValue(rikuen.Id_Uen.ToString()).Checked = true; } } } } catch (Exception ex) { ErrorManager(ex, "rg1_ItemCommand"); } }