/// <summary> /// 执行Sql语句并返回 SQLiteDataReader /// </summary> /// <param name="sql"></param> /// <returns></returns> public static SQLiteDataReader ExecuteReader(string sql) { try { using (SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection)) { return(command.ExecuteReader()); } } catch (System.Exception ex) { LogsHelper.WriteLog("ExecuteNonQuery()", LogsEnum.Error, ex); return(null); } }
/// <summary> /// 执行sql语句,并返回操作结果 /// </summary> /// <param name="sql"></param> /// <returns></returns> public static int ExecuteNonQuery(string sql) { try { using (SQLiteCommand command = new SQLiteCommand(sql, m_dbConnection)) { return(command.ExecuteNonQuery()); } } catch (Exception ex) { LogsHelper.WriteLog("ExecuteNonQuery()", LogsEnum.Error, ex); return(-1); } }