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();
}
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;
}
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();
}
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;
}
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();
}
public override global::System.Data.DataSet Clone()
{
ReportsDS cln = ((ReportsDS)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
ReportsDS ds = new ReportsDS();
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);
}
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.";
}
}
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;
}
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();
}
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.";
}
}
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();
ReportsDS ds = new ReportsDS();
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 = "RptTblDataTable";
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);
}
