using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Configuration;
using Microsoft.Win32;
using System.IO;

using SqlSugar;

namespace HXX.Scanner.Database
{
    /// <summary>
    /// sqlite基本操作
    /// </summary>
    public class SqlSugarHelper
    {
        static SqlSugarHelper()
        {
            string file = System.Environment.CurrentDirectory + @"\db\HXX.db";

            if (File.Exists(file))
            {
                ConnectionString = @"Data Source=" + System.Environment.CurrentDirectory + @"\db\HXX.db;";
            }
            else
            {
                string path = string.Empty;

                try
                {
                    var nn = Registry.ClassesRoot.OpenSubKey(@"scannerClient\DefaultIcon");
                    var mm = nn.GetValue("").ToString().Replace(",1", "");
                    path = Path.GetDirectoryName(mm);
                }
                catch (Exception ee) { }

                if (!string.IsNullOrEmpty(path))
                {
                    ConnectionString = @"Data Source=" + path + @"\db\HXX.db;";
                }
                else
                {
                    ConnectionString = @"Data Source=" + System.Environment.CurrentDirectory + @"\db\HXX.db;";
                }
            }
        }

        //public static string ConnectionString = @"Data Source=db\HXX.db;";
        public static string ConnectionString = @"Data Source=" + System.Environment.CurrentDirectory + @"\db\HXX.db;";

        public static SqlSugarClient GetClient()
        {
            SqlSugarClient db = new SqlSugarClient(
                new ConnectionConfig()
                {
                    ConnectionString = ConnectionString,
                    DbType = DbType.Sqlite,
                    IsAutoCloseConnection = true,
                }
            );

            db.Aop.OnLogExecuting = (sql, pars) =>
            {
                Console.WriteLine(sql + "\r\n" + db.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value)));
                Console.WriteLine();
            };

            return db;
        }

        public static SqlSugarClient GetClient(string conStr)
        {
            SqlSugarClient db = new SqlSugarClient(
                new ConnectionConfig()
                {
                    ConnectionString = conStr,
                    DbType = DbType.Sqlite,
                    IsAutoCloseConnection = true,
                }
            );

            db.Aop.OnLogExecuting = (sql, pars) =>
            {
                Console.WriteLine(sql + "\r\n" + db.Utilities.SerializeObject(pars.ToDictionary(it => it.ParameterName, it => it.Value)));
                Console.WriteLine();
            };

            return db;
        }
    }
}