/// <summary> /// /// </summary> public void CheckLogin() { if (!this.IsLogin) { const string msg = "对不起!你的登录信息已失效,请重新登录"; string script = string.Format(@" <SCRIPT LANGUAGE='javascript'><!-- alert({0}); top.location.href=""{1}""; //--></SCRIPT>", viviLib.Security.AntiXss.JavaScriptEncode(msg), "/index.aspx"); HttpContext.Current.Response.Write(script); HttpContext.Current.Response.End(); } else { if (BLL.User.Login.IsManageLogin() == false) { var model = new UserAccessTimeInfo { userid = UserId, lastAccesstime = DateTime.Now }; BLL.User.UserAccessTime.Add(model); } } }
/// <summary> /// /// </summary> /// <param name="completeTime"></param> /// <returns></returns> public double GetDifftime(int userId, object completeTime) { DateTime _comptime = DateTime.MinValue; UserAccessTimeInfo acctInfo = BLL.User.UserAccessTime.GetModel(userId); if (acctInfo == null) { return(1000.0); } DateTime?userAcceTime = acctInfo.lastAccesstime; if (userAcceTime.HasValue) { _comptime = userAcceTime.Value; } DateTime _comptime2 = Convert.ToDateTime(completeTime); return(_comptime2.Subtract(_comptime).TotalMinutes); }
/// <summary> /// /// </summary> /// <param name="ds"></param> /// <returns></returns> public static UserAccessTimeInfo GetModelFromDs(DataSet ds) { UserAccessTimeInfo model = new UserAccessTimeInfo(); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["userid"].ToString() != "") { model.userid = int.Parse(ds.Tables[0].Rows[0]["userid"].ToString()); } if (ds.Tables[0].Rows[0]["lastAccesstime"].ToString() != "") { model.lastAccesstime = DateTime.Parse(ds.Tables[0].Rows[0]["lastAccesstime"].ToString()); } return(model); } else { return(null); } }
/// <summary> /// 增加一条数据 /// </summary> public static bool Add(UserAccessTimeInfo model) { try { int rowsAffected; SqlParameter[] parameters = { new SqlParameter("@userid", SqlDbType.Int, 4), new SqlParameter("@lastAccesstime", SqlDbType.DateTime) }; parameters[0].Value = model.userid; parameters[1].Value = model.lastAccesstime; rowsAffected = DataBase.ExecuteNonQuery(CommandType.StoredProcedure, "proc_usertime_add", parameters); return(rowsAffected > 0); } catch (Exception ex) { ExceptionHandler.HandleException(ex); return(false); } }