/// <summary>
/// 同步制样 出样明细信息到集中管控
/// </summary>
/// <param name="output"></param>
/// <returns></returns>
public void SyncMakeDetail(Action <string, eOutputType> output)
{
int res = 0;
foreach (EquQZDZYJDetail entity in this.EquDber.Entities <EquQZDZYJDetail>("where DataFlag=0 order by CreationTime asc"))
{
if (SyncToRCMakeDetail(entity))
{
if (AutoMakerDAO.GetInstance().SaveMakerRecord(new InfMakerRecord
{
InterfaceType = CommonDAO.GetInstance().GetMachineInterfaceTypeByCode(this.MachineCode),
MachineCode = this.MachineCode,
MakeCode = entity.MakeCode,
BarrelCode = entity.BarrelCode,
YPType = entity.YPType,
YPWeight = entity.YPWeight,
StartTime = entity.StartTime,
EndTime = entity.EndTime,
MakeUser = entity.MakeUser,
DataFlag = 1
}))
{
entity.DataFlag = 1;
this.EquDber.Update(entity);
res++;
// 需调整：启动传输调度计划需根据现场情况而定
// 插入气动传输调度计划
//EquAutoCupboardDAO.GetInstance().AddNewSendSampleId(entity.BarrelCode, entity.YPType, eCmdCode.制样机1, eCmdCode.存样柜);
}
}
}
output(string.Format("同步出样明细记录 {0} 条", res), eOutputType.Normal);
}
/// <summary>
/// 同步制样 出样明细信息到集中管控
/// </summary>
/// <param name="output"></param>
/// <returns></returns>
public void SyncMakeDetail(Action <string, eOutputType> output)
{
int res = 0;
foreach (ZY_Record_Tb entity in this.EquDber.Entities <ZY_Record_Tb>("where DataStatus=0 and PackCode!=0 order by StartTime desc"))
{
if (SyncToRCMakeDetail(entity))
{
InfMakerRecord makeRecord = new InfMakerRecord
{
InterfaceType = CommonDAO.GetInstance().GetMachineInterfaceTypeByCode(this.MachineCode),
MachineCode = this.MachineCode,
MakeCode = entity.SampleID,
BarrelCode = entity.PackCode,
YPType = entity.SampleType, //AutoMakerDAO.GetInstance().GetKYMakeType(entity.SampleType.ToString()),
YPWeight = entity.SamepleWeight,
StartTime = entity.StartTime,
EndTime = entity.EndTime,
MakeUser = entity.UserName,
DataFlag = 1
};
if (AutoMakerDAO.GetInstance().SaveMakerRecord(makeRecord))
{
entity.DataStatus = 1;
this.EquDber.Update(entity);
res++;
}
}
}
output(string.Format("同步出样明细记录 {0} 条", res), eOutputType.Normal);
}
/// <summary>
/// 请求数据
/// </summary>
void RequestData()
{
try
{
CommonDAO commonDAO = CommonDAO.GetInstance();
AutoMakerDAO automakerDAO = AutoMakerDAO.GetInstance();
string value = string.Empty, machineCode = string.Empty;
List <HtmlDataItem> datas = new List <HtmlDataItem>();
List <InfEquInfHitch> equInfHitchs = new List <InfEquInfHitch>();
datas.Clear();
Device = string.IsNullOrEmpty(Device) ? "#1全自动制样机" : Device;
datas.Add(new HtmlDataItem("全自动制样机", Device, eHtmlDataItemType.svg_text));
Creatadatas(commonDAO, GlobalVars.MachineCode_QZDZYJ_1, datas);
// 发送到页面
if (datas != null)
{
cefWebBrowser.Browser.GetMainFrame().ExecuteJavaScript("requestData(" + Newtonsoft.Json.JsonConvert.SerializeObject(datas) + ");", "", 0);
}
}
catch (Exception ex)
{
}
}
public void BindData()
{
this.SqlWhere = " where 1=1";
if (!string.IsNullOrEmpty(txtBarrelCode_Ser.Text))
{
this.SqlWhere += " and BarrelCode like '%" + txtBarrelCode_Ser.Text + "%'";
}
if (!string.IsNullOrEmpty(dtInputStart.Text))
{
this.SqlWhere += " and CreateDate >= '" + dtInputStart.Value + "'";
}
if (!string.IsNullOrEmpty(dtInputEnd.Text))
{
this.SqlWhere += " and CreateDate <= '" + dtInputEnd.Value + "'";
}
List <InfMakerRecord> list = AutoMakerDAO.GetInstance().ExecutePager(PageSize, CurrentIndex, SqlWhere);
superGridControl1.PrimaryGrid.DataSource = list;
GetTotalCount(SqlWhere);
PagerControlStatue();
lblPagerInfo.Text = string.Format("共 {0} 条记录，每页 {1} 条，共 {2} 页，当前第 {3} 页", TotalCount, PageSize, PageCount, CurrentIndex + 1);
}
/// <summary>
/// 同步制样命令
/// </summary>
/// <param name="output"></param>
/// <returns></returns>
public void SyncCmd(Action <string, eOutputType> output)
{
int res = 0;
// 集中管控 > 第三方
foreach (InfMakerControlCmd entity in AutoMakerDAO.GetInstance().GetWaitForSyncMakerControlCmd(this.MachineCode))
{
bool isSuccess = false;
eEquInfMakerCmd cmd = eEquInfMakerCmd.开始制样;
Enum.TryParse <eEquInfMakerCmd>(entity.CmdCode, out cmd);
ZY_Cmd_Tb cmdtb = this.EquDber.Entity <ZY_Cmd_Tb>("where MachineCode=@MachineCode", new { MachineCode = DataToKYMachine(this.MachineCode) });
if (cmdtb == null)
{
isSuccess = this.EquDber.Insert(new ZY_Cmd_Tb
{
MachineCode = DataToKYMachine(this.MachineCode),
CommandCode = (int)cmd,
SampleCode = entity.MakeCode,
SendCommandTime = DateTime.Now,
DataStatus = 0
}) > 0;
}
else
{
cmdtb.CommandCode = (int)cmd;
cmdtb.SampleCode = entity.MakeCode;
cmdtb.SendCommandTime = DateTime.Now;
cmdtb.DataStatus = 0;
isSuccess = this.EquDber.Update(cmdtb) > 0;
}
ZY_Interface_Tb interfacetb = this.EquDber.Entity <ZY_Interface_Tb>();
if (interfacetb == null)
{
interfacetb = new ZY_Interface_Tb();
interfacetb.SampleID = entity.MakeCode;
interfacetb.Type = 1;
interfacetb.Size = 1;
interfacetb.Water = 1;
interfacetb.SendCommandTime = DateTime.Now;
interfacetb.DataStatus = 0;
isSuccess = this.EquDber.Insert(interfacetb) > 0;
}
else
{
isSuccess = this.EquDber.Execute(string.Format("update {0} set SampleID ='{1}',Type = 4,Size = 1,Water = 4,SendCommandTime=getdate(),DataStatus = 0 ", CMCS.DapperDber.Util.EntityReflectionUtil.GetTableName <ZY_Interface_Tb>(), entity.MakeCode)) > 0;
}
if (isSuccess)
{
entity.SyncFlag = 1;
commonDAO.SelfDber.Update(entity);
res++;
}
}
output(string.Format("同步控制命令 {0} 条（集中管控 > 第三方）", res), eOutputType.Normal);
}
/// <summary>
/// 从卸样记录中获取最新的采样编码,判断是否能卸样
/// </summary>
/// <param name="cmcsCMEquipment"></param>
/// <returns></returns>
private bool HandleWhetherSampleUnloadCmd(CmcsCMEquipment cmcsCMEquipment)
{
string tempSamplingId = string.Empty;
if (Dbers.GetInstance().SelfDber.Get <CmcsCMEquipment>(cmcsCMEquipment.Parentid).EquipmentCode == "皮带采样机")
{
InfBeltSampleUnloadCmd entity = commonDAO.SelfDber.Entity <InfBeltSampleUnloadCmd>(" where MachineCode='" + cmcsCMEquipment.EquipmentCode + "' order by createdate desc");
if (entity != null)
{
tempSamplingId = entity.SamplingId;
}
}
else if (Dbers.GetInstance().SelfDber.Get <CmcsCMEquipment>(cmcsCMEquipment.Parentid).EquipmentCode == "汽车机械采样机")
{
InfQCJXCYUnLoadCMD entity = commonDAO.SelfDber.Entity <InfQCJXCYUnLoadCMD>(" where MachineCode='" + cmcsCMEquipment.EquipmentCode + "' order by createdate desc");
if (entity != null)
{
tempSamplingId = entity.SamplingId;
}
}
else
{
rTxtOutputer.Output("无此编码类型，请查证\"皮带采样机\"和\"汽车机械采样机\"类型！", eOutputType.Error);
return(false);
}
if (!string.IsNullOrEmpty(tempSamplingId))
{
//同一批次可以继续卸样
if (this.CurrentRCSampling.Id == tempSamplingId)
{
return(true);
}
CmcsRCMake rcMake = AutoMakerDAO.GetInstance().GetRCMakeBySampleId(tempSamplingId);
if (rcMake != null)
{
//未找到制样记录需要提示是否继续操作
InfMakerPlan infMakerPlan = Dbers.GetInstance().SelfDber.Entity <InfMakerPlan>("where MakeCode=:MakeCode", new { MakeCode = rcMake.MakeCode });
if (infMakerPlan == null)
{
if (MessageBoxEx.Show("该卸样记录与上一次未制样的记录不是同一批次，为防止混样，确定是否继续", "操作提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Exclamation) == System.Windows.Forms.DialogResult.OK)
{
if (new FrmConfirmOperationLog("确定人为操作继续卸样").ShowDialog() == DialogResult.OK)
{
return(true);
}
}
}
}
}
return(false);
}
private void GetTotalCount(string sqlWhere)
{
TotalCount = AutoMakerDAO.GetInstance().GetTotalCount(sqlWhere);
if (TotalCount % PageSize != 0)
{
PageCount = TotalCount / PageSize + 1;
}
else
{
PageCount = TotalCount / PageSize;
}
}
/// <summary>
/// 发送制样计划和制样命令给制样机
/// </summary>
private void SendMakePlanAndStart()
{
if (this.brotherRCSampleBarrels.Count == 0)
{
ShowMessage("请先完成采样桶校验", eOutputType.Error);
return;
}
if (this.RCMake == null)
{
ShowMessage("未找到制样单记录", eOutputType.Error);
return;
}
if (this.AutoMaker == null)
{
ShowMessage("未找到制样机设备", eOutputType.Error);
return;
}
if (commonDAO.GetSignalDataValue(this.AutoMaker.EquipmentCode, eSignalDataName.系统.ToString()) != eEquInfSamplerSystemStatus.就绪待机.ToString())
{
MessageBoxEx.Show("制样机未就绪，禁止发送制样命令!", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (MessageBoxEx.Show("准备启动制样机，请确定煤样已全部倒入制样机料斗!", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Asterisk) == DialogResult.OK)
{
// 需调整：根据接口规定写入煤种、水分等参数
InfMakerPlan makerPlan = new InfMakerPlan()
{
InterfaceType = commonDAO.GetMachineInterfaceTypeByCode(this.AutoMaker.EquipmentCode),
MachineCode = this.AutoMaker.EquipmentCode,
InFactoryBatchId = this.brotherRCSampleBarrels[0].InFactoryBatchId,
MakeCode = this.RCMake.MakeCode,
FuelKindName = "褐煤",
Mt = "湿煤",
MakeType = "在线制样",
CoalSize = "小粒度"
};
if (AutoMakerDAO.GetInstance().SaveMakerPlanAndStartCmd(makerPlan, out resMessage))
{
this.CurrentFlowFlag = eFlowFlag.等待制样结果;
ShowMessage(resMessage, eOutputType.Normal);
}
else
{
ShowMessage(resMessage, eOutputType.Error);
}
}
}
/// <summary>
/// 同步制样计划
/// </summary>
/// <param name="output"></param>
/// <returns></returns>
public void SyncPlan(Action <string, eOutputType> output)
{
int res = 0;
// 集中管控 > 第三方
foreach (InfMakerPlan entity in AutoMakerDAO.GetInstance().GetWaitForSyncMakePlan(this.MachineCode))
{
bool isSuccess = false;
// 需调整：计划中的煤种、水分、颗粒度等信息视接口而定
EquQZDZYJPlan qZDZYJPlan = this.EquDber.Get <EquQZDZYJPlan>(entity.Id);
if (qZDZYJPlan == null)
{
isSuccess = this.EquDber.Insert(new EquQZDZYJPlan
{
// 保持相同的Id
Id = entity.Id,
InFactoryBatchId = entity.InFactoryBatchId,
MakeCode = entity.MakeCode,
FuelKindName = entity.FuelKindName,
//Mt = 0,
//CoalSize = 2,
DataFlag = 0
}) > 0;
}
else
{
qZDZYJPlan.Id = entity.Id;
qZDZYJPlan.MakeCode = entity.MakeCode;
qZDZYJPlan.FuelKindName = entity.FuelKindName;
//qZDZYJPlan.Mt = 0;
//qZDZYJPlan.CoalSize = 0;
qZDZYJPlan.DataFlag = 0;
isSuccess = this.EquDber.Update(qZDZYJPlan) > 0;
}
if (isSuccess)
{
entity.SyncFlag = 1;
commonDAO.SelfDber.Update(entity);
res++;
}
}
output(string.Format("同步制样计划 {0} 条（集中管控 > 第三方）", res), eOutputType.Normal);
}
/// <summary>
/// 发送制样计划
/// </summary>
/// <param name="rCSamplingId">采样单Id</param>
/// <param name="infactoryBatchId">批次Id</param>
/// <returns></returns>
private bool SendMakePlan(string rCSamplingId)
{
CmcsRCSampling rCSampling = commonDAO.SelfDber.Get <CmcsRCSampling>(rCSamplingId);
CmcsRCMake rcMake = AutoMakerDAO.GetInstance().GetRCMakeBySampleId(rCSamplingId);
if (rcMake != null)
{
string fuelKindName = string.Empty;
CmcsInFactoryBatch inFactoryBatch = commonDAO.GetBatchByRCSamplingId(rCSamplingId);
if (inFactoryBatch != null)
{
CmcsFuelKind fuelKind = commonDAO.SelfDber.Get <CmcsFuelKind>(inFactoryBatch.FuelKindId);
if (fuelKind != null)
{
fuelKindName = fuelKind.FuelName;
}
}
// 需调整：发送的制样计划中煤种、颗粒度、水分等相关信息视接口而定
InfMakerPlan makerPlan = new InfMakerPlan()
{
InterfaceType = commonDAO.GetMachineInterfaceTypeByCode(this.CurrentmakerMachineCode),
MachineCode = this.CurrentmakerMachineCode,
InFactoryBatchId = rCSampling != null ? rCSampling.InFactoryBatchId : "",
MakeCode = rcMake.MakeCode,
FuelKindName = fuelKindName,
//Mt = "湿煤",
MakeType = "在线制样",
//CoalSize = "小粒度",
SyncFlag = 0
};
AutoMakerDAO.GetInstance().SaveMakerPlanAndStartCmd(makerPlan, out currentMessage);
rTxtOutputer.Output(currentMessage, eOutputType.Normal);
return(true);
}
else
{
rTxtOutputer.Output("制样计划发送失败：未找到制样主记录信息", eOutputType.Error);
}
return(false);
}
private void SendMakePlanAndStart()
{
if (this.brotherRCSampleBarrels.Count == 0)
{
this.ShowMessage("请先完成采样桶校验", FrmMakeTake.eOutputType.Error);
return;
}
if (this.RCMake == null)
{
this.ShowMessage("未找到制样单记录", FrmMakeTake.eOutputType.Error);
return;
}
if (this.commonDAO.GetSignalDataValue(this.AutoMaker.EquipmentCode, eSignalDataName.设备状态.ToString()) != eEquInfSamplerSystemStatus.就绪待机.ToString())
{
MessageBoxEx.Show("制样机未就绪，禁止发送制样命令!", "提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Exclamation);
return;
}
if (MessageBoxEx.Show("准备启动制样机，请确定煤样已全部倒入制样机料斗!", "提示", System.Windows.Forms.MessageBoxButtons.OKCancel, System.Windows.Forms.MessageBoxIcon.Asterisk) == System.Windows.Forms.DialogResult.OK)
{
InfMakerPlan entity = new InfMakerPlan
{
InterfaceType = this.commonDAO.GetMachineInterfaceTypeByCode(this.AutoMaker.EquipmentCode),
MachineCode = this.AutoMaker.EquipmentCode,
InFactoryBatchId = this.brotherRCSampleBarrels[0].InFactoryBatchId,
MakeCode = this.RCMake.MakeCode,
FuelKindName = "褐煤",
Mt = "湿煤",
MakeType = "在线制样",
CoalSize = "小粒度"
};
if (AutoMakerDAO.GetInstance().SaveMakerPlanAndStartCmd(entity, out this.resMessage))
{
this.CurrentFlowFlag = eFlowFlag.等待制样结果;
this.ShowMessage(this.resMessage, FrmMakeTake.eOutputType.Normal);
return;
}
this.ShowMessage(this.resMessage, FrmMakeTake.eOutputType.Error);
}
}
/// <summary>
/// 皮带控制命令表
/// </summary>
/// <param name="output"></param>
/// <returns></returns>
public void SyncCmd(Action <string, eOutputType> output)
{
int res = 0;
// 集中管控 > 第三方
foreach (InfMakerControlCmd entity in AutoMakerDAO.GetInstance().GetWaitForSyncMakerControlCmd(this.MachineCode))
{
bool isSuccess = false;
EquQZDZYJCmd qZDZYJCmd = this.EquDber.Get <EquQZDZYJCmd>(entity.Id);
if (qZDZYJCmd == null)
{
isSuccess = this.EquDber.Insert(new EquQZDZYJCmd
{
// 保持相同的Id
Id = entity.Id,
CmdCode = entity.CmdCode,
MakeCode = entity.MakeCode,
ResultCode = eEquInfCmdResultCode.默认.ToString(),
DataFlag = 0
}) > 0;
}
else
{
isSuccess = true;
}
if (isSuccess)
{
entity.SyncFlag = 1;
commonDAO.SelfDber.Update(entity);
res++;
}
}
output(string.Format("同步控制命令 {0} 条（集中管控 > 第三方）", res), eOutputType.Normal);
res = 0;
// 第三方 > 集中管控
foreach (EquQZDZYJCmd entity in this.EquDber.Entities <EquQZDZYJCmd>("where DataFlag=2"))
{
InfMakerControlCmd makerControlCmd = commonDAO.SelfDber.Get <InfMakerControlCmd>(entity.Id);
if (makerControlCmd == null)
{
continue;
}
// 更新执行结果等
makerControlCmd.ResultCode = entity.ResultCode;
makerControlCmd.DataFlag = 3;
if (commonDAO.SelfDber.Update(makerControlCmd) > 0)
{
// 我方已读
entity.DataFlag = 3;
this.EquDber.Update(entity);
res++;
}
}
output(string.Format("同步控制命令 {0} 条（第三方 > 集中管控）", res), eOutputType.Normal);
}
/// <summary>
/// 请求数据
/// </summary>
void RequestData()
{
CommonDAO commonDAO = CommonDAO.GetInstance();
AutoMakerDAO automakerDAO = AutoMakerDAO.GetInstance();
string value = string.Empty, machineCode = string.Empty;
List <HtmlDataItem> datas = new List <HtmlDataItem>();
//#region 智能存样柜 #
datas.Clear();
machineCode = GlobalVars.MachineCode_CYG1;
datas.Add(new HtmlDataItem("仓位信息", commonDAO.GetSignalDataValue(machineCode, "已存仓位") + "/" + commonDAO.GetSignalDataValue(machineCode, "共有仓位"), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("大瓶用量", commonDAO.GetSignalDataValue(machineCode, "大瓶已存仓位") + "/" + commonDAO.GetSignalDataValue(machineCode, "大瓶仓位"), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("中瓶用量", commonDAO.GetSignalDataValue(machineCode, "中瓶已存仓位") + "/" + commonDAO.GetSignalDataValue(machineCode, "中瓶仓位"), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("小瓶用量", commonDAO.GetSignalDataValue(machineCode, "小瓶已存仓位") + "/" + commonDAO.GetSignalDataValue(machineCode, "小瓶仓位"), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("人工存瓶信号", commonDAO.GetSignalDataValue(machineCode, "人工存瓶信号") == "1"?"已就绪":"未准备好", eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("人工取瓶信号", commonDAO.GetSignalDataValue(machineCode, "人工取瓶信号") == "1" ? "已就绪" : "未准备好", eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("气送存瓶信号", commonDAO.GetSignalDataValue(machineCode, "气送存瓶信号") == "1" ? "已就绪" : "未准备好", eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("气送取瓶信号", commonDAO.GetSignalDataValue(machineCode, "气送取瓶信号") == "1" ? "已就绪" : "未准备好", eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("气送系统信号", commonDAO.GetSignalDataValue(machineCode, "气送系统信号") == "1" ? "已就绪" : "未准备好", eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("设备执行流程", "", eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("行走伺服位置", commonDAO.GetSignalDataValue(machineCode, "行走伺服"), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("升降伺服位置", commonDAO.GetSignalDataValue(machineCode, "升降伺服"), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("滑动模组位置", commonDAO.GetSignalDataValue(machineCode, "滑动模组"), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("旋转伺服位置", commonDAO.GetSignalDataValue(machineCode, "旋转伺服"), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("电爪状态", commonDAO.GetSignalDataValue(machineCode, "电爪状态开到位") == "1"?"打开到位": commonDAO.GetSignalDataValue(machineCode, "电爪状态关到位") == "1" ?"关闭到位":"", eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("气送闸板", commonDAO.GetSignalDataValue(machineCode, "气送阀板开到位") == "1"? "打开到位": commonDAO.GetSignalDataValue(machineCode, "气送阀板关到位") == "1"?"关闭到位":"", eHtmlDataItemType.svg_text));
//datas.Add(new HtmlDataItem("命令编码", commonDAO.GetSignalDataValue(machineCode, "命令编码"), eHtmlDataItemType.svg_text));
//datas.Add(new HtmlDataItem("瓶号", commonDAO.GetSignalDataValue(machineCode, "瓶号"), eHtmlDataItemType.svg_text));
//datas.Add(new HtmlDataItem("左右", commonDAO.GetSignalDataValue(machineCode, "左右"), eHtmlDataItemType.svg_text));
//datas.Add(new HtmlDataItem("列", commonDAO.GetSignalDataValue(machineCode, "列"), eHtmlDataItemType.svg_text));
//datas.Add(new HtmlDataItem("层", commonDAO.GetSignalDataValue(machineCode, "层"), eHtmlDataItemType.svg_text));
//datas.Add(new HtmlDataItem("水平坐标", commonDAO.GetSignalDataValue(machineCode, "水平坐标"), eHtmlDataItemType.svg_text));
//datas.Add(new HtmlDataItem("升降坐标", commonDAO.GetSignalDataValue(machineCode, "升降坐标"), eHtmlDataItemType.svg_text));
//datas.Add(new HtmlDataItem("时间", commonDAO.GetSignalDataValue(machineCode, "时间"), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("入厂6mm全水样超期", commonDAO.GetSignalDataValue(machineCode, "入厂6mm全水样超期"), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("入厂02mm分析样超期", commonDAO.GetSignalDataValue(machineCode, "入厂0.2mm分析样超期"), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("入厂02mm存查样超期", commonDAO.GetSignalDataValue(machineCode, "入厂0.2mm存查样超期"), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("入厂3mm备查样超期", commonDAO.GetSignalDataValue(machineCode, "入厂3mm备查样超期"), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("入炉6mm全水样超期", commonDAO.GetSignalDataValue(machineCode, "入炉6mm全水样超期"), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("入炉02mm分析样超期", commonDAO.GetSignalDataValue(machineCode, "入炉0.2mm分析样超期"), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("入炉02mm存查样超期", commonDAO.GetSignalDataValue(machineCode, "入炉0.2mm存查样超期"), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("入炉3mm备查样超期", commonDAO.GetSignalDataValue(machineCode, "入炉3mm备查样超期"), eHtmlDataItemType.svg_text));
//// 发送到页面
cefWebBrowser.Browser.GetMainFrame().ExecuteJavaScript("requestData(" + Newtonsoft.Json.JsonConvert.SerializeObject(datas) + ");", "", 0);
List <InfCYGSam> lists = Dbers.GetInstance().SelfDber.Entities <InfCYGSam>().ToList();
List <Tempsam> tempsams = new List <Tempsam>();
foreach (var item in lists)
{
Tempsam tempsam = new Tempsam();
tempsam.Name = item.AreaNumber + "-" + item.ColumnIndex + "-" + item.CellIndex;
tempsam.Type = item.SamType;
tempsam.Code = item.Code;
tempsams.Add(tempsam);
}
cefWebBrowser.Browser.GetMainFrame().ExecuteJavaScript("LoadSamInfo(" + Newtonsoft.Json.JsonConvert.SerializeObject(tempsams) + ");", "", 0);
}
/// <summary>
/// 请求数据
/// </summary>
void RequestData()
{
CommonDAO commonDAO = CommonDAO.GetInstance();
AutoMakerDAO automakerDAO = AutoMakerDAO.GetInstance();
string value = string.Empty, machineCode = string.Empty;
List <HtmlDataItem> datas = new List <HtmlDataItem>();
List <InfEquInfHitch> equInfHitchs = new List <InfEquInfHitch>();
#region 智能存样柜 #
datas.Clear();
GetBoxDatas(commonDAO, GlobalVars.MachineCode_CYG1, datas);
GetBoxDatas(commonDAO, GlobalVars.MachineCode_CYG2, datas);
machineCode = GlobalVars.MachineCode_QD;
//datas.Add(new HtmlDataItem("Keys", commonDAO.GetSignalDataValue(machineCode, "风机") == "1" ? "气动传输_风机" : "", eHtmlDataItemType.svg_scroll3));
value = commonDAO.GetSignalDataValue(machineCode, eSignalDataName.序状态.ToString());
if ("|就绪待机|".Contains("|" + value + "|"))
{
datas.Add(new HtmlDataItem("气动传输_系统", "#00c000", eHtmlDataItemType.svg_color));
}
else if ("|正在运行|正在卸样|".Contains("|" + value + "|"))
{
datas.Add(new HtmlDataItem("气动传输_系统", "#ff0000", eHtmlDataItemType.svg_color));
}
else if ("|发生故障|".Contains("|" + value + "|"))
{
datas.Add(new HtmlDataItem("气动传输_系统", "#ffff00", eHtmlDataItemType.svg_color));
}
else
{
datas.Add(new HtmlDataItem("气动传输_系统", "#c0c0c0", eHtmlDataItemType.svg_color));
}
//信号状态
string keys = "";
if (commonDAO.GetSignalDataValue(machineCode, "风机运转") == "1")
{
keys += "风机正转";
}
datas.Add(new HtmlDataItem(machineCode + "Keys", keys, eHtmlDataItemType.svg_scroll));
datas.Add(new HtmlDataItem("1#换向器_位置1", commonDAO.GetSignalDataValue(machineCode, "1#换向器_位置1") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("1#换向器_位置2", commonDAO.GetSignalDataValue(machineCode, "1#换向器_位置2") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("1#换向器_位置3", commonDAO.GetSignalDataValue(machineCode, "1#换向器_位置3") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("1#换向器_位置4", commonDAO.GetSignalDataValue(machineCode, "1#换向器_位置4") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("3#换向器_位置1", commonDAO.GetSignalDataValue(machineCode, "3#换向器_位置1") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("3#换向器_位置2", commonDAO.GetSignalDataValue(machineCode, "3#换向器_位置2") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("3#换向器_位置3", commonDAO.GetSignalDataValue(machineCode, "3#换向器_位置3") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("3#换向器_位置4", commonDAO.GetSignalDataValue(machineCode, "3#换向器_位置4") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("6#换向器_位置1", commonDAO.GetSignalDataValue(machineCode, "6#换向器_位置1") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("6#换向器_位置2", commonDAO.GetSignalDataValue(machineCode, "6#换向器_位置2") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜1换向器_位置1", commonDAO.GetSignalDataValue(machineCode, "存样柜1换向器_位置1") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜1换向器_位置2", commonDAO.GetSignalDataValue(machineCode, "存样柜1换向器_位置2") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜1换向器_位置3", commonDAO.GetSignalDataValue(machineCode, "存样柜1换向器_位置3") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜1换向器_位置4", commonDAO.GetSignalDataValue(machineCode, "存样柜1换向器_位置4") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜2换向器_位置1", commonDAO.GetSignalDataValue(machineCode, "存样柜2换向器_位置1") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜2换向器_位置2", commonDAO.GetSignalDataValue(machineCode, "存样柜2换向器_位置2") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜2换向器_位置3", commonDAO.GetSignalDataValue(machineCode, "存样柜2换向器_位置3") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜2换向器_位置4", commonDAO.GetSignalDataValue(machineCode, "存样柜2换向器_位置4") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("1换向器_样瓶检测1", commonDAO.GetSignalDataValue(machineCode, "1#换向器_样瓶检测1") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("1换向器_样瓶检测2", commonDAO.GetSignalDataValue(machineCode, "1#换向器_样瓶检测2") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("1换向器_样瓶检测3", commonDAO.GetSignalDataValue(machineCode, "1#换向器_样瓶检测3") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("1换向器_样瓶检测4", commonDAO.GetSignalDataValue(machineCode, "1#换向器_样瓶检测4") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("3换向器_样瓶检测1", commonDAO.GetSignalDataValue(machineCode, "3#换向器_样瓶检测1") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("3换向器_样瓶检测2", commonDAO.GetSignalDataValue(machineCode, "3#换向器_样瓶检测2") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("3换向器_样瓶检测3", commonDAO.GetSignalDataValue(machineCode, "3#换向器_样瓶检测3") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("3换向器_样瓶检测4", commonDAO.GetSignalDataValue(machineCode, "3#换向器_样瓶检测4") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("6换向器_样瓶检测1", commonDAO.GetSignalDataValue(machineCode, "6#换向器_样瓶检测1") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("6换向器_样瓶检测2", commonDAO.GetSignalDataValue(machineCode, "6#换向器_样瓶检测2") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜1换向器_样瓶检测1", commonDAO.GetSignalDataValue(machineCode, "存样柜1换向器_样瓶检测1") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜1换向器_样瓶检测2", commonDAO.GetSignalDataValue(machineCode, "存样柜1换向器_样瓶检测2") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜1换向器_样瓶检测3", commonDAO.GetSignalDataValue(machineCode, "存样柜1换向器_样瓶检测3") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜1换向器_样瓶检测4", commonDAO.GetSignalDataValue(machineCode, "存样柜1换向器_样瓶检测4") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜2换向器_样瓶检测1", commonDAO.GetSignalDataValue(machineCode, "存样柜2换向器_样瓶检测1") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜2换向器_样瓶检测2", commonDAO.GetSignalDataValue(machineCode, "存样柜2换向器_样瓶检测2") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜2换向器_样瓶检测3", commonDAO.GetSignalDataValue(machineCode, "存样柜2换向器_样瓶检测3") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜2换向器_样瓶检测4", commonDAO.GetSignalDataValue(machineCode, "存样柜2换向器_样瓶检测4") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("1发送站1_样瓶检测", commonDAO.GetSignalDataValue(machineCode, "1#发送站1_样瓶检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("1发送站1_管道物料检测", commonDAO.GetSignalDataValue(machineCode, "1#发送站1_管道物料检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("1发送站2_样瓶检测", commonDAO.GetSignalDataValue(machineCode, "1#发送站2_样瓶检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("1发送站2_管道物料检测", commonDAO.GetSignalDataValue(machineCode, "1#发送站2_管道物料检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("3发送站1_样瓶检测", commonDAO.GetSignalDataValue(machineCode, "3#发送站1_样瓶检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("3发送站1_管道物料检测", commonDAO.GetSignalDataValue(machineCode, "3#发送站1_管道物料检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("3发送站2_样瓶检测", commonDAO.GetSignalDataValue(machineCode, "3#发送站2_样瓶检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("3发送站2_管道物料检测", commonDAO.GetSignalDataValue(machineCode, "3#发送站2_管道物料检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("6发送站1_样瓶检测", commonDAO.GetSignalDataValue(machineCode, "6#发送站1_样瓶检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("6发送站1_管道物料检测", commonDAO.GetSignalDataValue(machineCode, "6#发送站1_管道物料检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("6发送站2_样瓶检测", commonDAO.GetSignalDataValue(machineCode, "6#发送站2_样瓶检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("6发送站2_管道物料检测", commonDAO.GetSignalDataValue(machineCode, "6#发送站2_管道物料检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("化验室接收站_样瓶检测", commonDAO.GetSignalDataValue(machineCode, "化验室接收站_样瓶检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("人工收发站_管道物料检测", commonDAO.GetSignalDataValue(machineCode, "制样人工收发站_管道物料检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("人工收发站_样瓶检测", commonDAO.GetSignalDataValue(machineCode, "制样人工收发站_样瓶检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜1收发站_管道物料检测", commonDAO.GetSignalDataValue(machineCode, "存样柜1收发站_管道物料检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜1收发站_样瓶检测", commonDAO.GetSignalDataValue(machineCode, "存样柜1收发站_样瓶检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜2收发站_管道物料检测", commonDAO.GetSignalDataValue(machineCode, "存样柜2收发站_管道物料检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("存样柜2收发站_样瓶检测", commonDAO.GetSignalDataValue(machineCode, "存样柜2收发站_样瓶检测") == "1" ? "#ee4036" : "#ffffff", eHtmlDataItemType.svg_color));
// 发送到页面
cefWebBrowser.Browser.GetMainFrame().ExecuteJavaScript("requestData(" + Newtonsoft.Json.JsonConvert.SerializeObject(datas) + ");", "", 0);
//出样信息
//List<InfCYGControlCMDDetail> listMakerRecord = automakerDAO.GetCYGControlCMDDetailByTime(DateTime.Now);
//cefWebBrowser.Browser.GetMainFrame().ExecuteJavaScript("LoadSampleInfo(" + Newtonsoft.Json.JsonConvert.SerializeObject(listMakerRecord.Select(a => new { UpdateTime = a.UpdateTime.Year < 2000 ? "" : a.UpdateTime.ToString("yyyy-MM-dd HH:mm"), Code = a.MakeCode, SamType = a. == null ? "" : a.SamType, Status = a.Status == null ? "" : a.Status })) + ");", "", 0);
#endregion
}
/// <summary>
/// 请求数据
/// </summary>
void RequestData()
{
CommonDAO commonDAO = CommonDAO.GetInstance();
AutoMakerDAO automakerDAO = AutoMakerDAO.GetInstance();
string value = string.Empty, machineCode = string.Empty;
List <HtmlDataItem> datas = new List <HtmlDataItem>();
List <InfEquInfHitch> equInfHitchs = new List <InfEquInfHitch>();
#region 全自动制样机
datas.Clear();
machineCode = GlobalVars.MachineCode_HYGPJ_1;
///信号接入
//datas.Add(new HtmlDataItem("故障提示", commonDAO.GetSignalDataValue(machineCode, "设备状态") == "发生故障" ? "#ff0000" : "#00ff00", eHtmlDataItemType.svg_color));
//datas.Add(new HtmlDataItem("湿煤破碎电机", commonDAO.GetSignalDataValue(machineCode, "湿煤破碎机") == "1" ? "#00ff00" : "#ff0000", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("X轴位置", commonDAO.GetSignalDataValue(machineCode, "当前轴位置"), eHtmlDataItemType.svg_text));
value = commonDAO.GetSignalDataValue(machineCode, "制样机卸料准备好信号");
if (value == "1")
{
datas.Add(new HtmlDataItem("制样机卸料准备好信号", "制样机卸料准备好", eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("制样机卸料准备好信号", "#00ff00", eHtmlDataItemType.svg_color));
}
else
{
datas.Add(new HtmlDataItem("制样机卸料准备好信号", "制样机卸料未准备好", eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("制样机卸料准备好信号", "#ff0000", eHtmlDataItemType.svg_color));
}
value = commonDAO.GetSignalDataValue(machineCode, "系统自动1手动0");
if (value == "1")
{
datas.Add(new HtmlDataItem("本地", "#000000", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("自动", "#ff0000", eHtmlDataItemType.svg_color));
}
else
{
datas.Add(new HtmlDataItem("本地", "#ff0000", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("自动", "#000000", eHtmlDataItemType.svg_color));
}
value = commonDAO.GetSignalDataValue(machineCode, "归批流程运行中");
if (value == "1")
{
datas.Add(new HtmlDataItem("归批流程", "运行中", eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("归批流程", "#00ff00", eHtmlDataItemType.svg_color));
}
else
{
datas.Add(new HtmlDataItem("归批流程", "未运行", eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("归批流程", "#ff0000", eHtmlDataItemType.svg_color));
}
datas.Add(new HtmlDataItem("存桶选择工位", commonDAO.GetSignalDataValue(machineCode, "存桶选择工位"), eHtmlDataItemType.svg_text));
//datas.Add(new HtmlDataItem("归批流程步", commonDAO.GetSignalDataValue(machineCode, "归批流程步"), eHtmlDataItemType.svg_text));
value = commonDAO.GetSignalDataValue(machineCode, "归批流程状态");
string gplc = "空闲";
if (value == "3")
{
gplc = "进桶到读卡位步";
}
else if (value == "4")
{
gplc = "读卡与判断步";
}
else if (value == "5")
{
gplc = "进桶选桶步";
}
else if (value == "6")
{
gplc = "进桶到存桶工位步";
}
else if (value == "7")
{
gplc = "故障桶排空步";
}
else if (value == "8")
{
gplc = "完成步";
}
datas.Add(new HtmlDataItem("归批流程步", gplc, eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("归批读卡编码", commonDAO.GetSignalDataValue(machineCode, "归批读卡编码"), eHtmlDataItemType.svg_text));
value = commonDAO.GetSignalDataValue(machineCode, "倒料流程运行中");
if (value == "1")
{
datas.Add(new HtmlDataItem("倒料流程", "运行中", eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("倒料流程", "#00ff00", eHtmlDataItemType.svg_color));
}
else
{
datas.Add(new HtmlDataItem("倒料流程", "未运行", eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("倒料流程", "#ff0000", eHtmlDataItemType.svg_color));
}
datas.Add(new HtmlDataItem("倒料选择工位", commonDAO.GetSignalDataValue(machineCode, "倒料选择工位"), eHtmlDataItemType.svg_text));
//datas.Add(new HtmlDataItem("倒料流程步", commonDAO.GetSignalDataValue(machineCode, "倒料流程步"), eHtmlDataItemType.svg_text));
value = commonDAO.GetSignalDataValue(machineCode, "倒料流程运行");
string dllc = "空闲";
if (value == "3")
{
dllc = "进桶到读卡位步";
}
else if (value == "4")
{
}
else if (value == "5")
{
dllc = "进桶选桶步";
}
else if (value == "6")
{
dllc = "进桶到存桶工位步";
}
else if (value == "7")
{
dllc = "故障桶排空步";
}
else if (value == "8")
{
dllc = "完成步";
}
datas.Add(new HtmlDataItem("倒料流程步", dllc, eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("倒料读卡编码", commonDAO.GetSignalDataValue(machineCode, "倒料读卡编码"), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("倒料编码", commonDAO.GetSignalDataValue(machineCode, "倒料编码给定"), eHtmlDataItemType.svg_text));
//datas.Add(new HtmlDataItem("倒料模式", commonDAO.GetSignalDataValue(machineCode, "倒料模式"), eHtmlDataItemType.svg_text));
//样桶信息
List <InfBatchMachineBarrel> barrel = Dbers.GetInstance().SelfDber.Entities <InfBatchMachineBarrel>();
foreach (InfBatchMachineBarrel item in barrel)
{
if (item.BarrelStatus == 1 && item.DataStatus == 1)
{
datas.Add(new HtmlDataItem(item.BarrelStation + "_" + item.BarrelCode, "1", eHtmlDataItemType.svg_visible));
}
else
{
datas.Add(new HtmlDataItem(item.BarrelStation + "_" + item.BarrelCode, "0", eHtmlDataItemType.svg_visible));
}
}
#endregion
//异常信息
string sql = string.Format(@"select
a.signalprefix,a.signalname,a.updatetime
from cmcstbsignaldata a where a.signalprefix like '%合样归批机%' and a.signalname like 'M_%'and a.signalvalue='1' order by updatetime desc
" );
DataTable dt = commonDAO.SelfDber.ExecuteDataTable(sql);
List <WarningTemp> list = new List <WarningTemp>();
if (dt.Rows.Count > 6)
{
for (int i = 0; i < 6; i++)
{
WarningTemp entity = new WarningTemp();
entity.tDate = Convert.ToDateTime(dt.Rows[i]["updatetime"]).ToShortDateString();
entity.tTime = Convert.ToDateTime(dt.Rows[i]["updatetime"]).ToShortTimeString();
entity.MachineName = dt.Rows[i]["signalprefix"].ToString();
entity.Remark = dt.Rows[i]["signalname"].ToString().TrimStart('M').TrimStart('_');
list.Add(entity);
}
}
else
{
for (int i = 0; i < dt.Rows.Count; i++)
{
WarningTemp entity = new WarningTemp();
entity.tDate = Convert.ToDateTime(dt.Rows[i]["updatetime"]).ToShortDateString();
entity.tTime = Convert.ToDateTime(dt.Rows[i]["updatetime"]).ToShortTimeString();
entity.MachineName = dt.Rows[i]["signalprefix"].ToString();
entity.Remark = dt.Rows[i]["signalname"].ToString().TrimStart('M').TrimStart('_');
list.Add(entity);
}
for (int i = dt.Rows.Count; i < 6; i++)
{
WarningTemp entity = new WarningTemp();
entity.tDate = "";
entity.tTime = "";
entity.MachineName = "";
entity.Remark = "";
list.Add(entity);
}
}
datas.Add(new HtmlDataItem("报警", dt.Rows.Count > 0 ? "#ff0000" : "#00ff00", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("报警数目", dt.Rows.Count.ToString(), eHtmlDataItemType.svg_text));
cefWebBrowser.Browser.GetMainFrame().ExecuteJavaScript("LoadHitchs(" + Newtonsoft.Json.JsonConvert.SerializeObject(list.Select(a => new { tDate = a.tDate, tTime = a.tTime, MachineName = a.MachineName, Remark = a.Remark })) + ");", "", 0);
// 发送到页面
cefWebBrowser.Browser.GetMainFrame().ExecuteJavaScript("requestData(" + Newtonsoft.Json.JsonConvert.SerializeObject(datas) + ");", "", 0);
}