C# EF+LINQ 查询主表明细表数据查询条件写法|C/S开发框架

if (!input.content.IsEmpty())
{
var q_Sub = q_APs.Where(w => false
|| w.InvoiceNo == input.content
|| w.InvoiceName == input.content
|| w.OrderNo == input.content
|| (w.Remark ?? "").Contains(input.content));
q_AP = q_AP.Where(w => (false
|| w.APNO == input.content
|| w.SupplierCode == input.content
|| (w.SupplierName ?? "").Contains(input.content)) || q_Sub.Any(x => x.APNO == w.APNO));
}
扫一扫加作者微信