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); }