var data = await _db.Queryable<DDArShop_User_ShopCartEntity, DDAr_Shop_ShopName_TaoCanEntity, DDAr_Shop_UserEntity>((a, b,c) => new JoinQueryInfos(JoinType.Left, a.ShopNameTaoCanId == b.Id,JoinType.Left, a.TenantId == c.Id)).WhereIF(!string.IsNullOrEmpty(input.shopId), a => a.ShopId.Contains(input.shopId)).WhereIF(!string.IsNullOrEmpty(input.shopNameTaoCanId), a => a.ShopNameTaoCanId.Contains(input.shopNameTaoCanId)).Where((a, b, c) => a.DeleteMark == null && a.Type == 1)
.Select((a,b,c) => new
{
id = a.Id,
shopId = a.ShopId,
shopNameTaoCanId = a.ShopNameTaoCanId,
shopName = b.ShopTitle,
chengYiJin = a.ChengYiJin,
myPrice = a.MyPrice,
type = a.Type,
content = a.Content,
result = a.Result,
userPhone = a.UserPhone,
userName = c.Nickname
}).MergeTable().Select<DDArShop_ShopCartOutput>().OrderBy(sidx + " " + input.order).ToPagedListAsync(input.page, input.limit); :本文最后更新于2023年12月11日,已经过了760天没有更新,若内容或图片失效,请留言反馈
.netcore用sqlsugar实现3表联查
博主关闭了当前页面的评论