Ejemplo n.º 1
0
        /// <summary>
        /// 数据转第三方登录实体
        /// </summary>
        public static OAuthInfo DataToModel(SqlDataReader rdr)
        {
            OAuthInfo oauth = new OAuthInfo();
            if (!rdr.IsDBNull(0)) oauth.OAuthID = rdr.GetInt32(0);
            if (!rdr.IsDBNull(1)) oauth.OpenID = rdr.GetString(1);
            if (!rdr.IsDBNull(2)) oauth.AccessToken = rdr.GetString(2);
            if (!rdr.IsDBNull(3)) oauth.UserID = rdr.GetInt32(3);
            if (!rdr.IsDBNull(4)) oauth.OldUserID = rdr.GetInt32(4);
            if (!rdr.IsDBNull(5)) oauth.OAuthBound = rdr.GetByte(5);
            if (!rdr.IsDBNull(6)) oauth.OAuthFrom = rdr.GetString(6);
            if (!rdr.IsDBNull(7)) oauth.ModifyDate = rdr.GetDateTime(7);

            return oauth;
        }
Ejemplo n.º 2
0
    private void BindData()
    {
        string u = Request.QueryString["u"];
        string openId = Request.QueryString["openId"];

        UserInfo user = new UserInfo();
        user.UserName = UserHelper.GetUserName(u);
        user.UserPassword = "******";
        user.UserNickName = Request.QueryString["name"] ?? "";
        user.UserImage = Request.QueryString["image"] == "" ? "none.gif" : Request.QueryString["image"];
        user.UserFrom = u;
        user.ModifyDate = DateTime.Now;
        user.IsUpdate = 1;

        OAuthInfo oauth = new OAuthInfo();
        oauth.OpenID = openId;
        oauth.AccessToken = Request.QueryString["accessToken"];
        oauth.OAuthFrom = u;
        oauth.OAuthBound = 0;
        oauth.ModifyDate = DateTime.Now;

        bool success = oauth_bll.OAuthLoginByOpenId(oauth.OpenID);
        if (!success)
        {
            using (TransactionScope ts = new TransactionScope())
            {
                success = bll.InsertUser(user);
                user = bll.GetUserByUserPassword(user.UserName, user.UserPassword);
                oauth.UserID = user.UserID;
                oauth.OldUserID = user.UserID;
                success = oauth_bll.InsertOAuth(oauth);

                ts.Complete();
            }
            if (!success)
            {
                Response.Write("自动登录错误!");
                Response.End();
            }
        }
        else
        {
            oauth = oauth_bll.GetOAuthByOpenId(openId);
            user = bll.GetUserByUserId(oauth.UserID);
        }

        UserHelper.SaveSession(user);

        Response.Redirect("/Default.aspx");
    }
Ejemplo n.º 3
0
        /// <summary>
        /// 根据OpenID取第三方登录
        /// </summary>
        public OAuthInfo GetOAuthByOpenId(string openId)
        {
            OAuthInfo oauth = new OAuthInfo();

            SqlParameter parm = new SqlParameter(PARM_OPEN_ID, SqlDbType.NVarChar, 100);
            parm.Value = openId;

            using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.Text, SQL_SELECT_OAUTH_BY_OPEN_ID, parm))
            {
                while (rdr.Read())
                {
                    oauth = DataToModel(rdr);
                }
            }

            return oauth;
        }
Ejemplo n.º 4
0
        /// <summary>
        /// 第三方登录实体转参数
        /// </summary>
        public static SqlParameter[] ModelToParms(OAuthInfo oauth)
        {
            SqlParameter[] parms = {
                    new SqlParameter("@OAuthID", SqlDbType.Int),
                    new SqlParameter("@OpenID", SqlDbType.NVarChar, 100),
                    new SqlParameter("@AccessToken", SqlDbType.NVarChar, 100),
                    new SqlParameter("@UserID", SqlDbType.Int),
                    new SqlParameter("@OldUserID", SqlDbType.Int),
                    new SqlParameter("@OAuthBound", SqlDbType.TinyInt),
                    new SqlParameter("@OAuthFrom", SqlDbType.NVarChar, 10),
                    new SqlParameter("@ModifyDate", SqlDbType.DateTime)
            };
            parms[0].Value = oauth.OAuthID;
            parms[1].Value = oauth.OpenID;
            parms[2].Value = oauth.AccessToken;
            parms[3].Value = oauth.UserID;
            parms[4].Value = oauth.OldUserID;
            parms[5].Value = oauth.OAuthBound;
            parms[6].Value = oauth.OAuthFrom;
            parms[7].Value = oauth.ModifyDate;

            return parms;
        }
Ejemplo n.º 5
0
    protected void Page_Load(object sender, EventArgs e)
    {
        string userName = Request.Form["username"] ?? "";
        string openId = Request.Form["openid"].ToString();
        string accessToken = Request.Form["accesstoken"].ToString();
        string oAuthFrom = "sjqq";
        string nickName = Request.Form["nickname"].ToString();
        string userImage = Request.Form["userimage"].ToString();
        string userFrom = Request.Form["userfrom"].ToString() ?? Request.Form["oauthfrom"].ToString();
        int type = Convert.ToInt32(Request.Form["type"]);
        string isUpdate = Request.Form["isupdate"] ?? "0";

        if (userFrom.Length > 5)
        {
            userFrom = userFrom.Replace("_", "");
            userFrom = userFrom.Insert(5, "_");
        }

        UserInfo user = user_bll.GetUserByUserName(userName);
        if (userName == "") user.UserName = UserHelper.GetUserName(oAuthFrom);
        if (userName == "") user.UserPassword = "******";
        user.UserNickName = nickName;
        user.UserImage = (userImage=="" ? "none.gif" : userImage);
        user.UserFrom = userFrom;
        user.CreateDate = DateTime.Now;
        user.ModifyDate = DateTime.Now;
        user.IsUpdate = Convert.ToByte(isUpdate);

        //写日志
        log.Info(string.Format(" UserInfo -> {0}", user.ToString()));

        OAuthInfo oauth = new OAuthInfo();
        oauth.OpenID = openId;
        oauth.AccessToken = accessToken;
        oauth.OAuthFrom = oAuthFrom;
        oauth.OAuthBound = 1;
        oauth.ModifyDate = DateTime.Now;

        //写日志
        log.Info(string.Format(" OAuthInfo -> {0}", oauth.ToString()));

        bool success = oauth_bll.OAuthLoginByOpenId(oauth.OpenID);
        if (!success)
        {
            using (TransactionScope ts = new TransactionScope())
            {
                if (user.UserID > 0)
                {
                    success = user_bll.UpdateUser(user);
                }
                else
                {
                    success = user_bll.InsertUser(user);
                    user = user_bll.GetUserByUserPassword(user.UserName, user.UserPassword);
                }

                oauth.UserID = user.UserID;
                oauth.OldUserID = user.UserID;
                success = oauth_bll.InsertOAuth(oauth);

                ts.Complete();
            }
            if (!success)
            {
                Response.Write("{\"result\":\"userid\":\"0\"}");
                Response.End();
            }
        }

        string result = "{";

        if (success)
        {
            oauth = oauth_bll.GetOAuthByOpenId(openId);
            user = user_bll.GetUserByUserId(oauth.UserID);

            decimal userMoney = user.UserMoney;
            if (isUpdate == "1")
            {
                userMoney = user.MoneyStart;
            }

            result += "\"userid\":\"" + user.UserID + "\",";
            result += "\"username\":\"" + user.UserName + "\",";
            result += "\"userpass\":\"" + user.UserPassword + "\",";
            result += "\"usernickname\":\"" + user.UserNickName + "\",";
            result += "\"createdate\":\"" + user.CreateDate.ToString("yyyy-MM-dd") + "\",";
            result += "\"useremail\":\"" + user.UserEmail + "\",";
            result += "\"userphone\":\"" + user.UserPhone + "\",";
            result += "\"userimage\":\"" + user.UserImage + "\",";
            result += "\"userworkday\":\"" + user.UserWorkDay + "\",";
            result += "\"usermoney\":\"" + userMoney + "\",";

            if (type == 1)
            {
                user_bll.UpdateSyncByUserId(user.UserID);
            }

            DataTable dt = bll.GetItemListWithSync(user.UserID);
            if (dt.Rows.Count > 0)
            {
                result += "\"hassync\":\"1\",";
            }
            else
            {
                result += "\"hassync\":\"0\",";
            }

            result += "\"userbound\":\"1\"";
        }
        else
        {
            result += "\"userid\":\"0\",";
            result += "\"username\":\"\",";
            result += "\"userpass\":\"\",";
            result += "\"usernickname\":\"\",";
            result += "\"createdate\":\"\",";
            result += "\"useremail\":\"\",";
            result += "\"userphone\":\"\",";
            result += "\"userimage\":\"\",";
            result += "\"userworkday\":\"5\",";
            result += "\"usermoney\":\"0\",";
            result += "\"categoryrate\":\"90\",";
            result += "\"hassync\":\"0\",";
            result += "\"userbound\":\"0\"";
        }

        result += "}";

        Response.Write(result);
        Response.End();
    }
Ejemplo n.º 6
0
 /// <summary>
 /// 插入第三方登录
 /// </summary>
 public bool InsertOAuth(OAuthInfo oAuth)
 {
     return dal.InsertOAuth(oAuth);
 }
Ejemplo n.º 7
0
 /// <summary>
 /// 修改第三方登录
 /// </summary>
 public bool UpdateOAuth(OAuthInfo oauth)
 {
     return dal.UpdateOAuth(oauth);
 }
Ejemplo n.º 8
0
        /// <summary>
        /// 修改第三方登录
        /// </summary>
        public bool UpdateOAuth(OAuthInfo oauth)
        {
            SqlParameter[] parms = ModelToParms(oauth);

            int result = SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionString, CommandType.StoredProcedure, SQL_UPDATE_OAUTH, parms);

            return result > 0;
        }
Ejemplo n.º 9
0
        /// <summary>
        /// 根据UserID取第三方登录
        /// </summary>
        public OAuthInfo GetOAuthByUserId(int userId)
        {
            OAuthInfo oauth = new OAuthInfo();

            SqlParameter parm = new SqlParameter(PARM_USER_ID, SqlDbType.Int);
            parm.Value = userId;

            using (SqlDataReader rdr = SqlHelper.ExecuteReader(SqlHelper.ConnectionString, CommandType.Text, SQL_SELECT_OAUTH_BY_USER_ID, parm))
            {
                while (rdr.Read())
                {
                    oauth = DataToModel(rdr);
                }
            }

            return oauth;
        }