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)
-
VIP0
2周前使用嵌套查询,MergeTable
select ().MergeTable()后面再接where就OK了或者再接OrderBy就好了
https://www.donet5.com/home/doc?masterId=1&typeId=23540 回复 -
fate sta VIP0
1周前select ().MergeTable().orderby
0 回复