/// <summary> /// 查询所有用户 /// </summary> /// <param name="groupId">组标识</param> /// <returns></returns> public List <ImUserInfoPo> QueryAllUser(Guid groupId) { #region sql script string sql = string.Format(@"SELECT top 100000 ui.ImUserId, ISNULL(ug.NickName,ui.ImUserName) AS 'ImUserName', ui.UserHeadimg, ui.UserId, ui.UserType, ui.Remark, ui.CreateTime, ui.UpdateTime, ui.IsValid FROM dbo.UserGroup ug WITH(NOLOCK) LEFT JOIN dbo.ImUserInfo ui WITH(NOLOCK) ON ug.ImUserId = ui.ImUserId WHERE ug.IsValid = 1 AND ui.IsValid = 1 AND ug.GroupId='{0}' ORDER BY ug.CreateTime ASC" , groupId.ToString()); #endregion var data = CurrentDbContext.SqlQueryable <ImUserInfoPo>(sql).ToList(); return(data); }