DBUtility/Utils.cs

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

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

using System;
using System.Collections.Generic;
using System.Web;
using System.Text;
using System.IO;
namespace Maticsoft.DBUtility
{
    public class Utils
    {
       static object obj = new object();
       /// <summary>
       /// 实现分页语句
       /// </summary>
       /// <param name="sql"></param>
       /// <param name="orderby"></param>
       /// <param name="pagesize"></param>
       /// <param name="nextpagecount"></param>
       /// <returns></returns>
       public static string getPageSizeSql(string sql, string orderby, long pagesize, long nextpagecount)
       {
           lock (obj)
           {
               StringBuilder sqlsb = new StringBuilder();
               sqlsb.Append("select top   ");
               sqlsb.Append(pagesize);
               sqlsb.Append("  * from (select ROW_NUMBER()over(order by  ");
               sqlsb.Append(orderby);
               sqlsb.Append(" desc ) as rownum,* from ( ");
               sqlsb.Append(sql);
               sqlsb.Append(") a  )a  where a.rownum not in(select top   ");
               sqlsb.Append(nextpagecount);
               sqlsb.Append(" ROW_NUMBER() over(order by  ");
               sqlsb.Append(orderby);
               sqlsb.Append("  desc) as rownum from (");
               sqlsb.Append(sql);
               sqlsb.Append(") a)");
           return sqlsb.ToString();
           }
       }
       /// <summary>
       /// 得到总记录数
       /// </summary>
       /// <param name="sql"></param>
       /// <returns></returns>
       public static string getSqlCount(string sql)
       {
           lock (obj)
           {
               StringBuilder sqlcountsb = new StringBuilder();
               sqlcountsb.Append("select count(1) as totilecount from (");
               sqlcountsb.Append(sql);
               sqlcountsb.Append(" ) a");
               return sqlcountsb.ToString();
           }
       }
       /// <summary>
       /// 判断是否有下一个菜单
       /// </summary>
       /// <param name="sql"></param>
       /// <returns></returns>