using System;
using System.Collections.Generic;
using System.Data.SQLite;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace OTSModelSharp.DTLBase
{
  public  interface IDBStoreBase
    {
		
		 bool IsTableExists(string a_sTableName);

		 List<string> GetTableList();
		 IDBQueryBase QueryByTableName(string a_sTableName, string a_sOrderColumnName);
		 IDBQueryBase QueryByCommand(string a_sQueryString);
		System.Data.DataTable QueryByCmdForDataTable(string a_sQueryString);

		System.Data.DataTable QueryByTableNameForDataTable(string a_sTableName, string a_sOrderColumnName);
		bool DeleteTable(string a_sTableName);

		 bool RunCommand(string a_sCommandString,  bool a_bIgnoreExist = false);

		bool BeginTransaction();
		 bool CommitTransaction();
		 bool CloseSynchronous();
		 long GetLastRowId(string a_sTableName = "");

		

		 bool InsertBlobData(string  szSql,  byte[] pBlobData, int iBlobDataLen);
		void ExecuteNonQueryBatch(ref List<KeyValuePair<string, SQLiteParameter[]>> list);
	}
}