事務的應用

在同時刪除多個表時建議應用事務來處理，防止產生資料不一致。
public int delete(int id)
  {
   string strConnectionString =Beyondbit.Data.DbConn.Sql_ConnectionString;
 
   int i=0;
   using (SqlConnection cn = new SqlConnection(strConnectionString))
   {
    cn.Open();
    using (SqlTransaction trans = cn.BeginTransaction())
    {
     try
     {
      string strSqlString="delete from userList where id='"+id+"'";
      SqlHelper.ExecuteNonQuery(trans,CommandType.Text, strSqlString);

      strSqlString="delete from taskcenter where id='"+id+"'";
      SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strSqlString);

      strSqlString="delete from form_document where DocID='"+id+"'";
      SqlHelper.ExecuteNonQuery(trans, CommandType.Text, strSqlString);

      trans.Commit();
     }
     catch (Exception ex)
     {
      trans.Rollback();
      i = -1;
      throw ex;
     }
     finally
     {
      cn.Close();
     }
    }
   }
   return i;
  }