8,497
社区成员
发帖
与我相关
我的任务
分享
SELECT TOP 6 * FROM [CompeteOrder]
LEFT OUTER JOIN CompeteList ON CompeteOrder.C_ListIDs LIKE ('%,'+CONVERT(VARCHAR(9),CompeteList.CL_ID)+',%' )
LEFT OUTER JOIN [UserTable] ON ([CompeteOrder].[C_UserID] = [UserTable].[ID])
WHERE (([CompeteOrder].[C_PayState] = '已支付') AND ([CompeteOrder].[C_UserID] = 1))
ORDER BY [CompeteOrder].[OrderID] DESC
return ORM.DbHelper.From<CompeteOrder>()
.LeftJoin<CompeteList>((o, p) =>("%,"+ p.CL_ID+",%").Like(o.C_ListIDs))
.LeftJoin<UserTable>((o, p) => o.C_UserID == p.ID)
.OrderByDescending(u => u.OrderID)
.Where(Dwhere.ToWhereClip())
.Select()
.Page(PageSize, PageIndex)
.ToDataTable();