public bool RemoveUser(QDbTran tran, params int[] puidS)
{
if (puidS == null || puidS.Length < 1)
{
throw new BCFException("参数异常:(puidS == null || puidS.Length < 1)");
}
//删除User
//
UserM u = new UserM();
u.Where(u.PUID.In(puidS)).Delete(tran);
//删除User关联信息
//
User_LinkedM ul = new User_LinkedM();
ul.Where(ul.PUID.In(puidS)).Delete(tran);
//删除User与Resource
//
ResourceService.G.RemoveLink(tran, puidS);
return(true);
}
public DataTable GetInLinked(int rsid)
{
if (rsid < 1)
{
return(null);
}
Resource_LinkedM rl = new Resource_LinkedM();
GroupM g = new GroupM();
UserM u = new UserM();
g.IncludeAll(false);
g.CN_Name.As("LK_OBJT_Name").IsInc = true;
u.IncludeAll(false);
u.CN_Name.As("LK_OBJT_Name").IsInc = true;
DataTable dt1 = rl.InnerJoin(u).On(rl.LK_OBJT_ID == u.PUID)
.And(rl.RSID == rsid).And(rl.LK_OBJT == User.LK_OBJT)
.Select();
rl = new Resource_LinkedM();
DataTable dt2 = rl.InnerJoin(g).On(rl.LK_OBJT_ID == g.PGID)
.And(rl.RSID == rsid)
.And(rl.LK_OBJT == Group.LK_OBJT)
.And(g.R_PGID != Package.DEFINE)
.Select();
foreach (DataRow row in dt2.Rows)
{
dt1.Rows.Add(row.ItemArray);
}
return(dt1);
}
/// <summary>
///
/// </summary>
/// <param name="pgCode">代码模式：3301|33%|33__01%</param>
/// <param name="incDisabled"></param>
/// <param name="incUnVisible"></param>
/// <returns></returns>
private SQuery GetUsersQuery(string pgCode, bool incDisabled, bool incUnVisible)
{
UserM u = new UserM();
User_LinkedM ul = new User_LinkedM();
GroupM g = new GroupM();
ul.IncludeAll(false);
ul.LK_OBJT_ID.IsInc = true;
ul.LK_OBJT_ID.AsName = "PGID";
SQuery SQ = NewSQ();
SQ.From(u)
.InnerJoin(ul)
.On(u.PUID == ul.PUID).And(ul.LK_OBJT == Group.LK_OBJT)
.InnerJoin(g)
.On(ul.LK_OBJT_ID == g.PGID)
.Where(g.PG_Code.Like(pgCode));
if (incDisabled == false)
{
SQ.And(u.Is_Disabled != true);
}
if (incUnVisible == false)
{
SQ.And(u.Is_Visibled != false);
}
return(SQ);
}
public int AppendUser(User user, bool checkUserId, QDbTran tran)
{
if (user == null)
{
return(0);
}
user.Create_Time = DateTime.Now;
user.Last_Update = user.Create_Time;
user.EncryptPassWd();
UserM u = new UserM();
u.Bind(user);
u.Pass_Wd.IsInc = (!string.IsNullOrEmpty(u.Pass_Wd.Value));
if (checkUserId == true) //验证用户名是否存在
{
if (u.Where(u.User_Id == user.User_Id).Exists())
{
return(0);
}
}
u.Insert(true, tran);
return(u.INSERTED_ID);
}
public bool ClearUsers()
{
string[] unClearPUIDs = new string[] { "0", "1" };
//清理,与功能间的关联
//
Resource_LinkedM rl = new Resource_LinkedM();
rl.Where(rl.LK_OBJT == User.LK_OBJT)
.And(rl.LK_OBJT_ID.Unin(unClearPUIDs))
.Delete();
//清理,与组之音的关联
//
User_LinkedM ul = new User_LinkedM();
ul.Where(ul.PUID.Unin(unClearPUIDs)).Delete();
//清理用户数据
//
UserM u = new UserM();
u.Where(u.PUID.Unin(unClearPUIDs)).Delete();
return(true);
}
private SQuery GetUsersQuery(bool incDisabled, bool incUnVisible, params int[] pgids)
{
UserM u = new UserM();
User_LinkedM ul = new User_LinkedM();
ul.IncludeAll(false);
ul.LK_OBJT_ID.IsInc = true;
ul.LK_OBJT_ID.AsName = "PGID";
SQuery SQ = NewSQ();
SQ.From(u)
.InnerJoin(ul)
.On(u.PUID == ul.PUID)
.Where(ul.LK_OBJT_ID.In(pgids))
.And(ul.LK_OBJT == Group.LK_OBJT);
if (incDisabled == false)
{
SQ.And(u.Is_Disabled != true);
}
if (incUnVisible == false)
{
SQ.And(u.Is_Visibled != false);
}
SQ.OrderBy(u.CN_Name);
return(SQ);
}
/// <summary>
/// 核对密码
/// </summary>
public static bool CheckPassWd(string userId, string passWd)
{
string secretPassWd = User.EncryptPassWd(userId, passWd);
UserM u = new UserM();
u.Where(u.User_Id == userId)
.And(u.Pass_Wd == secretPassWd);
return(u.Exists());
}
/// <summary>
/// 是否存有组内用户
/// </summary>
/// <param name="pgid">组PGID</param>
/// <param name="incDisabled">是否包括禁用的</param>
/// <returns></returns>
public bool ExistsUsers(int pgid, bool incDisabled)
{
User_LinkedM ul = new User_LinkedM();
UserM u = new UserM();
SQuery SQ = new SQuery();
return(SQ.From(ul.NoLock())
.InnerJoin(u.NoLock())
.On(ul.PUID == u.PUID)
.Where(ul.LK_OBJT == Group.LK_OBJT)
.And(ul.LK_OBJT_ID == pgid)
.Exists());
}
public bool VisibleUser(int puid, bool isVisibled)
{
if (puid < 1)
{
return(false);
}
UserM u = new UserM();
u.Is_Visibled.Value = isVisibled;
return(u.Where(u.PUID == puid).Update());
}
/// <summary>
/// 获取一个User[@orPuid 或者 @orUser_id]对象
/// </summary>
public User GetUser(int orPuid, string orUser_id)
{
if (orPuid == 0 && orUser_id == null)
{
throw new BCFException("PUID 与 User_Id不能同时为NULL");
}
UserM u = new UserM();
return(u.Where(u.PUID == orPuid)
.Or(u.User_Id == orUser_id)
.SelectOne <User>());
}
/// <summary>
/// 修改用户必码
/// </summary>
/// <param name="userId">用户ID</param>
/// <param name="passWd">未加密的代码</param>
public bool ModifyUserPassWd(string userId, string passWd)
{
UserM u = new UserM();
u.Pass_Wd.Value = User.EncryptPassWd(userId, passWd);
if (string.IsNullOrEmpty(u.Pass_Wd.Value))
{
return(false);
}
return(u.Where(u.User_Id == userId).Update());
}
/// <summary>
/// 是否存在一个用户
/// </summary>
public bool Exists(int orPuid, string orUser_id)
{
if (orUser_id == null)
{
orUser_id = "";
}
if (orUser_id.Length == 0 && orPuid < 1)
{
return(false);
}
UserM u = new UserM();
return(u.Where(u.PUID == orPuid)
.Or(u.User_Id == orUser_id)
.Exists());
}
/// <summary>
/// 修改时,已实现自动[Pass_Wd]加密
/// </summary>
public bool ModifyUser(User user, QDbTran tran)
{
UserM u = new UserM();
u.Pass_Wd.IsInc = user.EncryptPassWd();
u.Bind(user);
u.PUID.IsInc = false;
u.Create_Time.IsInc = false;
u.Last_Update.Value = DateTime.Now;
if (string.IsNullOrEmpty(u.Pass_Wd.Value))
{
u.Pass_Wd.IsInc = false;
}
return(u.Where(u.PUID == user.PUID).Update(tran));
}
/// <summary>
/// 登录
/// </summary>
/// <param name="userId">用户ID</param>
/// <param name="passWd">密码</param>
/// <param name="groupId">限定的组ID</param>
/// <returns>是否成功</returns>
public bool Login(string userId, string passWd, int groupId)
{
if (userId == null || passWd == null)
{
throw new BCFException("!!!(userId == null || passWd == null)");
}
if (userId.Length < 1 || passWd.Length < 1)
{
throw new BCFException("!!!(userId.Length < 1 || passWd.Length < 1)");
}
string secretPassWd = User.EncryptPassWd(userId, passWd);
//-------------------------------
UserM u = new UserM();
User_LinkedM ul = new User_LinkedM();
ul.IncludeAll(false);
//-------------------------------------
SQuery SQ = NewSQ();
SQ.From(u);
if (groupId > 0)
{
SQ.InnerJoin(ul)
.On(ul.PUID == u.PUID)
.And(ul.LK_OBJT == Group.LK_OBJT)
.And(ul.LK_OBJT_ID == groupId);
}
SQ.Where(u.User_Id == userId)
.And(u.Pass_Wd == secretPassWd)
.And(u.Is_Disabled == false);
User user = SQ.SelectOne <User>();
if (user.User_Id == null)
{
return(false);
}
else
{
if (_CurrentUser.Bind(user) == false)
{
return(false);
}
if (groupId > 0)
{
if (_CurrentGroup.Bind(GroupService.G.GetGroup(groupId)) == false)
{
return(false);
}
}
//------------------------->>成功登录后,执行插件调用
// PluginApply.OnLogin();
//-------------------------<<
return(true);
}
}
public bool ExistsUser(string userID)
{
UserM u = new UserM();
return(u.Where(u.User_Id == userID).Exists());
}
public List <User> GetUsers(params int[] puids)
{
UserM u = new UserM();
return(u.Where(u.PUID.In(puids)).Select <User>());
}
