/// <summary> /// 根据条件查询,返回查询后的DepartmentTree /// </summary> /// <param name="keyWord">关键词,为空表示查询整棵树</param> /// <returns></returns> public List<TreeNode> GetTree(string keyWord) { var pageQuery = new PageQuery<IDictionary<string, object>, Plug>(this.CurrentOperatorUser); pageQuery.Condition = new Dictionary<string, object>(); if (!string.IsNullOrEmpty(txtQueryText.Text.Trim())) { pageQuery.Condition["PlugName"] = txtQueryText.Text.Trim(); } pageQuery.CurrentPageIndex = 1; pageQuery.PageSize = int.MaxValue; Service.Query(pageQuery); return AspNetHelper.GetPlugChildNote(pageQuery.Result.ToList()); }
/// <summary> /// 绑定合作单位下拉列表 /// </summary> protected void BindSalesDDL() { DropWorkNameID.Items.Clear(); var request = new PageQuery<IDictionary<string, object>, Cooperation>(null); request.Condition = new Dictionary<string, object>(); request.SetQueryAll(); DependencyResolver.Resolver<ICooperationService>().Query(request); DropWorkNameID.Items.AddRange( request.Result.Select(m => new ListItem() { Text = m.Name, Value = m.Id.ToString() }).ToArray()); DropWorkNameID.Items.Insert(0, new ListItem("请选择", "")); }
/// <summary> /// 绑定列表 /// </summary> private void BindList() { var currentUser = this.CurrentOperatorUser; var pageQuery = new PageQuery<IDictionary<string, object>, OperatorUser>(currentUser.IsAdmin ? null : currentUser); pageQuery.Condition = new Dictionary<string, object>(); if (!string.IsNullOrEmpty(txtQueryText.Text)) { pageQuery.Condition.Add("OperatorName", txtQueryText.Text); } UserInfoService.Query(pageQuery); rptList.DataSource = pageQuery.Result; rptList.DataBind(); AspNetPager1.RecordCount = pageQuery.RecordCount; }
/// <summary> /// 绑定列表 /// </summary> private void BindList() { PageQuery<IDictionary<string, object>, MembershipCard> pageQuery = new PageQuery<IDictionary<string, object>, MembershipCard>(this.CurrentOperatorUser); pageQuery.Condition = new Dictionary<string, object>(); if (!string.IsNullOrEmpty(txtQueryText.Text)) { pageQuery.Condition.Add("CardCode", txtQueryText.Text); } pageQuery.CurrentPageIndex = AspNetPager1.CurrentPageIndex; pageQuery.PageSize = AspNetPager1.PageSize; Service.Query(pageQuery); rptList.DataSource = pageQuery.Result; rptList.DataBind(); AspNetPager1.RecordCount = pageQuery.RecordCount; }
/// <summary> /// 绑定列表 /// </summary> private void BindList(string condition = " DELETED !=1 ") { PageQuery<IDictionary<string, object>, Customer> pageQuery = new PageQuery<IDictionary<string, object>, Customer>(CurrentOperatorUser); pageQuery.Condition = new Dictionary<string, object>(); if (!string.IsNullOrEmpty(txtQueryText.Text)) { pageQuery.Condition.Add("Name", txtQueryText.Text); } pageQuery.CurrentPageIndex = AspNetPager1.CurrentPageIndex; pageQuery.PageSize = AspNetPager1.PageSize; Service.Query(pageQuery); rptList.DataSource = pageQuery.Result; rptList.DataBind(); AspNetPager1.RecordCount = pageQuery.RecordCount; }
/// <summary> /// Zwraca stronę danych użytkowników. /// </summary> /// <param name="query"></param> /// <returns></returns> public async Task <PagedResult <UserDto> > Page(PageQuery query) { return(await Get <PagedResult <UserDto> >("Page?" + query.ToQueryString())); }
private DynamicParameters BuildParamsForPageQueryBySp(PageQuerySqlEntity sqlEntity, PageQuery page) { var param = new DynamicParameters(); param.Add("_fields", sqlEntity.fields); param.Add("_tables", sqlEntity.tables); param.Add("_where", sqlEntity.where.ToString()); param.Add("_orderby", sqlEntity.order.ToString()); param.Add("_pageindex", page.pageIndex, dbType: System.Data.DbType.Int32); param.Add("_pageSize", page.pageSize, dbType: System.Data.DbType.Int32); param.Add("_totalcount", page.total, dbType: System.Data.DbType.Int32, direction: ParameterDirection.Output); param.Add("_pagecount", page.pageTotal, dbType: System.Data.DbType.Int32, direction: ParameterDirection.Output); return(param); }
public IActionResult PageQuery([FromBody] PageQuery <AppUserPageQueryCommandInputDTO> input) { var result = this.PageQueryCommand.Execute(input); return(this.Ok(result)); }
public void Query(PageQuery <IDictionary <string, object>, Holiday> pageQuery) { this._repository.Query(pageQuery); }
public IActionResult GetQuoteItems([FromBody] PageQuery <FunzaQuoteGetItemsCommandInputDTO> input) { var syncResult = this.QuoteGetItemsCommand.Execute(input); return(this.Ok(syncResult)); }
/// <summary> /// 绑定列表 /// </summary> private void BindList(string condition = " DELETED !=1 ") { var pageQuery = new PageQuery<IDictionary<string, object>, Task>(CurrentOperatorUser); pageQuery.Condition = new Dictionary<string, object>(); if (!string.IsNullOrEmpty(txtQueryText.Text)) { pageQuery.Condition.Add("Subject", txtQueryText.Text); } if (QueryType == "assign") { pageQuery.Condition.Add("AssignUser.Id", this.CurrentOperatorUser.Id); } else { pageQuery.Condition.Add("CreateUser.Id", this.CurrentOperatorUser.Id); } pageQuery.CurrentPageIndex = AspNetPager1.CurrentPageIndex; pageQuery.PageSize = AspNetPager1.PageSize; UserInfoService.Query(pageQuery); rptList.DataSource = pageQuery.Result; rptList.DataBind(); AspNetPager1.RecordCount = pageQuery.RecordCount; }
public async Task <OperationResponse> ExecuteAsync() { var taskDictionary = new Dictionary <string, Task <Object> >(); var result = new OperationResponse(); var integrationId = Guid.NewGuid(); //taskDictionary.Add( // "Products" // , Task.Run<object>(async () => // { // var combination = new List<FunzaGetProductsCommandOutput>(); // var filter = new PageQuery<FunzaGetProductsCommandInput>(); // var source = await this.GetProductsCommand.ExecuteAsync(filter); // combination.AddRange(source.Bag); // var mapping = this.Map(combination, integrationId: integrationId); // var wrapper = new SyncCommandEntityWrapperInput<ProductsUpdateCommandInput> // { // IntegrationId = integrationId, // SyncItems = mapping // }; // return this.ProductsUpdateCommand.Execute(wrapper); // }) //); //taskDictionary.Add( // "Colors" // , Task.Run<object>(async () => // { // var combination = new List<DirectGetProductColorsResult>(); // var filter = new PageQuery<FunzaGetColorsCommandInput>(); // var source = await this.GetColorsCommand.ExecuteAsync(filter); // combination.AddRange(source.Bag); // var mapping = this.Map(combination, integrationId: integrationId); // var wrapper = new SyncCommandEntityWrapperInput<ColorsUpdateCommandInput> // { // IntegrationId = integrationId, // SyncItems = mapping // }; // return this.ColorsUpdateCommand.Execute(wrapper); // }) //); //taskDictionary.Add( // "Categories" // , Task.Run<object>(async () => // { // var combination = new List<DirectGetProductCategoriesResult>(); // var filter = new PageQuery<FunzaGetCategoriesCommandInput>(); // var source = await this.GetCategoriesCommand.ExecuteAsync(filter); // combination.AddRange(source.Bag); // var mapping = this.Map(combination, integrationId: integrationId); // var wrapper = new SyncCommandEntityWrapperInput<CategoriesUpdateCommandInput> // { // IntegrationId = integrationId, // SyncItems = mapping // }; // return this.CategoriesUpdateCommand.Execute(wrapper); // }) //); taskDictionary.Add( "Packings" , Task.Run <object>(async() => { var combination = new List <DirectGetPackingsResult>(); var filter = new PageQuery <GetPackingsCommandInput>(); var source = await this.GetPackingsCommand.ExecuteAsync(filter); combination.AddRange(source.Bag); var mapping = this.Map(combination, integrationId: integrationId); var wrapper = new SyncCommandEntityWrapperInput <PackingsUpdateCommandInput> { IntegrationId = integrationId, SyncItems = mapping }; return(this.PackingsUpdateCommand.Execute(wrapper)); }) ); //taskDictionary.Add( // "Colors" // , Task.Run<object>(async () => // { // var combination = new List<FunzaGetColorsCommandOutput>(); // var filter = new PageQuery<FunzaGetColorsCommandInput>(); // var source = await this.GetColorsCommand.ExecuteAsync(filter); // combination.AddRange(source.Bag.Items); // while (source.IsSucceed && source.Bag?.Items.Count > 0) // { // filter.PageIndex++; // source = await this.GetColorsCommand.ExecuteAsync(filter); // if (source.IsSucceed && source.Bag != null) // { // combination.AddRange(source.Bag.Items); // } // } // var mapping = this.Map(combination); // return this.ColorsUpdateCommand.Execute(mapping); // }) //); //taskDictionary.Add( // "Categories" // , Task.Run<object>(async () => // { // var combination = new List<FunzaGetCategoriesCommandOutput>(); // var filter = new PageQuery<FunzaGetCategoriesCommandInput>(); // var source = await this.GetCategoriesCommand.ExecuteAsync(filter); // combination.AddRange(source.Bag.Items); // while (source.IsSucceed && source.Bag?.Items.Count > 0) // { // filter.PageIndex++; // source = await this.GetCategoriesCommand.ExecuteAsync(filter); // if (source.IsSucceed && source.Bag != null) // { // combination.AddRange(source.Bag.Items); // } // } // var mapping = this.Map(combination); // return this.CategoriesUpdateCommand.Execute(mapping); // }) //); /* * taskDictionary.Add( * "Packings" * , Task.Run<object>(() => * { * var source = this.GetPackingsCommand.Execute(); * if (source.IsSucceed && source.Bag != null && source.Bag.Count() > 0) * { * var dest = this.Map(source.Bag); * return this.PackingsUpdateCommand.Execute(dest); * } * * return new OperationResponse<FunzaPackingsUpdateCommandOutputDTO>(); * }) * ); * * taskDictionary.Add( * "Quotes" * , Task.Run<object>(() => * { * int pageIndex = 0; * int pageSize = 100; * var pageQuery = new PageQuery<FunzaQuoteGetItemsCommandInputDTO> { * PageIndex = pageIndex, PageSize = pageSize * }; * * PageResult<FunzaQuoteGetItemsCommandOutputDTO> loopResult = null; * * for (; pageIndex == 0 || (pageIndex > 0 && loopResult.Items.Count == pageSize); pageIndex++) * { * var source = this.GetQuotesCommand.Execute(pageQuery); * loopResult = source.Bag; * if (source.IsSucceed && source.Bag != null && loopResult.Items.Count() > 0) * { * var dest = this.Map(loopResult.Items); * return this.QuotesUpdateCommand.Execute(dest); * } * } * * return new OperationResponse<FunzaPackingsUpdateCommandOutputDTO>(); * }) * );*/ await Task.WhenAll(taskDictionary.Values.ToArray()); result.AddResponse(taskDictionary["Products"].Result as OperationResponse); result.AddResponse(taskDictionary["Colors"].Result as OperationResponse); result.AddResponse(taskDictionary["Categories"].Result as OperationResponse); //result.AddResponse(taskDictionary["Packings"].Result as OperationResponse); //result.AddResponse(taskDictionary["Quotes"].Result as OperationResponse); return(result); }
/// <summary> /// 绑定列表 /// </summary> private void BindList() { PageQuery<IDictionary<string, object>, Contract> pageQuery = new PageQuery<IDictionary<string, object>, Contract>(null); pageQuery.Condition = new Dictionary<string, object>(); pageQuery.Condition.Add("startDate", startDate.Value); pageQuery.Condition.Add("endDate", endDate.Value); string personID = ddlSales.SelectedValue; if (!string.IsNullOrEmpty(personID)) { pageQuery.Condition.Add("SignPerson", personID); } if (ContactState.SelectedValue.IsInt()) { pageQuery.Condition["State"] = ContactState.SelectedValue; } pageQuery.CurrentPageIndex = AspNetPager1.CurrentPageIndex; pageQuery.PageSize = AspNetPager1.PageSize; ContractService.Query(pageQuery); rptList.DataSource = pageQuery.Result; rptList.DataBind(); AspNetPager1.RecordCount = pageQuery.RecordCount; }
public int FindAllCount(PageQuery pageQuery) { return pageQuery.TotalCount(Query()); }
public IEnumerable<Page> FindAll(PageQuery pageQuery) { return pageQuery.Query(Query()); }
/// <summary> /// 根据条件查询,返回查询后的Tree /// </summary> /// <param name="keyWord">关键词,为空表示查询整棵树</param> /// <returns></returns> public List<TreeNode> GetMenuTree(string keyWord) { var pageQuery = new PageQuery<IDictionary<string, object>, Plug>(this.CurrentOperatorUser); pageQuery.Condition = new Dictionary<string, object>(); pageQuery.SetQueryAll(); PlugService.Query(pageQuery); return AspNetHelper.GetPlugChildNote(pageQuery.Result.ToList(), this.RolePlugService.GetPlugs(this.CurrentRole).ToList()); }
/// <summary> /// 绑定列表 /// </summary> private void BindList(string condition = " DELETED !=1 ") { var pageQuery = new PageQuery<IDictionary<string, object>, Customer>(CurrentOperatorUser); pageQuery.Condition = new Dictionary<string, object>(); if (!string.IsNullOrEmpty(QueryName.Text)) { pageQuery.Condition.Add("ShortName", QueryName.Text); } if (!string.IsNullOrEmpty(CustomerSourceID.SelectedValue) && CustomerSourceID.SelectedValue.IsInt()) { pageQuery.Condition.Add("CustomerSource.Id", CustomerSourceID.SelectedValue); } if (!string.IsNullOrEmpty(CustomerBusinessID.SelectedValue) && CustomerBusinessID.SelectedValue.IsInt()) { pageQuery.Condition.Add("CustomerBusiness.Id", CustomerBusinessID.SelectedValue); } if (!string.IsNullOrEmpty(AccTypeId.SelectedValue) && AccTypeId.SelectedValue.IsInt()) { pageQuery.Condition.Add("AccType", AccTypeId.SelectedValue); } pageQuery.Condition["BelongPerson.Id"] = this.CurrentOperatorUser.Id; pageQuery.CurrentPageIndex = AspNetPager1.CurrentPageIndex; pageQuery.PageSize = AspNetPager1.PageSize; UserInfoService.Query(pageQuery); rptList.DataSource = pageQuery.Result; rptList.DataBind(); AspNetPager1.RecordCount = pageQuery.RecordCount; }
private string QueryCustomerByName(string key) { string result = string.Empty; var pageQuery = new PageQuery<IDictionary<string, object>, Customer>(HttpCurrentUserService.Current); pageQuery.Condition = new Dictionary<string, object>(); pageQuery.Condition.Add("Name", key); DependencyResolver.Resolver<ICustomerService>().Query(pageQuery); pageQuery.Result.Where(m => m.Deleted == false).ToList().ForEach(m => { result += "<p onMouseOver=\"this.style.backgroundColor='#B4D7E9';\" onMouseOut=\"this.style.backgroundColor=''\" onClick=\"clickkey('" + m.Id.ToString() + "','" + m.Name + "')\" style=\"cursor:pointer\">" + m.Name.ToString().Trim() + "</p>"; }); return result; }
public PageResult <UserAccount> GetUserAccount(PredicateGroup group, PageQuery query) { return(base.GetPager(group, query)); }
public void Query(PageQuery <IDictionary <string, object>, Financial> pageQuery) { _financialRepository.Query(pageQuery); }
public void Query(PageQuery <IDictionary <string, object>, CustormerConsumRecord> pageQuery) { _recordRepository.Query(pageQuery); }
public OperationResponse <PageResult <SampleBoxPageQueryCommandOutputDTO> > PageQuery(PageQuery <SampleBoxPageQueryCommandInputDTO> input) { var result = new OperationResponse <PageResult <SampleBoxPageQueryCommandOutputDTO> >(); try { // predicate construction var predicate = PredicateBuilderExtension.True <SampleBox>(); if (input.CustomFilter != null) { var filter = input.CustomFilter; if (!string.IsNullOrWhiteSpace(filter.Term)) { predicate = predicate.And(o => o.SampleBoxProducts.Any(sampleProductItem => sampleProductItem.SaleOpportunityTargetPriceProduct.Product.Name.Contains(filter.Term, StringComparison.InvariantCultureIgnoreCase))); } } var dbLocator = this.AmbientDbContextLocator.Get <RiverdaleDBContext>(); { var query = dbLocator.Set <SampleBox>().AsQueryable(); var advancedSorting = new List <SortItem <SampleBox> >(); Expression <Func <SampleBox, object> > expression; if (input.Sort.ContainsKey("productType")) { expression = o => o.SampleBoxProducts.FirstOrDefault().SaleOpportunityTargetPriceProduct.Product.ProductType.Name; advancedSorting.Add(new SortItem <SampleBox> { PropertyName = "productType", SortExpression = expression, SortOrder = "desc" }); } var sorting = new SortingDTO <SampleBox>(input.Sort, advancedSorting); result.Bag = query.ProcessPagingSort <SampleBox, SampleBoxPageQueryCommandOutputDTO>(predicate, input, sorting, o => new SampleBoxPageQueryCommandOutputDTO { Id = o.Id, Order = o.Order, Name = o.Name }); } } catch (Exception ex) { result.AddException($"Error getting Sample Box page query", ex); } return(result); }
public ActionResult TestList(int? pageIndex, string sort, string sortDirection) { ViewBag.sort = sort; if (!pageIndex.HasValue) { pageIndex = 1; } if (string.IsNullOrEmpty(sort)) { sort = "UpdateTime"; } if (string.IsNullOrEmpty(sortDirection)) { sortDirection = "descending"; } ViewBag.sortDirection = (sortDirection == "ascending") ? "descending" : "ascending"; DataBase db = new DataBase(); List<RequestTestModels> TestRequestList = new List<RequestTestModels>(); TestRequestList = db.GetRequestTest(null, null, "", "", Session[SESSION_USERID].ToString()); PagerInfo pageInfo = new PagerInfo(); pageInfo.PageSize = PAGESIZE; pageInfo.PageIndex = pageIndex.Value; pageInfo.PageTotalCount = TestRequestList.Count; var query = from tr in TestRequestList orderby Utils.GetPropertyValue(tr, tr.TestModel, sort) descending select tr; if (sortDirection == "ascending") { query = from tr in TestRequestList orderby Utils.GetPropertyValue(tr, tr.TestModel, sort) ascending select tr; } //IEnumerable<RequestTestModels> data = TestRequestList.OrderByDescending(aa => aa.InsertDateTime).Skip(pageInfo.PageSize * (pageIndex.Value - 1)).Take(pageInfo.PageSize); IEnumerable<RequestTestModels> data = query.Skip(pageInfo.PageSize * (pageIndex.Value - 1)).Take(pageInfo.PageSize); PageQuery<PagerInfo, IEnumerable<RequestTestModels>> requestTestQuery = new PageQuery<PagerInfo, IEnumerable<RequestTestModels>>(pageInfo, data); return View(requestTestQuery); }
public void QueryStaff(PageQuery <IDictionary <string, object>, Staff> pageQuery) { this._userInfoRepository.QueryStaff(pageQuery); }
/// <summary> /// 增加系统管理员角色 /// </summary> public void AddRoleAdmin() { string roleName = "系统管理员"; var role = DependencyResolver.Resolver<IRoleService>().FindByRoleName(roleName); if (role == null) { role = new Role() { RoleName = roleName, Remark = "CRM 系统管理员" }; DependencyResolver.Resolver<IRoleService>().Save(role); } // 删除 CRM 系统管理员 原来的插件 ExecuteNonQuery(new string[]{@"DELETE FROM Sys_RolePlug WHERE ROLEID IN ( SELECT ID FROM SYS_ROLE WHERE ROLENAME ='系统管理员' AND SYSTEMNAME = 'CRM' )"}); // 给角色分配操作功能 var pageQuery = new PageQuery<IDictionary<string, object>, Plug>(null); pageQuery.Condition = new Dictionary<string, object>(); DependencyResolver.Resolver<IPlugService>().Query(pageQuery); foreach (Plug plug in pageQuery.Result.Where(m => m.Parent != null)) { RolePlug rolePlug = new RolePlug(); rolePlug.Role = role; rolePlug.Plug = plug; DependencyResolver.Resolver<IRolePlugService>().Save(rolePlug); } }
public void Query(PageQuery <IDictionary <string, object>, Task> pageQuery) { _taskRepository.Query(pageQuery); }
private async Task ScrapePageQueryAsync(PageQuery pageQuery) { await Task.CompletedTask; await pageQuery.Scrape(); }
public List <UserRole> GetUserRole(PredicateGroup group, PageQuery query) { return(base.GetPager(group, query).ToList()); }
public override async Task Process(string parameter, HttpListenerContext context) { this.Parameter = parameter; // Parse json request var request = context.Request; string text; using var reader = new StreamReader(request.InputStream, request.ContentEncoding); text = reader.ReadToEnd(); // GET if (parameter == "list") { ResultList = new List <PageQueryInterface>(); foreach (var query in ServerContext.PageQueryManager.GetAll()) { ResultList.Add((PageQueryInterface)query); } } // POST if (parameter == "add") { PageQueryInterface result = JsonConvert.DeserializeObject <PageQueryInterface>(text); CreatedQuery = await ServerContext.PageQueryManager.CreateNew(); CreatedQuery.Depth = result.depth; CreatedQuery.MediaRegex = result.media_regexp; CreatedQuery.PageRegex = result.page_regexp; CreatedQuery.ToleratedAge = result.time; CreatedQuery.StartingURL = result.url; } // POST if (parameter.StartsWith("scrape/")) { if (int.TryParse(parameter.Substring("scrape/".Length), out var id)) { var pageQuery = ServerContext.PageQueryManager.GetById(id); if (pageQuery != null) { OperationSuccessfull = true; _ = ScrapePageQueryAsync(pageQuery); } } } // DELETE if (parameter.StartsWith("remove/")) { if (int.TryParse(parameter.Substring("remove/".Length), out var id)) { var pageQuery = ServerContext.PageQueryManager.GetById(id); if (pageQuery != null) { OperationSuccessfull = true; pageQuery.Remove(); } } } }
/// <summary> /// 绑定列表 /// </summary> private void BindList(string condition = " DELETED !=1 ") { var pageQuery = new PageQuery<IDictionary<string, object>, Suggest>(CurrentOperatorUser); pageQuery.Condition = new Dictionary<string, object>(); if (!string.IsNullOrEmpty(txtQueryText.Text)) { pageQuery.Condition.Add("CustoMerName", txtQueryText.Text); } pageQuery.Condition["SuggestComplaints"] = this.IsPay ? (int)WebCrm.Model.SuggestComplaints.Complaints : (int)WebCrm.Model.SuggestComplaints.Suggest; pageQuery.CurrentPageIndex = AspNetPager1.CurrentPageIndex; pageQuery.PageSize = AspNetPager1.PageSize; UserInfoService.Query(pageQuery); rptList.DataSource = pageQuery.Result; rptList.DataBind(); AspNetPager1.RecordCount = pageQuery.RecordCount; }
public async Task <OperationResponse <IEnumerable <DirectGetProductColorsResult> > > ExecuteAsync(PageQuery <FunzaGetColorsCommandInput> model) { try { var result = new OperationResponse <IEnumerable <DirectGetProductColorsResult> >(); var funzaResponse = await this.ProductColorClient.GetProductColors(); var funzaResult = funzaResponse.Content; result.Bag = funzaResult.Result.AsEnumerable(); return(result); } catch (Exception) { throw; } }
public List <Department> GetDepartment(PredicateGroup group, PageQuery query) { return(base.GetPager(group, query).ToList()); }
public static async Task Main(string[] args) { try { const string collectionName = "TestCollection"; string connectionString = Environment.GetEnvironmentVariable("CUSTOMCONNSTR_MongoDB"); //string connectionString = "mongodb://*****:*****@localhost:27017"; ConventionRegistry.Register("Conventions", new MongoDbConventions(), _ => true); MongoClient mongoClient = new MongoClient(connectionString); IMongoDatabase database = mongoClient.GetDatabase("TestDB"); // Put a break point here and F10. // --> Drop: Collection. database.DropCollection(collectionName); IStudentRepository repository = new StudentRepository(database, collectionName); // --> Seed. await repository.InsertAsync(Student.GenerateStudents(100)); Student student = Student.GenerateStudent(); ReplaceOneResult updateOrInsertResult = await repository.UpdateOrInsertAsync(student, true); // updateOrInsertResult.UpsertedId.AsString // It has a value, in case of insert. student = await repository.GetAsync(student.Id); DeleteResult deleteResult = await repository.DeleteAsync(student.Id); bool exists = await repository.ExistsAsync(s => s.Id == student.Id); IEnumerable <Student> physicists = await repository.FindAsync(s => s.Subjects.Contains("Physics")); // ModifiedCount has to be 0. UpdateResult updateResult = await repository.AddSubjectAsync(physicists.First().Id, "Physics"); updateResult = await repository.RemoveSubjectAsync(physicists.First().Id, "Physics"); long count = await repository.CountAsync(s => s.Subjects.Contains("Physics")); // --> Paged query. PageQuery <Student> pageQuery = PageQuery <Student> .Create(page : 1, pageSize : 20) .Filter(s => s.Age >= 18 && s.Age <= 65) .Sort(sb => sb.Ascending(s => s.Age).Ascending(s => s.Name)); PageResult <Student> studentPageResult = null; do { studentPageResult = await repository.BrowseAsync(pageQuery); // if (studentPageResult.IsNotEmpty) studentPageResult.Items pageQuery.Page++; } while (studentPageResult.HasNextPage); // --> Paged query with projection. PageQuery <Student, StudentDto> pageQueryProjection = PageQuery <Student, StudentDto> .Create(page : 1, pageSize : 20) .Filter(s => s.Age >= 18 && s.Age <= 65) .Sort(sb => sb.Descending("$natural")) // https://docs.mongodb.com/manual/reference/glossary/#term-natural-order .Project(s => new StudentDto { Id = s.Id, Name = s.Name, SubjectCount = s.Subjects.Count() }); PageResult <StudentDto> studentDtoPageResult = null; do { studentDtoPageResult = await repository.BrowseAsync(pageQueryProjection); pageQueryProjection.Page++; } while (studentDtoPageResult.HasNextPage); deleteResult = await repository.DeleteAsync(s => s.Age < 5); } catch (Exception ex) { // MongoException // Do something... Console.WriteLine(ex.Message); } }
public OperationResponse <PageResult <ProductPageQueryCommandOutput> > PageQuery(PageQuery <ProductPageQueryCommandInput> input) { var result = new OperationResponse <PageResult <ProductPageQueryCommandOutput> >(); try { // predicate construction var predicate = PredicateBuilderExtension.True <Product>(); if (input.CustomFilter != null) { var filter = input.CustomFilter; if (!string.IsNullOrWhiteSpace(filter.Term)) { predicate = predicate.And(o => o.ReferenceDescription.Contains(filter.Term, StringComparison.InvariantCultureIgnoreCase)); } } var dbLocator = this.AmbientDbContextLocator.Get <FunzaDBContext>(); { var query = dbLocator.Set <Product>().AsQueryable(); var advancedSorting = new List <SortItem <Product> >(); Expression <Func <Product, object> > expression = null; //if (input.Sort.ContainsKey("erpId")) //{ // expression = o => o.CustomerThirdPartyAppSettings.Where(third => third.ThirdPartyAppTypeId == ThirdPartyAppTypeEnum.BusinessERP).SingleOrDefault().ThirdPartyCustomerId; // advancedSorting.Add(new SortItem<Product> { PropertyName = "erpId", SortExpression = expression, SortOrder = "desc" }); //} var sorting = new SortingDTO <Product>(input.Sort, advancedSorting); result.Bag = query.ProcessPagingSort <Product, ProductPageQueryCommandOutput>(predicate, input, sorting, o => new ProductPageQueryCommandOutput { Id = o.Id, Name = o.ReferenceDescription, CreatedAt = o.CreatedAt }); } } catch (Exception ex) { result.AddException($"Error getting customer page query", ex); } return(result); }
public OperationResponse <PageResult <ProductCategoryPageQueryCommandOutputDTO> > PageQuery(PageQuery <ProductCategoryPageQueryCommandInputDTO> input) { var result = new OperationResponse <PageResult <ProductCategoryPageQueryCommandOutputDTO> >(); try { // predicate construction var predicate = PredicateBuilderExtension.True <ProductCategory>(); if (input.CustomFilter != null) { var filter = input.CustomFilter; if (!string.IsNullOrWhiteSpace(filter.Term)) { predicate = predicate.And(o => o.Name.Contains(filter.Term, StringComparison.InvariantCultureIgnoreCase)); } } var dbLocator = this.AmbientDbContextLocator.Get <RiverdaleDBContext>(); { var query = dbLocator.Set <ProductCategory>().AsQueryable(); var advancedSorting = new List <SortItem <ProductCategory> >(); //var advancedSorting = new List<Expression<Func<ProductCategory, object>>>(); //Expression<Func<ProductCategory, object>> expression; var sorting = new SortingDTO <ProductCategory>(input.Sort, advancedSorting); result.Bag = query.ProcessPagingSort <ProductCategory, ProductCategoryPageQueryCommandOutputDTO>(predicate, input, sorting, o => new ProductCategoryPageQueryCommandOutputDTO { Id = o.Id, Identifier = o.Identifier, Name = o.Name, }); } } catch (Exception ex) { result.AddException($"Error getting customer freightout page query", ex); } return(result); }
public IEnumerable <TReturn> PageQueryBySp <TFirst, TSecond, TThird, TReturn>(PageQuerySqlEntity sqlEntity, PageQuery page, Func <TFirst, TSecond, TThird, TReturn> map, IDbTransaction transaction = null, bool buffered = true, string splitOn = "Id", int?commandTimeout = null) { try { var param = BuildParamsForPageQueryBySp(sqlEntity, page); var lst = this.DbSession.Connection.Query <TFirst, TSecond, TThird, TReturn>(sql: sqlEntity.sp_name, map: map, param: param, transaction: transaction, buffered: buffered, splitOn: splitOn, commandTimeout: commandTimeout, commandType: CommandType.StoredProcedure); page.total = param.Get <Int32>("_totalcount"); page.pageTotal = param.Get <Int32>("_pagecount"); return(lst); } catch { Dispose(); throw; } }
public IActionResult PageQuery([FromBody] PageQuery <SaleOpportunityTargetPricePageQueryCommandInputDTO> input) { var result = this.PageQueryCommand.Execute(input); return(result.IsSucceed ? (IActionResult)this.Ok(result) : (IActionResult)this.BadRequest(result)); }
public static SelectListItem[] BindBussinessPerson(string selectText) { PageQuery<IDictionary<string, object>, OperatorUser> pageQuery = new PageQuery<IDictionary<string, object>, OperatorUser>(HttpCurrentUserService.Current); pageQuery.Condition = new Dictionary<string, object>(); pageQuery.PageSize = int.MaxValue; pageQuery.CurrentPageIndex = 1; pageQuery.Condition["IsCrm"] = "1"; WebCrm.Framework.DependencyResolver.Resolver<IUserInfoService>().Query(pageQuery); return pageQuery.Result.Where(m => m.Deleted == false) .Select(m => new SelectListItem() { Text = m.OperatorName, Value = m.Id.ToString(), Selected = m.Id.ToString() == selectText }).ToArray(); }
public OptResult GetRecordsByPage(PageQuery page) { OptResult rst = null; if (page == null) { rst = OptResult.Build(ResultCode.ParamError, Msg_QueryByPage + ",分页参数不能为空!"); return(rst); } //1、过滤条件 PredicateGroup pg = new PredicateGroup { Operator = GroupOperator.And, Predicates = new List <IPredicate>() }; if (page.conditions != null && page.conditions.Count > 0) { if (page.conditions.ContainsKey("idcard") && page.conditions["idcard"].IsNotEmpty()) { pg.Predicates.Add(Predicates.Field <CardRecord>(r => r.rec_idcard, Operator.Eq, page.conditions["idcard"])); } if (page.conditions.ContainsKey("username") && page.conditions["username"].IsNotEmpty()) { pg.Predicates.Add(Predicates.Field <CardRecord>(r => r.rec_username, Operator.Like, "%" + page.conditions["username"] + "%")); } if (page.conditions.ContainsKey("type") && page.conditions["type"].IsNotEmpty()) { pg.Predicates.Add(Predicates.Field <CardRecord>(r => r.rec_type, Operator.Eq, page.conditions["type"])); } if (page.conditions.ContainsKey("time_begin") && page.conditions["time_begin"].IsNotEmpty()) { pg.Predicates.Add(Predicates.Field <CardRecord>(r => r.rec_time, Operator.Gt, page.conditions["time_begin"]));//>查询起始时间 } if (page.conditions.ContainsKey("time_end") && page.conditions["time_end"].IsNotEmpty()) { pg.Predicates.Add(Predicates.Field <CardRecord>(r => r.rec_time, Operator.Le, page.conditions["time_end"]));//≤查询结束时间 } } //2、排序 long total = 0; IList <ISort> sort = new[] { new Sort { PropertyName = "rec_time", Ascending = false } //按时间降序 }; try { var recs = _cardRecordRep.GetPageList(page.pageIndex, page.pageSize, out total, sort, pg); rst = OptResult.Build(ResultCode.Success, Msg_QueryByPage, new { total = total, rows = recs }); } catch (Exception ex) { LogHelper.LogError(Msg_QueryByPage, ex); rst = OptResult.Build(ResultCode.DbError, Msg_QueryByPage); } return(rst); }
public List <SystemConfig> GetSystemConfig(PredicateGroup group, PageQuery query) { return(base.GetPager(group, query).ToList()); }
public async Task <IActionResult> GetAll([FromRoute] int meetingId, [FromQuery] PageQuery pageQery) { return(HandleServiceResponse(await _service.FindAsync(GetClaims(), meetingId, pageQery))); }
public OperationResponse <PageResult <ProductCategoryPageQueryCommandOutputDTO> > Execute(PageQuery <ProductCategoryPageQueryCommandInputDTO> input) { using (var dbContextScope = this.DbContextScopeFactory.Create()) { return(this.Repository.PageQuery(input)); } }
public void Query(PageQuery <IDictionary <string, object>, Contract> pageQuery) { _contractRepository.Query(pageQuery); }
public async Task <ActionResult <PageDTO <FileAttachmentEntity> > > GetAllMutipartListByPage([FromQuery] PageQuery page) { PageDTO <FileAttachmentEntity> files = await _fileAttachmentService.GetFileAttachmentListByPageAsync(page.pageIndex, page.pageSize); return(Ok(files)); }
public OperationResponse <PageResult <CustomerThirdPartyAppSettingPageQueryCommandOutputDTO> > Execute(PageQuery <CustomerThirdPartyAppSettingPageQueryCommandInputDTO> input) { using (var dbContextScope = this.DbContextScopeFactory.Create()) { return(this.Repository.PageQuery(input)); } }
public void Query(PageQuery <IDictionary <string, object>, OperatorUser> pageQuery) { _userInfoRepository.Query(pageQuery); }
/// <summary> /// 绑定列表 /// </summary> private void BindList(string condition = " DELETED !=1 ") { var pageQuery = new PageQuery<CustomerContactQuery, CustomerContactInfo>(CurrentOperatorUser); pageQuery.Condition = new CustomerContactQuery(); if (BeginDate.Text.IsDateTime()) { pageQuery.Condition.EndBirthday = DateTime.Parse(BeginDate.Text); } if (MySelfData.Checked) { pageQuery.Condition.BussinessPerson = this.CurrentOperatorUser; } pageQuery.CurrentPageIndex = AspNetPager1.CurrentPageIndex; pageQuery.PageSize = AspNetPager1.PageSize; UserInfoService.Query(pageQuery); rptList.DataSource = pageQuery.Result; rptList.DataBind(); AspNetPager1.RecordCount = pageQuery.RecordCount; }