public static DataTable ConsultarEstacion(AreaLogica area) { DataTable datos = new DataTable(); try { datos = AccesoDatos.Consultar("SELECT * FROM t_areas WHERE estacion = '" + area.Estacion + "'"); } catch (Exception ex) { throw ex; } return(datos); }
public static DataTable ListarPlanta(AreaLogica area) { DataTable datos = new DataTable(); try { datos = AccesoDatos.Consultar("SELECT * FROM t_areas where planta = '" + area.Planta + "' order by area"); } catch (Exception ex) { throw ex; } return(datos); }
public static bool Eliminar(AreaLogica area) { try { string sQuery = "DELETE FROM t_areas WHERE area = '" + area.Area + "'"; if (AccesoDatos.Borrar(sQuery) != 0) { return(true); } else { return(false); } } catch { return(false); } }
public static bool VerificarEstacion(AreaLogica area) { try { string sQuery; sQuery = "SELECT * FROM t_areas WHERE estacion = '" + area.Estacion + "'"; DataTable datos = AccesoDatos.Consultar(sQuery); if (datos.Rows.Count != 0) { return(true); } else { return(false); } } catch { return(false); } }
public static int Guardar(AreaLogica area) { string[] parametros = { "@Area", "@Planta", "@Estacion", "@Global" }; return(AccesoDatos.Actualizar("sp_mant_areas", parametros, area.Area, area.Planta, area.Estacion, area.Global)); }