public DataTable GetPageList(string selectFileds, string joinstr, string sqlstr, int pageindex, int pagesize)
{
YHFramework.SysModel.PageInfo pages = new YHFramework.SysModel.PageInfo();
pages.PageIndex = pageindex;
pages.PageSize = pagesize;
pages.SqlWhere = sqlstr;
pages.ReturnFileds = "t.*";
pages.TableName = " CodeData ";
pages.JoinTable = joinstr;
pages.CountFields = " a.CodeDataId ";
pages.OrderString = " order by a.CodeDataId ";
pages.SelectFileds = selectFileds;
pages.doCount = 0;
PageHelper p = new PageHelper();
DataTable dt = p.GetList(pages);
return(dt);
}
/// <summary>
/// 分页计算总数
/// </summary>
/// <param name="sqlstr"></param>
/// <param name="joinString"></param>
/// <returns></returns>
public int GetCount(string sqlstr, string joinstr)
{
YHFramework.SysModel.PageInfo pages = new YHFramework.SysModel.PageInfo();
pages.SqlWhere = sqlstr;
pages.ReturnFileds = " * ";
pages.TableName = " CodeData ";
pages.JoinTable = joinstr;
pages.CountFields = " a.CodeDataId ";
pages.OrderString = " ";
pages.SelectFileds = "";
pages.doCount = 1;
PageHelper p = new PageHelper();
DataTable dt = p.GetList(pages);
if (dt.Rows.Count > 0)
{
return(Convert.ToInt32(dt.Rows[0][0].ToString()));
}
else
{
return(0);
}
}
