public static DataTable ConsultarFolio(LineaDownLogica line)
{
DataTable datos = new DataTable();
try
{
datos = AccesoDatos.Consultar("SELECT * FROM t_linedown WHERE folio = " + line.Folio + "");
}
catch (Exception ex)
{
throw ex;
}
return(datos);
}
public static int Eliminar(LineaDownLogica line)
{
int iRes = 0;
try
{
iRes = AccesoDatos.Borrar("DELETE FROM t_linedown WHERE folio = " + line.Folio + "");
}
catch (Exception ex)
{
throw ex;
}
return(iRes);
}
public static int GuardarSP(LineaDownLogica line)
{
string[] parametros = { "@Folio", "@Fecha", "@Turno", "@Linea", "@Hora", "@Duracion", "@Motivo", "@Notas" };
return(AccesoDatos.Actualizar("sp_mant_linedown", parametros, line.Folio, line.Fecha, line.Turno, line.Linea, line.Hora, line.Duracion, line.Motivo, line.Notas));
}