using OTSModelSharp.DTLBase;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace OTSModelSharp.DTLBase
{
    public interface IDBBase
    {
 
        /// 建表
        /// </summary>
        /// <param name="a_bClean">如果a_bClean删除表再建表</param>
        /// <returns></returns>
        bool Init(bool a_bClean = false);
        /// <summary>
        ///建表
        /// </summary>
        /// <returns></returns>
        bool CreateTable(bool a_bForce=false);
        /// <summary>
        ///删除表
        /// </summary>
        /// <returns></returns>
        bool DeleteTable();

        /// <summary>
        ///移除表数据
        /// </summary>
        /// <returns></returns>
        bool RemoveAllRows();
        /// <summary>
        /// 判断表是否存在
        /// </summary>
        /// <returns></returns>
        bool IsDBExist();
        /// <summary>
        /// 获取连接字符串
        /// </summary>
        /// <returns></returns>
        IDBStoreBase GetDatastore();
        /// <summary>
        /// 获取表结构
        /// </summary>
        /// <returns></returns>
        IDBTableBase GetTableInfo();
        /// <summary>
        /// 获取表所有信息
        /// </summary>
        /// <param name="a_sOrderColumnName">排序字段</param>
        /// <returns></returns>
        IDBQueryBase GetTableQuery(string a_sOrderColumnName);

       
    }
}