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