/// <summary>
/// 导出区域统计数据
/// </summary>
/// <returns></returns>
public void GetExportAreaData(HttpContext context)
{
int resourceId = ConvertHelper.ToInt32(context.Request["resourceId"]);
string startDate = context.Request["startDate"];
string endDate = context.Request["endDate"];
T_CountToolResource dataAccess = new T_CountToolResource();
DataTable dt = dataAccess.GetExportAreaData(resourceId, startDate, endDate);
BasePage.ExcelHelper helper = new BasePage.ExcelHelper();
helper.ExportDataGridToCSV(dt, "区域统计数据" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss"));
}
/// <summary>
/// 获取统计数据
/// </summary>
/// <param name="cusId">二维码ID</param>
/// <param name="bookName">图书名</param>
/// <param name="dateStart">开始时间</param>
/// <param name="dateEnd">结束时间</param>
/// <returns></returns>
public void GetExportData(HttpContext context)
{
int cusId = ConvertHelper.ToInt32(context.Request["cusId"]);
string bookName = context.Request["bookName"];
string dateStart = context.Request["dateStart"];
string dateEnd = context.Request["dateEnd"];
T_DownLoaded_Book_Data dataAccess = new T_DownLoaded_Book_Data();
DataTable dt = dataAccess.GetExportData(cusId, dateStart, dateEnd);
BasePage.ExcelHelper helper = new BasePage.ExcelHelper();
helper.ExportDataGridToCSV(dt, "二维码转化率统计" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss"));
}
/// <summary>
/// 渠道统计数据导出
/// </summary>
/// <param name="startDate"></param>
/// <param name="endDate"></param>
/// <param name="resourceId"></param>
/// <returns></returns>
public void GetWayCountExport(HttpContext context)
{
string startDate = context.Request["startDate"];
string endDate = context.Request["endDate"];
int resourceId = ConvertHelper.ToInt32(context.Request["resourceId"]);
T_CountToolResource dataAccess = new T_CountToolResource();
DataTable dt = dataAccess.GetWayCountExport(startDate, endDate, resourceId);
BaseResponse result = new BaseResponse();
result.recordCount = dt == null ? 0 : dt.Rows.Count;
result.list = dt;
string strResult = JsonConvert.SerializeObject(result);
context.Response.Write(strResult);
BasePage.ExcelHelper helper = new BasePage.ExcelHelper();
helper.ExportDataGridToCSV(dt, "渠道统计数据" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss"));
}
/// <summary>
/// 获取图书阅读统计导出信息
/// </summary>
/// <param name="context"></param>
public void GetBookReadExportCount(HttpContext context)
{
int pressId = ConvertHelper.ToInt32(context.Request["pressId"]); //出版社ID
int bookType = ConvertHelper.ToInt32(context.Request["bookType"]); //0图书，1系列
string bookGuid = context.Request["bookGuid"]; //图书GUID
DateTime timeStart = ConvertHelper.ToDateTime(context.Request["timeStart"]); //开始时间
DateTime timeEnd = ConvertHelper.ToDateTime(context.Request["timeEnd"]); //结束时间
BookCountAccess data = new BookCountAccess();
DataTable dt = data.GetBookReadCountData_Export(bookType, pressId, bookGuid, timeStart.ToShortDateString(), timeEnd.ToShortDateString(), new BasePage.BasePage().userId);
BasePage.ExcelHelper helper = new BasePage.ExcelHelper();
if (bookType == 0)
{
helper.ExportDataGridToCSV(dt, "图书阅读统计" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss"));
}
else
{
helper.ExportDataGridToCSV(dt, "系列阅读统计" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss"));
}
}
/// <summary>
/// 明细导出
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
public void GetBookReadCount_Detail(HttpContext context)
{
string bookGuid = context.Request["bookGuid"];
string startDate = context.Request["startDate"];
string endDate = context.Request["endDate"];
if (string.IsNullOrEmpty(startDate))
{
startDate = DateTime.Now.AddDays(-7).ToShortDateString();
}
if (string.IsNullOrEmpty(endDate))
{
endDate = DateTime.Now.ToShortDateString();
}
BookCountAccess data = new BookCountAccess();
DataTable dt = data.GetBookReadCount_Detail(bookGuid, startDate, endDate);
BasePage.ExcelHelper helper = new BasePage.ExcelHelper();
helper.ExportDataGridToCSV(dt, "图书热点明细统计" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss"));
}
/// <summary>
/// 获取图书下载统计的导出数据
/// </summary>
/// <returns></returns>
public void GetBookDownloadExportData(HttpContext context)
{
int pressId = ConvertHelper.ToInt32(context.Request["pressId"]);
string bookGuid = context.Request["bookGuid"];
string startDate = context.Request["startDate"];
string endDate = context.Request["endDate"];
if (string.IsNullOrEmpty(startDate))
{
startDate = DateTime.Now.AddDays(-7).ToShortDateString();
}
if (string.IsNullOrEmpty(endDate))
{
endDate = DateTime.Now.ToShortDateString();
}
BookCountAccess data = new BookCountAccess();
DataTable dt = data.GetBookDownloadExportData(pressId, bookGuid, startDate, endDate, new BasePage.BasePage().userId);
BasePage.ExcelHelper helper = new BasePage.ExcelHelper();
helper.ExportDataGridToCSV(dt, "图书下载统计明细" + DateTime.Now.ToString("yyyy-MM-dd-HH-mm-ss"));
}
