public void deleteBySeq(string seq) { SQLiteConnection sqliteConn = null; try { sqliteConn = DBConnectionManager.connection(); SQLiteTransaction tran = sqliteConn.BeginTransaction(); SQLiteCommand sqlCommand = new SQLiteCommand(DBCommand.POWER_MODE_SQL_DELETE_BY_SEQ, sqliteConn); sqlCommand.Parameters.Add(new SQLiteParameter("a", DbType.Int32)); sqlCommand.Parameters[0].Value = seq; sqlCommand.ExecuteNonQuery(); tran.Commit(); } catch (CoreException ex) { throw ex; } catch (TypeInitializationException ex) { throw new CoreException(CoreException.FAILED_TO_GET_DB_CONNECTION_0, string.Empty); } catch (SQLiteException ex) { throw new CoreException(CoreException.FAILED_TO_EXECUTE_SQL_1, DBCommand.POWER_MODE_SQL_DELETE_BY_SEQ); } finally { DBConnectionManager.closeConnection(sqliteConn); } }
public DataTable query() { DataTable dataTable = null; SQLiteConnection sqliteConn = null; try { sqliteConn = DBConnectionManager.connection(); SQLiteDataAdapter dataAdapter = new SQLiteDataAdapter(DBCommand.POWER_MODE_SQL_QUERY_ALL, sqliteConn); DataSet dataSet = new DataSet(); dataAdapter.Fill(dataSet); if (dataSet.Tables.Count > 0) { dataTable = dataSet.Tables[0]; } } catch (CoreException ex) { throw ex; } catch (TypeInitializationException ex) { throw new CoreException(CoreException.FAILED_TO_GET_DB_CONNECTION_0, string.Empty); } catch (SQLiteException ex) { throw new CoreException(CoreException.FAILED_TO_EXECUTE_SQL_1, DBCommand.POWER_MODE_SQL_QUERY_ALL); } finally { DBConnectionManager.closeConnection(sqliteConn); } return(dataTable); }