public async Task <List <UserEnterReport> > GetAsync(DateTime startTime, DateTime endTime, int UserID) { List <UserEnterReport> list = new List <UserEnterReport>(); try { await Task.Run(() => { DataContext dataContext = new DataContext(); var query = dataContext.EnterCustPhaseLogs.Where(x => x.CreateTime > startTime && x.CreateTime < endTime); if (UserID > 0) { query = query.Where(x => x.UserID == UserID); } var report = from q in query.ToList() group q by q.UserID into g select new { UserID = g.Key, Total = g.Count() }; if (report != null) { foreach (var r in report) { UserEnterReport uer = new UserEnterReport(); uer.Total = r.Total; uer.UserID = r.UserID; list.Add(uer); } } }); } catch (Exception ex) { ClassLoger.Error("EnterCustPhaseLogDal.GetAsync", ex); } return(list); }
public async Task <List <UserEnterReport> > GetAsync(DateTime startTime, DateTime endTime, int userid) { List <UserEnterReport> list = new List <UserEnterReport>(); try { await Task.Run(() => { DataContext dataContext = new DataContext(); var query = dataContext.SalesProjects.Where(x => x.ProjectTime > startTime && x.ProjectTime < endTime); if (userid > 0) { query = query.Where(x => x.HeadID == userid); } var report = from q in query.ToList() group q by q.HeadID into g select new { UserID = g.Key, Total = g.Count() }; if (report != null) { foreach (var r in report) { UserEnterReport userEnterReport = new UserEnterReport(); userEnterReport.UserID = r.UserID; userEnterReport.Total = r.Total; list.Add(userEnterReport); } } }); } catch (Exception ex) { ClassLoger.Error("SalesProjectDal.GetAsync", ex); } return(list); }
/// <summary> /// 统计用户录入客户数量 /// </summary> /// <param name="startTime"></param> /// <param name="endTime"></param> /// <param name="userid"></param> /// <returns></returns> public async Task <List <UserEnterReport> > GetAsync(DateTime startTime, DateTime endTime, int userid) { try { List <UserEnterReport> list = new List <UserEnterReport>(); await Task.Run(() => { DataContext dataContext = new DataContext(); var query = dataContext.EnterCustomers.Where(x => x.CreateTime > startTime && x.CreateTime < endTime); if (userid > 0) { query = query.Where(x => x.UserID == userid); } var report = from en in query.ToList() group en by en.UserID into g select new { UserID = g.Key, Total = g.Count() }; if (report != null) { foreach (var r in report) { UserEnterReport enterReport = new UserEnterReport(); enterReport.Total = r.Total; enterReport.UserID = r.UserID; list.Add(enterReport); } } }); return(list); } catch (Exception ex) { ClassLoger.Error("EnterCustomerDal.GetAsync", ex); } return(null); }