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