// GET: QCSelect public ActionResult Index(QCSelectIndexModel model, int?PageIndex, int?PageSize = 30) { ViewBag.Line = CommonHelp.list; // if (!string.IsNullOrEmpty(Request.QueryString["Area"])) // Session["Area"] = "123";//Request.QueryString["Area"]; // string area = Session["Area"].ToString(); // ViewBag.title= Session["Area"].ToString(); if (!model.Area.IsNullOrEmpty()) { list = DapperService.SqlHelp.QCSelect(model); foreach (var item in list) { item.area = model.Area; } ViewBag.list = list.Take(30).ToList(); ViewBag.totalcount = list.Count; // return Json(list, JsonRequestBehavior.AllowGet); } if (PageIndex != null) { var model1 = new PageInfoModel <QCSelectDto>(); model1.List = list; model1.PageSize = PageSize; model1.PageIndex = PageIndex; var res = CommonHelp.PageList(model1); return(Json(res, JsonRequestBehavior.AllowGet)); } return(View()); }
public IHttpActionResult GetForOwners(string owners, [FromUri] PageInfoModel pageInfo) { if (string.IsNullOrWhiteSpace(owners)) { return(BadRequest("No owners specified.")); } var splitted = owners.SplitCommaSeparated(); if (splitted.Length > MAX_NUMBER_OWNERS_ALLOWED) { return(BadRequest($"Maximum {MAX_NUMBER_OWNERS_ALLOWED} owners can be specified.")); } pageInfo = pageInfo ?? new PageInfoModel(); var paging = MappingHelper.MapToPageInfo(pageInfo); if (!paging.OrderBy.IsValidFor(_assetRepo.Columns)) { return(BadRequest($"Unknown field : {paging.OrderBy.Name}.")); } var pagedResult = _assetRepo.ForOwners(paging, splitted); return(CreateActionResultFor(pagedResult)); }
public ActionResult ListPartial(int page = 1, string sortCol = "RoleID", string sortType = "asc") { string err; try { var result = MBFDB.GetRolePageList <RoleViewModel>(out err, page, MBFDB.PageSize, sortCol, sortType); ViewBag.Page = page; ViewBag.SortCol = sortCol; ViewBag.SortType = sortType; // Session["PageInfo"] = new PageInfoModel(page, sortCol, sortType); if (string.IsNullOrEmpty(err)) { Response.StatusCode = (int)HttpStatusCode.OK; return(PartialView("ListPartial", result)); } else { LOG.Trace(ERRHD.BuildTraceMessage(ExceptionHandle.MBF_ERROR.ERR_DB_ACCESS, "MBFDB.GetRolePageList")); return(new HttpStatusCodeResult(500, ERRHD.BuildUserMsg(ExceptionHandle.MBF_ERROR.ERR_DB_ACCESS))); } } catch (Exception ex) { LOG.Fatal(ERRHD.BuildExceptionMessage(ex)); return(new HttpStatusCodeResult(500, "exception error.")); } }
public static List <AssembleSearchDto> list = new List <AssembleSearchDto>();// { get; set; } // 页面初次加载 public ActionResult Index(ForAssemblyModel model, int?PageIndex, int?PageSize = 30) { try { ViewBag.totalcount = 0; ViewBag.Line = CommonHelp.list; if (PageIndex == null && model.StartTime < model.EndTime && !string.IsNullOrEmpty(model.Area)) { model.EndTime = Convert.ToDateTime(model.EndTime); model.StartTime = Convert.ToDateTime(model.StartTime); model.Area = model.Area; list = GetAssemblyList(model); foreach (var item in list) { item.area = model.Area; } ViewBag.totalcount = list.Count; ViewBag.list = list.Take(30).ToList(); } if (PageIndex != null) { var model1 = new PageInfoModel <AssembleSearchDto>(); model1.List = list;; model1.PageSize = PageSize; model1.PageIndex = PageIndex; var res = CommonHelp.PageList(model1); return(Json(res, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { } return(View()); }
protected virtual IQueryable <TEntity> QueryDb(Expression <Func <TEntity, bool> > filter, Func <IQueryable <TEntity>, IOrderedQueryable <TEntity> > orderBy = null, PageInfoModel pagedInfo = null, params Expression <Func <TEntity, object> >[] includeProperties) { IQueryable <TEntity> query = Context .Set <TEntity>() .AsNoTracking(); if (filter != null) { query = query.Where(filter); } foreach (var includeProperty in includeProperties) { query = query.Include(includeProperty); } if (orderBy != null) { query = orderBy(query); } var isAdditionalOrder = !string.IsNullOrEmpty(pagedInfo?.SortDir) && !string.IsNullOrEmpty(pagedInfo.SortKey); if (isAdditionalOrder) { query = pagedInfo.SortDir == "desc" ? query.SortDesc(pagedInfo.SortKey) : query.Sort(pagedInfo.SortKey); } return(query); }
public IHttpActionResult Get( [FromUri] ProductFilterModel filter, [FromUri] PageInfoModel pageInfo) { filter = filter ?? new ProductFilterModel(); pageInfo = pageInfo ?? new PageInfoModel(); PagedResult <ProductDto> pagedResult; var paging = MappingHelper.MapToPageInfo(pageInfo); if (!paging.OrderBy.IsValidFor(_repo.Columns)) { return(BadRequest($"Unknown field : {paging.OrderBy.Name}.")); } if (filter.IsEmpty()) { pagedResult = _repo.PagedQuery(paging); return(CreateActionResultFor(pagedResult)); } // Apply filter. var query = MapToQuery(filter); pagedResult = _repo.PagedQuery(paging, query); return(CreateActionResultFor(pagedResult)); }
//[ValidateAntiForgeryToken] public string QueryACBJ(PageInfoModel pgingModel, ACBJViewModel model) { string result = string.Empty; this.db = new GWEB_TESTEntities(); try { //PAGING// //var queryResult = (from p in db.ACBJ select p).OrderBy(x => x.TPID).Skip(pgingModel.PageNum * pgingModel.PageSize).Take(pgingModel.PageSize); //NO PAGING// var queryResult = (from p in db.ACBJ select p); //FILTER ONLY WITH PRIMARY K,.. NOT REALLY EXACTLY/FULLY RIGHT// if (model.TPID != "" & model.TPID != null) { queryResult = queryResult.Where(x => x.TPID == model.TPID); } if (model.SQID != "" & model.SQID != null) { queryResult = queryResult.Where(x => x.SQID == model.SQID); } if (model.ACID != "" & model.ACID != null) { queryResult = queryResult.Where(x => x.ACID == model.ACID); } if (model.SBID != "" & model.SBID != null) { queryResult = queryResult.Where(x => x.SBID == model.SBID); } if (model.SQNO != "" & model.SQNO != null) { queryResult = queryResult.Where(x => x.SQNO == model.SQNO); } if (model.PJID != "" & model.PJID != null) { queryResult = queryResult.Where(x => x.PJID == model.PJID); } if (model.PJSQ != "" & model.PJSQ != null) { queryResult = queryResult.Where(x => x.PJSQ == model.PJSQ); } result = new JavaScriptSerializer().Serialize(queryResult.ToList()); } catch (Exception) { //TODO: throw; } finally { db.Dispose(); } return(result); }
// GET: GetPartByDate public ActionResult Index(PartDataModel model, int?PageIndex, int?PageSize = 30) { try { ViewBag.totalcount = 0; ViewBag.Line = CommonHelp.list; if (PageIndex == null && model.StartTime < model.EndTime && !string.IsNullOrEmpty(model.Line)) { string key = Guid.NewGuid().ToString() + model.Line; CommonHelp.key = key; if (model.EndTime.Month - model.StartTime.Month > 0) { CommonHelp.StarMon = model.StartTime.ToString("yyyy MMMM dd") + "~" + model.EndTime.ToString("yyyy MMMM dd"); CommonHelp.EndMon = CommonHelp.list.Where(p => p.Area.Equals(model.Line)).FirstOrDefault() .DesCribe; } else { CommonHelp.StarMon = model.StartTime.Month + "月"; CommonHelp.EndMon = CommonHelp.list.Where(p => p.Area.Equals(model.Line)).FirstOrDefault() .DesCribe; } if (CommonBuffer.Exist(key)) { CommonHelp.list2 = CommonBuffer.Get <List <PartDataDto> >(key); ViewBag.count = CommonHelp.list2.Count; ViewBag.Data = CommonHelp.list2.Take(30).ToList(); } else { CommonHelp.list2 = CommonBuffer.FindT(key, DapperService.SqlHelp.PartDataBase, model); ViewBag.count = CommonHelp.list2.Count; ViewBag.Data = CommonHelp.list2.Take(30).ToList(); } } if (PageIndex != null) { var model1 = new PageInfoModel <PartDataDto>(); model1.List = CommonHelp.list2; model1.PageSize = PageSize; model1.PageIndex = PageIndex; var res = CommonHelp.PageList(model1); return(Json(res, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { } return(View()); }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(PageInfoModel model) { bool reValue = true; int reCount = 0; StringBuilder strSql = new StringBuilder(); strSql.Append("update CORE.dbo.PageInfo set "); strSql.Append(" PageId = @PageId , "); strSql.Append(" PageName = @PageName , "); strSql.Append(" PageMemo = @PageMemo , "); strSql.Append(" OrderNo = @OrderNo , "); strSql.Append(" MerId = @MerId , "); strSql.Append(" Invalid = @Invalid , "); strSql.Append(" PageLabel = @PageLabel , "); strSql.Append(" BranchId = @BranchId , "); strSql.Append(" ZoneId = @ZoneId "); strSql.Append(" where PageId=@PageId "); SqlParameter[] parameters = { new SqlParameter("@PageId", SqlDbType.VarChar, 50), new SqlParameter("@PageName", SqlDbType.VarChar, 50), new SqlParameter("@PageMemo", SqlDbType.VarChar, 500), new SqlParameter("@OrderNo", SqlDbType.Int, 4), new SqlParameter("@MerId", SqlDbType.Decimal, 9), new SqlParameter("@Invalid", SqlDbType.Bit, 1), new SqlParameter("@PageLabel", SqlDbType.VarChar, 50), new SqlParameter("@BranchId", SqlDbType.VarChar, 50), new SqlParameter("@ZoneId", SqlDbType.VarChar, 50) }; parameters[0].Value = model.PageId; parameters[1].Value = model.PageName; parameters[2].Value = model.PageMemo; parameters[3].Value = model.OrderNo; parameters[4].Value = model.MerId; parameters[5].Value = model.Invalid; parameters[6].Value = model.PageLabel; parameters[7].Value = model.BranchId; parameters[8].Value = model.ZoneId; try {//异常处理 reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters); } catch (Exception ex) { this.helper.Close(); throw ex; } if (reCount <= 0) { reValue = false; } return(reValue); }
public IActionResult ListBooks([FromForm] PageInfoModel pageInfo, [FromForm] SearchViewModel model) { try { if (ModelState.IsValid) { ListBooksViewModel result = null; switch (pageInfo.ActionName.Replace("/", "")) { case "AllBooks": result = _libraryLogic.GetAllBook(this.CurrentUser(), model); break; case "CurrentReadList": result = _libraryLogic.GetCurrentReadBooks(this.CurrentUser(), model); break; case "PreviousReadList": result = _libraryLogic.GetPreviousReadBooks(this.CurrentUser(), model); break; } if (result != null) { result.PageView = pageInfo.PageItems; if (pageInfo.PageItems == 1) { pageInfo.PageItems = 4; } result.Search = model; ViewBag.Pagination = Pagination(pageInfo, result); result.Books = result.Books.OrderByDescending(book => (book.Aviable != 0)).ThenBy(book => book.Title).Skip((pageInfo.Page - 1) * pageInfo.PageItems).Take(pageInfo.PageItems).ToList(); return(PartialView(result)); } return(PartialView(result)); } else { return(BadRequest()); } } catch (Exception ex) { return(BadRequest(ex.Message)); } }
/// <summary> /// 增加一条数据 /// </summary> public bool Add(PageInfoModel model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into CORE.dbo.PageInfo ("); strSql.Append("PageId,PageName,PageMemo,OrderNo,MerId,Invalid,PageLabel,BranchId,ZoneId"); strSql.Append(") values ("); strSql.Append("@PageId,@PageName,@PageMemo,@OrderNo,@MerId,@Invalid,@PageLabel,@BranchId,@ZoneId"); strSql.Append(") "); SqlParameter[] parameters = { new SqlParameter("@PageId", SqlDbType.VarChar, 50), new SqlParameter("@PageName", SqlDbType.VarChar, 50), new SqlParameter("@PageMemo", SqlDbType.VarChar, 500), new SqlParameter("@OrderNo", SqlDbType.Int, 4), new SqlParameter("@MerId", SqlDbType.Decimal, 9), new SqlParameter("@Invalid", SqlDbType.Bit, 1), new SqlParameter("@PageLabel", SqlDbType.VarChar, 50), new SqlParameter("@BranchId", SqlDbType.VarChar, 50), new SqlParameter("@ZoneId", SqlDbType.VarChar, 50) }; parameters[0].Value = model.PageId; parameters[1].Value = model.PageName; parameters[2].Value = model.PageMemo; parameters[3].Value = model.OrderNo; parameters[4].Value = model.MerId; parameters[5].Value = model.Invalid; parameters[6].Value = model.PageLabel; parameters[7].Value = model.BranchId; parameters[8].Value = model.ZoneId; bool result = false; try { helper.ExecSqlReInt(strSql.ToString(), parameters); result = true; } catch (Exception ex) { this.helper.Close(); throw ex; } finally { } return(result); }
/// <summary> /// 得到一个对象实体 /// </summary> public PageInfoModel GetModel(string PageId) { StringBuilder strSql = new StringBuilder(); strSql.Append("select PageId, PageName, PageMemo, OrderNo, MerId, Invalid, PageLabel, BranchId, ZoneId "); strSql.Append(" from CORE.dbo.PageInfo "); strSql.Append(" where PageId=@PageId "); SqlParameter[] parameters = { new SqlParameter("@PageId", SqlDbType.VarChar, 50) }; parameters[0].Value = PageId; PageInfoModel model = new PageInfoModel(); DataSet ds = helper.ExecSqlReDs(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { model.PageId = ds.Tables[0].Rows[0]["PageId"].ToString(); model.PageName = ds.Tables[0].Rows[0]["PageName"].ToString(); model.PageMemo = ds.Tables[0].Rows[0]["PageMemo"].ToString(); if (ds.Tables[0].Rows[0]["OrderNo"].ToString() != "") { model.OrderNo = int.Parse(ds.Tables[0].Rows[0]["OrderNo"].ToString()); } if (ds.Tables[0].Rows[0]["MerId"].ToString() != "") { model.MerId = decimal.Parse(ds.Tables[0].Rows[0]["MerId"].ToString()); } if (ds.Tables[0].Rows[0]["Invalid"].ToString() != "") { if ((ds.Tables[0].Rows[0]["Invalid"].ToString() == "1") || (ds.Tables[0].Rows[0]["Invalid"].ToString().ToLower() == "true")) { model.Invalid = true; } else { model.Invalid = false; } } model.PageLabel = ds.Tables[0].Rows[0]["PageLabel"].ToString(); model.BranchId = ds.Tables[0].Rows[0]["BranchId"].ToString(); model.ZoneId = ds.Tables[0].Rows[0]["ZoneId"].ToString(); return(model); } else { return(model); } }
public async Task <PagedEntityResult <Account> > LoadAll(PageInfoModel pageInfo = null) { var items = await _repository.PagedQuery(null, null, pageInfo); var result = new PagedEntityResult <Account> { Result = items.Result, TotalCount = items.TotalCount, PagingInfo = items.PagingInfo }; return(result); }
public async Task <ApiResModel> UsageAmountDailyReport(long usageAccountId, int?currentPage, int?pageCount) { ApiResModel apiResModel = new ApiResModel(); var lineItems = await _reportService.UsageAmountDailyReport(usageAccountId); var pageInfo = new PageInfoModel(currentPage, pageCount); lineItems = pageInfo.ComputePage(lineItems); apiResModel.PageInfo = pageInfo; apiResModel.Result = lineItems; return(apiResModel); }
public void AddKeywords() { // Arrange const string keywords = "keyword01, keyword02, keyword03"; var pageInfoModel = new PageInfoModel("PageTitle"); pageInfoModel.AddKeywords(keywords); // Act var keywordsResult = pageInfoModel.GetKeywords().ToHtmlString(); // Assert Assert.That(keywordsResult, Is.Not.Null.Or.Empty); Assert.AreEqual(keywords, keywordsResult); }
public static ResPageInfoDto <T> PageList <T>(PageInfoModel <T> model) { var res = new ResPageInfoDto <T>(); if (model.PageIndex <= model.List.Count / 30) { res.List = model.List.Skip(model.PageIndex ?? 0 - 1).Take(model.PageSize ?? 30).ToList(); } else { var last = model.List.Count - (model.PageIndex - 1) * 30; res.List = model.List.Skip(model.PageIndex ?? 0 - 1).Take(last ?? 30).ToList(); } res.TotalCount = model.List.Count; return(res); }
/// <summary> /// Возвращает модель пагинации страницы /// </summary> /// <param name="pageInfo"> Информация о странице </param> /// <param name="books"> Список книг страницы </param> /// <returns> Модель пагинации страницы</returns> public static Pagination Pagination(PageInfoModel pageInfo, ListBooksViewModel books) { Pagination pagination = new Pagination { PageItemsAmount = pageInfo.PageItems, CurrentPage = pageInfo.Page, ControllerName = "Library", ActionName = pageInfo.ActionName.Replace("/", ""), ShowLastAndFirstPages = true }; pagination.ItemsAmount = books.Books.Count(); pagination.Refresh(); return(pagination); }
public void Ctor_PageInfoData_PageInfoModelInstance() { // Arrange const string pageTitle = "PageTitle"; const string pageDescription = "PageDescription"; // Act var pageInfoModel = new PageInfoModel(pageTitle) { Description = pageDescription }; // Assert Assert.IsNotNull(pageInfoModel); Assert.AreEqual(pageTitle, pageInfoModel.Title); Assert.AreEqual(pageDescription, pageInfoModel.Description); }
public FriendListViewModel GetFriendsByMessageRegime(long accountId, MessageRegime?messageRegime, int pageNumber, int pageSize) { var account = _accountManager.GetAccountById(accountId); var friends = new GetFriendsByMessageRegimeQueryHandler(new DataBaseContext()).Handle(new GetFriendsByMessageRegimeQuery { AccountId = accountId, GroupSettingsId = account.GroupSettingsId, MessageRegime = messageRegime, Page = new PageModel { PageNumber = pageNumber, PageSize = pageSize } }); var pageInfo = new PageInfoModel { PageNumber = pageNumber, PageSize = pageSize, TotalItems = friends.CountAllFriends }; var result = new FriendListViewModel { AccountId = accountId, Friends = friends.Friends.Select(model => new FriendViewModel { AddDateTime = model.AddedDateTime, Id = model.Id, Deleted = model.Deleted, FacebookId = model.FacebookId, MessagesEnded = model.DialogIsCompleted, Name = model.FriendName, Href = model.Href, IsAddedToGroups = model.IsAddedToGroups, IsAddedToPages = model.IsAddedToPages, IsWinked = model.IsWinked, MessageRegime = model.MessageRegime, AddedToRemoveDateTime = model.AddedToRemoveDateTime, CountWinksToFriends = model.CountWinksToFriends }).ToList(), PageInfo = pageInfo }; return(result); }
public static MvcHtmlString PageLinks(this HtmlHelper html, PageInfoModel pageInfo, Func <int, string> pageUrl) { var result = new StringBuilder(); for (int i = 1; i <= pageInfo.TotalPages; i++) { var tag = new TagBuilder("a"); tag.MergeAttribute("href", pageUrl(i)); tag.InnerHtml = i.ToString(); if (i == pageInfo.PageNumber) { tag.AddCssClass("selected"); tag.AddCssClass("btn-primary"); } tag.AddCssClass("btn btn-default"); result.Append(tag); } return(MvcHtmlString.Create(result.ToString())); }
public AntdInfoModule() { Get["/info"] = x => { var versionOs = Bash.Execute("uname -a"); var aosInfo = MachineInfo.GetAosrelease(); var uptime = MachineInfo.GetUptime(); var gentooRelease = File.ReadAllText("/etc/gentoo-release"); var lsbRelease = File.ReadAllText("/etc/lsb-release"); var osRelease = File.ReadAllText("/etc/os-release"); var model = new PageInfoModel { VersionOs = versionOs, AosInfo = aosInfo, Uptime = uptime, GentooRelease = gentooRelease, LsbRelease = lsbRelease, OsRelease = osRelease }; return(JsonConvert.SerializeObject(model)); }; }
// GET: ScanRate public ActionResult Index(PartDataModel model, int?PageIndex, int?PageSize = 30) { try { List <ResScnRateDto> listend = new List <ResScnRateDto>(); ViewBag.totalcount = 0; ViewBag.Line = CommonHelp.list; if (PageIndex == null && model.StartTime < model.EndTime && !string.IsNullOrEmpty(model.Line)) { string key = Guid.NewGuid().ToString() + model.Line; CommonHelp.key = key; if (CommonBuffer.Exist(key)) { CommonHelp.Listone <ResScnRateDto> .List = CommonBuffer.Get <List <ResScnRateDto> >(key); ViewBag.count = CommonHelp.Listone <ResScnRateDto> .List.Count; ViewBag.Data = CommonHelp.Listone <ResScnRateDto> .List.Take(30).ToList(); } else { CommonHelp.Listone <ResScnRateDto> .List = CommonBuffer.FindT(key, DapperService.SqlHelp.ScanRate, model); ViewBag.count = CommonHelp.Listone <ResScnRateDto> .List.Count; ViewBag.Data = CommonHelp.Listone <ResScnRateDto> .List.Take(30).ToList(); } } if (PageIndex != null) { var model1 = new PageInfoModel <ResScnRateDto>(); model1.List = CommonHelp.Listone <ResScnRateDto> .List; model1.PageSize = PageSize; model1.PageIndex = PageIndex; var res = CommonHelp.PageList(model1); return(Json(res, JsonRequestBehavior.AllowGet)); } } catch (Exception ex) { } return(View()); }
public PageInfoModel GetPrincipals(int CurrentPage = 1, int PageSize = 3, string principalName = "") { var list = bll.GetPrincipals(); if (!string.IsNullOrEmpty(principalName)) { list = list.Where(s => s.PrincipalName.Contains(principalName)).ToList(); } //实例化分页类 var p = new PageInfoModel(); //总记录数 p.TotalCount = list.Count(); //计算总页数 if (p.TotalCount == 0) { p.TotalPage = 1; } else if (p.TotalCount % PageSize == 0) { p.TotalPage = p.TotalCount / PageSize; } else { p.TotalPage = (p.TotalCount / PageSize) + 1; } //纠正当前页不正确的值 if (CurrentPage < 1) { CurrentPage = 1; } if (CurrentPage > p.TotalPage) { CurrentPage = p.TotalPage; } p.PrincipalModels = list.Skip(PageSize * (CurrentPage - 1)).Take(PageSize).ToList(); p.CurrentPage = CurrentPage; return(p); }
public void GetKeywords_Keywords_CommaSeparatedKeywords() { // Arrange const string keyword01 = "keyword01"; const string keyword02 = "keyword02"; const string keyword03 = "keyword03"; var pageInfoModel = new PageInfoModel("PageTitle"); pageInfoModel.AddKeyword(keyword01) .AddKeyword(keyword02) .AddKeyword(keyword03); // Act var keywords = pageInfoModel.GetKeywords().ToHtmlString(); // Assert Assert.That(keywords, Is.Not.Null.Or.Empty); Assert.IsTrue(keywords.Contains(keyword01)); Assert.IsTrue(keywords.Contains(keyword02)); Assert.IsTrue(keywords.Contains(keyword03)); Assert.IsTrue(keywords.Contains(",")); }
public ActionResult Query(PageInfoModel pgingModel, ACHDViewModel model) { string result = string.Empty; IndexViewModel outputModel = new IndexViewModel(); try { List <ACHD> queryResult = new JavaScriptSerializer().Deserialize <List <ACHD> >(this.QueryACHD(pgingModel, model)); //outputModel if (queryResult != null && queryResult.Count() > 0) { //this.QueryACBD } } catch (Exception ex) { throw; } return(Json(new { data = result }, JsonRequestBehavior.AllowGet)); //return View("Index", outputModel); }
public async Task <PagedEntityResult <TEntity> > PagedQuery(Expression <Func <TEntity, bool> > filter, Func <IQueryable <TEntity>, IOrderedQueryable <TEntity> > orderBy = null, PageInfoModel pageInfo = null, params Expression <Func <TEntity, object> >[] includeProperties ) { var query = QueryDb(filter, orderBy, pageInfo, includeProperties); int?skipCount = null; if (pageInfo != null && pageInfo.PageNumber.HasValue && pageInfo.PageSize.HasValue) { skipCount = pageInfo.PageNumber * pageInfo.PageSize; } var pagedEntity = new PagedEntityResult <TEntity>(query.AsQueryable(), new PageInfoModel { PageSize = pageInfo?.PageSize.GetValueOrDefault(), PageNumber = pageInfo?.PageNumber.GetValueOrDefault(), SortKey = pageInfo?.SortKey, SortDir = pageInfo?.SortDir }); if (skipCount.HasValue) { query = query.Skip(skipCount.Value); } if (pageInfo != null && pageInfo.PageSize.HasValue) { query = query.Take(pageInfo.PageSize.Value); } pagedEntity.Result = await query.AsNoTracking().ToListAsync(); return(pagedEntity); }
public async Task <IActionResult> Get([FromQuery] PageInfoModel pageInfo) { var users = await _service.LoadAll(pageInfo); return(users != null?Ok(_mapper.Map <UserResultViewModel>(users)) : EntitiesNotFound()); }
public static PageInfo MapToPageInfo(PageInfoModel input) => new PageInfo( input.PageNumber, input.RowsPerPage, input.OrderBy);
//[ValidateAntiForgeryToken] //public ActionResult Edit(EditViewModel model) //{ // EditViewModel outputModel = new VoucherViewModel(); // //this.db = new GWEB_TESTEntities(); // //ACHD achd = new ACHD(); // //achd.ACID = model.ACID; // //achd.CKAM = Convert.ToDecimal(model.CKAM); // //achd.CKID = model.CKID; // //achd.CKYM = model.CKYM; // //achd.DATE = model.DATE; // //achd.JSKD = model.JSKD; // //achd.NIKD = model.NIKD; // //achd.NOTE = model.NOTE; // //achd.PSID = model.PSID; // //achd.REM1 = model.REM1; // //achd.REM2 = model.REM2; // //achd.SBID = model.SBID; // //achd.SQID = model.SQID; // //achd.TPID = model.TPID; // //achd.TPNM = model.TPNM; // //achd.YYMM = model.YYMM; // //db.ACHD.Add(achd); // //db.SaveChanges(); // return View(outputModel); //} //Query ACHD >> using ACHD MODEL// //[ValidateAntiForgeryToken] //[NonAction] public string QueryACHD(PageInfoModel pgingModel, ACHDViewModel model) { string result = string.Empty; this.db = new GWEB_TESTEntities(); try { //PAGING// //var queryResult = (from p in db.ACHD select p).OrderBy(x=>x.ACID).Skip(pgingModel.PageNum * pgingModel.PageSize).Take(pgingModel.PageSize); //NO PAGING// var queryResult = (from p in db.ACHD select p); if (model.ACID != "" & model.ACID != null) { queryResult = queryResult.Where(x => x.ACID == model.ACID); } if (model.CKAM != "" & model.CKAM != null) { //decimal ckam = 0m; //if (Decimal.TryParse(model.CKAM, out ckam)) //{ // queryResult = queryResult.Where(x => x.CKAM == ckam); queryResult = queryResult.Where(x => x.CKAM == Convert.ToDecimal(model.CKAM)); //} //else //{ // //TODO: // //NOTHING// //} } if (model.CKID != "" & model.CKID != null) { queryResult = queryResult.Where(x => x.CKID == model.CKID); } if (model.CKYM != "" & model.CKYM != null) { queryResult = queryResult.Where(x => x.CKYM == model.CKYM); } if (model.DATE != "" & model.DATE != null) { DateTime date = CcDevConst.DATEINIVALUE; if (DateTime.TryParse(model.DATE, out date)) { queryResult = queryResult.Where(x => x.DATE == date); } else { //TODO: //NOTHING// } } if (model.JSKD != "" & model.JSKD != null) { queryResult = queryResult.Where(x => x.JSKD == model.JSKD); } if (model.NIKD != "" & model.NIKD != null) { queryResult = queryResult.Where(x => x.NIKD == model.NIKD); } if (model.NOTE != "" & model.NOTE != null) { queryResult = queryResult.Where(x => x.NOTE == model.NOTE); } if (model.PSID != "" & model.PSID != null) { queryResult = queryResult.Where(x => x.PSID == model.PSID); } if (model.REM1 != "" & model.REM1 != null) { queryResult = queryResult.Where(x => x.REM1 == model.REM1); } if (model.REM2 != "" & model.REM2 != null) { queryResult = queryResult.Where(x => x.REM2 == model.REM2); } if (model.SBID != "" & model.SBID != null) { queryResult = queryResult.Where(x => x.SBID == model.SBID); } if (model.SQID != "" & model.SQID != null) { queryResult = queryResult.Where(x => x.SQID == model.SQID); } if (model.TPID != "" & model.TPID != null) { queryResult = queryResult.Where(x => x.TPID == model.TPID); } if (model.TPNM != "" & model.TPNM != null) { queryResult = queryResult.Where(x => x.TPNM == model.TPNM); } if (model.YYMM != "" & model.YYMM != null) { queryResult = queryResult.Where(x => x.YYMM == model.YYMM); } result = new JavaScriptSerializer().Serialize(queryResult.OrderBy(x => x.TPID).OrderBy(x => x.SQID).ToList()); } catch (Exception) { //TODO: throw; } finally { db.Dispose(); } return(result); }
//[ValidateAntiForgeryToken] public string QueryACBD(PageInfoModel pgingModel, ACBDViewModel model) { string result = string.Empty; this.db = new GWEB_TESTEntities(); try { //PAGING// //var queryResult = (from p in db.ACBD select p).OrderBy(x => x.ACID).Skip(pgingModel.PageNum * pgingModel.PageSize).Take(pgingModel.PageSize); //NOPAGING// var queryResult = (from p in db.ACBD select p); if (model.ACID != "" & model.ACID != null) { queryResult = queryResult.Where(x => x.ACID == model.ACID); } if (model.TPID != "" & model.TPID != null) { queryResult = queryResult.Where(x => x.TPID == model.TPID); } if (model.SQID != "" & model.SQID != null) { queryResult = queryResult.Where(x => x.SQID == model.SQID); } if (model.SBID != "" & model.SBID != null) { queryResult = queryResult.Where(x => x.SBID == model.SBID); } if (model.DATE != "" & model.DATE != null) { queryResult = queryResult.Where(x => x.DATE == Convert.ToDateTime(model.DATE)); } //queryResult = queryResult.Where(x => x.DATE == DateTime.ParseExact(model.DATE, "yyyyMMdd", null)); if (model.SQNO != "" & model.SQNO != null) { queryResult = queryResult.Where(x => x.SQNO == model.SQNO); } if (model.CAMT != null) { queryResult = queryResult.Where(x => x.CAMT == model.CAMT); } if (model.DAMT != null) { queryResult = queryResult.Where(x => x.DAMT == model.DAMT); } if (model.TPNM != "" & model.TPNM != null) { queryResult = queryResult.Where(x => x.TPNM == model.TPNM); } if (model.YYMM != "" & model.YYMM != null) { queryResult = queryResult.Where(x => x.YYMM == model.YYMM); } if (model.ITID != "" & model.ITID != null) { queryResult = queryResult.Where(x => x.ITID == model.ITID); } result = new JavaScriptSerializer().Serialize(queryResult.ToList()); } catch (Exception) { //TODO: throw; } finally { db.Dispose(); } return(result); }