123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555 |
- using ProjectBase.Data.Pager;
- using System;
- using System.Collections;
- using System.Collections.Generic;
- using System.Data;
- using System.Data.Common;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- namespace ProjectBase.Data.BaseDAL
- {
- /// <summary>
- /// 数据访问层的接口
- /// </summary>
- public interface IBaseDAL<T> where T : BaseEntity
- {
- /// <summary>
- /// 定义一个操作记录的事件处理
- /// </summary>
- event OperationLogEventHandler OnOperationLog;
- #region 通用操作
- /// <summary>
- /// 获取表的所有记录数量
- /// </summary>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- int GetRecordCount(DbTransaction trans = null);
- /// <summary>
- /// 获取表的指定条件记录数量
- /// </summary>
- /// <param name="condition">条件语句</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- int GetRecordCount(string condition, DbTransaction trans = null);
- /// <summary>
- /// 根据condition条件,判断是否存在记录
- /// </summary>
- /// <param name="condition">查询的条件</param>
- /// <param name="trans">事务对象</param>
- /// <returns>如果存在返回True,否则False</returns>
- bool IsExistRecord(string condition, DbTransaction trans = null);
- /// <summary>
- /// 查询数据库,检查是否存在指定键值的对象
- /// </summary>
- /// <param name="recordTable">Hashtable:键[key]为字段名;值[value]为字段对应的值</param>
- /// <param name="trans">事务对象</param>
- /// <returns>存在则返回<c>true</c>,否则为<c>false</c>。</returns>
- bool IsExistKey(Hashtable recordTable, DbTransaction trans = null);
- /// <summary>
- /// 查询数据库,检查是否存在指定键值的对象
- /// </summary>
- /// <param name="fieldName">指定的属性名</param>
- /// <param name="key">指定的值</param>
- /// <param name="trans">事务对象</param>
- /// <returns>存在则返回<c>true</c>,否则为<c>false</c>。</returns>
- bool IsExistKey(string fieldName, object key, DbTransaction trans = null);
- /// <summary>
- /// 获取数据库中该对象的最大ID值
- /// </summary>
- /// <param name="trans">事务对象</param>
- /// <returns>最大ID值</returns>
- int GetMaxID(DbTransaction trans = null);
- /// <summary>
- /// 根据主键和字段名称,获取对应字段的内容
- /// </summary>
- /// <param name="key">指定对象的ID</param>
- /// <param name="fieldName">字段名称</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- string GetFieldValue(object key, string fieldName, DbTransaction trans = null);
- /// <summary>
- /// 根据指定对象的ID,从数据库中删除指定对象
- /// </summary>
- /// <param name="key">指定对象的ID</param>
- /// <param name="trans">事务对象</param>
- /// <returns>执行成功返回<c>true</c>,否则为<c>false</c>。</returns>
- bool Delete(object key, string userId, DbTransaction trans = null);
- /// <summary>
- /// 根据指定条件,从数据库中删除指定对象
- /// </summary>
- /// <param name="condition">删除记录的条件语句</param>
- /// <param name="trans">事务对象</param>
- /// <param name="paramList">Sql参数列表</param>
- /// <returns>执行成功返回<c>true</c>,否则为<c>false</c>。</returns>
- bool DeleteByCondition(string condition, DbTransaction trans = null, IDbDataParameter[] paramList = null);
- /// <summary>
- /// 插入指定对象到数据库中
- /// </summary>
- /// <param name="obj">指定的对象</param>
- /// <param name="trans">事务对象</param>
- /// <returns>执行成功返回True</returns>
- bool Insert(T obj, DbTransaction trans = null);
- /// <summary>
- /// 插入指定对象到数据库中,并返回自增长的键值
- /// </summary>
- /// <param name="obj">指定的对象</param>
- /// <param name="trans">事务对象</param>
- /// <returns>执行成功返回True</returns>
- int Insert2(T obj, DbTransaction trans = null);
- /// <summary>
- /// 更新对象属性到数据库中
- /// </summary>
- /// <param name="obj">指定的对象</param>
- /// <param name="primaryKeyValue">主键的值</param>
- /// <param name="trans">事务对象</param>
- /// <returns>执行成功返回<c>true</c>,否则为<c>false</c>。</returns>
- bool Update(T obj, object primaryKeyValue, DbTransaction trans = null);
- /// <summary>
- /// 更新某个表一条记录(只适用于用单键,用string类型作键值的表)
- /// </summary>
- /// <param name="id">ID值</param>
- /// <param name="recordField">Hashtable:键[key]为字段名;值[value]为字段对应的值</param>
- /// <param name="targetTable">需要操作的目标表名称</param>
- /// <param name="trans">事务对象,如果使用事务,传入事务对象,否则为Null不使用事务</param>
- bool Update(object id, Hashtable recordField, string targetTable, DbTransaction trans);
- /// <summary>
- /// 插入或更新对象属性到数据库中
- /// </summary>
- /// <param name="obj">指定的对象</param>
- /// <param name="primaryKeyValue">主键值</param>
- /// <param name="trans">事务对象</param>
- /// <returns>执行成功返回<c>true</c>,否则为<c>false</c>。</returns>
- bool InsertUpdate(T obj, object primaryKeyValue, DbTransaction trans = null);
- /// <summary>
- /// 如果不存在记录,则插入对象属性到数据库中
- /// </summary>
- /// <param name="obj">指定的对象</param>
- /// <param name="primaryKeyValue">主键值</param>
- /// <param name="trans">事务对象</param>
- /// <returns>执行插入成功返回<c>true</c>,否则为<c>false</c>。</returns>
- bool InsertIfNew(T obj, object primaryKeyValue, DbTransaction trans = null);
- /// <summary>
- /// 执行SQL查询语句,返回查询结果的所有记录的第一个字段,用逗号分隔。
- /// </summary>
- /// <param name="sql">SQL语句</param>
- /// <param name="trans">事务对象</param>
- /// <returns>
- /// 返回查询结果的所有记录的第一个字段,用逗号分隔。
- /// </returns>
- string SqlValueList(string sql, DbTransaction trans = null);
- /// <summary>
- /// 执行一些特殊的语句
- /// </summary>
- /// <param name="sql">SQL语句</param>
- /// <param name="trans">事务对象</param>
- int SqlExecute(string sql, DbTransaction trans = null);
- /// <summary>
- /// 执行存储过程函数。
- /// </summary>
- /// <param name="storeProcName">存储过程函数</param>
- /// <param name="parameters">参数集合</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- int StoreProcExecute(string storeProcName, DbParameter[] parameters, DbTransaction trans = null);
- /// <summary>
- /// 执行SQL查询语句,返回所有记录的DataTable集合。
- /// </summary>
- /// <param name="sql">SQL查询语句</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- DataTable SqlTable(string sql, DbTransaction trans = null);
- /// <summary>
- /// 执行SQL查询语句,返回所有记录的DataTable集合。
- /// </summary>
- /// <param name="sql">SQL查询语句</param>
- /// <param name="parameters">SQL查询参数</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- DataTable SqlTable(string sql, DbParameter[] parameters, DbTransaction trans = null);
- /// <summary>
- /// 打开数据库连接,并创建事务对象
- /// </summary>
- DbTransaction CreateTransaction();
- /// <summary>
- /// 打开数据库连接,并创建事务对象
- /// </summary>
- /// <param name="level">事务级别</param>
- DbTransaction CreateTransaction(IsolationLevel level);
- /// <summary>
- /// 测试数据库是否正常连接
- /// </summary>
- bool TestConnection(string connectionString);
- /// <summary>
- /// 执行sql语句
- /// </summary>
- /// <param name="commandType">执行类型</param>
- /// <param name="sql">sql语句或存储过程</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- bool Update(CommandType commandType, string sql, DbTransaction trans = null);
- #endregion
- #region 返回实体类操作
- /// <summary>
- /// 查询数据库,检查是否存在指定ID的对象
- /// </summary>
- /// <param name="key">对象的ID值</param>
- /// <param name="trans">事务对象</param>
- /// <returns>存在则返回指定的对象,否则返回Null</returns>
- T FindByID(object key, DbTransaction trans = null);
- /// <summary>
- /// 根据条件查询数据库,如果存在返回第一个对象
- /// </summary>
- /// <param name="condition">查询的条件</param>
- /// <param name="trans">事务对象</param>
- /// <returns>指定的对象</returns>
- T FindSingle(string condition, DbTransaction trans = null);
- /// <summary>
- /// 根据条件查询数据库,如果存在返回第一个对象
- /// </summary>
- /// <param name="condition">查询的条件</param>
- /// <param name="orderBy">自定义排序语句,如Order By Name Desc;如不指定,则使用默认排序</param>
- /// <param name="trans">事务对象</param>
- /// <returns>指定的对象</returns>
- T FindSingle(string condition, string orderBy, DbTransaction trans = null);
- /// <summary>
- /// 根据条件查询数据库,如果存在返回第一个对象
- /// </summary>
- /// <param name="condition">查询的条件</param>
- /// <param name="orderBy">自定义排序语句,如Order By Name Desc;如不指定,则使用默认排序</param>
- /// <param name="paramList">参数列表</param>
- /// <param name="trans">事务对象</param>
- /// <returns>指定的对象</returns>
- T FindSingle(string condition, string orderBy, IDbDataParameter[] paramList, DbTransaction trans = null);
- /// <summary>
- /// 查找记录表中最新的一条记录
- /// </summary>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- T FindLast(DbTransaction trans = null);
- /// <summary>
- /// 查找记录表中最旧的一条记录
- /// </summary>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- T FindFirst(DbTransaction trans = null);
- #endregion
- #region 返回集合的接口
- /// <summary>
- /// 根据ID字符串(逗号分隔)获取对象列表
- /// </summary>
- /// <param name="idString">ID字符串(逗号分隔)</param>
- /// <param name="trans">事务对象</param>
- /// <returns>符合条件的对象列表</returns>
- List<T> FindByIDs(string idString, DbTransaction trans = null);
- /// <summary>
- /// 根据条件查询数据库,并返回对象集合
- /// </summary>
- /// <param name="condition">查询的条件</param>
- /// <param name="trans">事务对象</param>
- /// <returns>指定对象的集合</returns>
- List<T> Find(string condition, DbTransaction trans = null);
- /// <summary>
- /// 根据条件查询数据库,并返回对象集合(用于分页数据显示)
- /// </summary>
- /// <param name="condition">查询的条件</param>
- /// <param name="orderBy">自定义排序语句,如Order By Name Desc;如不指定,则使用默认排序</param>
- /// <param name="trans">事务对象</param>
- /// <returns>指定对象的集合</returns>
- List<T> Find(string condition, string orderBy, DbTransaction trans = null);
- /// <summary>
- /// 根据条件查询数据库,并返回对象集合(用于分页数据显示)
- /// </summary>
- /// <param name="condition">查询的条件</param>
- /// <param name="orderBy">自定义排序语句,如Order By Name Desc;如不指定,则使用默认排序</param>
- /// <param name="paramList">参数列表</param>
- /// <param name="trans">事务对象</param>
- /// <returns>指定对象的集合</returns>
- List<T> Find(string condition, string orderBy, IDbDataParameter[] paramList, DbTransaction trans = null);
- /// <summary>
- /// 通用获取集合对象方法
- /// </summary>
- /// <param name="sql">查询的Sql语句</param>
- /// <param name="paramList">参数列表,如果没有则为null</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- List<T> GetList(string sql, IDbDataParameter[] paramList = null, DbTransaction trans = null);
- /// <summary>
- /// 以分页方式通用获取集合对象方法
- /// </summary>
- /// <param name="sql">查询的Sql语句</param>
- /// <param name="info">分页实体</param>
- /// <param name="paramList">参数列表,如果没有则为null</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- List<T> GetListWithPager(string sql, PagerInfo info, IDbDataParameter[] paramList = null, DbTransaction trans = null);
- /// <summary>
- /// 根据条件查询数据库,并返回对象集合(用于分页数据显示)
- /// </summary>
- /// <param name="condition">查询的条件</param>
- /// <param name="info">分页实体</param>
- /// <param name="trans">事务对象</param>
- /// <returns>指定对象的集合</returns>
- List<T> FindWithPager(string condition, PagerInfo info, DbTransaction trans = null);
- /// <summary>
- /// 根据条件查询数据库,并返回对象集合(用于分页数据显示)
- /// </summary>
- /// <param name="condition">查询的条件</param>
- /// <param name="info">分页实体</param>
- /// <param name="fieldToSort">排序字段</param>
- /// <param name="trans">事务对象</param>
- /// <returns>指定对象的集合</returns>
- List<T> FindWithPager(string condition, PagerInfo info, string fieldToSort, DbTransaction trans = null);
- /// <summary>
- /// 根据条件查询数据库,并返回对象集合(用于分页数据显示)
- /// </summary>
- /// <param name="condition">查询的条件</param>
- /// <param name="info">分页实体</param>
- /// <param name="fieldToSort">排序字段</param>
- /// <param name="desc">是否降序</param>
- /// <param name="trans">事务对象</param>
- /// <returns>指定对象的集合</returns>
- List<T> FindWithPager(string condition, PagerInfo info, string fieldToSort, bool desc, DbTransaction trans = null);
- /// <summary>
- /// 返回数据库所有的对象集合
- /// </summary>
- /// <param name="trans">事务对象</param>
- /// <returns>指定对象的集合</returns>
- List<T> GetAll(DbTransaction trans = null);
- /// <summary>
- /// 返回数据库所有的对象集合
- /// </summary>
- /// <param name="orderBy">自定义排序语句,如Order By Name Desc;如不指定,则使用默认排序</param>
- /// <param name="trans">事务对象</param>
- /// <returns>指定对象的集合</returns>
- List<T> GetAll(string orderBy, DbTransaction trans = null);
- /// <summary>
- /// 返回数据库所有的对象集合(用于分页数据显示)
- /// </summary>
- /// <param name="info">分页实体信息</param>
- /// <param name="trans">事务对象</param>
- /// <returns>指定对象的集合</returns>
- List<T> GetAll(PagerInfo info, DbTransaction trans = null);
- /// <summary>
- /// 返回数据库所有的对象集合(用于分页数据显示)
- /// </summary>
- /// <param name="info">分页实体信息</param>
- /// <param name="fieldToSort">排序字段</param>
- /// <param name="desc">是否降序</param>
- /// <param name="trans">事务对象</param>
- /// <returns>指定对象的集合</returns>
- List<T> GetAll(PagerInfo info, string fieldToSort, bool desc, DbTransaction trans = null);
- /// <summary>
- /// 返回所有记录到DataTable集合中
- /// </summary>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- DataTable GetAllToDataTable(DbTransaction trans = null);
- /// <summary>
- /// 返回所有记录到DataTable集合中
- /// </summary>
- /// <param name="orderBy">自定义排序语句,如Order By Name Desc;如不指定,则使用默认排序</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- DataTable GetAllToDataTable(string orderBy, DbTransaction trans = null);
- /// <summary>
- /// 根据分页条件,返回DataTable对象
- /// </summary>
- /// <param name="info">分页条件</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- DataTable GetAllToDataTable(PagerInfo info, DbTransaction trans = null);
- /// <summary>
- /// 根据分页条件,返回DataTable对象
- /// </summary>
- /// <param name="info">分页条件</param>
- /// <param name="fieldToSort">排序字段</param>
- /// <param name="desc">是否降序</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- DataTable GetAllToDataTable(PagerInfo info, string fieldToSort, bool desc, DbTransaction trans = null);
- /// <summary>
- /// 根据查询条件,返回记录到DataTable集合中
- /// </summary>
- /// <param name="condition">查询条件</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- DataTable FindToDataTable(string condition, DbTransaction trans = null);
- /// <summary>
- /// 根据查询条件,返回记录到DataTable集合中
- /// </summary>
- /// <param name="condition">查询条件</param>
- /// <param name="info">分页条件</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- DataTable FindToDataTable(string condition, PagerInfo info, DbTransaction trans = null);
- /// <summary>
- /// 根据条件查询数据库,并返回DataTable集合(用于分页数据显示)
- /// </summary>
- /// <param name="condition">查询的条件</param>
- /// <param name="info">分页实体</param>
- /// <param name="fieldToSort">排序字段</param>
- /// <param name="desc">是否降序</param>
- /// <param name="trans">事务对象</param>
- /// <returns>指定DataTable的集合</returns>
- DataTable FindToDataTable(string condition, PagerInfo info, string fieldToSort, bool desc, DbTransaction trans = null);
- /// <summary>
- /// 获取某字段数据字典列表
- /// </summary>
- /// <param name="fieldName">字段名称</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- List<string> GetFieldList(string fieldName, DbTransaction trans = null);
- /// <summary>
- /// 根据条件,获取某字段数据字典列表
- /// </summary>
- /// <param name="fieldName">字段名称</param>
- /// <param name="condition">查询的条件</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- List<string> GetFieldListByCondition(string fieldName, string condition, DbTransaction trans = null);
- /// <summary>
- /// 根据条件,从视图里面获取记录
- /// </summary>
- /// <param name="viewName">视图名称</param>
- /// <param name="condition">查询条件</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- DataTable FindByView(string viewName, string condition, DbTransaction trans = null);
- /// <summary>
- /// 根据条件,从视图里面获取记录
- /// </summary>
- /// <param name="viewName">视图名称</param>
- /// <param name="condition">查询条件</param>
- /// <param name="sortField">排序字段</param>
- /// <param name="isDescending">是否为降序</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- DataTable FindByView(string viewName, string condition, string sortField, bool isDescending, DbTransaction trans = null);
- /// <summary>
- /// 获取前面记录指定数量的记录
- /// </summary>
- /// <param name="sql">查询语句</param>
- /// <param name="count">指定数量</param>
- /// <param name="orderBy">排序条件,例如order by id</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- DataTable GetTopResult(string sql, int count, string orderBy, DbTransaction trans = null);
- /// <summary>
- /// 根据条件,从视图里面获取记录
- /// </summary>
- /// <param name="viewName">视图名称</param>
- /// <param name="condition">查询条件</param>
- /// <param name="sortField">排序字段</param>
- /// <param name="isDescending">是否为降序</param>
- /// <param name="info">分页条件</param>
- /// <param name="trans">事务对象</param>
- /// <returns></returns>
- DataTable FindByViewWithPager(string viewName, string condition, string sortField, bool isDescending, PagerInfo info, DbTransaction trans = null);
- #endregion
- /// <summary>
- /// 设置数据库配置项名称
- /// </summary>
- /// <param name="dbConfigName">数据库配置项名称</param>
- void SetDbConfigName(string dbConfigName);
- /// <summary>
- /// 初始化数据库表名
- /// </summary>
- /// <param name="tableName">数据库表名</param>
- void InitTableName(string tableName);
- /// <summary>
- /// 获取数据库的全部表名称
- /// </summary>
- /// <returns></returns>
- List<string> GetTableNames();
- /// <summary>
- /// 获取表的字段名称和数据类型列表
- /// </summary>
- /// <returns></returns>
- DataTable GetFieldTypeList();
- /// <summary>
- /// 获取字段中文别名(用于界面显示)的字典集合
- /// </summary>
- /// <returns></returns>
- Dictionary<string, string> GetColumnNameAlias();
- /// <summary>
- /// 获取指定字段的报表数据
- /// </summary>
- /// <param name="fieldName">表字段</param>
- /// <param name="condition">查询条件</param>
- /// <returns></returns>
- DataTable GetReportData(string fieldName, string condition);
- }
- }
|