using CommunityToolkit.Mvvm.ComponentModel;
using HMI.Base;
using HMI.Core.Util;
using HMI.UI.Util;
using HMI.Util;
using Microsoft.Win32;
using Plugin.ModelManage.Entity;
using System;
using System.Collections.Generic;
using System.Collections.ObjectModel;
using System.Data;
using System.Drawing;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows;
using System.Windows.Controls;
using System.Windows.Data;
using System.Windows.Documents;
using System.Windows.Input;
using System.Windows.Media;
using System.Windows.Media.Imaging;
using System.Windows.Navigation;

namespace Plugin.ModelManage
{
    /// <summary>
    /// ModelManage.xaml 的交互逻辑
    /// </summary>
    [ObservableObject]
    public partial class ModelManage : SimpleMaskControl
    {
        private string dataFilePath;
        private SqliteHelper sqliteHelper;
        private double size = 30;

        [ObservableProperty]
        private ObservableCollection<ModelData> datasource;

        [ObservableProperty]
        private int currentPage;
        [ObservableProperty]
        private int maxPage;

        public ModelManage()
        {
            DataContext = this;
            InitializeComponent();
        }

        public override void InitFinish()
        {
            base.InitFinish();
            dataFilePath = Path.Combine(BaseFolder, "data.db");
            if (!File.Exists(dataFilePath))
            {
                SqliteHelper.CreateDatabase(dataFilePath);
            }
            sqliteHelper = new SqliteHelper(dataFilePath);
            sqliteHelper.ExecuteSql(@"CREATE TABLE IF NOT EXISTS ModelData (
                    Id INTEGER PRIMARY KEY AUTOINCREMENT,
                    Model TEXT NOT NULL,
                    CodeLength INT,
                    StartIndex INT,
                    Length INT,
                    Fixcode TEXT,
                    UNIQUE(Model),
                    UNIQUE(Fixcode));");
        }

        private void Button_Click(object sender, RoutedEventArgs e)
        {
            Button btn = sender as Button;
            ModelData data;
            switch (btn.Name)
            {
                case "addBtn":
                    OpenDataModal(new ModelData());
                    break;
                case "rfhBtn":
                    RefreshPage(CurrentPage);
                    break;
                case "exportBtn":
                    ExportExcel();
                    break;
                case "importBtn":
                    ImportExcel();
                    break;
                case "editBtn":
                    data = btn.Tag as ModelData;
                    OpenDataModal(data);
                    break;
                case "delBtn":
                    data = btn.Tag as ModelData;
                    DeleteData(data);
                    break;
                case "delBatchBtn":
                    DeleteBatchData();
                    break;
                default:
                    break;
            }
        }

        private void RefreshPage(int? page = null)
        {
            try
            {
                var sql = "SELECT COUNT (*) as num FROM ModelData;";
                var dt = sqliteHelper.GetDataTable(sql);
                if (dt.Rows.Count <= 0)
                {
                    CurrentPage = 1;
                    MaxPage = 1;
                    return;
                }
                int count = int.Parse(dt.Rows[0]["num"].ToString());
                MaxPage = (int)Math.Ceiling(count / size);

                if (page != null)
                {
                    CurrentPage = page.Value;
                }

                if (CurrentPage > MaxPage)
                {
                    CurrentPage = MaxPage;
                }

                if (page == CurrentPage)
                {
                    RefreshData();
                }
            }
            catch (Exception ex)
            {
                log.Error("RefreshPage Error.", ex);
                ToastHelper.Error($"刷新数据失败: {ex.Message}");
            }
        }

        private void RefreshData()
        {
            try
            {
                var list = new ObservableCollection<ModelData>();
                var sql = $"SELECT Id, Model, CodeLength, StartIndex, Length, Fixcode FROM ModelData ORDER BY Id DESC LIMIT ({CurrentPage - 1} * {size}), {size};";
                var dt = sqliteHelper.GetDataTable(sql);
                if (dt.Rows.Count > 0)
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        var at = new ModelData
                        {
                            Id = dr["Id"].ToString(),
                            Model = dr["Model"].ToString(),
                            CodeLength = int.Parse(dr["CodeLength"].ToString()),
                            StartIndex = int.Parse(dr["StartIndex"].ToString()),
                            //Length = int.Parse(dr["Length"].ToString()),
                            Fixcode = dr["Fixcode"].ToString()
                        };
                        list.Add(at);
                    }
                }
                Datasource = list;
            }
            catch (Exception ex)
            {
                log.Error("RefreshData Error.", ex);
                ToastHelper.Error($"刷新数据失败: {ex.Message}");
            }
        }

        private void ExportExcel()
        {
            try
            {
                SaveFileDialog sfd = new SaveFileDialog
                {
                    FileName = "型号管理",
                    Filter = "Excel|*.xls"
                };
                if (sfd.ShowDialog() == true)
                {
                    ExcelHelper.ExportExcel(sfd.FileName, Datasource);
                    ToastHelper.Success("导出成功");
                }
            }
            catch (Exception ex)
            {
                log.Error("ExportExcel Error.", ex);
                ToastHelper.Error($"导出失败: {ex.Message}");
            }
        }

        private void ImportExcel()
        {
            try
            {
                OpenFileDialog ofd = new OpenFileDialog
                {
                    Filter = "Excel|*.xls;*.xlsx"
                };
                if (ofd.ShowDialog() == true)
                {
                    List<ModelData> list = ExcelHelper.ReadFromExcel<ModelData>(ofd.FileName);
                    List<string> sqls = new List<string> {
                        "DELETE FROM ModelData;"
                    };
                    foreach (ModelData at in list)
                    {
                        sqls.Add($"INSERT INTO ModelData (Model,CodeLength,StartIndex,Fixcode) VALUES ('{at.Model}',{at.CodeLength},{at.StartIndex},'{at.Fixcode}');");
                    }

                    sqliteHelper.ExecuteBatchSql(sqls);
                    ToastHelper.Success("导入成功");
                    RefreshPage(CurrentPage);
                }
            }
            catch (Exception ex)
            {
                log.Error("ImportExcel Error.", ex);
                ToastHelper.Error($"导入失败: {ex.Message}");
            }
        }

        private void DeleteData(ModelData data)
        {
            try
            {
                if (MsgBoxHelper.WarnMessage(Window.GetWindow(this), "确定要删除该数据吗？") == MessageBoxResult.OK)
                {
                    string sql = $"DELETE FROM ModelData WHERE Id = {data.Id}";
                    sqliteHelper.ExecuteSql(sql);
                    ToastHelper.Success("删除成功");
                    RefreshPage(CurrentPage);
                }
            }
            catch (Exception ex)
            {
                log.Error("DeleteData Error.", ex);
                ToastHelper.Error($"删除失败: {ex.Message}");
            }
        }

        private void DeleteBatchData()
        {
            try
            {
                var datas = Datasource.Where(e => e.IsSelected).Select(e => e.Id).ToList();
                if (datas.Count <= 0) return;
                if (MsgBoxHelper.WarnMessage(Window.GetWindow(this), "确定要删除选中的数据吗？") == MessageBoxResult.OK)
                {
                    var ids = string.Join("','", datas);
                    string sql = $"DELETE FROM ModelData WHERE Id IN ('{ids}')";
                    sqliteHelper.ExecuteSql(sql);
                    ToastHelper.Success("删除成功");
                    RefreshPage(CurrentPage);
                }
            }
            catch (Exception ex)
            {
                log.Error("DeleteData Error.", ex);
                ToastHelper.Error($"删除失败: {ex.Message}");
            }
        }

        private void OpenDataModal(ModelData data)
        {
            try
            {
                var win = new DataModal
                {
                    Title = string.IsNullOrEmpty(data.Id) ? "新增" : "编辑",
                    Owner = Window.GetWindow(this)
                };
                if (win.Open(data, sqliteHelper) == true)
                {
                    RefreshPage(CurrentPage);
                }
            }
            catch (Exception ex)
            {
                log.Error("OpenDataModal Error.", ex);
            }
        }

        partial void OnCurrentPageChanged(int value)
        {
            RefreshData();
        }

        private void SimpleMaskControl_Loaded(object sender, RoutedEventArgs e)
        {
            RefreshPage(1);
            Loaded -= SimpleMaskControl_Loaded;
        }
    }
}