public DataTable GetDataSource(SearchFilterCollection sFilterCols, string SortString, int PageSize, int CurrentPage)
{
string WhereCond = Tools.GetCondition(sFilterCols);
var ListResult = dataContext.ExecuteQuery <vOrders>(string.Format("exec spGetPaged '{0}','{1}','{2}','{3}',N'{4}'", TableOrViewName, SortString, PageSize, CurrentPage, WhereCond));
DataTable dt = new Converter <vOrders>().ToDataTable(ListResult);
return(dt);
}
DataTable IBaseBOL.GetDataSource(SearchFilterCollection sFilterCols, string SortString, int PageSize, int CurrentPage)
{
string WhereCond;
WhereCond = Tools.GetCondition(sFilterCols);
if (WhereCond == "")
{
WhereCond = " OrderCode = " + MasterCode;
}
else
{
WhereCond = " OrderCode = " + MasterCode + " and " + WhereCond;
}
var ListResult = dataContext.ExecuteQuery <vOrderProducts>(string.Format("exec spGetPaged '{0}','{1}','{2}','{3}','{4}'", TableOrViewName, SortString, PageSize, CurrentPage, WhereCond));
DataTable dt = new Converter <vOrderProducts>().ToDataTable(ListResult);
return(dt);
}
