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;
}
}
