public DataTable Listar()
{
try
{
BDAcces bd = new BDAcces();
DataSet dt = new DataSet();
dt = bd.ExecuteDataSet("GETTIPODOCUMENTO");
return dt.Tables[0];
}
catch (Exception)
{
throw;
}
}
public DataTable ListarEnvase()
{
try
{
BDAcces bd = new BDAcces();
DataSet dt = new DataSet();
dt = bd.ExecuteDataSet("GETENVASE");
return dt.Tables[0];
}
catch (Exception)
{
throw;
}
}
public DataTable ListarCategoria()
{
try
{
BDAcces bd = new BDAcces();
DataSet dt = new DataSet();
dt = bd.ExecuteDataSet("GETCATEGORIA");
return dt.Tables[0];
}
catch (Exception)
{
throw;
}
}
public static DataTable ListarTipopago()
{
try
{
BDAcces bd = new BDAcces();
DataSet dt = new DataSet();
dt = bd.ExecuteDataSet("GETTIPOPAGO");
return dt.Tables[0];
}
catch (Exception)
{
throw;
}
}
public DataTable ListarComprobantes()
{
try
{
BDAcces bd = new BDAcces();
DataSet dt = new DataSet();
dt = bd.ExecuteDataSet("GETCOMPROBANTE");
return dt.Tables[0];
}
catch (Exception)
{
throw;
}
}
public static DataTable ListarComprobantes2()
{
try
{
BDAcces bd = new BDAcces();
DataSet dt = new DataSet();
bd.AddParameter("@opcion", "QUERY02");
dt = bd.ExecuteDataSet("GETCOMPROBANTE");
return dt.Tables[0];
}
catch (Exception)
{
throw;
}
}
public DataTable ListarUnidadMedida()
{
try
{
BDAcces bd= new BDAcces();
DataSet dt = new DataSet();
dt = bd.ExecuteDataSet("GETMEDIDAD");
return dt.Tables[0];
}
catch (Exception)
{
throw;
}
}
public DataSet LiquidacionDiaria(DateTime pfecha)
{
try
{
DataSet dt = new DataSet();
BDAcces bd = new BDAcces();
bd.AddParameter("@fecha",Convert.ToDateTime( pfecha.ToShortDateString()));
dt = bd.ExecuteDataSet("LIQUIDACION_DIARIA");
return dt;
}
catch (Exception)
{
throw;
}
}
public DataSet Rpt_ClienteCredito()
{
try
{
DataSet dt = new DataSet();
BDAcces bd = new BDAcces();
dt = bd.ExecuteDataSet("RPT_CLIENTECREDITO");
return dt;
}
catch (Exception)
{
throw;
}
}
public DataSet Rpt_ClienteCreditoById(string codigo)
{
try
{
DataSet dt = new DataSet();
BDAcces bd = new BDAcces();
bd.AddParameter("@cod_cliente", codigo);
dt = bd.ExecuteDataSet("RPT_CLIENTECREDITOBYID");
return dt;
}
catch (Exception)
{
throw;
}
}
public DataSet ReportedeDevoluciones(DateTime fecha1,
DateTime fecha2,
string opcion)
{
try
{
DataSet dt = new DataSet();
BDAcces bd = new BDAcces();
bd.AddParameter("@opcion", opcion);
bd.AddParameter("@fecha1", Convert.ToDateTime(fecha1.ToShortDateString()));
bd.AddParameter("@fecha2", Convert.ToDateTime(fecha2.ToShortDateString()));
dt = bd.ExecuteDataSet("GETDEVOLUCIONES");
return dt;
}
catch (Exception)
{
throw;
}
}
public DataSet PrintGuiaId(int pidconrol)
{
try
{
BDAcces bd = new BDAcces();
bd.AddParameter("@IDCONTROL", pidconrol);
DataSet dt = new DataSet();
dt = bd.ExecuteDataSet("PRINTGUIABYID");
return dt;
}
catch (Exception)
{
throw;
}
}
public DataSet Reporte()
{
try
{
BDAcces bd = new BDAcces();
DataSet dt = new DataSet();
dt = bd.ExecuteDataSet("GETPERSONAL");
return dt;
}
catch (Exception)
{
throw;
}
}
public DataSet Reporte()
{
try
{
BDAcces bd = new BDAcces();
DataSet dt = new DataSet();
bd.AddParameter("@letra", ofiltro.Valor[0].ToString());
bd.AddParameter("@idtipo", (int)ofiltro.Valor[1]);
bd.AddParameter("@opcion", ofiltro.Valor[2].ToString());
dt = bd.ExecuteDataSet("GETCLIENTE");
return dt;
}
catch (Exception)
{
throw;
}
}
public DataTable ListarPersonalCombo()
{
try
{
BDAcces bd = new BDAcces();
DataSet dt = new DataSet();
bd.AddParameter("@opcion", "QUERY05");
dt = bd.ExecuteDataSet("GETPERSONAL");
return dt.Tables[0];
}
catch (Exception)
{
throw;
}
}
public static DataTable ListarHistorialPedido(int idcontrol)
{
try
{
DataSet dt = new DataSet();
BDAcces bd = new BDAcces();
bd.AddParameter("@idcontrol", idcontrol);
bd.AddParameter("@opcion", "QUERY01");
dt = bd.ExecuteDataSet("GETHISTORIAL_PEDIDO");
return dt.Tables[0];
}
catch (Exception)
{
throw;
}
}
public DataSet Rpt_VendedorCredito()
{
try
{
DataSet dt = new DataSet();
BDAcces bd = new BDAcces();
dt = bd.ExecuteDataSet("RPT_VENDEDORCREDITO");
return dt;
}
catch (Exception)
{
throw;
}
}
public DataSet Rpt_VendedorCreditoById(string codigo)
{
try
{
DataSet dt = new DataSet();
BDAcces bd = new BDAcces();
bd.AddParameter("@cod_vendedor", codigo);
dt = bd.ExecuteDataSet("RPT_VENDEDORCREDITOBYID");
return dt;
}
catch (Exception)
{
throw;
}
}
public DataTable ListarProductosCombo()
{
try
{
DataSet dt = new DataSet();
BDAcces bd = new BDAcces();
bd.AddParameter("@opcion", "QUERY04");
dt = bd.ExecuteDataSet("GETPRODUCTO");
return dt.Tables[0];
}
catch (Exception)
{
throw;
}
}
public DataSet ReporteGasto()
{
try
{
BDAcces bd = new BDAcces();
DataSet dt = new DataSet();
bd.AddParameter("@opcion", ofiltro.Valor[0].ToString());
bd.AddParameter("@anno", (int)ofiltro.Valor[1]);
bd.AddParameter("@mes", (int)ofiltro.Valor[2]);
bd.AddParameter("@fecha", Convert.ToDateTime(ofiltro.Valor[3]));
dt = bd.ExecuteDataSet("GETGASTO");
return dt;
}
catch (Exception)
{
throw;
}
}
public static DataTable ListarProveedor()
{
try
{
DataSet dt = new DataSet();
BDAcces bd = new BDAcces();
bd.AddParameter("@opcion", "QUERY02");
dt = bd.ExecuteDataSet("[GETPROVEEDOR]");
return dt.Tables[0];
}
catch (Exception)
{
throw;
}
}