/// <summary> /// 在打开的事务中执行一条SQL命令 /// </summary> /// <param name="SqlCommandText">SQL命令</param> /// <param name="Transaction">一个在外部打开事务,也要在外部提交</param> /// <returns>成功返回1,失败返回-1</returns> public int UpdateCommand(DataTable WillUpdateDataTable, Transaction Transaction) { using (SQLiteConnection connection = new SQLiteConnection(sqliteata.ConnStr)) { if (connection.State == ConnectionState.Closed) { connection.Open(); } return(sqliteata.Update(WillUpdateDataTable, Transaction)); } }