/// <summary> /// 分页获取数据列表 /// </summary> public DataSet GetList(int PageSize,int PageIndex,string strWhere) { SqlParameter[] parameters = { new SqlParameter("@tblName", SqlDbType.VarChar, 255),//表明 new SqlParameter("@fldName", SqlDbType.VarChar, 255),//主键 new SqlParameter("@PageSize", SqlDbType.Int), new SqlParameter("@PageIndex", SqlDbType.Int), new SqlParameter("@IsReCount", SqlDbType.Bit),//返回记录总数, 非 0 值则返回 new SqlParameter("@OrderType", SqlDbType.Bit),//设置排序类型, 非 0 值则降序 new SqlParameter("@strWhere", SqlDbType.VarChar,1000), }; parameters[0].Value = "tb_Expert"; parameters[1].Value = "ExpertID"; parameters[2].Value = PageSize; parameters[3].Value = PageIndex; parameters[4].Value = 0; parameters[5].Value = 0; parameters[6].Value = strWhere; return DbHelperSQL.RunProcedure("UP_GetRecordByPage",parameters,"ds"); }