IDBBase.cs 1.5 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859
  1. using OTSModelSharp.DTLBase;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Data;
  5. using System.Linq;
  6. using System.Text;
  7. using System.Threading.Tasks;
  8. namespace OTSModelSharp.DTLBase
  9. {
  10. public interface IDBBase
  11. {
  12. /// 建表
  13. /// </summary>
  14. /// <param name="a_bClean">如果a_bClean删除表再建表</param>
  15. /// <returns></returns>
  16. bool Init(bool a_bClean = false);
  17. /// <summary>
  18. ///建表
  19. /// </summary>
  20. /// <returns></returns>
  21. bool CreateTable(bool a_bForce=false);
  22. /// <summary>
  23. ///删除表
  24. /// </summary>
  25. /// <returns></returns>
  26. bool DeleteTable();
  27. /// <summary>
  28. ///移除表数据
  29. /// </summary>
  30. /// <returns></returns>
  31. bool RemoveAllRows();
  32. /// <summary>
  33. /// 判断表是否存在
  34. /// </summary>
  35. /// <returns></returns>
  36. bool IsDBExist();
  37. /// <summary>
  38. /// 获取连接字符串
  39. /// </summary>
  40. /// <returns></returns>
  41. IDBStoreBase GetDatastore();
  42. /// <summary>
  43. /// 获取表结构
  44. /// </summary>
  45. /// <returns></returns>
  46. IDBTableBase GetTableInfo();
  47. /// <summary>
  48. /// 获取表所有信息
  49. /// </summary>
  50. /// <param name="a_sOrderColumnName">排序字段</param>
  51. /// <returns></returns>
  52. IDBQueryBase GetTableQuery(string a_sOrderColumnName);
  53. }
  54. }