asp.net 操作带输入输出参数的分页存储过程（四）

最新推荐文章于 2018-08-02 16:52:13 发布

Mellee

最新推荐文章于 2018-08-02 16:52:13 发布

阅读量419

点赞数

分类专栏： WEB编程

本文链接：https://blog.csdn.net/mellee/article/details/74018610

版权

WEB编程专栏收录该内容

6 篇文章 0 订阅

订阅专栏

# C# 代码调用方法，这部分代码放在表示层，最外围调用

 int pagecount = 0;
 int recordcount = 0;
  try
  {
      System.Collections.Generic.IList<NewsEntity> new = Mellee.TopSource.Module.NewsLogic.ShowNewsList("GetSplitPage","mellee_news","id","*",1,1,"[updatetimes] desc"," ",ref pagecount,ref recordcount);    
      foreach (NewsEntity li in ne)
      {
           Tools.Response.Write(recordcount + "<br />" + pagecount + "<br />" + li.updatetimes + "<br />");///输出结果
      }
      Tools.Response.Write(CustomErrors.ErrDescription);///自定义错误输出
 }
//catch
{
     Tools.Response.Write(CustomErrors.ErrDescription);///自定义错误输出
｝

/// <summary>
/// 业务逻辑
/// </summary>
/// <param name="spname">存储过程名</param>
/// <param name="tabname">表名</param>
/// <param name="prikey">主键</param>
/// <param name="fieldname">字段列表</param>
/// <param name="pagesize">页记录数</param>
/// <param name="pageindex">当前页码</param>
/// <param name="sortname">排序字段</param>
/// <param name="condition">搜索条件</param>
/// <param name="pagecount">页大小</param>
/// <param name="recordcount">记录总数</param>
/// <returns></returns>
public static IList<NewsEntity> ShowNewsList(string spname, string tabname, string prikey, string fieldname, int pagesize, int pageindex, string sortname, string condition, ref int pagecount, ref int recordcount)
 {
     SqlParameter[] sp =
     {
         new SqlParameter("curpage",pageindex), 
         new SqlParameter("pagesize",pagesize),
         new SqlParameter("prikey",prikey),
         new SqlParameter("tabname",tabname),
         new SqlParameter("fldname",fieldname),
         new SqlParameter("condition",condition),
         new SqlParameter("sortname",sortname),
         new SqlParameter("recordcount",recordcount),
         };
         sp[7].Direction = ParameterDirection.Output;
         return NewsDAL.ShowNewsList(spname, pagesize, ref pagecount, ref recordcount, sp);             
}