GetCountSql() 공개 메소드

public GetCountSql ( string tableName ) : string
tableName string
리턴 string
예제 #1
0
        public virtual int CountSql(string table, Filter filter)
        {
            string sql = Dialect.GetCountSql(table);
            object obj;

            if (filter != null)
            {
                string   whereSql   = Dialect.GetWhereSql(filter, 0);
                object[] pars       = filter.GetAllValueParameters();
                In[]     parameters = Dialect.ConvertToNamedParameters(0, pars);
                obj = Database.QueryScalar(sql + " " + whereSql, parameters);
                return(Convert.ToInt32(obj));
            }

            obj = Database.QueryScalar(sql);
            return(Convert.ToInt32(obj));
        }