/// <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);
}
}
