xiaomiMes/MainForm/FaForm/Form_Other.cs

using EIP_Protocol;
using MainForm.ClassFile.XiaomiClass;
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)
        {
            var cleanupService = new MultiDirectoryCleanupService();
            cleanupService.Start();
        }
    }
}