public static DataTable ConsultaArticulo(InnovaLogica rec)
{
DataTable datos = new DataTable();
try
{
string sQuery = "SELECT * FROM articulo WHERE no_art = '" + rec.Articulo + "' ";
datos = AccesoDatos.ConsultarInnova(sQuery);
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}
public static DataTable ConsultaOrden(InnovaLogica rec)
{
DataTable datos = new DataTable();
try
{
string sQuery = "SELECT rq.no_art,rq.desc_art,rc.cantidad,rq.um " +
"FROM recibo_mov rc INNER JOIN req_mov rq on rc.csc_mov = rq.csc_mov and rc.no_req = rq.no_req WHERE rc.orden = '" + rec.Orden + "' ";
datos = AccesoDatos.ConsultarInnova(sQuery);
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}
public static DataTable ConsultaReciboMov(InnovaLogica rec)
{
DataTable datos = new DataTable();
try
{
string sQuery = "SELECT re.fecha,re.no_recibo,re.orden,rq.no_art,rq.desc_art,rc.cantidad,rq.um,rc.almacen,re.recibio " +
"FROM recibo_mov rc INNER JOIN recibo re on rc.no_recibo = re.no_recibo " +
"INNER JOIN req_mov rq on rc.csc_mov = rq.csc_mov and rc.no_req = rq.no_req " +
"WHERE re.no_recibo = '" + rec.Recibo + "' and rc.csc_mov = " + rec.Consec + "";
datos = AccesoDatos.ConsultarInnova(sQuery);
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}