像是这样:
public static bool DeletePlanByPlanUid(ListplanUidList) { SqlConnection conn = new SqlConnection(DataBase.connectString); conn.Open(); SqlTransaction transaction = conn.BeginTransaction(); SqlCommand cmd = conn.CreateCommand(); cmd.Transaction = transaction; try { foreach (string planUid in planUidList) {//liuhong string sqlStr = SqlStr.setPlanDeleted; cmd.CommandText = sqlStr; cmd.Parameters.AddWithValue("@PlanUid", planUid); cmd.ExecuteNonQuery(); cmd.Parameters.Clear(); } transaction.Commit(); return true; } catch (Exception ex) { transaction.Rollback(); return false; } finally { conn.Close(); } }