YG-OPP-WCS-Client/WCS_Client/From/From_Montior/Form_EquInfo.cs

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<WCS_STACKERDATA>().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<WCS_STACKERDATA>().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<SrmSignal>();
                //    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<WCS_TASK>().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<ConveyorSignal>();
                //    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<WCS_TASK>().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<RGVSignal>();
                //    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<WCS_TASK>().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<WCS_TASK>().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);
            }
        }
    }
}