mes-client/UAS_MES_XZC/FunctionCode/Make/Make_CollectFb.cs

using DevExpress.XtraRichEdit.API.Word;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Net.Sockets;
using System.Net;
using System.Text;
using System.Windows.Forms;
using System.Xml;
using UAS_MES_NEW.DataOperate;
using UAS_MES_NEW.Entity;
using UAS_MES_NEW.PublicMethod;
using System.Speech.Synthesis;
using Newtonsoft.Json;

namespace UAS_MES_NEW.Make
{
    public partial class Make_CollectFb : Form
    {
        DataHelper dh;
        AutoSizeFormClass asc = new AutoSizeFormClass();
        LogStringBuilder sql = new LogStringBuilder();
        DataTable dt;
        //当前序列号记录
        string sn_code;
        //制造单号
        string macode;
        //采集网标号
        string net_code;
        //网标查询条件ms_id
        string oMsID;
        //判断是否输入网标
        Boolean isnetcode = false;
        //打印计数
        int printcount = 0;
        int ma_unlimitin;

        private SpeechSynthesizer SpeechSynthesizer;

        public Make_CollectFb()
        {
            InitializeComponent();
            SpeechSynthesizer = new SpeechSynthesizer();
            SpeechSynthesizer.SetOutputToDefaultAudioDevice();
            //SpeechSynthesizer.SelectVoiceByHints(VoiceGender.Male, VoiceAge.Teen, 0, new System.Globalization.CultureInfo("zh-CN"));
            SpeechSynthesizer.Rate = -2;
        }


        //FileSystemWatcher watcher;


        private void Make_CollectNetCode_Load(object sender, EventArgs e)
        {
            asc.controllInitializeSize(this);
            dh = SystemInf.dh;

            //string sharedFolderPath = @"\\192.168.10.1\othersystem\Type2Output";
            //sharedFolderPath = @"D:\mes";

            //sharedFolderPath = @"\\192.168.10.1\othersystem\PickupInformation";
            //sharedFolderPath = @"D:\标签";
            ////// 确保路径以反斜杠结尾，以便正确监控目录
            ////if (!sharedFolderPath.EndsWith("\\"))
            ////{
            ////    sharedFolderPath += "\\";
            ////}
            //// 创建FileSystemWatcher实例
            //watcher = new FileSystemWatcher
            //{
            //    Path = sharedFolderPath,
            //    NotifyFilter = NotifyFilters.FileName | NotifyFilters.LastWrite | NotifyFilters.Size | NotifyFilters.DirectoryName,
            //    Filter = "*.*", // 监控所有文件
            //    IncludeSubdirectories = false, // 根据需要设置为true以监控子目录
            //    EnableRaisingEvents = true
            //};

            // 绑定事件处理程序
            //fileSystemWatcher1.Created += OnCreated;
            //watcher.Changed += OnChanged;
            //watcher.Deleted += OnDeleted;
            //watcher.Renamed += OnRenamed;
            //OperateResult.AppendText(DateTime.Now+" 开始监控文件夹: " + fileSystemWatcher1.Path+ "\n");
            //OperateResult.AppendText(DateTime.Now + " 开始监控文件夹: " + fileSystemWatcher2.Path + "\n");
        }

        public class MachiningRecord
        {
            public string SN { get; set; }
            public string LorR { get; set; }
            public string OPDateTime { get; set; }
            public string BeginTime { get; set; }
            public string EndTime { get; set; }
            public decimal MillSegment { get; set; }
            public decimal TotalMillSegments { get; set; }
            public decimal MillDis { get; set; }
            public decimal MillDiameter { get; set; }
            public string FixtureSN { get; set; }
            public string ProductCount { get; set; }
            public decimal BoardThickness { get; set; }
            public int LiftingKnifeHeight { get; set; }
            public decimal OverZ { get; set; }
            public decimal WorkHeight { get; set; }
            public int CutSpeed { get; set; }
            public int SpindleSpeed { get; set; }
            public string OPNo { get; set; }
        }

        // 文件创建事件处理程序
        private  void OnCreated(object sender, FileSystemEventArgs e)
        {
            try
            {
                OperateResult.AppendText(DateTime.Now+" 文件创建: " + e.FullPath + "\n");

                //第二版
                if (e.FullPath.Contains("txt"))
                {
                    string jsonFilePath = e.FullPath;
                    string jsonContent = File.ReadLines(jsonFilePath).Last().Replace("[", "\"").Replace("]", "\"");
                    Console.WriteLine(jsonContent);
                    MachiningRecord record = JsonConvert.DeserializeObject<MachiningRecord>(jsonContent);
                    if (!dh.CheckExist("MACHINING_RECORDS", "OP_DATE_TIME=to_date('" + record.OPDateTime + "','yyyy/MM/dd hh24:mi:ss')"))
                    {
                        dh.ExecuteSql(" INSERT INTO MACHINING_RECORDS (RECORD_ID, SN, LOR_R, OP_DATE_TIME, BEGIN_TIME, END_TIME,  MILL_SEGMENT," +
                            " TOTAL_MILL_SEGMENTS, MILL_DIS, MILL_DIAMETER, FIXTURE_SN, PRODUCT_COUNT, BOARD_THINNESS, LIFTING_KNIFE_HEIGHT, OVER_Z," +
                            " WORK_HEIGHT,CUT_SPEED, SPINDLE_SPEED, OP_NO) VALUES (MACHINING_RECORDS_seq.nextval,'" + record.SN + "','" + record.LorR + "',to_date('" + record.OPDateTime + "','yyyy/MM/dd hh24:mi:ss')" +
                            ",to_date('" + record.BeginTime + "','yyyy/MM/dd hh24:mi:ss'),to_date('" + record.EndTime + "','yyyy/MM/dd hh24:mi:ss'),'" + record.MillSegment + "','" + record.TotalMillSegments + "','" + record.MillDis + "'," +
                            "'" + record.MillDiameter + "','" + record.FixtureSN + "','" + record.ProductCount + "','" + record.BoardThickness + "','" + record.LiftingKnifeHeight + "','" + record.OverZ + "'," +
                            "'" + record.WorkHeight + "','" + record.CutSpeed + "','" + record.SpindleSpeed + "','" + record.OPNo + "') ", "insert");
                    }

                }


            }
            catch (Exception ex)
            {
                OperateResult.AppendText(DateTime.Now + " " + ex.Message + "\n");
            }
        }

        // 文件更改事件处理程序
        private  void OnChanged(object sender, FileSystemEventArgs e)
        {
           // OperateResult.AppendText("文件更改: " + e.FullPath+"\n");
        }

        // 文件删除事件处理程序
        private  void OnDeleted(object sender, FileSystemEventArgs e)
        {
            //OperateResult.AppendText("文件删除: " + e.FullPath + "\n");
        }

        // 文件重命名事件处理程序
        private  void OnRenamed(object sender, RenamedEventArgs e)
        {
            //OperateResult.AppendText("文件重命名: 从 "+ e.OldFullPath + " 到 "+ e.FullPath + "\n");
        }

        private void sncode_KeyDown(object sender, KeyEventArgs e)
        {
           
        }

        private void Make_CollectNetCode_SizeChanged(object sender, EventArgs e)
        {
            asc.controlAutoSize(this);
        }

        private void Make_CollectNetCode_Activated(object sender, EventArgs e)
        {
        }


  

        private void deleteButton1_Click(object sender, EventArgs e)
        {

        }

        private void Make_CollectNetCode_FormClosed(object sender, FormClosedEventArgs e)
        {
            // 释放资源
            fileSystemWatcher1.Dispose();
        }

      


      

      

     

        private void fileSystemWatcher1_Changed(object sender, FileSystemEventArgs e)
        {
            try
            {
                OperateResult.AppendText(DateTime.Now + " 文件变更: " + e.FullPath + "\n");

                //第二版
                if (e.FullPath.Contains("txt"))
                {
                    string jsonFilePath = e.FullPath;
                    string jsonContent = File.ReadLines(jsonFilePath).Last().Replace("[", "\"").Replace("]", "\"");
                    MachiningRecord record = JsonConvert.DeserializeObject<MachiningRecord>(jsonContent);
                    if (!dh.CheckExist("MACHINING_RECORDS", "OP_DATE_TIME=to_date('" + record.OPDateTime + "','yyyy/MM/dd hh24:mi:ss')"))
                    {
                        dh.ExecuteSql(" INSERT INTO MACHINING_RECORDS (RECORD_ID, SN, LOR_R, OP_DATE_TIME, BEGIN_TIME, END_TIME,  MILL_SEGMENT," +
                            " TOTAL_MILL_SEGMENTS, MILL_DIS, MILL_DIAMETER, FIXTURE_SN, PRODUCT_COUNT, BOARD_THINNESS, LIFTING_KNIFE_HEIGHT, OVER_Z," +
                            " WORK_HEIGHT,CUT_SPEED, SPINDLE_SPEED, OP_NO) VALUES (MACHINING_RECORDS_seq.nextval,'" + record.SN + "','" + record.LorR + "',to_date('" + record.OPDateTime + "','yyyy/MM/dd hh24:mi:ss')" +
                            ",to_date('" + record.BeginTime + "','yyyy/MM/dd hh24:mi:ss'),to_date('" + record.EndTime + "','yyyy/MM/dd hh24:mi:ss'),'" + record.MillSegment + "','" + record.TotalMillSegments + "','" + record.MillDis + "'," +
                            "'" + record.MillDiameter + "','" + record.FixtureSN + "','" + record.ProductCount + "','" + record.BoardThickness + "','" + record.LiftingKnifeHeight + "','" + record.OverZ + "'," +
                            "'" + record.WorkHeight + "','" + record.CutSpeed + "','" + record.SpindleSpeed + "','" + record.OPNo + "') ", "insert");
                    }

                }


            }
            catch (Exception ex)
            {
                OperateResult.AppendText(DateTime.Now + " " + ex.Message + "\n");
            }
        }
    }
}