public int getCount(Model.ViewModel.ImageManageViewModel model)
{
StringBuilder sbSI = new StringBuilder();
sbSI.AppendFormat("select * from ImageManage Where 1=1 ");
if (!string.IsNullOrEmpty(model.ImageName))
{
sbSI.AppendFormat(" and ImageName like '%{0}%'", model.ImageName);
}
DataTable dtBusiness = DBHelper.SearchSql(sbSI.ToString());
return(dtBusiness.Rows.Count);
}
public System.Data.DataTable getList(Model.ViewModel.ImageManageViewModel model)
{
StringBuilder sbSI = new StringBuilder();
sbSI.AppendFormat("select * from ImageManage Where 1=1 ");
if (!string.IsNullOrEmpty(model.ImageName))
{
sbSI.AppendFormat(" and ImageName like '%{0}%'", model.ImageName);
}
sbSI.AppendFormat(" limit {0},{1};", (model.page - 1) * model.rows, model.rows);
DataTable dtFootLink = DBHelper.SearchSql(sbSI.ToString());
return(dtFootLink);
}
