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