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); }