public List <string> GetMultiNames(ManagerCatagory catagory = ManagerCatagory.Majordomo) { try { using (var ctx = new BaseDBContext()) { var result = from manager in ctx.Managers where manager.Catagory == (int)catagory orderby manager.Account.Length descending, manager.Account descending select manager.Account; return(result.Take(20).ToList <string>()); } } catch (Exception ex) { throw ex; } }
public List <Manager> GetSubManagers(ManagerCatagory catagory, string searchStr) { try { try { using (var ctx = new BaseDBContext()) { var result = from manager in ctx.Managers where manager.Catagory == (int)catagory && manager.Account.Equals(searchStr) orderby manager.Account select new { Id = manager.Id, Account = manager.Account, Title = manager.Title, ResidualCredit = manager.ResidualCredit, EnterAllow = manager.EnterAllow, Remark = manager.Remark, RemarkText = manager.RemarkText, AmericanBaseball = manager.AmericanBaseball, JapaneseBaseball = manager.JapaneseBaseball, TaiwaneseBaseball = manager.TaiwaneseBaseball, KoreanBaseball = manager.KoreanBaseball, Hockey = manager.Hockey, Basketball = manager.Basketball, ColorBall = manager.ColorBall, AmericanFootball = manager.AmericanFootball, Tennis = manager.Tennis, Football = manager.Football, Other = manager.Other, MixParlay = manager.MixParlay, Gamer = manager.Gamer, ChildrenCount = ctx.Managers.Where(m => m.Catagory == (int)catagory + 1 && m.Majordomo.Equals(manager.Account)).Count() }; return(result.ToList().Select(m => new Manager() { Id = m.Id, Account = m.Account, Title = m.Title, ResidualCredit = m.ResidualCredit, EnterAllow = m.EnterAllow, Remark = m.Remark, RemarkText = m.RemarkText, AmericanBaseball = m.AmericanBaseball, JapaneseBaseball = m.JapaneseBaseball, TaiwaneseBaseball = m.TaiwaneseBaseball, KoreanBaseball = m.TaiwaneseBaseball, Hockey = m.Hockey, Basketball = m.Basketball, ColorBall = m.ColorBall, AmericanFootball = m.AmericanFootball, Tennis = m.Tennis, Football = m.Football, Other = m.Other, MixParlay = m.MixParlay, Gamer = m.Gamer, ChildrenCount = m.ChildrenCount }).ToList()); } } catch (Exception ex) { throw ex; } } catch (Exception ex) { throw ex; } }