public DataTable GetFactura_rpt01(EParOCFillrpt oc)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@fechaini", SqlDbType.Char, oc.fechaini));
arrPrm.Add(DBAccess.CreateParameter("@fechafin", SqlDbType.VarChar, oc.fechaFin));
arrPrm.Add(DBAccess.CreateParameter("@idcliprov", SqlDbType.VarChar, oc.idProv));
arrPrm.Add(DBAccess.CreateParameter("@local", SqlDbType.VarChar, oc.local));
arrPrm.Add(DBAccess.CreateParameter("@idempresa", SqlDbType.VarChar, oc.IdEmpresa));
DataTable dt = db.ExecuteDatatable("sp_ocfactura_rpt", arrPrm);
return dt;
}
public DataTable AL_Salida_Detalle_rpt02(ESalida_Detalle obj)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, obj.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@fecha_ini", SqlDbType.DateTime, obj.Fe_creatrec));
arrPrm.Add(DBAccess.CreateParameter("@fecha_fin", SqlDbType.DateTime, obj.Fe_uupdarec));
arrPrm.Add(DBAccess.CreateParameter("@vendedor", SqlDbType.VarChar, 15, obj.Id_vendedor));
arrPrm.Add(DBAccess.CreateParameter("@producto", SqlDbType.VarChar, 20, obj.Id_producto));
arrPrm.Add(DBAccess.CreateParameter("@color", SqlDbType.VarChar, 40, obj.Id_color));
arrPrm.Add(DBAccess.CreateParameter("@cliente", SqlDbType.VarChar, 50, obj._id_cliente));
arrPrm.Add(DBAccess.CreateParameter("@tipo", SqlDbType.VarChar, 20, obj.Id_tipo));
arrPrm.Add(DBAccess.CreateParameter("@dsMercado", SqlDbType.VarChar, 15, obj.Id_mercado));
arrPrm.Add(DBAccess.CreateParameter("@dstipTela", SqlDbType.VarChar, 15, obj.Id_tiptela));
DataTable dt = db.ExecuteDatatable("AL_Salida_Detalle_rpt02", arrPrm);
return dt;
}
public DataTable MG_Cliente_rpt01(ECliente c)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@idEmpresa", SqlDbType.Char, 3, c.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@nu_ruc", SqlDbType.Char, 11, c.Nu_ruc.Trim()));
arrPrm.Add(DBAccess.CreateParameter("@ds_raznombre", SqlDbType.Char, 100, c.Ds_raznombre.Trim()));
DataTable dt = db.ExecuteDatatable("MG_Cliente_rpt01", arrPrm);
return dt;
}
// orden de compra por proveedor
public DataTable GetOrdenCompra_rpt03(EParOCFillrpt oc)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@idEmpresa", SqlDbType.Char, 3, oc.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@fechaIni", SqlDbType.DateTime, oc.fechaini));
arrPrm.Add(DBAccess.CreateParameter("@fechaFin", SqlDbType.DateTime, oc.fechaFin));
arrPrm.Add(DBAccess.CreateParameter("@idcliprov", SqlDbType.VarChar, oc.idProv));
DataTable dt = db.ExecuteDatatable("CO_OrdenCompraXprov_qry03_rpt", arrPrm);
return dt;
}
//reprote de orden de compra por proveedor
public DataTable GetOrdenCompra_rpt04(EParOCFillrpt oc)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@idEmpresa", SqlDbType.Char, 3, oc.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@año", SqlDbType.VarChar, 5, oc.IdAnio));
arrPrm.Add(DBAccess.CreateParameter("@mes", SqlDbType.VarChar, 16, oc.IdMesIni));
arrPrm.Add(DBAccess.CreateParameter("@prov", SqlDbType.VarChar, 6, oc.idProv));
arrPrm.Add(DBAccess.CreateParameter("@fac", SqlDbType.VarChar, 8, oc.nuFactura));
arrPrm.Add(DBAccess.CreateParameter("@impotacion", SqlDbType.VarChar, 10, oc.nuImportacion));
arrPrm.Add(DBAccess.CreateParameter("@Expotacion", SqlDbType.VarChar, 10, oc.nuExportacion));
DataTable dt = db.ExecuteDatatable("CO_OrdenCompra_qry02_rpt", arrPrm);
return dt;
}
public DataTable AL_Salida_rpt01(ESalida obj)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, obj.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@pidPeriodo", SqlDbType.Char, 4, obj.IdPeriodo));
arrPrm.Add(DBAccess.CreateParameter("@pidSalida", SqlDbType.Char, 7, obj.IdSalida));
DataTable dt = db.ExecuteDatatable("AL_Salida_rpt01", arrPrm);
return dt;
}
public DataTable GetOrdenCompra_rpt02(EParOCFillrpt oc)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@pchr_idperiodo", SqlDbType.Char, 4, oc.IdAnio));
arrPrm.Add(DBAccess.CreateParameter("@pchr_idordenco", SqlDbType.Char, 7, oc.IdOrdenCompra));
arrPrm.Add(DBAccess.CreateParameter("@pdte_empresa", SqlDbType.Char, 3, oc.IdEmpresa));
DataTable dt = db.ExecuteDatatable("RPT_OrdenCompra", arrPrm);
return dt;
}
public DataTable _AL_Producto_Stock(EIngresoDetalle obj)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@psintypesel", SqlDbType.Char, 1, obj.psintypesel));
arrPrm.Add(DBAccess.CreateParameter("@pidEmpresa", SqlDbType.VarChar, 3, obj.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@ds_raznombre", SqlDbType.VarChar, 60, obj.ds_clipro));
arrPrm.Add(DBAccess.CreateParameter("@ds_producto", SqlDbType.VarChar, 100, obj.ds_producto));
arrPrm.Add(DBAccess.CreateParameter("@ds_vendedor", SqlDbType.VarChar, 60, obj.Ds_Vendedor));
arrPrm.Add(DBAccess.CreateParameter("@ds_color", SqlDbType.VarChar, 60, obj.ds_color));
DataTable dt = db.ExecuteDatatable("AL_Ingreso_Detalle_Stock", arrPrm);
return dt;
}
public DataTable CO_OrdenCompra_qry09_rpt(EParOCFillrpt oc)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@idEmpresa", SqlDbType.Char, 3, oc.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@anio", SqlDbType.VarChar, 4, oc.IdAnio));
arrPrm.Add(DBAccess.CreateParameter("@mesIni", SqlDbType.VarChar, 2, oc.IdMesIni));
arrPrm.Add(DBAccess.CreateParameter("@mesFin", SqlDbType.VarChar, 2, oc.IdMesfin));
arrPrm.Add(DBAccess.CreateParameter("@st_aprueba", SqlDbType.VarChar, 1, oc.st_aprueba));
DataTable dt = db.ExecuteDatatable("CO_OrdenCompra_qry09_rpt", arrPrm);
return dt;
}
public DataTable AL_Ingreso_Detalle_rpt01(EIngresoDetalle oc)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@idEmpresa", SqlDbType.Char, 3, oc.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@feIni", SqlDbType.VarChar, 10, oc.fecha));
arrPrm.Add(DBAccess.CreateParameter("@feFin", SqlDbType.VarChar, 10, oc.fechaFin));
arrPrm.Add(DBAccess.CreateParameter("@dsCliente", SqlDbType.VarChar, 60, oc.ds_clipro));
arrPrm.Add(DBAccess.CreateParameter("@dsProducto", SqlDbType.VarChar, 100, oc.ds_producto));
arrPrm.Add(DBAccess.CreateParameter("@dsColor", SqlDbType.VarChar, 80, oc.ds_color));
arrPrm.Add(DBAccess.CreateParameter("@dsMercado", SqlDbType.VarChar, 30, oc.Id_mercado));
arrPrm.Add(DBAccess.CreateParameter("@dsTipTela", SqlDbType.VarChar, 20, oc.Id_tipTela));
arrPrm.Add(DBAccess.CreateParameter("@dsTipIngreso", SqlDbType.VarChar, 30, oc.Id_TipIngreso));
arrPrm.Add(DBAccess.CreateParameter("@dsTipo", SqlDbType.VarChar, 30, oc.Id_Tipo));
DataTable dt = db.ExecuteDatatable("AL_Ingreso_Detalle_rpt01", arrPrm);
return dt;
}
public DataTable AL_Ingreso_etiqueta03_rpt(EIngresoDetalle oc)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, oc.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@Cod_Bar", SqlDbType.VarChar, oc.Cod_Bar));
DataTable dt = db.ExecuteDatatable("AL_Ingreso_etiqueta03_rpt", arrPrm);
return dt;
}
public DataTable AL_Ingreso_etiqueta_rpt(EIngreso obj)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
//arrPrm.Add(DBAccess.CreateParameter("@psintypesel", SqlDbType.Int, tj.psintypesel));
arrPrm.Add(DBAccess.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, obj.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@pidPeriodo", SqlDbType.Char, 4, obj.IdPeriodo));
arrPrm.Add(DBAccess.CreateParameter("@pidIngreso", SqlDbType.Char, 7, obj.IdIngreso));
DataTable dt = db.ExecuteDatatable("AL_Ingreso_etiqueta_rpt", arrPrm);
return dt;
}
public DataTable VE_OrdenPedido_qry07_rpt(EParametros obj)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, obj.idEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@pidPeriodo", SqlDbType.Char, 4, obj.idperiodo));
// arrPrm.Add(DBAccess.CreateParameter("@pidreqsalida", SqlDbType.Char, 7, obj.pidreqsalida));
arrPrm.Add(DBAccess.CreateParameter("@pdte_feordenpeini", SqlDbType.DateTime, obj.fechaIni));
arrPrm.Add(DBAccess.CreateParameter("@pdte_feordenpefin", SqlDbType.DateTime, obj.fechaFin));
arrPrm.Add(DBAccess.CreateParameter("@pestado", SqlDbType.Char, 1, obj.estado));
DataTable dt = db.ExecuteDatatable("VE_OrdenPedido_qry07_rpt", arrPrm);
return dt;
}
public DataTable GetOrdenPedido_rpt01(EOrdPedido op)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@pidEmpresa", SqlDbType.Char, 3, op.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@pidPeriodo", SqlDbType.Char, 4, op.IdPeriodo));
arrPrm.Add(DBAccess.CreateParameter("@pidreqsalida", SqlDbType.Char, 7, op.Idreqsalida));
DataTable dt = db.ExecuteDatatable("VE_OrdenPedido_rpt01", arrPrm);
return dt;
}
public DataTable GetFctura_rpt02(EParOCFillrpt fac)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@idPeriodo", SqlDbType.Char, 5, fac.IdAnio));
arrPrm.Add(DBAccess.CreateParameter("@idEmpresa", SqlDbType.Char, 3, fac.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@fechaini", SqlDbType.Char, 10, fac.fechaini ));
arrPrm.Add(DBAccess.CreateParameter("@fechafin", SqlDbType.Char, 10, fac.fechaFin));
arrPrm.Add(DBAccess.CreateParameter("@exportacion", SqlDbType.Char, 7, fac.nuExportacion));
arrPrm.Add(DBAccess.CreateParameter("@importacion", SqlDbType.Char, 7, fac.nuImportacion));
arrPrm.Add(DBAccess.CreateParameter("@nuFactura", SqlDbType.Char, 12, fac.nuFactura));
arrPrm.Add(DBAccess.CreateParameter("@idOrden", SqlDbType.Char, 10,fac.IdOrdenCompra));
DataTable dt = db.ExecuteDatatable("CO_Factura_rpt", arrPrm);
return dt;
}
//----------------------------------REPORTES---------------------------------------------------------------------------------------------------------------
public DataTable GetOrdenCompra_rpt01(EParOCFillrpt oc)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@idEmpresa", SqlDbType.Char, 3, oc.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@anio", SqlDbType.VarChar, 5, oc.IdAnio));
arrPrm.Add(DBAccess.CreateParameter("@mes", SqlDbType.VarChar, 16, oc.IdMesIni));
DataTable dt = db.ExecuteDatatable("CO_OrdenCompra_qry01_rpt", arrPrm);
return dt;
}
public DataTable GetFichaTejeduria_rpt01(ETejeduria tj)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
//arrPrm.Add(DBAccess.CreateParameter("@psintypesel", SqlDbType.Int, tj.psintypesel));
arrPrm.Add(DBAccess.CreateParameter("@pchr_idproduct", SqlDbType.Char, 12, tj.Id_producto));
arrPrm.Add(DBAccess.CreateParameter("@pchr_nucorreficha", SqlDbType.Char, 6, tj.Nu_correficha));
arrPrm.Add(DBAccess.CreateParameter("@pid_empresa", SqlDbType.Char, 3, tj.IdEmpresa));
DataTable dt = db.ExecuteDatatable("TJ_Fichatela_qry01", arrPrm);
return dt;
}
public DataTable GetMuestraEtiqueta_rpt02(ETejeduria tj)
{
DBAccess db = new DBAccess();
ArrayList arrPrm = new ArrayList();
arrPrm.Add(DBAccess.CreateParameter("@idEmpresa", SqlDbType.Char, 3, tj.IdEmpresa));
arrPrm.Add(DBAccess.CreateParameter("@id_producto", SqlDbType.Char, 12, tj.Id_producto));
arrPrm.Add(DBAccess.CreateParameter("@nu_correficha", SqlDbType.Char, 6, tj.Nu_correficha));
DataTable dt = db.ExecuteDatatable("TJ_TejeduriaCodBarr_qry02", arrPrm);
return dt;
}