using DataEntity;
|
using DataRWDAL.Base;
|
using HxEnum;
|
using SqlSugar;
|
using System.Collections.Generic;
|
using System.Linq;
|
using XCommon.SqlSugar;
|
using static HxEnum.OperationTypeEnum;
|
|
namespace XImagingXhandler.XDAL
|
{
|
/// <summary>
|
/// 错误状态表
|
/// </summary>
|
public class ErrorStateDB : BaseDB
|
{
|
/// <summary>
|
/// 登录错误状态
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public static int AddErrorState(ErrorStateModel model)
|
{
|
using (var db = GetInstance())
|
{
|
return db.Insertable<ErrorStateModel>(model).ExecuteCommand();
|
}
|
}
|
|
#region 跳过
|
/// <summary>
|
/// 跳过
|
/// </summary>
|
/// <param name="expId"></param>
|
/// <param name="statusEnum"></param>
|
/// <param name="expOperationTypeEnum"></param>
|
public static void Continue(string expId, ExpStatusEnum statusEnum, NodeOperationTypeEnum expOperationTypeEnum)
|
{
|
UpStatus(expId, statusEnum, expOperationTypeEnum);
|
|
UpdateErrorState();
|
}
|
#endregion
|
|
#region 更新实验状态完成
|
/// <summary>
|
/// 更新实验状态完成
|
/// </summary>
|
/// <param name="id"></param>
|
/// <param name="statusEnum"></param>
|
/// <param name="expOperationTypeEnum"></param>
|
private static void UpStatus(string id, ExpStatusEnum statusEnum, NodeOperationTypeEnum expOperationTypeEnum)
|
{
|
//var model = experimentBLL.GetExperimentById(id);
|
|
//if (model != null)
|
//{
|
// string executionLogId = Guid.NewGuid().ToString();
|
|
// #region 插入设备执行日志
|
// //string msg = $"实验：【{model.Name}】已{EnumManagement.GetFieldText(expOperationTypeEnum)}";
|
// //LogUtil.ClientLog(msg + "_插入设备执行日志");
|
// //new ExecutionLogBLL().AddExecutionLog(new ExecutionLogModel
|
// //{
|
// // Id = executionLogId,
|
// // ExperimentId = model.Id,
|
// // Progress = 100,
|
// // ExperimentStep = "中控软件",
|
// // EquipmentAction = msg,
|
// // StartTime = DateTime.Now,
|
// // Equipment = "中控软件",
|
// // Remark = msg,
|
// // CreateTime = DateTime.Now
|
// //});
|
// #endregion
|
|
// #region 更新结束时间
|
// //var experimentModel = new ExperimentBLL().GetExperimentById(model.Id);
|
// //experimentModel.Status = EnumManagement.GetEnumValue(statusEnum);
|
// //if (expOperationTypeEnum == ExpOperationTypeEnum.ExpOperationTypeCEnum)
|
// //{
|
// // experimentModel.ExpEndTime = DateTime.Now;
|
// //}
|
// //var expTime = new ExperimentBLL().Update(experimentModel);
|
// //if (expTime != null)
|
// //{
|
// // new ExecutionLogBLL().UpdateExecutionLogEndTime(executionLogId); //修改结束时间
|
// //}
|
// #endregion
|
//}
|
}
|
#endregion
|
|
#region 修改错误状态
|
/// <summary>
|
/// 修改错误状态
|
/// </summary>
|
private static void UpdateErrorState()
|
{
|
#region 修改错误信息为已处理
|
var getInfoList = GetInfoListTopNum(1);
|
if (getInfoList != null && getInfoList.Count > 0)
|
{
|
var errorStateModel = GetInfoListTopNum(1).FirstOrDefault();
|
errorStateModel.OperationState = EnumManagement.GetEnumValue(OperationStateEnum.OperationStateBEnum);
|
Update(errorStateModel); //修改状态
|
}
|
#endregion
|
}
|
|
/// <summary>
|
/// 更新错误状态
|
/// </summary>
|
/// <param name="model"></param>
|
/// <returns></returns>
|
public static int Update(ErrorStateModel model)
|
{
|
using (var db = GetInstance())
|
{
|
return db.Updateable<ErrorStateModel>(model).ExecuteCommand();
|
}
|
}
|
|
/// <summary>
|
/// 获取前几条数据
|
/// </summary>
|
/// <param name="topNum"></param>
|
/// <returns></returns>
|
public static List<ErrorStateModel> GetInfoListTopNum(int topNum)
|
{
|
var operationStateEnum = EnumManagement.GetEnumValue(OperationStateEnum.OperationStateAEnum);
|
var parameter = LinqExtensions.True<ErrorStateModel>();
|
parameter = parameter.And(t => t.OperationState == operationStateEnum);
|
|
var result = GetList<ErrorStateModel>(topNum, parameter, b => b.CreateTime, OrderByType.Asc);
|
if (result != null && result.Count > 0)
|
{
|
return result.ToList();
|
}
|
return null;
|
}
|
|
#endregion
|
}
|
}
|
