132 lines
5.2 KiB
C#
132 lines
5.2 KiB
C#
using Infrastructure.Attribute;
|
|
using Microsoft.AspNetCore.Http;
|
|
using SqlSugar;
|
|
using System;
|
|
using System.Collections.Generic;
|
|
using System.Linq;
|
|
using System.Text;
|
|
using System.Threading.Tasks;
|
|
using ARW.Model;
|
|
using ARW.Repository;
|
|
using ARW.Repository.Business.Project.ProjectGroups;
|
|
using ARW.Service.Api.IBusinessService.Project.ProjectGroups;
|
|
using ARW.Model.Dto.Api.Project.ProjectGroups;
|
|
using ARW.Model.Models.Business.Project.ProjectGroups;
|
|
using ARW.Model.Vo.Api.Project.ProjectGroups;
|
|
|
|
namespace ARW.Service.Api.BusinessService.Project.ProjectGroups
|
|
{
|
|
/// <summary>
|
|
/// 项目分组接口实现类
|
|
/// </summary>
|
|
[AppService(ServiceType = typeof(IProjectGroupServiceApi), ServiceLifetime = LifeTime.Transient)]
|
|
public class ProjectGroupServiceImplApi : BaseService<ProjectGroup>, IProjectGroupServiceApi
|
|
{
|
|
private readonly ProjectGroupRepository _ProjectGroupRepository;
|
|
|
|
public ProjectGroupServiceImplApi(ProjectGroupRepository ProjectGroupRepository)
|
|
{
|
|
this._ProjectGroupRepository = ProjectGroupRepository;
|
|
}
|
|
|
|
#region Api接口代码
|
|
|
|
|
|
/// <summary>
|
|
/// 查询项目分组树形列表(Api)
|
|
/// </summary>
|
|
/// <param name="parm"></param>
|
|
/// <returns></returns>
|
|
public List<ProjectGroupApiVo> GetProjectGroupTreeListApi(ProjectGroupQueryApiDto parm)
|
|
{
|
|
//开始拼装查询条件d
|
|
var predicate = Expressionable.Create<ProjectGroup>();
|
|
|
|
predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.ProjectGroupName), it => it.ProjectGroupName == parm.ProjectGroupName);
|
|
var query = _ProjectGroupRepository
|
|
.Queryable()
|
|
.LeftJoin<ProjectGroup>((s, c) => s.ProjectGroupParentGuid == c.ProjectGroupGuid)
|
|
.Where(predicate.ToExpression())
|
|
.Where(s => s.ProjectGroupCustomerGuid == parm.ToolCustomerGuid)
|
|
.OrderBy(s => s.ProjectGroupSort, OrderByType.Asc)
|
|
.Select((s, c) => new ProjectGroupApiVo
|
|
{
|
|
ProjectGroupId = s.ProjectGroupId,
|
|
ProjectGroupGuid = s.ProjectGroupGuid,
|
|
ProjectGroupParentGuid = s.ProjectGroupParentGuid,
|
|
ProjectGroupAncestralGuid = s.ProjectGroupAncestralGuid,
|
|
ProjectGroupCustomerGuid = s.ProjectGroupCustomerGuid,
|
|
ProjectGroupName = s.ProjectGroupName,
|
|
ProjectGroupSort = s.ProjectGroupSort,
|
|
ParentName = c.ProjectGroupName,
|
|
});
|
|
|
|
return query.ToTree(it => it.Children, it => it.ProjectGroupParentGuid, 0);
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// 查询项目分组树形列表(Api)
|
|
/// </summary>
|
|
/// <param name="parm"></param>
|
|
/// <returns></returns>
|
|
public List<ProjectGroupApiVo> GetProjectGroupListApi(ProjectGroupQueryApiDto parm)
|
|
{
|
|
//开始拼装查询条件d
|
|
var predicate = Expressionable.Create<ProjectGroup>();
|
|
|
|
predicate = predicate.AndIF(!string.IsNullOrEmpty(parm.ProjectGroupName), it => it.ProjectGroupName == parm.ProjectGroupName);
|
|
var query = _ProjectGroupRepository
|
|
.Queryable()
|
|
.LeftJoin<ProjectGroup>((s, c) => s.ProjectGroupParentGuid == c.ProjectGroupGuid)
|
|
.Where(predicate.ToExpression())
|
|
.Where(s => s.ProjectGroupCustomerGuid == parm.ToolCustomerGuid)
|
|
.OrderBy(s => s.ProjectGroupSort, OrderByType.Asc)
|
|
.Select((s, c) => new ProjectGroupApiVo
|
|
{
|
|
ProjectGroupId = s.ProjectGroupId,
|
|
ProjectGroupGuid = s.ProjectGroupGuid,
|
|
ProjectGroupParentGuid = s.ProjectGroupParentGuid,
|
|
ProjectGroupAncestralGuid = s.ProjectGroupAncestralGuid,
|
|
ProjectGroupCustomerGuid = s.ProjectGroupCustomerGuid,
|
|
ProjectGroupName = s.ProjectGroupName,
|
|
ProjectGroupSort = s.ProjectGroupSort,
|
|
ParentName = c.ProjectGroupName,
|
|
});
|
|
|
|
return query.ToList();
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// 查询项目分组详情(Api)
|
|
/// </summary>
|
|
/// <param name="parm"></param>
|
|
/// <returns></returns>
|
|
public Task<string> GetProjectGroupDetails(ProjectGroupApiDto parm)
|
|
{
|
|
|
|
var query = _ProjectGroupRepository
|
|
.Queryable()
|
|
.Where(s => s.ProjectGroupGuid == parm.ProjectGroupGuid)
|
|
.Select(s => new ProjectGroupApiDetailsVo
|
|
{
|
|
ProjectGroupId = s.ProjectGroupId,
|
|
ProjectGroupGuid = s.ProjectGroupGuid,
|
|
ProjectGroupParentGuid = s.ProjectGroupParentGuid,
|
|
ProjectGroupAncestralGuid = s.ProjectGroupAncestralGuid,
|
|
ProjectGroupCustomerGuid = s.ProjectGroupCustomerGuid,
|
|
ProjectGroupName = s.ProjectGroupName,
|
|
ProjectGroupSort = s.ProjectGroupSort,
|
|
}).Take(1);
|
|
|
|
|
|
return query.ToJsonAsync();
|
|
}
|
|
|
|
|
|
#endregion
|
|
|
|
}
|
|
}
|