/// <summary>
/// 获取JSON格式的用户列表
/// </summary>
public JsonResult GetUserList(string uname, string rname, string postName, string deptName, int status,
int sex, string userCode, int deptId = 0, int postId = 0,
int pageSize = 20, int pageIndex = 1, string jsRenderSortField = " UserId desc")
{
//SearchCondtion["UserList/uname"] = uname;
//SearchCondtion["UserList/rname"] = rname;
//SearchCondtion["UserList/postName"] = postName;
//SearchCondtion["UserList/deptName"] = deptName;
//SearchCondtion["UserList/status"] = status.ToString();
//SearchCondtion["UserList/sex"] = sex.ToString();
//SearchCondtion["UserList/userCode"] = userCode;
//SearchCondtion["UserList/pageIndex"] = pageIndex.ToString(CultureInfo.InvariantCulture);
//SearchCondtion["UserList/pageSize"] = pageSize.ToString(CultureInfo.InvariantCulture);
var selectIds = Session["chooseUser_selectIds"] == null ? "" : Session["chooseUser_selectIds"].ToString();
var selectedUserIds = selectIds.GetArray();
var deptIds = new List <int>();
var postIds = new List <int>();
if (deptId > 0)
{
deptIds = _deptManager.GetChildDepts(CurrentTenant.TenantId, deptId);
deptIds.Add(deptId);
}
if (postId > 0)
{
postIds = _postManager.GetAllChildPosts(postId, CurrentTenant.TenantId);
postIds.Add(postId);
}
int totalRecords;
var list = _userManager.GetUserList(out totalRecords, CurrentTenant.TenantId, uname, rname, postName,
deptName, deptIds.ToArray(), postIds.ToArray(), null, status, sex,
userCode, (pageIndex - 1) * pageSize + 1, pageSize, jsRenderSortField);
var itemArray = list.Select(p => new
{
p.UserId,
p.Username,
p.UserCode,
p.Realname,
//DeptName = p.DeptName ?? CurrentTenant.TenantName,
p.DeptName,
p.PostName,
p.Email,
p.Phone,
p.Freezed,
p.Sex,
IsSelected = selectedUserIds.Contains(p.UserId) ? "1" : "0"
});
return(Json(new { dataList = itemArray, recordCount = totalRecords }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取JSON格式的用户列表
/// </summary>
public JsonResult GetNotTeacherUserList(string uname, string rname, int status,
int sex, int deptId = 0, int postId = 0,
int pageSize = 20, int pageIndex = 1, string jsRenderSortField = " UserId desc")
{
var deptIds = new List <int>();
var postIds = new List <int>();
if (deptId > 0)
{
deptIds = _deptManager.GetChildDepts(CurrentTenant.TenantId, deptId);
deptIds.Add(deptId);
}
if (postId > 0)
{
postIds = _postManager.GetAllChildPosts(postId, CurrentTenant.TenantId);
postIds.Add(postId);
}
int totalRecords;
var list = _userManager.GetUserListForChooseTeacher(out totalRecords, CurrentTenant.TenantId, uname, rname,
deptIds.ToArray(), postIds.ToArray(), null, status, sex,
(pageIndex - 1) * pageSize + 1, pageSize, jsRenderSortField);
var itemArray = list.Select(p => new
{
p.UserId,
p.Username,
p.UserCode,
p.Realname,
//DeptName = p.DeptName ?? CurrentTenant.TenantName,
p.DeptName,
p.PostName,
p.Email,
p.Phone,
p.Freezed,
p.Sex
});
return(Json(new { dataList = itemArray, recordCount = totalRecords }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取JSON格式的用户列表
/// </summary>
public JsonResult GetUserList(string uname, string rname, int status,
int sex, string userCode = "", string postName = "", string deptName = "", int deptId = 0, int postId = 0, int jiSession = 0, int excludeSelf = 0,
int pageSize = 20, int pageIndex = 1, string jsRenderSortField = "UserId desc")
{
if (jiSession == 0)
{
SearchCondtion["UserList/uname"] = uname;
SearchCondtion["UserList/rname"] = rname;
SearchCondtion["UserList/status"] = status.ToString();
SearchCondtion["UserList/sex"] = sex.ToString();
SearchCondtion["UserList/userCode"] = userCode;
SearchCondtion["UserList/pageIndex"] = pageIndex.ToString(CultureInfo.InvariantCulture);
SearchCondtion["UserList/pageSize"] = pageSize.ToString(CultureInfo.InvariantCulture);
}
string selectIds = this.SessionExt()["chooseUser_selectIds"] == null ? "" : this.SessionExt()["chooseUser_selectIds"].ToString();
int[] selectedUserIds = selectIds.GetArray();
var deptIds = new List <int>();
var postIds = new List <int>();
if (deptId > 0)
{
deptIds = _deptManager.GetChildDepts(CurrentTenant.TenantId, deptId);
deptIds.Add(deptId);
}
if (postId > 0)
{
postIds = _postManager.GetAllChildPosts(postId, CurrentTenant.TenantId);
postIds.Add(postId);
}
//IEnumerable<UserList> list = _userManager.GetUserList(out totalRecords, CurrentTenant.TenantId, uname, rname,
// postName,
// deptName, deptIds.ToArray(), postIds.ToArray(), null, status, sex,
// userCode, (pageIndex - 1) * pageSize + 1, pageSize, jsRenderSortField);
var ulist = SystemUsers.Where(p => p.Status == 0 && p.Username.ToLower().Contains(uname.ToLower()))
.Where(p => p.Realname.ToLower().Contains(rname.ToLower()))
.Where(p => p.PostName.ToLower().Contains(postName.ToLower()))
.Where(p => p.DeptLevelPath.ToLower().Contains(deptName.ToLower()))
.Where(p => p.UserCode.ToLower().Contains(userCode.ToLower()))
.Where(p => deptIds.Count == 0 || deptIds.Contains(p.DeptId))
.Where(p => postIds.Count == 0 || postIds.Contains(p.PostId))
.Where(p => status == -1 || (p.Freezed ? 1 : 0) == status)
.Where(p => sex == -1 || p.Sex == sex)
.Where(p => excludeSelf == 0 || p.UserId != CurrentUser.UserId).Distinct();
int totalRecords = ulist.Count();
ulist = ulist.DataSorting(jsRenderSortField);
ulist = ulist.Skip((pageIndex - 1) * pageSize).Take(pageSize);
var itemArray = ulist.Select(p => new
{
p.UserId,
p.Username,
p.UserCode,
p.Realname,
//DeptName = p.DeptName ?? CurrentTenant.TenantName,
p.DeptName,
p.PostName,
p.Email,
p.Phone,
Freezed = p.Freezed ? 1 : 0,
p.Sex,
IsSelected = selectedUserIds.Contains(p.UserId) ? "1" : "0"
});
return(Json(new { dataList = itemArray, recordCount = totalRecords }, JsonRequestBehavior.AllowGet));
}
