子查询有判断回报对象为空错误 返回

SqlSugar 沟通中
1 116

 .Select(

     (u) =>

         new PageOrderMasterOutput

         {

             OrderCode = u.OrderCode,

             OrderDate = u.OrderDate,

             VendorWarehouse = u.VendorWarehouse,

             OrderType = u.OrderType,

             IsRelevancyXsOrder = u.OrderType != "2" && SqlFunc.Subqueryable<OrderMaster>().Where(p => p.OrderCode == SqlFunc.Replace(u.OrderCode, "XSTH", "XS")).Any(),

         },

     true

 );

  单独的
u.OrderType != "2" 

SqlFunc.Subqueryable<OrderMaster>().Where(p => p.OrderCode == SqlFunc.Replace(u.OrderCode, "XSTH", "XS")).Any(),
都没问题,加上判断就报错,还有什么写法吗

热忱回答1