/// <summary>
/// 获取总条数
/// </summary>
/// <param name="condition"></param>
/// <returns></returns>
public int getSecondLevelDirCount(SecondMenuQuery condition)
{
int result = 0;
try
{
DirDbContext context = new DirDbContext();
var sql = context.secondLevels.Where(x => x.activityFlag == 1);
sql = string.IsNullOrEmpty(condition.title) ? sql : sql.Where(x => x.title == condition.title);
sql = condition.firstLevelID == 0 ? sql : sql.Where(x => x.firstLevelId == condition.firstLevelID);
result = sql.Count();
}
catch (Exception)
{
}
return(result);
}
/// <summary>
/// 根据动态条件获取所有2级菜单集合
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public Result <List <SecondLevel> > getSecondLevelDir(Pager <List <SecondLevel> > pager, SecondMenuQuery condition)
{
Result <List <SecondLevel> > result = new Result <List <SecondLevel> >();
try
{
DirDbContext context = new DirDbContext();
var sql = context.secondLevels.Where(x => x.activityFlag == 1);
int start = (pager.page - 1) * pager.recPerPage;
sql = string.IsNullOrEmpty(condition.title) ? sql : sql.Where(x => x.title == condition.title);
sql = condition.firstLevelID == 0 ? sql : sql.Where(x => x.firstLevelId == condition.firstLevelID);
sql = sql.OrderBy(x => x.orderId).ThenBy(x => x.title).Skip(start).Take(pager.recPerPage);
result.data = sql.ToList();
}
catch (Exception err)
{
result.addError(err.Message);
}
return(result);
}
/// <summary>
/// search
/// </summary>
/// <param name="model"></param>
/// <param name="pager"></param>
/// <returns></returns>
public async Task <ActionResult> searchSecondLevelDir(Pager <List <SecondLevel> > pager, SecondMenuQuery condition)
{
ViewBag.Condition = condition;
var result = await layer.getSecondLevelDir(pager, condition);
if (result.success)
{
return(View("Index", pager));
}
else
{
ViewBag.ReturnUrl = "/SecondLevelDir/Index";
ViewBag.Msg = result.message;
return(View("Error"));
}
}
/// <summary>
/// 通过条件进行查询
/// </summary>
/// <param name="pager"></param>
/// <returns></returns>
public async Task <Result <Pager <List <SecondLevel> > > > getSecondLevelDir(Pager <List <SecondLevel> > pager, SecondMenuQuery condition)
{
Result <Pager <List <SecondLevel> > > result = new Result <Pager <List <SecondLevel> > >();
Result <List <SecondLevel> > result_data = await Task.Factory.StartNew(() => dao.getSecondLevelDir(pager, condition));
if (result_data.success)
{
pager.data = result_data.data;
pager.recTotal = await Task.Factory.StartNew(() => dao.getSecondLevelDirCount(condition));
}
else
{
result.addError(result_data.message);
}
return(result);
}
public ActionResult Index(Pager <List <SecondLevel> > pager, SecondMenuQuery model)
{
ViewBag.Condition = model;
return(View(pager));
}
