public List <LoginStatisticItem> QueryUniqueLoginStatistic(QueryLoginStatisticCriteria criteria) { List <LoginStatisticItem> result = new List <LoginStatisticItem>(); var da = new StatisticDA(); //由于数据库的数据没有连续的数据进行呈现,所以在没有数据的点,应该初始化成0 List <LoginStatisticItem> items = da.QueryUniqueLoginStatistic(criteria); DateTime startDate = criteria.DateFrom.HasValue ? criteria.DateFrom.Value : DateTime.Now; DateTime endDate = GetEndDate(criteria.DateTo); int days = (endDate.Date - startDate.Date).Days; if (startDate > endDate) { days = -1; } for (int i = 0; i <= days; i++) { LoginStatisticItem findResult = items.SingleOrDefault(item => item.InDate.Date.Equals(endDate.AddDays(-i).Date)); if (findResult != null) { result.Add(findResult); } else { result.Add(new LoginStatisticItem { Count = 0, InDate = endDate.AddDays(-i) }); } } return(result); }
public void BatchInsertEventLog(List <EventLog> eventLogs) { if (eventLogs == null) { return; } var statisticDA = new StatisticDA(); foreach (var log in eventLogs) { InsertEventLog(log); } }
public List <UserPVStatisticItem> QueryUserPVStatistic(QueryUserPVStatisticCriteria criteria) { var da = new StatisticDA(); List <UserPVStatisticItem> list = da.QueryUserPVStatistic(criteria); if (list != null) { foreach (UserPVStatisticItem item in list) { UserInfo u = CPContext.GetUserInfoFromAD(item.UserId, CPContext.GetADDomain()); if (u != null && !string.IsNullOrWhiteSpace(u.FullName)) { item.UserId = string.Format("{0} - {1} ({2})", u.UserID, u.FullName, u.Department); } } } return(list); }
public void InsertEventLog(EventLog eventLog) { if (eventLog == null) { return; } var statisticDA = new StatisticDA(); try { statisticDA.InsertEventLog(eventLog); } catch (Exception ex) { ExceptionHelper.HandleException(ex); } }
public List <PVStatisticItem> QueryPVStatistic(QueryPVStatisticCriteria criteria) { var da = new StatisticDA(); return(da.QueryPVStatistic(criteria)); }
public void TraceEventLog(EventLog eventLog) { var da = new StatisticDA(); da.InsertEventLog(eventLog); }