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);
    }
示例#2
0
    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);
    }