namespace Yw.DAL
|
{
|
/// <summary>
|
/// RepairRequestForm
|
/// </summary>
|
public interface IRepairRequestForm : IBaseTraceDAL<Entity.RepairRequestForm>
|
{
|
|
/// <summary>
|
/// 获取最近列表
|
/// </summary>
|
List<Entity.RepairRequestForm> GetLastList(int Number = 1);
|
|
/// <summary>
|
/// 获取所有待受理的数据
|
/// </summary>
|
List<Entity.RepairRequestForm> GetPendingList();
|
|
/// <summary>
|
/// 获取待受理的数量
|
/// </summary>
|
int GetPendingCount();
|
|
/// <summary>
|
/// 通过 FormStatus 获取
|
/// </summary>
|
List<Entity.RepairRequestForm> GetByFormStatus(int FormStatus);
|
|
/// <summary>
|
/// 通过 FormStatus 获取数量
|
/// </summary>
|
int GetCountByFormStatus(int FormStatus);
|
|
/// <summary>
|
/// 通过 EquipmentID 获取
|
/// </summary>
|
List<Entity.RepairRequestForm> GetByEquipmentID(long EquipmentID);
|
|
/// <summary>
|
/// 通过 EquipmentIds 获取
|
/// </summary>
|
List<Entity.RepairRequestForm> GetByEquipmentIds(List<long> EquipmentIds);
|
|
/// <summary>
|
/// 获取某日的数量
|
/// </summary>
|
int GetCountOfDay(DateTime Day);
|
|
/// <summary>
|
/// 更新 FormStatus
|
/// </summary>
|
bool UpdateFormStatus(long ID, int FormStatus);
|
|
/// <summary>
|
/// 插入
|
/// </summary>
|
long Insert(Entity.RepairRequestForm entity, List<Entity.RepairRequestFile> entity4FileList)
|
{
|
if (string.IsNullOrEmpty(entity.FormNo))
|
{
|
var count = GetCountOfDay(entity.CreateTime) + 1;
|
entity.FormNo = $"R{entity.CreateTime.ToString("yyyyMMdd")}{count.ToString("000000")}";
|
}
|
using (var db = new SqlSugarClient(ConnectionConfig))
|
{
|
try
|
{
|
db.BeginTran();
|
var formId = db.Insertable(entity).ExecuteReturnSnowflakeId();
|
if (formId < 1)
|
{
|
db.RollbackTran();
|
return default;
|
}
|
var entity4Log = new Entity.RepairRequestLog();
|
entity4Log.FormID = formId;
|
entity4Log.OperateType = (int)eRequestOperation.Create;
|
entity4Log.OperateContent = "创建";
|
entity4Log.OperateTime = entity.CreateTime;
|
entity4Log.OperateUserID = entity.CreateUserID;
|
entity4Log.OperateUserName = entity.CreateUserName;
|
entity4Log.OperateNote = "创建";
|
var logId = db.Insertable(entity4Log).ExecuteReturnSnowflakeId();
|
if (logId < 1)
|
{
|
db.RollbackTran();
|
return default;
|
}
|
if (entity4FileList != null && entity4FileList.Count > 0)
|
{
|
entity4FileList.ForEach(x => x.FormID = formId);
|
var fileIds = db.Insertable(entity4FileList).ExecuteReturnSnowflakeIdList();
|
if (fileIds == null || fileIds.Count != entity4FileList.Count)
|
{
|
db.RollbackTran();
|
return default;
|
}
|
}
|
|
db.CommitTran();
|
return formId;
|
}
|
catch
|
{
|
db.RollbackTran();
|
throw;
|
}
|
}
|
}
|
|
/// <summary>
|
/// 驳回
|
/// </summary>
|
bool Reject(long ID, string Reason);
|
|
/// <summary>
|
/// 受理
|
/// </summary>
|
bool Accept(long ID, string Note);
|
|
/// <summary>
|
/// 获取我的模糊分页列表
|
/// </summary>
|
List<Entity.RepairRequestForm> GetMyFluzzyPageList
|
(
|
long CreateUserID,
|
int? FormStatus,
|
int? Urgency,
|
DateTime? StartTime,
|
DateTime? EndTime,
|
int PageIndex,
|
int PageSize,
|
ref int Total
|
);
|
|
/// <summary>
|
/// 获取模糊分页列表
|
/// </summary>
|
List<Entity.RepairRequestForm> GetFluzzyPageList
|
(
|
List<long> EquipmentIds,
|
long? CreateUserID,
|
int? FormStatus,
|
int? Urgency,
|
string FormNo,
|
DateTime? StartTime,
|
DateTime? EndTime,
|
int PageIndex,
|
int PageSize,
|
ref int Total
|
);
|
|
/// <summary>
|
/// 获取待派单分页列表
|
/// </summary>
|
List<Tuple<Entity.RepairRequestForm, Entity.RepairTaskForm>> GetJustAccepedPageList
|
(
|
List<long> EquipmentIds,
|
long? CreateUserID,
|
int? Urgency,
|
string FormNo,
|
DateTime? StartTime,
|
DateTime? EndTime,
|
int PageIndex,
|
int PageSize,
|
ref int Total
|
);
|
|
|
|
|
}
|
}
|
