public static DataTable Listar(LinestdLogica line) { DataTable datos = new DataTable(); try { datos = AccesoDatos.Consultar("SELECT linea,consec,turno,nombre as Hora,estandar as Meta FROM t_linestd where linea='" + line.Linea + "' and turno='" + line.Turno + "' order by nombre"); } catch (Exception ex) { throw ex; } return(datos); }
public static DataTable ConsultarTurno(LinestdLogica line) { DataTable datos = new DataTable(); try { datos = AccesoDatos.Consultar("SELECT * FROM t_linestd WHERE linea = '" + line.Linea + "' and turno= '" + line.Turno + "' ORDER BY consec"); } catch (Exception ex) { throw ex; } return(datos); }
public static bool Eliminar(LinestdLogica line) { try { string sQuery = "DELETE FROM t_linestd WHERE linea = '" + line.Linea + "' and consec=" + line.Consec + ""; if (AccesoDatos.Borrar(sQuery) != 0) { return(true); } else { return(false); } } catch { return(false); } }
public static bool Verificar(LinestdLogica line) { try { string sQuery; sQuery = "SELECT * FROM t_linestd WHERE linea = '" + line.Linea + "' and consec = " + line.Consec + ""; DataTable datos = AccesoDatos.Consultar(sQuery); if (datos.Rows.Count != 0) { return(true); } else { return(false); } } catch { return(false); } }
public static int Guardar(LinestdLogica line) { string[] parametros = { "@Linea", "@Consec", "@Turno", "@Nombre", "@Estandar" }; return(AccesoDatos.Actualizar("sp_mant_linestd", parametros, line.Linea, line.Consec, line.Turno, line.Nombre, line.Estandar)); }