Пример #1
0
        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;
     }
 }
Пример #3
0
        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("&nbsp;", 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("&nbsp;", string.Empty);;
                        txtTelefono.Text = rg1.Items[item]["Telefono"].Text.Replace("&nbsp;", 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");
            }
        }