コード例 #1
0
        private void CargarReporte()
        {
            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.DevuelveReporteCostosGeneral(mdlGenerales.Conexion,
                                                            RucEmpresa[Convert.ToInt32(cmbEmpresa.SelectedIndex.ToString())].ToString(),
                                                            IDproyecto[Convert.ToInt32(cmbProyecto.SelectedIndex.ToString())].ToString());
            DTMain = DSDevuelve.Tables[0];
            DataSet   DSArma = new DataSet();
            DataTable DTArma = new DataTable();

            DTArma.Columns.Add("empresa", Type.GetType("System.String"));
            DTArma.Columns.Add("Descripcion", Type.GetType("System.String"));
            DTArma.Columns.Add("inicio", Type.GetType("System.DateTime"));
            DTArma.Columns.Add("ruc", Type.GetType("System.String"));
            DTArma.Columns.Add("tipocosto", Type.GetType("System.String"));
            DTArma.Columns.Add("detalletc", Type.GetType("System.String"));
            DTArma.Columns.Add("IGV", Type.GetType("System.Decimal"));
            DTArma.Columns.Add("totalsinigv", Type.GetType("System.Decimal"));
            DTArma.Columns.Add("total", Type.GetType("System.Decimal"));
            DTArma.Columns.Add("logo", Type.GetType("System.Byte[]"));
            DataRow DR;

            foreach (DataRow Row in DTMain.Rows)
            {
                DR                = DTArma.NewRow();
                DR["empresa"]     = Row[0].ToString();
                DR["Descripcion"] = Row[1].ToString();
                DR["inicio"]      = Convert.ToDateTime(Row[2].ToString());
                DR["ruc"]         = Row[3].ToString();
                DR["tipocosto"]   = Row[4].ToString();
                DR["detalletc"]   = Row[5].ToString();
                DR["IGV"]         = Convert.ToDecimal(Row[6].ToString());
                DR["totalsinigv"] = Convert.ToDecimal(Row[7].ToString());
                DR["total"]       = Convert.ToDecimal(Row[8].ToString());
                DR["logo"]        = Mostrar(Row[9].ToString());
                DTArma.Rows.Add(DR);
            }
            Report.Database.Tables[0].SetDataSource(DTArma);
            CRVReport.ReportSource = Report;
            CRVReport.Zoom(100);
            CRVReport.Visible = true;
        }