1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283 |
- using LeaRun.Util.WebControl;
- using LeaRun.Util;
- using System;
- using System.Collections.Generic;
- using System.Data;
- using LeaRun.Application.Service.SystemManage;
- using LeaRun.Application.IService.SystemManage;
- using LeaRun.Application.Entity.SystemManage;
- namespace LeaRun.Application.Busines.SystemManage
- {
- /// <summary>
- /// 版 本 6.1
- /// Copyright (c) 2013-2016 上海力软信息技术有限公司
- /// 创建人:佘赐雄
- /// 日 期:2015.11.18 11:02
- /// 描 述:数据库管理
- /// </summary>
- public class DataBaseTableBLL
- {
- private IDataBaseTableService service = new DataBaseTableService();
- #region 获取数据
- /// <summary>
- /// 数据表列表
- /// </summary>
- /// <param name="dataBaseLinkId">库连接Id</param>
- /// <param name="tableName">表明</param>
- /// <returns></returns>
- public DataTable GetTableList(string dataBaseLinkId, string tableName)
- {
- return service.GetTableList(dataBaseLinkId, tableName);
- }
- /// <summary>
- /// 数据表字段列表
- /// </summary>
- /// <param name="dataBaseLinkId">数据库连接Id</param>
- /// <param name="tableName">表明</param>
- /// <returns></returns>
- public IEnumerable<DataBaseTableFieldEntity> GetTableFiledList(string dataBaseLinkId, string tableName = "")
- {
- return service.GetTableFiledList(dataBaseLinkId, tableName);
- }
- /// <summary>
- /// 数据库表数据列表
- /// </summary>
- /// <param name="dataBaseLinkId">库连接</param>
- /// <param name="tableName">表明</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 switchWhere, string logic, string keyword, Pagination pagination)
- {
- return service.GetTableDataList(dataBaseLinkId, tableName, switchWhere, logic, keyword, pagination);
- }
- #endregion
- #region 提交数据
- /// <summary>
- /// 保存数据库表表单(新增、修改)
- /// </summary>
- /// <param name="dataBaseLinkId">库连接Id</param>
- /// <param name="tableName">表名称</param>
- /// <param name="tableDescription">表说明</param>
- /// <param name="fieldListJson">字段列表Json</param>
- public void SaveForm(string dataBaseLinkId, string tableName, string tableDescription, string fieldListJson)
- {
- try
- {
- IEnumerable<DataBaseTableFieldEntity> fieldList = fieldListJson.ToList<DataBaseTableFieldEntity>();
- service.SaveForm(dataBaseLinkId, tableName, tableDescription, fieldList);
- }
- catch (Exception)
- {
- throw;
- }
- }
- #endregion
- }
- }
|