/// <summary>
/// 關閉資料庫連接
/// </summary>
internal void CloseDatabase()
{
if (m_SQL == null)
{
return;
}
m_SQL.Close();
m_SQL = null;
}
/// <summary>
/// 照SQL語法取得Table資料
/// </summary>
/// <param name="Schema"></param>
/// <returns></returns>
private DataTable GetDataTable(DaoDbCommon DbCom, string Schema, params object[] Values)
{
DataTable Dt;
DaoErrMsg Err = DbCom.GetDataTable(Schema, out Dt, Values);
if (Err.isError)
{
return(null);
}
return(Dt);
}
private DaoErrMsg ConnectSQLite()
{
DaoErrMsg Err = new DaoErrMsg();
if (m_SQL != null)
{
//表示已開啟過;//
return(Err);
}
//連接Sqlite;//
string SQLiteConn = @"Data source = ./MYP.db; Password = Myp53750804; DateTimeKind = Utc";
m_SQL = new DaoDbCommon(SQLiteConn, new SQLiteConnection());
Err = m_SQL.Connect();
if (Err.isError)
{
System.Diagnostics.Debug.WriteLine(Err.ErrorMsg);
m_SQL = null;
return(Err);
}
return(Err);
}
