DAL/TCWL_D_Loglog.cs

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

namespace DAL
{
    using Common;
    using System;
    using System.Data;
    using System.Runtime.InteropServices;
    using System.Text;

    public class TCWL_D_Loglog
    {
        public DataTable GetListByPage(string strWhere, string orderby, int startIndex, int endIndex, out int total)
        {
            StringBuilder builder = new StringBuilder();
            builder.Append("SELECT * FROM ( ");
            builder.Append(" SELECT ROW_NUMBER() OVER (");
            if (!string.IsNullOrEmpty(orderby.Trim()))
            {
                builder.Append("order by T." + orderby);
            }
            else
            {
                builder.Append("order by T.timeStr desc");
            }
            builder.Append(")AS Row, T.ID,T.doSomething,T.userID,T.serviceID,CONVERT(varchar(16) , T.timeStr, 20) as timeStr,T.ip,u.userXM as UserXM from TCWL_Log  T left join TCWL_User u on u.userName = T.userID ");
            if (!string.IsNullOrEmpty(strWhere.Trim()))
            {
                builder.Append(" WHERE " + strWhere);
            }
            builder.Append(" ) TT");
            DataSet set = DBHelper.Query(builder.ToString());
            total = set.Tables[0].Rows.Count;
            builder.AppendFormat(" WHERE TT.Row between {0} and {1}", startIndex, endIndex);
            return DBHelper.Query(builder.ToString()).Tables[0];
        }
    }
}