欢迎加我的QQ群:193522571,一起来讨论、交流!

LinQ多字段排序的误区,代码本身不报错,但是得不到应有的效果,此处列出了我测试的几个方法,只有第一个是对的

            //正确
            var weldtable = (from tt in database.NDEWeldingCheckData
                             where tt.IsDelete == false && tt.FK_TasComID == jobnoid
                             select tt
                             )
                             .OrderBy(p => p.SpaType)
                             .ThenBy(p => p.WeldingCheckTypeGoup)
                             .ThenBy(p => p.OrderNumber);
            //错误
            var weldtable = (from tt in database.NDEWeldingCheckData
                             where tt.IsDelete == false && tt.FK_TasComID == jobnoid
                             orderby tt.SpaType, tt.WeldingCheckTypeGoup, tt.OrderNumber
                             select tt
                             );
            //错误
            var weldtable = (from tt in database.NDEWeldingCheckData
                             where tt.IsDelete == false && tt.FK_TasComID == jobnoid
                             orderby tt.SpaType
                             orderby tt.WeldingCheckTypeGoup
                             orderby tt.OrderNumber
                             select tt
                             );

 

posted @ 2016-01-22 13:13  swtool  阅读(435)  评论(0编辑  收藏  举报
欢迎加我的QQ群:193522571,一起来讨论、交流!