protected override Result GetDetailTable <T>(HttpContext context)
{
var lists = GetData <T>(context, true);
var list = lists.Count != 0 ? lists[0] : new List <T>();
DataTablesRequest param = new DataTablesRequest(context.Request);
JQueryDataTableData dt = new JQueryDataTableData();
dt.sEcho = param.sEcho;
dt.iTotalRecords = dt.iTotalDisplayRecords = list.Count;
dt.aaData = ObjectParseListFillDetailTable(list);
DateTime restime = Convert.ToDateTime(context.Request["begintime"]);
int period = Convert.ToInt32(context.Request["period"]);
if (1 == period)
{
dt.begintime = restime.ToString("yyyy-MM-dd");
dt.endtime = restime.ToString("yyyy-MM-dd");
}
if (3 == period)
{
dt.begintime = B_BaseToolService.GetWeekUpOfDate(restime, DayOfWeek.Monday, -1).ToString("yyyy-MM-dd");
dt.endtime = B_BaseToolService.GetWeekUpOfDate(restime, DayOfWeek.Sunday, 0).ToString("yyyy-MM-dd");
}
if (12 == period)
{
dt.begintime = restime.AddDays(-1 * (restime.Day) + 1).AddMonths(-1).ToString("yyyy-MM-dd");
dt.endtime = restime.AddDays(-1 * (restime.Day)).ToString("yyyy-MM-dd");
}
return(Result.GetSuccessedResult(dt, false));
}
protected override List <List <Dictionary <string, string> > > GetData(HttpContext context, bool flag = false)
{
DateTime restime = Convert.ToDateTime(context.Request["begintime"]);
DateTime comparebeforetime = restime.AddDays(-1);
int softs = Convert.ToInt32(context.Request["softs"]);
int platform = Convert.ToInt32(context.Request["plat"]);
int restype = Convert.ToInt32(context.Request["restype"]);
int period = Convert.ToInt32(context.Request["period"]);
int downtype = Convert.ToInt32(context.Request["downtype"]);
if (3 == period)
{
comparebeforetime = B_BaseToolService.GetWeekUpOfDate(restime, DayOfWeek.Sunday, -1);
restime = B_BaseToolService.GetWeekUpOfDate(restime, DayOfWeek.Sunday, 0);
}
if (12 == period)
{
comparebeforetime = restime.AddDays(-1 * (restime.Day)).AddMonths(-1);
restime = restime.AddDays(-1 * (restime.Day));
}
List <List <Dictionary <string, string> > > lists = new List <List <Dictionary <string, string> > >();
List <Dictionary <string, string> > result = D_StatDownRank_Service.Instance.GetD_StatDownRankBySoftByCacheMap(restype, softs, platform,
comparebeforetime, restime, period, downtype);
if (result.Count == 0)
{
return(new List <List <Dictionary <string, string> > >());
}
lists.Add(result);
return(lists);
}
protected override List <List <T> > GetData <T>(HttpContext context, bool flag = false)
{
DateTime restime = Convert.ToDateTime(context.Request["begintime"]);
DateTime comparebeforetime = restime.AddDays(-1);
int softs = Convert.ToInt32(context.Request["softs"]);
int platform = Convert.ToInt32(context.Request["plat"]);
int restype = Convert.ToInt32(context.Request["restype"]);
int period = Convert.ToInt32(context.Request["period"]);
if (3 == period)
{
comparebeforetime = B_BaseToolService.GetWeekUpOfDate(restime, DayOfWeek.Sunday, -1);
restime = B_BaseToolService.GetWeekUpOfDate(restime, DayOfWeek.Sunday, 0);
}
if (12 == period)
{
comparebeforetime = restime.AddDays(-1 * (restime.Day)).AddMonths(-1);
restime = restime.AddDays(-1 * (restime.Day));
}
List <List <D_StatDownCountsByResIDEntity> > lists = new List <List <D_StatDownCountsByResIDEntity> >();
var lstauthor = B_BaseToolService.Instance.GetAuthorEntityCache();
var result = D_StatDownRank_Service.Instance.GetD_StatDownCountRankByAuthorIDCache(period, restype, softs, platform,
comparebeforetime, restime);
var res = from item1 in result.AsEnumerable()
join item2 in lstauthor.AsEnumerable() on item1.AuthorID equals item2.AuthorID
select new D_StatDownCountsByResIDEntity()
{
StatDate = item1.StatDate,
ResID = item1.ResID,
AuthorID = item1.AuthorID,
AuthorName = item2.AuthorName,
DownCount = item1.DownCount,
ResCount = item1.ResCount,
Rank = item1.Rank,
LastRank = item1.LastRank
};
if (res.Count() != 0)
{
lists.Add(res.ToList <D_StatDownCountsByResIDEntity>());
}
return(lists as List <List <T> >);
}
protected override List <List <T> > GetData <T>(HttpContext context, bool flag = false)
{
DateTime restime = Convert.ToDateTime(context.Request["begintime"]);
DateTime comparebeforetime = restime.AddDays(-1);
int softs = Convert.ToInt32(context.Request["softs"]);
int platform = Convert.ToInt32(context.Request["plat"]);
int restype = Convert.ToInt32(context.Request["restype"]);
int period = Convert.ToInt32(context.Request["period"]);
int pcid = Convert.ToInt32(context.Request["pcid"]);
int cid = Convert.ToInt32(context.Request["cid"]);
int downtype = Convert.ToInt32(context.Request["downtype"]);
if (3 == period)
{
comparebeforetime = B_BaseToolService.GetWeekUpOfDate(restime, DayOfWeek.Sunday, -1);
restime = B_BaseToolService.GetWeekUpOfDate(restime, DayOfWeek.Sunday, 0);
}
if (12 == period)
{
comparebeforetime = restime.AddDays(-1 * (restime.Day)).AddMonths(-1);
restime = restime.AddDays(-1 * (restime.Day));
}
List <List <D_StatDownRank_SUM> > lists = new List <List <D_StatDownRank_SUM> >();
List <D_StatDownRank_SUM> resultbefore = D_StatDownRank_Service.Instance.GetD_StatDownRankByClassByCache(restype, softs, platform,
comparebeforetime, period, pcid, cid, downtype);
List <D_StatDownRank_SUM> resultrestime = D_StatDownRank_Service.Instance.GetD_StatDownRankByClassByCache(restype, softs, platform,
restime, period, pcid, cid, downtype);
var resulttemp = (from itrestime in resultrestime
join itbefore in resultbefore on itrestime.ResIdentifier equals itbefore.ResIdentifier into os
from t in os.DefaultIfEmpty()
select new D_StatDownRank_SUM
{
StatDate = itrestime.StatDate,
SoftID = itrestime.SoftID,
Platform = itrestime.Platform,
ResType = itrestime.ResType,
DownCount = itrestime.DownCount,
ResIdentifier = itrestime.ResIdentifier,
Rank = itrestime.Rank,
LastRank = t == null?"--":t.Rank.ToString()
}).OrderBy(p => p.Rank).ToList();
var reslst = resulttemp.Select(p => p.ResIdentifier).ToList();
int projectsourcetype = new B_BaseTool_DataAccess().GetProjectSourceTypeBySoftId2(softs);
List <B_ResInfo> lstresinfo = new B_BaseToolService().GetResInfo(restype, projectsourcetype, reslst);
var result = (from item in resulttemp
join itemresinfo in lstresinfo on item.ResIdentifier equals itemresinfo.ResIdentifier into os
from t in os.DefaultIfEmpty()
select new D_StatDownRank_SUM
{
StatDate = item.StatDate,
SoftID = item.SoftID,
Platform = item.Platform,
ResType = item.ResType,
ResIdentifier = item.ResIdentifier,
Rank = item.Rank,
DownCount = item.DownCount,
LastRank = item.LastRank,
ResName = t == null ? "" : t.ResName
}).ToList();
if (result.Count == 0)
{
return(new List <List <D_StatDownRank_SUM> >() as List <List <T> >);
}
lists.Add(result);
return(lists as List <List <T> >);
}