public List <Beatmap> SearchBeatmapByOptions(string searchText, BeatmapSortMode sortMode, int startIndex,
int count)
{
try
{
return(_dbOperator.SearchBeatmapByOptions(searchText, sortMode, startIndex, count));
}
catch (Exception ex)
{
Notification.Push($"Error while searching for beatmaps: {ex.Message}");
return(new List <Beatmap>());
}
}
public BeatmapInfoItemUIComparer(BeatmapSortMode mode)
{
Mode = mode;
}
public static List <Beatmap> SearchBeatmapByOptions(this AppDbOperator op, string searchText, BeatmapSortMode beatmapSortMode, int startIndex, int count)
{
var expando = new DynamicParameters();
var command = " SELECT * FROM beatmap WHERE ";
var keywordSql = GetKeywordQueryAndArgs(searchText, ref expando);
var sort = GetOrderAndTakeQueryAndArgs(beatmapSortMode, startIndex, count);
var sw = Stopwatch.StartNew();
try
{
return(op.ThreadedProvider.GetDbConnection().Query <Beatmap>(command + keywordSql + sort, expando)
.ToList());
}
catch (Exception ex)
{
Logger.Error(ex, "Error while calling SearchBeatmapByOptions().");
throw;
}
finally
{
Logger.Debug("查询花费: {0}", sw.ElapsedMilliseconds);
sw.Stop();
}
}
