/// <summary> /// 校验 /// </summary> /// <param name="context"></param> public void ValidResource(HttpContext context) { HttpHelper hh = new HttpHelper(); T_CountToolResource dataAccess = new T_CountToolResource(); DataTable dt = dataAccess.GetResourceDetail(ConvertHelper.ToInt32(context.Request["resourceId"])); if (dt == null || dt.Rows.Count == 0) { context.Response.Write("资源不存在"); return; } string url = dt.Rows[0]["CTRUrl"].ToString(); string strResult = hh.HttpGet(url); int index = strResult.IndexOf("Scripts/DoStatistical.js?q="); if (index < 0) { context.Response.Write("校验失败,请确认代码是否已经加入"); return; } index += ("Scripts/DoStatistical.js?q=").Length; strResult = strResult.Substring(index, 20); strResult = strResult.Split('&')[0]; strResult = MXR.Utilities.Security.Cryptography.Decryption.MXR(strResult); if (ConvertHelper.ToInt32(strResult) == ConvertHelper.ToInt32(context.Request["resourceId"])) { dataAccess.SetValid(ConvertHelper.ToInt32(context.Request["resourceId"]), 1); context.Response.Write("1"); } else { context.Response.Write("校验失败,代码加入有误,请重新尝试加入"); } }
private void BindData() { int codeid = 0; if (txtBooklink.Text == "") { txtBookGuidLink.Value = ""; } if (txtBookGuidLink.Value == "") { codeid = 0; } else { codeid = Convert.ToInt32(txtBookGuidLink.Value); } string startDate = textTimeStart.Text; string endDate = textTimeEnd.Text; if (string.IsNullOrEmpty(startDate)) { startDate = DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd"); textTimeStart.Text = DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd"); } if (string.IsNullOrEmpty(endDate)) { endDate = DateTime.Now.ToString("yyyy-MM-dd"); textTimeEnd.Text = DateTime.Now.ToString("yyyy-MM-dd"); } T_CountToolResource dataAccess = new T_CountToolResource(); DataTable dt = dataAccess.GetAreaCoutTable(codeid, startDate, endDate); repData.DataSource = dt; repData.DataBind(); }
/// <summary> /// /// </summary> /// <param name="context"></param> public void UpdateNewName(HttpContext context) { string newName = context.Request["Name"].ToString(); int ID = ConvertHelper.ToInt32(context.Request["ID"]); T_CountToolResource DataAccess = new T_CountToolResource(); DataAccess.UpdateNewName(newName, ID); }
/// <summary> /// 获取所有的资源,用于制作下拉列表 /// </summary> /// <returns></returns> public void GetResourceValuePair(HttpContext context) { T_CountToolResource dataAccess = new T_CountToolResource(); DataTable dt = dataAccess.GetResourceValuePair(); string strResult = JsonConvert.SerializeObject(dt); context.Response.Write(strResult); }
/// <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="context"></param> public void GetResourceDetail(HttpContext context) { int resourceId = ConvertHelper.ToInt32(context.Request["resourceId"]); T_CountToolResource dataAccess = new T_CountToolResource(); DataTable dt = dataAccess.GetResourceDetail(resourceId); BaseResponse result = new BaseResponse(); result.recordCount = dt == null ? 0 : 1; result.list = dt; string strResult = JsonConvert.SerializeObject(result); context.Response.Write(strResult); }
/// <summary> /// 设置状态 /// </summary> /// <param name="context"></param> public void GetValidResult(HttpContext context) { int resourceId = ConvertHelper.ToInt32(context.Request["resourceId"]); T_CountToolResource dataAccess = new T_CountToolResource(); if (dataAccess.GetTestHistory(resourceId)) { context.Response.Write("1"); } else { context.Response.Write("0"); } }
protected void Page_Load(object sender, EventArgs e) { string url = HttpContext.Current.Request.Url.Query; string[] str = url.Split('='); int ID = ConvertHelper.ToInt32(str[1]); T_CountToolResource dataAccess = new T_CountToolResource(); DataTable dt = dataAccess.GetResourceDetail(ID); BaseResponse result = new BaseResponse(); result.recordCount = dt == null ? 0 : 1; result.list = dt; strCode = dt.Rows[0]["CTRCode"].ToString();//获取CODE }
/// <summary> /// 获取区域分布统计 /// </summary> /// <returns></returns> public void GetAreaCoutTable(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.GetAreaCoutTable(resourceId, startDate, endDate); BaseResponse result = new BaseResponse(); result.recordCount = dt == null ? 0 : dt.Rows.Count; result.list = dt; string strResult = JsonConvert.SerializeObject(result); context.Response.Write(strResult); }
/// <summary> /// 获取二维码列表(统计工具资源) /// </summary> /// <returns></returns> public void GetResourceData(HttpContext context) { int pageIndex = ConvertHelper.ToInt32(context.Request["pageIndex"]); int pageSize = ConvertHelper.ToInt32(context.Request["pageSize"]); int status = ConvertHelper.ToInt32(context.Request["status"]); string resourceName = context.Request["resourceName"]; int recordCount = 0; T_CountToolResource dataAccess = new T_CountToolResource(); DataTable dt = dataAccess.GetResourceData(pageIndex, pageSize, status, resourceName, ref recordCount); BaseResponse result = new BaseResponse(); result.recordCount = recordCount; result.list = dt; string strResult = JsonConvert.SerializeObject(result); context.Response.Write(strResult); }
///// <summary> ///// 创建新码 ///// </summary> ///// <param name="context"></param> //public void CreateResourceCode(HttpContext context) //{ // string newCode = "<script>window.onload = function() { var hm = document.createElement(\"script\"); hm.src = \"JavaScript.js?q=" + encryId + "&b=testButton\"; hm.id = \"tj\"; var s = document.getElementsByTagName(\"script\")[0]; s.parentNode.insertBefore(hm, s);}</script>"; // context.Response.Write(newCode); //} /// <summary> /// 校验统计工具资源 /// </summary> /// <returns></returns> public void GetValidUrl(HttpContext context) { int id = ConvertHelper.ToInt32(context.Request["resourceId"]); T_CountToolResource dataAccess = new T_CountToolResource(); DataTable dt = dataAccess.GetResourceDetail(id); if (dt == null) { return; } string strResult = $"<html><head><title>校验{dt.Rows[0]["CTRName"].ToString()}</title>{dt.Rows[0]["CTRCode"].ToString()} <script>setTimeout('window.close();', 10000);</script></head><body></body></html>"; string name = DateTime.Now.ToString("yyyyMMddHHmmssffff") + ".html"; string url = "/datafiles/countToolPage/" + name; string location = context.Server.MapPath("/datafiles/countToolPage/" + name); File.AppendAllText(strResult, location); context.Response.Write(url); }
private void BindData(int pageIndex) { int type = ConvertHelper.ToInt32(TypeChoose.Text); string name = Name.Text; if (pageIndex <= 0) { pageIndex = 1; } int recordCount = 0; T_CountToolResource dataAccess = new T_CountToolResource(); DataTable dt = dataAccess.GetResourceData(pageIndex, 10, type, name, ref recordCount); num.Value = recordCount.ToString(); AspNetPager1.CurrentPageIndex = pageIndex; AspNetPager1.RecordCount = recordCount; AspNetPager1.DataBind(); }
/// <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")); }
private void BindData(int pageIndex) { int codeid = 0; if (txtBookGuidLink.Value == "") { codeid = 0; } else { codeid = Convert.ToInt32(txtBookGuidLink.Value); } string startDate = textTimeStart.Text; string endDate = textTimeEnd.Text; if (pageIndex <= 0) { pageIndex = 1; } if (string.IsNullOrEmpty(startDate)) { startDate = DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd"); textTimeStart.Text = DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd"); } if (string.IsNullOrEmpty(endDate)) { endDate = DateTime.Now.ToString("yyyy-MM-dd"); textTimeEnd.Text = DateTime.Now.ToString("yyyy-MM-dd"); } int recordCount = 0; T_CountToolResource dataAccess = new T_CountToolResource(); DataTable dt = dataAccess.GetWayCountData(pageIndex, 10, startDate, endDate, codeid, ref recordCount); num.Value = recordCount.ToString(); repData.DataSource = dt; repData.DataBind(); AspNetPager1.CurrentPageIndex = pageIndex; AspNetPager1.RecordCount = recordCount; AspNetPager1.DataBind(); }
/// <summary> /// 新增资源(二维码) /// </summary> /// <returns></returns> public void AddResource(HttpContext context) { string name = context.Request["name"]; string weburl = context.Request["weburl"]; string code = context.Request["code"]; BasePage.BasePage bp = new BasePage.BasePage(); int userId = bp.userId; string userName = bp.userName; string errorMsg = string.Empty; T_CountToolResource dataAccess = new T_CountToolResource(); string strNewCode = string.Empty;//生成后的新代码 if (dataAccess.AddResource(name, weburl, code, userId, userName, ref strNewCode, ref errorMsg)) { context.Response.Write(strNewCode); } else { context.Response.Write("生成失败:" + errorMsg); } }