8,497
社区成员
发帖
与我相关
我的任务
分享
public IQueryable<Document_ASN_Header> GetDocument_ASN_HeaderByCondition(string ASNNO, string CONSIGNMENTNO, long DOCUMENTTYPE, long OWNERID)
{
var query = from p in this.ObjectContext.Document_ASN_Header
where p.DocumentNo.Contains(ASNNO)&&p.ConsignmentNo.Contains(CONSIGNMENTNO)
select p;
return query;
}
null==DOCUMENTTYPE ? true : DOCUMENTTYPE==doctype
//笨是笨了点,但是能解决你的问题
public IQueryable<Document_ASN_Header> GetDocument_ASN_HeaderByCondition(string ASNNO, string CONSIGNMENTNO, long DOCUMENTTYPE, long OWNERID)
{
if (DOCUMENTTYPE == null && OWNERID == null)
{
var query = from p in this.ObjectContext.Document_ASN_Header
where p.DocumentNo.Contains(ASNNO) && p.ConsignmentNo.Contains(CONSIGNMENTNO)
select p;
return query;
}
else if (DOCUMENTTYPE == null && OWNERID != null)
{
var query = from p in this.ObjectContext.Document_ASN_Header
where p.DocumentNo.Contains(ASNNO) && p.ConsignmentNo.Contains(CONSIGNMENTNO)
&& p.OWNERID == OWNERID
select p;
return query;
}
else if (DOCUMENTTYPE != null && OWNERID == null)
{
var query = from p in this.ObjectContext.Document_ASN_Header
where p.DocumentNo.Contains(ASNNO) && p.ConsignmentNo.Contains(CONSIGNMENTNO)
&& p.DOCUMENTTYPE == DOCUMENTTYPE
select p;
return query;
}
else
{
var query = from p in this.ObjectContext.Document_ASN_Header
where p.DocumentNo.Contains(ASNNO) && p.ConsignmentNo.Contains(CONSIGNMENTNO)
&& p.OWNERID == OWNERID && p.DOCUMENTTYPE == DOCUMENTTYPE
select p;
return query;
}
}
WHERE ... AND ((A IS NULL) OR (A IS NOT NULL AND A = '某个原始值'))
public IQueryable<Document_ASN_Header> GetDocument_ASN_HeaderByCondition(string ASNNO, string CONSIGNMENTNO, long DOCUMENTTYPE, long OWNERID)
{
var query = from p in this.ObjectContext.Document_ASN_Header
where p.DocumentNo.Contains(ASNNO)
&& p.ConsignmentNo.Contains(CONSIGNMENTNO)
&& DOCUMENTTYPE == null
|| p.DOCUMENTTYPE == DOCUMENTTYPE
&& OWNERID == null
|| p.OWNERID == OWNERID
select p;
return query;
}