using HH.WMS.DAL;
using HH.WMS.Entitys;
using HH.WMS.Entitys.Common;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace HH.WMS.BLL
{
    public class DapperBLL<T> : BaseBLL where T : new()
    {
        #region 新增
        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="entity"></param>
        /// <param name="trans"></param>
        /// <returns></returns>
        public OperateResult Add(T entity, IDbTransaction trans = null)
        {
            return CreateDAL<DapperDAL<T>>().Add(entity, trans);
        }
        #endregion

        #region 批量新增
        /// <summary>
        /// 批量新增
        /// </summary>
        /// <param name="list"></param>
        /// <param name="trans"></param>
        /// <returns></returns>
        public OperateResult AddRange(List<T> list)
        {
            return CreateDAL<DapperDAL<T>>().AddRange(list);
        }
        #endregion

        #region 修改
        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="entity"></param>
        /// <param name="where"></param>
        /// <param name="trans"></param>
        /// <returns></returns>
        public OperateResult Update(T entity, object where)
        {
            return CreateDAL<DapperDAL<T>>().UpdateAll(entity, where);
        }
        #endregion

        #region 单表分页
        /// <summary>
        /// 单表分页
        /// </summary>
        /// <param name="where"></param>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="orderBy"></param>
        /// <returns></returns>
        public OperateResult GetPagingResult(int pageIndex, int pageSize, object where = null, string orderBy = "")
        {
            return CreateDAL<DapperDAL<T>>().GetPagingResult(pageIndex, pageSize, where, orderBy);
        }
        public OperateResult GetPagingResult(List<SearchWhere> whereColumn,int pageIndex, int pageSize,bool isParamQuery, object where = null, string orderBy = "")
        {
            return CreateDAL<DapperDAL<T>>().GetPagingResult(whereColumn,pageIndex, pageSize,isParamQuery, where, orderBy);
        }
        #endregion

        #region 分页
        /// <summary>
        /// 分页
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="total"></param>
        /// <param name="where"></param>
        /// <param name="orderBy"></param>
        /// <returns></returns>
        public DataTable GetPagingData(int pageIndex, int pageSize, out long total, object where = null, string orderBy = "")
        {
            return CreateDAL<DapperDAL<T>>().GetPagingData(pageIndex, pageSize, out total, where, orderBy);
        }

        public DataTable GetPagingData(List<SearchWhere> whereColumn, int pageIndex, int pageSize, out long total, bool isParamQuery, object where, string orderBy = "")
        {
            return CreateDAL<DapperDAL<T>>().GetPagingData(pageIndex, pageSize, out total, whereColumn, isParamQuery, where, orderBy);
        }
        
        public DataTable GetDataTable(object where = null, string orderBy = "")
        {
            return CreateDAL<DapperDAL<T>>().GetDataTable(where, orderBy);
        }

        public DataTable GetData(List<SearchWhere> whereColumn, bool isParamQuery, object where = null, string orderBy = "")
        {
            return CreateDAL<DapperDAL<T>>().GetData(whereColumn, isParamQuery, where, orderBy);
        }
        #endregion

        #region 动态修改单表
        /// <summary>
        /// 动态修改
        /// </summary>
        /// <param name="updateFields"></param>
        /// <param name="where"></param>
        /// <param name="trans"></param>
        /// <returns></returns>
        public OperateResult Update(object updateFields, object where)
        {
            return CreateDAL<DapperDAL<T>>().Update(updateFields, where);
        }
        #endregion

        #region 批量修改
        /// <summary>
        /// 批量修改
        /// </summary>
        /// <param name="list"></param>
        /// <param name="where"></param>
        /// <param name="trans"></param>
        /// <returns></returns>
        public OperateResult UpdateRange(IList<T> list, object where)
        {
            return CreateDAL<DapperDAL<T>>().UpdateRange(list, where);
        }
        #endregion

        #region 查询-返回List
        /// <summary>
        ///  查询-返回List
        /// </summary>
        /// <param name="where"></param>
        /// <returns></returns>
        public List<T> GetList(object where = null, string orderBy = "")
        {
            return CreateDAL<DapperDAL<T>>().GetList(where, orderBy);
        }
        #endregion

        #region 查询-返回entity
        /// <summary>
        /// 查询-返回entity
        /// </summary>
        /// <param name="sql"></param>
        /// <param name="where"></param>
        /// <returns></returns>
        public T GetSingleEntity(object where = null, string orderBy = "")
        {
            return CreateDAL<DapperDAL<T>>().GetSingleEntity(where, orderBy);
        }
        #endregion

        #region 删除
        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="where"></param>
        /// <returns></returns>
        public OperateResult Delete(object where)
        {
            return CreateDAL<DapperDAL<T>>().Delete(where);
        }
        #endregion

        public List<T> GetList(List<SearchWhere> whereColumn, object where, bool isParamQuery)
        {
            return CreateDAL<DapperDAL<T>>().GetList(whereColumn, where, isParamQuery);
        }
        #region 获取top条
        /// <summary>
        /// 获取top条
        /// </summary>
        /// <param name="top"></param>
        /// <param name="where"></param>
        /// <param name="orderBy"></param>
        /// <returns></returns>
        public List<T> GetTopList(int top, object where = null, string orderBy = "")
        {
            return CreateDAL<DapperDAL<T>>().GetTopList(top, where, orderBy);
        }
        #endregion
    }
}