Ejemplo n.º 1
0
 /// <summary>
 /// 开启事务
 /// </summary>
 /// <param name="entity">数据库连接信息</param>
 /// <returns></returns>
 public IRepository BeginTrans(string databaseLinkId)
 {
     try
     {
         DatabaseLinkEntity entity = GetEntity(databaseLinkId);
         return(databaseLinkService.BeginTrans(entity));
     }
     catch (Exception ex)
     {
         if (ex is ExceptionEx)
         {
             throw;
         }
         else
         {
             throw ExceptionEx.ThrowServiceException(ex);
         }
     }
 }
Ejemplo n.º 2
0
 /// <summary>
 /// 根据指定数据库执行sql语句
 /// </summary>
 /// <param name="databaseLinkId">数据库主键</param>
 /// <param name="sql">sql语句</param>
 /// <param name="dbParameter">参数</param>
 public void ExecuteBySql(string databaseLinkId, string sql, object dbParameter = null)
 {
     try
     {
         DatabaseLinkEntity entity = GetEntity(databaseLinkId);
         databaseLinkService.ExecuteBySql(entity, sql, dbParameter);
     }
     catch (Exception ex)
     {
         if (ex is ExceptionEx)
         {
             throw;
         }
         else
         {
             throw ExceptionEx.ThrowBusinessException(ex);
         }
     }
 }
Ejemplo n.º 3
0
 /// <summary>
 /// 根据数据库执行sql语句,查询数据->datatable(分页)
 /// </summary>
 /// <param name="databaseLinkId">数据库主键</param>
 /// <param name="sql">sql语句</param>
 /// <param name="dbParameter">参数</param>
 /// <param name="pagination">分页参数</param>
 /// <returns></returns>
 public DataTable FindTable(string databaseLinkId, string sql, object dbParameter, Pagination pagination)
 {
     try
     {
         DatabaseLinkEntity entity = GetEntity(databaseLinkId);
         return(databaseLinkService.FindTable(entity, sql, dbParameter, pagination));
     }
     catch (Exception ex)
     {
         if (ex is ExceptionEx)
         {
             throw;
         }
         else
         {
             throw ExceptionEx.ThrowBusinessException(ex);
         }
     }
 }
Ejemplo n.º 4
0
 /// <summary>
 /// 创建数据库表
 /// </summary>
 /// <param name="databaseLinkEntity"></param>
 /// <param name="tableName"></param>
 /// <param name="tableRemark"></param>
 /// <param name="colList"></param>
 /// <returns></returns>
 public string CreateTable(string databaseLinkId, string tableName, string tableRemark, List <DatabaseTableFieldModel> colList)
 {
     try
     {
         DatabaseLinkEntity databaseLinkEntity = databaseLinkIBLL.GetEntity(databaseLinkId);
         return(databaseTableService.CreateTable(databaseLinkEntity, tableName, tableRemark, colList));
     }
     catch (Exception ex)
     {
         if (ex is ExceptionEx)
         {
             throw;
         }
         else
         {
             throw ExceptionEx.ThrowBusinessException(ex);
         }
     }
 }
Ejemplo n.º 5
0
 /// <summary>
 /// 数据库表数据列表
 /// </summary>
 /// <param name="databaseLinkId">数据库连接主键</param>
 /// <param name="tableName">表名</param>
 /// <returns></returns>
 public DataTable GetTableDataList(string databaseLinkId, string tableName)
 {
     try
     {
         DatabaseLinkEntity databaseLinkEntity = databaseLinkIBLL.GetEntity(databaseLinkId);
         return(databaseTableService.GetTableDataList(databaseLinkEntity, tableName));
     }
     catch (Exception ex)
     {
         if (ex is ExceptionEx)
         {
             throw;
         }
         else
         {
             throw ExceptionEx.ThrowBusinessException(ex);
         }
     }
 }
Ejemplo n.º 6
0
 /// <summary>
 /// 数据库表数据列表
 /// </summary>
 /// <param name="databaseLinkId">数据库连接主键</param>
 /// <param name="field">表明</param>
 /// <param name="switchWhere">条件</param>
 /// <param name="logic">逻辑</param>
 /// <param name="keyword">关键字</param>
 /// <param name="pagination">分页参数</param>
 /// <returns></returns>
 public DataTable GetTableDataList(string databaseLinkId, string tableName, string field, string logic, string keyword, Pagination pagination)
 {
     try
     {
         DatabaseLinkEntity databaseLinkEntity = databaseLinkIBLL.GetEntity(databaseLinkId);
         return(databaseTableService.GetTableDataList(databaseLinkEntity, tableName, field, logic, keyword, pagination));
     }
     catch (Exception ex)
     {
         if (ex is ExceptionEx)
         {
             throw;
         }
         else
         {
             throw ExceptionEx.ThrowBusinessException(ex);
         }
     }
 }
Ejemplo n.º 7
0
 /// <summary>
 /// 保存自定义查询(新增、修改)
 /// </summary>
 /// <param name="keyValue">主键值</param>
 /// <param name="departmentEntity">部门实体</param>
 /// <returns></returns>
 public bool SaveEntity(string keyValue, DatabaseLinkEntity databaseLinkEntity)
 {
     try
     {
         cache.Remove(cacheKey, CacheId.database);
         cache.Remove(cacheKey + "dic", CacheId.database);
         return(databaseLinkService.SaveEntity(keyValue, databaseLinkEntity));
     }
     catch (Exception ex)
     {
         if (ex is ExceptionEx)
         {
             throw;
         }
         else
         {
             throw ExceptionEx.ThrowBusinessException(ex);
         }
     }
 }
Ejemplo n.º 8
0
 /// <summary>
 /// 数据库表数据列表
 /// </summary>
 /// <param name="databaseLinkEntity">库连接信息</param>
 /// <param name="tableName">表名</param>
 /// <returns></returns>
 public DataTable GetTableDataList(DatabaseLinkEntity databaseLinkEntity, string tableName)
 {
     try
     {
         StringBuilder strSql = new StringBuilder();
         strSql.Append(" SELECT * FROM " + tableName);
         return(this.BaseRepository(databaseLinkEntity.F_DbConnection, databaseLinkEntity.F_DbType).FindTable(strSql.ToString()));
     }
     catch (Exception ex)
     {
         if (ex is ExceptionEx)
         {
             throw;
         }
         else
         {
             throw ExceptionEx.ThrowServiceException(ex);
         }
     }
 }
Ejemplo n.º 9
0
 /// <summary>
 /// 数据表字段列表
 /// </summary>
 /// <param name="databaseLinkEntity">数据库连接信息</param>
 /// <param name="tableName">表名</param>
 /// <returns></returns>
 public IEnumerable <DatabaseTableFieldModel> GetTableFiledList(DatabaseLinkEntity databaseLinkEntity, string tableName)
 {
     try
     {
         if (databaseLinkEntity == null)
         {
             return(new List <DatabaseTableFieldModel>());
         }
         return(this.BaseRepository(databaseLinkEntity.F_DbConnection, databaseLinkEntity.F_DbType).GetDBTableFields <DatabaseTableFieldModel>(tableName));
     }
     catch (Exception ex)
     {
         if (ex is ExceptionEx)
         {
             throw;
         }
         else
         {
             throw ExceptionEx.ThrowServiceException(ex);
         }
     }
 }
Ejemplo n.º 10
0
 /// <summary>
 /// 删除自定义查询条件
 /// </summary>
 /// <param name="keyValue">主键</param>
 public void VirtualDelete(string keyValue)
 {
     try
     {
         DatabaseLinkEntity entity = new DatabaseLinkEntity()
         {
             F_DatabaseLinkId = keyValue,
             F_DeleteMark     = 1
         };
         this.BaseRepository().Update(entity);
     }
     catch (Exception ex)
     {
         if (ex is ExceptionEx)
         {
             throw;
         }
         else
         {
             throw ExceptionEx.ThrowServiceException(ex);
         }
     }
 }
Ejemplo n.º 11
0
        /// <summary>
        /// 数据库表数据列表
        /// </summary>
        /// <param name="databaseLinkEntity">库连接信息</param>
        /// <param name="field">表明</param>
        /// <param name="switchWhere">条件</param>
        /// <param name="logic">逻辑</param>
        /// <param name="keyword">关键字</param>
        /// <param name="pagination">分页参数</param>
        /// <returns></returns>
        public DataTable GetTableDataList(DatabaseLinkEntity databaseLinkEntity, string tableName, string field, string logic, string keyword, Pagination pagination)
        {
            try
            {
                StringBuilder strSql = new StringBuilder();
                strSql.Append("SELECT * FROM " + tableName + " WHERE 1=1");
                if (!string.IsNullOrEmpty(keyword) && !string.IsNullOrEmpty(logic) && logic != "Null" && logic != "NotNull")
                {
                    strSql.Append(" AND " + field + " ");
                    switch (logic)
                    {
                    case "Equal":               //等于
                        strSql.Append(" = ");
                        break;

                    case "NotEqual":            //不等于
                        strSql.Append(" <> ");
                        break;

                    case "Greater":             //大于
                        strSql.Append(" > ");
                        break;

                    case "GreaterThan":         //大于等于
                        strSql.Append(" >= ");
                        break;

                    case "Less":                //小于
                        strSql.Append(" < ");
                        break;

                    case "LessThan":            //小于等于
                        strSql.Append(" >= ");
                        break;

                    case "Like":                //包含
                        strSql.Append(" like ");
                        keyword = "%" + keyword + "%";
                        break;

                    default:
                        break;
                    }
                    strSql.Append("@keyword ");
                }
                if (logic == "Null")
                {
                    strSql.Append(" AND " + field + " is null ");
                }
                else if (logic == "NotNull")
                {
                    strSql.Append(" AND " + field + " is not null ");
                }
                return(this.BaseRepository(databaseLinkEntity.F_DbConnection, databaseLinkEntity.F_DbType).FindTable(strSql.ToString(), new { keyword = keyword }, pagination));
            }
            catch (Exception ex)
            {
                if (ex is ExceptionEx)
                {
                    throw;
                }
                else
                {
                    throw ExceptionEx.ThrowServiceException(ex);
                }
            }
        }