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

namespace Ant.ORM
{
    public class ConstSql
    {
       
        /// <summary>
        /// SQL分页模板
        /// </summary>
        public const string SQL_PageTemplate = "SELECT {0} FROM (SELECT ROW_NUMBER() OVER(order by {1}) AS RowNumber, {2}) as tmp_tbl where RowNumber BETWEEN @pageStart and @pageEnd ";

        /// <summary>
        /// 删除指定表指定字段值的数据
        /// </summary>
        public const string SQL_DELETE_DATA = "DELETE FROM [{0}] WHERE 1=1 {1}";

        /// <summary>
        /// 提取指定表指定字段的数据
        /// </summary>
        public const string SQL_GET_VALUE = "SELECT {0} {1} FROM [{2}] with(nolock) WHERE 1=1";

        /// <summary>
        /// 根据条件提取表
        /// </summary>
        public const string SQL_GET_TABLE = "SELECT * FROM {0} WHERE {1}='{2}'";

        /// <summary>
        /// 插入数据SQL语句模板
        /// </summary>
        public const string SQL_INSERT_TABLE = "INSERT INTO [{0}] ({1}) VALUES ({2});{3}";
        /// <summary>
        /// 更新SQL语句模板
        /// </summary>
        public const string SQL_UPDATE_TABLE = " UPDATE [{0}] SET {1} WHERE {2} ";

        /// <summary>
        /// 获取自增长ID
        /// </summary>
        public const string SQL_SCOPE_IDENTITY = "select SCOPE_IDENTITY() as id";
        /// <summary>
        /// SQL备注
        /// </summary>
        public const string SQL_WITH_COMMENT = "--Platform;{0}/Author;{1}/Description;{2}/FileName:{3}/MethodName:{4}/ClassName:{5}";


        /// <summary>
        /// 提取指定表指定字段的数据
        /// </summary>
        public const string MYSQL_GET_VALUE = "SELECT  {0} FROM [{1}]  WHERE 1=1  ";
        /// <summary>
        /// MYSQL分页SQL
        /// </summary>
        public const string MYSQL_PAGE_VALUE = "SELECT {0} FROM {1} WHERE {2} {3} LIMIT {4},{5}";


    }
}