xiaomiMes/MainForm/FaForm/Form_Other.cs

using EIP_Protocol;
using MathNet.Numerics.RootFinding;
using Newtonsoft.Json;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;
using static MainForm.ClassFile.XiaomiAPI_MES.XiaomiMESHttp_StationOutbound;
using static MainForm.ClassFile.XiaomiAPI_MES.XiaomiMESHttp_StationOutbound.XmMES_StationOutRequest_Body;
using static MainForm.ClassFile.XiaomiClass.MesHelper;

namespace MainForm.FaForm
{
    public partial class Form_Other : Form
    {
        public Form_Other()
        {
            InitializeComponent();
        }

        private void button7_Click(object sender, EventArgs e)
        {
            ProcessData processData = new ProcessData
            {
                Workorder_code = GlobalContext.WorkOrderCode,
                //Batch_number = GlobalContext.BatchNumber,
                Equipment_code = GlobalContext.LineCode + "-S15",
                Test_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")
            };
            textBox1.Text = SQLHelper.ExecuteNonQuery(processData.ToStringInsert(0,0));
        }

        private void button8_Click(object sender, EventArgs e)
        {
            OneCheckData oneCheckData = new OneCheckData();
            string sql = oneCheckData.ToStringInsert(0);
            textBox1.Text = SQLHelper.ExecuteNonQuery(sql);
        }

        private void button5_Click(object sender, EventArgs e)
        {
            string url = @"http://10.1.19.33:9090/api/ProductionLine/GetWorkOrderInfo";
            string ret = string.Empty;
            WorkOrderInfo responseData = HttpUitls.GetWOData(textBox1.Text.Trim());
            textBox1.Text = JsonConvert.SerializeObject(responseData);
        }

        private void button4_Click(object sender, EventArgs e)
        {
            List<TestItem> items = new List<TestItem>();
            items.Add(new TestItem { Parameter_name = "1", Parameter_unit = "1", Parameter_value = "1" });
            items.Add(new TestItem { Parameter_name = "2", Parameter_unit = "2", Parameter_value = "2" });
            List<ProcessData> data = new List<ProcessData>();
            ProcessData processData = new ProcessData()
            {
                Equipment_code = "Equipment_code",
                Workorder_code = GlobalContext.WorkOrderCode,
                //Batch_number = GlobalContext.BatchNumber,
                Sn = "",
                Testitem = "Testitem",
                Parameter_values = items,
                Write_user = GlobalContext.CurrentUser,
                Test_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff")
            };
            //上传mes
            data.Add(processData);
            string jsonstr = JsonConvert.SerializeObject(data);
            if (GlobalContext.IsSendProcessData)
            {
                string url = @"HTTP://" + GlobalContext.ServerHost + @"/api/ProductionLine/ProcessData";
                string mesRet = HttpUitls.SubmitDataToMES(url, jsonstr); // HttpUitls.Post(url, jsonstr);
            }
            //本地数据
            string ret = SQLHelper.ExecuteNonQuery(processData.ToStringInsert(0, 0));
        }

        private void button6_Click(object sender, EventArgs e)
        {
            textBox1.Text = string.Empty;
        }

        private void button1_Click(object sender, EventArgs e)
        {
            WorkingData workingData = new WorkingData()
            {
                Equipment_code = GlobalContext.LineCode + "-Test",
                Update_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
            };
            string date = DateTime.Now.ToString("yyyy-MM-dd");
            textBox1.Text = SQLHelper.ExecuteNonQuery(workingData.ToStringInsert(date));
        }

        private void button3_Click(object sender, EventArgs e)
        {
            LineWorkingData_ThisTime lineWorkingData = new LineWorkingData_ThisTime()
            {
                LineName = GlobalContext.LineCode + "-Test",
                CreateTime = DateTime.Now
            };
            textBox1.Text = SQLHelper.ExecuteNonQuery(lineWorkingData.ToStringInsert());
        }

        private void button9_Click(object sender, EventArgs e)
        {
            WorkingData workingData = new WorkingData()
            {
                Equipment_code = GlobalContext.LineCode + "-Test",
                Update_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
            };
            string date = DateTime.Now.ToString("yyyy-MM-dd");
            textBox1.Text = SQLHelper.ExecuteNonQuery(workingData.ToStringUpdate(date));
        }

        private void button10_Click(object sender, EventArgs e)
        {
            //LineWorkingData_ThisTime lineWorkingData = new LineWorkingData_ThisTime()
            //{
            //    LineName = GlobalContext.LineCode + "-Test",
            //    CreateTime = DateTime.Now
            //};
            //string guid = DateTime.Now.ToString("yyyy-MM-dd");
            //textBox1.Text = SQLHelper.ExecuteNonQuery(lineWorkingData.ToStringUpdate(guid));
        }

        private void button11_Click(object sender, EventArgs e)
        {
            WorkingData workingData = new WorkingData()
            {
                Equipment_code = GlobalContext.LineCode + "-Test",
                Update_time = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")
            };
            string date = DateTime.Now.ToString("yyyy-MM-dd");
            textBox1.Text = SQLHelper.GetDataTable(workingData.ToStringQuery(date)).ToString();
        }

        private void button12_Click(object sender, EventArgs e)
        {
            LineWorkingData_ThisTime lineWorkingData = new LineWorkingData_ThisTime()
            {
                LineName = GlobalContext.LineCode + "-Test",
                CreateTime = DateTime.Now
            };
            string date = DateTime.Now.ToString("yyyy-MM-dd");
            textBox1.Text = SQLHelper.GetDataTable(lineWorkingData.ToStringQuery()).ToString();
        }

        private void button2_Click(object sender, EventArgs e)
        {
            AlarmData alarmData = new AlarmData()
            {
                LineName = GlobalContext.LineCode + "-Test",
                StartTime = DateTime.Now
            };
            //string sql = alarmData.ToStringInsert(0);
            //textBox1.Text = SQLHelper.ExecuteNonQuery(alarmData.ToStringInsert(0)).ToString();

            string sql = alarmData.ToStringInsert();
            textBox1.Text = SQLHelper.ExecuteNonQuery(alarmData.ToStringInsert()).ToString();
        }

        private void button13_Click(object sender, EventArgs e)
        {
            #region MAS测试项
            XmMES_StationOutRequest_Body outRequest_Body = new XmMES_StationOutRequest_Body();
            OP30_stnDataSet_t stPLC_MesData = new OP30_stnDataSet_t();
            string passFlag = "";
            string AllpassFlag = "PASS";
            string SN = "A123456";

            stPLC_MesData.testData.fAB_AirPressDiff = 2.5f;
            stPLC_MesData.testData.fAB_AirPressDiffMax = 2.5f;
            stPLC_MesData.testData.fAB_AirPressDiffMin = 0;
            stPLC_MesData.testData.fAB_AirPress = 0.1f;
            stPLC_MesData.testData.fAB_AirPressMax = 0.2f;
            stPLC_MesData.testData.fAB_AirPressMin = 0;

            float fAB_AirPressDiff = stPLC_MesData.testData.fAB_AirPressDiff;
            float fAB_AirPressDiffMax = stPLC_MesData.testData.fAB_AirPressDiffMax;
            float fAB_AirPressDiffMin = stPLC_MesData.testData.fAB_AirPressDiffMin;
            float fAB_AirPress = stPLC_MesData.testData.fAB_AirPress;
            float fAB_AirPressMax = stPLC_MesData.testData.fAB_AirPressMax;
            float fAB_AirPressMin = stPLC_MesData.testData.fAB_AirPressMin;

            XmStationOut_InspectionItemData inspectionItemData = new XmStationOut_InspectionItemData();
            if (fAB_AirPressDiffMax > fAB_AirPressDiffMin && (fAB_AirPressDiffMax != 0 || fAB_AirPressDiffMin != 0))
            {
                if (fAB_AirPressDiff > fAB_AirPressDiffMin && fAB_AirPressDiff <= fAB_AirPressDiffMax)
                    passFlag = "PASS";
                else
                    passFlag = "FAIL";

                if (passFlag == "FAIL") AllpassFlag = passFlag;
                inspectionItemData.AddDataItem("N801A","AB管气压", fAB_AirPressDiff.ToString(), fAB_AirPressDiffMax.ToString(), fAB_AirPressDiffMin.ToString(), passFlag);
            }

            if (fAB_AirPressMax>fAB_AirPressMin && (fAB_AirPressMax != 0 || fAB_AirPressMin != 0))
            {
                if (fAB_AirPress > fAB_AirPressMin && fAB_AirPress <= fAB_AirPressMax)
                    passFlag = "PASS";
                else
                    passFlag = "FAIL";

                if (passFlag == "FAIL") AllpassFlag = passFlag;
                inspectionItemData.AddDataItem("N801A","AB管气压差", fAB_AirPress.ToString(), fAB_AirPressMax.ToString(), fAB_AirPressMin.ToString(), passFlag);
            }
            
            inspectionItemData.childUnitSn = SN;
            inspectionItemData.childUnitState = AllpassFlag;
            inspectionItemData.toolVersion = "1.0";

            string detailjson = JsonConvert.SerializeObject(inspectionItemData);//过站测试项

            #endregion
        }
    }
}