public override global::System.Data.DataSet Clone() { DataSetContaPagar cln = ((DataSetContaPagar)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { DataSetContaPagar ds = new DataSetContaPagar(); 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 ActionResult GerarBuscaRelatorioContaPagar(FormCollection fomulario) { try { DateTime DataIncio = DateTime.MinValue; DateTime DataFim = DateTime.MinValue; Usuario u = (Usuario)Session["usuario"]; if (!Request["DataIncio"].ToString().Equals(string.Empty)) { try { DataIncio = Convert.ToDateTime(Request["DataIncio"].ToString()); } catch { ViewBag.Mensagem = "Data Inicio Invalida! "; } } if (!Request["DataFim"].ToString().Equals(string.Empty)) { try { DataFim = Convert.ToDateTime(Request["DataFim"].ToString()); } catch { ViewBag.Mensagem = "Data Final Invalida! "; } } if (DataIncio > DataFim) { throw new Exception("A Data de Incio não pode ser menor que a data Final."); } string formato = Request["formato"].ToString(); ContaPagarDal d = new ContaPagarDal(); List<ContaPagar> Lista = d.FindByRelatorio(DataIncio, DataFim, u.IdUsuario); DataSetContaPagar ds = new DataSetContaPagar(); DataTable dt = ds.CONTAPAGAR; foreach (ContaPagar c in Lista) { DataRow registro = dt.NewRow(); registro["CODIGO"] = c.IdContaPagar; registro["NOME"] = c.Nome; registro["DATAPAGAMENTO"] = c.DataPagamento; registro["VALOR"] = c.Valor; dt.Rows.Add(registro); } RelContaPagar rel = new RelContaPagar(); rel.SetDataSource(dt); Stream arquivo = null; switch (formato) { case "1": //PDF arquivo = rel.ExportToStream(ExportFormatType.PortableDocFormat); return File(arquivo, "application/pdf", "relatorio.pdf"); case "2": //Word arquivo = rel.ExportToStream(ExportFormatType.WordForWindows); return File(arquivo, "application/msword", "relatorio"); case "3": //Excel arquivo = rel.ExportToStream(ExportFormatType.Excel); return File(arquivo, "application/excel", "relatorio"); } } catch (Exception e) { ViewBag.Mensagem = e.Message; } return View("BuscaContaPagar"); }
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(); DataSetContaPagar ds = new DataSetContaPagar(); 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 = "CONTAPAGARDataTable"; 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); }
public ActionResult GerarBuscaRelatorioContaPagar(FormCollection fomulario) { try { DateTime DataIncio = DateTime.MinValue; DateTime DataFim = DateTime.MinValue; Usuario u = (Usuario)Session["usuario"]; if (!Request["DataIncio"].ToString().Equals(string.Empty)) { try { DataIncio = Convert.ToDateTime(Request["DataIncio"].ToString()); } catch { ViewBag.Mensagem = "Data Inicio Invalida! "; } } if (!Request["DataFim"].ToString().Equals(string.Empty)) { try { DataFim = Convert.ToDateTime(Request["DataFim"].ToString()); } catch { ViewBag.Mensagem = "Data Final Invalida! "; } } if (DataIncio > DataFim) { throw new Exception("A Data de Incio não pode ser menor que a data Final."); } string formato = Request["formato"].ToString(); ContaPagarDal d = new ContaPagarDal(); List <ContaPagar> Lista = d.FindByRelatorio(DataIncio, DataFim, u.IdUsuario); DataSetContaPagar ds = new DataSetContaPagar(); DataTable dt = ds.CONTAPAGAR; foreach (ContaPagar c in Lista) { DataRow registro = dt.NewRow(); registro["CODIGO"] = c.IdContaPagar; registro["NOME"] = c.Nome; registro["DATAPAGAMENTO"] = c.DataPagamento; registro["VALOR"] = c.Valor; dt.Rows.Add(registro); } RelContaPagar rel = new RelContaPagar(); rel.SetDataSource(dt); Stream arquivo = null; switch (formato) { case "1": //PDF arquivo = rel.ExportToStream(ExportFormatType.PortableDocFormat); return(File(arquivo, "application/pdf", "relatorio.pdf")); case "2": //Word arquivo = rel.ExportToStream(ExportFormatType.WordForWindows); return(File(arquivo, "application/msword", "relatorio")); case "3": //Excel arquivo = rel.ExportToStream(ExportFormatType.Excel); return(File(arquivo, "application/excel", "relatorio")); } } catch (Exception e) { ViewBag.Mensagem = e.Message; } return(View("BuscaContaPagar")); }