DMSFrame 之查詢表示式用法（一）

kingkoo發表於2018-04-21

where條件

            WhereClip<Adm_User> where = new WhereClip<Adm_User>(q => q.DeleteFlag == false);
            where.And(q => q.UserID == 1);
            where.Like("UserName", "123");
            where.GreaterThan("UserName", "A");
            where.Equal("TrueName", "admin");

order by 排序

  　　　　　　OrderByClip<Adm_User> orderby = new OrderByClip<Adm_User>();
            orderby.Appends("UserID", true);//後一個參數列示是否倒序
            orderby.Appends(q => q.OrderBy(q.UserID, q.UserName.Desc()));

group by 分組 

            GroupByClip<Adm_User> groupby = new GroupByClip<Adm_User>();
            groupby.Appends("UserID");
            groupby.Appends(q => q.GroupBy(q.UserID, q.UserName));

 可以說:DMSFrame在查詢上還是非常靈活的.只有您想不到的,沒有做不到的方式

 

相關文章