protected async Task <Tuple <int, List <Company> > > GetPagedCompanyList(GetCompanyInput input) { var query = _companyRepositoryAsNoTrack; //TODO:根据传入的参数添加过滤条件 query = query.WhereIf(!string.IsNullOrEmpty(input.CompanyName), c => c.CompanyName.Contains(input.CompanyName)) // .WhereIf(!string.IsNullOrEmpty(input.IndustryCode), // c => c.Industries.Any(i => i.Industry.IndustryCode == input.IndustryCode)) .WhereIf(input.IndustryId > 0, c => c.Industries.Any(i => i.IndustryId == input.IndustryId)) .WhereIf(!string.IsNullOrEmpty(input.RegionCode), c => c.RegionCode == input.RegionCode) .WhereIf(!string.IsNullOrEmpty(input.RegionParentCode), c => c.Region.ParentCode == input.RegionParentCode) .WhereIf(input.IsAuthed != null, c => c.IsAuthed == input.IsAuthed) .WhereIf(input.IsActive != null, c => c.IsActive == input.IsActive); var companyCount = await query.CountAsync(); var companys = query .OrderBy(input.Sorting) .PageBy(input) .ToListAsync().Result; return(new Tuple <int, List <Company> >(companyCount, companys)); }
public GetCompanyOutput GetById(GetCompanyInput input) { var kt = _companyService.GetById(input.Code); var output = Mapper.Map <Models.Company.Company, GetCompanyOutput>(kt); return(output); }
public async Task <PagedResultDto <NewCompanyListDto> > GetCompanys(GetCompanyInput input) { int TenantId = (int)(AbpSession.TenantId); using (_unitOfWorkManager.Current.SetTenantId(TenantId)) { var query = _NewCompanyRepository.GetAll() .WhereIf( !input.Filter.IsNullOrEmpty(), p => p.Name.Contains(input.Filter) || p.CustomerTypes.Title.Contains(input.Filter) ); var company = (from a in query select new NewCompanyListDto { Id = a.Id, CompanyName = a.Name, CustomerTypeName = a.CustomerTypes.Title, NewCustomerTypeId = a.CustomerTypeId, AccountManagerId = a.AccountManagerId, ManagedBy = a.AbpAccountManager.UserName, CountryCode = a.CountryId != null ? a.Countrys.CountryName : "", CurrencyCode = a.CurrencyId != null ? a.Currencys.Code : "" }); var companyCount = await company.CountAsync(); var companylist = await company .OrderBy(input.Sorting) .PageBy(input) .ToListAsync(); try { } catch (Exception es) { } var companylistoutput = companylist.MapTo <List <NewCompanyListDto> >(); return(new PagedResultDto <NewCompanyListDto>( companyCount, companylistoutput)); } }
/// <summary> /// 根据查询条件获取企业表分页列表 /// </summary> public async Task <PagedResultDto <CompanyListDto> > GetPagedCompanysAsync(GetCompanyInput input) { var query = _companyRepositoryAsNoTrack; //TODO:根据传入的参数添加过滤条件 // var companyCount = await query.CountAsync(); // // var companys = query // .OrderBy(input.Sorting) // .PageBy(input) // .ToListAsync().Result; var tupleResult = GetPagedCompanyList(input); var companyListDtos = tupleResult.Result.Item2.MapTo <List <CompanyListDto> >(); return(new PagedResultDto <CompanyListDto>( tupleResult.Result.Item1, companyListDtos )); }
/// <summary> /// 根据查询条件获取企业信息分页列表 /// </summary> public async Task <PagedResultDto <CompanyListDto> > GetPagedCompanysAsync(GetCompanyInput input) { var query = _companyRepositoryAsNoTrack; //TODO:根据传入的参数添加过滤条件 var companyCount = await query.CountAsync(); var companys = await query .OrderBy(input.Sorting) .PageBy(input) .ToListAsync(); var companyListDtos = companys.MapTo <List <CompanyListDto> >(); return(new PagedResultDto <CompanyListDto>( companyCount, companyListDtos )); }
public async Task <PagedResultDto <CompanyViewDt> > GetCompanies(GetCompanyInput input) { var query = _CompanyRepository.GetAll() .WhereIf( !input.Filter.IsNullOrWhiteSpace(), p => p.CompanyCode.Contains(input.Filter) || p.CompanyName.Contains(input.Filter) || p.Address.Contains(input.Filter) || p.Email.Contains(input.Filter) || p.Fax.Contains(input.Filter) || p.Cities.CityName.Contains(input.Filter) || p.CustomerTypes.CustomerTypeName.Contains(input.Filter)); var companycount = await query.CountAsync(); var companydto = from c in query select new CompanyViewDt { Id = c.Id, CompanyCode = c.CompanyCode, CompanyName = c.CompanyName, City = c.Cities.CityName, Address = c.Address, Country = c.Cities.Country.CountryName, Fax = c.Fax, TelNo = c.TelNo, CustomerType = c.CustomerTypes.CustomerTypeName, Phone = c.PhoneNo, Email = c.Email, AccountManager = c.AbpAccountManager.UserName }; var companydtos = await companydto.OrderBy(input.Sorting).PageBy(input).ToListAsync(); var companydtoss = companydtos.MapTo <List <CompanyViewDt> >(); return(new PagedResultDto <CompanyViewDt>(companycount, companydtoss)); }
public async Task <PagedResultDto <CompanyListWithProductsDto> > GetPagedCompanysWithProductsAsync(GetCompanyInput input) { var tupleResult = GetPagedCompanyList(input); var companyListDtos = tupleResult.Result.Item2.MapTo <List <CompanyListWithProductsDto> >(); return(new PagedResultDto <CompanyListWithProductsDto>( tupleResult.Result.Item1, companyListDtos )); }
public async Task <List <Company> > GetCompany(GetCompanyInput Parameters) { return(await CompanyManager.GetCompany(Parameters)); }
//public async Task<PagedResultDto<NewCompanyListDto>> GetCompanys(GetCompanyInput input) //{ // var query = _NewCompanyRepository.GetAll() // .WhereIf( // !input.Filter.IsNullOrEmpty(), // p => p.Name.Contains(input.Filter) || // p.NewCustomerTypes.Title.Contains(input.Filter) // ); // var company = (from a in query select new NewCompanyListDto { // Id = a.Id, // CompanyName = a.Name, // CustomerId = a.CustomerId, // CustomerTypeName = a.NewCustomerTypes.Title, // NewCustomerTypeId = a.NewCustomerTypeId, // AccountManagerId = a.AccountManagerId, // ManagedBy = a.AbpAccountManager.UserName, // ApprovedById = a.ApprovedById, // ApprovedBy = a.AbpApprovedBy.UserName, // IsApproved = a.IsApproved, // CreatedBy = "", // CreationTime = a.LastModificationTime ?? a.CreationTime, // CreatedUserId = a.CreatorUserId ?? 0 , // TRNnumber = a.TRNnumber, // TradeLicense = a.TradeLicense, // IndustryName = a.IndustryId != null ? a.Industries.IndustryName : "", // Discountable = a.Discountable, // UnDiscountable = a.UnDiscountable // }); // var companyCount = await company.CountAsync(); // var companylist = await company.ToListAsync(); // if (input.Sorting == "CompanyName,CustomerTypeName,ManagedBy,ApprovedBy,CustomerId,IsApproved,CreatedBy") // { // companylist = await company // .OrderBy(a => a.CreationTime) // .PageBy(input) // .ToListAsync(); // } // else // { // companylist = await company // .OrderBy(input.Sorting) // .PageBy(input) // .ToListAsync(); // } // foreach (var r in companylist) // { // if (r.CreatedUserId > 0) // { // var user = await UserManager.GetUserByIdAsync(r.CreatedUserId); // r.CreatedBy = user.UserName; // } // } // var companylistoutput = companylist.MapTo<List<NewCompanyListDto>>(); // return new PagedResultDto<NewCompanyListDto>( // companyCount, companylistoutput); //} public async Task <PagedResultDto <NewCompanyListDto> > GetCompanys(GetCompanyInput input) { long userid = (int)AbpSession.UserId; var userrole = (from c in UserManager.Users join urole in _userRoleRepository.GetAll() on c.Id equals urole.UserId join role in _roleManager.Roles on urole.RoleId equals role.Id where urole.UserId == userid select role).FirstOrDefault(); var query = _NewCompanyRepository.GetAll().Where(r => r.Id == 0); if (userrole.DisplayName == "Sales Executive" || userrole.DisplayName == "Sales Coordinator / Sales Executive") { query = (from comp in _NewCompanyRepository.GetAll() where comp.AccountManagerId == userid select comp); } else if (userrole.DisplayName == "Sales Manager" || userrole.DisplayName == "Sales Manager / Sales Executive") { query = (from com in _NewCompanyRepository.GetAll() join q in _TeamDetailRepository.GetAll() on com.AccountManagerId equals q.SalesmanId join r in _TeamRepository.GetAll() on q.TeamId equals r.Id where r.SalesManagerId == userid select com); } else { query = _NewCompanyRepository.GetAll(); } query = query .WhereIf( !input.Filter.IsNullOrEmpty(), p => p.Name.Contains(input.Filter) || p.NewCustomerTypes.Title.Contains(input.Filter) ); var company = (from a in query select new NewCompanyListDto { Id = a.Id, CompanyName = a.Name, CustomerId = a.CustomerId, CustomerTypeName = a.NewCustomerTypes.Title, NewCustomerTypeId = a.NewCustomerTypeId, AccountManagerId = a.AccountManagerId, ManagedBy = a.AbpAccountManager.UserName, ApprovedById = a.ApprovedById, ApprovedBy = a.AbpApprovedBy.UserName, IsApproved = a.IsApproved, CreatedBy = "", CreationTime = a.LastModificationTime ?? a.CreationTime, CreatedUserId = a.CreatorUserId ?? 0, TRNnumber = a.TRNnumber, TradeLicense = a.TradeLicense, IndustryName = a.IndustryId != null ? a.Industries.IndustryName : "", Discountable = a.Discountable, UnDiscountable = a.UnDiscountable }); var companyCount = await company.CountAsync(); var companylist = await company.ToListAsync(); if (input.Sorting == "CompanyName,CustomerTypeName,ManagedBy,ApprovedBy,CustomerId,IsApproved,CreatedBy") { companylist = await company .OrderBy(a => a.CreationTime) .PageBy(input) .ToListAsync(); } else { companylist = await company .OrderBy(input.Sorting) .PageBy(input) .ToListAsync(); } foreach (var r in companylist) { if (r.CreatedUserId > 0) { var user = await UserManager.GetUserByIdAsync(r.CreatedUserId); r.CreatedBy = user.UserName; } } var companylistoutput = companylist.MapTo <List <NewCompanyListDto> >(); return(new PagedResultDto <NewCompanyListDto>( companyCount, companylistoutput)); }
public static async Task <List <Company> > GetCompany(GetCompanyInput Parameters) { var List = new List <Company>(); var projection = Builders <Company> .Projection; var project = projection.Exclude("_id"); var filter = FilterDefinition <Company> .Empty; BsonValue val; if (Parameters.ColumnType == "int") { val = Convert.ToInt64(Parameters.Value); } else if (Parameters.ColumnType == "bool") { val = Convert.ToBoolean(Parameters.Value); } else { val = Convert.ToString(Parameters.Value); } if (Parameters.Statement == "=") { filter = Builders <Company> .Filter.Eq(Parameters.Column, val); } else if (Parameters.Statement == "<") { filter = Builders <Company> .Filter.Lt(Parameters.Column, val); } else if (Parameters.Statement == ">") { filter = Builders <Company> .Filter.Gt(Parameters.Column, val); } var option = new FindOptions <Company, BsonDocument> { Projection = project }; using (var cursor = await db.GetCollection <Company>("Company").FindAsync(filter, option)) { while (await cursor.MoveNextAsync()) { var batch = cursor.Current; foreach (BsonDocument s in batch) { var Company = new Company(); if (s.Contains("CompanyID")) { Company.CompanyID = s["CompanyID"].AsString; } if (s.Contains("CompanyName")) { Company.CompanyName = s["CompanyName"].AsString; } List.Add(Company); } } } return(List); }