/// <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;
}
