/// <summary>
/// 活跃用户留存率数据EXCEL文件下载
/// </summary>
/// <param name="softId"></param>
/// <param name="platform"></param>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <param name="channelIds"></param>
/// <param name="channelTypes"></param>
/// <param name="channelTexts"></param>
private void GetStatRetainedActiveUsers(int softId, int platform, DateTime startDate, DateTime endDate, int[] channelIds, ChannelTypeOptions[] channelTypes, string[] channelTexts)
{
//权限验证
CheckHasRight(softId, "Reports/StatRetainedActiveUsers.aspx");
if (channelIds.Length == 1)
{
string fileName = string.Format("活跃用户留存率{0}.xls", channelIds[0] > 0 ? "(" + channelTexts[0] + ")" : string.Empty);
AddHead(fileName);
List <Sjqd_StatRetainedUsers> users = new StatUsersService().GetStatRetainedActiveUsers(softId, platform, channelIds[0], channelTypes[0], startDate, endDate);
ThisResponse.Write(TableTemplateHelper.BuildStatRetainedUsersTable((int)net91com.Stat.Core.PeriodOptions.Daily, users, true, string.Empty, true));
}
}
/// <summary>
/// 活跃用户留存率分地区数据EXCEL文件下载
/// </summary>
/// <param name="softId"></param>
/// <param name="platform"></param>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <param name="channelIds"></param>
/// <param name="channelTypes"></param>
/// <param name="channelTexts"></param>
private void GetStatRetainedActiveUsersByArea(int softId, int platform, DateTime startDate, DateTime endDate, int[] channelIds, ChannelTypeOptions[] channelTypes, string[] channelTexts)
{
//权限验证
CheckHasRight(softId, "Reports/StatRetainedActiveUsersByArea.aspx");
//地区ID
string[] areaIds = string.IsNullOrEmpty(ThisRequest["AreaIds"]) ? new string[0] : ThisRequest["AreaIds"].Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToArray();
string[] areaNames = string.IsNullOrEmpty(ThisRequest["AreaNames"]) ? new string[0] : ThisRequest["AreaNames"].Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToArray();
if (areaIds.Length == 1 && areaIds.Length == areaNames.Length && channelIds.Length == 1)
{
string fileName = string.Format("活跃用户留存率({0}{1}).xls", channelIds[0] > 0 ? channelTexts[0] + "-" : string.Empty, areaNames[0]);
AddHead(fileName);
List <Sjqd_StatRetainedUsers> users = new StatUsersService().GetStatRetainedActiveUsersByArea(softId, platform, areaIds[0], channelIds[0], channelTypes[0], startDate, endDate);
ThisResponse.Write(TableTemplateHelper.BuildStatRetainedUsersTable((int)net91com.Stat.Core.PeriodOptions.Daily, users, true, string.Empty, true));
}
}
/// <summary>
/// 新增用户留存率分版本数据EXCEL文件下载
/// </summary>
/// <param name="softId"></param>
/// <param name="platform"></param>
/// <param name="period"></param>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <param name="channelIds"></param>
/// <param name="channelTypes"></param>
/// <param name="channelTexts"></param>
private void GetStatRetainedUsersByVersion(int softId, int platform, int period, DateTime startDate, DateTime endDate, int[] channelIds, ChannelTypeOptions[] channelTypes, string[] channelTexts)
{
//权限验证
CheckHasRight(softId, "Reports/StatRetainedUsersByVersion.aspx");
//版本ID
string[] versionIds = string.IsNullOrEmpty(ThisRequest["VersionIds"]) ? new string[0] : ThisRequest["VersionIds"].Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToArray();
string[] versionNames = string.IsNullOrEmpty(ThisRequest["VersionNames"]) ? new string[0] : ThisRequest["VersionNames"].Split(new string[] { "," }, StringSplitOptions.RemoveEmptyEntries).ToArray();
if (versionIds.Length == 1 && versionIds.Length == versionNames.Length && channelIds.Length == 1)
{
string fileName = string.Format("新增用户留存率({0}{1}).xls", channelIds[0] > 0 ? channelTexts[0] + "-" : string.Empty, versionNames[0]);
AddHead(fileName);
List <Sjqd_StatRetainedUsers> users = new StatUsersService().GetStatRetainedUsersByVersion(softId, platform, versionIds[0], channelIds[0], channelTypes[0], period, startDate, endDate);
ThisResponse.Write(TableTemplateHelper.BuildStatRetainedUsersTable(period, users, true, string.Empty));
}
}
/// <summary>
/// 获取数据加上绑定数据
/// </summary>
protected void BindData()
{
int channelId = 0;
ChannelTypeOptions channelType = ChannelTypeOptions.Category;
if (HeadControl1.Channel1.ChannelValues.Count > 0)
{
channelId = HeadControl1.Channel1.ChannelValues[0].ChannelValue;
channelType = HeadControl1.Channel1.ChannelValues[0].ChannelType;
}
StatUsersService suService = new StatUsersService();
List <net91com.Reports.Entities.DataBaseEntity.Sjqd_StatRetainedUsers> users = suService.GetStatRetainedUsersByVersion(SoftID, PlatformID, HeadControl1.VersionID, channelId, channelType, (int)Period, BeginTime, EndTime);
ExcelDownUrl = string.Format("/Services/ExcelDownloader.ashx?Action=GetStatRetainedUsersByVersion&SoftID={0}&Platform={1}&Period={2}&StartDate={3:yyyy-MM-dd}&EndDate={4:yyyy-MM-dd}&VersionIds={5}&VersionNames={6}&ChannelIds={7}&ChannelTypes={8}&ChannelTexts={9}&v={10}", SoftID, PlatformID, (int)Period, BeginTime, EndTime, HeadControl1.VersionID, HeadControl1.VersionID, HeadControl1.Channel1.SelectedValue, HeadControl1.Channel1.SelectedCate, HttpUtility.UrlEncode(HeadControl1.Channel1.SelectedText), DateTime.Now.Ticks);
SeriesJsonStr = LineChartHelper.BuildStatRetainedUsersLine(users, Period, BeginTime, EndTime, out AxisJsonStr);
TablesHtml = TableTemplateHelper.BuildStatRetainedUsersTable((int)Period, users, false, string.Empty);
}
