protected override IEnumerable GetRows()
{
var where = "BillDate BETWEEN '" + dtpBillDate1.Value.Date.ToString() + "' AND dateadd(day, 1, '" + dtpBillDate2.Value.Date.ToString() + "')";
var s = txtSupplierName.Text.Trim();
if (s != "")
{
where += " AND SupplierName LIKE '%" + s + "%'";
}
var orderby = "BillDate ASC";
var bl = new PurchaseBillBL();
var list = bl.GetList(where, orderby);
return(list);
}
protected override IEnumerable GetList()
{
var filters = "BillDate >= '" + dtpBillDate1.Value.Date.ToString() + "' AND BillDate < dateadd(day, 1, '" + dtpBillDate2.Value.Date.ToString() + "')";
var s = txtSupplierName.Text.Trim();
if (s != string.Empty)
{
if (filters != string.Empty)
{
filters += " AND ";
}
filters += "SupplierName LIKE '%" + s + "%'";
}
var sorts = "BillDate DESC, BillCode, SupplierName";
var bl = new PurchaseBillBL();
var list = bl.GetList(filters, sorts);
return(list);
}