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