public int InsertPVData(PVData pv)
{
string sql = @"insert into pv_data_collect(DOMAIN,URL,TITLE,REFERRER,SH,SW,CD,ACCOUNT,LTIME,OPENID)
values(@DOMAIN,@URL,@TITLE,@REFERRER,@SH,@SW,@CD,@ACCOUNT,@LTIME,@OPENID)";
return(base.Excute(sql, new {
DOMAIN = pv.DOMAIN,
URL = pv.URL,
TITLE = pv.TITLE,
REFERRER = pv.REFERRER,
SH = pv.SH,
SW = pv.SW,
CD = pv.CD,
ACCOUNT = pv.ACCOUNT,
LTIME = pv.LTIME,
OPENID = pv.openid
}));
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
var requestPath = context.Request.PathInfo.Replace("/", "");
var RequestParams = GetRequestStringList(context.Request);
var result = "";
string openid = System.Web.HttpContext.Current.Session["FromUserName"] == null ? "" : System.Web.HttpContext.Current.Session["FromUserName"].ToString();
HttpCookie cookie = context.Request.Cookies["XYH_COUPON"];
if (openid == "" && cookie != null && !string.IsNullOrWhiteSpace(cookie["FromUserName"]))
{
openid = cookie["FromUserName"].ToString();
}
// openid = "oDRuD1DSi1yyDx9x4_Ttpf_0haB0";
if (string.IsNullOrWhiteSpace(openid) &&
requestPath != "HXCoupon" &&
requestPath != "GetCardDetail") //核销不需要openid
{
response.Status = -5;
response.Message = "重新授权";
result = JsonHelper.ToJSON(response);
context.Response.Write(result);
return;
}
DateTime StartDate = string.IsNullOrWhiteSpace(AppConfig.ActivityStartDate) ? DateTime.MinValue : DateTime.Parse(AppConfig.ActivityStartDate);
DateTime EndDate = string.IsNullOrWhiteSpace(AppConfig.ActivityEndDate) ? DateTime.MaxValue : DateTime.Parse(AppConfig.ActivityEndDate);
//活动结束只能领券，核销，分享
if (EndDate < DateTime.Now)
{
response.Status = -6;
response.Message = "活动已结束";
result = JsonHelper.ToJSON(response);
context.Response.Write(result);
return;
}
switch (requestPath)
{
case "AddPVData":
//WriteTxt("新增pv数据-开始" + openid);
try
{
PVData pv = new PVData();
pv.DOMAIN = context.Request.Params[1];
pv.URL = "商业集团领券活动";
pv.TITLE = context.Request.Params[3];
pv.REFERRER = context.Request.Params[4];
pv.SH = context.Request.Params[5];
pv.SW = context.Request.Params[6];
pv.CD = context.Request.Params[7];
pv.ACCOUNT = context.Request.Params[9];
pv.LTIME = context.Request.Params[10];
pv.openid = openid;
mss.InsertPVData(pv);
//WriteTxt("新增pv数据-结束" + openid);
}
catch (Exception ex) { WriteTxt("新增pv数据-异常" + ex.Message); }
result = "";
break;
case "GetCardDetail": result = GetCardDetail(RequestParams["code"], RequestParams["card_id"]); break;
case "HXCoupon": result = HXCoupon(RequestParams["code"], RequestParams["card_id"]); break;
case "SendMsg": result = SendMsg(RequestParams["mobile"]); break;
case "IsMember": result = IsMember(RequestParams["mobile"], openid); break;
case "WXShare": result = WXShare(openid, int.Parse(RequestParams["type"])); break;
case "VerificaMobile": result = VerificaMobile(RequestParams["mobile"]); break;
case "VerificaOpenId": result = VerificaOpenId(openid); break;
case "LQCoupon": result = LQCoupon(openid); break;
}
context.Response.Write(result);
}
public void ProcessRequest(HttpContext context)
{
if (GetQeuryString("para", context) == "jsapi") //获取js接口凭证
{
try
{
//string token = w.Token();//w.mjuserid
string resmsg = NetHelper.HttpRequest(AppConfig.TokenUrl, "", "GET", 2000,
Encoding.UTF8, "application/json");
TokeRes toke = JsonHelper.DeserializeObject <TokeRes>(resmsg);
string token = toke.Access_Token;
string sj = ConvertDateTimeInt(DateTime.Now).ToString(); //时间戳
string sjm = Guid.NewGuid().ToString("d"); //随机码
string jsapimsg = NetHelper.HttpRequest(AppConfig.JsApiTokenUrl, "", "GET", 2000,
Encoding.UTF8, "application/json");
JsApiTicket jat = JsonHelper.DeserializeObject <JsApiTicket>(jsapimsg);
string ticket = jat.JsApi; // GetJSAPI_Ticket(token, m); //凭证
//WriteTxt("js注册：apiurl=" + context.Request.Params["apiurl"]);
string dz = context.Server.UrlDecode(context.Request.Params["apiurl"]); //context.Request.Params["apiurl"];//
string noncestr = "noncestr=" + sjm;
string jsapi_ticket = "jsapi_ticket=" + ticket;
string timestamp = "timestamp=" + sj;
string url = "url=" + dz;
//WriteTxt("js注册：url="+ dz);
string[] ArrTmp = { noncestr, jsapi_ticket, timestamp, url };
Array.Sort(ArrTmp); //字典排序
string tmpStr = string.Join("&", ArrTmp);
//WriteTxt("js注册：tmpStr=" + tmpStr);
tmpStr = FormsAuthentication.HashPasswordForStoringInConfigFile(tmpStr, "SHA1");
tmpStr = tmpStr.ToLower();
if (ticket == "")
{
//WriteTxt("js注册：失败" );
context.Response.Write("{\"status\":\"" + -1 + "\"}");
}
else
{
var re = new
{
state = 0,
appId = AppConfig.WXAppId,
timestamp = sj,
nonceStr = sjm,
signature = tmpStr,
url = dz,
link = (dz.IndexOf("&") == -1 ? dz : dz.Substring(0, dz.IndexOf("&"))),
title = "",
imgUrl = ConfigurationSettings.AppSettings["WebUrl"] + "/wechat/XYH_Coupon_H5/images/logo.jpg",
desc = ""
};
string ret = JsonConvert.SerializeObject(re);
//WriteTxt("js注册：" + ret);
context.Response.Write(ret);
}
}
catch (Exception ex)
{
context.Response.Write(ex.Message + "," + ex.StackTrace);
}
}
else if (GetQeuryString("para", context) == "upimg") //上传图片
{
}
else if (GetQeuryString("para", context) == "delete") //上传图片
{
}
else if (GetQeuryString("para", context) == "pv")
{
try
{
PVData pv = new PVData();
pv.DOMAIN = context.Request.Params[1];
pv.URL = context.Request.Params[2];
pv.TITLE = context.Request.Params[3];
pv.REFERRER = context.Request.Params[4];
pv.SH = context.Request.Params[5];
pv.SW = context.Request.Params[6];
pv.CD = context.Request.Params[7];
pv.ACCOUNT = context.Request.Params[9];
pv.LTIME = context.Request.Params[10];
mss.InsertPVData(pv);
}
catch { }
}
}
public int InsertPVData(PVData pv)
{
return(_set.InsertPVData(pv));
}
