public override global::System.Data.DataSet Clone()
        {
            dsConcepto cln = ((dsConcepto)(base.Clone()));

            cln.InitVars();
            cln.SchemaSerializationMode = this.SchemaSerializationMode;
            return(cln);
        }
        public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
        {
            dsConcepto ds = new dsConcepto();

            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);
        }
示例#3
0
        public ActionResult Reporte(int id)
        {
            //string pathRpt = Path.Combine(Server.MapPath("~/Reports"), "RptHistoria.rpt");
            try
            {
                dsHistoria     dshistoria  = new dsHistoria();
                string         conn        = ConfigurationManager.AppSettings["conexion"];
                SqlConnection  sqlcon      = new SqlConnection(conn);
                historia       historia    = db.historia.Find(id);
                string         strHistoria = "Select * from view_historia where his_id=" + id;
                SqlDataAdapter daHistoria  = new SqlDataAdapter(strHistoria, sqlcon);
                daHistoria.Fill(dshistoria, "view_historia");
                RptHistoria rp         = new RptHistoria();
                string      reportPath = Server.MapPath("~/Reports/RptHistoria.rpt");
                rp.Load(reportPath);
                rp.SetDataSource(dshistoria);

                //Subreportes
                //TRABAJOS ANTERIORES
                dsHistorico    dshistorico  = new dsHistorico();
                string         strHistorico = "Select * from ocupacional where ocu_tipo='histórico' and ocu_paciente=" + historia.his_paciente;
                SqlDataAdapter daHistorico  = new SqlDataAdapter(strHistorico, sqlcon);
                daHistorico.Fill(dshistorico, "ocupacional");
                //INFORMACIÓN OCUPACIONAL
                dsHistorico    dsocupacional  = new dsHistorico();
                string         strOcupacional = "Select top 1 * from ocupacional where ocu_tipo='actual' and ocu_paciente=" + historia.his_paciente;
                SqlDataAdapter daOcupacional  = new SqlDataAdapter(strOcupacional, sqlcon);
                daOcupacional.Fill(dsocupacional, "ocupacional");
                //riesgos laborales
                dsRiesgos      dsriesgos  = new dsRiesgos();
                string         strRiesgos = "Select * from view_riesgo where ocu_paciente=" + historia.his_paciente;
                SqlDataAdapter daRiesgos  = new SqlDataAdapter(strRiesgos, sqlcon);
                daRiesgos.Fill(dsriesgos, "view_riesgo");
                ////diagnostico
                dsDiagnostico  dsdiagnostico  = new dsDiagnostico();
                string         strDiagnostico = "Select * from view_diagnostico where dia_historia=" + historia.his_id;
                SqlDataAdapter daDiagnostico  = new SqlDataAdapter(strDiagnostico, sqlcon);
                daDiagnostico.Fill(dsdiagnostico, "view_diagnostico");
                ////inmunizacion
                dsInmunizacion dsinmunizacion  = new dsInmunizacion();
                string         strInmunizacion = "Select * from view_inmunizacion where inm_paciente=" + historia.his_paciente;
                SqlDataAdapter daInmunizacion  = new SqlDataAdapter(strInmunizacion, sqlcon);
                daInmunizacion.Fill(dsinmunizacion, "view_inmunizacion");
                //concepto
                dsConcepto     dsconcepto  = new dsConcepto();
                string         strConcepto = "Select * from concepto where con_id=" + historia.his_id;
                SqlDataAdapter daConcepto  = new SqlDataAdapter(strConcepto, sqlcon);
                daConcepto.Fill(dsconcepto, "concepto");

                rp.Subreports["RptHistorico.rpt"].SetDataSource(dshistorico);
                rp.Subreports["RptOcupacional.rpt"].SetDataSource(dsocupacional);
                rp.Subreports["RptRiesgos.rpt"].SetDataSource(dsriesgos);
                rp.Subreports["RptDiagnostico.rpt"].SetDataSource(dsdiagnostico);
                rp.Subreports["RptInmunizacion.rpt"].SetDataSource(dsinmunizacion);
                rp.Subreports["RptConcepto.rpt"].SetDataSource(dsconcepto);
                Stream stream = rp.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat);
                stream.Seek(0, SeekOrigin.Begin);
                return(File(stream, "application/pdf", "Reporte.pdf"));
            }
            catch (Exception ex)
            {
                return(RedirectToAction("Message", "Home", new { mensaje = ex.Message + ex.InnerException }));
            }
        }
            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();
                dsConcepto ds = new dsConcepto();

                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 = "ConceptoDataTable";
                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);
            }