using Gs.Toolbox;
using Gs.Toolbox.ApiCore.Abstract.Mvc;
using Gs.Toolbox.ApiCore.Common.Mvc;
using Gs.Toolbox.ApiCore.Group;
using GS.Sys.Models;
using Microsoft.AspNetCore.Http;
using Microsoft.AspNetCore.Http.HttpResults;
using Microsoft.AspNetCore.Mvc;
using Newtonsoft.Json.Linq;
using System.Data;
using System.Data.SqlClient;

namespace GS.Sys.Service;

/// <summary>
///     ¿´°åĿ¼¹ÜÀí£¨´æ´¢¹ý³Ì°æ±¾£©
/// </summary>
[ApiGroup(ApiGroupNames.Sys)]
public class MesSimpleManager : Repository<MesSimple>, IRomteService
{
    private readonly IHttpContextAccessor _http;
    private readonly string _userCode, _userGuid, _orgFids;

    public MesSimpleManager(IHttpContextAccessor httpContextAccessor)
    {
        _http = httpContextAccessor;
        (_userCode, _userGuid, _orgFids) = UtilityHelper.GetUserGuidAndOrgGuid(_http);
    }

    /// <summary>
    ///     ²éѯÁÐ±í£¬Ö§³Ö·ÖÒ³
    /// </summary>
    [RequestMethod(RequestMethods.POST)]
    public ReturnDto<PageList<dynamic>> GetListPage(PageQuery query)
    {
        try
        {
            // Ìí¼Ó 'a.' ǰ׺ÒÔÆ¥Åä´æ´¢¹ý³Ì
            var sortField = "a." + (query.sortName?.Replace("a.", "") ?? "sort_order");
            var sortOrder = query.sortOrder?.ToUpper() ?? "ASC";

            // ¹¹½¨´æ´¢¹ý³Ì²ÎÊý
            var parameters = new SqlParameter[]
            {
                new SqlParameter("@pageIndex", SqlDbType.Int) { Value = query.currentPage },
                new SqlParameter("@pageSize", SqlDbType.Int) { Value = query.everyPageSize },
                new SqlParameter("@sortField", SqlDbType.NVarChar, 50) { Value = sortField },
                new SqlParameter("@sortOrder", SqlDbType.NVarChar, 10) { Value = sortOrder },
                new SqlParameter("@keyWord", SqlDbType.NVarChar, 100) { Value = query.keyWord ?? "" },
                new SqlParameter("@keyWhere", SqlDbType.NVarChar, -1) { Value = "" }
            };

            // µ÷Óô洢¹ý³Ì£¨×¢ÒâÃû³Æ£©
            var dset = DbHelperSQL.RunProcedure("proc_MesSimple_GetListPage", parameters, "ResultSet");

            if (dset == null || dset.Tables.Count == 0 || dset.Tables[0].Rows.Count == 0)
            {
                var emptyList = new PageList<dynamic>(new List<dynamic>(), 0, query.everyPageSize);
                return ReturnDto<PageList<dynamic>>.QuickReturn<PageList<dynamic>>(emptyList, ReturnCode.Success, "ÔÝÎÞÊý¾Ý");
            }

            // »ñÈ¡×ܼǼÊý
            var totalCount = 0;
            if (dset.Tables[0].Rows.Count > 0)
            {
                var firstRow = dset.Tables[0].Rows[0];
                if (firstRow.Table.Columns.Contains("totalCount"))
                {
                    totalCount = Convert.ToInt32(firstRow["totalCount"]);
                }
            }

            // ת»»Îª¶¯Ì¬¶ÔÏóÁбí
            var itemsList = dset.Tables[0].TableToDynamicList();

            var pageList = new PageList<dynamic>(itemsList, totalCount, query.everyPageSize);
            return ReturnDto<PageList<dynamic>>.QuickReturn<PageList<dynamic>>(pageList, ReturnCode.Success, "¶ÁÈ¡³É¹¦");
        }
        catch (Exception ex)
        {
            LogHelper.Debug(ToString(), $"GetListPage error: {ex.Message}\nStackTrace: {ex.StackTrace}");
            var emptyList = new PageList<dynamic>(new List<dynamic>(), 0, query.everyPageSize);
            return ReturnDto<PageList<dynamic>>.QuickReturn<PageList<dynamic>>(emptyList, ReturnCode.Exception, "²éѯʧ°Ü£º" + ex.Message);
        }
    }

    /// <summary>
    ///     ¶ÁÈ¡µ¥Ìõ¼Ç¼
    /// </summary>
    [RequestMethod(RequestMethods.POST)]
    public ReturnDto<dynamic> GetModel([FromBody] MesSimple model)
    {
        try
        {
            var parameters = new SqlParameter[]
            {
                new SqlParameter("@id", SqlDbType.BigInt) { Value = model.Id }
            };

            var dset = DbHelperSQL.RunProcedure("proc_MesSimple_GetModel", parameters, "ResultSet");

            if (dset == null || dset.Tables.Count == 0 || dset.Tables[0].Rows.Count == 0)
            {
                return ReturnDto<dynamic>.QuickReturn<dynamic>(null, ReturnCode.Default, "Êý¾Ý²»´æÔÚ£¡");
            }

            var m = dset.Tables[0].Rows[0].RowToDynamic();
            return ReturnDto<dynamic>.QuickReturn<dynamic>(m, ReturnCode.Success, "¶ÁÈ¡³É¹¦£¡");
        }
        catch (Exception ex)
        {
            LogHelper.Debug(ToString(), $"GetModel error: {ex.Message}");
            return ReturnDto<dynamic>.QuickReturn<dynamic>(null, ReturnCode.Exception, "¶Áȡʧ°Ü£º" + ex.Message);
        }
    }

    /// <summary>
    ///     ±£´æÊý¾Ý (ÐÂÔö/ÐÞ¸Ä)
    /// </summary>
    [RequestMethod(RequestMethods.POST)]
    public ReturnDto<string> SaveModel([FromBody] MesSimple model)
    {
        try
        {
            if (string.IsNullOrWhiteSpace(model.Title))
            {
                return ReturnDto<string>.QuickReturn("", ReturnCode.Default, "Ãû³Æ²»ÄÜΪ¿Õ£¡");
            }

            var parameters = new SqlParameter[]
            {
                new SqlParameter("@id", SqlDbType.BigInt) { Value = model.Id },
                new SqlParameter("@parentId", SqlDbType.BigInt) { Value = model.ParentId.HasValue ? (object)model.ParentId.Value : DBNull.Value },
                new SqlParameter("@nodeType", SqlDbType.TinyInt) { Value = model.NodeType },
                new SqlParameter("@code", SqlDbType.NVarChar, 50) { Value = string.IsNullOrEmpty(model.Code) ? DBNull.Value : model.Code },
                new SqlParameter("@title", SqlDbType.NVarChar, 255) { Value = model.Title },
                new SqlParameter("@url", SqlDbType.NVarChar, 500) { Value = string.IsNullOrEmpty(model.Url) ? DBNull.Value : model.Url },
                new SqlParameter("@carouselDuration", SqlDbType.Int) { Value = model.CarouselDuration.HasValue ? (object)model.CarouselDuration.Value : DBNull.Value },
                new SqlParameter("@isExpanded", SqlDbType.Bit) { Value = model.IsExpanded },
                new SqlParameter("@isEnabled", SqlDbType.Bit) { Value = model.IsEnabled },
                new SqlParameter("@sortOrder", SqlDbType.Int) { Value = model.SortOrder },
                new SqlParameter("@userCode", SqlDbType.NVarChar, 50) { Value = _userCode ?? "SYSTEM" },
                new SqlParameter("@outId", SqlDbType.BigInt) { Direction = ParameterDirection.Output },
                new SqlParameter("@outMsg", SqlDbType.NVarChar, 500) { Direction = ParameterDirection.Output }
            };
            // Ìí¼Óµ÷ÊÔÈÕÖ¾
            LogHelper.Debug(ToString(), $"SaveModel - ²ÎÊýÊýÁ¿: {parameters.Length}");
            DbHelperSQL.RunProcedure("proc_MesSimple_Save", parameters, "0");//ResultSet
            var outId = parameters[11].Value != DBNull.Value ? Convert.ToInt64(parameters[11].Value) : 0;
            var outMsg = parameters[12].Value != DBNull.Value ? parameters[12].Value.ToString() : "²Ù×÷³É¹¦";

            if (outId > 0)
            {
                return ReturnDto<string>.QuickReturn(outId.ToString(), ReturnCode.Success, outMsg);
            }
            else
            {
                return ReturnDto<string>.QuickReturn("", ReturnCode.Default, outMsg);
            }
        }
        catch (Exception ex)
        {
            LogHelper.Debug(ToString(), $"SaveModel error: {ex.Message}");
            return ReturnDto<string>.QuickReturn("", ReturnCode.Exception, "±£´æʧ°Ü£º" + ex.Message);
        }
    }

    /// <summary>
    ///     ɾ³ýÊý¾Ý (Èíɾ³ý) - ÐÞ¸´°æ
    /// </summary>
    [RequestMethod(RequestMethods.POST)]
    public ReturnDto<int> DeleteModel([FromBody] JToken data)
    {
        try
        {
            string idStr = null;

            LogHelper.Debug(ToString(), $"DeleteModel received: {data?.ToString()}, Type: {data?.Type}");

            if (data == null)
            {
                return ReturnDto<int>.QuickReturn(0, ReturnCode.Default, "ÇëÑ¡ÔñҪɾ³ýµÄÊý¾Ý£¡");
            }

            // ÖÇÄܽâÎö¸÷ÖÖÊý¾Ý¸ñʽ
            if (data is JArray jArray)
            {
                if (jArray.Count == 0)
                {
                    return ReturnDto<int>.QuickReturn(0, ReturnCode.Default, "ÇëÑ¡ÔñҪɾ³ýµÄÊý¾Ý£¡");
                }
                idStr = jArray[0].ToString();
            }
            else if (data is JValue jValue)
            {
                idStr = jValue.ToString();
            }
            else if (data is JObject jObject)
            {
                idStr = jObject["id"]?.ToString() ?? jObject["Id"]?.ToString();
            }
            else
            {
                idStr = data.ToString();
            }

            if (string.IsNullOrEmpty(idStr) || !long.TryParse(idStr, out long id))
            {
                return ReturnDto<int>.QuickReturn(0, ReturnCode.Default, $"ÎÞЧµÄID£º{idStr}");
            }

            LogHelper.Debug(ToString(), $"DeleteModel parsed ID: {id}");

            // µ÷Óô洢¹ý³Ì£¨×¢Òâ²ÎÊýÃûÊÇ @ids£©
            var parameters = new SqlParameter[]
            {
                new SqlParameter("@ids", SqlDbType.NVarChar, -1) { Value = id.ToString() },
                new SqlParameter("@userCode", SqlDbType.NVarChar, 50) { Value = _userCode ?? "SYSTEM" },
                new SqlParameter("@outCode", SqlDbType.Int) { Direction = ParameterDirection.Output },
                new SqlParameter("@outMsg", SqlDbType.NVarChar, 500) { Direction = ParameterDirection.Output }
            };

            DbHelperSQL.RunProcedure("proc_MesSimple_Delete", parameters, "0");

            var outCode = parameters[2].Value != DBNull.Value ? Convert.ToInt32(parameters[2].Value) : 0;
            var outMsg = parameters[3].Value != DBNull.Value ? parameters[3].Value.ToString() : "δ֪´íÎó";

            LogHelper.Debug(ToString(), $"DeleteModel result: code={outCode}, msg={outMsg}");

            if (outCode > 0)
            {
                return ReturnDto<int>.QuickReturn(outCode, ReturnCode.Success, outMsg);
            }
            else
            {
                return ReturnDto<int>.QuickReturn(0, ReturnCode.Default, outMsg);
            }
        }
        catch (Exception ex)
        {
            LogHelper.Debug(ToString(), $"DeleteModel error: {ex.Message}\n{ex.StackTrace}");
            return ReturnDto<int>.QuickReturn(0, ReturnCode.Exception, "ɾ³ýʧ°Ü£º" + ex.Message);
        }
    }

    /// <summary>
    ///     »ñÈ¡Ê÷Ðνṹ
    /// </summary>
    [RequestMethod(RequestMethods.POST)]
    public ReturnDto<List<dynamic>> GetTree(long? rootId = null)
    {
        try
        {
            var parameters = new SqlParameter[]
            {
                new SqlParameter("@RootId", SqlDbType.BigInt) { Value = rootId.HasValue ? (object)rootId.Value : DBNull.Value }
            };

            var dset = DbHelperSQL.RunProcedure("usp_MesSimple_GetTree", parameters, "ResultSet");

            if (dset == null || dset.Tables.Count == 0)
            {
                return ReturnDto<List<dynamic>>.QuickReturn<List<dynamic>>(new List<dynamic>(), ReturnCode.Success, "ÔÝÎÞÊý¾Ý");
            }

            var treeList = dset.Tables[0].TableToDynamicList();
            return ReturnDto<List<dynamic>>.QuickReturn<List<dynamic>>(treeList, ReturnCode.Success, "¶ÁÈ¡³É¹¦");
        }
        catch (Exception ex)
        {
            LogHelper.Debug(ToString(), $"GetTree error: {ex.Message}");
            return ReturnDto<List<dynamic>>.QuickReturn<List<dynamic>>(new List<dynamic>(), ReturnCode.Exception, "²éѯʧ°Ü£º" + ex.Message);
        }
    }

    /// <summary>
    ///     ¸üÐÂÅÅÐòÐòºÅ
    /// </summary>
    [RequestMethod(RequestMethods.POST)]
    public ReturnDto<bool> UpdateSortOrder(long id, int sortOrder)
    {
        try
        {
            var parameters = new SqlParameter[]
            {
                new SqlParameter("@Id", SqlDbType.BigInt) { Value = id },
                new SqlParameter("@NewSortOrder", SqlDbType.Int) { Value = sortOrder }
            };

            var dset = DbHelperSQL.RunProcedure("usp_MesSimple_UpdateSortOrder", parameters, "ResultSet");

            if (dset != null && dset.Tables.Count > 0 && dset.Tables[0].Rows.Count > 0)
            {
                var row = dset.Tables[0].Rows[0];
                var rtnCode = Convert.ToInt32(row["rtnCode"]);
                var rtnMsg = row["rtnMsg"].ToString();

                if (rtnCode > 0)
                {
                    return ReturnDto<bool>.QuickReturn(true, ReturnCode.Success, rtnMsg);
                }
                else
                {
                    return ReturnDto<bool>.QuickReturn(false, ReturnCode.Default, rtnMsg);
                }
            }

            return ReturnDto<bool>.QuickReturn(false, ReturnCode.Default, "¸üÐÂʧ°Ü£¡");
        }
        catch (Exception ex)
        {
            LogHelper.Debug(ToString(), $"UpdateSortOrder error: {ex.Message}");
            return ReturnDto<bool>.QuickReturn(false, ReturnCode.Exception, "¸üÐÂʧ°Ü£º" + ex.Message);
        }
    }
}