/// <summary>
/// 同步报文
/// </summary>
/// <param name="output"></param>
/// <returns></returns>
public List <CmcsTrainCarriagePass> GetDBWInfo(Action <string, eOutputType> output)
{
List <CmcsTrainCarriagePass> cmcstbtrainrecognition = new List <CmcsTrainCarriagePass>();
String interface_dbwdest = CommonDAO.GetInstance().GetAppletConfigString("车号识别文件储存位置");
int interface_dbwtime = CommonDAO.GetInstance().GetAppletConfigInt32("车号识别文件读取天数");
int res = 0;
if (Directory.Exists(interface_dbwdest))
{
String[] dir = Directory.GetFiles(interface_dbwdest);
foreach (var diritem in dir)
{
///解析数据
if (File.Exists(diritem) && CheckUseFull(diritem).AddDays(interface_dbwtime) >= DateTime.Now.Date)
{
String Info = File.ReadAllText(diritem);
if (Info.StartsWith("D"))
{
try
{
//火车方向
String fx = Info.Substring(18, 1) == "0" ? "入厂" : "出厂";
//到达时间
DateTime ddsj = new DateTime(Convert.ToInt32(Info.Substring(34, 4)), Convert.ToInt32(Info.Substring(38, 2)), Convert.ToInt32(Info.Substring(40, 2)), Convert.ToInt32(Info.Substring(42, 2)), Convert.ToInt32(Info.Substring(44, 2)), Convert.ToInt32(Info.Substring(46, 2)));
//通过时间
DateTime tgsj = new DateTime(Convert.ToInt32(Info.Substring(50, 4)), Convert.ToInt32(Info.Substring(54, 2)), Convert.ToInt32(Info.Substring(56, 2)), Convert.ToInt32(Info.Substring(58, 2)), Convert.ToInt32(Info.Substring(60, 2)), Convert.ToInt32(Info.Substring(62, 2)));
//报告时间
DateTime bgsj = new DateTime(Convert.ToInt32(Info.Substring(66, 4)), Convert.ToInt32(Info.Substring(70, 2)), Convert.ToInt32(Info.Substring(72, 2)), Convert.ToInt32(Info.Substring(74, 2)), Convert.ToInt32(Info.Substring(76, 2)), Convert.ToInt32(Info.Substring(78, 2)));
//车数
int countnum = Convert.ToInt32(Info.Substring(82, 3));
//车头
int ctnum = Convert.ToInt32(Info.Substring(85, 1));
//车中
int cznum = Convert.ToInt32(Info.Substring(86, 1));
//车尾
int cwnum = Convert.ToInt32(Info.Substring(87, 1));
if ((int)Info.Substring(88 + 24 * countnum, 1).ToCharArray()[0] == 0x04)
{
for (int i = 0; i < countnum; i++)
{
String trainnum = Info.Substring(88 + 24 * i, 24);
//车型
String cx = "";
//车号
String ch = "";
//车类型
String clx = "";
if (trainnum.StartsWith("T"))
{
//车型
cx = trainnum.Substring(1, 6).Trim();
//车号
ch = trainnum.Substring(7, 7);
clx = "车厢";
}
else if (trainnum.StartsWith("J"))
{
//车型
cx = trainnum.Substring(1, 3);
//车号
ch = trainnum.Substring(4, 4);
clx = "车头";
}
string pkid = ch + "-" + tgsj.ToString("yyyyMMddHHmmss");
if (clx == "车厢")
{
CmcsTrainCarriagePass item = new CmcsTrainCarriagePass
{
OrderNum = 0,
CarModel = cx,
TrainNumber = ch,
PassTime = tgsj,
Speed = 0,
MachineCode = MachineCode_CHSB
};
cmcstbtrainrecognition.Add(item);
}
}
}
}
catch (Exception ex)
{
output(string.Format("解析 {0} 报文失败,原因:{1}", diritem, ex.Message), eOutputType.Error);
}
}
}
}
}
return(cmcstbtrainrecognition);
}
/// <summary>
/// 车辆数据处理_1号车号识别
/// </summary>
/// <param name="carSpotsNum">车辆识别器编号</param>
/// <returns></returns>
public int CarSpotsHandle1(Action <string, eOutputType> output, int carSpotsNum)
{
lock (LockObject)
{
int res = 0;
IList <CmcsTrainRecognition_01> cardata = Dbers.GetInstance().SelfDber.Entities <CmcsTrainRecognition_01>(" where MachineCode like '%" + carSpotsNum + "%' and CrossTime>=to_date('" + DateTime.Now.Date.AddDays(-1) + "','yyyy/mm/dd HH24:MI:SS') and DataFlag=0 and carnumber<>'*' order by CrossTime asc,OrderNum asc");
bool flag = false;
foreach (var item in cardata)
{
if (item.Direction == "进")
{
CmcsTrainWeightRecord transportOver = Dbers.GetInstance().SelfDber.Entity <CmcsTrainWeightRecord>(" where TrainNumber='" + item.CarNumber + "' and IsTurnover='已翻' and ArriveTime>=to_date('" + DateTime.Now.Date.AddDays(-2) + "','yyyy/mm/dd HH24:MI:SS')");
CmcsTrainWeightRecord transport = Dbers.GetInstance().SelfDber.Entity <CmcsTrainWeightRecord>(" where TrainNumber='" + item.CarNumber + "' and IsTurnover='未翻' and ArriveTime>=to_date('" + DateTime.Now.Date.AddDays(-2) + "','yyyy/mm/dd HH24:MI:SS')");
if (transport == null)
{
// 此判断是过滤车辆出厂后立马进厂合并不同轨道车辆的情况，时间相差几分钟
if (transportOver != null)
{
//flag = true;
}
else
{
Dbers.GetInstance().SelfDber.Insert(new CmcsTrainWeightRecord()
{
PKID = item.Id,
TrainNumber = item.CarNumber,
ArriveTime = item.CrossTime,
TrainType = item.CarModel.Trim().TrimStart('T'),
IsTurnover = "未翻",
MachineCode = "1",
DataFlag = 0,
TicketWeight = (decimal)CommonDAO.GetInstance().GetTrainRateLoadByTrainType(item.CarModel.Trim().TrimStart('T')),
OrderNumber = item.OrderNum,
GrossTime = item.CrossTime,
SkinTime = item.CrossTime,
LeaveTime = item.CrossTime,
UnloadTime = item.CrossTime,
});
}
}
CmcsTrainCarriagePass transportPass = Dbers.GetInstance().SelfDber.Entity <CmcsTrainCarriagePass>("where TrainNumber='" + item.CarNumber + "' and PassTime>=to_date('" + DateTime.Now.Date.AddDays(-1) + "','yyyy/mm/dd HH24:MI:SS') order by PassTime desc");
if (transportPass == null)
{
transportPass = new CmcsTrainCarriagePass();
transportPass.TrainNumber = item.CarNumber;
transportPass.CarModel = item.CarModel.Trim().TrimStart('T');
transportPass.MachineCode = "1";
transportPass.PassTime = item.CrossTime;
transportPass.Direction = "进厂";
transportPass.OrderNum = item.OrderNum;
transportPass.DataFlag = 0;
transportPass.PKID = item.Id;
Dbers.GetInstance().SelfDber.Insert(transportPass);
}
// 插入定位信息
if (InsertTransportPosition("入厂", item.CarNumber))
{
output(string.Format("入厂轨道插入定位信息;{0}车号识别 车号:{1}", item.MachineCode, item.CarNumber), eOutputType.Normal);
}
flag = true;
}
else if (item.Direction == "出")
{
CmcsTrainWeightRecord trainRecord = Dbers.GetInstance().SelfDber.Entity <CmcsTrainWeightRecord>("where TrainNumber=:TrainNumber order by ArriveTime desc", new { TrainNumber = item.CarNumber });
if (trainRecord != null)
{
trainRecord.LeaveTime = item.CrossTime;
Dbers.GetInstance().SelfDber.Update(trainRecord);
CmcsTransport transport = Dbers.GetInstance().SelfDber.Entity <CmcsTransport>("where PKID=:PKID order by InfactoryTime desc", new { PKID = item.Id });
if (transport != null)
{
transport.OutfactoryTime = item.CrossTime;
Dbers.GetInstance().SelfDber.Update(transport);
}
}
//移除定位信息
RemoveTransportPosition(item.CarNumber);
flag = true;
}
if (flag)
{
//item.DataFlag = 1;
Dbers.GetInstance().SelfDber.Execute(" update Cmcstbtrainrecognition_01 set DataFlag=1 where Id='" + item.Id + "'");
res++;
}
}
output(string.Format("读取{0}号车号识别数据{1}条", carSpotsNum, res), eOutputType.Normal);
return(res);
}
}
void Search(string input)
{
List <CmcsTransportCompany> list = CommonDAO.GetInstance().GetTransportCompanyByNameOrChs(input.Trim(), sqlWhere);
superGridControl1.PrimaryGrid.DataSource = list;
}
/// <summary>
/// 执行所有任务
/// </summary>
void ExecuteAllTask()
{
#region #1汽车机械采样机
taskSimpleScheduler.StartNewTask("#1汽车机械采样机-快速同步", () =>
{
EquCarJXSamplerDAO carJXSamplerDAO1 = new EquCarJXSamplerDAO(GlobalVars.MachineCode_QC_JxSampler_1, new DapperDber.Dbs.SqlServerDb.SqlServerDapperDber(CommonDAO.GetInstance().GetCommonAppletConfigString("#1汽车机械采样机接口连接字符串")));
if (CommonDAO.GetInstance().TestPing(carJXSamplerDAO1.EquDber.Connection.DataSource))
{
carJXSamplerDAO1.SyncSignal(this.rTxtOutputer.Output);
carJXSamplerDAO1.SyncBarrel(this.rTxtOutputer.Output);
carJXSamplerDAO1.SyncSampleCmd(this.rTxtOutputer.Output);
carJXSamplerDAO1.SyncJXCYControlUnloadCMD(this.rTxtOutputer.Output);
carJXSamplerDAO1.SyncResult(this.rTxtOutputer.Output);
carJXSamplerDAO1.SyncQCJXCYJError(this.rTxtOutputer.Output);
}
else
{
this.rTxtOutputer.Output(string.Format("{0}网络不通", GlobalVars.MachineCode_QC_JxSampler_1), eOutputType.Warn);
}
}, 4000, OutputError);
#endregion
#region #2汽车机械采样机
taskSimpleScheduler.StartNewTask("#2汽车机械采样机-快速同步", () =>
{
EquCarJXSamplerDAO carJXSamplerDAO2 = new EquCarJXSamplerDAO(GlobalVars.MachineCode_QC_JxSampler_2, new DapperDber.Dbs.SqlServerDb.SqlServerDapperDber(CommonDAO.GetInstance().GetCommonAppletConfigString("#2汽车机械采样机接口连接字符串")));
if (CommonDAO.GetInstance().TestPing(carJXSamplerDAO2.EquDber.Connection.DataSource))
{
carJXSamplerDAO2.SyncSignal(this.rTxtOutputer.Output);
carJXSamplerDAO2.SyncBarrel(this.rTxtOutputer.Output);
carJXSamplerDAO2.SyncSampleCmd(this.rTxtOutputer.Output);
carJXSamplerDAO2.SyncJXCYControlUnloadCMD(this.rTxtOutputer.Output);
carJXSamplerDAO2.SyncResult(this.rTxtOutputer.Output);
carJXSamplerDAO2.SyncQCJXCYJError(this.rTxtOutputer.Output);
}
else
{
this.rTxtOutputer.Output(string.Format("{0}网络不通", GlobalVars.MachineCode_QC_JxSampler_1), eOutputType.Warn);
}
}, 4000, OutputError);
#endregion
}
/// <summary>
/// 保存数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSubmit_Click(object sender, EventArgs e)
{
if (this.EditMode == eEditMode.修改)
{
CmcsBuyFuelTransport.SerialNumber = txt_SerialNumber.Text;
CmcsBuyFuelTransport.CarNumber = txt_CarNumber.Text;
if (cmcsSupplier != null)
{
CmcsBuyFuelTransport.SupplierId = cmcsSupplier.Id;
CmcsBuyFuelTransport.SupplierName = cmcsSupplier.Name;
}
if (cmcsTransportCompany != null)
{
CmcsBuyFuelTransport.TransportCompanyId = cmcsTransportCompany.Id;
CmcsBuyFuelTransport.TransportCompanyName = cmcsTransportCompany.Name;
}
if (cmcsMine != null)
{
CmcsBuyFuelTransport.MineId = cmcsMine.Id;
CmcsBuyFuelTransport.MineName = cmcsMine.Name;
}
if (cmcsFuelKind != null)
{
CmcsBuyFuelTransport.FuelKindId = cmcsFuelKind.Id;
CmcsBuyFuelTransport.FuelKindName = cmcsFuelKind.Name;
}
string logValue = "修改前：" + Environment.NewLine;
logValue += "车号：" + CmcsBuyFuelTransport.CarNumber + Environment.NewLine;
logValue += "矿点：" + CmcsBuyFuelTransport.MineName + " 煤种：" + CmcsBuyFuelTransport.FuelKindName + Environment.NewLine;
logValue += "入厂时间：" + CmcsBuyFuelTransport.InFactoryTime + " 矿发量：" + CmcsBuyFuelTransport.TicketWeight + Environment.NewLine;
logValue += "毛重时间：" + CmcsBuyFuelTransport.GrossTime + " 毛重：" + CmcsBuyFuelTransport.GrossWeight + Environment.NewLine;
logValue += "皮重时间：" + CmcsBuyFuelTransport.TareTime + " 皮重：" + CmcsBuyFuelTransport.TareWeight + Environment.NewLine;
logValue += "扣矸：" + CmcsBuyFuelTransport.KgWeight + " 扣水：" + CmcsBuyFuelTransport.KsWeight + " 自动扣水：" + CmcsBuyFuelTransport.AutoKsWeight + Environment.NewLine;
logValue += "出厂时间：" + CmcsBuyFuelTransport.OutFactoryTime + " 验收量：" + CmcsBuyFuelTransport.CheckWeight + Environment.NewLine;
CmcsBuyFuelTransport.SamplingType = (string)cmb_SampingType.SelectedItem;
CmcsBuyFuelTransport.TicketWeight = (decimal)dbi_TicketWeight.Value;
CmcsBuyFuelTransport.GrossWeight = (decimal)dbi_GrossWeight.Value;
CmcsBuyFuelTransport.TareWeight = (decimal)dbi_TareWeight.Value;
CmcsBuyFuelTransport.KgWeight = (decimal)dbi_KgWeight.Value;
CmcsBuyFuelTransport.KsWeight = (decimal)dbi_KsWeight.Value;
CmcsBuyFuelTransport.Remark = txt_Remark.Text;
CmcsBuyFuelTransport.IsFinish = (chb_IsFinish.Checked ? 1 : 0);
CmcsBuyFuelTransport.IsUse = (chb_IsUse.Checked ? 1 : 0);
// 生成批次以及采制化三级编码数据
CmcsInFactoryBatch inFactoryBatch = carTransportDAO.GCQCInFactoryBatchByBuyFuelTransport(CmcsBuyFuelTransport);
WeighterDAO.GetInstance().SaveBuyFuelTransportHand(CmcsBuyFuelTransport);
logValue += "修改后：" + Environment.NewLine;
logValue += "车号：" + CmcsBuyFuelTransport.CarNumber + Environment.NewLine;
logValue += "矿点:" + CmcsBuyFuelTransport.MineName + " 煤种：" + CmcsBuyFuelTransport.FuelKindName + Environment.NewLine;
logValue += "入厂时间：" + CmcsBuyFuelTransport.InFactoryTime + " 矿发量：" + CmcsBuyFuelTransport.TicketWeight + Environment.NewLine;
logValue += "毛重时间：" + CmcsBuyFuelTransport.GrossTime + " 毛重：" + CmcsBuyFuelTransport.GrossWeight + Environment.NewLine;
logValue += "皮重时间：" + CmcsBuyFuelTransport.TareTime + " 皮重：" + CmcsBuyFuelTransport.TareWeight + Environment.NewLine;
logValue += "扣矸：" + CmcsBuyFuelTransport.KgWeight + " 扣水：" + CmcsBuyFuelTransport.KsWeight + " 自动扣水：" + CmcsBuyFuelTransport.AutoKsWeight + Environment.NewLine;
logValue += "出厂时间：" + CmcsBuyFuelTransport.OutFactoryTime + " 验收量：" + CmcsBuyFuelTransport.CheckWeight + Environment.NewLine;
logValue += "修改人：" + SelfVars.LoginUser.UserName;
CommonDAO.GetInstance().SaveAppletLog(eAppletLogLevel.Info, "修改运输记录", logValue, SelfVars.LoginUser.UserAccount);
}
this.DialogResult = DialogResult.OK;
this.Close();
}
/// <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
}
protected override bool Execute(string name, CefV8Value obj, CefV8Value[] arguments, out CefV8Value returnValue, out string exception)
{
exception = null;
returnValue = null;
string paramSampler = arguments[0].GetStringValue();
switch (name)
{
// 急停
case "Stop":
commonDAO.SendAppRemoteControlCmd(MonitorCommon.GetInstance().GetCarSamplerMachineCodeBySelected(arguments[0].GetStringValue()), "急停", "1");
CefProcessMessage cefMsg1 = CefProcessMessage.Create("SaveOperationLog");
cefMsg1.Arguments.SetSize(0);
cefMsg1.Arguments.SetString(0, "设置" + MonitorCommon.GetInstance().GetCarSamplerMachineCodeBySelected(arguments[0].GetStringValue()) + "急停");
CefV8Context.GetCurrentContext().GetBrowser().SendProcessMessage(CefProcessId.Browser, cefMsg1);
break;
// 复位
case "Reset":
commonDAO.SendAppRemoteControlCmd(MonitorCommon.GetInstance().GetCarSamplerMachineCodeBySelected(arguments[0].GetStringValue()), "急停", "0");
CefProcessMessage cefMsg2 = CefProcessMessage.Create("SaveOperationLog");
cefMsg2.Arguments.SetSize(0);
cefMsg2.Arguments.SetString(0, "设置" + MonitorCommon.GetInstance().GetCarSamplerMachineCodeBySelected(arguments[0].GetStringValue()) + "急停复位");
CefV8Context.GetCurrentContext().GetBrowser().SendProcessMessage(CefProcessId.Browser, cefMsg2);
break;
// 制样急停
case "ZYStop":
commonDAO.SendAppRemoteControlCmd(MonitorCommon.GetInstance().GetCarSamplerMachineCodeBySelected(arguments[0].GetStringValue()), "制样急停", "1");
CefProcessMessage cefMsg3 = CefProcessMessage.Create("SaveOperationLog");
cefMsg3.Arguments.SetSize(0);
cefMsg3.Arguments.SetString(0, "设置" + MonitorCommon.GetInstance().GetCarSamplerMachineCodeBySelected(arguments[0].GetStringValue()) + "制样急停");
CefV8Context.GetCurrentContext().GetBrowser().SendProcessMessage(CefProcessId.Browser, cefMsg3);
break;
// 制样复位
case "ZYReset":
commonDAO.SendAppRemoteControlCmd(MonitorCommon.GetInstance().GetCarSamplerMachineCodeBySelected(arguments[0].GetStringValue()), "制样急停", "0");
CefProcessMessage cefMsg4 = CefProcessMessage.Create("SaveOperationLog");
cefMsg4.Arguments.SetSize(0);
cefMsg4.Arguments.SetString(0, "设置" + MonitorCommon.GetInstance().GetCarSamplerMachineCodeBySelected(arguments[0].GetStringValue()) + "制样急停复位");
CefV8Context.GetCurrentContext().GetBrowser().SendProcessMessage(CefProcessId.Browser, cefMsg4);
break;
// 车辆信息
case "CarInfo":
if (paramSampler == "#1")
{
MessageBox.Show("#1 CarInfo");
}
else if (paramSampler == "#2")
{
MessageBox.Show("#2 CarInfo");
}
break;
// 故障复位
case "ErrorReset":
if (paramSampler == "#1")
{
MessageBox.Show("#1 ErrorReset");
}
else if (paramSampler == "#2")
{
MessageBox.Show("#2 ErrorReset");
}
break;
// 采样历史记录
case "SampleHistory":
if (paramSampler == "#1")
{
MessageBox.Show("#1 SampleHistory");
}
else if (paramSampler == "#2")
{
MessageBox.Show("#2 SampleHistory");
}
break;
//获取异常信息
case "GetHitchs":
//异常信息
string machineCode = string.Empty;
if (paramSampler == "#1")
{
machineCode = GlobalVars.MachineCode_QCJXCYJ_1;
}
else if (paramSampler == "#2")
{
machineCode = GlobalVars.MachineCode_QCJXCYJ_2;
}
equInfHitchs = CommonDAO.GetInstance().GetEquInfHitchsByTime(machineCode, DateTime.Now);
returnValue = CefV8Value.CreateString(Newtonsoft.Json.JsonConvert.SerializeObject(equInfHitchs.Select(a => new { MachineCode = a.MachineCode, HitchTime = a.HitchTime.ToString("yyyy-MM-dd HH:mm"), HitchDescribe = a.HitchDescribe })));
break;
case "ChangeSelected":
CefProcessMessage cefMsg = CefProcessMessage.Create("CarSamplerChangeSelected");
cefMsg.Arguments.SetSize(0);
cefMsg.Arguments.SetString(0, paramSampler);
CefV8Context.GetCurrentContext().GetBrowser().SendProcessMessage(CefProcessId.Browser, cefMsg);
break;
// 打开实时视频预览
case "OpenHikVideo":
cefMsg = CefProcessMessage.Create("OpenHikVideo");
cefMsg.Arguments.SetSize(0);
cefMsg.Arguments.SetString(0, arguments[0].GetStringValue());
CefV8Context.GetCurrentContext().GetBrowser().SendProcessMessage(CefProcessId.Browser, cefMsg);
break;
default:
returnValue = null;
break;
}
return(true);
}
/// <summary>
/// 解析报文数据
/// </summary>
/// <returns></returns>
public List <CmcsTrainWeightRecord> GetTrainWeightInfo()
{
String interface_path = CommonDAO.GetInstance().GetCommonAppletConfigString("轨道衡报文路径");
int interface_day = CommonDAO.GetInstance().GetCommonAppletConfigInt32("轨道衡数据读取天数");
List <CmcsTrainWeightRecord> items = new List <CmcsTrainWeightRecord>();
List <string> st = new List <string>();
for (int i = 0; i <= interface_day; i++)
{
String[] directory = Directory.GetFiles(interface_path, String.Format("{0}_*", DateTime.Now.AddDays(-i).ToString("yyMMdd")));
st.AddRange(directory);
}
foreach (var item in st)
{
String bw = File.ReadAllText(item, Encoding.GetEncoding("gb2312"));
//if (bw.Contains("*"))
// continue;
String[] strs = bw.Split(new string[] { "\r\n" }, StringSplitOptions.None);
DateTime dt = new DateTime(2000, 1, 1);
String fx = "";
String name = "";
for (int i = 0; i < strs.Count(); i++)
{
if (i == 1)
{
if (strs[i].Contains("<--"))
{
fx = "出厂";
}
else if (strs[i].Contains("-->"))
{
fx = "入厂";
}
}
if (i == 3)
{
string ss = DateTime.Now.ToString("yyyy").Substring(0, 2) + strs[i].Substring(strs[i].IndexOf(':') + 1, strs[i].Length - strs[i].IndexOf(':') - 1);
ss = ss.Substring(0, 4) + "-" + ss.Substring(4, 2) + "-" + ss.Substring(6, 2) + " " + ss.Substring(9, 2) + ":" + ss.Substring(11, 2) + ":" + ss.Substring(13, 2);
DateTime.TryParse(ss, out dt);
}
if (i >= 5)
{
String[] ss = strs[i].Split(',');
if (ss.Count() >= 10)
{
CmcsTrainWeightRecord tw = new CmcsTrainWeightRecord();
int twOrderNumber;
if (int.TryParse(ss[0].Trim(), out twOrderNumber))
{
tw.OrderNumber = twOrderNumber;
}
tw.TrainNumber = ss[1].Trim();
Decimal twGrossWeight;
if (Decimal.TryParse(ss[2].Trim(), out twGrossWeight))
{
if ((twGrossWeight < 25 && fx == "入厂") || (twGrossWeight > 25 && fx == "出厂") || twGrossWeight == 0)
{
continue;
}
tw.GrossWeight = twGrossWeight;
}
Decimal twTareWeight;
if (Decimal.TryParse(ss[3].Trim(), out twTareWeight))
{
tw.SkinWeight = twTareWeight;//不同步皮重
}
Decimal twSuttleWeight;
if (Decimal.TryParse(ss[4].Trim(), out twSuttleWeight))
{
tw.StandardWeight = twSuttleWeight;
}
tw.SupplierName = ss[6].Trim();
decimal ticketWeight;
if (Decimal.TryParse(ss[8].Trim(), out ticketWeight))
{
tw.TicketWeight = ticketWeight;
}
Decimal twSpeed;
if (Decimal.TryParse(ss[9].Trim(), out twSpeed))
{
tw.Speed = twSpeed;
}
tw.TrainType = ss[10].Trim();
tw.PKID = dt.ToString("yyyyMMddHHmmss") + "-" + tw.OrderNumber;
tw.GrossTime = dt;
tw.ArriveTime = tw.GrossTime;
tw.SkinTime = dt;
tw.LeaveTime = dt;
tw.MesureMan = name;
tw.InFactoryDirection = fx;
tw.MachineCode = "轨道衡";
items.Add(tw);
}
}
}
}
return(items);
}
/// <summary>
/// 同步车号识别数据
/// </summary>
/// <param name="output"></param>
/// <returns></returns>
public void SyncTrainRecognitionInfo(Action <string, eOutputType> output)
{
CmcsTrainRecognition train = Dbers.GetInstance().SelfDber.Entity <CmcsTrainRecognition>("where Status=0 and MachineCode=1 order by CrossTime desc");
CommonDAO.GetInstance().SetSignalDataValue(GlobalVars.MachineCode_Recognition_1, eSignalDataName.当前车号.ToString(), train != null ? train.CarNumber : "");
CmcsTrainRecognition train2 = Dbers.GetInstance().SelfDber.Entity <CmcsTrainRecognition>("where Status=0 and MachineCode=2 order by CrossTime desc");
CommonDAO.GetInstance().SetSignalDataValue(GlobalVars.MachineCode_Recognition_2, eSignalDataName.当前车号.ToString(), train2 != null ? train2.CarNumber : "");
int CrossNumber = Dbers.GetInstance().SelfDber.Count <CmcsTrainRecognition>("where CrossTime>=:CrossTime and MachineCode=1 order by CrossTime desc", new { CrossTime = DateTime.Now.Date });
CommonDAO.GetInstance().SetSignalDataValue(GlobalVars.MachineCode_Recognition_1, eSignalDataName.当日已过车数.ToString(), CrossNumber.ToString());
int CrossNumber2 = Dbers.GetInstance().SelfDber.Count <CmcsTrainRecognition>("where CrossTime>=:CrossTime and MachineCode=2 order by CrossTime desc", new { CrossTime = DateTime.Now.Date });
CommonDAO.GetInstance().SetSignalDataValue(GlobalVars.MachineCode_Recognition_2, eSignalDataName.当日已过车数.ToString(), CrossNumber2.ToString());
if (train != null)
{
CmcsTrainWeightRecord trainWeight = Dbers.GetInstance().SelfDber.Entity <CmcsTrainWeightRecord>("where TrainNumber=:TrainNumber and GrossTime<:GrossTime and GrossWeight=0 order by GrossTime desc", new { TrainNumber = train.CarNumber, GrossTime = train.CrossTime });
CommonDAO.GetInstance().SetSignalDataValue(GlobalVars.MachineCode_Recognition_2, eSignalDataName.当前记录Id.ToString(), trainWeight != null ? trainWeight.PKID : "");
}
if (train2 != null)
{
CmcsTrainWeightRecord trainWeight2 = Dbers.GetInstance().SelfDber.Entity <CmcsTrainWeightRecord>("where TrainNumber=:TrainNumber and GrossTime<:GrossTime and GrossWeight=0 order by GrossTime desc", new { TrainNumber = train2.CarNumber, GrossTime = train2.CrossTime });
CommonDAO.GetInstance().SetSignalDataValue(GlobalVars.MachineCode_Recognition_2, eSignalDataName.当前记录Id.ToString(), trainWeight2 != null ? trainWeight2.PKID : "");
}
//入场总车数
int WeightTotal = CommonDAO.GetInstance().SelfDber.Count <CmcsTrainWeightRecord>("where ArriveTime>=:ArriveTime", new { ArriveTime = DateTime.Now.Date });
//翻车总车数
int GrossTotal = CommonDAO.GetInstance().SelfDber.Count <CmcsTrainRecognition>("where CrossTime>=:CrossTime ", new { CrossTime = DateTime.Now.Date });
//待翻车数
CommonDAO.GetInstance().SetSignalDataValue(GlobalVars.MachineCode_TrunOver, eSignalDataName.当日待翻车数.ToString(), (WeightTotal - GrossTotal).ToString());
//检测火车入场时间
IList <CmcsTrainWeightRecord> list = CommonDAO.GetInstance().SelfDber.Entities <CmcsTrainWeightRecord>("where ArriveTime>=:ArriveTime", new { ArriveTime = DateTime.Now.Date });
if (list != null)
{
IList <CmcsTrainWeightRecord> list_over = list.Where(a => (DateTime.Now - a.ArriveTime).Hours > CommonDAO.GetInstance().GetCommonAppletConfigInt32("火车入场最长时间")).ToList();
if (list_over != null && list_over.Count > 0)
{
string msgContent = string.Empty;
if (list_over.Count < 6)
{
msgContent = "火车入场超时:";
IList <string> TrainNumbers = list_over.Select(a => a.TrainNumber).ToList();
foreach (string item in TrainNumbers)
{
msgContent += item + ",";
}
msgContent = msgContent.TrimEnd(',');
}
else
{
msgContent = string.Format("火车入场：{0}节车厢超时，请到火车入场列表查看", list_over.Count);
}
CommonDAO.GetInstance().SaveSysMessage("轨道衡", msgContent);
}
}
}
private void panel1_Paint(object sender, PaintEventArgs e)
{
Graphics g = e.Graphics;
string SerialNumber = string.Empty,
CarNumber = string.Empty,
MineName = string.Empty,
FuelKindName = string.Empty,
GrossTime = string.Empty,
TareTime = string.Empty,
TicketWeight = string.Empty,
GrossWeight = string.Empty,
TareWeight = string.Empty,
SuttleWeight = string.Empty,
DeductWeight = string.Empty,
CheckWeight = string.Empty,
UserName = string.Empty;
if (this._BuyFuelTransport != null)
{
SerialNumber = this._BuyFuelTransport.SerialNumber;
CarNumber = this._BuyFuelTransport.CarNumber;
MineName = this._BuyFuelTransport.MineName;
FuelKindName = this._BuyFuelTransport.FuelKindName;
GrossTime = DisposeTime(this._BuyFuelTransport.GrossTime.ToString(), "yyyy-MM-dd HH:mm");
TareTime = DisposeTime(this._BuyFuelTransport.TareTime.ToString(), "yyyy-MM-dd HH:mm");
TicketWeight = this._BuyFuelTransport.TicketWeight.ToString("F2").PadLeft(6, ' ');
GrossWeight = this._BuyFuelTransport.GrossWeight.ToString("F2").PadLeft(6, ' ');
TareWeight = this._BuyFuelTransport.TareWeight.ToString("F2").PadLeft(6, ' ');
SuttleWeight = this._BuyFuelTransport.SuttleWeight.ToString("F2").PadLeft(6, ' ');
DeductWeight = this._BuyFuelTransport.DeductWeight.ToString("F2").PadLeft(6, ' ');
List <CmcsBuyFuelTransportDeduct> deductlist = CommonDAO.GetInstance().SelfDber.Entities <CmcsBuyFuelTransportDeduct>("where TransportId=:Transportid order by CreationTime desc", new { Transportid = this._BuyFuelTransport.Id });
#region 入厂煤
// 行间距 24
float TopValue = 53;
string printValue = "";
g.DrawString("国电投青铝发电有限公司", TitleFont, Brushes.White, 30, TopValue);
TopValue += 34;
g.DrawString("打印时间：" + DateTime.Now.ToString("yyyy-MM-dd HH:mm"), ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
g.DrawLine(new Pen(Color.White, 2), 0, TopValue, 300 - 10, TopValue);
TopValue += 15;
g.DrawString("车 牌 号：" + CarNumber, ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
printValue = printValue = "矿 点：" + MineName;
if (printValue.Length > 18)
{
g.DrawString(printValue.Substring(0, 18), ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
g.DrawString(printValue.Substring(18, printValue.Length - 18), ContentFont, Brushes.White, 105, TopValue);
TopValue += 24;
}
else
{
g.DrawString(printValue, ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
}
g.DrawString("煤 种：" + FuelKindName, ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
g.DrawString(string.Format("矿 发 量：{0} 吨", TicketWeight), ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
g.DrawString(string.Format("毛 重：{0} 吨", GrossWeight), ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
g.DrawString("毛重时间：" + this._BuyFuelTransport.GrossTime.ToString("yyyy-MM-dd HH:mm"), ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
g.DrawString(string.Format("皮 重：{0} 吨", TareWeight), ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
g.DrawString("皮重时间：" + this._BuyFuelTransport.TareTime.ToString("yyyy-MM-dd HH:mm"), ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
int deductindex = 1;
foreach (CmcsBuyFuelTransportDeduct item in deductlist)
{
g.DrawString(string.Format("扣 吨{0}：{1} 吨 ({2})", deductindex, item.DeductWeight, item.DeductType), ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
deductindex++;
}
g.DrawString(string.Format("净 重：{0} 吨", SuttleWeight), ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
g.DrawString(string.Format("计量员签字："), ContentFont, Brushes.White, 30, TopValue);
TopValue += 34;
g.DrawString(string.Format("监磅员签字："), ContentFont, Brushes.White, 30, TopValue);
TopValue += 34;
g.DrawString(string.Format("司机签字："), ContentFont, Brushes.White, 30, TopValue);
TopValue += 34;
g.DrawString("", ContentFont, Brushes.Black, 30, TopValue);
#endregion
}
else if (this._GoodsTransport != null)
{
SerialNumber = this._GoodsTransport.SerialNumber;
CarNumber = this._GoodsTransport.CarNumber;
MineName = this._GoodsTransport.SupplyUnitName;
FuelKindName = this._GoodsTransport.GoodsTypeName;
GrossTime = DisposeTime(this._GoodsTransport.FirstTime.ToString(), "yyyy-MM-dd HH:mm");
TareTime = DisposeTime(this._GoodsTransport.SecondTime.ToString(), "yyyy-MM-dd HH:mm");
GrossWeight = this._GoodsTransport.FirstWeight.ToString("F2").PadLeft(6, ' ');
TareWeight = this._GoodsTransport.SecondWeight.ToString("F2").PadLeft(6, ' ');
SuttleWeight = this._GoodsTransport.SuttleWeight.ToString("F2").PadLeft(6, ' ');
#region 其他物资
// 行间距 24
float TopValue = 53;
string printValue = "";
g.DrawString(PrintAppConfig.GetInstance().TitleContent, TitleFont, Brushes.Black, 30, TopValue);
TopValue += 34;
g.DrawString("打印时间：" + DateTime.Now.ToString("yyyy-MM-dd HH:mm"), ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
g.DrawLine(new Pen(Color.Black, 2), 0, TopValue, 300 - 10, TopValue);
TopValue += 15;
g.DrawString("车 牌 号：" + CarNumber, ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
printValue = "单 位：" + MineName;
if (printValue.Length > 18)
{
g.DrawString(printValue.Substring(0, 18), ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
g.DrawString(printValue.Substring(18, printValue.Length - 18), ContentFont, Brushes.White, 105, TopValue);
TopValue += 24;
}
else
{
g.DrawString(printValue, ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
}
g.DrawString("物资类型：" + FuelKindName, ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
g.DrawString(string.Format("一次称重：{0} 吨", GrossWeight), ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
g.DrawString("一次时间：" + GrossTime, ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
g.DrawString(string.Format("二次称重：{0} 吨", TareWeight), ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
g.DrawString("二次时间：" + TareTime, ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
g.DrawString(string.Format("净 重：{0} 吨", SuttleWeight), ContentFont, Brushes.White, 30, TopValue);
TopValue += 24;
g.DrawString(string.Format("计量员签字："), ContentFont, Brushes.White, 30, TopValue);
TopValue += 34;
g.DrawString(string.Format("监磅员签字："), ContentFont, Brushes.White, 30, TopValue);
TopValue += 34;
g.DrawString(string.Format("司机签字："), ContentFont, Brushes.White, 30, TopValue);
TopValue += 34;
g.DrawString("", ContentFont, Brushes.Black, 30, TopValue);
#endregion
}
}
/// <summary>
/// 执行所有任务
/// </summary>
void ExecuteAllTask()
{
#region #1全自动制样机
EquAutoMakerDAO autoMakerDAO1 = new EquAutoMakerDAO(GlobalVars.MachineCode_QZDZYJ_1, new DapperDber.Dbs.SqlServerDb.SqlServerDapperDber(CommonDAO.GetInstance().GetCommonAppletConfigString("#1全自动制样机接口连接字符串")));
taskSimpleScheduler.StartNewTask("#1全自动制样机-快速同步", () =>
{
autoMakerDAO1.SyncCmd(this.rTxtOutputer.Output);
autoMakerDAO1.SyncError(this.rTxtOutputer.Output);
autoMakerDAO1.SyncSignal(this.rTxtOutputer.Output);
autoMakerDAO1.SyncMakeDetail(this.rTxtOutputer.Output);
}, 2000, OutputError);
taskSimpleScheduler.StartNewTask("#1全自动制样机-OPC同步", () =>
{
EquAutoMakerOPC.GetInstance().SyncOPCTags(this.rTxtOutputer.Output);
}, 0, OutputError);
taskSimpleScheduler.StartNewTask("#1全自动制样机执行命令", () =>
{
EquAutoMakerOPC.GetInstance().RunCmd(this.rTxtOutputer.Output);
}, 500, OutputError);
#endregion
}
/// <summary>
/// 生成抽查样
/// </summary>
/// <param name="assay">原化验记录</param>
/// <param name="UserName">操作人</param>
/// <param name="assayPoint">化验指标</param>
/// <param name="PreFix">化验类型</param>
/// <returns></returns>
public bool CreateSpotAssay(CmcsRCAssay entity, string userName, string userAccount, string assayPoint, string PreFix, ref CmcsRCAssay assay)
{
try
{
assay = new CmcsRCAssay();
assay.AssayPoint = assayPoint;
assay.AssayType = "三级编码化验";
assay.SendDate = GlobalVars.ServerNowDateTime;
//assay.AssayDate = GlobalVars.ServerNowDateTime;
CmcsRCMake make = entity.TheRcMake;
if (make.TheRcSampling != null && make.TheRcSampling.TheInFactoryBatch != null)
{
assay.InFactoryBatchId = make.TheRcSampling.TheInFactoryBatch.Id;
}
assay.MakeId = make.Id;
assay.IsRelieve = 1;
assay.AssayPle = userName;
assay.AssayCode = CommonDAO.GetInstance().CreateNewAssayCode(DateTime.Now);
assay.AssayWay = PreFix;
assay.Remark = "由化验室接样程序手动生成";
assay.ParentId = entity.Id;
assay.BackBatchDate = entity.BackBatchDate;
CmcsFuelQuality quality_new = new CmcsFuelQuality();
CmcsRCAssay assay_new = CommonDAO.GetInstance().SelfDber.Entity <CmcsRCAssay>("where MakeId=:MakeId order by CreateDate desc", new { MakeId = make.Id });
if (assay_new != null)
{
quality_new = (CmcsFuelQuality)Clone(assay_new.TheFuelQuality);
}
quality_new.CreateDate = quality_new.OperDate = DateTime.Now;
if (assayPoint.Contains("全水分") || assayPoint.Contains("全指标") || assayPoint.Contains("日常分析"))
{
quality_new.Mar = 0;
}
if (assayPoint.Contains("空干基水分") || assayPoint.Contains("全指标") || assayPoint.Contains("日常分析"))
{
quality_new.Mad = 0;
quality_new.FCad = 0;
}
if (assayPoint.Contains("灰分") || assayPoint.Contains("全指标") || assayPoint.Contains("日常分析"))
{
quality_new.Aad = 0;
quality_new.Ad = 0;
quality_new.Aar = 0;
quality_new.FCad = 0;
}
if (assayPoint.Contains("挥发分") || assayPoint.Contains("全指标") || assayPoint.Contains("日常分析"))
{
quality_new.Vad = 0;
quality_new.Vdaf = 0;
quality_new.Vd = 0;
quality_new.Var = 0;
quality_new.FCad = 0;
}
if (assayPoint.Contains("全硫") || assayPoint.Contains("全指标") || assayPoint.Contains("日常分析"))
{
quality_new.Stad = 0;
quality_new.Star = 0;
quality_new.Std = 0;
quality_new.Sd = 0;
}
if (assayPoint.Contains("热值") || assayPoint.Contains("全指标") || assayPoint.Contains("日常分析"))
{
quality_new.QbAd = 0;
quality_new.Qgrad = 0;
quality_new.Qgrar = 0;
quality_new.Qgrd = 0;
quality_new.QCal = 0;
quality_new.QJ = 0;
}
if (assayPoint.Contains("氢值") || assayPoint.Contains("全指标") || assayPoint.Contains("日常分析"))
{
quality_new.Hd = 0;
quality_new.Had = 0;
quality_new.Har = 0;
}
if (assayPoint.Contains("灰熔融") || assayPoint.Contains("全指标"))
{
quality_new.DT = 0;
quality_new.HT = 0;
quality_new.FT = 0;
quality_new.ST = 0;
}
quality_new.Id = Guid.NewGuid().ToString();
quality_new.CreateUser = userAccount;
quality_new.OperUser = userAccount;
assay.FuelQualityId = quality_new.Id;
Dbers.GetInstance().SelfDber.Insert(quality_new);
Dbers.GetInstance().SelfDber.Insert(assay);
return(true);
}
catch (Exception)
{
return(false);
}
}
/// <summary>
/// 生成制样及化验
/// </summary>
/// <param name="makeCode"></param>
/// <param name="assayType"></param>
/// <param name="user"></param>
/// <param name="assayTarget"></param>
/// <returns></returns>
public bool CreateMakeAndAssay(ref string makeCode, string assayType, string user, string assayTarget)
{
bool isSuccess = false;
CmcsRCMake make = Dbers.GetInstance().SelfDber.Entity <CmcsRCMake>("where MakeCode=:MakeCode order by CreateDate desc ", new { MakeCode = makeCode });
if (make != null)
{
CmcsRCSampling rCSampling = Dbers.GetInstance().SelfDber.Get <CmcsRCSampling>(make.SamplingId);
if (rCSampling != null)
{
// 入厂煤制样
CmcsRCMake rCMake = new CmcsRCMake()
{
SamplingId = rCSampling.Id,
MakeStyle = eMakeType.机器制样.ToString(),
MakeType = assayType,
MakeStartTime = DateTime.Now,
MakeEndTime = DateTime.Now,
MakeCode = CommonDAO.GetInstance().CreateNewMakeCode(DateTime.Now),
MakePle = user,
ParentMakeId = make.Id
};
isSuccess = Dbers.GetInstance().SelfDber.Insert(rCMake) > 0;
makeCode = rCMake.MakeCode;
//入厂煤制样明细
foreach (CodeContent item in CommonDAO.GetInstance().GetCodeContentByKind("制样类型"))
{
CmcsRCMakeDetail rCMakeDetail = Dbers.GetInstance().SelfDber.Entity <CmcsRCMakeDetail>("where MakeId=:MakeId and SampleType=:SampleType", new { MakeId = rCMake.Id, SampleType = item.Content });
if (rCMakeDetail == null)
{
rCMakeDetail = new CmcsRCMakeDetail();
rCMakeDetail.MakeId = rCMake.Id;
rCMakeDetail.BarrelCode = CommonDAO.GetInstance().CreateNewMakeBarrelCodeByMakeCode(rCMake.MakeCode, item.Content);
rCMakeDetail.SampleType = item.Content;
isSuccess = Dbers.GetInstance().SelfDber.Insert(rCMakeDetail) > 0;
}
}
// 入厂煤化验
CmcsRCAssay rCAssay = Dbers.GetInstance().SelfDber.Entity <CmcsRCAssay>("where MakeId=:MakeId", new { MakeId = rCMake.Id });
if (rCAssay == null)
{
// 入厂煤煤质
CmcsFuelQuality fuelQuality = new CmcsFuelQuality()
{
Id = Guid.NewGuid().ToString()
};
if (Dbers.GetInstance().SelfDber.Insert(fuelQuality) > 0)
{
rCAssay = new CmcsRCAssay()
{
MakeId = rCMake.Id,
AssayType = assayType,
AssayWay = assayType,
AssayCode = CommonDAO.GetInstance().CreateNewAssayCode(rCMake.CreateDate),
InFactoryBatchId = rCSampling.InFactoryBatchId,
FuelQualityId = fuelQuality.Id,
AssayDate = rCMake.CreateDate,
WfStatus = 0,
AssayPoint = assayTarget
};
isSuccess = Dbers.GetInstance().SelfDber.Insert(rCAssay) > 0;
}
}
}
}
return(isSuccess);
}
/// <summary>
/// 请求数据
/// </summary>
void RequestData()
{
string value = string.Empty, machineCode = string.Empty;
List <HtmlDataItem> datas = new List <HtmlDataItem>();
List <InfEquInfHitch> equInfHitchs = new List <InfEquInfHitch>();
#region 汽车机械采样机 #1
datas.Clear();
machineCode = this.CurrentMachineCode;
datas.Add(new HtmlDataItem("机械采样机_当前采样机", machineCode, eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("1号机械采样机_系统", monitorCommon.ConvertMachineStatusToColor(commonDAO.GetSignalDataValue(GlobalVars.MachineCode_QCJXCYJ_1, eSignalDataName.系统.ToString())), eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("2号机械采样机_系统", monitorCommon.ConvertMachineStatusToColor(commonDAO.GetSignalDataValue(GlobalVars.MachineCode_QCJXCYJ_2, eSignalDataName.系统.ToString())), eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("3号机械采样机_系统", monitorCommon.ConvertMachineStatusToColor(commonDAO.GetSignalDataValue(GlobalVars.MachineCode_QCJXCYJ_3, eSignalDataName.系统.ToString())), eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_采样编码", commonDAO.GetSignalDataValue(machineCode, eSignalDataName.采样编码.ToString()), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("机械采样机_矿发量", commonDAO.GetSignalDataValue(machineCode, eSignalDataName.矿发量.ToString()), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("机械采样机_采样时间", commonDAO.GetSignalDataValue(machineCode, eSignalDataName.采样时间.ToString()), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("机械采样机_车牌号", commonDAO.GetSignalDataValue(machineCode, eSignalDataName.当前车号.ToString()), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("机械采样机_采样点数", commonDAO.GetSignalDataValue(machineCode, eSignalDataName.采样点数.ToString()), eHtmlDataItemType.svg_text));
datas.Add(new HtmlDataItem("机械采样机_小车1", commonDAO.GetSignalDataValue(machineCode, "小车") == "1" ? "Red" : "url(#rect1770_1_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_小车2", commonDAO.GetSignalDataValue(machineCode, "小车") == "1" ? "Red" : "url(#rect1752_1_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_小车3", commonDAO.GetSignalDataValue(machineCode, "小车") == "1" ? "Red" : "url(#rect1761_1_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_小车4", commonDAO.GetSignalDataValue(machineCode, "小车") == "1" ? "Red" : "url(#rect1716_1_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_小车5", commonDAO.GetSignalDataValue(machineCode, "小车") == "1" ? "Red" : "url(#rect1725_1_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_小车6", commonDAO.GetSignalDataValue(machineCode, "小车") == "1" ? "Red" : "url(#rect1734_1_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_小车7", commonDAO.GetSignalDataValue(machineCode, "小车") == "1" ? "Red" : "url(#polygon1743_1_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_接料斗1", commonDAO.GetSignalDataValue(machineCode, "接料斗") == "1" ? "Red" : "url(#_164344952_2_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_接料斗2", commonDAO.GetSignalDataValue(machineCode, "接料斗") == "1" ? "Red" : "url(#_130855712_2_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_接料斗3", commonDAO.GetSignalDataValue(machineCode, "接料斗") == "1" ? "Red" : "url(#_164355560_2_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_接料斗4", commonDAO.GetSignalDataValue(machineCode, "接料斗") == "1" ? "Red" : "url(#_164351936_2_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_除铁给料皮带", commonDAO.GetSignalDataValue(machineCode, "给料皮带") == "1" ? "Red" : "#808080", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_溜煤管", commonDAO.GetSignalDataValue(machineCode, "溜煤管") == "1" ? "Red" : "url(#polygon984_1_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_锤式破碎机1", commonDAO.GetSignalDataValue(machineCode, "锤式破碎机") == "1" ? "Red" : "url(#_125277864-0_2_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_锤式破碎机2", commonDAO.GetSignalDataValue(machineCode, "锤式破碎机") == "1" ? "Red" : "url(#_164348960_2_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_锤式破碎机3", commonDAO.GetSignalDataValue(machineCode, "锤式破碎机") == "1" ? "Red" : "url(#_130854176_2_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_锤式破碎机4", commonDAO.GetSignalDataValue(machineCode, "锤式破碎机") == "1" ? "Red" : "url(#_130859336-4_2_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_锤式破碎机5", commonDAO.GetSignalDataValue(machineCode, "锤式破碎机") == "1" ? "Red" : "url(#_164347592_2_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_锤式破碎机6", commonDAO.GetSignalDataValue(machineCode, "锤式破碎机") == "1" ? "Red" : "url(#_164343680_2_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_锤式破碎机7", commonDAO.GetSignalDataValue(machineCode, "锤式破碎机") == "1" ? "Red" : "url(#_164356088_2_)", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_缩分皮带", commonDAO.GetSignalDataValue(machineCode, "缩分皮带") == "1" ? "Red" : "#808080", eHtmlDataItemType.svg_color));
datas.Add(new HtmlDataItem("机械采样机_弃料斗", commonDAO.GetSignalDataValue(machineCode, "弃料斗") == "1" ? "Red" : "url(#_164344952-8_1_)", eHtmlDataItemType.svg_color));
string carNumber = commonDAO.GetSignalDataValue(machineCode, "车牌号");
if (string.IsNullOrEmpty(carNumber))
{
datas.Add(new HtmlDataItem("Car1", "false", eHtmlDataItemType.svg_visible));
this.LastCarNumber = string.Empty;
}
else
{
if (this.LastCarNumber != carNumber)
{
CmcsAutotruck autotruck = CommonDAO.GetInstance().GetAutotruckByCarNumber(carNumber);
if (autotruck != null)
{
if (PreviewCarCarriage(autotruck))
{
datas.Add(new HtmlDataItem("Car1", "true", eHtmlDataItemType.svg_visible));
}
else
{
datas.Add(new HtmlDataItem("Car1", "false", eHtmlDataItemType.svg_visible));
}
}
else
{
datas.Add(new HtmlDataItem("Car1", "false", eHtmlDataItemType.svg_visible));
}
this.LastCarNumber = carNumber;
}
}
// 集样罐
List <InfEquInfSampleBarrel> barrels1 = MonitorDAO.GetInstance().GetEquInfSampleBarrels(machineCode);
datas.Add(new HtmlDataItem("采样机1_集样罐", Newtonsoft.Json.JsonConvert.SerializeObject(barrels1.Select(a => new { BarrelNumber = a.BarrelNumber, IsCurrent = a.IsCurrent, BarrelStatus = a.BarrelStatus, SampleCount = a.SampleCount })), eHtmlDataItemType.json_data));
#endregion
// 发送到页面
cefWebBrowser.Browser.GetMainFrame().ExecuteJavaScript("requestData(" + Newtonsoft.Json.JsonConvert.SerializeObject(datas) + ");", "", 0);
}
private void FrmCarSampler_Load(object sender, EventArgs e)
{
this.Text = "全自动制样机接口业务";
equDber = new SqlServerDapperDber(CommonDAO.GetInstance().GetCommonAppletConfigString("汽车机械采样机接口连接字符串"));
Bind_SAMPLE_INTERFACE_DATA();
}
/// <summary>
/// 请求数据
/// </summary>
void RequestData()
{
CommonDAO commonDAO = CommonDAO.GetInstance();
MonitorDAO monitorDAO = MonitorDAO.GetInstance();
string value = string.Empty, machineCode = string.Empty, machineCode2 = string.Empty;
List <HtmlDataItem> datas = new List <HtmlDataItem>();
List <InfEquInfHitch> equInfHitchs = new List <InfEquInfHitch>();
#region 翻车机
datas.Clear();
#region 入厂
machineCode = GlobalVars.MachineCode_QC_Queue_1;
datas.Add(new HtmlDataItem("Infactory_State1", commonDAO.GetSignalDataValue(machineCode, "系统"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Infactory_State2", commonDAO.GetSignalDataValue(machineCode, "IO控制器_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Infactory_State3", commonDAO.GetSignalDataValue(machineCode, "LED屏1_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Infactory_State4", commonDAO.GetSignalDataValue(machineCode, "LED屏2_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Infactory_State5", commonDAO.GetSignalDataValue(machineCode, "抓拍相机_连接状态"), eHtmlDataItemType.json_data));
#endregion
#region 采样
machineCode = GlobalVars.MachineCode_QC_JxSampler_1;
datas.Add(new HtmlDataItem("Sample1_State1", commonDAO.GetSignalDataValue(machineCode, "系统"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample1_State2", commonDAO.GetSignalDataValue(machineCode, "IO控制器_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample1_State3", commonDAO.GetSignalDataValue(machineCode, "LED屏1_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample1_State4", commonDAO.GetSignalDataValue(machineCode, "LED屏2_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample1_State5", commonDAO.GetSignalDataValue(machineCode, "抓拍相机_连接状态"), eHtmlDataItemType.json_data));
machineCode = GlobalVars.MachineCode_QC_JxSampler_2;
datas.Add(new HtmlDataItem("Sample2_State1", commonDAO.GetSignalDataValue(machineCode, "系统"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample2_State2", commonDAO.GetSignalDataValue(machineCode, "IO控制器_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample2_State3", commonDAO.GetSignalDataValue(machineCode, "LED屏1_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample2_State4", commonDAO.GetSignalDataValue(machineCode, "LED屏2_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample2_State5", commonDAO.GetSignalDataValue(machineCode, "抓拍相机_连接状态"), eHtmlDataItemType.json_data));
machineCode = GlobalVars.MachineCode_QC_JxSampler_3;
datas.Add(new HtmlDataItem("Sample3_State1", commonDAO.GetSignalDataValue(machineCode, "系统"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample3_State2", commonDAO.GetSignalDataValue(machineCode, "IO控制器_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample3_State3", commonDAO.GetSignalDataValue(machineCode, "LED屏1_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample3_State4", commonDAO.GetSignalDataValue(machineCode, "LED屏2_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample3_State5", commonDAO.GetSignalDataValue(machineCode, "抓拍相机_连接状态"), eHtmlDataItemType.json_data));
machineCode = GlobalVars.MachineCode_QC_JxSampler_4;
datas.Add(new HtmlDataItem("Sample4_State1", commonDAO.GetSignalDataValue(machineCode, "系统"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample4_State2", commonDAO.GetSignalDataValue(machineCode, "IO控制器_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample4_State3", commonDAO.GetSignalDataValue(machineCode, "LED屏1_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample4_State4", commonDAO.GetSignalDataValue(machineCode, "LED屏2_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample4_State5", commonDAO.GetSignalDataValue(machineCode, "抓拍相机_连接状态"), eHtmlDataItemType.json_data));
machineCode = GlobalVars.MachineCode_QC_JxSampler_5;
datas.Add(new HtmlDataItem("Sample5_State1", commonDAO.GetSignalDataValue(machineCode, "系统"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample5_State2", commonDAO.GetSignalDataValue(machineCode, "IO控制器_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample5_State3", commonDAO.GetSignalDataValue(machineCode, "LED屏1_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample5_State4", commonDAO.GetSignalDataValue(machineCode, "LED屏2_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample5_State5", commonDAO.GetSignalDataValue(machineCode, "抓拍相机_连接状态"), eHtmlDataItemType.json_data));
machineCode = GlobalVars.MachineCode_QC_JxSampler_6;
datas.Add(new HtmlDataItem("Sample6_State1", commonDAO.GetSignalDataValue(machineCode, "系统"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample6_State2", commonDAO.GetSignalDataValue(machineCode, "IO控制器_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample6_State3", commonDAO.GetSignalDataValue(machineCode, "LED屏1_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample6_State4", commonDAO.GetSignalDataValue(machineCode, "LED屏2_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Sample6_State5", commonDAO.GetSignalDataValue(machineCode, "抓拍相机_连接状态"), eHtmlDataItemType.json_data));
#endregion
#region 汽车衡
machineCode = GlobalVars.MachineCode_QC_Weighter_1;
datas.Add(new HtmlDataItem("Weighter1_State1", commonDAO.GetSignalDataValue(machineCode, "系统"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter1_State2", commonDAO.GetSignalDataValue(machineCode, "IO控制器_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter1_State3", commonDAO.GetSignalDataValue(machineCode, "LED屏1_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter1_State4", commonDAO.GetSignalDataValue(machineCode, "LED屏2_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter1_State5", commonDAO.GetSignalDataValue(machineCode, "抓拍相机_连接状态"), eHtmlDataItemType.json_data));
machineCode = GlobalVars.MachineCode_QC_Weighter_2;
datas.Add(new HtmlDataItem("Weighter2_State1", commonDAO.GetSignalDataValue(machineCode, "系统"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter2_State2", commonDAO.GetSignalDataValue(machineCode, "IO控制器_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter2_State3", commonDAO.GetSignalDataValue(machineCode, "LED屏1_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter2_State4", commonDAO.GetSignalDataValue(machineCode, "LED屏2_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter2_State5", commonDAO.GetSignalDataValue(machineCode, "抓拍相机_连接状态"), eHtmlDataItemType.json_data));
machineCode = GlobalVars.MachineCode_QC_Weighter_3;
datas.Add(new HtmlDataItem("Weighter3_State1", commonDAO.GetSignalDataValue(machineCode, "系统"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter3_State2", commonDAO.GetSignalDataValue(machineCode, "IO控制器_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter3_State3", commonDAO.GetSignalDataValue(machineCode, "LED屏1_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter3_State4", commonDAO.GetSignalDataValue(machineCode, "LED屏2_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter3_State5", commonDAO.GetSignalDataValue(machineCode, "抓拍相机_连接状态"), eHtmlDataItemType.json_data));
machineCode = GlobalVars.MachineCode_QC_Weighter_4;
datas.Add(new HtmlDataItem("Weighter4_State1", commonDAO.GetSignalDataValue(machineCode, "系统"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter4_State2", commonDAO.GetSignalDataValue(machineCode, "IO控制器_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter4_State3", commonDAO.GetSignalDataValue(machineCode, "LED屏1_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter4_State4", commonDAO.GetSignalDataValue(machineCode, "LED屏2_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter4_State5", commonDAO.GetSignalDataValue(machineCode, "抓拍相机_连接状态"), eHtmlDataItemType.json_data));
machineCode = GlobalVars.MachineCode_QC_Weighter_5;
datas.Add(new HtmlDataItem("Weighter5_State1", commonDAO.GetSignalDataValue(machineCode, "系统"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter5_State2", commonDAO.GetSignalDataValue(machineCode, "IO控制器_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter5_State3", commonDAO.GetSignalDataValue(machineCode, "LED屏1_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter5_State4", commonDAO.GetSignalDataValue(machineCode, "LED屏2_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter5_State5", commonDAO.GetSignalDataValue(machineCode, "抓拍相机_连接状态"), eHtmlDataItemType.json_data));
machineCode = GlobalVars.MachineCode_QC_Weighter_6;
datas.Add(new HtmlDataItem("Weighter6_State1", commonDAO.GetSignalDataValue(machineCode, "系统"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter6_State2", commonDAO.GetSignalDataValue(machineCode, "IO控制器_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter6_State3", commonDAO.GetSignalDataValue(machineCode, "LED屏1_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter6_State4", commonDAO.GetSignalDataValue(machineCode, "LED屏2_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter6_State5", commonDAO.GetSignalDataValue(machineCode, "抓拍相机_连接状态"), eHtmlDataItemType.json_data));
machineCode = GlobalVars.MachineCode_QC_Weighter_7;
datas.Add(new HtmlDataItem("Weighter7_State1", commonDAO.GetSignalDataValue(machineCode, "系统"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter7_State2", commonDAO.GetSignalDataValue(machineCode, "IO控制器_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter7_State3", commonDAO.GetSignalDataValue(machineCode, "LED屏1_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter7_State4", commonDAO.GetSignalDataValue(machineCode, "LED屏2_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter7_State5", commonDAO.GetSignalDataValue(machineCode, "抓拍相机_连接状态"), eHtmlDataItemType.json_data));
machineCode = GlobalVars.MachineCode_QC_Weighter_8;
datas.Add(new HtmlDataItem("Weighter8_State1", commonDAO.GetSignalDataValue(machineCode, "系统"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter8_State2", commonDAO.GetSignalDataValue(machineCode, "IO控制器_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter8_State3", commonDAO.GetSignalDataValue(machineCode, "LED屏1_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter8_State4", commonDAO.GetSignalDataValue(machineCode, "LED屏2_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Weighter8_State5", commonDAO.GetSignalDataValue(machineCode, "抓拍相机_连接状态"), eHtmlDataItemType.json_data));
#endregion
#region 出厂
machineCode = GlobalVars.MachineCode_QC_Out_1;
datas.Add(new HtmlDataItem("Outfactory_State1", commonDAO.GetSignalDataValue(machineCode, "系统"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Outfactory_State2", commonDAO.GetSignalDataValue(machineCode, "IO控制器_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Outfactory_State3", commonDAO.GetSignalDataValue(machineCode, "LED屏1_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Outfactory_State4", commonDAO.GetSignalDataValue(machineCode, "LED屏2_连接状态"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("Outfactory_State5", commonDAO.GetSignalDataValue(machineCode, "抓拍相机_连接状态"), eHtmlDataItemType.json_data));
#endregion
// 发送到页面
cefWebBrowser.Browser.GetMainFrame().ExecuteJavaScript("requestData(" + Newtonsoft.Json.JsonConvert.SerializeObject(datas) + ");", "", 0);
#endregion
}
/// <summary>
/// 执行所有任务
/// </summary>
void ExecuteAllTask()
{
#region #3汽车机械采样机
EquCarJXSamplerDAO carJXSamplerDAO3 = new EquCarJXSamplerDAO(GlobalVars.MachineCode_QCJXCYJ_3, new DapperDber.Dbs.SqlServerDb.SqlServerDapperDber(CommonDAO.GetInstance().GetCommonAppletConfigString("#3汽车机械采样机接口连接字符串")));
taskSimpleScheduler.StartNewTask("#3汽车机械采样机-快速同步", () =>
{
carJXSamplerDAO3.SyncBarrel(this.rTxtOutputer.Output);
carJXSamplerDAO3.SyncSampleCmd(this.rTxtOutputer.Output);
//carJXSamplerDAO3.SyncJXCYControlUnloadCMD(this.rTxtOutputer.Output);
carJXSamplerDAO3.SyncUnloadResult(this.rTxtOutputer.Output);
carJXSamplerDAO3.SyncQCJXCYJError(this.rTxtOutputer.Output);
carJXSamplerDAO3.SyncSignal(this.rTxtOutputer.Output);
}, 2000, OutputError);
this.taskSimpleScheduler.StartNewTask("#3汽车机械采样机-上位机心跳", () =>
{
carJXSamplerDAO3.SyncHeartbeatSignal();
}, 30000, OutputError);
#endregion
#region #4汽车机械采样机
EquCarJXSamplerDAO carJXSamplerDAO4 = new EquCarJXSamplerDAO(GlobalVars.MachineCode_QCJXCYJ_4, new DapperDber.Dbs.SqlServerDb.SqlServerDapperDber(CommonDAO.GetInstance().GetCommonAppletConfigString("#4汽车机械采样机接口连接字符串")));
taskSimpleScheduler.StartNewTask("#4汽车机械采样机-快速同步", () =>
{
carJXSamplerDAO4.SyncBarrel(this.rTxtOutputer.Output);
carJXSamplerDAO4.SyncSampleCmd(this.rTxtOutputer.Output);
//carJXSamplerDAO3.SyncJXCYControlUnloadCMD(this.rTxtOutputer.Output);
carJXSamplerDAO4.SyncUnloadResult(this.rTxtOutputer.Output);
carJXSamplerDAO4.SyncQCJXCYJError(this.rTxtOutputer.Output);
carJXSamplerDAO4.SyncSignal(this.rTxtOutputer.Output);
}, 2000, OutputError);
this.taskSimpleScheduler.StartNewTask("#4汽车机械采样机-上位机心跳", () =>
{
carJXSamplerDAO4.SyncHeartbeatSignal();
}, 30000, OutputError);
#endregion
#region #5汽车机械采样机
EquCarJXSamplerDAO carJXSamplerDAO5 = new EquCarJXSamplerDAO(GlobalVars.MachineCode_QCJXCYJ_5, new DapperDber.Dbs.SqlServerDb.SqlServerDapperDber(CommonDAO.GetInstance().GetCommonAppletConfigString("#5汽车机械采样机接口连接字符串")));
taskSimpleScheduler.StartNewTask("#5汽车机械采样机-快速同步", () =>
{
carJXSamplerDAO5.SyncBarrel(this.rTxtOutputer.Output);
carJXSamplerDAO5.SyncSampleCmd(this.rTxtOutputer.Output);
//carJXSamplerDAO1.SyncJXCYControlUnloadCMD(this.rTxtOutputer.Output);
carJXSamplerDAO5.SyncUnloadResult(this.rTxtOutputer.Output);
carJXSamplerDAO5.SyncQCJXCYJError(this.rTxtOutputer.Output);
carJXSamplerDAO5.SyncSignal(this.rTxtOutputer.Output);
}, 2000, OutputError);
this.taskSimpleScheduler.StartNewTask("#5汽车机械采样机-上位机心跳", () =>
{
carJXSamplerDAO5.SyncHeartbeatSignal();
}, 30000, OutputError);
#endregion
}
/// <summary>
/// 请求数据
/// </summary>
void RequestData()
{
CommonDAO commonDAO = CommonDAO.GetInstance();
MonitorDAO monitorDAO = MonitorDAO.GetInstance();
string value = string.Empty, machineCode1 = string.Empty, machineCode2 = string.Empty;
List <HtmlDataItem> datas = new List <HtmlDataItem>();
List <InfEquInfHitch> equInfHitchs = new List <InfEquInfHitch>();
#region 翻车机
datas.Clear();
machineCode1 = GlobalVars.MachineCode_TrunOver_1;
machineCode2 = GlobalVars.MachineCode_TrunOver_2;
datas.Add(new HtmlDataItem("翻车机1_正翻", commonDAO.GetSignalDataValue(machineCode1, "正翻"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("翻车机1_反翻", commonDAO.GetSignalDataValue(machineCode1, "反翻"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("翻车机1_重调原位", commonDAO.GetSignalDataValue(machineCode1, "重调原位"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("翻车机1_正翻效果", commonDAO.GetSignalDataValue(machineCode1, "正翻"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("翻车机1_反翻效果", commonDAO.GetSignalDataValue(machineCode1, "反翻"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("翻车机1_转盘信号", commonDAO.GetSignalDataValue(machineCode1, "转盘信号"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("翻车机1_当前翻车车号", commonDAO.GetSignalDataValue(machineCode1, eSignalDataName.当前车号.ToString()), eHtmlDataItemType.key_value));
datas.Add(new HtmlDataItem("翻车机1_待翻车数", commonDAO.GetSignalDataValue(machineCode1, "待翻车数"), eHtmlDataItemType.key_value));
datas.Add(new HtmlDataItem("翻车机1_已翻车数", commonDAO.GetSignalDataValue(machineCode1, "已翻车数"), eHtmlDataItemType.key_value));
string trainWeightRecord1 = commonDAO.GetSignalDataValue(machineCode1, "当前车Id");
// 此处 当前车Id 的值为火车入厂记录Id
if (!string.IsNullOrEmpty(trainWeightRecord1))
{
DataTable dtl = monitorDAO.GetInFactoryBatchInfoByTrainWeightRecordId(trainWeightRecord1);
if (dtl.Rows.Count > 0)
{
datas.Add(new HtmlDataItem("翻车机1_供应商", dtl.Rows[0]["SupplierName"].ToString(), eHtmlDataItemType.key_value));
datas.Add(new HtmlDataItem("翻车机1_发站", dtl.Rows[0]["StationName"].ToString(), eHtmlDataItemType.key_value));
datas.Add(new HtmlDataItem("翻车机1_矿点", dtl.Rows[0]["MineName"].ToString(), eHtmlDataItemType.key_value));
datas.Add(new HtmlDataItem("翻车机1_煤种", dtl.Rows[0]["FuelName"].ToString(), eHtmlDataItemType.key_value));
}
}
datas.Add(new HtmlDataItem("翻车机2_正翻", commonDAO.GetSignalDataValue(machineCode2, "正翻"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("翻车机2_反翻", commonDAO.GetSignalDataValue(machineCode2, "反翻"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("翻车机2_重调原位", commonDAO.GetSignalDataValue(machineCode2, "重调原位"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("翻车机2_正翻效果", commonDAO.GetSignalDataValue(machineCode1, "正翻"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("翻车机2_反翻效果", commonDAO.GetSignalDataValue(machineCode1, "反翻"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("翻车机2_转盘信号", commonDAO.GetSignalDataValue(machineCode2, "转盘信号"), eHtmlDataItemType.json_data));
datas.Add(new HtmlDataItem("翻车机2_当前翻车车号", commonDAO.GetSignalDataValue(machineCode2, eSignalDataName.当前车号.ToString()), eHtmlDataItemType.key_value));
datas.Add(new HtmlDataItem("翻车机2_待翻车数", commonDAO.GetSignalDataValue(machineCode2, "待翻车数"), eHtmlDataItemType.key_value));
datas.Add(new HtmlDataItem("翻车机2_已翻车数", commonDAO.GetSignalDataValue(machineCode2, "已翻车数"), eHtmlDataItemType.key_value));
string trainWeightRecord2 = commonDAO.GetSignalDataValue(machineCode2, "当前车Id");
// 此处 当前车Id 的值为火车入厂记录Id
if (!string.IsNullOrEmpty(trainWeightRecord2))
{
DataTable dtl = monitorDAO.GetInFactoryBatchInfoByTrainWeightRecordId(trainWeightRecord2);
if (dtl.Rows.Count > 0)
{
datas.Add(new HtmlDataItem("翻车机2_供应商", dtl.Rows[0]["SupplierName"].ToString(), eHtmlDataItemType.key_value));
datas.Add(new HtmlDataItem("翻车机2_发站", dtl.Rows[0]["StationName"].ToString(), eHtmlDataItemType.key_value));
datas.Add(new HtmlDataItem("翻车机2_矿点", dtl.Rows[0]["MineName"].ToString(), eHtmlDataItemType.key_value));
datas.Add(new HtmlDataItem("翻车机2_煤种", dtl.Rows[0]["FuelName"].ToString(), eHtmlDataItemType.key_value));
}
}
// 发送到页面
cefWebBrowser.Browser.GetMainFrame().ExecuteJavaScript("requestData(" + Newtonsoft.Json.JsonConvert.SerializeObject(datas) + ");", "", 0);
#endregion
}
private void superGridControl1_CellMouseDown(object sender, DevComponents.DotNetBar.SuperGrid.GridCellMouseEventArgs e)
{
CmcsBuyFuelTransport entity = Dbers.GetInstance().SelfDber.Get <CmcsBuyFuelTransport>(superGridControl1.PrimaryGrid.GetCell(e.GridCell.GridRow.Index, superGridControl1.PrimaryGrid.Columns["clmId"].ColumnIndex).Value.ToString());
switch (superGridControl1.PrimaryGrid.Columns[e.GridCell.ColumnIndex].Name)
{
case "clmShow":
FrmBuyFuelTransport_Oper frmShow = new FrmBuyFuelTransport_Oper(entity.Id, false);
if (frmShow.ShowDialog() == DialogResult.OK)
{
BindData();
}
break;
case "clmEdit":
FrmBuyFuelTransport_Oper frmEdit = new FrmBuyFuelTransport_Oper(entity.Id, true);
if (frmEdit.ShowDialog() == DialogResult.OK)
{
BindData();
}
break;
case "clmDelete":
if (entity.GrossWeight > 0 || entity.TareWeight > 0)
{
MessageBoxEx.Show("该记录已有重量，禁止删除！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return;
}
if (MessageBoxEx.Show("确定要删除该记录？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
CommonDAO.GetInstance().SaveAppletLog(eAppletLogLevel.Warn, "删除入场煤运输记录：", string.Format("车号:{0};毛重:{1};皮重:{2};矿点:{3};操作人:{4}", entity.CarNumber, entity.GrossWeight, entity.TareWeight, entity.MineName, SelfVars.LoginUser.UserName));
if (QueuerDAO.GetInstance().DeleteTransport(entity.Id))
{
CommonDAO.GetInstance().InsertWaitForHandleEvent("汽车智能化_删除入厂煤运输记录", entity.Id);
}
}
catch (Exception)
{
MessageBoxEx.Show("该记录正在使用中，禁止删除！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
BindData();
}
break;
case "clmPic":
if (Dbers.GetInstance().SelfDber.Entities <CmcsTransportPicture>(String.Format(" where TransportId='{0}'", entity.Id)).Count > 0)
{
FrmTransportPicture frmPic = new FrmTransportPicture(entity.Id, entity.CarNumber);
if (frmPic.ShowDialog() == DialogResult.OK)
{
BindData();
}
}
else
{
MessageBoxEx.Show("暂无抓拍图片！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
break;
}
}
/// <summary>
/// 绑定集样罐信息
/// </summary>
/// <param name="superGridControl"></param>
/// <param name="machineCode">设备编码</param>
private void BindBeltSampleBarrel(SuperGridControl superGridControl, string machineCode)
{
IList <InfEquInfSampleBarrel> list = CommonDAO.GetInstance().GetEquInfSampleBarrels(machineCode);
superGridControl.PrimaryGrid.DataSource = list;
}
/// <summary>
/// 同步轨道衡过衡数据，并在火车出厂后将皮重回写
/// </summary>
/// <param name="output"></param>
/// <returns></returns>
public int SyncLwCarsInfo(Action <string, eOutputType> output)
{
int res = 0;
DataTable result = getData(DcDbers.GetInstance().WeightBridger_Dber1);
foreach (DataRow row in result.Rows)
{
string pKId = getDateTime(row["时间"].ToString()) + "-" + row["车号"].ToString(); //时间+车号组装成唯一标识
CmcsTrainWeightRecord trainWeightRecord = Dbers.GetInstance().SelfDber.Entity <CmcsTrainWeightRecord>("where PKID=:PKID", new { PKID = pKId });
if (trainWeightRecord == null)
{
res += Dbers.GetInstance().SelfDber.Insert <CmcsTrainWeightRecord>(
new CmcsTrainWeightRecord
{
PKID = pKId,
OrderNumber = Convert.ToInt32(row["序号"].ToString()),
SupplierName = row["供煤单位"].ToString(),
MineName = row["矿点"].ToString(),
FuelKind = row["煤种"].ToString(),
StationName = row["发站"].ToString(),
MachineCode = row["设备编号"].ToString(),
TrainNumber = row["车号"].ToString(),
TrainType = row["车型"].ToString(),
TicketWeight = Convert.ToDecimal(row["票重"]),
GrossWeight = Convert.ToDecimal(row["毛重"]),
SkinWeight = Convert.ToDecimal(row["皮重"]),
StandardWeight = Convert.ToDecimal(row["净重"]),
Speed = Convert.ToDecimal(row["车速"]),
MesureMan = row["过衡人"].ToString(),
ArriveTime = Convert.ToDateTime(getDateTime(row["入厂时间"].ToString())),
GrossTime = Convert.ToDateTime(getDateTime(row["毛重时间"].ToString())),
SkinTime = Convert.ToDateTime(getDateTime(row["皮重时间"].ToString())),
LeaveTime = Convert.ToDateTime(getDateTime(row["出厂时间"].ToString())),
UnloadTime = Convert.ToDateTime(getDateTime(row["卸车时间"].ToString())),
TrainTipperMachineCode = row["翻车机编号"].ToString(),
IsTurnover = row["翻车标识"].ToString(),
DataFlag = 0
}
);
}
else
{
trainWeightRecord.OrderNumber = Convert.ToInt32(row["序号"].ToString());
if (!String.IsNullOrEmpty(row["车号"].ToString()))
{
trainWeightRecord.TrainNumber = row["车号"].ToString();
}
trainWeightRecord.SupplierName = row["供煤单位"].ToString();
trainWeightRecord.MineName = row["矿点"].ToString();
trainWeightRecord.FuelKind = row["煤种"].ToString();
trainWeightRecord.StationName = row["发站"].ToString();
trainWeightRecord.MachineCode = row["设备编号"].ToString();
trainWeightRecord.TrainType = row["车型"].ToString();
trainWeightRecord.TicketWeight = Convert.ToDecimal(row["票重"]);
trainWeightRecord.GrossWeight = Convert.ToDecimal(row["毛重"]);
trainWeightRecord.SkinWeight = Convert.ToDecimal(row["皮重"]);
trainWeightRecord.StandardWeight = Convert.ToDecimal(row["净重"]);
trainWeightRecord.Speed = Convert.ToDecimal(row["车速"]);
trainWeightRecord.MesureMan = row["过衡人"].ToString();
trainWeightRecord.ArriveTime = Convert.ToDateTime(getDateTime(row["入厂时间"].ToString()));
trainWeightRecord.GrossTime = Convert.ToDateTime(getDateTime(row["毛重时间"].ToString()));
trainWeightRecord.SkinTime = Convert.ToDateTime(getDateTime(row["皮重时间"].ToString()));
trainWeightRecord.LeaveTime = Convert.ToDateTime(getDateTime(row["出厂时间"].ToString()));
trainWeightRecord.UnloadTime = Convert.ToDateTime(getDateTime(row["卸车时间"].ToString()));
trainWeightRecord.TrainTipperMachineCode = row["翻车机编号"].ToString();
trainWeightRecord.IsTurnover = row["翻车标识"].ToString();
trainWeightRecord.DataFlag = 0;
res += Dbers.GetInstance().SelfDber.Update <CmcsTrainWeightRecord>(trainWeightRecord);
}
if (res > 0 && String.IsNullOrEmpty(row["车号"].ToString()))
{
CommonDAO.GetInstance().SaveSysMessage(eMessageType.轨道衡.ToString(), "车号为空请补录!", eMessageType.轨道衡.ToString());
}
}
output(string.Format("同步轨道衡数据 {0} 条（第三方 > 集中管控）", res), eOutputType.Normal);
return(res);
}
/// <summary>
/// 同步翻车衡过衡数据
/// </summary>
/// <param name="output"></param>
/// <returns></returns>
public int SyncLwCarsInfo(Action <string, eOutputType> output)
{
int res = 0;
IList <CarInfoMutual> carInfos = DcDbers.GetInstance().TurnCarWeighterMutualDber.Entities <CarInfoMutual>(" where DataFlag=1 and SuttleWeight>0 and CreateDate>=to_date('" + DateTime.Now.Date.AddDays(-2) + "','yyyy/mm/dd HH24:MI:SS')");
foreach (var item in carInfos)
{
//同步到批次明细
CmcsTransport transport = Dbers.GetInstance().SelfDber.Entity <CmcsTransport>(" where TransportNo=:TransportNo and InfactoryTime>=:InfactoryTime ", new { TransportNo = item.CarNumber, InfactoryTime = DateTime.Now.Date.AddDays(-2) });
if (transport != null && !string.IsNullOrEmpty(transport.InFactoryBatchId))
{
if (item.GrossWeight != 0 && transport.GrossQty == 0)
{
transport.GrossQty = (decimal)item.GrossWeight;
}
if (item.TareWeight != 0 && transport.SkinQty == 0)
{
transport.SkinQty = (decimal)item.TareWeight;
}
if (item.SuttleWeight != 0 && transport.SuttleQty == 0)
{
transport.SuttleQty = (decimal)item.SuttleWeight;
transport.MarginQty = (decimal)(item.SuttleWeight - item.TicketWeight);
}
transport.MeasureMan = "自动";
transport.IsDeleted = item.CancelSign;
transport.ArriveDate = item.WeightDate;
transport.TareDate = item.WeightDate.AddMinutes(3).AddSeconds(1.2);
transport.TrackCode = item.TurnCarNumber == "#1" ? "#4" : "#2";
if (item.TurnCarNumber == "#1")
{
CommonDAO.GetInstance().SetSignalDataValue(GlobalVars.MachineCode_TrunOver_1, eSignalDataName.当前车号.ToString(), string.Empty);
}
else
{
CommonDAO.GetInstance().SetSignalDataValue(GlobalVars.MachineCode_TrunOver_2, eSignalDataName.当前车号.ToString(), string.Empty);
}
res += Dbers.GetInstance().SelfDber.Update(transport);
//同步到轨道衡数据表
CmcsTrainWeightRecord trainRecord = Dbers.GetInstance().SelfDber.Entity <CmcsTrainWeightRecord>("where TrainNumber=:TrainNumber and ArriveTime>=:ArriveTime", new { TrainNumber = item.CarNumber, ArriveTime = DateTime.Now.Date.AddDays(-2) });
CmcsRCSampling sampling = Dbers.GetInstance().SelfDber.Entity <CmcsRCSampling>("where InFactoryBatchId=:InFactoryBatchId order by SamplingDate", new { InFactoryBatchId = transport.InFactoryBatchId });
if (trainRecord != null)
{
trainRecord.TrainTipperMachineCode = item.TurnCarNumber;
trainRecord.FuelKind = transport.TheBatch.FuelKindName;
trainRecord.MineName = sampling != null ? sampling.SampleCode : "";
trainRecord.SupplierName = "";
trainRecord.StationName = transport.TheBatch.TheStation.Name;
trainRecord.SerialNumber = item.RecordId;
trainRecord.TicketWeight = (decimal)item.TicketWeight;
trainRecord.GrossTime = item.WeightDate;
trainRecord.GrossWeight = (decimal)item.GrossWeight;
trainRecord.SkinTime = item.WeightDate.AddMinutes(3).AddSeconds(1.2);
trainRecord.SkinWeight = (decimal)item.TareWeight;
trainRecord.StandardWeight = (decimal)item.SuttleWeight;
trainRecord.MarginWeight = trainRecord.StandardWeight - trainRecord.TicketWeight - trainRecord.DeductWeight;
trainRecord.MesureMan = "自动";
trainRecord.TrainTipperMachineCode = item.TurnCarNumber;
trainRecord.MachineCode = item.TurnCarNumber == "#1" ? "#4" : "#2";
trainRecord.IsTurnover = "已翻";
trainRecord.UnloadTime = item.WeightDate;
Dbers.GetInstance().SelfDber.Update(trainRecord);
}
}
item.DataFlag = 2;
DcDbers.GetInstance().TurnCarWeighterMutualDber.Update(item);
}
output(string.Format("同步翻车衡数据 {0} 条（第三方 > 集中管控）", res), eOutputType.Normal);
return(res);
}
private void superGridControl1_CellMouseDown(object sender, DevComponents.DotNetBar.SuperGrid.GridCellMouseEventArgs e)
{
CmcsBuyFuelTransport entity = Dbers.GetInstance().SelfDber.Get <CmcsBuyFuelTransport>(superGridControl1.PrimaryGrid.GetCell(e.GridCell.GridRow.Index, superGridControl1.PrimaryGrid.Columns["clmId"].ColumnIndex).Value.ToString());
if (entity == null || entity.SerialNumber == "合计")
{
return;
}
switch (superGridControl1.PrimaryGrid.Columns[e.GridCell.ColumnIndex].Name)
{
case "clmPrint":
if (entity.SuttleWeight <= 0)
{
MessageBoxEx.Show("净重异常，禁止打印", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
return;
}
if (entity.ProfitWeight > 0 && entity.ProfitWeight >= Convert.ToDecimal(CommonDAO.GetInstance().GetAppletConfigDouble("盈异常吨数")))
{
MessageBoxEx.Show("盈吨异常", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
if (entity.ProfitWeight < 0 && entity.ProfitWeight >= Convert.ToDecimal(CommonDAO.GetInstance().GetAppletConfigDouble("亏异常吨数")))
{
MessageBoxEx.Show("亏吨异常", "提示", MessageBoxButtons.OK, MessageBoxIcon.Asterisk);
}
FrmPrint_Oper frmPrint = new FrmPrint_Oper(entity.Id, false);
if (frmPrint.ShowDialog() == DialogResult.OK)
{
BindData();
}
break;
case "clmShow":
FrmBuyFuelTransport_Oper frmShow = new FrmBuyFuelTransport_Oper(entity.Id, false);
if (frmShow.ShowDialog() == DialogResult.OK)
{
BindData();
}
break;
case "clmEdit":
FrmBuyFuelTransport_Oper frmEdit = new FrmBuyFuelTransport_Oper(entity.Id, true);
if (frmEdit.ShowDialog() == DialogResult.OK)
{
BindData();
}
break;
case "clmDelete":
// 查询正在使用该记录的车数
if (MessageBoxEx.Show("确定要删除该记录？", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
try
{
CommonDAO.GetInstance().SaveAppletLog(eAppletLogLevel.Warn, "删除入厂煤运输记录", string.Format("车号:{0};毛重:{1};皮重:{2};矿点:{3};操作人:{4}", entity.CarNumber, entity.GrossWeight, entity.TareWeight, entity.MineName, SelfVars.LoginUser.UserName));
CommonDAO.GetInstance().RemoveDeduct(entity.Id);
Dbers.GetInstance().SelfDber.Delete <CmcsBuyFuelTransport>(entity.Id);
CommonDAO.GetInstance().RemoveUnFinishTransport(entity.Id);
}
catch (Exception)
{
MessageBoxEx.Show("该记录正在使用中，禁止删除！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
BindData();
}
break;
case "clmPic":
if (Dbers.GetInstance().SelfDber.Entities <CmcsTransportPicture>(String.Format(" where TransportId='{0}'", entity.Id)).Count > 0)
{
FrmTransportPicture frmPic = new FrmTransportPicture(entity.Id, entity.CarNumber);
if (frmPic.ShowDialog() == DialogResult.OK)
{
BindData();
}
}
else
{
MessageBoxEx.Show("暂无抓拍图片！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
break;
}
}
protected override bool Execute(string name, CefV8Value obj, CefV8Value[] arguments, out CefV8Value returnValue, out string exception)
{
exception = null;
returnValue = null;
string paramSampler = arguments[0].GetStringValue();
switch (name)
{
case "ChangeSelected":
CefProcessMessage cefMsg = CefProcessMessage.Create("ChangeSelected");
cefMsg.Arguments.SetSize(0);
cefMsg.Arguments.SetString(0, paramSampler);
CefV8Context.GetCurrentContext().GetBrowser().SendProcessMessage(CefProcessId.Browser, cefMsg);
break;
case "ShowYGDetail":
int overday = CommonDAO.GetInstance().GetCommonAppletConfigInt32("存样柜超期天数");
IList <RowResult> rowResult = new List <RowResult>();
IList <InfAutoCupBoard> cellList = CommonDAO.GetInstance().SelfDber.Entities <InfAutoCupBoard>(string.Format("where CupBoardCode like '%{0}%' and CupBoardType='{1}' and ParentPKID is not null", paramSampler, arguments[1].GetStringValue()));
if (cellList != null && cellList.Count > 0)
{
int maxRow = cellList.OrderByDescending(a => a.RowNumber).First().RowNumber;
int maxCell = cellList.OrderByDescending(a => a.CellNumber).First().CellNumber;
for (int i = 1; i <= maxRow; i++)
{
RowResult rowEntity = new RowResult();
rowEntity.RowName = String.Format("第 {0} 层", i);
rowEntity.CellList = new List <CellResult>();
for (int j = 1; j <= maxCell; j++)
{
CellResult cellEntity = new CellResult();
InfAutoCupBoard sampleCell = cellList.Where(a => a.RowNumber == i && a.CellNumber == j).FirstOrDefault();
if (sampleCell == null)
{
cellEntity.CellFlag = -1;
}
else
{
cellEntity.CellNumber = sampleCell.CupBoardDes.Replace("层", "").Replace("格", "").Remove(0, 2);
//柜门标识：-1没这一格，0空柜，1已存放，2超期样，3停用
if (sampleCell.IsValid == "0")
{
cellEntity.CellFlag = 3;
}
else if (sampleCell.State == 1 && sampleCell.SaveTime < DateTime.Now.AddDays(-overday))
{
cellEntity.CellFlag = 2;
}
else if (sampleCell.State == 1)
{
cellEntity.CellFlag = 1;
}
else
{
cellEntity.CellFlag = 0;
}
}
rowEntity.CellList.Add(cellEntity);
}
rowResult.Add(rowEntity);
}
}
returnValue = CefV8Value.CreateString(Newtonsoft.Json.JsonConvert.SerializeObject(rowResult));
break;
default:
returnValue = null;
break;
}
return(true);
}
void Search(string input)
{
List <CmcsSupplier> list = CommonDAO.GetInstance().GetSupplierByNameOrChs(input.Trim(), sqlWhere);
superGridControl1.PrimaryGrid.DataSource = list;
}
/// <summary>
/// 执行所有任务
/// </summary>
void ExecuteAllTask()
{
SqlServerDapperDber BeltSampler_Dber_Out = null;
EquBeltSamplerDAO beltSamplerDAO_Out = null;
taskSimpleScheduler.StartNewTask("出场皮带采样机快速同步", () =>
{
BeltSampler_Dber_Out = new SqlServerDapperDber(CommonDAO.GetInstance().GetCommonAppletConfigString("出场皮带采样机接口连接字符串"));
beltSamplerDAO_Out = new EquBeltSamplerDAO("出场", BeltSampler_Dber_Out);
if (CommonDAO.GetInstance().TestPing(BeltSampler_Dber_Out.Connection.DataSource))
{
beltSamplerDAO_Out.SyncSignal(this.rTxtOutputer.Output);
beltSamplerDAO_Out.SyncError(this.rTxtOutputer.Output);
beltSamplerDAO_Out.SyncBarrel(this.rTxtOutputer.Output);
beltSamplerDAO_Out.SyncPlan(this.rTxtOutputer.Output);
beltSamplerDAO_Out.SyncUnloadCmd(this.rTxtOutputer.Output);
beltSamplerDAO_Out.SyncCmd(this.rTxtOutputer.Output);
beltSamplerDAO_Out.SyncUnloadResult(this.rTxtOutputer.Output);
}
else
{
rTxtOutputer.Output("出场皮带采样机网络不通");
}
}, 3000, OutputError);
this.taskSimpleScheduler.StartNewTask("出场皮带采样机运行状态-心跳", () =>
{
if (CommonDAO.GetInstance().TestPing(BeltSampler_Dber_Out.Connection.DataSource))
{
beltSamplerDAO_Out.SyncHeartbeatSignal();
}
else
{
rTxtOutputer.Output("出场皮带采样机网络不通");
}
}, 30000, OutputError);
#region 入场
SqlServerDapperDber BeltSampler_Dber_In = null;
EquBeltSamplerDAO beltSamplerDAO_In = null;
taskSimpleScheduler.StartNewTask("入场皮带采样机快速同步", () =>
{
BeltSampler_Dber_In = new SqlServerDapperDber(CommonDAO.GetInstance().GetCommonAppletConfigString("入场皮带采样机接口连接字符串"));
beltSamplerDAO_In = new EquBeltSamplerDAO("入场", BeltSampler_Dber_In);
if (CommonDAO.GetInstance().TestPing(BeltSampler_Dber_In.Connection.DataSource))
{
beltSamplerDAO_In.SyncSignal(this.rTxtOutputer.Output);
beltSamplerDAO_In.SyncError(this.rTxtOutputer.Output);
beltSamplerDAO_In.SyncBarrel(this.rTxtOutputer.Output);
beltSamplerDAO_In.SyncPlan(this.rTxtOutputer.Output);
beltSamplerDAO_In.SyncUnloadCmd(this.rTxtOutputer.Output);
beltSamplerDAO_In.SyncCmd(this.rTxtOutputer.Output);
beltSamplerDAO_In.SyncUnloadResult(this.rTxtOutputer.Output);
}
else
{
rTxtOutputer.Output("入场皮带采样机网络不通");
}
}, 3000, OutputError);
this.taskSimpleScheduler.StartNewTask("入场皮带采样机运行状态-心跳", () =>
{
if (CommonDAO.GetInstance().TestPing(BeltSampler_Dber_In.Connection.DataSource))
{
beltSamplerDAO_In.SyncHeartbeatSignal();
}
else
{
rTxtOutputer.Output("入场皮带采样机网络不通");
}
}, 30000, OutputError);
#endregion
}
/// <summary>
/// 执行所有任务
/// </summary>
void ExecuteAllTask()
{
#region 封装归批机
try
{
taskSimpleScheduler.StartNewTask("矩阵合样归批机-快速同步", () =>
{
EquPackagingBatchDAO batchDAO = new EquPackagingBatchDAO(new DapperDber.Dbs.SqlServerDb.SqlServerDapperDber(CommonDAO.GetInstance().GetCommonAppletConfigString("矩阵合样归批机接口连接字符串")));
if (CommonDAO.GetInstance().TestPing(batchDAO.EquDber.Connection.DataSource))
{
batchDAO.SyncCmd(this.rTxtOutputer.Output);
batchDAO.SyncCoord(this.rTxtOutputer.Output);
batchDAO.SyncError(this.rTxtOutputer.Output);
batchDAO.SyncSignal(this.rTxtOutputer.Output);
}
else
{
this.rTxtOutputer.Output(string.Format("{0}网络不通", batchDAO.MachineCode), eOutputType.Warn);
}
}, 5000, OutputError);
}
catch (Exception ex)
{
OutputError("矩阵合样归批机-快速同步", ex);
}
#endregion
}
public FrmPrintWeb(CmcsBuyFuelTransport buyfueltransport)
{
_BuyFuelTransport = CommonDAO.GetInstance().SelfDber.Get <CmcsBuyFuelTransport>(buyfueltransport.Id);
InitializeComponent();
}
/// <summary>
/// 打印入厂煤磅单
/// </summary>
/// <param name="entity"></param>
public void PrintBuyFuelTransport(CmcsBuyFuelTransport entity)
{
#region 备份
DataTable table = new DataTable();
table.Columns.Add("SerialNumber", typeof(string));
table.Columns.Add("TareTime", typeof(string));
table.Columns.Add("CarNumber", typeof(string));
table.Columns.Add("FuelKindName", typeof(string));
table.Columns.Add("SupplierName", typeof(string));
table.Columns.Add("Remark", typeof(string));
table.Columns.Add("GrossWeight", typeof(string));
table.Columns.Add("TareWeight", typeof(string));
table.Columns.Add("SuttleWeight", typeof(string));
table.Columns.Add("DeductWeight", typeof(string));
table.Columns.Add("CreateUser", typeof(string));
table.Columns.Add("Type", typeof(string));
table.Rows.Add(entity.SerialNumber, entity.TareTime.ToString("yyyy年MM月dd日 HH:mm:ss"), entity.CarNumber, entity.FuelKindName, entity.SupplierName, "华能渭南",
entity.GrossWeight, entity.TareWeight, entity.SuttleWeight, entity.DeductWeight, CommonDAO.GetInstance().GetNameByAccount(entity.CreateUser));
LocalReport report = new LocalReport();
//设置需要打印的报表的文件名称。
report.ReportPath = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "TransportReport.rdlc");
//创建要打印的数据源
ReportDataSource source = new ReportDataSource();
source.Name = "Transport";
source.Value = table;
report.DataSources.Add(source);
////刷新报表中的需要呈现的数据
//report.Refresh();
PrintDocument(source, report);
Dispose();
report.Dispose();
#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);
}