public DataTable GetList(string sqlstr, int pageindex, int pagesize)
{
YHFramework.SysModel.PageInfo pages = new SysModel.PageInfo();
pages.PageIndex = pageindex;
pages.PageSize = pagesize;
pages.SqlWhere = sqlstr;
pages.ReturnFileds = "t.*";
pages.TableName = "BoxNumber";
pages.JoinTable = " ";
pages.CountFields = " a.BoxNumberId ";
pages.OrderString = " order by a.BoxNumberId desc";
pages.SelectFileds = " a.* ";
pages.doCount = 0;
PageHelper p = new PageHelper();
DataTable dt = p.GetList(pages);
return(dt);
}
public int GetCount(string sqlstr, string joinString)
{
YHFramework.SysModel.PageInfo pages = new SysModel.PageInfo();
pages.SqlWhere = sqlstr;
pages.ReturnFileds = "Id";
pages.SqlWhere = sqlstr;
pages.TableName = "BoxNumber";
pages.JoinTable = " ";
pages.CountFields = " a.BoxNumberId ";
pages.OrderString = " ";
pages.SelectFileds = " a.* ";
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);
}
}
