using CCWin; using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Threading.Tasks; using System.Windows.Forms; using WCS_Client.Models; namespace WCS_Client.From { public partial class Form_EquInfo : CCSkinMain { string _equName = string.Empty; string _rgvposno = string.Empty; string _rgvposText = string.Empty; public Form_EquInfo(string equname, string rgvposno = "", string rgvpostext = "") { InitializeComponent(); _equName = equname; _rgvposno = rgvposno; _rgvposText = rgvpostext; Name = string.Format("设备[{0}]信息", _equName); Init(); } private void Init() { try { TryCachHelper.TryExecute((db) => { WCS_STACKERDATA stackerdate = null; stackerdate = db.Queryable().Where(v=>v.STA_EQUIPMENTNO==_equName).ToList().FirstOrDefault(); if (stackerdate == null) return; if (stackerdate.STA_TYPE.ToLower() == "rgv") { txtEquNo.Text = _rgvposText; } else { txtEquNo.Text = stackerdate.STA_EQUIPMENTNO; } txtPlcName.Text = stackerdate.STA_PLCNAME; txtEquType.Text = stackerdate.STA_TYPE; txtAlarmNo.Text = stackerdate.STA_ALARMSNO; txtAlarmInfo.Text = stackerdate.STA_ALARMSMSG; if (stackerdate.STA_TYPE.ToLower() == "rgv") { if (_rgvposText == "1023" || _rgvposText == "1007" || _rgvposText == "1056" || _rgvposText == "1086") { txtTaskNo.Text = stackerdate.RGVSignalItem.DB522_Tasknum_1.ToString(); txtRequest.Text = stackerdate.RGVSignalItem.DB522_Request_1.ToString(); txtConfirm.Text = stackerdate.RGVSignalItem.DB520_Confirm_1.ToString(); txtStartAddress.Text = stackerdate.RGVSignalItem.DB522_Goodsstart_1.ToString(); txtEndAddress.Text = stackerdate.RGVSignalItem.DB522_Goodsend_1.ToString(); txtPH_Status.Text = stackerdate.RGVSignalItem.DB522_PH_Status_1.ToString(); } else { txtTaskNo.Text = stackerdate.RGVSignalItem.DB522_Tasknum_2.ToString(); txtRequest.Text = stackerdate.RGVSignalItem.DB522_Request_2.ToString(); txtConfirm.Text = stackerdate.RGVSignalItem.DB520_Confirm_2.ToString(); txtStartAddress.Text = stackerdate.RGVSignalItem.DB522_Goodsstart_2.ToString(); txtEndAddress.Text = stackerdate.RGVSignalItem.DB522_Goodsend_2.ToString(); txtPH_Status.Text = stackerdate.RGVSignalItem.DB522_PH_Status_2.ToString(); } } else if (stackerdate.STA_TYPE.ToLower() == "conveyor") { txtTaskNo.Text = stackerdate.ConveyorSignalItem.DB521_Tasknum.ToString(); txtRequest.Text = stackerdate.ConveyorSignalItem.DB521_Request.ToString(); txtConfirm.Text = stackerdate.ConveyorSignalItem.DB520_Confirm.ToString(); txtStartAddress.Text = stackerdate.ConveyorSignalItem.DB521_Goodsstart.ToString(); txtEndAddress.Text = stackerdate.ConveyorSignalItem.DB521_Goodsend.ToString(); txtPH_Status.Text = stackerdate.ConveyorSignalItem.CvDB51_PH_Status.ToString(); } else { txtTaskNo.Text = stackerdate.SrmSignalItem.DB521_TaskID.ToString(); } }); //string sqlstr = string.Format("STA_EQUIPMENTNO='{0}'", _equName); //using (MAction action = new MAction("wcs_stackerdata")) //{ // stackerdate = action.Select(sqlstr).ToList().FirstOrDefault(); //} //if (stackerdate == null) return; //if(stackerdate.STA_TYPE.ToLower() == "rgv") //{ // txtEquNo.Text = _rgvposText; //} //else //{ // txtEquNo.Text = stackerdate.STA_EQUIPMENTNO; //} //txtPlcName.Text = stackerdate.STA_PLCNAME; //txtEquType.Text = stackerdate.STA_TYPE; //txtAlarmNo.Text = stackerdate.STA_ALARMSNO; //txtAlarmInfo.Text = stackerdate.STA_ALARMSMSG; //if (stackerdate.STA_TYPE.ToLower() == "srm") //{ // SrmSignal srms = stackerdate.STA_DATA.ToObject(); // txtTaskNo.Text = srms.DB521_TaskID.ToString(); // if (srms.DB521_TaskID > 0) // { // sqlstr = string.Format("select * from WCS_TASK where TASK_NO={0}", srms.DB521_TaskID); // using (MAction action = new MAction("WCS_TASK")) // { // WCS_TASK task = action.Select(sqlstr).ToList().FirstOrDefault(); // if (task != null) // { // txtGoodsCode.Text = task.TASK_BOXBARCODE; // txtStartAddress.Text = task.TASK_POSIDFROM; // txtEndAddress.Text = task.TASK_POSIDTO; // } // } // } //} //else if (stackerdate.STA_TYPE.ToLower() == "conveyor") //{ // ConveyorSignal cs = stackerdate.STA_DATA.ToObject(); // txtTaskNo.Text = cs.DB521_Tasknum.ToString(); // txtGoodsType.Text = cs.DB521_Goodstype.ToString(); // txtRequest.Text = cs.DB521_Request.ToString(); // txtConfirm.Text = cs.DB521_Confirm.ToString(); // txtPH_Status.Text = cs.CvDB51_PH_Status.ToString(); // if (cs.DB521_Tasknum > 0) // { // sqlstr = string.Format("select * from WCS_TASK where TASK_NO={0}", cs.DB521_Tasknum); // using (MAction action = new MAction("WCS_TASK")) // { // WCS_TASK task = action.Select(sqlstr).ToList().FirstOrDefault(); // if (task != null) // { // txtGoodsCode.Text = task.TASK_BOXBARCODE; // txtStartAddress.Text = task.TASK_POSIDFROM; // txtEndAddress.Text = task.TASK_POSIDTO; // } // } // } //} //else if (stackerdate.STA_TYPE.ToLower() == "rgv") //{ // RGVSignal rgvs = stackerdate.STA_DATA.ToObject(); // if (_rgvposno == "btn01") // { // txtTaskNo.Text = rgvs.DB522_Tasknum_1.ToString(); // txtGoodsType.Text = rgvs.DB522_Goodstype_1.ToString(); // txtRequest.Text =rgvs.DB522_Request_1.ToString(); // txtConfirm.Text = rgvs.DB522_Confirm_1.ToString(); // txtPH_Status.Text = rgvs.DB522_PH_Status_1.ToString(); // txtAGVPallFull.Text = rgvs.DB522_Full_1.ToString(); // txtAGVPallEmpty.Text = rgvs.DB522_Empty_1.ToString(); // if (rgvs.DB522_Tasknum_1 > 0) // { // sqlstr = string.Format("select * from WCS_TASK where TASK_NO={0}", rgvs.DB522_Tasknum_1); // using (MAction action = new MAction("WCS_TASK")) // { // WCS_TASK task = action.Select(sqlstr).ToList().FirstOrDefault(); // if (task != null) // { // txtGoodsCode.Text = task.TASK_BOXBARCODE; // txtStartAddress.Text = task.TASK_POSIDFROM; // txtEndAddress.Text = task.TASK_POSIDTO; // } // } // } // } // else if (_rgvposno == "btn02") // { // txtTaskNo.Text = rgvs.DB522_Tasknum_2.ToString(); // txtGoodsType.Text = rgvs.DB522_Goodstype_2.ToString(); // txtRequest.Text = rgvs.DB522_Request_2.ToString(); // txtConfirm.Text = rgvs.DB522_Confirm_2.ToString(); // txtPH_Status.Text = rgvs.DB522_PH_Status_2.ToString(); // txtAGVPallFull.Text = rgvs.DB522_Full_2.ToString(); // txtAGVPallEmpty.Text = rgvs.DB522_Empty_2.ToString(); // if (rgvs.DB522_Tasknum_2 > 0) // { // sqlstr = string.Format("select * from WCS_TASK where TASK_NO={0}", rgvs.DB522_Tasknum_2); // using (MAction action = new MAction("WCS_TASK")) // { // WCS_TASK task = action.Select(sqlstr).ToList().FirstOrDefault(); // if (task != null) // { // txtGoodsCode.Text = task.TASK_BOXBARCODE; // txtStartAddress.Text = task.TASK_POSIDFROM; // txtEndAddress.Text = task.TASK_POSIDTO; // } // } // } // } //} } catch (Exception ex) { MessageBox.Show(ex.Message); } } } }