public void TestWhereEntity()
{
var subPaymentHTs = SubPaymentHTs
.Where(w => w.GROUP_REQUEST_NO == "999999560900000001" &&
(w.STATUS != null && w.STATUS == "P"));
Assert.AreEqual(subPaymentHTs.Count(), 2);
}
private IEnumerable <AG_IAS_SUBPAYMENT_H_T> GetSubPaymentHead(AG_IAS_PAYMENT_G_T paymentGT)
{
IEnumerable <AG_IAS_SUBPAYMENT_H_T> subPaymentHTs = SubPaymentHTs
.Where(w => w.GROUP_REQUEST_NO == paymentGT.GROUP_REQUEST_NO &&
(w.STATUS != null && w.STATUS == "P") &&
(
w.PETITION_TYPE_CODE == "11" ||
w.PETITION_TYPE_CODE == "13" ||
w.PETITION_TYPE_CODE == "14" ||
w.PETITION_TYPE_CODE == "15" ||
w.PETITION_TYPE_CODE == "16" ||
w.PETITION_TYPE_CODE == "17" ||
w.PETITION_TYPE_CODE == "18"
)
).ToList();
return(subPaymentHTs);
}