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