/// <summary>
/// 同步实时信号到集中管控
/// </summary>
/// <param name="output"></param>
/// <returns></returns>
//public int SyncSignal(Action<string, eOutputType> output)
//{
// int res = 0;
// //同步制样机状态
// foreach (ZY_Status_Tb entity in this.EquDber.Entities<ZY_Status_Tb>("where MachineCode=@MachineCode", new { MachineCode = DataToKYMachine(this.MachineCode) }))
// {
// eEquInfAutoMakerSystemStatus systemStatus = eEquInfAutoMakerSystemStatus.发生故障;
// Enum.TryParse<eEquInfAutoMakerSystemStatus>(entity.SamReady.ToString(), out systemStatus);
// res += commonDAO.SetSignalDataValue(this.MachineCode, eSignalDataName.设备状态.ToString(), systemStatus.ToString()) ? 1 : 0;
// }
// //制样设备状态
// foreach (ZY_State_Tb entity in this.EquDber.Entities<ZY_State_Tb>())
// {
// res += commonDAO.SetSignalDataValue(this.MachineCode, entity.DeviceName, entity.DeviceStatus.ToString()) ? 1 : 0;
// entity.DataStatus = 1;//我方已读
// this.EquDber.Update(entity);
// }
// output(string.Format("同步实时信号 {0} 条", res), eOutputType.Normal);
// return res;
//}
/// <summary>
/// 同步合样归批机 故障信息到集中管控
/// </summary>
/// <param name="output"></param>
/// <returns></returns>
public void SyncError(Action <string, eOutputType> output)
{
int res = 0;
foreach (var entity in this.EquDber.Entities <CY_HYGP_AL_Tb>("where DATEDIFF(dd, Date_Time, GETDATE())=0"))
{
InfEquInfHitch infEquInfHitch = Dbers.GetInstance().SelfDber.Entity <InfEquInfHitch>(" where MachineCode=:MachineCode and HitchTime=:HitchTime and HitchDescribe=:HitchDescribe", new { MachineCode = this.MachineCode, HitchTime = entity.Date_Time, HitchDescribe = entity.Error_Record });
if (infEquInfHitch == null)
{
if (CommonDAO.GetInstance().SaveEquInfHitch(this.MachineCode, entity.Date_Time, entity.Error_Record))
{
//entity.ReadStatus = 1;
//this.EquDber.Update(entity);
res++;
}
}
}
output(string.Format("同步故障信息记录 {0} 条", res), eOutputType.Normal);
}
/// <summary>
/// 同步故障信息到集中管控
/// </summary>
/// <param name="output"></param>
/// <returns></returns>
public void SyncError(Action <string, eOutputType> output)
{
int res = 0;
foreach (KY_CYJ_P_Alarm entity in DcDbers.GetInstance().BeltSampler_Dber.Entities <KY_CYJ_P_Alarm>("where DateDiff(dd,AlarmDateTime,getdate())<=7"))
{
InfEquInfHitch infEquInfHitch = Dbers.GetInstance().SelfDber.Entity <InfEquInfHitch>("where HitchTime=:HitchTime and HitchDescribe=:HitchDescribe", new { HitchTime = entity.AlarmDateTime, HitchDescribe = entity.VarComment });
if (infEquInfHitch == null)
{
if (commonDAO.SaveEquInfHitch(entity.VarName.Contains("A侧") ? GlobalVars.MachineCode_PDCYJ_1 : GlobalVars.MachineCode_PDCYJ_2, entity.AlarmDateTime, entity.VarComment))
{
//entity.DataFlag = 1;
//this.EquDber.Update(entity);
res++;
}
}
}
output(string.Format("同步故障信息记录 {0} 条", res), eOutputType.Normal);
}
