int IBaseBOL.GetCount(SearchFilterCollection sFilterCols) { int RecordCount = 1; DBToolsDataContext dcTools = new DBToolsDataContext(); string WhereCond = Tools.GetCondition(sFilterCols); WhereCond = WhereCond.Replace("''", "'"); var ResultQuery = dcTools.spGetCount(TableOrViewName, WhereCond); RecordCount = (int)ResultQuery.ReturnValue; return(RecordCount); }
public int GetCount(SearchFilterCollection sFilterCols) { string WhereCond; int RecordCount = 1; DBToolsDataContext dcTools = new DBToolsDataContext(); WhereCond = Tools.GetCondition(sFilterCols); //if (WhereCond == "") // WhereCond = " UserCode = " + MasterCode; //else // WhereCond = " UserCode = " + MasterCode + " and " + WhereCond; WhereCond = WhereCond.Replace("''", "'"); var ResultQuery = dcTools.spGetCount(TableOrViewName, WhereCond); RecordCount = (int)ResultQuery.ReturnValue; return(RecordCount); }