usingSystem;usingSystem.Collections.Generic;usingSystem.Data;usingSystem.Data.SQLite;namespaceEasyEnergy.AppLogicService
{public classAlarmSqliteDbHelp
{public static string ConnSqlLiteDbPath = @"D:\data\test.data";public static stringConnString
{get{return string.Format("Data Source={0}", ConnSqlLiteDbPath);
}
}public static int ExecuteRefId(stringsql)
{
SQLiteConnection connection;
SQLiteTransaction transaction= null;try{
connection= newSQLiteConnection(ConnString);
connection.Open();var command = newSQLiteCommand(connection)
{
CommandText= sql + ";SELECT last_insert_rowid()"};returnConvert.ToInt32(command.ExecuteScalar());
}catch(Exception)
{
transaction.Rollback();throw;
}
}public static int Execute(string sSQL