WebPortal_Lib/01.Lib/com/constant/common/SQLConstant.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Web;

namespace com.constant.common
{
    /// <summary>
    /// SQLConstant：包含与查询Sql相关的一些参数
    /// </summary>
    public class SQLConstant
    {
        #region 排序字符串,其中a为主表的别名

        #region 排序字符串,建立时间_倒序
        /// <summary>
        /// orderstring_createtime_desc
        /// </summary>
        public static string orderstring_createtime_desc = " order by a.createtime desc ";
        #endregion

        #region 排序字符串,建立时间_正序
        /// <summary>
        /// 排序字符串,建立时间_正序，orderstring_createtime_asc
        /// </summary>
        public static string orderstring_createtime_asc = " order by a.createtime asc ";
        #endregion

        #region 排序字符串,修改时间_倒序
        /// <summary>
        /// orderstring_updatetime_desc
        /// </summary>
        public static string orderstring_updatetime_desc = " order by a.updatetime desc ";
        #endregion

        #region 排序字符串,修改时间_正序
        /// <summary>
        /// 排序字符串,修改时间_正序，orderstring_updatetime_asc
        /// </summary>
        public static string orderstring_updatetime_asc = " order by a.updatetime asc ";
        #endregion

        #region 排序字符串,显示序号_正序
        /// <summary>
        /// 排序字符串,显示序号_正序，orderstring_sortid_asc
        /// </summary>
        public static string orderstring_sortid_asc = " order by a.sortid asc ";
        #endregion

        #region 排序字符串,显示序号_倒序
        /// <summary>
        /// 排序字符串,显示序号_倒序，orderstring_sortid_desc
        /// </summary>
        public static string orderstring_sortid_desc = " order by a.sortid desc ";
        #endregion

        #region 排序字符串,点击数量_倒序
        /// <summary>
        /// 排序字符串,点击数量_倒序，orderstring_clicknum_desc
        /// </summary>
        public static string orderstring_clicknum_desc = " order by a.clicknum desc ";