/// <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")); }