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