public void DeleteClientFinance(int accountID)
{
SqlCommand cmd = null;
SqlConnection conn = null;
SqlTransaction trans = null;
conn = new SqlConnection(connString);
conn.Open();
trans = conn.BeginTransaction();
cmd = new SqlCommand(cmdDeleteBankAccount, conn);
cmd.CommandType = CommandType.Text;
cmd.Transaction = trans;
SqlParameter parameter = new SqlParameter("@AccountID", SqlDbType.Int);
parameter.Value = accountID;
cmd.Parameters.Add(parameter);
try
{
cmd.ExecuteNonQuery();
trans.Commit();
}
catch (SqlException ex)
{
trans.Rollback();
throw ex;
}
finally
{
conn.Close();
cmd = null;
conn = null;
}
}

浙公网安备 33010602011771号