/// <summary>
/// 添加日志
/// </summary>
public static void AddLog(string logType, string LogName, string LogMessMode)
{
var message = LogMessMode;
_LogService.AddLog(new LogMessageRecord()
{
LogType = logType,
LogName = LogName,
LogMessage = message,
LogTime = DateTime.Now,
LogRemark = "同步数据失败"
});
}
/// <summary>
/// 添加日志
/// </summary>
public static void AddLog(string logType, string LogName, MesRequestParamModel LogMessMode)
{
var message = string.Format("MES无数据-参数信息：SqlServer_{0},Database_{1},UserID_{2},StartDate_{3},EndDate_{4},CustomerIDString_{5}", LogMessMode.SqlServer, LogMessMode.Database, LogMessMode.UserID_ID, LogMessMode.StartDate, LogMessMode.EndDate, LogMessMode.CustomerIDString);
_LogService.AddLog(new LogMessageRecord()
{
LogType = logType,
LogName = LogName,
LogMessage = message,
LogTime = DateTime.Now,
LogRemark = "同步数据失败"
});
}
//添加数据
public bool AddMES_PIS(int uid, List <MES_StationDataRecordDTO> mesDataList, CurentTimeModel CurrentDate, MesRequestParamModel mesRequest)
{
//是否发邮件
var isSendEMail = false;
var isAddFailRecord = false;
try
{
var pisConfigList = _process_Service.GetSyscProcessConfig();
var resultModelList = new List <MES_StationDataRecordDTO>();
var convertModel = mesDataList.GroupBy(p => p.MES_ProcessName).ToDictionary(p => p.Key, m => m);
//筛选领料--待商议
var AllPickIngModel = convertModel.Where(p => pisConfigList.Select(m => m.MES_PickingID).Contains(p.Key));
var AllNgModel = convertModel.Where(p => pisConfigList.Select(m => m.MES_NgID).Contains(p.Key));
var AllReworkModel = convertModel.Where(p => pisConfigList.Select(m => m.MES_ReworkID).Contains(p.Key));
foreach (var item in AllNgModel)
{
isAddFailRecord = true;
MES_StationDataRecord AddPisModel = new MES_StationDataRecord();
AddPisModel.Date = CurrentDate.CurrentDay;
AddPisModel.TimeInterVal = CurrentDate.CurrentInterval;
AddPisModel.StartTimeInterval = CurrentDate.CurrentStartMinute;
AddPisModel.EndTimeInterval = CurrentDate.CurrentEndMinute;
AddPisModel.PIS_ProcessID = pisConfigList.Where(p => p.MES_NgID == item.Key).FirstOrDefault().PIS_ProcessID;
AddPisModel.PIS_ProcessName = pisConfigList.Where(p => p.MES_NgID == item.Key).FirstOrDefault().PIS_ProcessName;
AddPisModel.MES_ProcessID = item.Value.FirstOrDefault().MES_ProcessID;
AddPisModel.MES_ProcessName = item.Key;
AddPisModel.ProductQuantity = item.Value.Count();
AddPisModel.ProjectName = mesRequest.CustomerIDString;
AddPisModel.ProcessType = "PIS-NG";
//resultModelList.Add(AddPisModel);
var result = _mes_Service.AddMesData(AddPisModel);
if (!result)
{
isSendEMail = true;
//AddMESSyncFailedLog("Failed", "AddPIS", mesRequest);
}
}
foreach (var item in AllReworkModel)
{
isAddFailRecord = true;
MES_StationDataRecord AddPisModel = new MES_StationDataRecord();
AddPisModel.Date = CurrentDate.CurrentDay;
AddPisModel.TimeInterVal = CurrentDate.CurrentInterval;
AddPisModel.StartTimeInterval = CurrentDate.CurrentStartMinute;
AddPisModel.EndTimeInterval = CurrentDate.CurrentEndMinute;
AddPisModel.PIS_ProcessID = pisConfigList.Where(p => p.MES_ReworkID == item.Key).FirstOrDefault().PIS_ProcessID;
AddPisModel.PIS_ProcessName = pisConfigList.Where(p => p.MES_ReworkID == item.Key).FirstOrDefault().PIS_ProcessName;
AddPisModel.MES_ProcessID = item.Value.FirstOrDefault().MES_ProcessID;
AddPisModel.MES_ProcessName = item.Key;
AddPisModel.ProductQuantity = item.Value.Count();
AddPisModel.ProjectName = mesRequest.CustomerIDString;
AddPisModel.ProcessType = "PIS-ReWork";
var result = _mes_Service.AddMesData(AddPisModel);
if (!result)
{
isSendEMail = true;
//AddLog("Failed", "AddPIS", mesRequest);
//AddMESSyncFailedLog("Failed", "AddPIS", mesRequest);
}
}
foreach (var item in AllPickIngModel)
{
isAddFailRecord = true;
MES_StationDataRecord AddPisModel = new MES_StationDataRecord();
AddPisModel.Date = CurrentDate.CurrentDay;
AddPisModel.TimeInterVal = CurrentDate.CurrentInterval;
AddPisModel.StartTimeInterval = CurrentDate.CurrentStartMinute;
AddPisModel.EndTimeInterval = CurrentDate.CurrentEndMinute;
AddPisModel.PIS_ProcessID = pisConfigList.Where(p => p.MES_PickingID == item.Key).FirstOrDefault().PIS_ProcessID;
AddPisModel.PIS_ProcessName = pisConfigList.Where(p => p.MES_PickingID == item.Key).FirstOrDefault().PIS_ProcessName;
AddPisModel.MES_ProcessID = item.Value.FirstOrDefault().MES_ProcessID;
AddPisModel.MES_ProcessName = item.Key;
AddPisModel.ProductQuantity = item.Value.Count();
AddPisModel.ProjectName = mesRequest.CustomerIDString;
AddPisModel.ProcessType = "PIS-PICK";
//resultModelList.Add(AddPisModel);
var result = _mes_Service.AddMesData(AddPisModel);
if (!result)
{
isSendEMail = true;
//AddLog("Failed", "AddPIS", mesRequest);
//AddMESSyncFailedLog("Failed", "AddPIS", mesRequest);
}
}
//手动同步失败更新状态和失败次数
if (isAddFailRecord)
{
if (isSendEMail)
{
UpdateSyncFailedLog("MES_PIS", "MES数据手动同步", false, uid, mesRequest);
}
else
{
UpdateSyncFailedLog("MES_PIS", "MES数据手动同步", true, uid, mesRequest);
}
}
//有数据同步成功
if (isAddFailRecord && !isSendEMail)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
_LogService.AddLog(new LogMessageRecord()
{
LogType = "手动同步-异常",
LogName = "手动同步异常",
LogMessage = ex.Message.ToString(),
LogTime = DateTime.Now,
LogRemark = "添加_MES_StationDataRecord"
});
return(false);
}
}