138 lines
4.8 KiB
C#
138 lines
4.8 KiB
C#
using System;
|
|
using SqlSugar;
|
|
using Infrastructure.Attribute;
|
|
using Infrastructure.Extensions;
|
|
using ZR.Model;
|
|
using ZR.Repository;
|
|
|
|
using System.Linq;
|
|
using ZR.Model.MES.dev;
|
|
using ZR.Model.MES.dev.Dto;
|
|
using ZR.Service.MES.dev.IService;
|
|
|
|
namespace ZR.Service.MES.dev
|
|
{
|
|
/// <summary>
|
|
/// 报修单Service业务层处理
|
|
/// </summary>
|
|
[AppService(ServiceType = typeof(IDeviceRepairService), ServiceLifetime = LifeTime.Transient)]
|
|
public class DeviceRepairService : BaseService<DeviceRepair>, IDeviceRepairService
|
|
{
|
|
/// <summary>
|
|
/// 查询报修单列表
|
|
/// </summary>
|
|
/// <param name="parm"></param>
|
|
/// <returns></returns>
|
|
public PagedInfo<DeviceRepairDto> GetList(DeviceRepairQueryDto parm)
|
|
{
|
|
var predicate = Expressionable.Create<DeviceRepair>()
|
|
.AndIF(!string.IsNullOrEmpty(parm.RepairOrder), dr => dr.RepairOrder.Contains(parm.RepairOrder))
|
|
.AndIF(!string.IsNullOrEmpty(parm.RepairPeron), dr => dr.RepairPeron.Contains(parm.RepairPeron))
|
|
.AndIF(!string.IsNullOrEmpty(parm.Phone), dr => dr.Phone.Contains(parm.Phone))
|
|
.AndIF(parm.FkDeviceId > 0, dr => dr.FkDeviceId == parm.FkDeviceId)
|
|
.AndIF(!string.IsNullOrEmpty(parm.Type), dr => dr.Type == parm.Type)
|
|
.AndIF(parm.Status > -1, dr => dr.Status == parm.Status)
|
|
.AndIF(parm.TimeRange != null && (parm.TimeRange[0] > new DateTime(1990, 1, 1)), dr => dr.CreatedTime >= parm.TimeRange[0])
|
|
.AndIF(parm.TimeRange != null && (parm.TimeRange[1] > new DateTime(1990, 1, 1)), dr => dr.CreatedTime <= parm.TimeRange[1])
|
|
;
|
|
|
|
var response = Queryable()
|
|
.LeftJoin<DeviceAccount>((dr, da) => dr.FkDeviceId == da.Id)
|
|
.Where(predicate.ToExpression())
|
|
.Select<DeviceRepairDto>()
|
|
.ToPage(parm);
|
|
//.ToPage<DeviceRepair, DeviceRepairDto>(parm);
|
|
|
|
return response;
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// 获取详情
|
|
/// </summary>
|
|
/// <param name="Id"></param>
|
|
/// <returns></returns>
|
|
public DeviceRepair GetInfo(string Id)
|
|
{
|
|
var response = Queryable()
|
|
.Where(x => x.Id == Id)
|
|
.First();
|
|
|
|
return response;
|
|
}
|
|
|
|
/// <summary>
|
|
/// 添加报修单
|
|
/// </summary>
|
|
/// <param name="model"></param>
|
|
/// <returns></returns>
|
|
public DeviceRepair AddDeviceRepair(DeviceRepair model)
|
|
{
|
|
model.Id = SnowFlakeSingle.Instance.NextId().ToString();
|
|
model.RepairOrder = GetNextRepairNo();
|
|
model.Status = 1;
|
|
return Context.Insertable(model).ExecuteReturnEntity();
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
/// 生成维修单编号
|
|
/// </summary>
|
|
/// <returns></returns>
|
|
public string GetNextRepairNo()
|
|
{
|
|
string split = "-";
|
|
string titleStr = "MR";
|
|
string timeStr = DateTime.Now.ToString("yyyyMMdd");
|
|
var predicate = Expressionable.Create<DeviceRepair>()
|
|
.And(it => it.RepairOrder.Contains(timeStr));
|
|
var lastDeviceRepair = Queryable()
|
|
.Where(predicate.ToExpression())
|
|
.OrderByDescending(it => it.Id)
|
|
.First();
|
|
if (lastDeviceRepair != null && lastDeviceRepair.RepairOrder != null)
|
|
{
|
|
if (int.TryParse(lastDeviceRepair.RepairOrder.Split(split)[2], out int lastNum))
|
|
{
|
|
return titleStr + split + timeStr + split + (lastNum + 1).ToString("000");
|
|
}
|
|
else
|
|
{
|
|
return titleStr + split + timeStr + split + "001";
|
|
}
|
|
|
|
}
|
|
else
|
|
{
|
|
return titleStr + split + timeStr + split + "001";
|
|
}
|
|
|
|
}
|
|
|
|
/// <summary>
|
|
/// 修改报修单
|
|
/// </summary>
|
|
/// <param name="model"></param>
|
|
/// <returns></returns>
|
|
public int UpdateDeviceRepair(DeviceRepair model)
|
|
{
|
|
//var response = Update(w => w.Id == model.Id, it => new DeviceRepair()
|
|
//{
|
|
// RepairOrder = model.RepairOrder,
|
|
// Type = model.Type,
|
|
// RepairPeron = model.RepairPeron,
|
|
// Phone = model.Phone,
|
|
// FaultDescription = model.FaultDescription,
|
|
// File = model.File,
|
|
// Status = model.Status,
|
|
// CreatedBy = model.CreatedBy,
|
|
// CreatedTime = model.CreatedTime,
|
|
// UpdatedBy = model.UpdatedBy,
|
|
// UpdatedTime = model.UpdatedTime,
|
|
//});
|
|
//return response;
|
|
return Update(model, true);
|
|
}
|
|
|
|
}
|
|
} |