/// <summary>
/// 新增、修改、删除操作
/// </summary>
/// <param name="sqlStr">sql字符</param>
/// <returns>无</returns>
public static void insOrUpdOrDel(string sqlStr)
{
//创建数据库连接
MySqlConnection conn = new MySqlConnect().getConnection(new MySqlConnect().connection());
//启动一个事务
MySqlTransaction myTrans = conn.BeginTransaction();
//事务命令
MySqlCommand cmd = conn.CreateCommand();
//事务命令
cmd.Transaction = myTrans;
try
{
//执行数据库新增、修改、删除操作
MySqlHelper.ExecuteNonQuery(conn, sqlStr);
//事务提交
myTrans.Commit();
//关闭释放连接资源
conn.Close();
}
catch (Exception ex)
{
//遇到错误回滚
myTrans.Rollback();
//关闭释放连接资源
conn.Close();
//错误日志
LogHelper.WriteError("新增、修改、删除操作异常回滚：" + ex.Message);
}
}
/// <summary>
/// 数据库参数式新增、修改、删除操作
/// </summary>
/// <param name="sqlStr">sql字符</param>
/// <returns>无</returns>
public static int insOrUpdOrDel(string sqlStr, MySqlParameter[] commandParameters)
{
//创建数据库连接
MySqlConnection conn = new MySqlConnect().getConnection(new MySqlConnect().connection());
//启动一个事务
MySqlTransaction myTrans = conn.BeginTransaction();
//事务命令
MySqlCommand cmd = conn.CreateCommand();
//事务命令
cmd.Transaction = myTrans;
int result = 0;
try
{
//执行数据库新增、修改、删除操作
result = MySqlHelper.ExecuteNonQuery(conn, sqlStr, commandParameters);
//事务提交
myTrans.Commit();
//关闭释放连接资源
conn.Close();
//
return(result);
}
catch (Exception ex)
{
//异常回滚
myTrans.Rollback();
//关闭释放连接资源
conn.Close();
//异常日志
LogHelper.WriteError("新增、修改、删除操作异常回滚：" + ex.Message);
return(0);
}
}