public int getCount(Model.ViewModel.OtherPageInfo model)
{
StringBuilder sbSI = new StringBuilder();
sbSI.AppendFormat("select * from otherpage Where 1=1 ");
if (!string.IsNullOrEmpty(model.Name))
{
sbSI.AppendFormat(" and Name like '%{0}%'", model.Name);
}
DataTable dtBusiness = DBHelper.SearchSql(sbSI.ToString());
return(dtBusiness.Rows.Count);
}
public System.Data.DataTable getList(Model.ViewModel.OtherPageInfo model)
{
StringBuilder sbSI = new StringBuilder();
sbSI.AppendFormat("select * from otherpage Where 1=1 ");
if (!string.IsNullOrEmpty(model.Name))
{
sbSI.AppendFormat(" and Name like '%{0}%'", model.Name);
}
sbSI.Append(" ORDER BY CreateDate DESC");
sbSI.AppendFormat(" limit {0},{1};", (model.page - 1) * model.rows, model.rows);
DataTable dtOtherPage = DBHelper.SearchSql(sbSI.ToString());
return(dtOtherPage);
}