#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;
}
}
}