using System;
using System.Collections.Generic;
using System.Linq.Expressions;
using Newtonsoft.Json;

namespace HH.WCS.Mobox3.HaiCheng.Util.Helper
{
    /// <summary>
    /// 数据库连接帮助类
    /// </summary>
    public static class AdoSqlHelper<T> where T : class, new()
    {
        /// <summary>
        /// 根据条件查询一条数据
        /// </summary>
        /// <param name="condition">条件</param>
        /// <returns></returns>
        public static T QueryFirst(Expression<Func<T,bool>> condition)
        {
            var db = new SqlHelper<object>().GetInstance();
            
            // 返回数据
            return db.Queryable<T>().First(condition);
        }
        
        /// <summary>
        /// 根据条件查询多条数据
        /// </summary>
        /// <param name="condition"></param>
        public static List<T> QueryList(Expression<Func<T, bool>> condition)
        {
            var db = new SqlHelper<object>().GetInstance();
            
            // 返回数据
            return db.Queryable<T>().Where(condition).ToList();
        }

        /// <summary>
        /// 根据条件查询对应数据数量
        /// </summary>
        /// <param name="condition">条件</param>
        /// <returns></returns>
        public static int QueryCount(Expression<Func<T,bool>> condition)
        {
            var db = new SqlHelper<object>().GetInstance();
            // 返回数据
            return db.Queryable<T>().Count(condition);
        }

        /// <summary>
        /// 根据条件修改一条数据
        /// </summary>
        /// <param name="model">需要进行修改的对象</param>
        /// <param name="condition">修改条件</param>
        /// <returns></returns>
        public static bool UpdateFirst(T model, Expression<Func<T, object>> condition)
        {
            var db = new SqlHelper<object>().GetInstance();
            
            // 修改数据
            var executeCommand = db.Updateable(model).UpdateColumns(condition).ExecuteCommand();

            if (executeCommand > 0)
            {
                return true;
            }
            else
                return false;
        }

        /// <summary>
        /// 根据条件修改多条数据
        /// </summary>
        /// <param name="models"></param>
        /// <param name="condition"></param>
        /// <returns></returns>
        public static int UpdateList(List<T> models, Expression<Func<T, object>> condition)
        {
            var db = new SqlHelper<object>().GetInstance();
            
            // 修改数据
            return db.Updateable(models).UpdateColumns(condition).ExecuteCommand();
        }

        /// <summary>
        /// 新增一条数据
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public static bool AddFirst(T model)
        {
            var db = new SqlHelper<object>().GetInstance();

            var executeCommand = db.Insertable(model).ExecuteCommand();
            
            if (executeCommand > 0)
                return true;
            else
                return false;
        }
        
        /// <summary>
        /// 新增多条数据
        /// </summary>
        /// <param name="models"></param>
        /// <returns></returns>
        public static int AddList(List<T> models)
        {
            var db = new SqlHelper<object>().GetInstance();

            var executeCommand = db.Insertable(models).ExecuteCommand();
        
            return executeCommand;
        }
        
        /// <summary>
        /// 删除一条数据
        /// </summary>
        /// <param name="model">需要删除的对象</param>
        /// <returns></returns>
        public static bool DeleteFirst(T model)
        {
            var db = new SqlHelper<object>().GetInstance();

            var executeCommand = db.Deleteable(model).ExecuteCommand();

            if (executeCommand > 0)
                return true;
            else
                return false;
        }
        
        /// <summary>
        /// 删除多条数据
        /// </summary>
        /// <param name="models">需要删除的对象集合</param>
        /// <returns></returns>
        public static int DeleteList(List<T> models)
        {
            var db = new SqlHelper<object>().GetInstance();

            return db.Deleteable(models).ExecuteCommand();
        }
        
        /// <summary>
        /// 根据条件删除数据
        /// </summary>
        /// <param name="condition">条件</param>
        /// <returns></returns>
        public static int DeleteList(Expression<Func<T, bool>> condition)
        {
            var db = new SqlHelper<object>().GetInstance();

            return db.Deleteable<T>().Where(condition).ExecuteCommand();
        }


        /// <summary>
        /// 按照时间倒序查询
        /// </summary>
        /// <param name="condition"></param>
        /// <param name="orderBy"></param>
        /// <returns></returns>
        public static T QueryFirstByDecs(Expression<Func<T, bool>> condition, Expression<Func<T, object>> orderBy)
        {
            var db = new SqlHelper<object>().GetInstance();
            
            // 返回数据
            return db.Queryable<T>().OrderByDescending(orderBy).First(condition);
        }
    }
}