通过EmSqlCommonFn获得查询辅助配置 - DataColumnQueryAssistCreateByEmSqlCommonFn +

2017-02-19 11:26:54 访问(1571) 赞(0) 踩(0)


        /// <summary>
        /// 通过EmSqlCommonFn获得查询辅助配置 - DataColumnQueryAssistCreateByEmSqlCommonFn +
        /// </summary>
        /// <param name="emFn"></param>
        /// <returns></returns>
        public static DataColumnQueryAssist DataColumnQueryAssistCreateByEmSqlCommonFn
            (
                SlowX.Core.Enums.SqlCommonFn.EmSqlCommonFn emFn
            )
        {
            DataColumnQueryAssist theResult = new DataColumnQueryAssist();

            BaseSqlFunction bf = null;
            switch (emFn)
            {
                case SlowX.Core.Enums.SqlCommonFn.EmSqlCommonFn._Count:
                    bf = new BaseSqlFunction(SlowX.Core.Enums.SqlFunction.EmSqlFunction.Count);
                    break;
                case SlowX.Core.Enums.SqlCommonFn.EmSqlCommonFn._Avg:
                    bf = new BaseSqlFunction(SlowX.Core.Enums.SqlFunction.EmSqlFunction.Avg);
                    break;
                case SlowX.Core.Enums.SqlCommonFn.EmSqlCommonFn._Distinct:
                    bf = new BaseSqlFunction(SlowX.Core.Enums.SqlFunction.EmSqlFunction.Distinct);
                    break;
                case SlowX.Core.Enums.SqlCommonFn.EmSqlCommonFn._Max:
                    bf = new BaseSqlFunction(SlowX.Core.Enums.SqlFunction.EmSqlFunction.Max);
                    break;
                case SlowX.Core.Enums.SqlCommonFn.EmSqlCommonFn._Min:
                    bf = new BaseSqlFunction(SlowX.Core.Enums.SqlFunction.EmSqlFunction.Min);
                    break;
                case SlowX.Core.Enums.SqlCommonFn.EmSqlCommonFn._Sum:
                    bf = new BaseSqlFunction(SlowX.Core.Enums.SqlFunction.EmSqlFunction.Sum);
                    break;
                case SlowX.Core.Enums.SqlCommonFn.EmSqlCommonFn.无:
                default:
                    break;
            }

            if (bf != null)
            {
                theResult.leftAddBaseSqlFunction(bf);

            }
         
            return theResult;
        }