public List <PairData> findTextScoreGreaterThen(double score) { SQLQueryExecutor executor = new SQLQueryExecutor(); SQLCommand command = new SQLCommand(); command.query = "SELECT * FROM TEXTS WHERE {SCORE > @score}"; command.parameters.Add("@score", score.ToString()); List <PairData> datas = executor.executeQuery(command); return(datas); }
public List <PairData> findTextWithWordContainsAndScoreLessEquals(string name, double score) { SQLQueryExecutor executor = new SQLQueryExecutor(); SQLCommand command = new SQLCommand(); command.query = "SELECT * FROM TEXTS WHERE CONTENT LIKE @content AND {SCORE <= @score}"; command.parameters.Add("@content", "%" + name + "%"); command.parameters.Add("@score", score.ToString()); List <PairData> datas = executor.executeQuery(command); return(datas); }
public List <PairData> findTextWithNameContainsAndScoreGreaterEquals(string name, double score) { SQLQueryExecutor executor = new SQLQueryExecutor(); SQLCommand command = new SQLCommand(); command.query = "SELECT * FROM TEXTS WHERE TITLE LIKE @title AND {SCORE >= @anotherscore}"; command.parameters.Add("@title", "%" + name + "%"); command.parameters.Add("@anotherscore", score.ToString()); List <PairData> datas = executor.executeQuery(command); return(datas); }