BaseConfig/BaseDAL.cs

(完整代码) 2KB

using System;
using System.Data;
using System.Data.SqlClient;
using BaseDBUtility;

namespace BaseConfig.BaseDAL
{
    public class Pager
    {
        /// <summary>
        /// 标准分页
        /// </summary>
        /// <param name="PageSize"></param>
        /// <param name="PageIndex"></param>
        /// <param name="strWhere"></param>
        /// <param name="orderby"></param>
        /// <param name="tablename"></param>
        /// <param name="cols"></param>
        /// <returns></returns>
        public static DataTable GetPager(int PageSize, int PageIndex, string strWhere, string orderby, string tablename, string cols)
        {
            using (SqlDataAdapter sda = new SqlDataAdapter())
            {
                SqlParameter[] pa = new SqlParameter[6];
                pa[0] = new SqlParameter("@PageSize", PageSize);
                pa[1] = new SqlParameter("@PageIndex", PageIndex);
                pa[2] = new SqlParameter("@orderby", orderby);
                pa[3] = new SqlParameter("@strWhere", strWhere);
                pa[4] = new SqlParameter("@tablename", tablename);
                pa[5] = new SqlParameter("@cols", cols);
                sda.SelectCommand = DbHelperSQL.GetCommand(PubConstant.GetConnectionString("conn_second"), "UP_T_GetPager", pa);
                using (DataSet ds = new DataSet())
                {
                    sda.Fill(ds);
                    return ds.Tables[0];
                }
            }
        }

        /// <summary>
        /// 获取所有符合条件的数量
        /// </summary>
        /// <param name="strWhere"></param>
        /// <returns></returns>
        public static int GetAllCount(string strWhere, string tablename)
        {
            string sql = "UP_T_GetCount";
            SqlParameter[] param = new SqlParameter[]
            {
                new SqlParameter("@strWhere",strWhere),
                new SqlParameter("@tablename",tablename)
            };
            return Convert.ToInt32(DbHelperSQL.ExecuteScalar(PubConstant.GetConnectionString("conn_second"), CommandType.StoredProcedure, sql, param));
        }
    }
}

24 小时内免费解锁 3 个项目,之后 1 算力/个。 规则说明

AI 解读 AI

登录后可用,每次 10 算力,解读结果公开显示在下面。

还没有人解读过这个文件。