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));
}
private Result get_page(HttpContext context)
{
DataTablesRequest param = new DataTablesRequest(context.Request);
int region = Convert.ToInt32(context.Request["region"]);
int restype = Convert.ToInt32(context.Request["restype"]);
int projectsource = Convert.ToInt32(context.Request["projectsource"]);
string positionid = context.Request["position"];
string positionname = context.Request["positionname"];
string pagename = context.Request["pagename"];
string pagetype = context.Server.UrlDecode(context.Request["pagetype"]);
int downtype = Convert.ToInt32(context.Request["downtype"]);
int checkistag = Convert.ToInt32(context.Request["checkistag"]);
int pagesize = param.iDisplayLength;
int pageIndex = (param.iDisplayStart + 1) / param.iDisplayLength + 1;
int recordcount = 0;
B_BaseTool_DataAccess basetool = new B_BaseTool_DataAccess();
int softid2 = basetool.getSoftid2byProjectsource(projectsource, region);
var list = B_BaseDownPositionService.Instance.GetB_DownPositionListByCache((ProjectSourceTypeOptions)region, downtype, checkistag,
restype, projectsource, positionid,
positionname, pagename, pagetype, (pageIndex - 1) * pagesize,
pagesize, softid2, out recordcount);
JQueryDataTableData dt = new JQueryDataTableData();
dt.sEcho = param.sEcho;
dt.iTotalRecords = dt.iTotalDisplayRecords = recordcount;
dt.aaData = GetDataStrList(list);
return(Result.GetSuccessedResult(dt, false));
}
/// <summary>
/// 获取填充报表的数据
/// </summary>
/// <typeparam name="T">domain model</typeparam>
/// <param name="context">HttpContext</param>
/// <returns></returns>
protected virtual Result GetDetailTable(HttpContext context)
{
List <Dictionary <string, string> > list;
var lists = GetData(context, true);
list = lists.Count != 0 ? lists[0] : new List <Dictionary <string, string> >();
DataTablesRequest param = new DataTablesRequest(context.Request);
JQueryDataTableData dt = new JQueryDataTableData();
dt.sEcho = param.sEcho;
dt.iTotalRecords = dt.iTotalDisplayRecords = list.Count;
dt.aaData = ObjectParseListFillDetailTable(list);
return(Result.GetSuccessedResult(dt, false));
}
/// <summary>
/// 获取table中数据
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public Result GetPage(HttpContext context)
{
var x_DateTime = new List <DateTime>();
List <List <Sjqd_StatRetainedUsers> > lists = GetData(context, ref x_DateTime);
var dt = new JQueryDataTableData();
var param = new DataTablesRequest(context.Request);
dt.sEcho = param.sEcho;
dt.iTotalRecords = dt.iTotalDisplayRecords = lists.Count;
int period = Convert.ToInt32(context.Request["period"]);
dt.aaData = GetStringList(lists, period);
return(Result.GetSuccessedResult(dt, false));
}
private Result GetPage(HttpContext context)
{
var param = new DataTablesRequest(context.Request);
List <Sjqd_StatMAC2IMEI> list = GetData(context);
var dt = new JQueryDataTableData();
dt.sEcho = param.sEcho;
dt.iTotalRecords = dt.iTotalDisplayRecords = list.Count;
int pageIndex = (param.iDisplayStart + 1) / param.iDisplayLength + 1;
int pageSize = param.iDisplayLength;
List <Sjqd_StatMAC2IMEI> resultList = list; // list.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
dt.aaData = GetDataStrList(resultList);
return(Result.GetSuccessedResult(dt, true));
}
/// <summary>
/// 获取table中数据
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public Result GetPage(HttpContext context)
{
DataTable dtresult = GetTable(context);
var dt = new JQueryDataTableData();
var param = new DataTablesRequest(context.Request);
dt.sEcho = param.sEcho;
dt.iTotalRecords = dt.iTotalDisplayRecords = dtresult.Rows.Count;
int channelid = Convert.ToInt32(context.Request["channelid"]);
Sjqd_ChannelCustomers customer = SjqdChannelCustomers_DataAccess.Instance.GetChannelCustomer(channelid);
int showType = customer == null ? 0 : customer.ShowType;
dt.aaData = GetStringList(dtresult, showType);
return(Result.GetSuccessedResult(dt, false));
}
public Result GetList(HttpContext context)
{
Result result = null;
DataTablesRequest param = new DataTablesRequest(context.Request);
List <List <string> > data = new List <List <string> >();
try
{
List <LinkAdCount> list = GetData(context);
if (list != null && list.Count > 0)
{
foreach (LinkAdCount obj in list)
{
List <string> values = new List <string>();
values.Add(obj.PlanName);
values.Add(obj.UnionName);
values.Add(obj.Keyword);
values.Add(obj.MapMode);
values.Add(obj.LinkCount.ToString());
values.Add(obj.StatCount_15.ToString());
values.Add(obj.StatCount_New_15.ToString());
values.Add(string.Format("{0:P}", obj.StatCount_New_15 * 1.0 / obj.LinkCount));
values.Add(obj.StatCount_30.ToString());
values.Add(obj.StatCount_New_30.ToString());
values.Add(string.Format("{0:P}", obj.StatCount_New_30 * 1.0 / obj.LinkCount)); values.Add(obj.AdID.ToString());
values.Add(obj.AdID.ToString());
values.Add(obj.AdID.ToString());
values.Add(obj.AdID.ToString());
data.Add(values);
}
}
list.Clear();
}
catch (Exception ex)
{
LogHelper.WriteException("获取广告跳转数据失败：", ex);
}
finally
{
JQueryDataTableData dt = new JQueryDataTableData();
dt.sEcho = param.sEcho;
dt.iTotalRecords = dt.iTotalDisplayRecords = data.Count;
dt.aaData = data;
result = Result.GetSuccessedResult(dt, true);
}
return(result);
}
private Result GetLinkTagList(HttpContext context)
{
Result result = null;
DataTablesRequest param = new DataTablesRequest(context.Request);
List <List <string> > data = new List <List <string> >();
try
{
int softid = Convert.ToInt32(context.Request["softid"]);
int platform = Convert.ToInt32(context.Request["platform"]);
int cid = Convert.ToInt32(context.Request["cid"]);
List <LinkTagInfo> dataList = LinkTagLog_DataAccess.Instance.GetTagInfoList(softid, platform, cid);
if (dataList != null && dataList.Count > 0)
{
data = new List <List <string> >();
foreach (LinkTagInfo obj in dataList)
{
List <string> values = new List <string>();
values.Add(obj.LinkName);
values.Add(obj.LinkType.ToString());
values.Add(obj.LinkTag);
values.Add(obj.LinkUrl);
values.Add(obj.UpdateTime.ToString("yyyy-MM-dd HH:mm:ss"));
values.Add(obj.ChannelId.ToString());
values.Add(obj.ID.ToString());
data.Add(values);
}
dataList.Clear();
}
dataList = null;
}
catch (Exception ex)
{
LogHelper.WriteException("获取跳转链接列表失败：", ex);
}
finally
{
JQueryDataTableData dt = new JQueryDataTableData();
dt.sEcho = param.sEcho;
dt.iTotalRecords = dt.iTotalDisplayRecords = data.Count;
dt.aaData = data;
result = Result.GetSuccessedResult(dt, true);
}
return(result);
}
public Result GetList_Retained(HttpContext context)
{
Result result = null;
DataTablesRequest param = new DataTablesRequest(context.Request);
List <List <string> > data = new List <List <string> >();
try
{
List <LinkAdStatRetainedUsers> list = GetData_Retained(context);
if (list != null && list.Count > 0)
{
foreach (LinkAdStatRetainedUsers obj in list)
{
List <string> values = new List <string>();
values.Add(obj.OriginalDate.ToString("yyyy-MM-dd"));
values.Add(obj.NewUsers.ToString());
values.Add(obj.C_1.ToString());
values.Add(obj.C_2.ToString());
values.Add(obj.C_3.ToString());
values.Add(obj.C_4.ToString());
values.Add(obj.C_5.ToString());
values.Add(obj.C_6.ToString());
values.Add(obj.C_7.ToString());
data.Add(values);
}
}
list.Clear();
}
catch (Exception ex)
{
LogHelper.WriteException("获取广告跳转留存率失败：", ex);
}
finally
{
JQueryDataTableData dt = new JQueryDataTableData();
dt.sEcho = param.sEcho;
dt.iTotalRecords = dt.iTotalDisplayRecords = data.Count;
dt.aaData = data;
result = Result.GetSuccessedResult(dt, true);
}
return(result);
}
