Exemplo n.º 1
0
    public static string getwxCode(string code, string httpUrl)
    {
        string result   = "123";
        string xtopenid = "";

        Cms.BLL.wx_info info      = new Cms.BLL.wx_info();
        string          appid     = info.GetModel(1).AppId;
        string          appsecret = info.GetModel(1).AppSecret;

        if (code != null && code != "")
        {
            string Code = code;
            string Str  = GetJson("https://api.weixin.qq.com/sns/oauth2/access_token?appid=" + appid + "&secret=" + appsecret + "&code=" + Code + "&grant_type=authorization_code");
            //微信回传的数据为Json格式,将Json格式转化成对象
            OAuth_Token Model = wxuser.JSONToObject <OAuth_Token>(Str);

            xtopenid = Model._openid;
            result   = Model._openid + code;

            Cms.BLL.wx_info       wxinfo     = new Cms.BLL.wx_info();
            Cms.Model.wx_info     Model_info = new Cms.Model.wx_info();
            Cms.BLL.wx_userinfo   userinfo   = new Cms.BLL.wx_userinfo();
            Cms.Model.wx_userinfo muserinfo  = new Cms.Model.wx_userinfo();
            Model_info = wxinfo.GetModel(1);
            string str    = "";
            string openid = Model._openid;
            str       = setinfo("https://api.weixin.qq.com/cgi-bin/user/info?access_token=" + Model.access_token + "&openid=" + openid, "", openid);
            muserinfo = JSONToObject <Cms.Model.wx_userinfo>(str);
            Cms.Model.wx_userinfo wxs = new Cms.Model.wx_userinfo();
            wxs.subscribe      = muserinfo.subscribe;
            wxs.openid         = muserinfo.openid;
            wxs.nickname       = muserinfo.nickname;
            wxs.sex            = muserinfo.sex;
            wxs.language       = muserinfo.language;
            wxs.city           = muserinfo.city;
            wxs.province       = muserinfo.province;
            wxs.country        = muserinfo.country;
            wxs.headimgurl     = muserinfo.headimgurl;
            wxs.subscribe_time = muserinfo.subscribe_time;
            wxs.remark         = muserinfo.remark;
            wxs.updatetime     = DateTime.Now;
            if (!Cms.DBUtility.DbHelperSQL.Exists("select count(1) from wx_userinfo where openid='" + muserinfo.openid + "'"))
            {
                if (wxs.openid != "")
                {
                    userinfo.Add(wxs);
                }
            }
            else
            {
                Cms.DBUtility.DbHelperSQL.ExecuteSql("update wx_userinfo set updatetime='" + DateTime.Now + "' where openid='" + muserinfo.openid + "'");
            }
        }

        return(result);
    }
Exemplo n.º 2
0
 public static Cms.Model.wx_userinfo getwxCode(string code, string httpUrl)
 {
     Cms.Model.wx_info     wxInfo    = new Cms.BLL.wx_info().GetModel(1);
     Cms.BLL.wx_userinfo   userinfo  = new Cms.BLL.wx_userinfo();
     Cms.Model.wx_userinfo muserinfo = new Cms.Model.wx_userinfo();
     if (code != null && code != "")
     {
         string strOpenId = GetJson("https://api.weixin.qq.com/sns/oauth2/access_token?appid=" + wxInfo.AppId + "&secret=" + wxInfo.AppSecret + "&code=" + code + "&grant_type=authorization_code");
         //微信回传的数据为Json格式,将Json格式转化成对象
         OAuth_Token oAuth_Token = wxuser.JSONToObject <OAuth_Token>(strOpenId);
         string      strInfo     = GetJson("https://api.weixin.qq.com/sns/userinfo?access_token=" + oAuth_Token.access_token + "&openid=" + oAuth_Token.openid + "&lang=zh_CN");
         wxuserinfo  Wxuserinfo  = wxuser.JSONToObject <wxuserinfo>(strInfo);
         muserinfo.subscribe      = Wxuserinfo.subscribe;
         muserinfo.openid         = Wxuserinfo.openid;
         muserinfo.nickname       = Wxuserinfo.nickname;
         muserinfo.sex            = Wxuserinfo.sex;
         muserinfo.language       = Wxuserinfo.language;
         muserinfo.city           = Wxuserinfo.city;
         muserinfo.province       = Wxuserinfo.province;
         muserinfo.country        = Wxuserinfo.country;
         muserinfo.headimgurl     = Wxuserinfo.headimgurl;
         muserinfo.subscribe_time = Wxuserinfo.subscribe_time;
         muserinfo.remark         = Wxuserinfo.remark;
         muserinfo.updatetime     = DateTime.Now;
         //string str = setinfo("https://api.weixin.qq.com/cgi-bin/user/info?access_token=" + Model_info.access_token + "&openid=" + openid, "", openid);
         if (!Cms.DBUtility.DbHelperSQL.Exists("select count(1) from wx_userinfo where openid='" + muserinfo.openid + "'"))
         {
             if (muserinfo.openid != "")
             {
                 setlog("添加访问信息", oAuth_Token.openid);
                 userinfo.Add(muserinfo);
             }
             else
             {
                 DataTable dtUserInfo = new Cms.BLL.wx_userinfo().GetList("openid='" + muserinfo.openid + "' order by updatetime desc").Tables[0];
                 if (dtUserInfo != null && dtUserInfo.Rows.Count > 0)
                 {
                     muserinfo.id = int.Parse(dtUserInfo.Rows[0]["id"].ToString());
                     userinfo.Update(muserinfo);
                 }
             }
         }
         else
         {
             DataTable dtUserInfo = new Cms.BLL.wx_userinfo().GetList("openid='" + muserinfo.openid + "' order by updatetime desc").Tables[0];
             if (dtUserInfo != null && dtUserInfo.Rows.Count > 0)
             {
                 muserinfo.id = int.Parse(dtUserInfo.Rows[0]["id"].ToString());
                 userinfo.Update(muserinfo);
             }
         }
     }
     return(muserinfo);
 }
Exemplo n.º 3
0
    public static string getUser_info(string poststr)
    {
        string result = "123";

        try
        {
            wxuser.setstatistics("", "微信消息", poststr, 1, 1);
            string res = "";
            if (poststr != null)
            {
                wxmessage   wx  = new wxmessage();
                XmlDocument xml = new XmlDocument();
                xml.LoadXml(poststr);
                XmlElement root = xml.DocumentElement;


                wx.ToUserName   = root.SelectSingleNode("ToUserName").InnerText;
                wx.FromUserName = root.SelectSingleNode("FromUserName").InnerText;
                wx.MsgType      = root.SelectSingleNode("MsgType").InnerText;
                if (wx.MsgType.Trim() == "text")
                {
                    wx.Content = root.SelectSingleNode("Content").InnerText;
                }
                if (wx.MsgType.Trim() == "event")
                {
                    wx.EventName = root.SelectSingleNode("Event").InnerText;
                    wx.EventKey  = root.SelectSingleNode("EventKey").InnerText;
                }
                if (wx.MsgType.Trim() == "voice")
                {
                    wx.Recognition = root.SelectSingleNode("Recognition").InnerText;
                }
                Cms.BLL.wx_info       wxinfo    = new Cms.BLL.wx_info();
                Cms.Model.wx_info     Model     = new Cms.Model.wx_info();
                Cms.BLL.wx_userinfo   userinfo  = new Cms.BLL.wx_userinfo();
                Cms.Model.wx_userinfo muserinfo = new Cms.Model.wx_userinfo();
                Model = wxinfo.GetModel(1);
                string str    = "";
                string openid = wx.FromUserName;
                str       = setinfo("https://api.weixin.qq.com/cgi-bin/user/info?access_token=" + Model.access_token + "&openid=" + openid, "", openid);
                muserinfo = JSONToObject <Cms.Model.wx_userinfo>(str);
                Cms.Model.wx_userinfo wxs = new Cms.Model.wx_userinfo();
                wxs.subscribe      = muserinfo.subscribe;
                wxs.openid         = muserinfo.openid;
                wxs.nickname       = muserinfo.nickname;
                wxs.sex            = muserinfo.sex;
                wxs.language       = muserinfo.language;
                wxs.city           = muserinfo.city;
                wxs.province       = muserinfo.province;
                wxs.country        = muserinfo.country;
                wxs.headimgurl     = muserinfo.headimgurl;
                wxs.subscribe_time = muserinfo.subscribe_time;
                wxs.remark         = muserinfo.remark;
                wxs.updatetime     = DateTime.Now;
                if (!Cms.DBUtility.DbHelperSQL.Exists("select count(1) from wx_userinfo where openid='" + muserinfo.openid + "'"))
                {
                    if (muserinfo.openid != "")
                    {
                        userinfo.Add(wxs);
                    }
                }
                else
                {
                    Cms.DBUtility.DbHelperSQL.ExecuteSql("update wx_userinfo set updatetime='" + DateTime.Now + "' where openid='" + muserinfo.openid + "'");
                }
                wxuser.setstatistics("", "", "", 3, 1);
                result = muserinfo.openid;
            }


            HttpContext.Current.Response.ContentType = "text/xml";
            HttpContext.Current.Response.Write(res);
        }
        catch (Exception ex)
        {
            setlog(ex.Message, "错误1");
        }
        return(result = "21313");
    }
Exemplo n.º 4
0
    /// <summary>
    /// 获取微信用户信息
    /// </summary>
    /// <param name="openid"></param>
    /// <returns></returns>
    public static Cms.Model.wx_userinfo getwxuserinfo(string openid)
    {
        Cms.BLL.wx_info       wxinfo    = new Cms.BLL.wx_info();
        Cms.Model.wx_info     Model     = new Cms.Model.wx_info();
        Cms.BLL.wx_userinfo   userinfo  = new Cms.BLL.wx_userinfo();
        Cms.Model.wx_userinfo muserinfo = new Cms.Model.wx_userinfo();
        Model = wxinfo.GetModel(1);
        string    str = "";
        DataTable dt  = userinfo.GetList("openid='" + openid + "' order by updatetime desc").Tables[0];

        if (dt.Rows.Count > 0)
        {
            string uptime = Convert.ToDateTime(dt.Rows[0]["updatetime"]).ToString("yyyy-MM-dd");
            string time   = DateTime.Now.ToString("yyyy-MM-dd");

            if (uptime == time)
            {
                muserinfo = userinfo.GetModel(int.Parse(dt.Rows[0]["id"].ToString()));
            }
            else
            {
                string Str = GetJson("https://api.weixin.qq.com/cgi-bin/token?grant_type=client_credential&appid=" + Model.AppId + "&secret=" + Model.AppSecret + "");
                //微信回传的数据为Json格式,将Json格式转化成对象
                OAuth_Token ModelOAuth_Token = wxuser.JSONToObject <OAuth_Token>(Str);
                setlog("添加ModelOAuth_Token", ModelOAuth_Token.access_token);
                string     StrTwo   = GetJson("https://api.weixin.qq.com/cgi-bin/user/info?access_token=" + ModelOAuth_Token.access_token + "&openid=" + openid + "");
                wxuserinfo ModelTwo = wxuser.JSONToObject <wxuserinfo>(StrTwo);
                muserinfo.subscribe      = ModelTwo.subscribe;
                muserinfo.openid         = ModelTwo.openid;
                muserinfo.nickname       = ModelTwo.nickname;
                muserinfo.sex            = ModelTwo.sex;
                muserinfo.language       = ModelTwo.language;
                muserinfo.city           = ModelTwo.city;
                muserinfo.province       = ModelTwo.province;
                muserinfo.country        = ModelTwo.country;
                muserinfo.headimgurl     = ModelTwo.headimgurl;
                muserinfo.subscribe_time = ModelTwo.subscribe_time;
                muserinfo.remark         = ModelTwo.remark;
                muserinfo.updatetime     = DateTime.Now;

                //str = setinfo("https://api.weixin.qq.com/cgi-bin/user/info?access_token=" + Model.access_token + "&openid=" + openid, "", openid);
                //muserinfo = JSONToObject<Cms.Model.wx_userinfo>(str);
                //Cms.Model.wx_userinfo wx = new Cms.Model.wx_userinfo();
                ////wx.id = int.Parse(dt.Rows[0]["id"].ToString());
                //wx.subscribe = muserinfo.subscribe;
                //wx.openid = muserinfo.openid;
                //wx.nickname = muserinfo.nickname;
                //wx.sex = muserinfo.sex;
                //wx.language = muserinfo.language;
                //wx.city = muserinfo.city;
                //wx.province = muserinfo.province;
                //wx.country = muserinfo.country;
                //wx.headimgurl = muserinfo.headimgurl;
                //wx.subscribe_time = muserinfo.subscribe_time;
                //wx.remark = muserinfo.remark;
                //wx.updatetime = DateTime.Now;
                userinfo.Add(muserinfo);
            }
        }



        return(muserinfo);
    }
Exemplo n.º 5
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 public bool Update(Cms.Model.wx_userinfo model)
 {
     return(dal.Update(model));
 }
Exemplo n.º 6
0
 /// <summary>
 /// 增加一条数据
 /// </summary>
 public int  Add(Cms.Model.wx_userinfo model)
 {
     return(dal.Add(model));
 }