#region using System.Data; using CSFrameworkV5.Common; using CSFrameworkV5.DataAccess; using CSFrameworkV5.Models; #endregion namespace CSFrameworkV5.WCFContract { /// /// 系统所有用户缓存数据(仅含帐号和密码信息),用于客户端调用WCF接口时检测用户名和密码,有效避免频繁访问数据库。 /// public static class ActivityUserCache { private static DataTable _AllUser; //基于性能优化,定义成员变量 private static DataRow[] _CurrentValidateUser; private static string filter = "Account='{0}' AND Password='{1}'"; /// /// 所有缓存的用户 /// public static DataTable AllUser { get { if (_AllUser == null) RefreshUserCache(); return _AllUser; } } /// /// 刷新缓存数据,重新加载所有用户数据。 /// public static void RefreshUserCache() { _AllUser = dalUser.GetUserList4Cache(); } /// /// 系统增新用户,添加到缓存表 /// /// /// public static void SyncAddUserCache(string account, string encodedPwd) { if (_AllUser == null) return; lock (_AllUser) { var R = _AllUser.Rows.Add(); R[tb_MyUser.Account] = account; R[tb_MyUser.Password] = encodedPwd; _AllUser.AcceptChanges(); } } /// /// 删除指定缓存用户 /// /// public static void SyncRemoveUserCache(string account) { if (_AllUser == null) return; lock (_AllUser) { var rs = _AllUser.Select("Account='" + account + "'"); if (rs.Length > 0) _AllUser.Rows.Remove(rs[0]); } } /// /// 同步用户密码 /// /// 帐号 /// 新密码 public static void SyncUpdateUserCache(string account, string pwd) { if (_AllUser == null) return; var rs = _AllUser.Select("Account='" + account + "'"); if (rs.Length > 0) lock (_AllUser) { rs[0][tb_MyUser.Password] = pwd; _AllUser.AcceptChanges(); } } /// /// 同步用户缓存数据 /// /// 最新修改的用户数据 public static void SyncUserCache(DataTable newUserData) { if (newUserData.Rows.Count <= 0) return; var R = newUserData.Rows[0]; if (R.RowState != DataRowState.Deleted) { var account = ConvertEx.ToString(R[tb_MyUser.Account]); var password = ConvertEx.ToString(R[tb_MyUser.Password]); if (R.RowState == DataRowState.Added) SyncAddUserCache(account, password); if (R.RowState == DataRowState.Modified) SyncUpdateUserCache(account, password); } } /// /// 检查用户名及密码是否正确 /// /// 登录帐号 /// 加密后的密码 /// public static bool ValidateUser(string account, string encodedPwd) { _CurrentValidateUser = AllUser.Select(string.Format(filter, account, encodedPwd)); return _CurrentValidateUser.Length > 0; } } }