MVC4 用户关闭浏览器后更新用户登录状态

2018-06-22 06:10:38来源：未知阅读 ()

前台代码：

　　</body>

　　function RunOnBeforeUnload() {
                //更改用户登录状态
                var currUser = getCookie("UserAccount");
                $.ajax({
                    type: "post",
                    url: "../Home/UpdateLoginState",
                    data: { 'currUser': currUser},
                    dataType: "text",
                    async: false,
                    success: function (data) {

                    }
                });
            }

后台代码：

　　　//关闭浏览器后更改用户登录状态
        public ActionResult UpdateLoginState()
        {
            string currUser = "";
            string stateStr = "";
            if (Request["currUser"]!=null)
            {
                currUser = Request["currUser"].ToString();
                string updaStr = "update Users set OnLine=0 where UserAccount='"+currUser.Trim()+"'";
                int coun = SqlHelper.ExecuteSql(updaStr);
                if (coun > 0)
                {
                    stateStr = "更改成功！";
                }
                else
                {
                    stateStr = "更改失败！";
                }
            }
            return Content(stateStr);
        }