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