public void Consultar() { try { DsCategoriaPersonal ds = new DsCategoriaPersonal(); SqlParameter pCategoriaPersonalID = new SqlParameter("@CategoriaPersonalID", Utiles.BaseDatos.IntToSql(CategoriaID)); Config.Conexion.LlenarTypeDataSet(ds.Datos, System.Data.CommandType.StoredProcedure, "CategoriaPersonalONE", pCategoriaPersonalID); foreach (DsCategoriaPersonal.DatosRow dr in ds.Datos) { CategoriaID = dr.CategoriaID; Nivel = dr.Nivel; DependenciaID = dr.IsDependenciaIDNull() ? 0 : dr.DependenciaID; Depende = dr.IsDependeNull() ? "" : dr.Depende; Descripcion = dr.IsDescripcionNull() ? "" : dr.Descripcion; EsEjecutivoCuenta = dr.EsEjecutivoCuenta; Baja = dr.Baja; NivelDependenciaID = dr.IsNivelDependenciaIDNull() ? 0 : dr.NivelDependenciaID; DsObjetivoIncentivoDescrip ds2 = new DsObjetivoIncentivoDescrip(); Config.Conexion.LlenarTypeDataSet(ds2.Datos, System.Data.CommandType.StoredProcedure, "ObjetivoByCategoriaPersonalSEL", pCategoriaPersonalID); DsObejtivos = ds2; } } catch (Exception ex) { throw ex; } }
public override global::System.Data.DataSet Clone() { DsCategoriaPersonal cln = ((DsCategoriaPersonal)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { DsCategoriaPersonal ds = new DsCategoriaPersonal(); global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte()));) { ; } if ((s1.Position == s1.Length)) { return(type); } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return(type); }
public DsCategoriaPersonal GetCategorias() { try { DsCategoriaPersonal ds = new DsCategoriaPersonal(); SqlParameter pNivel = new SqlParameter("@Nivel", Utiles.BaseDatos.IntToSql(Nivel)); SqlParameter pDescripcion = new SqlParameter("@Descripcion", Utiles.BaseDatos.StrToSql(Descripcion)); Config.Conexion.LlenarTypeDataSet(ds.Datos, System.Data.CommandType.StoredProcedure, "CategoriaPersonalSEL", pNivel, pDescripcion); return(ds); } catch (Exception ex) { throw ex; } }
private void BindGrid() { try { SisPackController.AdministrarGrillas.Configurar(dtgCategoriaPersonal, "CategoriaID", 20, true, false); ICategoriaPersonal categoria = CategoriaPersonalFactory.GetCategoriaPersonalFactory(); categoria.Nivel = Utiles.Validaciones.obtieneEntero(txtNivel.Text); categoria.Descripcion = txtDescripcion.Text; DsCategoriaPersonal ds = categoria.GetCategorias(); dtgCategoriaPersonal.DataSource = ds; dtgCategoriaPersonal.CurrentPageIndex = Utiles.Validaciones.obtieneEntero(txtPagina.Text); dtgCategoriaPersonal.DataBind(); } catch (Exception ex) { throw ex; } }
private void Buscar() { try { ICategoriaPersonal categoria = CategoriaPersonalFactory.GetCategoriaPersonalFactory(); categoria.Nivel = Utiles.Validaciones.obtieneEntero(nivel); categoria.Descripcion = descripcion; DsCategoriaPersonal ds = categoria.GetCategorias(); if (ds.Datos.Count == 1) { foreach (DsCategoriaPersonal.DatosRow dr in ds.Datos) { txtNivel.Text = dr.Nivel.ToString(); txtDescripcion.Text = dr.Descripcion; txtCategoriaID.Text = dr.CategoriaID.ToString(); txtEjecutivo.Text = dr.EsEjecutivoCuenta.ToString(); txtErrorMsg.Text = ""; txtOpen.Text = ""; } } else if (ds.Datos.Count > 1) { txtNivel.Text = nivel; txtDescripcion.Text = descripcion; txtCategoriaID.Text = ""; txtOpen.Text = "S"; } else { txtCategoriaID.Text = ""; txtNivel.Text = nivel; txtDescripcion.Text = descripcion; txtEjecutivo.Text = ""; txtErrorMsg.Text = "No se encontraron datos"; txtOpen.Text = ""; } } catch (Exception ex) { txtErrorMsg.Text = "Error al consultar datos " + ex.Message; } }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs) { global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); DsCategoriaPersonal ds = new DsCategoriaPersonal(); global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny(); any1.Namespace = "http://www.w3.org/2001/XMLSchema"; any1.MinOccurs = new decimal(0); any1.MaxOccurs = decimal.MaxValue; any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any1); global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny(); any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1"; any2.MinOccurs = new decimal(1); any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax; sequence.Items.Add(any2); global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute1.Name = "namespace"; attribute1.FixedValue = ds.Namespace; type.Attributes.Add(attribute1); global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute(); attribute2.Name = "tableTypeName"; attribute2.FixedValue = "DatosDataTable"; type.Attributes.Add(attribute2); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte()));) { ; } if ((s1.Position == s1.Length)) { return(type); } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return(type); }