public async Task <List <t_equipmentListDto> > t_equipmentList(t_equipmentListInputDto input)
{
return(await JIT_t_equipment.GetAll().Join(JIT_t_OrganizationUnit.GetAll(), A => A.FWorkCenterID, B => B.Id,
(A, B) => new
{
A.FInterID,
A.FNumber,
A.FName,
B.DisplayName,
A.FType,
A.FWorkCenterID
})
.Where(w => w.FType == PublicEnum.EquipmentType.设备 && w.FName.Contains(input.FName) &&
(input.FWorkCenterID.Equals(0) || w.FWorkCenterID.Equals(input.FWorkCenterID))).Select(s =>
new t_equipmentListDto
{
FInterID = s.FInterID,
FNumber = s.FNumber,
FName = s.FName,
DisplayName = s.DisplayName,
FWorkCenterID = s.FWorkCenterID
})
.PageBy(input)
.ToListAsync());
}
/// <summary>
/// 获取所有车间
/// </summary>
public async Task <List <SelectModel> > GetSelectModel()
{
return(await JIT_t_OrganizationUnit.GetAll()
.Select(s => new SelectModel {
value = s.Id.ToString(), title = s.DisplayName
}).ToListAsync());
}
public async Task <int> Create(OrganizationCreateInput input)
{
try
{
var entity = new t_OrganizationUnit()
{
Code = input.Code,
ParentId = int.Parse(input.ParentId.ToString() == null ? "0" : input.ParentId.ToString()),
TenantId = this.AbpSession.TenantId.HasValue ? this.AbpSession.TenantId.Value : 0,
CreationTime = DateTime.Now,
CreatorUserId = this.AbpSession.UserId.HasValue ? this.AbpSession.UserId.Value : 0,
DisplayName = input.DisplayName,
IsDeleted = false,
OrganizationType = Enum.Parse <PublicEnum.OrganizationType>(input.OrganizationType.ToString()), //组织类型
DataBaseConnection = input.DataBaseConnection, //数据库连接
ERPOrganizationLeader = input.ERPOrganizationLeader == null ? 0 : input.ERPOrganizationLeader, //组织负责人
ERPOrganization = input.ERPOrganization == null ? 0 : input.ERPOrganization,
Remark = input.Remark,
FWorkshopType = input.FWorkshopType
};
return(await JIT_t_OrganizationUnit.InsertAndGetIdAsync(entity));
}
catch (Exception e)
{
Console.WriteLine(e.Message);
}
return(0);
}
public async Task <int> Delete(OrganizationDeleteDto input)
{
var count = 0;
var query = JIT_t_OrganizationUnit.GetAll().Where(p => p.Id == input.Id)
.Include(p => p.Children);
var entity = await query.SingleOrDefaultAsync(p => true);
var ORByID = JIT_t_OrganizationUnit.GetAll().SingleOrDefault(p => p.Id == entity.ParentId);
var EmployeeByID = EmployeeApp.GetOneselfAndJunior(new int[] { input.Id });
List <Entities.Employee> EmployeeList = new EditableList <Entities.Employee>();
if (EmployeeByID != null)
{
EmployeeList = EmployeeApp._ERepository.GetAll()
.Where(p => p.IsDeleted == false && EmployeeByID.Contains(p.FDepartment)).ToList();
}
if (entity != null)
{
foreach (var e in EmployeeList)
{
if (ORByID != null)
{
e.FDepartment = ORByID.Id;
}
else
{
e.FDepartment = EmployeeApp._ERepository.GetAll().FirstOrDefault(p => p.Id == entity.ParentId && p.IsDeleted == false).Id;
}
EmployeeApp._ERepository.Update(e);
}
entity.IsDeleted = true;
entity.DeletionTime = DateTime.Now;
entity.DeleterUserId = this.AbpSession.UserId.HasValue ? this.AbpSession.UserId.Value : 0;
count++;
foreach (var c in entity.Children)
{
c.IsDeleted = true;
c.DeletionTime = DateTime.Now;
c.DeleterUserId = this.AbpSession.UserId.HasValue ? this.AbpSession.UserId.Value : 0;
count++;
}
await JIT_t_OrganizationUnit.UpdateAsync(entity);
}
return(count);
}
public async Task <List <OrganizationDto> > GetChildMenuList(int ParentID)
{
var quers = await JIT_t_OrganizationUnit.GetAll().Where(p => p.IsDeleted == false).ToListAsync();
var list = quers.MapTo <List <OrganizationDto> >();
var result = list.Where(x => x.ParentId == ParentID);
return(result.ToList());
}
public async Task <t_OrganizationUnit> Update(OrganizationCreateInput input)
{
var entity = input.MapTo <t_OrganizationUnit>();
entity.Id = input.Id;
entity.TenantId = this.AbpSession.TenantId.HasValue ? this.AbpSession.TenantId.Value : 0;
entity.IsDeleted = false;
entity.LastModificationTime = DateTime.Now;
entity.LastModifierUserId = this.AbpSession.UserId.HasValue ? this.AbpSession.UserId.Value : 0;
entity.CreationTime = input.CreationTime;
entity.CreatorUserId = input.CreatorUserId;
return(await JIT_t_OrganizationUnit.UpdateAsync(entity));;
}
public async Task <List <OrganizationDtoTest> > GetAll(OrganizationGetAllInput input)
{
var query = JIT_t_OrganizationUnit.GetAll().Where(p => p.IsDeleted.HasValue && !p.IsDeleted.Value);
if (input.OrganizationType.HasValue)
{
//过滤组织类型
OrganizationTypeSpecification wcsf = new OrganizationTypeSpecification(input.OrganizationType.Value);
query = query.Where(wcsf);
}
if (input.isWorkCenter)
{
query = query.Where(p => p.FWorkshopType);
}
var data = await query.ToListAsync();
return(data.MapTo <List <OrganizationDtoTest> >());
}
public async Task <t_OrganizationUnit> Get(OrganizationDeleteDto input)
{
var entity = await JIT_t_OrganizationUnit.GetAll().SingleOrDefaultAsync(p => p.Id == input.Id && p.IsDeleted == false);
return(entity.MapTo <t_OrganizationUnit>());
}
