示例#1
0
        public void cargarReporte()
        {
            MySqlDataAdapter adapter;

            fechaIni = dtp.Value.Year.ToString() + "/" + dtp.Value.Month.ToString() + "/" + dtp.Value.Day.ToString();
            fechaFin = dtp2.Value.Year.ToString() + "/" + dtp2.Value.Month.ToString() + "/" + dtp2.Value.Day.ToString();

            try
            {
                crearConsulta();
                ds      = new dataSet_inventarios();
                adapter = new MySqlDataAdapter(query, con);
                adapter.Fill(ds, "PromedioCompra");

                //aki va el switch

                switch (cb_tipo.SelectedIndex)
                {
                case 0:    //Texto
                    reportetxt = new crPromedioT();
                    reportetxt.SetDataSource(ds);
                    crv.ReportSource = reportetxt;
                    break;

                case 1:    //Grafica
                    reporteg = new crPromedioG();
                    reporteg.SetDataSource(ds);
                    crv.ReportSource = reporteg;
                    break;

                case 2:    //Ambos
                    reporte = new crPromedio();
                    reporte.SetDataSource(ds);
                    crv.ReportSource = reporte;
                    break;
                }
            }
            catch (FormatException fex)
            {
                MessageBox.Show(fex.Message);
            }
        }
示例#2
0
        public void cargarReporte()
        {
            MySqlDataAdapter adapter;

            fechaIni = dtp.Value.Year.ToString() + "/" + dtp.Value.Month.ToString() + "/" + dtp.Value.Day.ToString();
            fechaFin = dtp2.Value.Year.ToString() + "/" + dtp2.Value.Month.ToString() + "/" + dtp2.Value.Day.ToString();

            try
            {
                crearConsulta();
                ds = new dataSet_inventarios();
                adapter = new MySqlDataAdapter(query, con);
                adapter.Fill(ds, "PromedioCompra");

                //aki va el switch

                switch (cb_tipo.SelectedIndex)
                {
                    case 0://Texto
                        reportetxt = new crPromedioT();
                        reportetxt.SetDataSource(ds);
                        crv.ReportSource = reportetxt;
                    break;
                    case 1://Grafica
                        reporteg = new crPromedioG();
                        reporteg.SetDataSource(ds);
                        crv.ReportSource = reporteg;
                    break;
                    case 2://Ambos
                        reporte = new crPromedio();
                        reporte.SetDataSource(ds);
                        crv.ReportSource = reporte;
                    break;
                }

            }
            catch(FormatException fex)
            {
                MessageBox.Show(fex.Message);
            }
        }