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
|
}
|
}
|
