Esempio n. 1
0
        private void WorkerMethodRpt(object sender, WaitWindowEventArgs e)
        {
            string path = Application.StartupPath;

            path = path.Replace("\\", "/");
            path = path.Replace("/bin/Debug", "");

            path = path + "/Dominio/Reportes/rptFrecEnf.rpt";

            rpt.Load(path);

            Conexion.CMD.CommandText = this.sql;

            using (SqlDataAdapter da = new SqlDataAdapter(Conexion.CMD))
            {
                using (ReportsDS ds = new ReportsDS())
                {
                    ds.Clear();
                    da.Fill(ds, 0, int.Parse(spinner1.Value.ToString()), "FrecEnf");
                    rpt.SetDataSource(ds);
                }
            }

            //rpt.SetParameterValue("consul", e.Arguments[0].ToString());
            //rpt.SetParameterValue("fi", e.Arguments[1].ToString());
            //rpt.SetParameterValue("ff", e.Arguments[2].ToString());
            rpt.SetParameterValue("texto", this.texto);

            e.Result = true;
        }
Esempio n. 2
0
        private void WorkerMethodRpt(object sender, WaitWindowEventArgs e)
        {
            string path = Application.StartupPath;

            path = path.Replace("\\", "/");
            path = path.Replace("/bin/Debug", "");

            path = path + "/Dominio/Reportes/rptTotVenEsp.rpt";

            rpt.Load(path);

            Conexion.CMD.CommandText = this.sqlVenCons;

            using (SqlDataAdapter da = new SqlDataAdapter(Conexion.CMD))
            {
                using (ReportsDS ds = new ReportsDS())
                {
                    ds.Clear();
                    da.Fill(ds, "VenCons");
                    rpt.SetDataSource(ds);
                }
            }

            e.Result = true;
        }
Esempio n. 3
0
        private void WorkerMethodRpt(object sender, WaitWindowEventArgs e)
        {
            string path = Application.StartupPath;

            path = path.Replace("\\", "/");
            path = path.Replace("/bin/Debug", "");

            path = path + "/Dominio/Reportes/rptTotUser.rpt";

            rpt.Load(path);

            Conexion.CMD.CommandText = this.vSQL;
            int count = 0;

            using (SqlDataAdapter da = new SqlDataAdapter(Conexion.CMD))
            {
                using (ReportsDS ds = new ReportsDS())
                {
                    ds.Clear();
                    da.Fill(ds, "TotUser");
                    count = ds.Tables["TotUser"].Rows.Count;

                    foreach (DataRow row in ds.Tables["TotUser"].Rows)
                    {
                        row["Digitador"] = General.TradUser(row["Digitador"].ToString());
                    }
                    rpt.SetDataSource(ds);
                }
            }

            e.Result = count.ToString();
        }
Esempio n. 4
0
        private void WorkerMethodRptPagEsp(object sender, WaitWindowEventArgs e)
        {
            string path = Application.StartupPath;

            path = path.Replace("\\", "/");
            path = path.Replace("/bin/Debug", "");

            path = path + "/Dominio/Reportes/rptPagEsp.rpt";

            rpt.Load(path);

            int count = 0;

            Conexion.CMD.CommandText = this.vSQL;
            using (SqlDataAdapter da = new SqlDataAdapter(Conexion.CMD))
            {
                using (ReportsDS ds = new ReportsDS())
                {
                    ds.Clear();
                    da.Fill(ds, "PagEsp");
                    count = ds.Tables["PagEsp"].Rows.Count;
                    rpt.SetDataSource(ds);
                }
            }

            rpt.SetParameterValue("periodo", this.periodo);
            rpt.SetParameterValue("subtitle", this.subtitle);

            e.Result = count.ToString();
        }
Esempio n. 5
0
        private void WorkerMethodRptProdMedCon(object sender, WaitWindowEventArgs e)
        {
            string path = Application.StartupPath;

            path = path.Replace("\\", "/");
            path = path.Replace("/bin/Debug", "");

            path = path + "/Dominio/Reportes/rptProdMedCon.rpt";

            rpt.Load(path);

            int    count = 0;
            string sql   = "SELECT X.año, X.mes, X.fecha_atencion, X.medico, X.consultorio, SUM(X.ccon) AS cantidad, SUM(X.tcon) AS total, X.turno, X.cturno, X.horas, X.colegiatura, X.sueldo from (" + this.vSQL + ") X WHERE ccon>0 GROUP BY X.año, X.mes, X.fecha_atencion, X.medico, X.consultorio, X.turno, X.cturno, X.horas, X.colegiatura, X.sueldo";

            sql = "SELECT Y.año, Y.mes, Y.fecha_atencion, Y.medico, Y.consultorio, SUM(Y.cantidad) AS cantidad, SUM(Y.total) AS total, Y.turno, Y.cturno, Y.horas, Y.colegiatura, SUM(Y.sueldo * Y.cturno) AS sueldo from (" + sql + ") Y GROUP BY Y.año, Y.mes, Y.fecha_atencion, Y.medico, Y.consultorio, Y.turno, Y.cturno, Y.horas, Y.colegiatura ORDER BY 4, 3, 8";
            Conexion.CMD.CommandText = sql;
            using (SqlDataAdapter da = new SqlDataAdapter(Conexion.CMD))
            {
                using (ReportsDS ds = new ReportsDS())
                {
                    ds.Clear();
                    da.Fill(ds, "ProdMed");
                    count = ds.Tables["ProdMed"].Rows.Count;
                    rpt.SetDataSource(ds);
                }
            }

            rpt.SetParameterValue("periodo", this.periodo);
            rpt.SetParameterValue("subtitle", this.subtitle);

            e.Result = count.ToString();
        }
Esempio n. 6
0
        private void WorkerMethodRPT(object sender, WaitWindowEventArgs e)
        {
            int    option   = (int)e.Arguments[0];
            string sql      = e.Arguments[1].ToString();
            string rptName  = e.Arguments[2].ToString();
            string rptTable = e.Arguments[3].ToString();
            string nText    = e.Arguments[4].ToString();

            //define la ruta por defecto de la app
            string path = Application.StartupPath;

            path = path.Replace("\\", "/");
            path = path.Replace("/bin/Debug", "");

            //define el reporte dependiendo del tipo de seleccion
            path = path + "/Dominio/Reportes/" + rptName + ".rpt";

            //carga el reporte
            rpt.Load(path);

            Conexion.CMD.CommandText = sql;
            using (SqlDataAdapter da = new SqlDataAdapter(Conexion.CMD))
            {
                using (ReportsDS ds = new ReportsDS())
                {
                    ds.Clear();
                    da.Fill(ds, rptTable);
                    rpt.SetDataSource(ds);
                }
            }

            //setea los parametros del reporte Parte de atencion diario
            rpt.SetParameterValue("nText", nText);

            if (e.Arguments.Count > 0)
            {
                e.Result = e.Arguments[0].ToString();
            }
            else
            {
                e.Result = "Proceso culminado.";
            }
        }
Esempio n. 7
0
        private void WorkerMethodRpt(object sender, WaitWindowEventArgs e)
        {
            string path = Application.StartupPath;

            path = path.Replace("\\", "/");
            path = path.Replace("/bin/Debug", "");

            string rptName = "";
            string table   = "";

            if (rbVentas.Checked)
            {
                rptName = "rptVenxPac";
                table   = "VenxPac";
            }
            else
            {
                rptName = "rptAtenxPac";
                table   = "AtenxPac";
            }

            path = path + "/Dominio/Reportes/" + rptName + ".rpt";

            rpt.Load(path);

            Conexion.CMD.CommandText = this.sql;

            using (SqlDataAdapter da = new SqlDataAdapter(Conexion.CMD))
            {
                using (ReportsDS ds = new ReportsDS())
                {
                    ds.Clear();
                    da.Fill(ds, table);
                    rpt.SetDataSource(ds);
                }
            }

            rpt.SetParameterValue("paciente", txtPaciente.Text);


            e.Result = true;
        }
Esempio n. 8
0
        private void WorkerMethodRptProdMedPrcSOP(object sender, WaitWindowEventArgs e)
        {
            string path = Application.StartupPath;

            path = path.Replace("\\", "/");
            path = path.Replace("/bin/Debug", "");

            path = path + "/Dominio/Reportes/rptProdMedPrcSOP.rpt";

            rpt.Load(path);

            int count = 0;

            string sql = "";

            if (e.Arguments[0].ToString() == "PROCEDIMIENTO")
            {
                sql = "SELECT X.año, X.mes, X.fecha_atencion, X.medico, X.consultorio, X.producto, SUM(X.cprc) AS cantidad, SUM(X.tprc) AS total, '" + e.Arguments[0].ToString() + "' AS modo, X.sueldo FROM (" + this.vSQL + ") X WHERE X.cprc > 0 GROUP BY X.año, X.mes, X.fecha_atencion, X.medico, X.consultorio, X.producto, X.sueldo ORDER BY 9, 4, 3, 5, 6";
            }
            else
            {
                sql = "SELECT X.año, X.mes, X.fecha_atencion, X.medico, X.consultorio, X.producto, SUM(X.csop) AS cantidad, SUM(X.tsop) AS total, '" + e.Arguments[0].ToString() + "' AS modo, X.sueldo FROM (" + this.vSQL + ") X WHERE X.csop > 0 GROUP BY X.año, X.mes, X.fecha_atencion, X.medico, X.consultorio, X.producto, X.sueldo ORDER BY 9, 4, 3, 5, 6";
            }

            Conexion.CMD.CommandText = sql;
            using (SqlDataAdapter da = new SqlDataAdapter(Conexion.CMD))
            {
                using (ReportsDS ds = new ReportsDS())
                {
                    ds.Clear();
                    da.Fill(ds, "ProdMedPrcSOP");
                    count = ds.Tables["ProdMedPrcSOP"].Rows.Count;
                    rpt.SetDataSource(ds);
                }
            }

            rpt.SetParameterValue("periodo", this.periodo);
            rpt.SetParameterValue("subtitle", this.subtitle);

            e.Result = count.ToString();
        }
Esempio n. 9
0
        private void WorkerMethodRPT(object sender, WaitWindowEventArgs e)
        {
            //define la ruta por defecto de la app
            string path = Application.StartupPath;

            path = path.Replace("\\", "/");
            path = path.Replace("/bin/Debug", "");

            //define el reporte dependiendo del tipo de seleccion
            path = path + "/Dominio/Reportes/rptTalon.rpt";

            //carga el reporte
            rpt.Load(path);

            Conexion.CMD.CommandText = getSql(e.Arguments[0].ToString(), e.Arguments[1].ToString(), e.Arguments[2].ToString(), e.Arguments[3].ToString());
            using (SqlDataAdapter da = new SqlDataAdapter(Conexion.CMD))
            {
                using (ReportsDS ds = new ReportsDS())
                {
                    ds.Clear();
                    da.Fill(ds, "Talon");
                    rpt.SetDataSource(ds);
                }
            }

            //setea los parametros del reporte Parte de atencion diario
            rpt.SetParameterValue("TituloReporte", "Talonario de documentos de venta");
            rpt.SetParameterValue("Fecha", DateTime.Now.ToLongDateString());

            if (e.Arguments.Count > 0)
            {
                e.Result = e.Arguments[0].ToString();
            }
            else
            {
                e.Result = "Proceso culminado.";
            }
        }