public List <SystemUserDataInfo> GetSystemUserDataInfos(string searchText, int pageSize, int pageIndex, out int recordCount)
{
List <SystemUser> users = null;
if (string.IsNullOrEmpty(searchText))
{
users = db.SystemUser.Where(n => !n.IsDelete).OrderByDescending(n => n.ID).ToList();
recordCount = db.SystemUser.Where(n => !n.IsDelete).Count();
}
else
{
users = db.SystemUser.Where(n => !n.IsDelete && (n.DisplayName.Contains(searchText) || n.UserName.Contains(searchText))).OrderByDescending(n => n.ID).ToList();
recordCount = db.SystemUser.Where(n => !n.IsDelete && (n.DisplayName.Contains(searchText) || n.UserName.Contains(searchText))).Count();
}
users = users.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
List <SystemUserDataInfo> userDataInfos = SimpleObjectMapper.ListMap <SystemUser, SystemUserDataInfo>(users).ToList();
return(userDataInfos);
}
public List <UserDataInfo> GetUserDataInfos(string searchText, int pageSize, int pageIndex, out int recordCount)
{
List <User> users = null;
if (string.IsNullOrEmpty(searchText))
{
users = db.User.ToList();
recordCount = db.User.Count();
}
else
{
users = db.User.Where(n => n.DisplayName.Contains(searchText) || n.UserName.Contains(searchText)).ToList();
recordCount = db.User.Where(n => n.DisplayName.Contains(searchText) || n.UserName.Contains(searchText)).Count();
}
users = users.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
List <UserDataInfo> userDataInfos = SimpleObjectMapper.ListMap <User, UserDataInfo>(users).ToList();
foreach (var item in userDataInfos)
{
}
return(userDataInfos);
}
public List <SystemLogDataInfo> GetSystemLogDataInfos(string searchText, int userID, int pageSize, int pageIndex, out int recordCount)
{
recordCount = 0;
List <SystemLog> logs = null;
if (string.IsNullOrEmpty(searchText) && userID == 0)
{
logs = db.SystemLog.OrderByDescending(n => n.ID).ToList();
recordCount = db.SystemLog.Count();
}
else
{
if (!string.IsNullOrEmpty(searchText))
{
logs = db.SystemLog.Where(n => n.ModulePage.Contains(searchText) || n.Remark.Contains(searchText)).OrderByDescending(n => n.ID).ToList();
recordCount = db.SystemLog.Where(n => n.ModulePage.Contains(searchText) || n.Remark.Contains(searchText)).Count();
}
if (userID != 0)
{
logs = db.SystemLog.Where(n => n.CreationUserID == userID).OrderByDescending(n => n.ID).ToList();
recordCount = db.SystemLog.Where(n => n.CreationUserID == userID).Count();
}
}
logs = logs.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
List <SystemLogDataInfo> logDataInfos = SimpleObjectMapper.ListMap <SystemLog, SystemLogDataInfo>(logs).ToList();
foreach (var item in logDataInfos)
{
SystemUser user = logs.FirstOrDefault(n => n.ID == item.ID).SystemUser;
if (user != null)
{
item.UserDisplayName = user.DisplayName;
}
item.Remark = item.UserDisplayName + item.Remark;
}
return(logDataInfos);
}
