/// <summary> /// 多表存储过程查询 /// </summary> /// <typeparam name="T"></typeparam> /// <param name="tblName"></param> /// <param name="strGetFields"></param> /// <param name="OrderfldName"></param> /// <param name="strWhere"></param> /// <param name="PageSize"></param> /// <param name="PageIndex"></param> /// <param name="OrderType"></param> /// <returns></returns> public ProcDataAndTotal <T> GetProcData <T>(string tblName, string strGetFields, string OrderfldName, string strWhere, int PageSize, int PageIndex, bool OrderType) where T : class, new() { using (IDbConnection conn = new SqlConnection() { ConnectionString = connectionString }) { DynamicParameters param = new DynamicParameters(); param.Add("@tblName", tblName); param.Add("@strGetFields", strGetFields); param.Add("@OrderfldName", OrderfldName); param.Add("@strWhere", strWhere); param.Add("@PageSize", PageSize); param.Add("@PageIndex", PageIndex); param.Add("@OrderType", OrderType); param.Add("@doCount", 0, DbType.Int32, ParameterDirection.Output); //返回的类 ProcDataAndTotal <T> dataAndTotal = new ProcDataAndTotal <T>() { ProcData = conn.Query <T>("Proc_MultipleTablesPager", param, commandType: CommandType.StoredProcedure).ToList(), Total = param.Get <int>("@doCount"), }; return(dataAndTotal); } }
/// <summary> /// 单表存储过程查询 /// </summary> /// <typeparam name="T">接收数据的类</typeparam> /// <param name="TableName">要查询的表名</param> /// <param name="ReFieldsStr">显示的字段</param> /// <param name="OrderString">排序的字段</param> /// <param name="WhereString">查询的条件</param> /// <param name="PageSize">页数</param> /// <param name="PageIndex">页码</param> /// <returns></returns> public ProcDataAndTotal <T> GetProcData <T>(string TableName, string ReFieldsStr, string OrderString, string WhereString, int PageSize, int PageIndex) where T : class, new() { using (IDbConnection conn = new SqlConnection() { ConnectionString = connectionString }) { DynamicParameters param = new DynamicParameters(); param.Add("@TableName", TableName); param.Add("@ReFieldsStr", ReFieldsStr); param.Add("@OrderString", OrderString); param.Add("@WhereString", WhereString); param.Add("@PageSize", PageSize); param.Add("@PageIndex", PageIndex); param.Add("@TotalRecord", 0, DbType.Int32, ParameterDirection.Output); //返回的类 ProcDataAndTotal <T> dataAndTotal = new ProcDataAndTotal <T>() { ProcData = conn.Query <T>("Proc_SingleTablePager", param, commandType: CommandType.StoredProcedure).ToList(), Total = param.Get <int>("@TotalRecord"), }; return(dataAndTotal); } }