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