public string ReturnQuickSort(string userName, string source) { var returnQFindSort = new ReturnQuickFindSort(_context); var resultLastSort = from sort in returnQFindSort.ReturnQuickSort(userName, source, true) where sort.LastUsedToday == 1 select sort.QuickSort_Query; // var lastSort = resultLastSort as string[] ?? resultLastSort.ToArray(); if (resultLastSort.Any()) { var sortReturn = string.Join(" ", resultLastSort); return(sortReturn); } else { var result = from sort in returnQFindSort.ReturnQuickSort(userName, source, true) where sort.LastUsed == true select sort.QuickSort_Query; var sortReturn = ""; if (result.Any()) { sortReturn = string.Join(" ", result); } return(sortReturn); } }
public string ReturnQueryString(string userName, string source) { var returnQFindSort = new ReturnQuickFindSort(_context); var qiuckFind = returnQFindSort.ReturnQuickFind(userName, source, true); var quickfindMcs = qiuckFind as QuickfindMC[] ?? qiuckFind.ToArray(); var query = (from find in quickfindMcs where find.LastUsedToday == 1 select find.QuickfindID); var quickFindId = -1; var enumerable = query as int[] ?? query.ToArray(); if (enumerable.Any()) { quickFindId = enumerable.FirstOrDefault(); } else { quickFindId = (from find in quickfindMcs where find.LastUsed == true select find.QuickfindID).FirstOrDefault(); } return(returnQFindSort.ReturnQuickFindQueryString(userName, source, true, quickFindId)); }
public IEnumerable<QuickSort> GetQuickSortName(string userName, string source, TdmsDbContext context) { var newItem = new ReturnQuickFindSort(context); return newItem.ReturnQuickSort(userName, source, true); }