private void BindGrid() { SisPackController.AdministrarGrillas.Configurar(this.dtgProveedores, "ProveedorID", this.CantidadOpciones); try { IProveedor prov = ProveedorFactory.GetProveedor(); DsProveedor ds = prov.GetProveedoresConsultaDataSet(); string documento = this.txtDocumento.Text; string razon = this.txtRazonSocial.Text; string filtroEspecial = this.txtFiltro.Text; string proveedorActual = this.txtProveedorActual.Text; string filtro = "Documento LIKE '" + documento + "%' AND RazonSocial LIKE '" + razon + "%'"; //Agregar que si no le paso un proveedor actual, no lo tenga que buscar. if (filtroEspecial == NegociosSisPackInterface.SisPack.TipoAgencia.Cabecera.ToString()) { if (proveedorActual != null && proveedorActual.Length > 0) { filtro += " AND ProveedorID <> " + proveedorActual; } } DsProveedor.DatosRow[] drLista = (DsProveedor.DatosRow[])ds.Datos.Select(filtro); dtgProveedores.DataSource = drLista; dtgProveedores.DataBind(); } catch (Exception ex) { throw ex; //this.txtErrorMsg.Text = "Error al consultar datos de agencias: " + ex.Message; } }
/// <summary> /// Método que retorna un DataSet tipado con aquellas proveedores que cumplen con los filtros. /// </summary> /// <returns></returns> public DsProveedor GetProveedoresConsultaDataSet() { DsProveedor ds = new DsProveedor(); Config.Conexion.LlenarTypeDataSet(ds.Datos, System.Data.CommandType.StoredProcedure, "ProveedorSEL"); return(ds); }
public override global::System.Data.DataSet Clone() { DsProveedor cln = ((DsProveedor)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { DsProveedor ds = new DsProveedor(); 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); }
private void Buscar() { int total = 0; try { IProveedor prov = ProveedorFactory.GetProveedor(); DsProveedor ds = prov.GetProveedoresConsultaDataSet(); string filtro = "Documento LIKE '" + this.documento + "%' AND RazonSocial LIKE '" + this.razonSocial + "%'"; //Agregar que si no le paso una agencia actual, no la tenga que buscar. if (this.proveedorActual != null && this.proveedorActual.Length > 0) { filtro += " AND ProveedorID <> " + this.proveedorActual; } DsProveedor.DatosRow[] drLista = (DsProveedor.DatosRow[])ds.Datos.Select(filtro); total = drLista.Length; if (total > 0) { if (total == 1) { DsProveedor.DatosRow dr = drLista[0]; this.txtProveedorID.Text = dr.ProveedorID.ToString(); this.txtDocumento.Text = dr.Documento; this.txtRazonSocial.Text = dr.RazonSocial; this.txtErrorMsg.Text = ""; this.txtOpen.Text = ""; } else { this.txtDocumento.Text = this.documento; this.txtRazonSocial.Text = this.razonSocial; this.txtOpen.Text = "S"; this.txtFiltro.Text = this.filtroEspecial; this.txtProveedorActual.Text = this.proveedorActual; } } else { this.txtProveedorID.Text = ""; this.txtErrorMsg.Text = "No se encontraron datos."; this.txtOpen.Text = ""; } } catch (Exception ex) { this.txtErrorMsg.Text = "Error al consultar datos de agencias: " + ex.Message; } }
public void Consultar() { try { DsProveedor ds = new DsProveedor(); SqlParameter pProveedorId = new SqlParameter("@ProveedorID", Utiles.BaseDatos.IntToSql(ProveedorID)); Config.Conexion.LlenarTypeDataSet(ds.Datos, System.Data.CommandType.StoredProcedure, "ProveedorONE", pProveedorId); if (ds.Datos.Count == 1) { DsProveedor.DatosRow dr = ds.Datos.FindByProveedorID(ProveedorID); RazonSocial = dr.RazonSocial; Documento = dr.Documento; } } catch (Exception ex) { throw ex; } }
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(); DsProveedor ds = new DsProveedor(); 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); }