BaseConfig/BaseDAL.cs
(完整代码) 2KBusing 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 算力,解读结果公开显示在下面。
还没有人解读过这个文件。