public void Reporte_RESMOVINV(string vdesde, string vhasta)
{
DateTime dd = Convert.ToDateTime(vdesde);
DateTime dh = Convert.ToDateTime(vhasta);
Text = "Listado de Movimiento de Inventario por Productos y Cedulas";
Cnn.ConecDb_Abrir();
DTSDATOS DS = new DTSDATOS();
CRp_RESMOVINV rpt = new CRp_RESMOVINV();
string strSQL = $"SELECT T1.despro, T2.tiptra, T3.destra, count(T3.tiptra) AS cantmov, SUM(T2.canmov) AS sumov FROM productos T1 " +
$"INNER JOIN(SELECT codpro, tiptra, canmov, fecmov FROM movinv WHERE stamov = 1 GROUP BY codpro, canmov, tiptra, fecmov) AS T2 ON T1.codpro = T2.codpro " +
$"INNER JOIN tiptransa T3 ON T3.tiptra = T2.tiptra " +
$"WHERE (DATE(T2.fecmov) BETWEEN '{vdesde}' AND '{vhasta}') " +
$"GROUP BY T2.codpro, T2.tiptra, T3.destra, T1.despro " +
$"ORDER BY T2.codpro ASC";
if (Cnn.GetDataSet(ref DS, strSQL, "resmovinv"))
{
rpt.SetDataSource(DS);
rpt.SetParameterValue("Rdesde", string.Format("{0:d}", dd));
rpt.SetParameterValue("Rhasta", string.Format("{0:dd/MM/yyyy}", dh));
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Refresh();
}
Cnn.ConecDb_Close();
}
public void Reporte_LISPER()
{
Text = "Listado de Trabajdores";
Cnn.ConecDb_Abrir();
DTSDATOS DS = new DTSDATOS();
CRp_LISPER rpt = new CRp_LISPER();
string strSQL = $"SELECT T1.cedper, (T1.nomper || ' ' || T1.apeper) AS nompersonal, T3.nomdpt, T2.desgco, T1.retper, T1.staper " +
$"FROM personal T1 " +
$"INNER JOIN grupcomobs T2 ON T2.codgco = T1.codgco " +
$"INNER JOIN departa T3 ON T3.coddpt = T1.coddpt " +
$"ORDER BY T3.nomdpt ASC, T1.cedper ASC ";
if (Cnn.GetDataSet(ref DS, strSQL, "employee"))
{
rpt.SetDataSource(DS);
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Refresh();
}
Cnn.ConecDb_Close();
}
public void Reporte_MOVINVPROCED(string vdesde, string vhasta)
{
Text = "Listado de Movimiento de Inventario por Productos y Cedulas";
Cnn.ConecDb_Abrir();
DTSDATOS DS = new DTSDATOS();
CRp_MOVINVPROCED rpt = new CRp_MOVINVPROCED();
string strSQL = $"SELECT movinv.codpro, productos.despro, movinv.cedper, to_char(movinv.fecmov,'DD/MM/YYYY') AS fecmov, movinv.tiptra, movinv.canmov " +
$"FROM productos INNER JOIN movinv ON productos.codpro = movinv.codpro " +
$"WHERE movinv.stamov = 1 AND (DATE(movinv.fecmov) BETWEEN '{vdesde}' AND '{vhasta}') " +
$"GROUP BY movinv.codmov, movinv.cedper, movinv.codpro, movinv.fecmov, movinv.tiptra, productos.despro, movinv.canmov " +
$"ORDER BY movinv.codpro ASC, movinv.fecmov ASC, movinv.codmov ASC";
if (Cnn.GetDataSet(ref DS, strSQL, "movinvced"))
{
rpt.SetDataSource(DS);
crystalReportViewer1.ReportSource = rpt;
crystalReportViewer1.Refresh();
}
Cnn.ConecDb_Close();
}
