Linq to entity 执行多个字段排序的方法

可以连续使用OrderBy,ThenBy 或者 OrderByDescending,ThenByDescending

 var data = db.User
                .Where(u => u.UserId != "System" && u.EnabledMark == 1 && u.DeleteMark == 0)
                .Select(u => new
                {
                    u.UserId,
                    u.EnCode,
                    u.Account,
                    u.RealName,
                    u.Gender,
                    u.Birthday,
                    u.Mobile,
                    u.Manager,
                    u.OrganizeId,
                    u.DepartmentId,
                    OrganizeName = u.Organize.FullName,
                    DepartmentName = u.Department.FullName,
                    u.RoleId,
                    u.DutyName,
                    u.PostName,
                    u.EnabledMark,
                    u.CreateDate,
                    u.Description
                }).OrderBy(u => u.OrganizeName).ThenBy(u=>u.DepartmentName).ThenBy(u=> u.RealName);

 

posted @ 2017-03-29 10:01  James·wang  阅读(3338)  评论(0)    收藏  举报