MESProductionWeb/AntORM/Ant.ORM/MoreSql/MakeOrderBy.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Ant.ORM
{
    public class  OrderByModel
    {
        /// <summary>
        /// 表名
        /// </summary>
        public string TableName { get; set; }

        /// <summary>
        /// 排序
        /// </summary>
        public List<string> StrOrderBy { get; set; }

        /// <summary>
        /// 排序方式
        /// </summary>
        public string SortType { get; set; }
    }
    public class MakeOrderBy
    {
        
        public  List<OrderByModel> OrderByList=new List<OrderByModel>();

        /// <summary>
        /// 升序排序
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="columns"></param>
        /// <returns></returns>
        public MakeOrderBy OrderDesc<T>(params string[] columns)
        {
            var mod = new OrderByModel();
            var tableName = typeof (T).Name;
            mod.TableName = tableName;
            var strlist = new List<string>();
            foreach (var column in columns)
            {
                strlist.Add(column);
            }
            mod.StrOrderBy = strlist;
            mod.SortType = "Desc";
            OrderByList.Add(mod);
            return this;
        }

        /// <summary>
        /// 降序排序
        /// </summary>
        /// <typeparam name="T"></typeparam>
        /// <param name="columns"></param>
        /// <returns></returns>
        public MakeOrderBy OrderAsc<T>(params string[] columns)
        {
            var mod = new OrderByModel();
            var tableName = typeof(T).Name;
            mod.TableName = tableName;
            var strlist = new List<string>();
            foreach (var column in columns)
            {
                strlist.Add(column);
            }
            mod.StrOrderBy = strlist;
            mod.SortType = "asc";
            OrderByList.Add(mod);
            return this;
        }

    }
}