/// <summary>
/// 获取部门用户
/// </summary>
/// <param name="eStatus">状态:注销,正常</param>
/// <returns></returns>
public ViewBase GetUsers(Common.UserStatus eStatus)
{
ViewRoleUser vwRoleUesr = new ViewRoleUser();
vwRoleUesr.BaseCondition = "d.ID = " + base.ID.ToString() + " AND a.IsCancel = " + ((int)eStatus).ToString();
return(vwRoleUesr);
}
private async Task updateUserStatus(string id, Common.UserStatus status)
{
for (var i = 0; i < 100; i++)
{
var result = await Cosmos.User.ReadItemAsync <UserModel>(id, PartitionKey.None);
var model = result.Resource;
model.SetStatus(status);
var option = new ItemRequestOptions();
option.IfMatchEtag = result.ETag;
option.ConsistencyLevel = ConsistencyLevel.Session;
try
{
var resultReplace = await Cosmos.Sequence.ReplaceItemAsync(model, id, null, option);
return;
}
catch (CosmosException ex)
{
Logger.LogInformation(ex, $"GetNumber Retry {i}");
continue;
}
}
Logger.LogWarning("GetNumber is over retry count.");
}
/// <summary>
/// 根据部门获得当前角色下的人
/// </summary>
/// <param name="iDeptID">部门ID</param>
/// <param name="eStatus">用户状态:注销/启用</param>
/// <returns></returns>
public ViewBase GetUserByCurrDept(int iDeptID, Common.UserStatus eStatus)
{
ViewBase vw = this.GetUsers(eStatus);
vw.BaseCondition += " b.FK_DeptID = '" + iDeptID + "'";
return(vw);
}
/// <summary>
/// 获取部门用户
/// </summary>
/// <param name="eStatus">状态:注销,正常</param>
/// <returns></returns>
public ViewBase GetUsers(Common.UserStatus eStatus)
{
ViewBase vwUser = this.Users;
vwUser.BaseCondition += " AND a.IsCancel = " + ((int)eStatus).ToString();
return(vwUser);
}
/// <summary>
/// 获取当前部门下的人
/// </summary>
/// <param name="ifloorCode"> 0自己,>0 子部门层数,-1所有</param>
/// <param name="eStatus">状态</param>
/// <returns></returns>
private ViewBase GetChildDUser(int ifloorCode, Common.UserStatus eStatus)
{
string strSubDptIDs = ifloorCode == 0 ? string.Empty : this.GetChildDeptID(base.ID, ifloorCode);
strSubDptIDs = strSubDptIDs.Length > 0 ? strSubDptIDs + "," + base.ID.ToString() : base.ID.ToString();
ViewBase vwUser = new ViewUser();
vwUser.BaseCondition = "b.FK_DeptID IN (" + strSubDptIDs + ") AND a.IsCancel = " + ((int)eStatus).ToString();
return(vwUser);
}
/// <summary>
/// 根据部门ID获得角色下的人(在某个部门具有当前角色的人)
/// </summary>
/// <param name="iDeptID">部门ID</param>
/// <param name="eStatus">eStatus</param>
/// <returns></returns>
public ViewBase GetUserByDept(int iDeptID, Common.UserStatus eStatus)
{
Department dpt = new Department();
string strSubDptIDs = dpt.GetChildDeptID(iDeptID, -1);
string strCondition = "(d.ID = " + base.ID.ToString() + " AND b.FK_DeptID = " + iDeptID.ToString() + ")";
strCondition = strSubDptIDs.Length > 0 ? "(" + strCondition + "OR (d.ID = " + base.ID.ToString() + " AND b.FK_DeptID IN (" + strSubDptIDs + ")))" : strCondition;
ViewBase vw = new ViewRoleUser();
vw.BaseCondition = strCondition + " AND a.IsCancel = " + ((int)eStatus).ToString();
return(vw);
}
/// <summary>
/// 当前部门下子部门的人
/// </summary>
/// <param name="ifloorCode"> 0自己,>0 子部门层数,-1所有</param>
/// <param name="eStatus">状态:注销,正常</param>
/// <returns></returns>
public ViewBase GetChildDeptUsers(int ifloorCode, Common.UserStatus eStatus)
{
return(this.GetChildDUser(ifloorCode, eStatus));
}
