public static int UpdBlasting(Blasting blasting)
{
int result = 0;
try
{
result = DataFactory.UpdateEntity(blasting
, "BlastingSID,BlastingNum,BlastingTotalNum,BlastingEndTime", "MW_Blasting_UPD");
}
catch (Exception ex)
{
result = 0;
}
return(result);
}
//#region 新增抛丸信息
//public static int AddBlastingInfo(int equipmentSID,int groupSID,int materialSID, int blastingNum,int blastingTotalNum, DateTime blastingBeginTime, DateTime blastingEndTime)
//{
// Blasting blasting = new Blasting();
// blasting.EquipmentSID = equipmentSID;
// blasting.GroupSID = groupSID;
// blasting.MaterialSID = materialSID;
// blasting.BlastingNum = blastingNum;
// blasting.BlastingTotalNum = blastingTotalNum;
// blasting.BlastingBeginTime = blastingBeginTime;
// blasting.BlastingEndTime = blastingEndTime;
// int result = 0;
// try
// {
// result = DataFactory.UpdateEntity(blasting, "EquipmentSID,GroupSID,MaterialSID,BlastingNum,BlastingTotalNum,BlastingBeginTime,BlastingEndTime", "DG_Blasting_INS_MW");
// }
// catch (Exception)
// {
// result = 0;
// }
// return result;
//}
//#endregion
#region 查询抛丸最新SID
public static int GetBlastingSID()
{
List <Blasting> blastings = null;
Blasting blasting = new Blasting();
try
{
blastings = DataFactory.FillEntities <Blasting>(blasting, "", "MW_BlastingSID_SEL");
}
catch (Exception)
{
blastings = new List <Blasting>();
}
return(blastings[0].BlastingSID);
}
//抛丸线程
private void ThreadReadServer4()
{
Blasting blasting = new Blasting();
int result;
#region 注释
//持续读取
//GroupSID = siemensTcpNet.ReadInt16("DB1.508").Content; //班次
////物料查询
//if (Convert.ToInt16(siemensTcpNet.ReadBool("DB1.242").Content) - Convert.ToInt16(MaterialIDSearchSignal) != 0)
//{
// try
// {
// materials = MaterialDAL.LoadMaterals(""); //查询物料料号和SID
// writeResultRender(siemensTcpNet.Write("DB1.238", materials[0].MaterialID + "/" + materials[0].MaterialSID), "DB1.238"); //物料信息写入HMI
// writeResultRender(siemensTcpNet.Write("DB1.260", materials[1].MaterialID + "/" + materials[1].MaterialSID), "DB1.260");
// writeResultRender(siemensTcpNet.Write("DB1.282", materials[2].MaterialID + "/" + materials[2].MaterialSID), "DB1.282");
// writeResultRender(siemensTcpNet.Write("DB1.304", materials[3].MaterialID + "/" + materials[3].MaterialSID), "DB1.304");
// writeResultRender(siemensTcpNet.Write("DB1.326", materials[4].MaterialID + "/" + materials[4].MaterialSID), "DB1.326");
// writeResultRender(siemensTcpNet.Write("DB1.348", materials[5].MaterialID + "/" + materials[5].MaterialSID), "DB1.348");
// writeResultRender(siemensTcpNet.Write("DB1.370", materials[6].MaterialID + "/" + materials[6].MaterialSID), "DB1.370");
// writeResultRender(siemensTcpNet.Write("DB1.392", materials[7].MaterialID + "/" + materials[7].MaterialSID), "DB1.392");
// writeResultRender(siemensTcpNet.Write("DB1.414", materials[8].MaterialID + "/" + materials[8].MaterialSID), "DB1.414");
// writeResultRender(siemensTcpNet.Write("DB1.436", materials[9].MaterialID + "/" + materials[9].MaterialSID), "DB1.436");
// }
// catch (Exception ex) { }
//}
//MaterialIDSearchSignal = siemensTcpNet.ReadBool("DB1.242").Content; //更新物料查询标志
////产品查询
//if (Convert.ToInt16(siemensTcpNet.ReadBool("DB1.242").Content) - Convert.ToInt16(MaterialIDSearchSignal) != 0)
//{
// try
// {
// materials2 = MaterialDAL.LoadMaterals(""); //查询产品料号和SID
// writeResultRender(siemensTcpNet.Write("DB1.238", materials2[0].MaterialID + "/" + materials2[0].MaterialSID), "DB1.238"); //产品信息写入HMI
// writeResultRender(siemensTcpNet.Write("DB1.260", materials2[1].MaterialID + "/" + materials2[1].MaterialSID), "DB1.260");
// writeResultRender(siemensTcpNet.Write("DB1.282", materials2[2].MaterialID + "/" + materials2[2].MaterialSID), "DB1.282");
// writeResultRender(siemensTcpNet.Write("DB1.304", materials2[3].MaterialID + "/" + materials2[3].MaterialSID), "DB1.304");
// writeResultRender(siemensTcpNet.Write("DB1.326", materials2[4].MaterialID + "/" + materials2[4].MaterialSID), "DB1.326");
// writeResultRender(siemensTcpNet.Write("DB1.348", materials2[5].MaterialID + "/" + materials2[5].MaterialSID), "DB1.348");
// writeResultRender(siemensTcpNet.Write("DB1.370", materials2[6].MaterialID + "/" + materials2[6].MaterialSID), "DB1.370");
// writeResultRender(siemensTcpNet.Write("DB1.392", materials2[7].MaterialID + "/" + materials2[7].MaterialSID), "DB1.392");
// writeResultRender(siemensTcpNet.Write("DB1.414", materials2[8].MaterialID + "/" + materials2[8].MaterialSID), "DB1.414");
// writeResultRender(siemensTcpNet.Write("DB1.436", materials2[9].MaterialID + "/" + materials2[9].MaterialSID), "DB1.436");
// }
// catch (Exception ex) { }
//}
//MaterialIDSearchSignal = siemensTcpNet.ReadBool("DB1.242").Content; //更新产品查询标志
////故障查询
//if (Convert.ToInt16(siemensTcpNet.ReadBool("DB1.726.1").Content) - Convert.ToInt16(ProblemSearchSignal) != 0)
//{
// try
// {
// int ProblemPage = siemensTcpNet.ReadInt16("DB1.734").Content;
// problemCates = ProblemCateDAL.LoadProblemCates(1);
// this.listBox1.Items.Add(problemCates[0].ProblemCateDesc);
// if (ProblemPage == 0)
// {
// writeResultRender(siemensTcpNet.Write("DB1.510", problemCates[0].ProblemCateDesc + "/" + problemCates[0].ProblemCateSID), "DB1.510");
// writeResultRender(siemensTcpNet.Write("DB1.552", problemCates[1].ProblemCateDesc + "/" + problemCates[1].ProblemCateSID), "DB1.552");
// writeResultRender(siemensTcpNet.Write("DB1.594", problemCates[2].ProblemCateDesc + "/" + problemCates[2].ProblemCateSID), "DB1.594");
// writeResultRender(siemensTcpNet.Write("DB1.636", problemCates[3].ProblemCateDesc + "/" + problemCates[3].ProblemCateSID), "DB1.636");
// writeResultRender(siemensTcpNet.Write("DB1.678", problemCates[4].ProblemCateDesc + "/" + problemCates[4].ProblemCateSID), "DB1.678");
// }
// if (ProblemPage == 1)
// {
// writeResultRender(siemensTcpNet.Write("DB1.510", problemCates[5].ProblemCateDesc), "DB1.510");
// }
// }
// catch (Exception ex) { }
//}
//ProblemSearchSignal = siemensTcpNet.ReadBool("DB1.726.1").Content; //更新故障查询标志
//EquipmentSID = 74;//抛丸机
//if (siemensTcpNet.ReadBool("抛丸开始标志").Content == true)
//{
// BlastingBeginTime = DateTime.Now;
//}
//if (siemensTcpNet.ReadBool("抛丸结束标志").Content == true)
//{
// BlastingEndTime = DateTime.Now;
//}
#endregion
try
{
blasting.BlastingSID = BlastingDAL.GetBlastingSID();
blasting.BlastingNum = siemensTcpNet.ReadInt16("DB1.2").Content; //当班次当产品抛丸件数
blasting.BlastingTotalNum = siemensTcpNet.ReadInt16("DB1.2").Content; //总件数
blasting.BlastingEndTime = DateTime.Now;
result = BlastingDAL.UpdBlasting(blasting);
if (result == 1)
{
listBox2.Items.Add("抛丸写入数据库成功 " + DateTime.Now);
}
else
{
listBox2.Items.Add("抛丸写入数据库失败 " + DateTime.Now);
}
}
catch (Exception ex)
{
MessageBox.Show("抛丸出现问题：" + ex.Message);
}
this.thread4.Abort();
}
