internal static IEnumerable<SalesmanScoreViewModel> ToList(WXStudio.EFModel.Entities.WXPstudioDbContext db)
{
List<SalesmanScoreViewModel> models = new List<SalesmanScoreViewModel>();
try
{
ILookup<int, Salesman> lookup = db.Salesmans.ToLookup(p => p.SalesmanId);
ILookup<int, SaleBook> lookup2 = db.SaleBooks.ToLookup(p => p.SaleBookId);
try
{
foreach (var one in db.SalesmanScores)
{
SalesmanScoreViewModel re = new SalesmanScoreViewModel() { SalesmanScore = one };
if (lookup.Contains(re.SalesmanScore.SalesmanId) && lookup[re.SalesmanScore.SalesmanId] != null
&& lookup[re.SalesmanScore.SalesmanId].Count() > 0)
{
var first = lookup[re.SalesmanId].First();
re.SalesmanName = first.Name;
re.SalesmanPhone = first.Phone;
}
if (lookup2.Contains(re.SalesmanScore.SaleBookId) && lookup2[re.SalesmanScore.SaleBookId] != null
&& lookup2[re.SalesmanScore.SaleBookId].Count() > 0)
{
var first = lookup2[re.SalesmanScore.SaleBookId].First();
re.ClientName = first.Name;
re.ClientPhone = first.Phone;
}
if (re.SalesmanScore.CreateDate != null)
{
re.CreateDate = re.SalesmanScore.CreateDate.Value;
}
models.Add(re);
}
}
catch (Exception ex2)
{
LogHelper.Error("SalesmanScoreViewModel.ToList EX2 出错：" + ex2.StackTrace, ex2);
}
}
catch (Exception e)
{
LogHelper.Error("SalesmanScoreViewModel.ToList出错：" + e.StackTrace, e);
}
return models;
}
private async Task SignInAsync(WXStudio.EFModel.Entities.Core.CoreAccount //>ApplicationUser
user, bool isPersistent)
{
AuthenticationManager.SignOut(DefaultAuthenticationTypes.ExternalCookie);
AuthenticationManager.SignIn(new AuthenticationProperties() { IsPersistent = isPersistent }, await user.GenerateUserIdentityAsync(UserManager));
}
