using System;
using System.Collections.Generic;
using System.Linq;
using System.Reflection.Emit;
using System.Security.Cryptography;
using System.Text;
using System.Threading.Tasks;
using System.Drawing;
using Newtonsoft.Json.Linq;
using Newtonsoft.Json;
using SkiaSharp;
using Microsoft.VisualBasic;
using Org.BouncyCastle.Utilities.Collections;
using System.Data;
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using NPOI.HSSF.UserModel;

namespace Competition.Common.Util
{
    /// <summary>
    /// 接口状态码
    /// </summary>
    public enum APICode
    {
        /// <summary>
        /// 成功
        /// </summary>
        Success,
        /// <summary>
        /// 失败
        /// </summary>
        Fail
    }

    /// <summary>
    /// 工具类
    /// </summary>
    public class Tool
    {
        private static string appkey = "bridge-fenglin0903";
        private static int vs = 0;

        /// <summary>
        /// 获取当前时间戳13位
        /// </summary>
        /// <returns></returns>
        public static long GetTimestamp()
        {
            TimeSpan ts = DateTime.Now.ToUniversalTime() - new DateTime(1970, 1, 1);//ToUniversalTime()转换为标准时区的时间,去掉的话直接就用北京时间
            return (long)ts.TotalMilliseconds; //精确到毫秒
            //return (long)ts.TotalSeconds;//获取10位
        }

        /// <summary>
        /// 获取带状态码的JSON字符串
        /// </summary>
        /// <param name="code"></param>
        /// <param name="dataObj"></param>
        /// <returns></returns>
        public static object GetJsonWithCode(APICode code, object dataObj)
        {
            return new { code = (int)code, state = code.ToString(), data = dataObj };
        }

        /// <summary>  
        /// 将c# DateTime时间格式转换为Unix时间戳格式  
        /// </summary>  
        /// <param name="time">时间</param>  
        /// <returns>long</returns>  
        public static long DateTimeToTimestamp(System.DateTime time)
        {
            System.DateTime startTime = TimeZone.CurrentTimeZone.ToLocalTime(new System.DateTime(1970, 1, 1, 0, 0, 0, 0));
            long t = (time.Ticks - startTime.Ticks) / 10000;   //除10000调整为13位      
            return t;
        }

        /// <summary>
        /// 时间戳转换为DATETIME格式
        /// </summary>
        /// <param name="timeStamp">时间戳字符串</param>
        /// <returns></returns>
        public static DateTime GetDateTime(string timeStamp)
        {
            DateTime dtStart = TimeZone.CurrentTimeZone.ToLocalTime(new DateTime(1970, 1, 1));
            string ts = timeStamp + "0000000";
            if (timeStamp.Length == 13)
            {
                ts = timeStamp + "0000";
            }
            long lTime = long.Parse(ts);
            TimeSpan toNow = new TimeSpan(lTime);
            return dtStart.Add(toNow);
        }

        /// <summary>
        /// md5密码加密
        /// </summary>
        /// <param name="passWord">待加密字符串</param>
        /// <returns></returns>
        public static string GetMD5(string passWord)
        {
            MD5 md5 = new MD5CryptoServiceProvider();
            byte[] bt = Encoding.Default.GetBytes(passWord);//将待加密字符转为 字节型数组
            byte[] resualt = md5.ComputeHash(bt);//将字节数组转为加密的字节数组
            string pwds = BitConverter.ToString(resualt).Replace("-", "");
            passWord = pwds;
            return passWord;
        }

        /// <summary>
        /// 图片转成base64
        /// </summary>
        /// <param name="Imagefilename"></param>
        /// <returns></returns>
        public static string img_to_base64(string Imagefilename)
        {
            try
            {
                using (MemoryStream memoryStream = new MemoryStream())
                {
                    Bitmap file = new Bitmap(Imagefilename);
                    file.Save(memoryStream, file.RawFormat);
                    file.Dispose();
                    byte[] imageBytes = memoryStream.ToArray();
                    return Convert.ToBase64String(imageBytes);
                }
            }
            catch (Exception)
            {
                return "";
            }
        }

        ///// <summary>
        ///// 生成图片
        ///// </summary>
        ///// <param name="name">名称</param>
        ///// <param name="start">起点</param>
        ///// <param name="end">终点</param>
        ///// <param name="model_length">型号长度</param>
        ///// <param name="path">生成图片后的路径</param>
        ///// <param name="root_path">wwwroot文件</param>
        //public static string GeneratePictures(string name, string start, string end, string model_length, string path, string root_path)
        //{
        //    try
        //    {
        //        Font LabelFont = new Font("Adobe 黑体 Std R", 50); //设置字体、字号、是否加粗
        //        SolidBrush labelColor = new SolidBrush(Color.Black);//设置字体颜色
        //        MemoryStream ms = new MemoryStream(File.ReadAllBytes(root_path + "/Img/BaseMap.jpg"));//底图
        //        Image imgSource = Image.FromStream(ms);//底图
        //        Graphics graphics = Graphics.FromImage(imgSource);//设置画图对象
        //        StringFormat sf = new StringFormat();//位置对象
        //        sf.Alignment = StringAlignment.Near;//左对齐，使用时看一下注释，尝试一下，和矩形框有关系
        //                                            //sf.Alignment = StringAlignment.Center;//居中
        //                                            //sf.Alignment = StringAlignment.Near;//右对齐
        //        Rectangle rt1 = new Rectangle(240, 155, imgSource.Width, imgSource.Height);//绘图区域框，0：x方向开始位置，20：y方向开始位置，宽和高是矩形的宽和高
        //        graphics.DrawString(name, LabelFont, labelColor, rt1, sf);
        //        Rectangle rt2 = new Rectangle(240, 230, imgSource.Width, imgSource.Height);
        //        graphics.DrawString(start, LabelFont, labelColor, rt2, sf);
        //        Rectangle rt3 = new Rectangle(240, 305, imgSource.Width, imgSource.Height);
        //        graphics.DrawString(end, LabelFont, labelColor, rt3, sf);
        //        Rectangle rt4 = new Rectangle(360, 380, imgSource.Width, imgSource.Height);
        //        graphics.DrawString(model_length, LabelFont, labelColor, rt4, sf);
        //        Rectangle rt5 = new Rectangle(360, 455, imgSource.Width, imgSource.Height);
        //        graphics.DrawString("配电工程处", LabelFont, labelColor, rt5, sf);
        //        Rectangle rt6 = new Rectangle(240, 530, imgSource.Width, imgSource.Height);
        //        graphics.DrawString("2019年8月16日", LabelFont, labelColor, rt6, sf);
        //        //graphics.DrawString("另一种写法，我在x、y位置", LabelFont, labelColor, x, y);//相对于左上角的x、y坐标
        //        imgSource.Save(root_path + path);
        //        imgSource.Dispose();
        //        graphics.Dispose();
        //        return "true";
        //    }
        //    catch (Exception ex)
        //    {
        //        return ex.Message;
        //    }
        //}
        /// <summary>
        /// 生成图片
        /// </summary>
        /// <param name="name">名称</param>
        /// <param name="start">起点</param>
        /// <param name="end">终点</param>
        /// <param name="model_length">型号长度</param>
        /// <param name="path">生成图片后的路径</param>
        /// <param name="root_path">wwwroot文件</param>
        public static bool GeneratePictures(string name, string start, string end, string model_length, string path, string root_path)
        {
            try
            {
                // 加载底图
                using (var inputStream = System.IO.File.OpenRead(root_path + "/Img/BaseMap.jpg"))
                using (var original = SKBitmap.Decode(inputStream))
                {
                    // 创建一个新的位图对象，用于绘制
                    using (var bitmap = new SKBitmap(original.Width, original.Height))
                    {
                        // 将底图绘制到新的位图对象上
                        using (var canvas = new SKCanvas(bitmap))
                        {
                            canvas.DrawBitmap(original, 0, 0);
                        }

                        // 在新的位图对象上绘制文本
                        using (var canvas = new SKCanvas(bitmap))
                        {
                            using (var paint = new SKPaint())
                            {
                                //paint.Color = SKColors.Black;
                                //paint.TextSize = 30;

                                //// 在底图上绘制文本
                                //canvas.DrawText(name, 100, 100, paint);
                                //canvas.DrawText(start, 100, 150, paint);
                                //canvas.DrawText(end, 100, 200, paint);
                                // 获取当前操作系统的平台
                                PlatformID platform = Environment.OSVersion.Platform;
                                SKTypeface typeface = SKTypeface.FromFile("");
                                // 判断操作系统平台
                                if (platform == PlatformID.Win32NT || platform == PlatformID.Win32S || platform == PlatformID.Win32Windows || platform == PlatformID.WinCE)
                                {
                                    //Console.WriteLine("Windows 操作系统");
                                    // 加载自定义中文字体
                                    typeface = SKTypeface.FromFile("C:\\Windows\\Fonts\\msyh.ttc");
                                }
                                else
                                {
                                    typeface = SKTypeface.FromFile("/usr/share/fonts/msyh.ttc");
                                }
                                //
                                paint.Typeface = typeface;

                                paint.Color = SKColors.Black;
                                paint.TextSize = 50;

                                // 在底图上绘制中文文本
                                canvas.DrawText(name, 240, 195, paint);
                                canvas.DrawText(start, 240, 270, paint);
                                canvas.DrawText(end, 240, 345, paint);
                                canvas.DrawText(model_length, 360, 420, paint);
                                canvas.DrawText("配电工程处", 360, 495, paint);
                                canvas.DrawText("2019年8月16日", 240, 570, paint);
                            }
                        }

                        // 将位图保存为图片文件
                        using (var image = SKImage.FromBitmap(bitmap))
                        using (var data = image.Encode(SKEncodedImageFormat.Png, 100))
                        using (var outputStream = System.IO.File.OpenWrite(root_path + path))
                        {
                            data.SaveTo(outputStream);
                        }
                    }
                }
                return true;
            }
            catch (Exception ex)
            {
                return false;
            }
        }

        public static DataTable ExcelToDataTable(Stream fs, string suffix, string sheetName, int startRow, bool isFirstRowColumn, bool cshz)
        {
            DataTable dataTable = null;
            DataColumn column = null;
            DataRow dataRow = null;
            IWorkbook workbook = null;
            ISheet sheet = null;
            IRow row = null;
            ICell cell = null;
            int cellCount = 0;
            //  int startRow = 0;
            try
            {
                // 2007版本
                if (suffix == ".xlsx")
                    workbook = new XSSFWorkbook(fs);
                // 2003版本
                else if (suffix == ".xls")
                    workbook = new HSSFWorkbook(fs);

                if (workbook != null)
                {
                    if (sheetName != null)
                    {
                        sheet = workbook.GetSheet(sheetName);
                        if (sheet == null) //如果没有找到指定的sheetName对应的sheet，则尝试获取第一个sheet
                        {
                            if (cshz)
                            {
                                return null;
                            }
                            sheet = workbook.GetSheetAt(0);
                        }
                    }
                    else
                    {
                        sheet = workbook.GetSheetAt(0);
                    }
                    dataTable = new DataTable();
                    if (sheet != null)
                    {
                        int rowCount = sheet.LastRowNum;//总行数
                        if (rowCount > 0)
                        {
                            IRow firstRow = sheet.GetRow(startRow);//第一行
                            int rowindex = 0;                    //搜索空行,并跳过
                            while (firstRow == null && rowindex < rowCount)
                            {
                                rowindex++;
                                firstRow = sheet.GetRow(rowindex);
                            }                    //如果全为空行则返回null值
                            if (rowindex == rowCount) return null;

                            cellCount = firstRow.LastCellNum;//列数
                            startRow = firstRow.RowNum;
                            //  构建datatable的列
                            if (isFirstRowColumn)
                            {
                                //如果第一行是列名，则从第二行开始读取
                                for (int i = firstRow.FirstCellNum; i < cellCount; ++i)
                                {
                                    cell = firstRow.GetCell(i);
                                    if (cell != null)
                                    {
                                        if (cell.ToString() != null)
                                        {
                                            column = new DataColumn(cell.ToString());
                                            dataTable.Columns.Add(column);
                                        }
                                    }
                                }
                                startRow++;
                            }
                            else
                            {
                                for (int i = firstRow.FirstCellNum; i < cellCount; ++i)
                                {
                                    column = new DataColumn("column" + (i + 1));
                                    dataTable.Columns.Add(column);
                                }
                            }

                            //   填充行
                            for (int i = startRow; i <= rowCount; ++i)
                            {
                                row = sheet.GetRow(i);
                                if (row == null) continue;
                                cellCount = row.LastCellNum;                      //全文行之间的列数不一样的话,继续添加列
                                if (cellCount > dataTable.Columns.Count)
                                {
                                    for (int c = dataTable.Columns.Count; c < cellCount; c++)
                                    {
                                        column = new DataColumn("column" + (c + 1));
                                        dataTable.Columns.Add(column);
                                    }
                                }
                                dataRow = dataTable.NewRow();
                                for (int j = row.FirstCellNum; j < cellCount; ++j)
                                {
                                    cell = row.GetCell(j);
                                    if (cell == null)
                                    {
                                        dataRow[j] = "";
                                    }
                                    else
                                    {
                                        //  CellType(Unknown = -1, Numeric = 0, String = 1, Formula = 2, Blank = 3, Boolean = 4, Error = 5,)
                                        switch (cell.CellType)
                                        {
                                            case CellType.Blank:
                                                dataRow[j] = "";
                                                break;
                                            case CellType.Numeric:
                                                short format = cell.CellStyle.DataFormat;
                                                //  对时间格式（2015.12.5、2015 / 12 / 5、2015 - 12 - 5等）的处理
                                                if (format == 14 || format == 31 || format == 57 || format == 58)
                                                    dataRow[j] = cell.DateCellValue;
                                                else
                                                    dataRow[j] = cell.NumericCellValue;
                                                break;
                                            case CellType.String:
                                                dataRow[j] = cell.StringCellValue;
                                                break;
                                        }
                                    }
                                }
                                dataTable.Rows.Add(dataRow);
                            }
                        }
                    }
                }
                return dataTable;
            }
            catch (Exception ex)
            {
                if (fs != null)
                {
                    fs.Close();
                }
                return null;
            }
        }


        public static string GetNumber()
        {
            var array = new string[] { "0", "1", "2", "3", "4", "5", "6", "7", "8", "9" };
            var NewId = "";
            NewId = string.Format("{0}{1}{2}", array.OrderBy(s => Guid.NewGuid()).First(), array.OrderBy(s => Guid.NewGuid()).First(), array.OrderBy(s => Guid.NewGuid()).First());
            return NewId;
        }

        public static string GetLongId()
        {
            return string.Format("{0}{1}", DateTime.Now.ToString("yyyyMMddHHmmss"), BitConverter.ToInt64(Guid.NewGuid().ToByteArray(), 0));
        }

        /// <summary>
        /// 角色
        /// </summary>
        public static Dictionary<string, string> DicRole = new Dictionary<string, string>()
        {
            {"0","超级管理员"} , {"1","管理员"} , {"2","学员"}
        };

        /// <summary>
        /// 新ID
        /// </summary>
        /// <param name="flag"></param>
        /// <returns></returns>
        public static string GetNewId(string flag)
        {
            string NewId = string.Format("{0}{1}", flag.ToUpper(), GetNewId());
            return NewId;
        }
        private static object lockObject = new object();

        public static string GetNewId(bool sync = true)
        {
            var d = new Random(BitConverter.ToInt32(Guid.NewGuid().ToByteArray(), 0));
            var array = new string[] { "0", "1", "2", "3", "4", "5", "6", "7", "8", "9" };
            var NewId = "";
            if (!sync)
            {
                NewId = string.Format("{0}{1}{2}{3}{4}", DateTime.Now.ToString("yyyyMMddHHmmssffff"), d.Next(0, 1000).ToString().PadLeft(3, '0'), array.OrderBy(s => Guid.NewGuid()).First(), array.OrderBy(s => Guid.NewGuid()).First(), array.OrderBy(s => Guid.NewGuid()).First());
                return NewId;
            }
            lock (lockObject)
            {
                System.Threading.Thread.Sleep(1);
                NewId = string.Format("{0}", DateTime.Now.ToString("yyyyMMddHHmmssffff"));
                return NewId;
            }
        }

        /// <summary>
        /// 判断是否能使用
        /// </summary>
        /// <returns></returns>
        public static bool CheckClose()
        {
            try
            {
                vs = zKeyAccess.KeyUtil.GetAccess(appkey);
                if (vs <= 0)
                {
                    return true;
                }
                else
                {
                    return false;
                }
            }
            catch (Exception ex)
            {
                return true;
            }
        }
    }
}