﻿namespace ToolGood.ReadyGo3.Enums
{
    /// <summary>
    /// SQL函数
    /// </summary>
    public enum SqlFunction
    {
        /// <summary>
        /// 使用自定义函数
        /// </summary>
        Fuction,
        /// <summary>
        /// 求长度
        /// </summary>
        Len,
        ///// <summary>
        ///// 求最大值 
        ///// </summary>
        //Max,
        ///// <summary>
        ///// 求最小值 
        ///// </summary>
        //Min,
        ///// <summary>
        ///// 求平均值
        ///// </summary>
        //Avg,
        ///// <summary>
        ///// 求和
        ///// </summary>
        //Sum,
        ///// <summary>
        ///// 求个数
        ///// </summary>
        //Count,
        ///// <summary>
        ///// 求不重复的个数
        ///// </summary>
        //CountDistinct,
        ///// <summary>
        ///// 求时间格式
        ///// </summary>
        //DatePart,
        ///// <summary>
        ///// 求日期差
        ///// </summary>
        //DateDiff,
        /// <summary>
        /// 求年份
        /// </summary>
        Year,
        /// <summary>
        /// 求月份
        /// </summary>
        Month,
        /// <summary>
        /// 天
        /// </summary>
        Day,
        /// <summary>
        /// 时
        /// </summary>
        Hour,
        /// <summary>
        /// 分
        /// </summary>
        Minute,
        /// <summary>
        /// 秒
        /// </summary>
        Second,
        /// <summary>
        /// 求天数
        /// </summary>
        DayOfYear,
        ///// <summary>
        ///// 该函数返回日期的星期数
        ///// </summary>
        //Week,
        /// <summary>
        /// 返回日期的星期索引(0=周一，1=周二，6=星期日)。
        /// </summary>
        WeekDay,
        /// <summary>
        /// 截取字符串
        /// </summary>
        SubString3,
        /// <summary>
        /// 截取字符串
        /// </summary>
        SubString2,
        ///// <summary>
        ///// 截取字符串左边
        ///// </summary>
        //Left,
        ///// <summary>
        ///// 截取字符串右边
        ///// </summary>
        //Right,
        /// <summary>
        /// 小写字母
        /// </summary>
        Lower,
        /// <summary>
        /// 大写字母
        /// </summary>
        Upper,
        ///// <summary>
        ///// 求Ascii码
        ///// </summary>
        //Ascii,
        /// <summary>
        /// 字符串拼接
        /// </summary>
        Concat,
        /// <summary>
        /// 删除前导或尾随空格
        /// </summary>
        Trim,
        /// <summary>
        /// 删除前导空格
        /// </summary>
        LTrim,
        /// <summary>
        /// 删除尾随空格
        /// </summary>
        RTrim,
        /// <summary>
        /// 索引
        /// </summary>
        IndexOf,
        /// <summary>
        /// 替换
        /// </summary>
        Replace,
    }
}
