using System;
using System.Data;
using System.Windows.Forms;
using System.Drawing.Printing;
using System.Linq;
using System.Collections.Generic;
using System.IO;
using System.Text;
using System.Configuration;
using gregn6Lib;
using BLL;
using System.Drawing;

namespace BarcodePrintEngine
{
    public partial class Gy_BarcodePrint : Form
    {
        public DBHelper oCn = new DBHelper();

        // 列索引常
        private const int COL_ID = 0;          
        private const int COL_BARCODE = 1;    
        private const int COL_MATERIALCODE = 2; 
        private const int COL_MATERIALNAME = 3;
        private const int COL_QTY = 4;        
        private const int COL_ISPRINTED = 5;   
        private const int COL_PRINTDATE = 6;  
        private const int COL_PRINTERNAME = 7; 

        // 报表相关
        private GridppReport Report;
        private DataGridView _printGrid;
        private int _selectColIndex = -1;

        // 自动打印防重入标志
        private bool isAutoPrinting = false;

        // 配置文件路径（设备别名和打印机共用）
        private readonly string deviceConfigPath;

        public Gy_BarcodePrint()
        {
            InitializeComponent();

            // 设置配置文件路径
            deviceConfigPath = AppDomain.CurrentDomain.BaseDirectory + "./Config/Device.config";

            this.StartPosition = FormStartPosition.CenterScreen;
            this.Load += Gy_BarcodePrint_Load;

            // 从配置文件加载打印机
            LoadDefaultPrinterFromConfig();
            InitGrids();

            // 绑定设备别名事件
            txtDeviceAlias.Leave += TxtDeviceAlias_Leave;
            txtDeviceAlias.KeyDown += TxtDeviceAlias_KeyDown;
            txtDeviceAlias.TextChanged += TxtDeviceAlias_TextChanged;
            txtPrinter.TextChanged += TxtPrinter_TextChanged;

            // 初始状态：按钮禁用，定时器未启动
            btnToggleAutoPrint.Enabled = false;
            timer1.Interval = 60000;
            timer1.Stop();
        }

        #region 配置文件读写（通用）

        /// <summary>
        /// 确保配置文件存在，若不存在则创建空的 appSettings 文件
        /// </summary>
        private void EnsureConfigFileExists(string configPath)
        {
            if (File.Exists(configPath)) return;

            string dir = Path.GetDirectoryName(configPath);
            if (!Directory.Exists(dir))
                Directory.CreateDirectory(dir);

            string content = @"<?xml version=""1.0"" encoding=""utf-8""?>
<configuration>
  <appSettings>
  </appSettings>
</configuration>";
            File.WriteAllText(configPath, content, Encoding.UTF8);
        }

        /// <summary>
        /// 从指定配置文件读取键值
        /// </summary>
        private string GetConfigKey(string configPath, string key)
        {
            EnsureConfigFileExists(configPath);
            var config = ConfigurationManager.OpenMappedExeConfiguration(
                new ExeConfigurationFileMap { ExeConfigFilename = configPath },
                ConfigurationUserLevel.None);
            return config.AppSettings.Settings[key]?.Value ?? string.Empty;
        }

        /// <summary>
        /// 向指定配置文件写入键值
        /// </summary>
        private void SetConfigKey(string configPath, string key, string value)
        {
            EnsureConfigFileExists(configPath);
            var config = ConfigurationManager.OpenMappedExeConfiguration(
                new ExeConfigurationFileMap { ExeConfigFilename = configPath },
                ConfigurationUserLevel.None);
            if (config.AppSettings.Settings[key] == null)
                config.AppSettings.Settings.Add(key, value);
            else
                config.AppSettings.Settings[key].Value = value;
            config.Save(ConfigurationSaveMode.Modified);
            ConfigurationManager.RefreshSection("appSettings");
        }

        #endregion

        #region 打印机配置（改用配置文件）

        /// <summary>
        /// 从配置文件加载默认打印机
        /// </summary>
        private void LoadDefaultPrinterFromConfig()
        {
            string saved = GetConfigKey(deviceConfigPath, "DefaultPrinter");
            if (!string.IsNullOrEmpty(saved) && PrinterSettings.InstalledPrinters.Cast<string>().Contains(saved))
                txtPrinter.Text = saved;
            else
                txtPrinter.Text = "（未选择）";
        }

        /// <summary>
        /// 保存默认打印机到配置文件
        /// </summary>
        private void SaveDefaultPrinterToConfig(string printerName)
        {
            SetConfigKey(deviceConfigPath, "DefaultPrinter", printerName);
        }

        #endregion

        #region 窗体加载 – 读取配置、加载数据，但不启动定时器
        private void Gy_BarcodePrint_Load(object sender, EventArgs e)
        {
            // 读取设备别名
            string alias = GetConfigKey(deviceConfigPath, "DeviceAlias");
            txtDeviceAlias.Text = alias ?? "";

            // 加载数据（按别名过滤）
            LoadData();

            // 检查条件更新启动按钮状态
            UpdateStartButtonState();

            LogService.Write("条码打印程序启动，等待用户启动自动打印服务。");
        }
        #endregion

        #region 启动/停止自动打印按钮
        private void btnToggleAutoPrint_Click(object sender, EventArgs e)
        {
            if (timer1.Enabled)
            {
                // 正在运行 → 准备停止，先确认
                DialogResult result = MessageBox.Show(
                    "确认停止自动打印程序吗？",
                    "确认停止",
                    MessageBoxButtons.YesNo,
                    MessageBoxIcon.Question
                );
                if (result == DialogResult.Yes)
                {
                    timer1.Stop();
                    btnToggleAutoPrint.Text = "启动";
                    btnToggleAutoPrint.BackColor = Color.LightGreen;
                    LogService.Write("自动打印服务已停止。");
                }
                // 如果用户取消，不执行任何操作
            }
            else
            {
                // 未运行 → 启动
                if (!IsPrinterAndAliasValid())
                {
                    MessageBox.Show("请先选择有效的打印机并填写设备别名。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                timer1.Start();
                btnToggleAutoPrint.Text = "停止";
                btnToggleAutoPrint.BackColor = Color.Orange;
                LogService.Write("自动打印服务已启动。");
            }
        }

        /// <summary>
        /// 检查打印机和别名是否有效
        /// </summary>
        private bool IsPrinterAndAliasValid()
        {
            string printer = txtPrinter.Text.Trim();
            string alias = txtDeviceAlias.Text.Trim();
            bool printerOk = !string.IsNullOrEmpty(printer) && printer != "（未选择）" && PrinterSettings.InstalledPrinters.Cast<string>().Contains(printer);
            bool aliasOk = !string.IsNullOrEmpty(alias);
            return printerOk && aliasOk;
        }

        /// <summary>
        /// 更新启动按钮的启用状态
        /// </summary>
        private void UpdateStartButtonState()
        {
            if (!timer1.Enabled)
            {
                // 停止状态
                bool canStart = IsPrinterAndAliasValid();
                btnToggleAutoPrint.Enabled = canStart;
                if (canStart)
                {
                    btnToggleAutoPrint.Text = "启动";
                    btnToggleAutoPrint.BackColor = Color.LightGreen;
                }
                else
                {
                    // 当条件不满足时，按钮不可用，颜色可置灰或恢复默认
                    btnToggleAutoPrint.Text = "启动";
                    btnToggleAutoPrint.BackColor = SystemColors.Control; // 或保留绿色但禁用，视觉上灰色会覆盖
                }
            }
            else
            {
                // 运行状态
                btnToggleAutoPrint.Enabled = true;
                btnToggleAutoPrint.Text = "停止";
                btnToggleAutoPrint.BackColor = Color.Orange;
            }
        }

        private void TxtPrinter_TextChanged(object sender, EventArgs e)
        {
            if (timer1.Enabled)
            {
                timer1.Stop();
                btnToggleAutoPrint.Text = "启动";
                LogService.Write("打印机变更，自动打印服务已自动停止。");
            }
            UpdateStartButtonState();
        }

        private void TxtDeviceAlias_TextChanged(object sender, EventArgs e)
        {
            if (timer1.Enabled)
            {
                timer1.Stop();
                btnToggleAutoPrint.Text = "启动";
                LogService.Write("设备别名变更，自动打印服务已自动停止。");
            }
            UpdateStartButtonState();
        }
        #endregion

        #region 设备别名 – 保存与刷新
        private void TxtDeviceAlias_Leave(object sender, EventArgs e)
        {
            SaveDeviceAlias();
        }

        private void TxtDeviceAlias_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                SaveDeviceAlias();
                e.SuppressKeyPress = true;
            }
        }

        private void SaveDeviceAlias()
        {
            string alias = txtDeviceAlias.Text.Trim();
            SetConfigKey(deviceConfigPath, "DeviceAlias", alias);
            LoadData(); // 刷新数据
            LogService.Write($"设备别名已更新为：{alias}");
        }
        #endregion

        #region 定时器 Tick – 自动打印逻辑
        private void timer1_Tick(object sender, EventArgs e)
        {
            if (isAutoPrinting) return;
            isAutoPrinting = true;

            try
            {
                this.Invoke(new Action(() =>
                {
                    string alias = txtDeviceAlias.Text.Trim();
                    if (string.IsNullOrEmpty(alias))
                    {
                        LogService.Write("自动打印: 未设置设备别名，跳过");
                        return;
                    }

                    if (string.IsNullOrEmpty(txtPrinter.Text) || txtPrinter.Text == "（未选择）")
                    {
                        LogService.Write("自动打印: 未选择打印机，跳过");
                        return;
                    }

                    string templateName = GetConfigKey(AppDomain.CurrentDomain.BaseDirectory + "./Config/PWD.config", "PrintTemplate");
                    if (string.IsNullOrEmpty(templateName) || templateName == "undefined")
                    {
                        LogService.Write("自动打印: 未配置打印模板，跳过");
                        return;
                    }

                    string safeAlias = alias.Replace("'", "''");

                    string sql = $@"
                        SELECT 
                            a.HItemId AS id,
                            a.HBarCode AS 条码编号,
                            a.HQty AS 数量,
                            a.HIsPrintSuccess AS 是否打印成功,
                            a.HLastPrintDate AS 打印时间,
                            a.HPrintName AS 打印机名称
                        FROM Gy_BarCodeBill_Split a
                        INNER JOIN Gy_Material b ON a.HMaterID = b.HItemID
                        WHERE a.HIsPrintSuccess = 0 AND ISNULL(a.HPrintName,'') = '{safeAlias}'
                        ORDER BY a.HItemId";

                    DataSet ds = oCn.RunProcReturn(sql, "AutoPrintQuery");
                    if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
                        return;

                    List<string> barcodeList = new List<string>();
                    List<int> idList = new List<int>();
                    foreach (DataRow dr in ds.Tables[0].Rows)
                    {
                        string barcode = dr["条码编号"].ToString().Trim();
                        if (string.IsNullOrEmpty(barcode)) continue;
                        barcodeList.Add(barcode.Replace("'", "''"));
                        idList.Add(Convert.ToInt32(dr["id"]));
                    }

                    if (barcodeList.Count == 0) return;

                    string inClause = string.Join(",", barcodeList.Select(b => "'" + b + "'"));
                    string viewSql = $@"
                        SELECT 
                            条码编号,
                            物料代码,
                            物料名称,
                            规格型号,
                            批号,
                            数量,
                            供应商,
                            组托单号,
                            生产日期,
                            源单单号
                        FROM h_v_IF_BarCodeBillList_Split
                        WHERE 条码编号 IN ({inClause})";

                    DataSet dsView = oCn.RunProcReturn(viewSql, "AutoPrintView");
                    if (dsView == null || dsView.Tables.Count == 0 || dsView.Tables[0].Rows.Count == 0)
                        return;

                    DataTable dtPrint = new DataTable();
                    dtPrint.Columns.Add("条码编号", typeof(string));
                    dtPrint.Columns.Add("物料代码", typeof(string));
                    dtPrint.Columns.Add("物料名称", typeof(string));
                    dtPrint.Columns.Add("规格型号", typeof(string));
                    dtPrint.Columns.Add("批号", typeof(string));
                    dtPrint.Columns.Add("数量", typeof(string));
                    dtPrint.Columns.Add("供应商", typeof(string));
                    dtPrint.Columns.Add("组托单号", typeof(string));
                    dtPrint.Columns.Add("生产日期", typeof(string));
                    dtPrint.Columns.Add("源单单号", typeof(string));

                    foreach (DataRow dr in dsView.Tables[0].Rows)
                    {
                        DataRow newRow = dtPrint.NewRow();
                        newRow["条码编号"] = dr["条码编号"].ToString();
                        newRow["物料代码"] = dr["物料代码"].ToString();
                        newRow["物料名称"] = dr["物料名称"].ToString();
                        newRow["规格型号"] = dr["规格型号"].ToString();
                        newRow["批号"] = dr["批号"].ToString();
                        object qty = dr["数量"];
                        newRow["数量"] = qty == DBNull.Value ? "0" : Convert.ToDecimal(qty).ToString("0");
                        newRow["供应商"] = dr["供应商"].ToString();
                        newRow["组托单号"] = dr["组托单号"].ToString();
                        object prodDate = dr["生产日期"];
                        newRow["生产日期"] = prodDate == DBNull.Value ? "" : Convert.ToDateTime(prodDate).ToString("yyyy-MM-dd");
                        newRow["源单单号"] = dr["源单单号"].ToString();
                        dtPrint.Rows.Add(newRow);
                    }

                    DataGridView tempGrid = new DataGridView();
                    tempGrid.DataSource = dtPrint;
                    DataGridViewCheckBoxColumn selectCol = new DataGridViewCheckBoxColumn();
                    selectCol.HeaderText = "选择";
                    selectCol.Name = "选择";
                    tempGrid.Columns.Insert(0, selectCol);
                    foreach (DataGridViewRow row in tempGrid.Rows)
                    {
                        row.Cells["选择"].Value = true;
                    }

                    Sub_SetReport(templateName, tempGrid);
                    Report.Printer.PrinterName = txtPrinter.Text.Trim();
                    //Report.PrintPreview(true);  // 弹出预览窗口
                    Report.Print(false);

                    if (idList.Count > 0)
                    {
                        string ids = string.Join(",", idList);
                        string updateSql = $@"UPDATE Gy_BarCodeBill_Split SET HIsPrintSuccess = 1, HLastPrintDate = GETDATE() WHERE HItemId IN ({ids})";
                        oCn.RunProc(updateSql);
                    }

                    LoadData();
                    LogService.Write($"自动打印完成，共打印 {barcodeList.Count} 个条码。");
                }));
            }
            catch (Exception ex)
            {
                LogService.Write("自动打印异常：" + ex.Message);
            }
            finally
            {
                isAutoPrinting = false;
            }
        }
        #endregion

        #region 打印机选择（使用配置文件）
        private void btnSelectPrinter_Click(object sender, EventArgs e)
        {
            using (PrintDialog pd = new PrintDialog())
            {
                pd.PrinterSettings = new PrinterSettings();
                if (pd.ShowDialog() == DialogResult.OK)
                {
                    string printer = pd.PrinterSettings.PrinterName;
                    txtPrinter.Text = printer;
                    SaveDefaultPrinterToConfig(printer);
                }
            }
        }
        #endregion

        #region 表格初始化
        private void InitGrids()
        {
            grdUnprinted.ColumnCount = 8;
            grdUnprinted.Columns[COL_ID].HeaderText = "ID";
            grdUnprinted.Columns[COL_ID].Visible = false;
            grdUnprinted.Columns[COL_BARCODE].HeaderText = "条码编号";
            grdUnprinted.Columns[COL_BARCODE].Width = 200;
            grdUnprinted.Columns[COL_MATERIALCODE].HeaderText = "物料代码";
            grdUnprinted.Columns[COL_MATERIALCODE].Width = 120;
            grdUnprinted.Columns[COL_MATERIALNAME].HeaderText = "物料名称";
            grdUnprinted.Columns[COL_MATERIALNAME].Width = 200;
            grdUnprinted.Columns[COL_QTY].HeaderText = "数量";
            grdUnprinted.Columns[COL_QTY].Width = 70;
            grdUnprinted.Columns[COL_ISPRINTED].HeaderText = "是否打印";
            grdUnprinted.Columns[COL_ISPRINTED].Width = 100;
            grdUnprinted.Columns[COL_PRINTDATE].HeaderText = "打印时间";
            grdUnprinted.Columns[COL_PRINTDATE].Width = 150;
            grdUnprinted.Columns[COL_PRINTERNAME].HeaderText = "打印机名称";
            grdUnprinted.Columns[COL_PRINTERNAME].Width = 200;

            grdUnprinted.ReadOnly = true;
            grdUnprinted.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
            grdUnprinted.MultiSelect = true;


            grdPrinted.ColumnCount = 8;
            grdPrinted.Columns[COL_ID].HeaderText = "ID";
            grdPrinted.Columns[COL_ID].Visible = false;
            grdPrinted.Columns[COL_BARCODE].HeaderText = "条码编号";
            grdPrinted.Columns[COL_BARCODE].Width = 200;
            grdPrinted.Columns[COL_MATERIALCODE].HeaderText = "物料代码";
            grdPrinted.Columns[COL_MATERIALCODE].Width = 120;
            grdPrinted.Columns[COL_MATERIALNAME].HeaderText = "物料名称";
            grdPrinted.Columns[COL_MATERIALNAME].Width = 200;
            grdPrinted.Columns[COL_QTY].HeaderText = "数量";
            grdPrinted.Columns[COL_QTY].Width = 70;
            grdPrinted.Columns[COL_ISPRINTED].HeaderText = "是否打印";
            grdPrinted.Columns[COL_ISPRINTED].Width = 100;
            grdPrinted.Columns[COL_PRINTDATE].HeaderText = "打印时间";
            grdPrinted.Columns[COL_PRINTDATE].Width = 180;
            grdPrinted.Columns[COL_PRINTERNAME].HeaderText = "打印机名称";
            grdPrinted.Columns[COL_PRINTERNAME].Width = 200;

            grdPrinted.ReadOnly = true;
            grdPrinted.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
            grdPrinted.MultiSelect = true;

        }
        #endregion

        #region 加载数据
        private void LoadData()
        {
            try
            {
                string alias = txtDeviceAlias.Text.Trim();
                if (string.IsNullOrEmpty(alias))
                {
                    grdUnprinted.Rows.Clear();
                    grdPrinted.Rows.Clear();
                    return;
                }
                string safeAlias = alias.Replace("'", "''");

                string sql = $@"
                    SELECT 
                        a.HItemId AS id,                    
                        a.HBarCode AS 条码编号,
                        b.HNumber AS 物料代码,
                        b.HName AS 物料名称,
                        a.HQty AS 数量,
                        a.HIsPrintSuccess AS 是否打印成功,
                        a.HLastPrintDate AS 打印时间,
                        a.HPrintName AS 打印机名称
                    FROM Gy_BarCodeBill_Split a
                    INNER JOIN Gy_Material b ON a.HMaterID = b.HItemID
                    WHERE ISNULL(a.HPrintName,'') = '{safeAlias}'
                    ORDER BY a.HItemId";

                DataSet ds = oCn.RunProcReturn(sql, "LoadBarCodeSplit");
                if (ds == null || ds.Tables.Count == 0 || ds.Tables[0].Rows.Count == 0)
                {
                    grdUnprinted.Rows.Clear();
                    grdPrinted.Rows.Clear();
                    return;
                }

                grdUnprinted.Rows.Clear();
                grdPrinted.Rows.Clear();

                foreach (DataRow dr in ds.Tables[0].Rows)
                {
                    object[] rowData = new object[8];  // 8列
                    rowData[COL_ID] = dr["id"];
                    rowData[COL_BARCODE] = dr["条码编号"].ToString();
                    rowData[COL_MATERIALCODE] = dr["物料代码"]?.ToString() ?? "";
                    rowData[COL_MATERIALNAME] = dr["物料名称"]?.ToString() ?? "";

                    // 数量（索引4）
                    object qtyObj = dr["数量"];
                    if (qtyObj == DBNull.Value || qtyObj == null)
                        rowData[COL_QTY] = "0";
                    else
                    {
                        try { decimal qty = Convert.ToDecimal(qtyObj); rowData[COL_QTY] = qty.ToString("0"); }
                        catch { rowData[COL_QTY] = qtyObj.ToString(); }
                    }

                    // 是否打印（索引5）
                    bool isPrinted = (dr["是否打印成功"] != DBNull.Value && Convert.ToBoolean(dr["是否打印成功"]));
                    rowData[COL_ISPRINTED] = isPrinted ? "是" : "否";

                    // 打印时间（索引6）
                    rowData[COL_PRINTDATE] = dr["打印时间"] == DBNull.Value ? "" : Convert.ToDateTime(dr["打印时间"]).ToString("yyyy-MM-dd HH:mm");

                    // 打印机名称（索引7）
                    rowData[COL_PRINTERNAME] = dr["打印机名称"].ToString();

                    if (isPrinted)
                        grdPrinted.Rows.Add(rowData);
                    else
                        grdUnprinted.Rows.Add(rowData);
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show("加载数据失败：" + ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                LogService.Write("LoadData异常：" + ex.Message);
            }
        }
        #endregion

        #region 打印功能（通用）
        public static String GetConfigKey_Print(String configPath, String key)
        {
            Configuration ConfigurationInstance =ConfigurationManager.OpenMappedExeConfiguration(
                    new ExeConfigurationFileMap()
                    {
                        ExeConfigFilename = configPath
                    },
                    ConfigurationUserLevel.None);

            if (ConfigurationInstance.AppSettings.Settings[key] != null)
                return ConfigurationInstance.AppSettings.Settings[key].Value;
            else
                return string.Empty;
        }

        private void Sub_SetReport(string templateName, DataGridView grid)
        {
            Report = new GridppReport();
            string fullPath = Pub_Class.ClsPub.AppPath + @"" + templateName + ".grf";
            Report.LoadFromFile(fullPath);
            Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord);
            Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable);

            _printGrid = grid;
            _selectColIndex = Fun_GetCol("选择", grid);
        }

        private void ReportBeforePostRecord() { }

        private void ReportFetchRecordByDataTable()
        {
            try
            {
                DataTable dt = null;

                // 从 DataGridView 的数据源中获取 DataTable
                if (_printGrid.DataSource is DataTable)
                {
                    dt = (DataTable)_printGrid.DataSource;
                }
                else if (_printGrid.DataSource is DataView)
                {
                    dt = ((DataView)_printGrid.DataSource).Table;
                }
                else if (_printGrid.DataSource is BindingSource)
                {
                    var bs = (BindingSource)_printGrid.DataSource;
                    if (bs.DataSource is DataTable) dt = (DataTable)bs.DataSource;
                    else if (bs.DataSource is DataView) dt = ((DataView)bs.DataSource).Table;
                }

                if (dt == null)
                {
                    LogService.Write("打印数据源不是 DataTable/DataView，无法填充报表");
                    return;
                }
            
                Utility.FillRecordToReport(Report, dt);
            }
            catch (Exception ex)
            {
                LogService.Write("ReportFetchRecordByDataTable异常：" + ex.Message);
            }
        }

        private int Fun_GetCol(string colName, DataGridView grid)
        {
            for (int i = 0; i < grid.Columns.Count; i++)
            {
                if (grid.Columns[i].HeaderText == colName)
                    return i;
            }
            return -1;
        }

        private DataGridView GetCurrentGrid()
        {
            if (tabControl1.SelectedTab == tabPageUnprinted)
                return grdUnprinted;
            else if (tabControl1.SelectedTab == tabPagePrinted)
                return grdPrinted;
            else
                return null;
        }
        #endregion

        #region 手动打印按钮
        private void btnPrintBarcode_Click(object sender, EventArgs e)
        {
            DataGridView currentGrid = GetCurrentGrid();
            if (currentGrid == null || currentGrid.SelectedRows.Count == 0)
            {
                MessageBox.Show("请先在当前页签中选择要打印的行。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
                return;
            }

            if (string.IsNullOrEmpty(txtPrinter.Text) || txtPrinter.Text == "（未选择）")
            {
                MessageBox.Show("请先选择打印机。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                return;
            }

            if (!PrinterSettings.InstalledPrinters.Cast<string>().Contains(txtPrinter.Text))
            {
                MessageBox.Show("所选打印机不可用，请重新选择。", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }

            string templateName = GetConfigKey_Print(AppDomain.CurrentDomain.BaseDirectory + "./Config/PWD.config", "PrintTemplate");
            if (string.IsNullOrEmpty(templateName) || templateName == "undefined")
            {
                MessageBox.Show("未配置打印模板（PrintTemplate），请在配置文件中设置。", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }

            try
            {
                List<string> barcodeList = new List<string>();
                List<int> idList = new List<int>();

                foreach (DataGridViewRow row in currentGrid.SelectedRows)
                {
                    object barcodeObj = row.Cells[COL_BARCODE].Value;
                    if (barcodeObj == null || barcodeObj == DBNull.Value) continue;
                    string barcode = barcodeObj.ToString().Trim();
                    if (string.IsNullOrEmpty(barcode)) continue;

                    object idObj = row.Cells[COL_ID].Value;
                    if (idObj == null || idObj == DBNull.Value) continue;
                    int id;
                    try { id = Convert.ToInt32(idObj); }
                    catch { continue; }

                    barcodeList.Add(barcode.Replace("'", "''"));
                    idList.Add(id);
                }

                if (barcodeList.Count == 0)
                {
                    MessageBox.Show("选中行中无有效的条码编号。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }

                string inClause = string.Join(",", barcodeList.Select(b => "'" + b + "'"));
                string viewSql = $@"
                    SELECT 
                        条码编号,
                        物料代码,
                        物料名称,
                        规格型号,
                        批号,
                        数量,
                        供应商,
                        组托单号,
                        生产日期,
                        源单单号
                    FROM h_v_IF_BarCodeBillList_Split
                    WHERE 条码编号 IN ({inClause})";

                DataSet dsView = oCn.RunProcReturn(viewSql, "ViewData");
                if (dsView == null || dsView.Tables.Count == 0 || dsView.Tables[0].Rows.Count == 0)
                {
                    MessageBox.Show("未查询到有效的条码详情，请检查数据。", "提示", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }

                DataTable dtPrint = new DataTable();
                dtPrint.Columns.Add("条码编号", typeof(string));
                dtPrint.Columns.Add("物料代码", typeof(string));
                dtPrint.Columns.Add("物料名称", typeof(string));
                dtPrint.Columns.Add("规格型号", typeof(string));
                dtPrint.Columns.Add("批号", typeof(string));
                dtPrint.Columns.Add("数量", typeof(string));
                dtPrint.Columns.Add("供应商", typeof(string));
                dtPrint.Columns.Add("组托单号", typeof(string));
                dtPrint.Columns.Add("生产日期", typeof(string));
                dtPrint.Columns.Add("源单单号", typeof(string));

                foreach (DataRow dr in dsView.Tables[0].Rows)
                {
                    DataRow newRow = dtPrint.NewRow();
                    newRow["条码编号"] = dr["条码编号"].ToString();
                    newRow["物料代码"] = dr["物料代码"].ToString();
                    newRow["物料名称"] = dr["物料名称"].ToString();
                    newRow["规格型号"] = dr["规格型号"].ToString();
                    newRow["批号"] = dr["批号"].ToString();
                    object qty = dr["数量"];
                    newRow["数量"] = qty == DBNull.Value ? "0" : Convert.ToDecimal(qty).ToString("0");
                    newRow["供应商"] = dr["供应商"].ToString();
                    newRow["组托单号"] = dr["组托单号"].ToString();
                    object prodDate = dr["生产日期"];
                    newRow["生产日期"] = prodDate == DBNull.Value ? "" : Convert.ToDateTime(prodDate).ToString("yyyy-MM-dd");
                    newRow["源单单号"] = dr["源单单号"].ToString();
                    dtPrint.Rows.Add(newRow);
                }

                DataGridView tempGrid = new DataGridView();
                tempGrid.DataSource = dtPrint;
                DataGridViewCheckBoxColumn selectCol = new DataGridViewCheckBoxColumn();
                selectCol.HeaderText = "选择";
                selectCol.Name = "选择";
                tempGrid.Columns.Insert(0, selectCol);
                foreach (DataGridViewRow row in tempGrid.Rows)
                {
                    row.Cells["选择"].Value = true;
                }

                Sub_SetReport(templateName, tempGrid);
                Report.Printer.PrinterName = txtPrinter.Text.Trim();
                //Report.PrintPreview(true);  // 弹出预览窗口
                Report.Print(false);

                bool isUnprinted = (tabControl1.SelectedTab == tabPageUnprinted);
                if (isUnprinted && idList.Count > 0)
                {
                    string ids = string.Join(",", idList);
                    string alias = txtDeviceAlias.Text.Trim().Replace("'", "''");
                    string updateSql = $@"UPDATE Gy_BarCodeBill_Split  SET HIsPrintSuccess = 1, HLastPrintDate = GETDATE() WHERE HItemId IN ({ids})";
                    oCn.RunProc(updateSql);
                    LoadData();
                }
                else if (!isUnprinted)
                {
                    MessageBox.Show("已打印记录重新打印完成（仅打印，不改变状态）。", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
                }

                MessageBox.Show("打印完成。", "信息", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            catch (Exception ex)
            {
                MessageBox.Show("打印出错：" + ex.Message, "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
                LogService.Write("打印异常：" + ex.Message);
            }
        }
        #endregion

        private void Form1_FormClosed(object sender, FormClosedEventArgs e)
        {
            timer1?.Stop();
            timer1?.Dispose();
        }
    }
}