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