public override global::System.Data.DataSet Clone() { DSHojaCobranza cln = ((DSHojaCobranza)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { DSHojaCobranza ds = new DSHojaCobranza(); 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 CargarReporteCobranza() { DSHojaCobranza oDSHojaCobranza = new DSHojaCobranza(); VistaVenta oEntidad = new VistaVenta(); oEntidad.Fecha = DateTime.MinValue; oDSHojaCobranza = new BLVenta().ReporteCobranza(oEntidad); CRHojaCobranza oCRHojaCobranza = new CRHojaCobranza(); oCRHojaCobranza.Refresh(); oCRHojaCobranza.SetDataSource(oDSHojaCobranza); crvCobranza.ReportSource = oCRHojaCobranza; crvCobranza.RefreshReport(); }
public DSHojaCobranza ReporteCobranza(VistaVenta pVistaVenta) { DatabaseHelper oDatabaseHelper = new DatabaseHelper(); DSHojaCobranza oDSHojaCobranza = new DSHojaCobranza(); IDataReader oIDataReader = null; try { oDatabaseHelper.ClearParameter(); oDatabaseHelper.AddParameter("@intIdVenta", (pVistaVenta.IdVenta <= 0) ? (object)DBNull.Value : pVistaVenta.IdVenta); oDatabaseHelper.AddParameter("@datFecha", (pVistaVenta.Fecha == DateTime.MinValue) ? (object)DBNull.Value : pVistaVenta.Fecha); oDatabaseHelper.AddParameter("@intIdCliente", (pVistaVenta.IdCliente <= 0) ? (object)DBNull.Value : pVistaVenta.IdCliente); oDatabaseHelper.AddParameter("@intIdZona", (pVistaVenta.IdZona <= 0) ? (object)DBNull.Value : pVistaVenta.IdZona); oIDataReader = oDatabaseHelper.ExecuteReader("DGP_Listar_ReporteVenta_Cobranza", CommandType.StoredProcedure); while (oIDataReader.Read()) { oDSHojaCobranza.COBRANZA.AddCOBRANZARow( oIDataReader["Id_Venta"].ToString() , Convert.ToDecimal(oIDataReader["Total_Saldo"]) , oIDataReader["Tipo_Cobranza"].ToString() , Convert.ToDateTime(oIDataReader["FECHA"]) , oIDataReader["Zona"].ToString() , oIDataReader["Cliente"].ToString() , oIDataReader["TIPO_CLIENTE"].ToString() , oIDataReader["PRODUCTO"].ToString() , string.Empty , (oIDataReader["PesoNeto"] == DBNull.Value)? 0 : Convert.ToDecimal(oIDataReader["PesoNeto"]) , oIDataReader["EsSaldo"].ToString() ); } oDSHojaCobranza.COBRANZA.AcceptChanges(); return(oDSHojaCobranza); } catch (Exception ex) { throw ex; } finally { oDatabaseHelper.Dispose(); } }
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(); DSHojaCobranza ds = new DSHojaCobranza(); 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 = "COBRANZADataTable"; 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); }