using Aspose.Cells;
using Aspose.Cells.Rendering;
using autuPrint.printService;

using OfficeOpenXml.Drawing;
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;
using System.Threading.Tasks;
using System.Windows.Forms;
using ZXing;
using ZXing.Common;
using autuPrint.ORM;
using System.Diagnostics;
using iWareCommon.Utils;


namespace autuPrint
{
    public partial class Form1 : Form
    {
        public static string QuerPartStatus = ConfigHelper.GetConfigString("QuerPartStatus");//修改为配置文件 【EditBy shaocx,2022-01-27】
        public Form1()
        {
            InitializeComponent();
        }
        //自动打印线程
        Thread AutoPrint, Colors;
        /// <summary>
        /// //线程锁防止并发
        /// </summary>
        public static Mutex single = new Mutex();

        private void Form1_Load(object sender, EventArgs e)
        {

            //检测是否已经开启
            Process current = Process.GetCurrentProcess();
            Process[] processes = Process.GetProcessesByName(current.ProcessName);
            foreach (Process process in processes)
            {
                if (process.Id != current.Id)
                {
                    if (process.MainModule.FileName == current.MainModule.FileName)
                    {
                        Environment.Exit(0);
                        return;
                    }
                }
            }
            AutoPrint = new Thread(autoPrint);
            AutoPrint.Start();//开启自动打印线程

            var doAutoPrint = new Thread(do_autoPrint);
            doAutoPrint.Start();//开启自动打印线程

            new Thread(DeleteData).Start();

            Colors = new Thread(changeColor);
            Colors.Start();
            string path = @"C:\autoPrint\" + "Setup.txt";
            if (!Directory.Exists(Path.GetDirectoryName(path))) Directory.CreateDirectory(Path.GetDirectoryName(path));
            if (!File.Exists(path)) File.WriteAllText(path, string.Empty);
            string org = File.ReadAllText(path);
            string[] getSetUP = org.Split('#');
            if (getSetUP.Length == 2)
            {

                textBox1.Text = getSetUP[0];
                textBox2.Text = getSetUP[1];
            }

        }
        /// <summary>
        /// 自动打印-准备数据
        /// </summary>
        public void autoPrint()
        {
            while (true)
            {
                Thread.Sleep(1000);
                if (single.WaitOne())//增加线程锁
                {
                    try
                    {
                        using (dbModel1 mod = new dbModel1())
                        {
                            //List<vBase_ProductPosition> needPrint = mod.vBase_ProductPosition.Where(x => x.PositionName == "收货暂存区" && x.ProductStorage > 0 && x.PartStatus == "1").ToList();
                            List<vBase_ProductPosition> needPrint = mod.vBase_ProductPosition.Where(x => x.PositionName == "收货暂存区" && x.ProductStorage > 0 && x.PartStatus == QuerPartStatus).ToList();

                            //needPrint = needPrint.Where(x => x.ProductStorage>0).ToList();

                            if (needPrint.Count > 0)
                            {
                                foreach (var item in needPrint)
                                {
                                    var isQrCode = false;//是不是二维码
                                    #region 单个处理标签打印
                                    Thread.Sleep(1000);


                                    #region 生成 标签条码

                                    string barCode = "";
                                    if (!string.IsNullOrEmpty(item.qrCode_guid))
                                    {
                                        isQrCode = true;
                                        barCode = item.qrCode_guid;
                                    }
                                    else
                                    {
                                        barCode = DateTime.Now.ToString("yyMMddHHmmss");
                                    }

                                    var existCount = mod.Base_PositionPrint.Where(x => x.ExtendField06 == barCode).Count();
                                    if (existCount >= 1)
                                    {//说明标签条码重复了，需要直接返回  【Editby shaocx,2022-10-20】
                                        Log4NetHelper.WriteInfoLog(LogType.AutoHandlerPrint, "说明标签条码重复了，需要直接返回：" + barCode);
                                        //必须要保存数据才对！
                                        //注意：保存
                                        item.PartStatus = "0";//赋值为0，表示已经打印完毕 【EditBy shaocx,2022-10-15】

                                        //为什么会将库存清零？我不明白，我给注释掉了.因为清零，会导致我单独上架时库存为0的问题 【Editby shaocx,2024-09-12】
                                        //item.ProductStorage = 0M;

                                        var dbObj = mod.Base_ProductPosition.Where(x => x.ProductPosition_Id == item.ProductPosition_Id).FirstOrDefault();
                                        if (dbObj != null)
                                        {
                                            dbObj.ExtendField06 = barCode;//记录标签码
                                            dbObj.BarCode = barCode;//记录标签码
                                        }

                                        int pp = mod.SaveChanges();
                                        Log4NetHelper.WriteInfoLog(LogType.AutoHandlerPrint, "说明标签条码重复了，需要直接返回SaveChanges，直接返回：" + pp);

                                        break;//直接跳出本次循环
                                    }

                                    #endregion

                                    #region 写入打印记录,该表用于界面【码盘上架】扫码查询使用
                                    try
                                    {
                                        Base_PositionPrint printRecord = new Base_PositionPrint();
                                        printRecord.ExtendField06 = barCode;//标签条码
                                        printRecord.PoCode = item.PoCode == null ? "" : item.PoCode;//采购单号
                                        printRecord.ItemNumber = item.ItemNumber == null ? "" : item.ItemNumber;//采购项号
                                        printRecord.SaleCode = item.SaleCode == null ? "" : item.SaleCode;//销售单号
                                        printRecord.ExtendField08 = item.ExtendField08 == null ? "" : item.ExtendField08;//销售项号
                                        printRecord.ExtendField04 = item.ExtendField04 == null ? "" : item.ExtendField04;//跟踪号
                                        printRecord.ProductCode = item.ProductCode;//物料编号
                                        printRecord.ProductName = item.ProductName;//物料名称
                                        printRecord.Quantity = (decimal?)item.OrignStorage;//标签上物料数量 修复 异常可空对象必须要有一个值 【Editby shaocx,2023-07-11】
                                        printRecord.SmallUnit = item.SmallUnit;//库存单位
                                        printRecord.InStorageDate = (DateTime)item.InStorageDate;//收货日期
                                        printRecord.LimitDate = item.LimitDate;//限用日期
                                        printRecord.ProviderShortName = item.ProviderShortName;//供应商名称
                                        printRecord.CreateDate = DateTime.Now;
                                        //不为空垃圾字段
                                        printRecord.CreateID = 1;
                                        printRecord.Creator = !isQrCode ? "自动打印" : "二维码，不打印";
                                        printRecord.PlatUser_Id = 1;
                                        printRecord.UserProduct_Id = 1007;

                                        printRecord.isNeedPrint = 1;//需要打印 【EditBy shaocx,2022-10-20】
                                        printRecord.printDevice = Convert.ToInt32(QuerPartStatus);//打印设备  【EditBy shaocx,2022-10-20】

                                        if (isQrCode)
                                        {//二维码，不需要打印
                                            printRecord.isNeedPrint = 0;//打印完成
                                        }

                                        mod.Base_PositionPrint.Add(printRecord);

                                        //注意：保存
                                        item.PartStatus = "0";//赋值为0，表示已经打印完毕 【EditBy shaocx,2022-10-15】

                                        //为什么会将库存清零？我不明白，我给注释掉了.因为清零，会导致我单独上架时库存为0的问题 【Editby shaocx,2024-09-12】
                                        //item.ProductStorage = 0M;

                                        var dbObj = mod.Base_ProductPosition.Where(x => x.ProductPosition_Id == item.ProductPosition_Id).FirstOrDefault();
                                        if (dbObj != null)
                                        {
                                            dbObj.ExtendField06 = barCode;//记录标签码
                                            dbObj.BarCode = barCode;//记录标签码
                                        }

                                        int i = mod.SaveChanges();
                                        Log4NetHelper.WriteInfoLog(LogType.AutoHandlerPrint, "SaveChanges，直接返回：" + i);
                                    }
                                    catch (Exception ex)
                                    {
                                        Log4NetHelper.WriteErrorLog(LogType.AutoHandlerPrint, "类名: Form1 方法名: autoPrint 标签自动打印,存打印记录表失败  " + ex.ToString(), ex);
                                    }

                                    #endregion

                                    #endregion
                                }
                            }
                            else
                            {
                                Log4NetHelper.WriteInfoLog(LogType.AutoHandlerPrint, "没有要处理的数据呵呵");
                            }
                        }
                    }
                    catch (Exception ex)
                    {
                        Log4NetHelper.WriteErrorLog(LogType.AutoHandlerPrint, "类名: Service1 方法名: autoPrint 自动打印方法参数转换失败 \r\n  " + ex.ToString(), ex);
                    }
                    finally { single.ReleaseMutex(); }//一轮结束
                }
            }
        }

        /// <summary>
        /// 自动打印-行动
        /// </summary>
        public void do_autoPrint()
        {
            while (true)
            {
                Thread.Sleep(1000);

                try
                {
                    using (dbModel1 mod = new dbModel1())
                    {
                        var queryQuerPartStatus = Convert.ToInt32(QuerPartStatus);
                        List<Base_PositionPrint> needPrint = mod.Base_PositionPrint.Where(x => x.isNeedPrint == 1 && x.printDevice == queryQuerPartStatus).ToList();

                        if (needPrint.Count > 0)
                        {
                            foreach (var item in needPrint)
                            {
                                #region 单个处理标签打印
                                Thread.Sleep(1000);
                                labelEntity label = new labelEntity();
                                int pringTime = 1;//打印次数

                                label.purchaseOrder = item.PoCode == null ? "" : item.PoCode;//采购单号
                                label.purchaseOrderItem = item.ItemNumber == null ? "" : item.ItemNumber;//采购项号
                                label.saleCode = item.SaleCode == null ? "" : item.SaleCode;//销售单号
                                label.saleCodeItem = item.ExtendField08 == null ? "" : item.ExtendField08;//销售项号
                                label.trackNumber = item.ExtendField04 == null ? "" : item.ExtendField04;//跟踪号
                                label.materailCode = item.ProductCode;//物料编号
                                label.materarilName = item.ProductName;//物料名称

                                //保留两位小数 [EditBy shaocx,2022-06-20]
                                decimal zz = (item.Quantity == null ? 0 : (decimal)item.Quantity);
                                label.quantity = pringTime == 1 ? Math.Round(zz, 2) : 0;//收货数量


                                label.Unit = item.SmallUnit;//库存单位
                                label.receivDate = (DateTime)item.InStorageDate;//收货日期
                                label.expireDate = item.LimitDate;//限用日期
                                label.supplierName = item.ProviderShortName;//供应商名称

                                string barCode = item.ExtendField06;//标签条码
                                Image img = QrCodeAndBarCode.printBr(barCode);
                                bool saveSucceed = creatExcelPrint.creatEXcel(img, label, barCode);

                                if (saveSucceed)
                                {
                                    if (File.Exists(@"D:\临时.xlsx"))
                                    {
                                        bool printSucceed = true;
                                        //发起打印
                                        for (int i = 0; i < pringTime; i++)
                                        {
                                            printSucceed = print.printExcel(@"D:\临时.xlsx");
                                        }


                                        if (printSucceed)
                                        {
                                            //打印成功 删除临时文件,并改状态
                                            FileInfo myfile = new FileInfo(@"D:\临时.xlsx");//PartStatus
                                            myfile.Delete();
                                            item.isNeedPrint = 0;//打印完成
                                            int isSave = mod.SaveChanges();
                                            if (isSave < 1)
                                            {
                                                Log4NetHelper.WriteErrorLog(LogType.Print, "类名: Form1 方法名: do_autoPrint 修改库存自动打印状态失败  ", null);
                                            }
                                        }
                                        else
                                        {
                                            Log4NetHelper.WriteErrorLog(LogType.Print, "最终打印失败", null);
                                        }
                                    }
                                    else
                                    {
                                        Log4NetHelper.WriteErrorLog(LogType.Print, "临时.xlsx不存在", null);
                                    }
                                }
                                else
                                {
                                    Log4NetHelper.WriteErrorLog(LogType.Print, "创建creatEXcel失败", null);
                                }
                                #endregion
                            }
                        }
                        else
                        {
                            Log4NetHelper.WriteInfoLog(LogType.Print, "没有要打印的数据");
                        }
                    }
                }
                catch (Exception ex)
                {
                    Log4NetHelper.WriteErrorLog(LogType.Print, "类名: Service1 方法名: do_autoPrint 自动打印方法参数转换失败 \r\n  " + ex.ToString(), ex);
                }
            }
        }

        public void changeColor()
        {
            bool isChange = true;
            while (true)
            {
                Thread.Sleep(1000);
                if (isChange)
                {
                    label1.BackColor = Color.Yellow;

                }
                else
                {
                    label1.BackColor = Color.Pink;
                }
                isChange = !isChange;
            }


        }

        private void Form1_FormClosing(object sender, FormClosingEventArgs e)
        {

            Environment.Exit(0);//退出本进程所有线程
        }

        private void textBox2_TextChanged(object sender, EventArgs e)
        {
            string path = @"C:\autoPrint\" + "Setup.txt";
            if (!Directory.Exists(Path.GetDirectoryName(path))) Directory.CreateDirectory(Path.GetDirectoryName(path));
            if (!File.Exists(path)) File.WriteAllText(path, string.Empty);
            string info = textBox1.Text + "#" + textBox2.Text;
            File.WriteAllText(path, info);

        }

        private void textBox1_TextChanged(object sender, EventArgs e)
        {
            string path = @"C:\autoPrint\" + "Setup.txt";
            if (!Directory.Exists(Path.GetDirectoryName(path))) Directory.CreateDirectory(Path.GetDirectoryName(path));
            if (!File.Exists(path)) File.WriteAllText(path, string.Empty);
            string info = textBox1.Text + "#" + textBox2.Text;
            File.WriteAllText(path, info);
        }


        #region 定时删除数据

        /// <summary>
        /// 定时删除数据
        /// </summary>
        public void DeleteData()
        {
            while (true)
            {
                try
                {
                    LogTextHelper.BatchDeleteLog();

                    Thread.Sleep(8 * 60 * 60 * 1000);//每天8小时一次 
                }
                catch (Exception ex)
                {
                    Log4NetHelper.WriteErrorLog(iWareCommon.Utils.LogType.Sys_DeleteLog, "定时删除数据 出现异常", ex);
                }
                finally
                {

                }
            }
        }

        #endregion

    }
}