MainWindow.xaml.cs

using System.Collections.ObjectModel;
using System.Data;
using System.IO;
using System.Text;
using System.Text.Json;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Input;
using System.Windows.Media;
using Microsoft.Win32;
using MySql.Data.MySqlClient;
using ClosedXML.Excel;

namespace MeretMarketManager;

public partial class MainWindow : Window
{
    // ── Db state ─────────────────────────────────
    MySqlConnection? _conn;
    string _tableName = "shop_merat_custom.xml";
    bool _connected => _conn?.State == ConnectionState.Open;

    // ── Data ─────────────────────────────────────
    readonly ObservableCollection<MeretItem> _allItems = new();
    MeretItem? _selectedItem;
    MeretItem? _editItem;
    bool _hasChanges;

    // ── Item Names ──────────────────────────────
    Dictionary<int, string> _itemNames = new();  // id -> name
    Dictionary<string, List<int>> _nameToIds = new(StringComparer.OrdinalIgnoreCase);  // name -> ids

    // ── Language ────────────────────────────────
    bool _isEnglish = false;
    public static bool IsEnglish { get; private set; }

    // ────────────────────────────────────────────
    public MainWindow()
    {
        InitializeComponent();
        DgItems.ItemsSource = _allItems;
        LoadEnvConfig();
        LoadItemNames();
    }

    // ── Load item names from shopitemname.xml ───
    void LoadItemNames()
    {
        var xmlFile = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, "shopitemname.xml");
        if (!File.Exists(xmlFile))
            xmlFile = Path.Combine(Environment.CurrentDirectory, "shopitemname.xml");
        if (!File.Exists(xmlFile)) return;

        try
        {
            var lines = File.ReadAllLines(xmlFile);
            foreach (var line in lines)
            {
                // Parse: <key id="11220051" class="" name="甜米樱桃冰淇淋耳环（男）" />
                var idMatch = System.Text.RegularExpressions.Regex.Match(line, @"id=""(\d+)""");
                var nameMatch = System.Text.RegularExpressions.Regex.Match(line, @"name=""([^""]+)""");
                if (idMatch.Success && nameMatch.Success)
                {
                    var id = int.Parse(idMatch.Groups[1].Value);
                    var name = nameMatch.Groups[1].Value;
                    _itemNames[id] = name;

                    // Build reverse index (name -> ids)
                    if (!_nameToIds.ContainsKey(name))
                        _nameToIds[name] = new List<int>();
                    _nameToIds[name].Add(id);
                }
            }
            SetStatus($"已加载 {_itemNames.Count} 个物品名称");
        }
        catch (Exception ex)
        {
            SetStatus($"加载物品名称失败: {ex.Message}");
        }
    }

    // ── Load .env config ─────────────────────────
    void LoadEnvConfig()
    {
        var envFile = Path.Combine(AppDomain.CurrentDomain.BaseDirectory, ".env");
        if (!File.Exists(envFile))
            envFile = Path.Combine(Environment.CurrentDirectory, ".env");

        if (File.Exists(envFile))
        {
            foreach (var line in File.ReadAllLines(envFile))
            {
                var trimmed = line.Trim();
                if (string.IsNullOrEmpty(trimmed) || trimmed.StartsWith('#')) continue;
                var idx = trimmed.IndexOf('=');
                if (idx <= 0) continue;
                var k = trimmed[..idx].Trim();
                var v = trimmed[(idx + 1)..].Trim();
                switch (k)
                {
                    case "DB_IP":         TxbDbHost.Text = v;  break;
                    case "DB_PORT":       TxbDbPort.Text = v;  break;
                    case "DB_USER":       TxbDbUser.Text = v;  break;
                    case "DB_PASSWORD":   TxbDbPass.Password = v;  break;
                    case "DATA_DB_NAME":  TxbDbName.Text = v;  break;
                    case "MERET_TABLE":   _tableName = v;       break;
                }
            }
        }
    }

    // ── Connection ───────────────────────────────
    void SetStatus(string msg, bool ok = false)
    {
        TxtStatus.Text = msg;
        DotStatus.Fill = new SolidColorBrush(ok ? Color.FromRgb(72, 187, 120) : Color.FromRgb(252, 129, 129));
    }

    void BtnConnect_Click(object sender, RoutedEventArgs e)
    {
        if (_connected) { Disconnect(); return; }

        try
        {
            var cs = $"Server={TxbDbHost.Text};Port={TxbDbPort.Text};Database={TxbDbName.Text};" +
                     $"User={TxbDbUser.Text};Password={TxbDbPass.Password};OldGuids=true;AllowUserVariables=true;";
            _conn = new MySqlConnection(cs);
            _conn.Open();
            TxbDbHost.IsEnabled = TxbDbPort.IsEnabled = TxbDbUser.IsEnabled =
                TxbDbPass.IsEnabled = TxbDbName.IsEnabled = false;
            BtnConnect.Content = "断开";
            SetStatus($"已连接 {TxbDbHost.Text}:{TxbDbPort.Text}/{TxbDbName.Text}", true);
            RefreshData();
        }
        catch (Exception ex)
        {
            SetStatus("连接失败: " + ex.Message);
            _conn?.Dispose();
            _conn = null;
        }
    }

    void Disconnect()
    {
        _conn?.Dispose();
        _conn = null;
        _allItems.Clear();
        TxbDbHost.IsEnabled = TxbDbPort.IsEnabled = TxbDbUser.IsEnabled =
            TxbDbPass.IsEnabled = TxbDbName.IsEnabled = true;
        BtnConnect.Content = _isEnglish ? "Connect" : "连接";
        SetStatus(_isEnglish ? "Disconnected" : "未连接");
        TxtItemCount.Text = "0 items";
    }

    // ── Language Switch ──────────────────────────
    void BtnLang_Click(object sender, RoutedEventArgs e)
    {
        _isEnglish = !_isEnglish;
        ApplyLanguage();
    }

    void ApplyLanguage()
    {

        TxbSearchLabel.Text = _isEnglish ? "Search:" : "搜索:";

        TabImport.Header = _isEnglish ? "Import/Export" : "导入导出";



        {
        }

    }

    void UpdateTabIdComboBoxes()
    {
        // Update filter combobox
        var filterItems = new (string Zh, string En)[]
        {
            ("全部", "All"),
            ("10 — 推荐", "10 — Featured"),
            ("11 — 新品", "11 — New"),
            ("40000 — 礼包", "40000 — Package"),
            ("40100 — 时装", "40100 — Fashion"),
            ("40200 — 召唤", "40200 — Summon"),
            ("40300 — 功能/消耗", "40300 — Function"),
            ("40400 — 表情动作", "40400 — Emote"),
            ("40500 — 徽章", "40500 — Badge"),
            ("40600 — 乐器", "40600 — Instrument")
        };

        for (int i = 0; i < CmbTabFilter.Items.Count && i < filterItems.Length; i++)
        {
            if (CmbTabFilter.Items[i] is ComboBoxItem ci)
                ci.Content = _isEnglish ? filterItems[i].En : filterItems[i].Zh;
        }

        // Update add/edit comboboxes
        var tabItems = new (string Zh, string En)[]
        {
            ("10 — 推荐", "10 — Featured"),
            ("11 — 新品", "11 — New"),
            ("40000 — 礼包", "40000 — Package"),
            ("40100 — 时装", "40100 — Fashion"),
            ("40101 — 武器", "40101 — Weapon"),
            ("40102 — 帽子", "40102 — Hat"),
            ("40103 — 连身衣", "40103 — Outfit"),
            ("40104 — 上装", "40104 — Top"),
            ("40105 — 下装", "40105 — Bottom"),
            ("40106 — 手套", "40106 — Gloves"),
            ("40107 — 鞋子", "40107 — Shoes"),
            ("40108 — 披风", "40108 — Cape"),
            ("40109 — 饰品", "40109 — Accessory"),
            ("40110 — 皮肤", "40110 — Skin"),
            ("40200 — 召唤", "40200 — Summon"),
            ("40201 — 陆地坐骑", "40201 — Ground Mount"),
            ("40202 — 飞行坐骑", "40202 — Flying Mount"),
            ("40203 — 宠物", "40203 — Pet"),
            ("40300 — 功能/消耗", "40300 — Function"),
            ("40400 — 表情动作", "40400 — Emote"),
            ("40500 — 徽章", "40500 — Badge"),
            ("40600 — 乐器", "40600 — Instrument")
        };

        for (int i = 0; i < CmbAddTabId.Items.Count && i < tabItems.Length; i++)
        {
            if (CmbAddTabId.Items[i] is ComboBoxItem ci)
                ci.Content = _isEnglish ? tabItems[i].En : tabItems[i].Zh;
        }

        for (int i = 0; i < CmbEditTabId.Items.Count && i < tabItems.Length; i++)
        {
            if (CmbEditTabId.Items[i] is ComboBoxItem ci)
                ci.Content = _isEnglish ? tabItems[i].En : tabItems[i].Zh;
        }
    }

    // ── Load from DB ─────────────────────────────
    void RefreshData()
    {
        if (!_connected) return;
        try
        {
            var cmd = _conn!.CreateCommand();
            cmd.CommandText = "SELECT `Table` FROM `server-table` WHERE `Name` = @name";
            cmd.Parameters.AddWithValue("@name", _tableName);
            var raw = cmd.ExecuteScalar()?.ToString();
            if (string.IsNullOrEmpty(raw)) { SetStatus("表不存在: " + _tableName); return; }

            var doc = JsonDocument.Parse(raw);
            var root = doc.RootElement;

            // detect structure: either { "!": "meretMarket", "Entries": {...} } or { "Entries": {...} }
            JsonElement entries;
            if (root.TryGetProperty("Entries", out entries) ||
                root.EnumerateObject().Any(p => p.Name != "!"))
            {
                // find the Entries property
                entries = root.GetProperty("Entries");
            }
            else
            {
                SetStatus("无法解析 Entries 结构"); return;
            }

            _allItems.Clear();
            foreach (var prop in entries.EnumerateObject())
            {
                var item = ParseEntry(prop.Name, prop.Value);
                if (item != null) _allItems.Add(item);
            }

            ApplyFilter();
            TxtItemCount.Text = $"{_allItems.Count} items";
            SetStatus($"已加载 {_allItems.Count} 条商品", true);
        }
        catch (Exception ex)
        {
            SetStatus("加载失败: " + ex.Message);
        }
    }

    MeretItem? ParseEntry(string key, JsonElement el)
    {
        try
        {
            var item = new MeretItem { Id = int.TryParse(key, out var k) ? k : 0 };
            foreach (var prop in el.EnumerateObject())
            {
                switch (prop.Name)
                {
                    case "Id":              item.Id              = prop.Value.GetInt32(); break;
                    case "ParentId":         item.ParentId        = prop.Value.GetInt32(); break;
                    case "TabId":            item.TabId           = prop.Value.GetInt32(); break;
                    case "Banner":           item.Banner          = prop.Value.GetString() ?? ""; break;
                    case "BannerTag":        item.BannerTag       = prop.Value.GetInt32(); break;
                    case "ItemId":           item.ItemId          = prop.Value.GetInt32(); break;
                    case "Rarity":           item.Rarity          = prop.Value.GetInt32(); break;
                    case "Quantity":         item.Quantity        = prop.Value.GetInt32(); break;
                    case "BonusQuantity":    item.BonusQuantity   = prop.Value.GetInt32(); break;
                    case "DurationInDays":   item.DurationInDays  = prop.Value.GetInt32(); break;
                    case "SaleTag":          item.SaleTag         = prop.Value.GetInt32(); break;
                    case "CurrencyType":     item.CurrencyType    = prop.Value.GetInt32(); break;
                    case "Price":            item.Price            = prop.Value.GetInt64(); break;
                    case "SalePrice":        item.SalePrice       = prop.Value.GetInt64(); break;
                    case "SaleStartTime":    item.SaleStartTime   = prop.Value.GetInt64(); break;
                    case "SaleEndTime":      item.SaleEndTime     = prop.Value.GetInt64(); break;
                    case "JobRequirement":   item.JobRequirement  = prop.Value.GetInt32(); break;
                    case "RestockUnavailable": item.RestockUnavailable = prop.Value.GetBoolean(); break;
                    case "RequireMinLevel":  item.RequireMinLevel = prop.Value.GetInt32(); break;
                    case "RequireMaxLevel":  item.RequireMaxLevel = prop.Value.GetInt32(); break;
                    case "RequireAchievementId":   item.RequireAchievementId   = prop.Value.GetInt32(); break;
                    case "RequireAchievementRank": item.RequireAchievementRank = prop.Value.GetInt32(); break;
                    case "PcCafe":           item.PcCafe          = prop.Value.GetBoolean(); break;
                    case "Giftable":         item.Giftable        = prop.Value.GetBoolean(); break;
                    case "ShowSaleTime":     item.ShowSaleTime    = prop.Value.GetBoolean(); break;
                    case "PromoName":        item.PromoName       = prop.Value.GetString() ?? ""; break;
                    case "PromoStartTime":   item.PromoStartTime  = prop.Value.GetInt64(); break;
                    case "PromoEndTime":     item.PromoEndTime    = prop.Value.GetInt64(); break;
                }
            }
            return item;
        }
        catch { return null; }
    }

    // ── Build preview JSON (does NOT write to DB) ──
    string BuildPreviewJson()
    {
        var dict = new Dictionary<string, object?> { { "!", "meretMarket" } };
        var entries = new Dictionary<string, object?>();
        foreach (var item in _allItems.OrderBy(x => x.Id))
        {
            entries[item.Id.ToString()] = item.ToDict();
        }
        dict["Entries"] = entries;
        return JsonSerializer.Serialize(dict, new JsonSerializerOptions
        {
            WriteIndented = true,
            DefaultIgnoreCondition = System.Text.Json.Serialization.JsonIgnoreCondition.WhenWritingNull
        });
    }

    // ── Save to DB ───────────────────────────────
    bool SaveToDb()
    {
        if (!_connected)
        {
            MessageBox.Show("数据库未连接，无法保存！", "错误", MessageBoxButton.OK, MessageBoxImage.Error);
            return false;
        }
        try
        {
            // Build the JSON object - entry key must match item.Id (server uses key as item ID)
            var dict = new Dictionary<string, object?> { { "!", "meretMarket" } };
            var entries = new Dictionary<string, object?>();
            foreach (var item in _allItems.OrderBy(x => x.Id))
            {
                entries[item.Id.ToString()] = item.ToDict();
            }
            dict["Entries"] = entries;

            var json = JsonSerializer.Serialize(dict, new JsonSerializerOptions
            {
                WriteIndented = false,
                DefaultIgnoreCondition = System.Text.Json.Serialization.JsonIgnoreCondition.WhenWritingNull
            });

            var cmd = _conn!.CreateCommand();
            cmd.CommandText = "UPDATE `server-table` SET `Table` = @t WHERE `Name` = @name";
            cmd.Parameters.AddWithValue("@t", json);
            cmd.Parameters.AddWithValue("@name", _tableName);
            var affected = cmd.ExecuteNonQuery();
            if (affected == 0)
            {
                SetStatus("UPDATE 0 rows — 表可能不存在");
                MessageBox.Show($"保存失败：表 {_tableName} 不存在或未更新", "错误", MessageBoxButton.OK, MessageBoxImage.Error);
                return false;
            }
            else
            {
                _hasChanges = false;
                MarkDirty(false);
                foreach (var i in _allItems) i.IsStaged = false;
                DgItems.Items.Refresh();
                SetStatus($"已保存 {json.Length} bytes", true);
                return true;
            }
        }
        catch (Exception ex)
        {
            SetStatus("保存失败: " + ex.Message);
            MessageBox.Show("保存失败: " + ex.Message, "错误", MessageBoxButton.OK, MessageBoxImage.Error);
            return false;
        }
    }

    void ApplyFilter()
    {
        if (_allItems == null || TxbSearch == null || DgItems == null) return;
        
        // 用 CollectionViewSource 过滤，不替换 ItemsSource（保证勾选/删除正常工作）
        var view = System.Windows.Data.CollectionViewSource.GetDefaultView(_allItems);
        view.Filter = o =>
        {
            var item = (MeretItem)o;
            
            // TabId 过滤
            int tabFilter = -1;
            if (CmbTabFilter.SelectedItem is ComboBoxItem ci && ci.Tag != null)
            {
                int.TryParse(ci.Tag.ToString(), out tabFilter);
                if (tabFilter == 0) tabFilter = -1;
            }
            if (tabFilter > 0 && item.TabId != tabFilter) return false;
            
            // 文本搜索
            var search = TxbSearch.Text.Trim();
            if (!string.IsNullOrEmpty(search))
            {
                if (int.TryParse(search, out var nid))
                    return item.ItemId == nid || item.Id == nid || item.ParentId == nid;
                else
                    return (item.Banner?.Contains(search, StringComparison.OrdinalIgnoreCase) ?? false) ||
                           (item.PromoName?.Contains(search, StringComparison.OrdinalIgnoreCase) ?? false);
            }
            return true;
        };
        view.Refresh();
    }

    // ── Filter events ────────────────────────────
    void TxbSearch_TextChanged(object sender, TextChangedEventArgs e) => ApplyFilter();
    void CmbTabFilter_SelectionChanged(object sender, SelectionChangedEventArgs e) => ApplyFilter();

    void BtnRefresh_Click(object sender, RoutedEventArgs e)
    {
        RefreshData();
        ApplyFilter();
    }

    // ── DataGrid selection ────────────────────────
    void DgItems_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {
        _selectedItem = DgItems.SelectedItem as MeretItem;
    }

    void DgItems_DoubleClick(object sender, MouseButtonEventArgs e)
    {
        if (_selectedItem != null)
        {
            MainTab.SelectedIndex = 2; // switch to Edit tab
            LoadEditItem(_selectedItem);
        }
    }

    // ── Checkbox selection ───────────────────────
    void ChkSelectAll_Click(object sender, RoutedEventArgs e)
    {
        if (sender is System.Windows.Controls.CheckBox chk)
        {
            bool isChecked = chk.IsChecked ?? false;
            foreach (var item in _allItems)
            {
                item.IsSelected = isChecked;
            }
            DgItems.Items.Refresh();
        }
    }

    void ChkItem_Click(object sender, RoutedEventArgs e)
    {
        // Update delete button text to show count
        int selectedCount = _allItems.Count(i => i.IsSelected);
        if (selectedCount > 0)
        {
            // Could update button content here if desired
        }
    }

    // ── Delete ──────────────────────────────────
    void BtnDeleteSelected_Click(object sender, RoutedEventArgs e)
    {
        // Check for multi-select first
        var selectedItems = _allItems.Where(i => i.IsSelected).ToList();
        
        if (selectedItems.Count == 0 && _selectedItem == null) 
        { 
            MessageBox.Show("请先选中一行（或勾选多行的复选框）"); 
            return; 
        }

        // If no checkbox selection, use single selection
        if (selectedItems.Count == 0 && _selectedItem != null)
        {
            selectedItems.Add(_selectedItem);
        }

        var itemIds = string.Join(", ", selectedItems.Select(i => i.Id));
        var result = MessageBox.Show(
            $"确定删除选中的 {selectedItems.Count} 个商品？\n商品 Id: {itemIds}",
            "确认删除", MessageBoxButton.YesNo, MessageBoxImage.Warning);
        if (result != MessageBoxResult.Yes) return;

        // Remove all selected items and their children
        foreach (var item in selectedItems)
        {
            var parentId = item.Id;
            _allItems.Remove(item);
            // cascade delete children
            var toRemove = _allItems.Where(i => i.ParentId == parentId).ToList();
            foreach (var child in toRemove) _allItems.Remove(child);
        }

        _hasChanges = true;
        MarkDirty(true);
        // 不要调用 RefreshData()，否则会从数据库重新加载覆盖本地删除
        ApplyFilter();
        SetStatus($"已删除 {selectedItems.Count} 个商品（点击 [应用] 保存到数据库）");
    }

    // ── Edit ────────────────────────────────────
    void BtnEditSelected_Click(object sender, RoutedEventArgs e)
    {
        if (_selectedItem == null) { MessageBox.Show("请先选中一行"); return; }
        MainTab.SelectedIndex = 2;
        LoadEditItem(_selectedItem);
    }

    void LoadEditItem(MeretItem item)
    {
        _editItem = item;
        TxbEditItemId.Text = item.ItemId.ToString();
        TxbEditItemName.Text = _itemNames.TryGetValue(item.ItemId, out var name) ? name : "";
        CmbEditRarity.SelectedIndex = Math.Clamp(item.Rarity - 1, 0, 4);
        TxbEditQty.Text = item.Quantity.ToString();
        TxbEditBonusQty.Text = item.BonusQuantity.ToString();
        TxbEditDuration.Text = item.DurationInDays.ToString();
        TxbEditParentId.Text = item.ParentId.ToString();
        TxbEditTabId.Text = item.TabId.ToString();
        SelectTabCombo(CmbEditTabId, item.TabId);

        TxbEditPrice.Text = item.Price.ToString();
        CmbEditCurrency.SelectedIndex = item.CurrencyType == 1 ? 0 : 1;
        TxbEditSalePrice.Text = item.SalePrice.ToString();
        CmbEditSaleTag.SelectedIndex = Math.Clamp(item.SaleTag, 0, 4);
        TxbEditSaleStart.Text = item.SaleStartTime > 0 ? item.SaleStartTime.ToString() : "";
        TxbEditSaleEnd.Text = item.SaleEndTime > 0 ? item.SaleEndTime.ToString() : "";
        TxbEditBanner.Text = item.Banner;
        TxbEditBannerTag.Text = item.BannerTag.ToString();
        TxbEditPromoName.Text = item.PromoName;
        TxbEditPromoStart.Text = item.PromoStartTime > 0 ? item.PromoStartTime.ToString() : "";
        TxbEditPromoEnd.Text = item.PromoEndTime > 0 ? item.PromoEndTime.ToString() : "";

        TxbEditJobReq.Text = item.JobRequirement.ToString("X");
        TxbEditMinLevel.Text = item.RequireMinLevel.ToString();
        TxbEditMaxLevel.Text = item.RequireMaxLevel.ToString();

        ChkEditNoRestock.IsChecked = item.RestockUnavailable;
        ChkEditPcCafe.IsChecked = item.PcCafe;
        ChkEditGiftable.IsChecked = item.Giftable;
        ChkEditShowSale.IsChecked = item.ShowSaleTime;
    }

    void SelectTabCombo(ComboBox cmb, int value)
    {
        for (int i = 0; i < cmb.Items.Count; i++)
        {
            if (cmb.Items[i] is ComboBoxItem ci && int.TryParse(ci.Tag?.ToString(), out int t) && t == value)
            { cmb.SelectedIndex = i; return; }
        }
        cmb.SelectedIndex = 0;
    }

    void BtnSaveEdit_Click(object sender, RoutedEventArgs e)
    {
        if (_editItem == null) { MessageBox.Show("请先选择要编辑的商品"); return; }
        try
        {
            _editItem.Rarity = CmbEditRarity.SelectedIndex + 1;
            _editItem.Quantity = int.Parse(TxbEditQty.Text);
            _editItem.BonusQuantity = int.Parse(TxbEditBonusQty.Text);
            _editItem.DurationInDays = int.Parse(TxbEditDuration.Text);
            _editItem.ParentId = int.Parse(TxbEditParentId.Text);
            _editItem.TabId = int.TryParse(TxbEditTabId.Text, out var tid) ? tid : 0;
            _editItem.Price = long.Parse(TxbEditPrice.Text);
            _editItem.CurrencyType = CmbEditCurrency.SelectedIndex == 0 ? 1 : 2;
            _editItem.SalePrice = long.Parse(TxbEditSalePrice.Text);
            _editItem.SaleTag = GetComboTag(CmbEditSaleTag);
            _editItem.SaleStartTime = ParseTimestamp(TxbEditSaleStart.Text);
            _editItem.SaleEndTime = ParseTimestamp(TxbEditSaleEnd.Text);
            _editItem.Banner = TxbEditBanner.Text;
            _editItem.BannerTag = int.Parse(TxbEditBannerTag.Text);
            _editItem.PromoName = TxbEditPromoName.Text;
            _editItem.PromoStartTime = ParseTimestamp(TxbEditPromoStart.Text);
            _editItem.PromoEndTime = ParseTimestamp(TxbEditPromoEnd.Text);
            _editItem.JobRequirement = int.Parse(TxbEditJobReq.Text, System.Globalization.NumberStyles.HexNumber);
            _editItem.RequireMinLevel = int.Parse(TxbEditMinLevel.Text);
            _editItem.RequireMaxLevel = int.Parse(TxbEditMaxLevel.Text);
            _editItem.RestockUnavailable = ChkEditNoRestock.IsChecked ?? false;
            _editItem.PcCafe = ChkEditPcCafe.IsChecked ?? false;
            _editItem.Giftable = ChkEditGiftable.IsChecked ?? false;
            _editItem.ShowSaleTime = ChkEditShowSale.IsChecked ?? false;

            _hasChanges = true;
            MarkDirty(true);
            _editItem!.IsStaged = true;
            DgItems.Items.Refresh();
            SetStatus("编辑已暂存（点击 [应用] 保存到数据库）");
        }
        catch (Exception ex)
        {
            MessageBox.Show("保存失败: " + ex.Message, "错误", MessageBoxButton.OK, MessageBoxImage.Error);
        }
    }

    // ── Add ─────────────────────────────────────
    void CmbAddTabId_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {
        if (CmbAddTabId.SelectedItem is ComboBoxItem ci && ci.Tag != null)
        {
            TxbAddTabId.Text = ci.Tag.ToString();
        }
    }

    void CmbEditTabId_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {
        if (CmbEditTabId.SelectedItem is ComboBoxItem ci && ci.Tag != null)
        {
            TxbEditTabId.Text = ci.Tag.ToString();
        }
    }

    // ── Item Name AutoComplete ──────────────────
    bool _isUpdatingName = false;  // 防止循环更新

    void TxbAddItemId_TextChanged(object sender, TextChangedEventArgs e)
    {
        if (_isUpdatingName) return;
        var text = TxbAddItemId.Text.Trim();
        
        // 输入完整的 ItemId 时，自动填充 Name
        if (int.TryParse(text, out int itemId))
        {
            TxbAddItemName.Text = _itemNames.TryGetValue(itemId, out var name) ? name : "";
        }

        // 输入至少 5 位数字时，显示匹配项下拉
        if (text.Length >= 5 && int.TryParse(text, out _))
        {
            var matches = _itemNames
                .Where(kvp => kvp.Key.ToString().StartsWith(text))
                .Take(15)
                .ToList();

            if (matches.Count > 0)
            {
                LstAddIdSuggestions.ItemsSource = matches.Select(m => $"{m.Key} - {m.Value}").ToList();
                PopAddIdSuggestions.IsOpen = true;
            }
            else
            {
                PopAddIdSuggestions.IsOpen = false;
            }
        }
        else
        {
            PopAddIdSuggestions.IsOpen = false;
        }
    }

    void TxbAddItemId_KeyDown(object sender, KeyEventArgs e)
    {
        if (e.Key == Key.Down && LstAddIdSuggestions.Items.Count > 0)
        {
            LstAddIdSuggestions.Focus();
            LstAddIdSuggestions.SelectedIndex = 0;
            e.Handled = true;
        }
        else if (e.Key == Key.Escape)
        {
            PopAddIdSuggestions.IsOpen = false;
            e.Handled = true;
        }
    }

    void LstAddIdSuggestions_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {
        if (LstAddIdSuggestions.SelectedItem is string selected)
        {
            var parts = selected.Split(new[] { " - " }, 2, StringSplitOptions.None);
            if (parts.Length == 2 && int.TryParse(parts[0], out int id))
            {
                _isUpdatingName = true;
                TxbAddItemId.Text = id.ToString();
                TxbAddItemName.Text = parts[1];
                _isUpdatingName = false;
            }
            PopAddIdSuggestions.IsOpen = false;
        }
    }

    void TxbAddItemName_TextChanged(object sender, TextChangedEventArgs e)
    {
        if (_isUpdatingName) return;
        var text = TxbAddItemName.Text.Trim();
        if (string.IsNullOrEmpty(text) || text.Length < 2)
        {
            PopAddItemSuggestions.IsOpen = false;
            return;
        }

        // 搜索匹配项
        var matches = _nameToIds
            .Where(kvp => kvp.Key.Contains(text, StringComparison.OrdinalIgnoreCase))
            .SelectMany(kvp => kvp.Value.Select(itemId => new { Id = itemId, Name = kvp.Key }))
            .Take(15)
            .ToList();

        if (matches.Count == 0)
        {
            PopAddItemSuggestions.IsOpen = false;
            return;
        }

        LstAddItemSuggestions.ItemsSource = matches.Select(m => $"{m.Id} - {m.Name}").ToList();
        PopAddItemSuggestions.IsOpen = true;
    }

    void TxbAddItemName_KeyDown(object sender, KeyEventArgs e)
    {
        if (e.Key == Key.Down && LstAddItemSuggestions.Items.Count > 0)
        {
            LstAddItemSuggestions.Focus();
            LstAddItemSuggestions.SelectedIndex = 0;
            e.Handled = true;
        }
        else if (e.Key == Key.Escape)
        {
            PopAddItemSuggestions.IsOpen = false;
            e.Handled = true;
        }
    }

    void LstAddItemSuggestions_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {
        if (LstAddItemSuggestions.SelectedItem is string selected)
        {
            var parts = selected.Split(new[] { " - " }, 2, StringSplitOptions.None);
            if (parts.Length == 2 && int.TryParse(parts[0], out int id))
            {
                _isUpdatingName = true;
                TxbAddItemId.Text = id.ToString();
                TxbAddItemName.Text = parts[1];
                _isUpdatingName = false;
            }
            PopAddItemSuggestions.IsOpen = false;
        }
    }

    void TxbEditItemName_TextChanged(object sender, TextChangedEventArgs e)
    {
        if (_isUpdatingName) return;
        var text = TxbEditItemName.Text.Trim();
        if (string.IsNullOrEmpty(text) || text.Length < 2)
        {
            PopEditItemSuggestions.IsOpen = false;
            return;
        }

        var matches = _nameToIds
            .Where(kvp => kvp.Key.Contains(text, StringComparison.OrdinalIgnoreCase))
            .SelectMany(kvp => kvp.Value.Select(itemId => new { Id = itemId, Name = kvp.Key }))
            .Take(15)
            .ToList();

        if (matches.Count == 0)
        {
            PopEditItemSuggestions.IsOpen = false;
            return;
        }

        LstEditItemSuggestions.ItemsSource = matches.Select(m => $"{m.Id} - {m.Name}").ToList();
        PopEditItemSuggestions.IsOpen = true;
    }

    void TxbEditItemName_KeyDown(object sender, KeyEventArgs e)
    {
        if (e.Key == Key.Down && LstEditItemSuggestions.Items.Count > 0)
        {
            LstEditItemSuggestions.Focus();
            LstEditItemSuggestions.SelectedIndex = 0;
            e.Handled = true;
        }
        else if (e.Key == Key.Escape)
        {
            PopEditItemSuggestions.IsOpen = false;
            e.Handled = true;
        }
    }

    void LstEditItemSuggestions_SelectionChanged(object sender, SelectionChangedEventArgs e)
    {
        if (LstEditItemSuggestions.SelectedItem is string selected)
        {
            var parts = selected.Split(new[] { " - " }, 2, StringSplitOptions.None);
            if (parts.Length == 2 && int.TryParse(parts[0], out int id))
            {
                _isUpdatingName = true;
                TxbEditItemId.Text = id.ToString();
                TxbEditItemName.Text = parts[1];
                _isUpdatingName = false;
            }
            PopEditItemSuggestions.IsOpen = false;
        }
    }

    void BtnAdd_Click(object sender, RoutedEventArgs e)
    {
        if (!_connected) { MessageBox.Show("请先连接数据库"); return; }

        try
        {
            var itemId = int.Parse(TxbAddItemId.Text);
            var price = long.Parse(TxbAddPrice.Text);
        }
        catch
        {
            MessageBox.Show("ItemId 和 Price 为必填项且必须是数字"); return;
        }

        var id = _allItems.Count > 0 ? _allItems.Max(i => i.Id) + 1 : 90000;

        var item = new MeretItem
        {
            Id              = id,
            ItemId          = int.Parse(TxbAddItemId.Text),
            Price           = long.Parse(TxbAddPrice.Text),
            TabId           = int.TryParse(TxbAddTabId.Text, out var tabId) ? tabId : 10,
            Rarity          = GetComboTag(CmbAddRarity),
            CurrencyType    = GetComboTag(CmbAddCurrency),
            Quantity        = int.TryParse(TxbAddQty.Text, out var q) ? q : 1,
            BonusQuantity   = int.TryParse(TxbAddBonusQty.Text, out var bq) ? bq : 0,
            DurationInDays  = int.TryParse(TxbAddDuration.Text, out var dd) ? dd : 0,
            ParentId        = int.TryParse(TxbAddParentId.Text, out var pid) ? pid : 0,
            SalePrice       = long.TryParse(TxbAddSalePrice.Text, out var sp) ? sp : long.Parse(TxbAddPrice.Text),
            SaleTag         = GetComboTag(CmbAddSaleTag),
            SaleStartTime   = ParseTimestamp(TxbAddSaleStart.Text),
            SaleEndTime     = ParseTimestamp(TxbAddSaleEnd.Text),
            Banner          = TxbAddBanner.Text,
            BannerTag       = int.TryParse(TxbAddBannerTag.Text, out var bt) ? bt : 0,
            PromoName       = TxbAddPromoName.Text,
            PromoStartTime  = ParseTimestamp(TxbAddPromoStart.Text),
            PromoEndTime    = ParseTimestamp(TxbAddPromoEnd.Text),
            JobRequirement  = int.TryParse(TxbAddJobReq.Text, out var jr) ? jr : 4095,
            RequireMinLevel  = int.TryParse(TxbAddMinLevel.Text, out var minl) ? minl : 0,
            RequireMaxLevel  = int.TryParse(TxbAddMaxLevel.Text, out var maxl) ? maxl : 0,
            RestockUnavailable = ChkAddNoRestock.IsChecked ?? false,
            PcCafe          = ChkAddPcCafe.IsChecked ?? false,
            Giftable        = ChkAddGiftable.IsChecked ?? false,
            ShowSaleTime    = ChkAddShowSale.IsChecked ?? false,
        };

        _allItems.Add(item);
        item.IsStaged = true;
        _hasChanges = true;
        MarkDirty(true);
        DgItems.Items.Refresh(); // 刷新行样式以显示绿色
        SetStatus($"已添加 Id={id}（点击 [应用] 保存到数据库）");
    }

    // ── Import / Export ─────────────────────────
    void BtnBrowseImport_Click(object sender, RoutedEventArgs e)
    {
        var dlg = new OpenFileDialog { Filter = "Excel/CSV Files|*.xlsx;*.csv|Excel Files|*.xlsx|CSV Files|*.csv|All Files|*.*", Title = "选择文件" };
        if (dlg.ShowDialog() == true) TxbImportPath.Text = dlg.FileName;
    }

    void BtnImport_Click(object sender, RoutedEventArgs e)
    {
        if (!_connected) { MessageBox.Show("请先连接数据库"); return; }
        var path = TxbImportPath.Text;
        if (string.IsNullOrEmpty(path) || !File.Exists(path))
        { MessageBox.Show("请先选择有效的文件"); return; }

        try
        {
            int added = 0, skipped = 0;
            var ext = System.IO.Path.GetExtension(path).ToLowerInvariant();

            if (ext == ".xlsx")
            {
                // Excel 导入
                using var wb = new ClosedXML.Excel.XLWorkbook(path);
                var ws = wb.Worksheet(1);
                var range = ws.RangeUsed();
                if (range == null) { MessageBox.Show("Excel 文件为空"); return; }

                // 读取表头
                var headerRow = range.FirstRow();
                var headers = new Dictionary<string, int>(StringComparer.OrdinalIgnoreCase);
                for (int c = 1; c <= range.ColumnCount(); c++)
                {
                    var h = headerRow.Cell(c).GetString().Trim().ToLowerInvariant();
                    headers[h] = c;
                }

                // 逐行解析
                for (int r = 2; r <= range.RowCount(); r++)
                {
                    var row = range.Row(r);
                    int id = GetXlsxInt(row, headers, "id", 0);
                    if (id == 0) id = GetXlsxInt(row, headers, "num", 0);  // 兜底：无 id 列时用 num
                    int itemId = GetXlsxInt(row, headers, "itemid", 0);
                    long price = GetXlsxLong(row, headers, "price", 0);
                    if (id == 0 || itemId == 0) { skipped++; continue; }
                    if (_allItems.Any(x => x.Id == id)) { skipped++; continue; }

                    var item = new MeretItem
                    {
                        Id              = id,
                        ItemId          = itemId,
                        Price           = price,
                        ParentId        = GetXlsxInt(row, headers, "parentid"),
                        TabId           = GetXlsxInt(row, headers, "tabid", 10),
                        Banner          = GetXlsxStr(row, headers, "banner"),
                        BannerTag       = GetXlsxInt(row, headers, "bannertag"),
                        Rarity          = GetXlsxInt(row, headers, "rarity", 1),
                        Quantity        = GetXlsxInt(row, headers, "quantity", 1),
                        BonusQuantity   = GetXlsxInt(row, headers, "bonusquantity"),
                        DurationInDays  = GetXlsxInt(row, headers, "durationindays"),
                        SaleTag         = GetXlsxInt(row, headers, "saletag"),
                        CurrencyType    = GetXlsxInt(row, headers, "currencytype", 1),
                        SalePrice       = GetXlsxLong(row, headers, "saleprice", price),
                        SaleStartTime   = GetXlsxLong(row, headers, "salestarttime"),
                        SaleEndTime     = GetXlsxLong(row, headers, "saleendtime"),
                        JobRequirement  = GetXlsxInt(row, headers, "jobrequirement", 4095),
                        RestockUnavailable = GetXlsxBool(row, headers, "restockunavailable"),
                        RequireMinLevel = GetXlsxInt(row, headers, "requireminlevel"),
                        RequireMaxLevel = GetXlsxInt(row, headers, "requiremaxlevel"),
                        RequireAchievementId   = GetXlsxInt(row, headers, "requireachievementid"),
                        RequireAchievementRank = GetXlsxInt(row, headers, "requireachievementrank"),
                        PcCafe          = GetXlsxBool(row, headers, "pccafe"),
                        Giftable        = GetXlsxBool(row, headers, "giftable"),
                        ShowSaleTime    = GetXlsxBool(row, headers, "showsaletime"),
                        PromoName       = GetXlsxStr(row, headers, "promoname"),
                        PromoStartTime  = GetXlsxLong(row, headers, "promostarttime"),
                        PromoEndTime    = GetXlsxLong(row, headers, "promoendtime"),
                    };

                    _allItems.Add(item);
                    item.IsStaged = true;
                    added++;
                }
            }
            else
            {
                // CSV 导入
                var lines = File.ReadAllLines(path, Encoding.UTF8);
                if (lines.Length < 2) { MessageBox.Show("CSV 文件内容为空"); return; }

                var headers = ParseCsvLine(lines[0]).Select(h => h.ToLowerInvariant().Trim()).ToArray();
                var h = headers.Select((name, idx) => (name, idx)).ToDictionary(x => x.name, x => x.idx);

                for (int i = 1; i < lines.Length; i++)
                {
                    var cols = ParseCsvLine(lines[i]);
                    if (cols.Length < 5) continue;

                    int id = GetInt(cols, h, "id", 0);
                    if (id == 0) id = GetInt(cols, h, "num", 0);  // 兜底：无 id 列时用 num
                    int itemId = GetInt(cols, h, "itemid", 0);
                    long price = GetLong(cols, h, "price", 0);
                    if (id == 0 || itemId == 0) { skipped++; continue; }
                    if (_allItems.Any(x => x.Id == id)) { skipped++; continue; }

                    var item = new MeretItem
                    {
                        Id              = id,
                        ItemId          = itemId,
                        Price           = price,
                        ParentId        = GetInt(cols, h, "parentid"),
                        TabId           = GetInt(cols, h, "tabid", 10),
                        Banner          = GetStr(cols, h, "banner"),
                        BannerTag       = GetInt(cols, h, "bannertag"),
                        Rarity          = GetInt(cols, h, "rarity", 1),
                        Quantity        = GetInt(cols, h, "quantity", 1),
                        BonusQuantity   = GetInt(cols, h, "bonusquantity"),
                        DurationInDays  = GetInt(cols, h, "durationindays"),
                        SaleTag         = GetInt(cols, h, "saletag"),
                        CurrencyType    = GetInt(cols, h, "currencytype", 1),
                        SalePrice       = GetLong(cols, h, "saleprice", price),
                        SaleStartTime   = GetLong(cols, h, "salestarttime"),
                        SaleEndTime     = GetLong(cols, h, "saleendtime"),
                        JobRequirement  = GetInt(cols, h, "jobrequirement", 4095),
                        RestockUnavailable = GetBool(cols, h, "restockunavailable"),
                        RequireMinLevel = GetInt(cols, h, "requireminlevel"),
                        RequireMaxLevel = GetInt(cols, h, "requiremaxlevel"),
                        RequireAchievementId   = GetInt(cols, h, "requireachievementid"),
                        RequireAchievementRank = GetInt(cols, h, "requireachievementrank"),
                        PcCafe          = GetBool(cols, h, "pccafe"),
                        Giftable        = GetBool(cols, h, "giftable"),
                        ShowSaleTime    = GetBool(cols, h, "showsaletime"),
                        PromoName       = GetStr(cols, h, "promoname"),
                        PromoStartTime  = GetLong(cols, h, "promostarttime"),
                        PromoEndTime    = GetLong(cols, h, "promoendtime"),
                    };

                    _allItems.Add(item);
                    item.IsStaged = true;
                    added++;
                }
            }

            _hasChanges = true;
            MarkDirty(true);
            DgItems.Items.Refresh();
            SetStatus($"导入完成：新增 {added} 条，跳过 {skipped} 条（点击 [应用] 保存到数据库）");
        }
        catch (Exception ex)
        {
            MessageBox.Show("导入失败: " + ex.Message, "错误", MessageBoxButton.OK, MessageBoxImage.Error);
        }
    }

    void BtnBrowseExport_Click(object sender, RoutedEventArgs e)
    {
        var dlg = new SaveFileDialog { Filter = "Excel Files|*.xlsx|CSV Files|*.csv", Title = "导出", FileName = "shop_export.xlsx" };
        if (dlg.ShowDialog() == true) TxbExportPath.Text = dlg.FileName;
    }

    void BtnExport_Click(object sender, RoutedEventArgs e)
    {
        if (!_connected) { MessageBox.Show("请先连接数据库"); return; }
        var path = TxbExportPath.Text;
        if (string.IsNullOrEmpty(path)) { MessageBox.Show("请选择导出路径"); return; }

        try
        {
            var ext = System.IO.Path.GetExtension(path).ToLowerInvariant();

            if (ext == ".xlsx")
            {
                // Excel 导出 - 按用户示例字段顺序
                using var wb = new ClosedXML.Excel.XLWorkbook();
                var ws = wb.Worksheets.Add("商品列表");

                // 表头：num + 28字段
                var headers = new[] { "num", "Id", "Price", "TabId", "Banner", "ItemId", "PcCafe", "Rarity", "SaleTag", "Giftable", "ParentId", "Quantity", "BannerTag", "PromoName", "SalePrice", "SaleEndTime", "CurrencyType", "PromoEndTime", "ShowSaleTime", "BonusQuantity", "SaleStartTime", "DurationInDays", "JobRequirement", "PromoStartTime", "RequireMaxLevel", "RequireMinLevel", "RestockUnavailable", "RequireAchievementId", "RequireAchievementRank" };
                for (int c = 0; c < headers.Length; c++)
                    ws.Cell(1, c + 1).Value = headers[c];

                // 表头样式
                var headerRange = ws.Range(1, 1, 1, headers.Length);
                headerRange.Style.Fill.BackgroundColor = ClosedXML.Excel.XLColor.FromHtml("#2d5a3d");
                headerRange.Style.Font.FontColor = ClosedXML.Excel.XLColor.White;
                headerRange.Style.Font.Bold = true;

                // 数据行
                int row = 2;
                foreach (var item in _allItems.OrderBy(i => i.Id))
                {
                    ws.Cell(row, 1).Value = item.Id;  // num = JSON key
                    ws.Cell(row, 2).Value = item.Id;
                    ws.Cell(row, 3).Value = item.Price;
                    ws.Cell(row, 4).Value = item.TabId;
                    ws.Cell(row, 5).Value = item.Banner;
                    ws.Cell(row, 6).Value = item.ItemId;
                    ws.Cell(row, 7).Value = item.PcCafe;
                    ws.Cell(row, 8).Value = item.Rarity;
                    ws.Cell(row, 9).Value = item.SaleTag;
                    ws.Cell(row, 10).Value = item.Giftable;
                    ws.Cell(row, 11).Value = item.ParentId;
                    ws.Cell(row, 12).Value = item.Quantity;
                    ws.Cell(row, 13).Value = item.BannerTag;
                    ws.Cell(row, 14).Value = item.PromoName;
                    ws.Cell(row, 15).Value = item.SalePrice;
                    ws.Cell(row, 16).Value = item.SaleEndTime;
                    ws.Cell(row, 17).Value = item.CurrencyType;
                    ws.Cell(row, 18).Value = item.PromoEndTime;
                    ws.Cell(row, 19).Value = item.ShowSaleTime;
                    ws.Cell(row, 20).Value = item.BonusQuantity;
                    ws.Cell(row, 21).Value = item.SaleStartTime;
                    ws.Cell(row, 22).Value = item.DurationInDays;
                    ws.Cell(row, 23).Value = item.JobRequirement;
                    ws.Cell(row, 24).Value = item.PromoStartTime;
                    ws.Cell(row, 25).Value = item.RequireMaxLevel;
                    ws.Cell(row, 26).Value = item.RequireMinLevel;
                    ws.Cell(row, 27).Value = item.RestockUnavailable;
                    ws.Cell(row, 28).Value = item.RequireAchievementId;
                    ws.Cell(row, 29).Value = item.RequireAchievementRank;
                    row++;
                }

                // 自动列宽
                ws.Columns().AdjustToContents();

                wb.SaveAs(path);
                MessageBox.Show($"导出成功：{_allItems.Count} 条商品\n路径：{path}", "导出完成", MessageBoxButton.OK, MessageBoxImage.Information);
            }
            else
            {
                // CSV 导出
                var headers = "num,Id,Price,TabId,Banner,ItemId,PcCafe,Rarity,SaleTag,Giftable,ParentId,Quantity,BannerTag,PromoName,SalePrice,SaleEndTime,CurrencyType,PromoEndTime,ShowSaleTime,BonusQuantity,SaleStartTime,DurationInDays,JobRequirement,PromoStartTime,RequireMaxLevel,RequireMinLevel,RestockUnavailable,RequireAchievementId,RequireAchievementRank";
                var lines = new List<string> { headers };
                foreach (var item in _allItems.OrderBy(i => i.Id))
                {
                    lines.Add($"{item.Id},{item.Id},{item.Price},{item.TabId},\"{item.Banner}\",{item.ItemId},{item.PcCafe},{item.Rarity},{item.SaleTag},{item.Giftable},{item.ParentId},{item.Quantity},{item.BannerTag},\"{item.PromoName}\",{item.SalePrice},{item.SaleEndTime},{item.CurrencyType},{item.PromoEndTime},{item.ShowSaleTime},{item.BonusQuantity},{item.SaleStartTime},{item.DurationInDays},{item.JobRequirement},{item.PromoStartTime},{item.RequireMaxLevel},{item.RequireMinLevel},{item.RestockUnavailable},{item.RequireAchievementId},{item.RequireAchievementRank}");
                }

                var utf8Bom = new UTF8Encoding(true);
                File.WriteAllLines(path, lines, utf8Bom);
                MessageBox.Show($"导出成功：{_allItems.Count} 条商品\n路径：{path}", "导出完成", MessageBoxButton.OK, MessageBoxImage.Information);
            }
        }
        catch (Exception ex)
        {
            MessageBox.Show("导出失败: " + ex.Message, "错误", MessageBoxButton.OK, MessageBoxImage.Error);
        }
    }

    // ── XLSX helpers ─────────────────────────────
    static int GetXlsxInt(IXLRangeRow row, Dictionary<string, int> headers, string key, int def = 0)
        => headers.TryGetValue(key, out var c) && int.TryParse(row.Cell(c).GetString(), out var v) ? v : def;

    static long GetXlsxLong(IXLRangeRow row, Dictionary<string, int> headers, string key, long def = 0)
        => headers.TryGetValue(key, out var c) && long.TryParse(row.Cell(c).GetString(), out var v) ? v : def;

    static string GetXlsxStr(IXLRangeRow row, Dictionary<string, int> headers, string key)
        => headers.TryGetValue(key, out var c) ? row.Cell(c).GetString().Trim() : "";

    static bool GetXlsxBool(IXLRangeRow row, Dictionary<string, int> headers, string key)
        => headers.TryGetValue(key, out var c) && bool.TryParse(row.Cell(c).GetString(), out var v) && v;

    // ── Combo helper ─────────────────────────────
    static int GetComboTag(ComboBox cmb)
    {
        if (cmb.SelectedItem is ComboBoxItem ci && ci.Tag != null)
        {
            // Tag in XAML is string, parse to int
            if (int.TryParse(ci.Tag.ToString(), out int t)) return t;
        }
        return 0;
    }

    // ── Timestamp helper (YYYYMMDD → long) ───────
    static long ParseTimestamp(string s)
    {
        if (string.IsNullOrWhiteSpace(s)) return 0;
        if (long.TryParse(s, out var v)) return v;
        if (int.TryParse(s, out var i))
        {
            // assume YYYYMMDD format
            return i;
        }
        return 0;
    }

    // ── CSV parser ────────────────────────────────
    static string[] ParseCsvLine(string line)
    {
        var result = new List<string>();
        bool inQuotes = false;
        var sb = new StringBuilder();
        for (int i = 0; i < line.Length; i++)
        {
            char c = line[i];
            if (c == '"')
            {
                if (inQuotes && i + 1 < line.Length && line[i + 1] == '"') { sb.Append('"'); i++; }
                else inQuotes = !inQuotes;
            }
            else if (c == ',' && !inQuotes)
            {
                result.Add(sb.ToString().Trim());
                sb.Clear();
            }
            else sb.Append(c);
        }
        result.Add(sb.ToString().Trim());
        return result.ToArray();
    }

    static int GetInt(string[] cols, Dictionary<string, int> h, string key, int def = 0)
        => h.TryGetValue(key, out var idx) && idx < cols.Length && int.TryParse(cols[idx], out var v) ? v : def;

    static long GetLong(string[] cols, Dictionary<string, int> h, string key, long def = 0)
        => h.TryGetValue(key, out var idx) && idx < cols.Length && long.TryParse(cols[idx], out var v) ? v : def;

    static string GetStr(string[] cols, Dictionary<string, int> h, string key)
        => h.TryGetValue(key, out var idx) && idx < cols.Length ? cols[idx] : "";

    static bool GetBool(string[] cols, Dictionary<string, int> h, string key)
        => h.TryGetValue(key, out var idx) && idx < cols.Length && bool.TryParse(cols[idx], out var v) && v;

    // ── Apply changes to DB ──────────────────────
    void BtnApply_Click(object sender, RoutedEventArgs e)
    {
        if (!_hasChanges)
        {
            MessageBox.Show("没有需要保存的修改", "提示", MessageBoxButton.OK, MessageBoxImage.Information);
            return;
        }
        if (SaveToDb())
        {
            MessageBox.Show("已成功应用到数据库！", "成功", MessageBoxButton.OK, MessageBoxImage.Information);
        }
    }

    // ── Dirty indicator ─────────────────────────
    void MarkDirty(bool dirty)
    {
        _hasChanges = dirty;
        if (BtnApply != null)
        {
            BtnApply.Content = dirty ? "应用 *" : "应用";
            BtnApply.IsEnabled = dirty || true; // always enabled for preview refresh
        }
        // Update XML preview if visible
        if (_xmlPreviewVisible) UpdateXmlPreview();
    }

    // ── XML Preview ─────────────────────────────
    bool _xmlPreviewVisible;

    void BtnToggleXmlPreview_Click(object sender, RoutedEventArgs e)
    {
        _xmlPreviewVisible = !_xmlPreviewVisible;
        XmlPreviewPanel.Visibility = _xmlPreviewVisible ? Visibility.Visible : Visibility.Collapsed;
        BtnToggleXmlPreview.Content = _xmlPreviewVisible ? "▲ 隐藏预览" : "▼ XML 预览";
        if (_xmlPreviewVisible) UpdateXmlPreview();
    }

    void UpdateXmlPreview()
    {
        if (TxbXmlPreview == null) return;
        try
        {
            TxbXmlPreview.Text = BuildPreviewJson();
        }
        catch (Exception ex)
        {
            TxbXmlPreview.Text = "生成预览失败: " + ex.Message;
        }
    }

    // ── Menu Event Handlers ───────────────────────
    void BtnMenuMarket_Click(object sender, RoutedEventArgs e)
    {
        SubMenuMarket.Visibility = Visibility.Visible;
        SubMenuUser.Visibility = Visibility.Collapsed;
        MainTab.SelectedIndex = 0; // 默认显示商品列表
        UpdateMenuButtonStyles(sender as Button);
    }

    void BtnSubMenuList_Click(object sender, RoutedEventArgs e)
    {
        MainTab.SelectedIndex = 0;
        UpdateSubMenuButtonStyles(sender as Button);
    }

    void BtnSubMenuAdd_Click(object sender, RoutedEventArgs e)
    {
        MainTab.SelectedIndex = 1;
        UpdateSubMenuButtonStyles(sender as Button);
    }

    void BtnSubMenuEdit_Click(object sender, RoutedEventArgs e)
    {
        MainTab.SelectedIndex = 2;
        UpdateSubMenuButtonStyles(sender as Button);
    }

    void BtnSubMenuImport_Click(object sender, RoutedEventArgs e)
    {
        MainTab.SelectedIndex = 3;
        UpdateSubMenuButtonStyles(sender as Button);
    }

    void BtnSubMenuExport_Click(object sender, RoutedEventArgs e)
    {
        MainTab.SelectedIndex = 3;
        UpdateSubMenuButtonStyles(sender as Button);
    }

    void UpdateMenuButtonStyles(Button? activeBtn)
    {
        BtnMenuMarket.Style = (Style)FindResource("BtnSecondary");
        if (activeBtn != null)
            activeBtn.Style = (Style)FindResource("BtnPrimary");
    }

    void UpdateSubMenuButtonStyles(Button? activeBtn)
    {
        // Reset all sub-menu buttons to secondary style
        BtnSubMenuList.Style = (Style)FindResource("BtnSecondary");
        BtnSubMenuAdd.Style = (Style)FindResource("BtnSecondary");
        BtnSubMenuEdit.Style = (Style)FindResource("BtnSecondary");
        BtnSubMenuImport.Style = (Style)FindResource("BtnSecondary");
        BtnSubMenuExport.Style = (Style)FindResource("BtnSecondary");
        
        if (activeBtn != null)
            activeBtn.Style = (Style)FindResource("BtnPrimary");
    }
}

// ────────────────────────────────────────────────
// MeretItem — view model
// ────────────────────────────────────────────────
public class MeretItem
{
    public bool IsSelected { get; set; }
    public bool IsStaged { get; set; }  // true = 未保存到数据库的新增/修改
    public int Id { get; set; }
    public int ParentId { get; set; }
    public int TabId { get; set; }
    public string Banner { get; set; } = "";
    public int BannerTag { get; set; }
    public int ItemId { get; set; }
    public int Rarity { get; set; }
    public int Quantity { get; set; }
    public int BonusQuantity { get; set; }
    public int DurationInDays { get; set; }
    public int SaleTag { get; set; }
    public int CurrencyType { get; set; }
    public long Price { get; set; }
    public long SalePrice { get; set; }
    public long SaleStartTime { get; set; } = 1726502400;
    public long SaleEndTime { get; set; } = 2704723200;
    public int JobRequirement { get; set; }
    public bool RestockUnavailable { get; set; }
    public int RequireMinLevel { get; set; }
    public int RequireMaxLevel { get; set; }
    public int RequireAchievementId { get; set; }
    public int RequireAchievementRank { get; set; }
    public bool PcCafe { get; set; }
    public bool Giftable { get; set; }
    public bool ShowSaleTime { get; set; }
    public string PromoName { get; set; } = "";
    public long PromoStartTime { get; set; }
    public long PromoEndTime { get; set; }

    public string SaleStartStr => SaleStartTime > 0 ? SaleStartTime.ToString() : "-";
    public string SaleEndStr => SaleEndTime > 0 ? SaleEndTime.ToString() : "-";
    public string SaleTagStr => SaleTag switch
    {
        1 => "新",
        2 => "HOT",
        3 => "活动",
        4 => "折扣",
        _ => ""
    };

    // 所有字段都写，只有 Banner/PromoName 为空时不写
    public Dictionary<string, object?> ToDict()
    {
        var d = new Dictionary<string, object?>();
        d["Id"] = Id;
        d["Price"] = Price;
        d["TabId"] = TabId;
        d["Banner"] = Banner ?? ""; // 必须写入，null 时用空字符串（避免服务器反序列化空引用）
        d["ItemId"] = ItemId;
        d["PcCafe"] = PcCafe;
        d["Rarity"] = Rarity;
        d["SaleTag"] = SaleTag;
        d["Giftable"] = Giftable;
        d["ParentId"] = ParentId;
        d["Quantity"] = Quantity;
        d["BannerTag"] = BannerTag;
        d["PromoName"] = PromoName ?? ""; // 必须写入，null 时用空字符串（避免服务器反序列化空引用）
        d["SalePrice"] = SalePrice;
        d["SaleEndTime"] = SaleEndTime;
        d["CurrencyType"] = CurrencyType;
        d["PromoEndTime"] = PromoEndTime;
        d["ShowSaleTime"] = ShowSaleTime;
        d["BonusQuantity"] = BonusQuantity;
        d["SaleStartTime"] = SaleStartTime;
        d["DurationInDays"] = DurationInDays;
        d["JobRequirement"] = JobRequirement;
        d["PromoStartTime"] = PromoStartTime;
        d["RequireMaxLevel"] = RequireMaxLevel;
        d["RequireMinLevel"] = RequireMinLevel;
        d["RestockUnavailable"] = RestockUnavailable;
        d["RequireAchievementId"] = RequireAchievementId;
        d["RequireAchievementRank"] = RequireAchievementRank;
        return d;
    }
}