/// <summary> /// 获取全部账号统计报告ISMP 使用 /// </summary> /// <param name="account"></param> /// <param name="beginTime"></param> /// <param name="endTime"></param> /// <returns></returns> public RPCResult <List <ReportStatistics> > GetStatisticsReportAll(DateTime beginTime, DateTime endTime) { DateTime cacheBeginTime = DateTime.MaxValue; if (DateTime.Compare(beginTime, endTime) > 0) { DateTime dt = beginTime; beginTime = endTime; endTime = dt; } if (DateTime.Compare(endTime, DateTime.Now) > 0) { endTime = DateTime.Now; } List <string> list = ReportStatisticsDB.GetTables(); var maxdate = list.Max(s => DateTime.Parse(s.Remove(0, 17).Insert(4, "-").Insert(7, "-"))); if (DateTime.Compare(endTime, maxdate) > 0) { endTime = maxdate; } var mindate = list.Min(s => DateTime.Parse(s.Remove(0, 17).Insert(4, "-").Insert(7, "-"))); if (DateTime.Compare(beginTime, mindate) < 0) { beginTime = mindate; } List <ReportStatistics> dbRS = ReportStatisticsDB.GetStatisticsByDate(beginTime, endTime); return(new RPCResult <List <ReportStatistics> >(true, dbRS, "")); }
public void GetStatisticsByDateTest() { var r = ReportStatisticsDB.GetStatisticsByDate(new DateTime(2016, 4, 28), DateTime.Now); Assert.IsTrue(r.Count > 0); }