Select中根据条件生成的Column,该如何排序? 返回

SqlSugar 沟通中
2 208
该叫什么 tiantian 发布于2周前
悬赏:0 飞吻
        return db.Queryable<CustomerContractOptionModel>()
                 .Includes(it1 => it1.Item)
                 .InnerJoin<CustomerInfoModel>((it1, it2) => it1.CustomerID == it2.CustomerID)
                 .InnerJoin<CustomerContractServiceModel>((it1, it2, it3) => it1.CustomerID == it3.CustomerID && it1.ServiceID == it3.ServiceID)
                 .Where(exp.ToExpression())
                 .Select((it1, it2, it3) => new CustomerOptionChangeDTO
                 {
                     InvoiceCD = it1.InvoiceCD ?? it3.InvoiceCD,
                     CustomerID = it1.CustomerID,
                     LinkCustomerID = it3.LinkCustomerID,
                     CustomerName = it2.CustomerName,
                     ServiceID = it1.ServiceID,
                     ItemCD = it1.ItemCD,
                     ItemName = it1.Item!.ItemName,
                     StartYM = it1.StartYM,
                     EndYM = it1.EndYM,
                     Qty = it1.Qty,
                     UnitCost = it1.UnitCost,
                     Charge = it1.Charge,
                     Note = it1.Note,
                     ApprovalNo = it1.ApprovalNo
                 })
                 .ToList();


请教,想要使用该Select中的InvoiceCD进行排序,该如何写OrderBy?


热忱回答2

  • 使用嵌套查询,MergeTable
    select ().MergeTable()后面再接where就OK了或者再接OrderBy就好了
    https://www.donet5.com/home/doc?masterId=1&typeId=2354

    0 回复
  • select ().MergeTable().orderby

    0 回复