排序管理器

一个管理排序的类,支持多排序。
    环境:.NET,C#
    /// <summary>
    /// 排序管理器
    /// </summary>
    public class DBOrderByOpt
    {
        protected struct ____Task____
        {
            public string fieldName;
            public bool ASC;
            public ____Task____(string fieldName, bool ASC)
            {
                this.fieldName = fieldName;
                this.ASC = ASC;
            }
        };
        private IList<____Task____> orderByData;
        /// <summary>
        /// 默认构造函数
        /// </summary>
        public DBOrderByOpt()
        {
            orderByData = new List<____Task____>();
        }
        /// <summary>
        /// 增加排序字段并调整字段优先级
        /// </summary>
        public void AddChg(string fieldName)
        {
            bool asc = true;
            foreach (____Task____ data in orderByData)
            {
                if (data.fieldName.Trim() == fieldName.Trim())
                {
                    asc = !data.ASC;
                    orderByData.Remove(data);
                    break;
                }
            }
            orderByData.Add(new ____Task____(fieldName.Trim(), asc));
        }
        /// <summary>
        /// 增加排序字段但保持字段优先级
        /// </summary>
        public void AddUnChg(string fieldName)
        {
            int i = 0;
            bool asc = true;
            for (; i < orderByData.Count; i++)
            {
                if (orderByData.fieldName.Trim() == fieldName.Trim())
                {
                    asc = !orderByData.ASC;
                    orderByData.Remove(orderByData);
                    break;
                }
            }
            orderByData.Insert(i, new ____Task____(fieldName.Trim(), asc));
        }
        /// <summary>
        /// 获取正向排序字符串
        /// </summary>
        public string ToOrderString()
        {
            string orderStr = "";
            for (int i = 0; i < orderByData.Count; i++)
            {
                if (orderByData.ASC)
                    orderStr += orderByData.fieldName + " asc, ";
                else
                    orderStr += orderByData.fieldName + " desc, ";
            }
            if (orderStr.Trim() == "")
                return "";
            else
                return orderStr.Substring(0, orderStr.Length - 2);
        }
        /// <summary>
        /// 获取反向排序字符串
        /// </summary>
        public string ToReOrderString()
        {
            string orderStr = "";
            for (int i = orderByData.Count - 1; i >= 0; i--)
            {
                if (orderByData.ASC)
                    orderStr += orderByData.fieldName + " asc, ";
                else
                    orderStr += orderByData.fieldName + " desc, ";
            }
            if (orderStr.Trim() == "")
                return "";
            else
                return orderStr.Substring(0, orderStr.Length - 2);
        }
    }

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值