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; }