protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string code = ""; string companyID = ""; if (Request.QueryString["code"] != null && Request.QueryString["code"] != "") { code = Request.QueryString["code"].ToString(); string str = Request.QueryString["req"].ToString(); string req = PwdHelper.DecodeDES(str, "bingoseller"); companyID = req.Split('&')[2].Split('=')[1]; string sql2 = "select * from asm_company where id=" + companyID; DataTable d1 = DbHelperSQL.Query(sql2).Tables[0]; if (d1.Rows.Count > 0) { appid = d1.Rows[0]["appId"].ToString(); appsecret = d1.Rows[0]["wx_appsecret"].ToString(); } OAuth_Token Model = Get_token(code, companyID); OAuthUser OAuthUser_Model = Get_UserInfo(Model.access_token, Model.openid); if (OAuthUser_Model.openid != null && OAuthUser_Model.openid != "") //已获取得openid及其他信息 { tupian = OAuthUser_Model.headimgurl.ToString(); //头像图片 name = OAuthUser_Model.nickname; //昵称 id = OAuthUser_Model.openid; //opendid string unionID = OAuthUser_Model.unionid; string country = OAuthUser_Model.country; string province = OAuthUser_Model.province; string city = OAuthUser_Model.city; OperUtil.setCooki("vshop_openID", id); string sql = "select * from asm_member where openID='" + id + "' and companyID=" + companyID; DataTable dt = DbHelperSQL.Query(sql).Tables[0]; if (dt.Rows.Count <= 0) { //添加会员 会员不一定必须绑定机器 只有会员有订购产品的时候才必须绑定机器 string sql1 = "INSERT INTO [dbo].[asm_member]" + " ([name],[phone],[QQ],[province],[city],[country],[addres],[AvailableMoney],[sumConsume],[sumRecharge],[createDate],[mechineID],[companyID],[age],[LastTime],[memberBH],[consumeCount],[openID],[brithday],[headurl],[nickname],unionID)" + " VALUES('" + name + "','','','" + province + "','" + city + "','','',0,0,0,'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','','" + companyID + "','0','','',0,'" + id + "','','" + tupian + "','" + name + "','" + unionID + "')"; DbHelperSQL.ExecuteSql(sql1); wxHelper wx = new wxHelper(companyID); string data = TemplateMessage.Member_ZC(id, OperUtil.getMessageID(companyID, "OPENTM203347141"), "恭喜您注册成为会员!", name, "恭喜您注册成为会员,您将享受到会员所有权利!"); TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(companyID), data); } else { string update = "update asm_member set unionID='" + unionID + "',name='" + name + "',nickname='" + name + "',headurl='" + tupian + "' where openID='" + id + "'"; Util.Debuglog("Update=" + update, "更新会员信息.txt"); } Response.Redirect("paypage.aspx?req=" + str); } } } }
public void login(HttpContext context) { string name = context.Request["name"].ToString(); string pwd = context.Request["pwd"].ToString(); string qx = context.Request["qx"].ToString(); if (qx == "1")//管理员 { string sql = "select * from [dbo].[asm_manager] where bh='" + name + "' and pwd='" + pwd + "'"; DataTable dt = DbHelperSQL.Query(sql).Tables[0]; if (dt.Rows.Count > 0) { OperUtil.Add("AdminOperaID", "0"); OperUtil.setCooki("operaName", name); System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder(); stringBuilder.Append("{"); stringBuilder.Append("\"result\":\"1\""); //完成 stringBuilder.Append("}"); context.Response.Write(stringBuilder.ToString()); } else { System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder(); stringBuilder.Append("{"); stringBuilder.Append("\"result\":\"2\""); //完成 stringBuilder.Append("}"); context.Response.Write(stringBuilder.ToString()); } } else if (qx == "2") { string sql = "select * from asm_opera where name='" + name + "' and pwd='" + pwd + "'"; DataTable dd = DbHelperSQL.Query(sql).Tables[0]; if (dd.Rows.Count > 0) { OperUtil.setCooki("operaName", name); OperUtil.Add("AdminOperaID", dd.Rows[0]["id"].ToString()); System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder(); stringBuilder.Append("{"); stringBuilder.Append("\"result\":\"1\""); //完成 stringBuilder.Append("}"); context.Response.Write(stringBuilder.ToString()); } else { System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder(); stringBuilder.Append("{"); stringBuilder.Append("\"result\":\"2\""); //完成 stringBuilder.Append("}"); context.Response.Write(stringBuilder.ToString()); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { string code = ""; if (Request.QueryString["code"] != null && Request.QueryString["code"] != "") { code = Request.QueryString["code"].ToString(); Util.Debuglog("code=" + code, "_获取会员信息.txt"); string companyID = Request.QueryString["companyID"].ToString(); string sql2 = "select * from asm_company where id=" + companyID; DataTable d1 = DbHelperSQL.Query(sql2).Tables[0]; if (d1.Rows.Count > 0) { appid = d1.Rows[0]["appId"].ToString(); appsecret = d1.Rows[0]["wx_appsecret"].ToString(); } OAuth_Token Model = Get_token(code, companyID); OAuthUser OAuthUser_Model = Get_UserInfo(Model.access_token, Model.openid); //OAuthUser OAuthUser_Model = Get_UserInfo(Model.access_token, Model.openid); if (OAuthUser_Model.openid != null && OAuthUser_Model.openid != "") //已获取得openid及其他信息 { tupian = OAuthUser_Model.headimgurl.ToString(); //头像图片 name = OAuthUser_Model.nickname; //昵称 id = OAuthUser_Model.openid; //opendid unionID = OAuthUser_Model.unionid; string country = OAuthUser_Model.country; string province = OAuthUser_Model.province; string city = OAuthUser_Model.city; Util.Debuglog("unionid=" + OAuthUser_Model.unionid, "_获取会员信息.txt"); OperUtil.setCooki("vshop_openID", id); string sql = "select * from asm_member where openID='" + id + "'or unionID='" + unionID + "' and companyID=" + companyID; DataTable dt = DbHelperSQL.Query(sql).Tables[0]; wxHelper wx = new wxHelper(companyID); wx.Get_UserInfo(id); if (dt.Rows.Count <= 0) { //name= System.Web.HttpUtility.UrlEncode(name, System.Text.Encoding.UTF8); //添加会员 会员不一定必须绑定机器 只有会员有订购产品的时候才必须绑定机器 string sql1 = "INSERT INTO [dbo].[asm_member]" + " ([name],[phone],[QQ],[province],[city],[country],[addres],[AvailableMoney],[sumConsume],[sumRecharge],[createDate],[mechineID],[companyID],[age],[LastTime],[memberBH],[consumeCount],[openID],[brithday],[headurl],[nickname],[pwd],[utfName],unionID)" + " VALUES(N'" + name + "','','','" + province + "','" + city + "','','',0,0,0,'" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','','" + companyID + "','0','','',0,'" + id + "','','" + tupian + "',N'" + name + "','000000','" + System.Web.HttpUtility.UrlEncode(name, System.Text.Encoding.UTF8) + "','" + unionID + "')"; DbHelperSQL.ExecuteSql(sql1); Util.Debuglog("sql1=" + sql1 + ";会员注册", "首页_.txt"); string data = TemplateMessage.Member_ZC(id, OperUtil.getMessageID(companyID, "OPENTM203347141"), "恭喜您注册成为会员!", name, "恭喜您注册成为会员,您将享受到会员所有权利!交易密码默认为000000,请前往会员中心修改"); TemplateMessage.SendTemplateMsg(wx.IsExistAccess_Token(companyID), data); //跳转领取红包判断系统是否开启 if (d1.Rows[0]["p4"].ToString() != "" && d1.Rows[0]["p4"].ToString() != null && d1.Rows[0]["p4"].ToString() != "0") { Response.Write("<script>top.location.href='accethb.aspx?companyID=" + companyID + "&openID=" + id + "';</script>"); } else { Response.Write("<script>top.location.href='homeIndex.aspx?companyID=" + companyID + "';</script>"); } } else { //更新会员信息 string sqlupdate = string.Format("update asm_member set name=N'{0}',headurl='{1}',utfName='{3}',unionID='" + unionID + "' where openID='{2}'", name, tupian, id, System.Web.HttpUtility.UrlEncode(name, System.Text.Encoding.UTF8)); DbHelperSQL.ExecuteSql(sqlupdate); Response.Write("<script>top.location.href='homeIndex.aspx?companyID=" + companyID + "';</script>"); } } } } }
protected void Page_Load(object sender, EventArgs e) { try { comid = Request.QueryString["companyID"].ToString(); //comid = "13"; OperUtil.setCooki("companyID", comid); this.companyID.Value = comid; Response.Cache.SetNoStore(); if (OperUtil.getCooki("vshop_openID") != "0") { string sql3 = "select * from asm_member where openID='" + OperUtil.getCooki("vshop_openID") + "' and companyID=" + companyID.Value; DataTable dd = DbHelperSQL.Query(sql3).Tables[0]; if (dd.Rows.Count <= 0) { Response.Redirect("WXCallback.aspx?companyID=" + this.companyID.Value); return; } else { string sql4 = "update asm_member set LastTime='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "' where id=" + dd.Rows[0]["id"].ToString(); DbHelperSQL.ExecuteSql(sql4); } //获取公众号的appid string sql = "select * from asm_company where id=" + comid; DataTable dt = DbHelperSQL.Query(sql).Tables[0]; if (dt.Rows.Count > 0 && !string.IsNullOrEmpty(dt.Rows[0]["appId"].ToString())) { this._jlc.Value = dt.Rows[0]["jlc"].ToString(); this.appID.Value = dt.Rows[0]["appId"].ToString(); app_id = dt.Rows[0]["appId"].ToString(); //app_id = OpenPFConfig.Appid; if (dt.Rows[0]["p8"].ToString() != "") { this._url1.Value = "1"; this.url1.Src = dt.Rows[0]["p8"].ToString(); } if (dt.Rows[0]["p9"].ToString() != "") { this._url2.Value = "1"; this.url2.Src = dt.Rows[0]["p9"].ToString(); } if (dt.Rows[0]["p10"].ToString() != "") { this._url3.Value = "1"; this.url3.Src = dt.Rows[0]["p10"].ToString(); } } this.memberID.Value = Util.getMemberID(); this._openID.Value = OperUtil.getCooki("vshop_openID"); } else { Response.Redirect("WXCallback.aspx?companyID=" + this.companyID.Value); } wxHelper wx = new wxHelper(comid); string[] str = wx.GetWXInfo(this.Request.Url.ToString(), comid).Split(','); //this.ur.Value = this.Request.Url.ToString(); //this.ticket.Value = wx.GetTicketPlat(comid); //this.te.Value = wx.IsExistAccess_Token(comid); time = str[0]; randstr = str[1]; signstr = str[2]; Util.Debuglog("time=" + time + ";randstr=" + randstr + ";signstr=" + signstr + ";url=" + this.Request.Url.ToString(), "微信参数.txt"); } catch { comid = OperUtil.getCooki("companyID"); this.companyID.Value = comid; Response.Cache.SetNoStore(); if (OperUtil.getCooki("vshop_openID") != "0") { string sql3 = "select * from asm_member where openID='" + OperUtil.getCooki("vshop_openID") + "' and companyID=" + companyID.Value; DataTable dd = DbHelperSQL.Query(sql3).Tables[0]; if (dd.Rows.Count <= 0) { Response.Redirect("WXCallback.aspx?companyID=" + this.companyID.Value); return; } //获取公众号的appid string sql = "select * from asm_company where id=" + OperUtil.getCooki("companyID"); DataTable dt = DbHelperSQL.Query(sql).Tables[0]; if (dt.Rows.Count > 0 && !string.IsNullOrEmpty(dt.Rows[0]["appId"].ToString())) { this.appID.Value = dt.Rows[0]["appId"].ToString(); app_id = dt.Rows[0]["appId"].ToString(); //p_id = OpenPFConfig.Appid; if (dt.Rows[0]["p8"].ToString() != "") { this._url1.Value = "1"; this.url1.Src = dt.Rows[0]["p8"].ToString(); } if (dt.Rows[0]["p9"].ToString() != "") { this._url2.Value = "1"; this.url2.Src = dt.Rows[0]["p9"].ToString(); } if (dt.Rows[0]["p10"].ToString() != "") { this._url3.Value = "1"; this.url3.Src = dt.Rows[0]["p10"].ToString(); } } this.memberID.Value = Util.getMemberID(); this._openID.Value = OperUtil.getCooki("vshop_openID"); } else { Response.Redirect("WXCallback.aspx?companyID=" + this.companyID.Value); } Response.Cache.SetNoStore(); wxHelper wx = new wxHelper(OperUtil.getCooki("companyID")); this.companyID.Value = OperUtil.getCooki("companyID");; string[] str = wx.GetWXInfo(this.Request.Url.ToString(), OperUtil.getCooki("companyID")).Split(','); //this.ur.Value = this.Request.Url.ToString(); //this.ticket.Value = wx.GetTicketPlat(OperUtil.getCooki("companyID")); //this.te.Value = wx.IsExistAccess_Token(OperUtil.getCooki("companyID")); time = str[0]; randstr = str[1]; signstr = str[2]; Util.Debuglog("2time=" + time + ";randstr=" + randstr + ";signstr=" + signstr + ";url=" + this.Request.Url.ToString(), "微信参数.txt"); } }