Beispiel #1
0
        /// <summary>执行SQL查询,返回总记录数</summary>
        /// <param name="builder">查询生成器</param>
        /// <returns>总记录数</returns>
        public override Int64 QueryCount(SelectBuilder builder)
        {
            var ds = Query(builder.SelectCount().ToString(), builder.Parameters.ToArray());

            if (ds == null || ds.Rows == null || ds.Rows.Count == 0)
            {
                return(-1);
            }

            return(ds.Rows[0][0].ToLong());
        }
Beispiel #2
0
 /// <summary>执行SQL查询,返回总记录数</summary>
 /// <param name="builder">查询生成器</param>
 /// <returns>总记录数</returns>
 public virtual Int64 QueryCount(SelectBuilder builder) => ExecuteScalar <Int64>(builder.SelectCount().ToString(), CommandType.Text, builder.Parameters.ToArray());