# 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);
}