using System.Data;
using System.Dynamic;
using System.Security.Cryptography;
using System.Text;
using Microsoft.AspNetCore.Http;

namespace Gs.Toolbox;

public static class UtilityHelper
{

    /// <summary>
    /// 读取登录用户信息：返回用户Code，用户Guid，组织ID
    /// </summary>
    /// <param name="_http"></param>
    /// <returns></returns>
    public static (string?, string?, string?) GetUserGuidAndOrgGuid(
        IHttpContextAccessor _http)
    {
        try
        {
            string _token = _http.HttpContext.Request.Headers["token"];
            var _userGuid = _token;
            var _sb = new StringBuilder();
            _sb.Append("select ACCOUNT as t1,'' as t3 from SYS_USER where guid='" + _userGuid + "' ");
            var dset = new DataSet();
            dset = DbHelperSQL.Query(_sb.ToString());
            if (dset != null && dset.Tables[0].Rows.Count > 0)
            {
                DataRow _row = dset.Tables[0].Rows[0];
                var _userCode = _row["t1"].ToString();
                var _orgFids = _row["t3"].ToString();
                return (_userCode, _userGuid, _orgFids);
            }
            return (null, null, null);
        }
        catch (Exception ex)
        {
            LogHelper.Debug("GetUserGuidAndOrgGuid:", ex.Message);
        }
        return (null, null, null);
    }

    /// <summary>
    ///     32位MD5加密
    /// </summary>
    /// <param name="password"></param>
    /// <returns></returns>
    public static string MD5Encrypt32(string password)
    {
        var cl = password;
        var pwd = "";
        var md5 = MD5.Create();
        var s = md5.ComputeHash(Encoding.UTF8.GetBytes(cl));
        for (var i = 0; i < s.Length; i++) pwd = pwd + s[i].ToString("X");
        return pwd;
    }

    /// <summary>
    ///     table转DynamicList
    /// </summary>
    /// <param name="table"></param>
    /// <returns></returns>
    public static List<dynamic> TableToDynamicList(this DataTable table)
    {
        var list = new List<dynamic>();
        // 遍历DataTable中的每一行
        foreach (DataRow row in table.Rows)
        {
            dynamic item = new ExpandoObject();
            // 遍历每一列，并添加到dynamic对象中
            foreach (DataColumn column in table.Columns)
                ((IDictionary<string, object>)item)[column.ColumnName] =
                    row[column];
            list.Add(item);
        }

        return list;
    }

    /// <summary>
    ///     row转DynamicList
    /// </summary>
    /// <param name="row"></param>
    /// <returns></returns>
    public static dynamic RowToDynamic(this DataRow row)
    {
        dynamic expando = new ExpandoObject();
        if (row != null)
            foreach (DataColumn column in row.Table.Columns)
            {
                var value = row[column];
                // 如果值为DBNull.Value，则转换为null
                if (value == DBNull.Value) value = null;
                ((IDictionary<string, object>)expando)[column.ColumnName] =
                    value;
            }

        return expando;
    }

    public static int? ToInt(string strV)
    {
        if (string.IsNullOrEmpty(strV))
            return null;
        return int.Parse(strV);
    }

    /// <summary>
    /// </summary>
    /// <param name="_userGuid">操作用户</param>
    /// <param name="_abtGuid">关联主键，有时候会为null</param>
    /// <param name="_tableName">表名，表描述</param>
    /// <param name="_logTxt">行为</param>
    /// <returns></returns>
    public static StringBuilder BuildLog(string _userGuid, string _abtGuid,
        string _table, string _logTxt)
    {
        var sb = new StringBuilder();
        sb.Append(" exec prc_log_create '" + _userGuid + "','" + _abtGuid +
                  "','" + _table + "','" + _logTxt + "' ");
        return sb;
    }
     
    /// <summary>
    ///     判断是不是guid
    /// </summary>
    /// <param name="guid"></param>
    /// <returns></returns>
    public static bool CheckGuid(Guid? guid)
    {
        if (guid == Guid.Empty)
            return false;
        if (guid == null) return false;
        return true;
    }

    /// <summary>
    ///     判断是不是guid
    /// </summary>
    /// <param name="guid"></param>
    /// <returns></returns>
    public static bool CheckGuid(string? guid)
    {
        if (guid == Guid.Empty.ToString())
            return false;
        if (string.IsNullOrEmpty(guid))
            return false;
        if (guid == null) return false;
        return true;
    }
}