/// <summary> /// 操作日志数据列表 /// </summary> /// <param name="search">查询搜索条件</param> /// <returns></returns> public ActionResult List(SearchHelperModel search) { Expression <Func <OperationLog, bool> > whereLambda = (l => true); if (!string.IsNullOrWhiteSpace(search.SearchItem1)) // 日志模块名称 { whereLambda = whereLambda.And((l => l.LogModule == search.SearchItem1.Trim())); } if (!string.IsNullOrWhiteSpace(search.SearchItem2)) // 日志内容 { whereLambda = whereLambda.And(l => l.LogContent.Contains(search.SearchItem2.Trim())); } try { var logList = operationLogHelper.Paged(search.PageIndex, search.PageSize, whereLambda, l => l.OperTime, false); var dataList = logList.ToPagedList(); return(View(dataList)); } catch (Exception ex) { Logger.Error("ex"); throw ex; } }
/// <summary> /// 预约记录数据页 /// </summary> /// <param name="search"></param> /// <returns></returns> public ActionResult ReservationList(SearchHelperModel search) { Expression <Func <Reservation, bool> > whereLambda = (m => DbFunctions.DiffDays(DateTime.Today, m.ReservationForDate) <= 7 && DbFunctions.DiffDays(DateTime.Today, m.ReservationForDate) >= 0); var rowsCount = 0; //补充查询条件 //根据预约日期查询 if (!String.IsNullOrEmpty(search.SearchItem0)) { whereLambda = (m => DbFunctions.DiffDays(DateTime.Parse(search.SearchItem0), m.ReservationForDate) == 0); } //根据预约人联系方式查询 if (!String.IsNullOrEmpty(search.SearchItem1)) { whereLambda = (m => m.ReservationPersonPhone.Contains(search.SearchItem1)); } //load data var list = new BLLReservation().GetReservationList(search.PageIndex, search.PageSize, out rowsCount, whereLambda, m => m.ReservationForDate, m => m.ReservationTime, false, false); var dataList = list.ToPagedList(search.PageIndex, search.PageSize, rowsCount); return(View(dataList)); }
/// <summary> /// 加载系统设置数据 /// </summary> /// <param name="search">分页信息,查询条件</param> /// <returns></returns> public ActionResult List(SearchHelperModel search) { //默认查询所有 Expression <Func <SystemSettings, bool> > whereLambda = (s => true); if (!string.IsNullOrEmpty(search.SearchItem1)) { whereLambda = (s => s.SettingName.Contains(search.SearchItem1)); } var settingsList = _systemSettingHelper.Paged(search.PageIndex, search.PageSize, whereLambda, s => s.SettingName); var data = settingsList.ToPagedList(); return(View(data)); }
public ActionResult UserListTable(SearchHelperModel search) { //默认查询所有 Expression <Func <User, bool> > whereLambda = (u => u.IsSuper == false); if (!string.IsNullOrEmpty(search.SearchItem1)) { whereLambda = (u => u.UserName.Contains(search.SearchItem1) && u.IsSuper == false); } var pageList = _bLLUser.Paged(search.PageIndex, search.PageSize, whereLambda, u => u.AddTime, false); var data = pageList.ToPagedList(); return(View(data)); }
public ActionResult UserListTable(SearchHelperModel search) { //默认查询所有 Expression <Func <User, bool> > whereLambda = (u => u.IsSuper == false); if (!String.IsNullOrEmpty(search.SearchItem1)) { whereLambda = (u => u.UserName.Contains(search.SearchItem1) && u.IsSuper == false); } var rowsCount = 0; var userList = BusinessHelper.UserHelper.GetPagedList(search.PageIndex, search.PageSize, out rowsCount, whereLambda, u => u.AddTime, false); var data = userList.ToPagedList(search.PageIndex, search.PageSize, rowsCount); return(View(data)); }
/// <summary> /// 加载系统设置数据 /// </summary> /// <param name="search">分页信息,查询条件</param> /// <returns></returns> public ActionResult List(SearchHelperModel search) { //默认查询所有 Expression <Func <SystemSettings, bool> > whereLambda = (s => 1 == 1); var rowsCount = 0; if (!String.IsNullOrEmpty(search.SearchItem1)) { whereLambda = (s => s.SettingName.Contains(search.SearchItem1)); } var settingsList = BusinessHelper.SystemSettingsHelper.GetPagedList(search.PageIndex, search.PageSize, out rowsCount, whereLambda, s => s.SettingName); var data = settingsList.ToPagedList(search.PageIndex, search.PageSize, rowsCount); return(View(data)); }
/// <summary> /// 预约记录数据页 /// </summary> /// <param name="search"></param> /// <returns></returns> public ActionResult ReservationList(SearchHelperModel search) { Expression <Func <Reservation, bool> > whereLambda = (m => true); //补充查询条件 //根据预约日期查询 if (!string.IsNullOrWhiteSpace(search.SearchItem0)) { whereLambda = m => EF.Functions.DateDiffDay(DateTime.Parse(search.SearchItem0), m.ReservationForDate) == 0; } //根据预约人联系方式查询 if (!string.IsNullOrWhiteSpace(search.SearchItem1)) { whereLambda = m => m.ReservationPersonPhone == search.SearchItem1.Trim(); } //load data var list = _reservationBLL.GetPagedListResult( x => new ReservationListViewModel { ReservationForDate = x.ReservationForDate, ReservationForTime = x.ReservationForTime, ReservationId = x.ReservationId, ReservationUnit = x.ReservationUnit, ReservationTime = x.ReservationTime, ReservationPlaceName = x.Place.PlaceName, ReservationActivityContent = x.ReservationActivityContent, ReservationPersonName = x.ReservationPersonName, ReservationPersonPhone = x.ReservationPersonPhone, ReservationStatus = x.ReservationStatus, }, queryBuilder => queryBuilder .WithPredict(whereLambda) .WithOrderBy(query => query.OrderByDescending(r => r.ReservationForDate).ThenByDescending(r => r.ReservationTime)) .WithInclude(query => query.Include(r => r.Place)) , search.PageIndex, search.PageSize); var dataList = list.ToPagedList(); return(View(dataList)); }
/// <summary> /// 公告列表 /// </summary> /// <param name="search">查询信息</param> /// <returns></returns> public ActionResult List([FromQuery] SearchHelperModel search) { Expression <Func <Notice, bool> > whereExpression = (n => true); if (!string.IsNullOrEmpty(search.SearchItem1)) { whereExpression = n => n.NoticeTitle.Contains(search.SearchItem1); } try { var list = _bLLNotice.Paged(search.PageIndex, search.PageSize, whereExpression, n => n.NoticePublishTime, false); return(View(list.ToPagedList())); } catch (Exception ex) { Logger.Error(ex); throw; } }
/// <summary> /// 公告列表 /// </summary> /// <param name="search">查询信息</param> /// <returns></returns> public ActionResult List(SearchHelperModel search) { Expression <Func <Notice, bool> > whereLamdba = (n => n.IsDeleted == false); if (!string.IsNullOrEmpty(search.SearchItem1)) { whereLamdba = n => n.IsDeleted == false && n.NoticeTitle.Contains(search.SearchItem1); } try { var list = _bLLNotice.Paged(search.PageIndex, search.PageSize, whereLamdba, n => n.NoticePublishTime, false); return(View(list.Data.ToPagedList(search.PageIndex, search.PageSize, list.TotalCount))); } catch (Exception ex) { Logger.Error(ex); throw; } }
/// <summary> /// 预约信息列表 /// </summary> /// <param name="search">搜索查询条件</param> /// <returns></returns> public ActionResult List(SearchHelperModel search) { Expression <Func <Reservation, bool> > whereLambda = (m => true); //根据预约人联系方式查询 if (!string.IsNullOrEmpty(search.SearchItem1)) { whereLambda = (m => m.ReservationPersonPhone.Contains(search.SearchItem1)); } //类别,加载全部还是只加载待审核列表 if (!string.IsNullOrEmpty(search.SearchItem2) && search.SearchItem2.Equals("1")) { // } else { whereLambda = whereLambda.And(m => m.ReservationStatus == 0); } //load data var list = _reservationHelper.GetPagedListResult( x => new ReservationListViewModel { ReservationForDate = x.ReservationForDate, ReservationForTime = x.ReservationForTime, ReservationId = x.ReservationId, ReservationUnit = x.ReservationUnit, ReservationTime = x.ReservationTime, ReservationPlaceName = x.Place.PlaceName, ReservationActivityContent = x.ReservationActivityContent, ReservationPersonName = x.ReservationPersonName, ReservationPersonPhone = x.ReservationPersonPhone, ReservationStatus = x.ReservationStatus, }, queryBuilder => queryBuilder .WithPredict(whereLambda) .WithOrderBy(query => query.OrderByDescending(r => r.ReservationForDate).ThenByDescending(r => r.ReservationTime)) .WithInclude(query => query.Include(r => r.Place)) , search.PageIndex, search.PageSize); var dataList = list.ToPagedList(); return(View(dataList)); }
/// <summary> /// 公告列表 /// </summary> /// <returns></returns> public ActionResult NoticeList(SearchHelperModel search) { Expression <Func <Notice, bool> > whereLamdba = (n => !n.IsDeleted && n.CheckStatus); if (!string.IsNullOrEmpty(search.SearchItem1)) { whereLamdba = whereLamdba.And(n => n.NoticeTitle.Contains(search.SearchItem1.Trim())); } try { var noticeList = HttpContext.RequestServices.GetService <IBLLNotice>().Paged(search.PageIndex, search.PageSize, whereLamdba, n => n.NoticePublishTime, false); var data = noticeList.ToPagedList(); return(View(data)); } catch (Exception ex) { Logger.Error(ex); throw; } }
/// <summary> /// 数据视图 /// </summary> /// <param name="search"></param> /// <returns></returns> public ActionResult List(SearchHelperModel search) { //默认查询全部 Expression <Func <BlockEntity, bool> > whereLambda = (b => true); //判断查询条件 if (!string.IsNullOrEmpty(search.SearchItem1) && !("0".Equals(search.SearchItem1))) { var id = Guid.Parse(search.SearchItem1); if (!string.IsNullOrEmpty(search.SearchItem2)) { whereLambda = (b => b.BlockTypeId == id && b.BlockValue.Contains(search.SearchItem2)); } else { whereLambda = (b => b.BlockTypeId == id); } } else { if (!string.IsNullOrEmpty(search.SearchItem2)) { whereLambda = (b => b.BlockValue.Contains(search.SearchItem2)); } } var rowsCount = 0; try { var blockList = BusinessHelper.BlockEntityHelper.GetPagedList(search.PageIndex, search.PageSize, out rowsCount, whereLambda, b => b.BlockTime, false); var dataList = blockList.ToPagedList(search.PageIndex, search.PageSize, rowsCount); return(View(dataList)); } catch (Exception ex) { Logger.Error(ex); throw; } }
/// <summary> /// 操作日志数据列表 /// </summary> /// <param name="search">查询搜索条件</param> /// <returns></returns> public ActionResult List(SearchHelperModel search) { Expression <Func <OperationLog, bool> > whereLambda = (l => 1 == 1); //日志模块名称 if (!string.IsNullOrEmpty(search.SearchItem1)) { //日志内容 if (!string.IsNullOrEmpty(search.SearchItem2)) { whereLambda = (l => l.LogContent.Contains(search.SearchItem2) && l.LogModule.Contains(search.SearchItem1)); } else { whereLambda = (l => l.LogModule.Contains(search.SearchItem1)); } } else { if (!string.IsNullOrEmpty(search.SearchItem2)) { whereLambda = (l => l.LogContent.Contains(search.SearchItem2)); } } var rowsCount = 0; try { var logList = BusinessHelper.OperationLogHelper.GetPagedList(search.PageIndex, search.PageSize, out rowsCount, whereLambda, l => l.OperTime, false); var dataList = logList.ToPagedList(search.PageIndex, search.PageSize, rowsCount); return(View(dataList)); } catch (Exception ex) { Logger.Error("ex"); throw ex; } }
/// <summary> /// 数据视图 /// </summary> /// <param name="search"></param> /// <returns></returns> public ActionResult List(SearchHelperModel search) { //默认查询全部 Expression <Func <BlockEntity, bool> > whereLambda = (b => true); //判断查询条件 if (!string.IsNullOrEmpty(search.SearchItem1) && !("0".Equals(search.SearchItem1))) { var id = Guid.Parse(search.SearchItem1); if (!string.IsNullOrEmpty(search.SearchItem2)) { whereLambda = (b => b.BlockTypeId == id && b.BlockValue.Contains(search.SearchItem2)); } else { whereLambda = (b => b.BlockTypeId == id); } } else { if (!string.IsNullOrEmpty(search.SearchItem2)) { whereLambda = (b => b.BlockValue.Contains(search.SearchItem2)); } } try { var blockList = _blockEntityHelper.GetPagedList(queryBuilder => queryBuilder .WithPredict(whereLambda) .WithInclude(q => q.Include(b => b.BlockType)) .WithOrderBy(q => q.OrderByDescending(b => b.BlockTime)), search.PageIndex, search.PageSize); var dataList = blockList.ToPagedList(); return(View(dataList)); } catch (Exception ex) { Logger.Error(ex); throw; } }
/// <summary> /// 公告列表 /// </summary> /// <returns></returns> public async Task <ActionResult> NoticeList(SearchHelperModel search, [FromServices] IBLLNotice noticeService) { Expression <Func <Notice, bool> > whereExpression = (n => !n.IsDeleted && n.CheckStatus); if (!string.IsNullOrEmpty(search.SearchItem1)) { whereExpression = whereExpression.And(n => n.NoticeTitle.Contains(search.SearchItem1.Trim())); } try { var noticeList = await noticeService.PagedAsync(search.PageIndex, search.PageSize, whereExpression, n => n.NoticePublishTime, false); var data = noticeList.ToPagedList(); return(View(data)); } catch (Exception ex) { Logger.Error(ex); return(View(PagedListResult <Notice> .Empty.ToPagedList())); } }
/// <summary> /// 公告列表 /// </summary> /// <returns></returns> public ActionResult NoticeList(SearchHelperModel search) { Expression <Func <Notice, bool> > whereLamdba = (n => !n.IsDeleted && n.CheckStatus); if (!String.IsNullOrEmpty(search.SearchItem1)) { whereLamdba = n => n.NoticeTitle.Contains(search.SearchItem1) && n.CheckStatus; } try { int count; var noticeList = new BLLNotice().GetPagedList(search.PageIndex, search.PageSize, out count, whereLamdba, n => n.NoticePublishTime, false); var data = noticeList.ToPagedList(search.PageIndex, search.PageSize, count); return(View(data)); } catch (Exception ex) { Logger.Error(ex); throw; } }
/// <summary> /// 预约信息列表 /// </summary> /// <param name="search">搜索查询条件</param> /// <returns></returns> public ActionResult List(SearchHelperModel search) { Action <WeihanLi.EntityFramework.EFRepositoryQueryBuilder <Reservation> > queryBuilderAction = queryBuilder => { if (!string.IsNullOrEmpty(search.SearchItem1)) { queryBuilder.WithPredict(m => m.ReservationPersonPhone.Contains(search.SearchItem1)); } if (!string.IsNullOrEmpty(search.SearchItem2) && search.SearchItem2.Equals("1")) { // } else { queryBuilder.WithPredict(m => m.ReservationStatus == ReservationStatus.UnReviewed); } queryBuilder.WithOrderBy(query => query.OrderByDescending(r => r.ReservationForDate).ThenByDescending(r => r.ReservationTime)) .WithInclude(query => query.Include(r => r.Place)); }; //load data var list = _reservationHelper.GetPagedListResult( x => new ReservationListViewModel { ReservationForDate = x.ReservationForDate, ReservationForTime = x.ReservationForTime, ReservationId = x.ReservationId, ReservationUnit = x.ReservationUnit, ReservationTime = x.ReservationTime, ReservationPlaceName = x.Place.PlaceName, ReservationActivityContent = x.ReservationActivityContent, ReservationPersonName = x.ReservationPersonName, ReservationPersonPhone = x.ReservationPersonPhone, ReservationStatus = x.ReservationStatus, }, queryBuilderAction, search.PageIndex, search.PageSize); var dataList = list.ToPagedList(); return(View(dataList)); }
/// <summary> /// 预约记录数据页 /// </summary> /// <param name="search"></param> /// <returns></returns> public async Task <ActionResult> ReservationList(SearchHelperModel search) { Expression <Func <Reservation, bool> > whereLambda = (m => m.ReservationStatus != ReservationStatus.Canceled); if (!string.IsNullOrWhiteSpace(search.SearchItem0) && DateTime.TryParse(search.SearchItem0, out var date)) { whereLambda = whereLambda.And(m => m.ReservationForDate == date.Date); } if (!string.IsNullOrWhiteSpace(search.SearchItem1)) { whereLambda = whereLambda.And(m => m.ReservationPersonPhone == search.SearchItem1.Trim()); } //load data var list = await _reservationBLL.GetPagedListResultAsync( x => new ReservationListViewModel { ReservationForDate = x.ReservationForDate, ReservationForTime = x.ReservationForTime, ReservationId = x.ReservationId, ReservationUnit = x.ReservationUnit, ReservationTime = x.ReservationTime, ReservationPlaceName = x.Place.PlaceName, ReservationActivityContent = x.ReservationActivityContent, ReservationPersonName = x.ReservationPersonName, ReservationPersonPhone = x.ReservationPersonPhone, ReservationStatus = x.ReservationStatus, }, queryBuilder => queryBuilder .WithPredict(whereLambda) .WithOrderBy(query => query.OrderByDescending(r => r.ReservationForDate).ThenByDescending(r => r.ReservationTime)) .WithInclude(query => query.Include(r => r.Place)) , search.PageIndex, search.PageSize); var dataList = list.ToPagedList(); return(View(dataList)); }
/// <summary> /// 预约信息列表 /// </summary> /// <param name="search">搜索查询条件</param> /// <returns></returns> public ActionResult List(SearchHelperModel search) { Expression <Func <Reservation, bool> > whereLambda = (m => DbFunctions.DiffDays(DateTime.Today, m.ReservationForDate) <= 7 && DbFunctions.DiffDays(DateTime.Today, m.ReservationForDate) >= 0 && m.ReservationStatus == 0); var rowsCount = 0; //类别,加载全部还是只加载待审核列表 if (!String.IsNullOrEmpty(search.SearchItem2) && search.SearchItem2.Equals("1")) { //根据预约人联系方式查询 if (!String.IsNullOrEmpty(search.SearchItem1)) { whereLambda = (m => m.ReservationPersonPhone.Contains(search.SearchItem1)); } else { whereLambda = (m => DbFunctions.DiffDays(DateTime.Today, m.ReservationForDate) <= 7 && DbFunctions.DiffDays(DateTime.Today, m.ReservationForDate) >= 0); } } else { if (!String.IsNullOrEmpty(search.SearchItem1)) { whereLambda = (m => m.ReservationPersonPhone.Contains(search.SearchItem1) && m.ReservationStatus == 0); } } //load data var list = BusinessHelper.ReservationHelper.GetReservationList(search.PageIndex, search.PageSize, out rowsCount, whereLambda, m => m.ReservationForDate, m => m.ReservationTime, false, false); var dataList = list.ToPagedList(search.PageIndex, search.PageSize, rowsCount); return(View(dataList)); }