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
{
///
/// 版 本 6.1
/// Copyright (c) 2013-2016 上海力软信息技术有限公司
/// 创建人:佘赐雄
/// 日 期:2015.11.18 11:02
/// 描 述:数据库管理
///
public class DataBaseTableBLL
{
private IDataBaseTableService service = new DataBaseTableService();
#region 获取数据
///
/// 数据表列表
///
/// 库连接Id
/// 表明
///
public DataTable GetTableList(string dataBaseLinkId, string tableName)
{
return service.GetTableList(dataBaseLinkId, tableName);
}
///
/// 数据表字段列表
///
/// 数据库连接Id
/// 表明
///
public IEnumerable GetTableFiledList(string dataBaseLinkId, string tableName = "")
{
return service.GetTableFiledList(dataBaseLinkId, tableName);
}
///
/// 数据库表数据列表
///
/// 库连接
/// 表明
/// 条件
/// 逻辑
/// 关键字
/// 分页参数
///
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 提交数据
///
/// 保存数据库表表单(新增、修改)
///
/// 库连接Id
/// 表名称
/// 表说明
/// 字段列表Json
public void SaveForm(string dataBaseLinkId, string tableName, string tableDescription, string fieldListJson)
{
try
{
IEnumerable fieldList = fieldListJson.ToList();
service.SaveForm(dataBaseLinkId, tableName, tableDescription, fieldList);
}
catch (Exception)
{
throw;
}
}
#endregion
}
}