private void CreateMainTask() { taskSimpleScheduler = new TaskSimpleScheduler(); autoResetEvent.Reset(); taskSimpleScheduler.StartNewTask("模拟业务", () => { if (!this.IsStartSimulator) { return; } // 心跳 this.EquDber.Execute("update " + EntityReflectionUtil.GetTableName <EquQCJXCYJSignal>() + " set TagValue=@TagValue where TagName=@TagName", new { TagName = GlobalVars.EquHeartbeatName, TagValue = DateTime.Now.ToString() }); // 控制命令 EquQCJXCYJSampleCmd qCJXCYJSampleCmd = this.EquDber.Entity <EquQCJXCYJSampleCmd>("where DataFlag=0 order by CreateDate desc"); if (qCJXCYJSampleCmd != null) { CmdHandle(qCJXCYJSampleCmd); autoResetEvent.WaitOne(); } // 卸样命令 EquQCJXCYJUnloadCmd qCJXCYJUnloadCmd = this.EquDber.Entity <EquQCJXCYJUnloadCmd>("where DataFlag=0 order by CreateDate desc"); if (qCJXCYJUnloadCmd != null) { CmdHandle(qCJXCYJUnloadCmd); autoResetEvent.WaitOne(); } }, 3000); }
private void CmdHandle(EquQCJXCYJUnloadCmd input) { Task task = new Task((state) => { EquQCJXCYJUnloadCmd qCJXCYJUnloadCmd = state as EquQCJXCYJUnloadCmd; OutputRunInfo(rtxtOutput, "处理卸样命令,采样码:" + qCJXCYJUnloadCmd.SampleCode); // 更新系统状态为正在卸样 this.EquDber.Execute("update " + EntityReflectionUtil.GetTableName <EquQCJXCYJSignal>() + " set TagValue=@TagValue where TagName=@TagName", new { TagName = eSignalDataName.设备状态.ToString(), TagValue = eEquInfSamplerSystemStatus.正在卸样.ToString() }); Thread.Sleep(3000); foreach (EquQCJXCYJBarrel pDCYJBarrel in this.EquDber.Entities <EquQCJXCYJBarrel>("where SampleCode=@SampleCode", new { SampleCode = qCJXCYJUnloadCmd.SampleCode })) { // 生成卸样结果 this.EquDber.Insert(new EquQCJXCYJUnloadResult { DataFlag = 0, SampleCode = qCJXCYJUnloadCmd.SampleCode, UnloadTime = DateTime.Now, BarrelNumber = pDCYJBarrel.BarrelNumber, BarrelCode = Guid.NewGuid().ToString().Substring(0, 8).ToUpper(), SamplingId = qCJXCYJUnloadCmd.SamplingId, }); pDCYJBarrel.SampleCount = 0; pDCYJBarrel.InFactoryBatchId = string.Empty; pDCYJBarrel.SampleCode = string.Empty; pDCYJBarrel.BarrelStatus = eSampleBarrelStatus.空桶.ToString(); pDCYJBarrel.UpdateTime = DateTime.Now; pDCYJBarrel.DataFlag = 0; if (this.EquDber.Update(pDCYJBarrel) > 0) { OutputRunInfo(rtxtOutput, "卸样完成,罐号:" + pDCYJBarrel.BarrelNumber.ToString() + " " + pDCYJBarrel.BarrelType.ToString()); } Thread.Sleep(2000); } // 更新命令 qCJXCYJUnloadCmd.ResultCode = eEquInfCmdResultCode.成功.ToString(); qCJXCYJUnloadCmd.DataFlag = 2; this.EquDber.Update(qCJXCYJUnloadCmd); OutputRunInfo(rtxtOutput, "卸样完成"); autoResetEvent.Set(); }, input); task.Start(); }
/// <summary> /// 同步卸样命令 /// </summary> /// <param name="output"></param> /// <returns></returns> public void SyncJXCYControlUnloadCMD(Action <string, eOutputType> output) { int res = 0; // 集中管控 > 第三方 foreach (InfQCJXCYUnLoadCMD entity in CarSamplerDAO.GetInstance().GetWaitForSyncJXCYSampleUnloadCmd(MachineCode)) { bool isSuccess = false; EquQCJXCYJUnloadCmd pJXCYCMD = this.EquDber.Get <EquQCJXCYJUnloadCmd>(entity.Id); if (pJXCYCMD == null) { isSuccess = this.EquDber.Insert(new EquQCJXCYJUnloadCmd { // 保持相同的Id Id = entity.Id, DataFlag = 0, CreateDate = entity.CreateDate, SampleCode = entity.SampleCode, ResultCode = eEquInfCmdResultCode.默认.ToString(), UnLoadType = entity.UnLoadType.ToString(), SamplingId = entity.SamplingId }) > 0; } else { isSuccess = true; } if (isSuccess) { entity.SyncFlag = 1; Dbers.GetInstance().SelfDber.Update(entity); res++; } } output(string.Format("同步卸样命令 {0} 条(集中管控 > 第三方)", res), eOutputType.Normal); res = 0; // 第三方 > 集中管控 foreach (EquQCJXCYJUnloadCmd entity in this.EquDber.Entities <EquQCJXCYJUnloadCmd>("where DataFlag=2 and datediff(dd,CreateDate,getdate())=0")) { InfQCJXCYUnLoadCMD JXCYCmd = Dbers.GetInstance().SelfDber.Get <InfQCJXCYUnLoadCMD>(entity.Id); if (JXCYCmd == null) { continue; } // 更新执行结果等 JXCYCmd.ResultCode = entity.ResultCode; if (Dbers.GetInstance().SelfDber.Update(JXCYCmd) > 0) { // 我方已读 entity.DataFlag = 3; this.EquDber.Update(entity); res++; } } output(string.Format("同步卸样命令 {0} 条(第三方 > 集中管控)", res), eOutputType.Normal); }