APCGC_CBS.DAL/Common.cs

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

using APCGC_CBS.DAL.DataAccess;
using System;
using System.Collections.Generic;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace APCGC_CBS.DAL
{
    public static class Common
    {
        /// <summary>
        /// 通用分页存储过程
        /// </summary>
        /// <param name="strColumn">字段</param>
        /// <param name="strViewOrTable">视图OR表名</param>
        /// <param name="strWhere">查询条件</param>
        /// <param name="strOderby">排序字段</param>
        /// <param name="iCurrentPage">当前第几页</param>
        /// <param name="iPageSize">每页大小</param>
        /// <param name="iPageNum">总页数</param>
        /// <param name="iRecordNum">总的记录数</param>
        /// <returns></returns>
        public static DataTable GetDataPager(string strColumn, string strViewOrTable, string strWhere, string strOderby,
            int iCurrentPage, int iPageSize, ref int iPageNum, ref int iRecordNum)
        {
            SqlParameter[] parameters = {
					new SqlParameter("@Columns", SqlDbType.VarChar),
					new SqlParameter("@TableName", SqlDbType.VarChar),
					new SqlParameter("@Condition", SqlDbType.VarChar),
					new SqlParameter("@OrderBy", SqlDbType.VarChar),
					new SqlParameter("@PageNum", SqlDbType.Int),
					new SqlParameter("@PageSize", SqlDbType.Int),
                    new SqlParameter("@PageCount", SqlDbType.Int),
					new SqlParameter("@RecordCount", SqlDbType.Int)};
            parameters[0].Value = strColumn;
            parameters[1].Value = strViewOrTable;
            parameters[2].Value = strWhere;
            parameters[3].Value = strOderby;
            parameters[4].Value = iCurrentPage;
            parameters[5].Value = iPageSize;
            parameters[6].Direction = ParameterDirection.Output;
            parameters[7].Direction = ParameterDirection.Output;

            DataSet ds = DbHelperSQL.RunProcedure("Proc_PageSqlServer", parameters, "ds");
            if (ds != null && ds.Tables[0].Rows.Count > 0)
            {
                iPageNum = (int)parameters[6].Value;
                iRecordNum = (int)parameters[7].Value;
                return ds.Tables[0];
            }
            else
            {
                return null;
            }
        }
    }
}