IDataBaseTableService.cs 2.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657
  1. using LeaRun.Application.Entity.SystemManage;
  2. using LeaRun.Util.WebControl;
  3. using System.Collections.Generic;
  4. using System.Data;
  5. namespace LeaRun.Application.IService.SystemManage
  6. {
  7. /// <summary>
  8. /// 版 本 6.1
  9. /// Copyright (c) 2013-2016 上海力软信息技术有限公司
  10. /// 创建人:佘赐雄
  11. /// 日 期:2015.11.18 11:02
  12. /// 描 述:数据库管理
  13. /// </summary>
  14. public interface IDataBaseTableService
  15. {
  16. #region 获取数据
  17. /// <summary>
  18. /// 数据表列表
  19. /// </summary>
  20. /// <param name="dataBaseLinkId">库连接Id</param>
  21. /// <param name="tableName">表明</param>
  22. /// <returns></returns>
  23. DataTable GetTableList(string dataBaseLinkId, string tableName);
  24. /// <summary>
  25. /// 数据表字段列表
  26. /// </summary>
  27. /// <param name="dataBaseLinkId">库连接Id</param>
  28. /// <param name="tableName">表明</param>
  29. /// <returns></returns>
  30. IEnumerable<DataBaseTableFieldEntity> GetTableFiledList(string dataBaseLinkId, string tableName);
  31. /// <summary>
  32. /// 数据库表数据列表
  33. /// </summary>
  34. /// <param name="dataBaseLinkId">库连接</param>
  35. /// <param name="tableName">表明</param>
  36. /// <param name="switchWhere">条件</param>
  37. /// <param name="logic">逻辑</param>
  38. /// <param name="keyword">关键字</param>
  39. /// <param name="pagination">分页参数</param>
  40. /// <returns></returns>
  41. DataTable GetTableDataList(string dataBaseLinkId, string tableName, string switchWhere, string logic, string keyword, Pagination pagination);
  42. #endregion
  43. #region 提交数据
  44. /// <summary>
  45. /// 保存数据库表表单(新增、修改)
  46. /// </summary>
  47. /// <param name="dataBaseLinkId">库连接Id</param>
  48. /// <param name="tableName">表名称</param>
  49. /// <param name="tableDescription">表说明</param>
  50. /// <param name="fieldList">字段列表</param>
  51. void SaveForm(string dataBaseLinkId, string tableName, string tableDescription, IEnumerable<DataBaseTableFieldEntity> fieldList);
  52. #endregion
  53. }
  54. }