public List<CategoryEntityComplete> searchComplete(string searchitem) { List<CategoryEntityComplete> l = new List<CategoryEntityComplete>(); var list = (from a in db.ESHOP_NEWs join b in db.ESHOP_NEWS_CATs on a.NEWS_ID equals b.NEWS_ID where (db.fClearUnicode(a.NEWS_TITLE).Contains(ClearUnicode(searchitem))) &&a.NEWS_TYPE==1 select new { a.NEWS_TITLE, a.NEWS_PUBLISHDATE, b.ESHOP_CATEGORy.CAT_NAME }).Distinct().OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n=>n.CAT_NAME).Take(10); foreach (var i in list) { CategoryEntityComplete enti = new CategoryEntityComplete(); enti.catname = i.CAT_NAME; enti.title = i.NEWS_TITLE; l.Add(enti); } return l; }
public List<CategoryEntityComplete> searchComplete(string searchitem) { string[] arr = searchitem.Split(' '); List<CategoryEntityComplete> l = new List<CategoryEntityComplete>(); for (int s = 0; s < arr.Length; s++) { if (s == 0) { var list = (from a in db.ESHOP_NEWs join b in db.ESHOP_NEWS_CATs on a.NEWS_ID equals b.NEWS_ID where (SqlMethods.Like(a.NEWS_KEYWORD_ASCII, ClearUnicode("%" + arr[s] + "%"))) && a.NEWS_TYPE == 1 select new { a.NEWS_TITLE, a.NEWS_PUBLISHDATE, b.ESHOP_CATEGORy.CAT_NAME }).Distinct().OrderByDescending(n => n.NEWS_PUBLISHDATE).OrderByDescending(n => n.CAT_NAME); foreach (var i in list) { CategoryEntityComplete enti = new CategoryEntityComplete(); enti.catname = i.CAT_NAME; enti.title = i.NEWS_TITLE; l.Add(enti); } } else { var list = l.Where(n=>n.title.ToLower().Contains(arr[s].ToLower())).ToList(); if (list != null && list.Count > 0) l = list; } } return l; }