Beispiel #1
0
        public void CargarReporte(String LCorrelativo)
        {
            DataSet   DSDevuelve = new DataSet();
            DataTable DTMain     = new DataTable();

            this.MdiParent = MFMdi.ActiveForm;
            this.Left      = 0;
            this.Top       = 0;
            WSAdministracion.WSAdministracion WSAdm = new WSAdministracion.WSAdministracion();
            WSAdm.Url  = mdlGenerales.DireccionWS + "FazServices/WSAdministracion.asmx";
            DSDevuelve = WSAdm.GeneraReporteEAR(mdlGenerales.Conexion, LCorrelativo);
            DTMain     = DSDevuelve.Tables[0];
            DataSet   DSArma = new DataSet();
            DataTable DTArma = new DataTable();

            DTArma.Columns.Add("tipo", Type.GetType("System.String"));
            DTArma.Columns.Add("correlativo", Type.GetType("System.String"));
            DTArma.Columns.Add("ndoc", Type.GetType("System.String"));
            DTArma.Columns.Add("nombres", Type.GetType("System.String"));
            DTArma.Columns.Add("detalle", Type.GetType("System.String"));
            DTArma.Columns.Add("documento", Type.GetType("System.String"));
            DTArma.Columns.Add("fecha", Type.GetType("System.DateTime"));
            DTArma.Columns.Add("abreviatura", Type.GetType("System.String"));
            DTArma.Columns.Add("monto", Type.GetType("System.Decimal"));
            DTArma.Columns.Add("tc", Type.GetType("System.Decimal"));
            DTArma.Columns.Add("soles", Type.GetType("System.Decimal"));
            DTArma.Columns.Add("logo", Type.GetType("System.Byte[]"));
            DTArma.Columns.Add("FechaEAR", Type.GetType("System.DateTime"));
            DataRow DR;

            foreach (DataRow Row in DTMain.Rows)
            {
                DR                = DTArma.NewRow();
                DR["tipo"]        = Row[0].ToString();
                DR["correlativo"] = Row[1].ToString();
                DR["ndoc"]        = Row[2].ToString();
                DR["nombres"]     = Row[3].ToString();
                DR["detalle"]     = Row[4].ToString();
                DR["documento"]   = Row[5].ToString();
                DR["fecha"]       = Convert.ToDateTime(Row[6].ToString());
                DR["abreviatura"] = Row[7].ToString();
                DR["monto"]       = Convert.ToDecimal(Row[8].ToString());
                DR["tc"]          = Convert.ToDecimal(Row[9].ToString());
                DR["soles"]       = Convert.ToDecimal(Row[10].ToString());
                DR["logo"]        = Mostrar(Row[11].ToString());
                DR["FechaEAR"]    = Convert.ToDateTime(Row[12].ToString());
                DTArma.Rows.Add(DR);
            }
            Report.Database.Tables[0].SetDataSource(DTArma);
            CRVReport.ReportSource = Report;
            CRVReport.Zoom(100);
            CRVReport.Visible = true;
        }