private void BindData(int pageIndex)
{
string bookName = txtBooklink.Text;
if (bookName == "全部")
{
bookName = "";
}
string timestart = textTimeStart.Text;
string timeend = textTimeEnd.Text;
if (string.IsNullOrEmpty(timestart))
{
timestart = DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd");
textTimeStart.Text = DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd");
}
if (string.IsNullOrEmpty(timeend))
{
timeend = DateTime.Now.ToString("yyyy-MM-dd");
textTimeEnd.Text = DateTime.Now.ToString("yyyy-MM-dd");
}
if (pageIndex <= 0)
{
pageIndex = 1;
}
int recordCount = 0;
T_DownLoaded_Book_Data dataAccess = new T_DownLoaded_Book_Data();
DataTable dtResult = dataAccess.GetCountData(pageIndex, 10, bookName, timestart, timeend, ref recordCount);
num.Value = recordCount.ToString();
AspNetPager1.CurrentPageIndex = pageIndex;
AspNetPager1.RecordCount = recordCount;
AspNetPager1.DataBind();
}
/// <summary>
/// 获取图书列表（仅含制作成二维码的图书）
/// </summary>
/// <returns></returns>
private void GetBookList(HttpContext context)
{
T_DownLoaded_Book_Data dataAccess = new T_DownLoaded_Book_Data();
DataTable dtAccess = dataAccess.GetBookList();
string strJson = JsonConvert.SerializeObject(dtAccess);
context.Response.Write(strJson);
}
/// <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="pageIndex"></param>
/// <param name="pageSize"></param>
/// <param name="bookName">图书名称</param>
/// <param name="dateStart">统计开始时间</param>
/// <param name="dateEnd">统计结束时间</param>
/// <returns></returns>
public void GetCountData(HttpContext context)
{
int pageIndex = ConvertHelper.ToInt32(context.Request["pageIndex"]);
int pageSize = ConvertHelper.ToInt32(context.Request["pageSize"]);
string bookName = context.Request["bookName"];
string dateStart = context.Request["dateStart"];
string dateEnd = context.Request["dateEnd"];
int recordCount = 0;
T_DownLoaded_Book_Data dataAccess = new T_DownLoaded_Book_Data();
DataTable dtResult = dataAccess.GetCountData(pageIndex, pageSize, bookName, dateStart, dateEnd, ref recordCount);
BaseResponse result = new BaseResponse();
result.recordCount = recordCount;
result.list = dtResult;
string strJson = JsonConvert.SerializeObject(dtResult);
context.Response.Write(strJson);
}
