/// <summary>
/// 获取实体分页
/// </summary>
public DataTable GetReplyMessageList(ReplyMessageTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount)
{
string table = " [ReplyMessage] ";
string pk = " ID ";
string fields = " * ";
string filter = "";// string.Format(" Status={0} ", ConstantsManager.JiLuZhuangTai.Normal);
#region 组织查询条件
//if (!string.IsNullOrEmpty(TO.MC))
//{
// filter += string.Format(" and MC like '%{0}%' ", StringHelper.SQLFilter(TO.MC));
//}
#endregion
string sort = " ID DESC ";//排序
if (!string.IsNullOrEmpty(orderBy))
{
sort = orderBy;
}
SqlParameter[] parameters =
{
new SqlParameter("@Tables", SqlDbType.VarChar, 1000),
new SqlParameter("@PK", SqlDbType.VarChar, 100),
new SqlParameter("@Fields", SqlDbType.VarChar, 1000),
new SqlParameter("@Pageindex", SqlDbType.Int),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@Filter", SqlDbType.VarChar, 1000),
new SqlParameter("@Sort", SqlDbType.VarChar, 200),
new SqlParameter("@RowCount", SqlDbType.Int)
};
parameters[0].Value = table;
parameters[1].Value = pk;
parameters[2].Value = fields;
parameters[3].Value = pageIndex;
parameters[4].Value = pageSize;
parameters[5].Value = filter;
parameters[6].Value = sort;
parameters[7].Direction = ParameterDirection.Output;
DataSet ds = SqlHelper.RunProcedure("SP_DividePage", parameters, "ReplyMessageList");
rowCount = (int)parameters[7].Value;
return(ds.Tables[0]);
}
/// <summary>
/// 获得数据列表分页
/// </summary>
/// <returns></returns>
public DataTable GetReplyMessageList(ReplyMessageTO TO, int pageIndex, int pageSize, string orderBy, out int rowCount)
{
return(service.GetReplyMessageList(TO, pageIndex, pageSize, orderBy, out rowCount));
}
