using FastReport;
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 Newtonsoft.Json;
using System.Drawing.Printing;
using OfficeOpenXml;
using OfficeOpenXml.FormulaParsing.Excel.Functions.Text;

namespace WindowsFormsApp6
{
    public partial class Form1 : Form
    {
        //public static string ReportPath = System.IO.Directory.GetCurrentDirectory();
        private bool isInputError = false;
        //public static string ReportPath = "E:\\KHGITHUB\\ZhongCheAGVCangKu\\ZhongCheAGVCangKu\\代码管理\\打印机\\WindowsFormsApp6\\WindowsFormsApp6\\FRX";
        //public static string ReportPath = "E:\\项目发布文件夹\\中车打印机";
        public static string ReportPath = Application.StartupPath;
        public Form1()
        {
            InitializeComponent();
            // 新增这行：设置EPPlus的许可证上下文
            ExcelPackage.LicenseContext = OfficeOpenXml.LicenseContext.NonCommercial;
            try
            {
                // 读取文件所有行
                string[] lines = System.IO.File.ReadAllLines("D:\\打印机车型轴承品牌下拉框文件夹\\车型.txt");
                string[] lines2 = System.IO.File.ReadAllLines("D:\\打印机车型轴承品牌下拉框文件夹\\轴承型号.txt");
                string[] lines3 = System.IO.File.ReadAllLines("D:\\打印机车型轴承品牌下拉框文件夹\\轴承品牌.txt");

                // 添加到下拉框
                this.comboBox3.Items.AddRange(lines2);
                this.comboBox2.Items.AddRange(lines);
                this.comboBox4.Items.AddRange(lines3);
            }
            catch (Exception ex)
            {
                // 读取失败时提示
                MessageBox.Show("读取文件失败：" + ex.Message);
            }
        }

        private void btn_print_Click(object sender, EventArgs e)
        {
            try
            {
                PrintDocument pd = new PrintDocument();
                //string name = Txt_barcode1.Text;
                //if (name == "")
                //{
                //    MessageBox.Show("请输入打印数据", "提示", MessageBoxButtons.OKCancel);
                //    return;
                //}
                Dictionary<string, string> printData = GetInputTxtData();

                //if (printData.Count == 0)
                //{
                //    MessageBox.Show("请输入打印数据", "提示", MessageBoxButtons.OK);
                //    return;
                //}


                if (isInputError)
                {
                    MessageBox.Show("输入数据有误或者不完整,请先检查后再打印", "提示", MessageBoxButtons.OK);
                    return;
                }

                // 这里做下拉框的绑定
                if (comboBox1.Text == "" || comboBox2.Text == ""
                    || comboBox3.Text == "" || comboBox4.Text == ""
                    || textBox1.Text.Trim() == "" || textBox3.Text.Trim() == "")
                {
                    MessageBox.Show("输入数据有误或者不完整,请先检查后再打印", "提示", MessageBoxButtons.OK);
                    return;
                }
                //string MFile = ReportPath + "\\FRX\\wl.frx";//FastReport设计后的文件保存的路径。
                // 替换原来的 string MFile = ReportPath + "\\FRX\\wl.frx";
                string MFile = Path.Combine(ReportPath, "FRX", "wl.frx");
                if (!File.Exists(MFile))
                {
                    MessageBox.Show(ReportPath.ToString());
                    MessageBox.Show("未找到托盘条码打印样式文件!");
                    return;
                }
                Report report = new Report();
                report.Load(MFile);
                report.PrintSettings.ShowDialog = false;
                PrinterSettings oitem = new PrinterSettings();
                if (report.ShowPrintDialog(out oitem) && oitem.Copies > 0)
                {
                    report.PrintSettings.ShowDialog = false;
                    report.SetParameterValue("Name", printData.Keys.ToList()[0]);//给参数赋值(条码)
                                                                //report.SetParameterValue("No", "456");
                                                                //report.SetParameterValue("Qty", "7");
                                                                //report.SetParameterValue("Supplier", "8");
                    report.SetParameterValue("Barcode", printData[printData.Keys.ToList()[0].ToString()]);
                    report.Print();
                }
                else
                {
                    MessageBox.Show("取消打印");
                }
                report.Dispose();

                #region 原打印逻辑
                //string MFile = ReportPath + "\\FRX\\wl.frx";//FastReport设计后的文件保存的路径。
                //if (!File.Exists(MFile))
                //{
                //    throw new Exception("未找到托盘条码打印样式文件!!!");
                //}
                //Report report = new Report();
                //report.Load(MFile);
                //report.PrintSettings.ShowDialog = false;
                //System.Drawing.Printing.PrinterSettings oitem = new System.Drawing.Printing.PrinterSettings();

                //if (report.ShowPrintDialog(out oitem) && oitem.Copies > 0)
                //{
                //    report.PrintSettings.ShowDialog = false;
                //    report.SetParameterValue("Name", name);//给参数赋值(条码)
                //                                           //report.SetParameterValue("No", "456");
                //                                           //report.SetParameterValue("Qty", "7");
                //                                           //report.SetParameterValue("Supplier", "8");
                //    report.SetParameterValue("Barcode", name);
                //    report.Print();
                //}
                //report.Dispose(); 
                #endregion
            }
            catch (Exception ex)
            {
                MessageBox.Show($"打印异常:{ex.Message}");
            }
        }

        /// <summary>
        /// 获取输入框输入数据    todo应做文本输入格式校验
        /// </summary>
        /// <returns></returns>
        //private List<string> GetInputTxtData()
        //{
        //    List<string> data = new List<string>();

        //    string barcode1 = Txt_barcode1.Text; if (!string.IsNullOrWhiteSpace(barcode1)) { data.Add(barcode1); }
        //    string barcode2 = Txt_barcode2.Text; if (!string.IsNullOrWhiteSpace(barcode2)) { data.Add(barcode2); }
        //    string barcode3 = Txt_barcode3.Text; if (!string.IsNullOrWhiteSpace(barcode3)) { data.Add(barcode3); }
        //    string barcode4 = Txt_barcode4.Text; if (!string.IsNullOrWhiteSpace(barcode4)) { data.Add(barcode4); }
        //    string barcode6 = Txt_barcode6.Text; if (!string.IsNullOrWhiteSpace(barcode6)) { data.Add(barcode6); }
        //    if (data.Count > 1) data.Distinct();  //去除重复条码

        //    return data;
        //}

        private Dictionary<string, string> GetInputTxtData()
        {
            Dictionary<string, string> partCode = new Dictionary<string, string>();
            string Row = "{";

            Row += "'轴承条码':"+$"'{Txt_barcode1.Text}',";
            Row += "'车型':"+$"'{comboBox2.Text}',";
            Row += "'轴承型号':"+$"'{comboBox3.Text}',";
            Row += "'轴承品牌':"+$"'{comboBox4.Text}',";
            Row += "'轴承类别':"+$"'{comboBox1.Text}',";
            Row += "'轴承批次号':"+$"'{textBox1.Text}',";
            Row += "'轴承重量':" + $"'{textBox2.Text}',";
            Row += "'日期':" + $"'{textBox3.Text}',";
            Row += "}";

            partCode.Add(Txt_barcode1.Text, Row);

            return partCode;
        }

        /// <summary>
        /// 肖佼 加的验证方法
        /// </summary>
        /// <param name="sender"></param>
        private void Validaltetion(object sender, CancelEventArgs e)
        {
            TextBox textBox = sender as TextBox;
            if (string.IsNullOrEmpty(textBox.Text))
            {
                errorProvider1.SetError(textBox, "不能为空");
                isInputError = true;
            }
            else
            {
                errorProvider1.SetError(textBox, ""); // 清除错误提示  
                isInputError = false;
            }
        }

        /// <summary>
        /// 输入框文本输入验证   为空时清除,不为空时验证输入是否合法
        /// </summary> 
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void ValidateTextBox(object sender, CancelEventArgs e)
        {
            TextBox textBox = sender as TextBox;
            if (string.IsNullOrEmpty(textBox.Text))
            {
                errorProvider1.SetError(textBox, ""); // 清除错误提示  
                isInputError = false;
            }
            else
            {
                if (!textBox.Text.Contains(","))  // 如果不包含&符号 则提示格式异常  包含则检测格式中的&是否正常
                {
                    errorProvider1.SetError(textBox, "格式不正确");
                    isInputError = true;
                }
                else
                {
                    if (CharCount(textBox.Text))
                    {
                        bool k = false;
                        for (int i = 0; i < textBox.Text.Length; i++)
                        {
                            if (textBox.Text[i] == '（')
                            {
                                k = true;
                            }

                            if(textBox.Text[i] == '）')
                            {
                                k = true;
                            }
                            if(textBox.Text[i] == '，')
                            {
                                k = true;
                            }
                        }

                        if (k)
                        {
                            errorProvider1.SetError(textBox, "格式不正确,符号不可为中文符号");
                            isInputError = true;
                        }
                        else
                        {
                            errorProvider1.SetError(textBox, ""); // 清除错误提示  
                            isInputError = false;
                        }

                        
                    }
                    else
                    {
                        errorProvider1.SetError(textBox, "格式不正确");
                        isInputError = true;
                    }
                }
            }
        }

        /// <summary>
        /// 窗体载入事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        //private void 打印机_Load(object sender, EventArgs e)
        //{
        //    //载入时为每个输入框 订阅文本校验事件
        //    Txt_barcode1.Validating += new CancelEventHandler(ValidateTextBox);
        //    Txt_barcode2.Validating += new CancelEventHandler(ValidateTextBox);
        //    Txt_barcode3.Validating += new CancelEventHandler(ValidateTextBox);
        //    Txt_barcode4.Validating += new CancelEventHandler(ValidateTextBox);
        //    Txt_barcode5.Validating += new CancelEventHandler(ValidateTextBox);
        //    Txt_barcode6.Validating += new CancelEventHandler(ValidateTextBox);
        //    Txt_barcode7.Validating += new CancelEventHandler(ValidateTextBox);
        //    Txt_barcode8.Validating += new CancelEventHandler(ValidateTextBox);
        //    Txt_barcode9.Validating += new CancelEventHandler(ValidateTextBox);
        //    Txt_barcode10.Validating += new CancelEventHandler(ValidateTextBox);
        //}
        
        // 肖佼 更改的打印机_Load
        private void 打印机_Load(object sender, EventArgs e)
        {
            //载入时为每个输入框 订阅文本校验事件
            Txt_barcode1.Validating += new CancelEventHandler(Validaltetion);
            //Txt_barcode2.Validating += new CancelEventHandler(Validaltetion);
            //Txt_barcode3.Validating += new CancelEventHandler(Validaltetion);
            //Txt_barcode4.Validating += new CancelEventHandler(Validaltetion);
            textBox1.Validating += new CancelEventHandler(Validaltetion);
            textBox2.Validating += new CancelEventHandler(Validaltetion);
            //Txt_barcode5.Validating += new CancelEventHandler(ValidateTextBox);
            //Txt_barcode6.Validating += new CancelEventHandler(Validaltetion);
            //Txt_barcode7.Validating += new CancelEventHandler(ValidateTextBox);
            //Txt_barcode8.Validating += new CancelEventHandler(ValidateTextBox);
            //Txt_barcode9.Validating += new CancelEventHandler(ValidateTextBox);
            //Txt_barcode10.Validating += new CancelEventHandler(ValidateTextBox);
        }



        private bool CharCount(string str)
        {
            int SumCount = 4;
            int strCoutn = 0;
            foreach (var item in str.ToCharArray())
            {
                if (item.Equals(',')) strCoutn++;
            }
            return strCoutn == SumCount;
        }

        private void btn_SelectFile_Click(object sender, EventArgs e)
        {
            OpenFileDialog openFileDialog = new OpenFileDialog();
            //openFileDialog.InitialDirectory = "c:\\"; // 设置初始目录
            openFileDialog.Filter = "Excel Files (*.xls;*.xlsx)|*.xls;*.xlsx"; // 设置文件过滤器
            openFileDialog.Title = "选择Excel文件";
            openFileDialog.FilterIndex = 2;
            openFileDialog.RestoreDirectory = true;

            if (openFileDialog.ShowDialog() == DialogResult.OK) // 显示对话框
            {
                // 获取选中文件的路径
                string filePath = openFileDialog.FileName;
                txt_file.Text = filePath;
            }
        }

        private void btn_filePrint_Click(object sender, EventArgs e)
        {
            try
            {
                string filePath = txt_file.Text;
                if (string.IsNullOrEmpty(filePath))
                {
                    MessageBox.Show("请先选择文件");
                    return;
                }

                FileInfo file = new FileInfo(filePath);
                if (!file.Exists)
                {
                    MessageBox.Show("未找到上传的文件,请重新选择");
                    return;
                }
                string errormsg = string.Empty;
                //List<string> partCode = new List<string>();
                Dictionary<string,string> partCode = new Dictionary<string,string>();
                List<string> line_Name = new List<string>();

                using (ExcelPackage package = new ExcelPackage(file))
                {
                    if (package.Workbook.Worksheets.Count == 0 || package.Workbook.Worksheets.FirstOrDefault().Dimension.End.Row <= 1)
                    {
                        MessageBox.Show("表格未导入数据");
                        return;
                    }

                    ExcelWorksheet sheet = package.Workbook.Worksheets.FirstOrDefault();
                    if (sheet != null)
                    {
                        //string columnCNName = sheet.Cells[1, 1].Value?.ToString()?.Trim();
                        //if (columnCNName != "part_code")
                        //{
                        //    MessageBox.Show($"导入模板异常,请检查文件中的A1项是否为'part_code'");
                        //    return;
                        //}
                        
                        for (int m = sheet.Dimension.Start.Row + 1, n = sheet.Dimension.End.Row; m <= n; m++)
                        {
                            string Temp_Row = "{";
                            string value = "";
                            for (int j = sheet.Dimension.Start.Column, k = sheet.Dimension.End.Column; j <= k; j++)
                            {
                                string tempstr = $"'{sheet.Cells[1, j].Value?.ToString()}':'{sheet.Cells[m, j].Value?.ToString()}',";
                                Temp_Row += tempstr;
                                if (j == 1)
                                {
                                    // line_Name.Add(value);
                                    value = sheet.Cells[m, j].Value?.ToString();
                                    
                                }
                                //if (value != null)
                                //{
                                //    //todo 数据验证  --格式验证 等
                                //    if (CharCount(value))
                                //    {
                                //        partCode.Add(value);
                                //    }
                                //    else
                                //    {
                                //        errormsg += $"第{m}行编码验证未通过,格式异常。{Environment.NewLine}";
                                //        continue;
                                //    }
                                //}
                                //else
                                //{
                                //    errormsg += $"第{m}行编码验证未通过,不能为空。{Environment.NewLine}";
                                //    continue;
                                //}
                            }
                            Temp_Row += "}";
                            //partCode.Add(Temp_Row);
                            partCode[value] = Temp_Row;
                        }
                    }
                }
                if (!string.IsNullOrEmpty(errormsg))
                {
                    MessageBox.Show(errormsg);
                    return;
                }
                else
                {
                    //string MFile = ReportPath + "\\FRX\\wl.frx";//FastReport设计后的文件保存的路径。

                    // 替换原来的 string MFile = ReportPath + "\\FRX\\wl.frx";
                    string MFile = Path.Combine(ReportPath, "FRX", "wl.frx");
                    if (!File.Exists(MFile))
                    {
                        MessageBox.Show("未找到托盘条码打印样式文件!!!");
                        return;
                    }

                    Report report = new Report();
                    report.Load(MFile);
                    report.PrintSettings.ShowDialog = false;
                    PrinterSettings oitem = new PrinterSettings();
                    if (report.ShowPrintDialog(out oitem) && oitem.Copies > 0)
                    {
                        //foreach (string data in partCode)
                        //{

                        //    report.SetParameterValue("Barcode", data);

                        //}
                        //foreach (var item in line_Name)
                        //{
                        //    report.PrintSettings.ShowDialog = false;
                        //    report.SetParameterValue("Name", item);//给参数赋值(条码)
                        //                                                         //report.SetParameterValue("No", "456");
                        //                                                         //report.SetParameterValue("Qty", "7");
                        //                                                         //report.SetParameterValue("Supplier", "8");
                        //}
                        //report.Print();
                        foreach (KeyValuePair<string, string> kvp in partCode)
                        {
                            report.PrintSettings.ShowDialog = false;
                            report.SetParameterValue("Name", kvp.Key);//给参数赋值(条码)

                            report.SetParameterValue("Barcode", kvp.Value);
                            report.Print();
                        }
                    }
                    else
                    {
                        MessageBox.Show("取消打印");
                        return;
                    }
                    report.Dispose();

                    MessageBox.Show("打印成功");
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show($"打印异常:{ex.Message}");
            }

            //try
            //{
            //    string filePath = txt_file.Text;
            //    if (string.IsNullOrEmpty(filePath))
            //    {
            //        MessageBox.Show("请先选择文件");
            //        return;
            //    }

            //    FileInfo file = new FileInfo(filePath);
            //    if (!file.Exists)
            //    {
            //        MessageBox.Show("文件不存在，请检查路径");
            //        return;
            //    }

            //    // 1. 强制设置EPPlus许可证（必须）
            //    ExcelPackage.LicenseContext = OfficeOpenXml.LicenseContext.NonCommercial;
            //    List<string> dataList = new List<string>();

            //    using (ExcelPackage package = new ExcelPackage(file))
            //    {
            //        // 2. 修复索引问题：用First()取第一个工作表（最安全）
            //        if (package.Workbook.Worksheets.Count == 0)
            //        {
            //            MessageBox.Show("表格中无任何工作表");
            //            return;
            //        }
            //        ExcelWorksheet sheet = package.Workbook.Worksheets.First();

            //        // 3. 读取前20行A列（列索引1），覆盖你的数据范围
            //        int readMaxRow = 20; // 可根据你的表格调整
            //        for (int row = 1; row <= readMaxRow; row++)
            //        {
            //            // 读取A列单元格，处理空值
            //            string cellValue = sheet.Cells[row, 1].Value?.ToString()?.Trim();
            //            if (!string.IsNullOrEmpty(cellValue))
            //            {
            //                dataList.Add($"第{row}行：{cellValue}");
            //            }
            //        }
            //    }

            //    // 4. 弹窗显示读取结果（直观验证）
            //    if (dataList.Count > 0)
            //    {
            //        MessageBox.Show("✅ 读取到的数据：\n" + string.Join("\n", dataList));
            //    }
            //    else
            //    {
            //        MessageBox.Show("❌ 未读取到任何数据，请检查：\n1. 表格A列是否有数据\n2. 数据是否为非空文本");
            //    }
            //}
            //catch (Exception ex)
            //{
            //    // 显示完整错误信息（方便定位）
            //    MessageBox.Show($"❌ 读取失败：\n错误信息：{ex.Message}\n调用堆栈：{ex.StackTrace}");
            //}
        }

        private void label14_Click(object sender, EventArgs e)
        {

        }

        private void Txt_barcode1_TextChanged(object sender, EventArgs e)
        {

        }

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

        private void groupBox2_Enter(object sender, EventArgs e)
        {

        }
    }
}