Пример #1
0
        /// <summary>
        /// 平均值
        /// </summary>
        /// <param name="functionHandle">函数</param>
        /// <param name="param">字段</param>
        /// <returns></returns>
        public static BQLAggregateFunction Avg(BQLParamHandle param)
        {
            BQLAggregateFunction item = new BQLAggregateFunction(DBAggregateFunction.DoAvg, param);

            item.ValueDbType = DbType.Double;
            return(item);
        }
Пример #2
0
        /// <summary>
        /// 总行数
        /// </summary>
        /// <param name="functionHandle">函数</param>
        /// <param name="param">字段</param>
        /// <returns></returns>
        public static BQLAggregateFunction Count(BQLParamHandle param)
        {
            BQLAggregateFunction item = new BQLAggregateFunction(DBAggregateFunction.DoCount, param);

            item.ValueDbType = DbType.Int32;
            return(item);
        }
Пример #3
0
        //IAggregateFunctions agf = DbAdapterLoader.Aggregate;
        /// <summary>
        /// 总计
        /// </summary>
        /// <param name="functionHandle">函数</param>
        /// <param name="param">字段</param>
        /// <returns></returns>
        public static BQLAggregateFunction Sum(BQLParamHandle param)
        {
            BQLAggregateFunction item = new BQLAggregateFunction(DBAggregateFunction.DoSum, param);

            item.ValueDbType = DbType.Double;
            //item.ValueDataType = DefaultType.DoubleType;
            return(item);
        }
Пример #4
0
        /// <summary>
        /// 最大
        /// </summary>
        /// <param name="functionHandle">函数</param>
        /// <param name="param">字段</param>
        /// <returns></returns>
        public static BQLAggregateFunction Max(BQLParamHandle param)
        {
            BQLAggregateFunction item = new BQLAggregateFunction(DBAggregateFunction.DoMax, param);

            return(item);
        }