IDBTableBase.cs 1.0 KB

1234567891011121314151617181920212223242526272829303132333435
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Data;
  4. using System.Linq;
  5. using System.Text;
  6. using System.Threading.Tasks;
  7. namespace OTSModelSharp.DTLBase
  8. {
  9. public interface IDBTableBase
  10. {
  11. void AddColumn(ColumnDefine col);
  12. int GetColumnCount();
  13. string GetTableName();
  14. void SetTableName(string a_sTableName);
  15. //void AddColumn(string v, object sTRING);
  16. string GetColumnName(int a_nColId);
  17. string GetColumnFullName(int a_nColId);
  18. string GetColumnNames(bool a_bWithPrimary = true);
  19. string GetColumnFullNames(bool a_bWithPrimary = true);
  20. ColumnType GetColumnType(int a_nColId);
  21. string GetCreateTableCommandString();
  22. string GetDeleteTableCommandString();
  23. string GetRemoveAllRowsCommandString();
  24. string GetInsertCommandFormatString(bool a_bWithPrimary = false);
  25. string GetInsertCommandFormatString(List<int> a_colIndexes);
  26. string GetUpdateCommandFormatString(List<int> a_updateColIndexes, int a_nConditionColIndex);
  27. }
  28. }