C# CsvWriter.Dispose方法代码示例

 public void Save(List<BouncingBallClass> balls, string FilePath)
 {
     CsvWriter csv = new CsvWriter(new StreamWriter(FilePath));
     csv.WriteRecords(balls);
     csv.Dispose();
 }

//.........这里部分代码省略.........
            pitCsv.WriteField("Gender");
            pitCsv.WriteField("Age");
            pitCsv.WriteField("Family");
            pitCsv.WriteField("Dwelling");
            pitCsv.WriteField("Location");
            pitCsv.NextRecord();

            var ids = new List<int>();

            foreach (var result in results)
            {
                if (result.SubmitThis)
                {
                    if (result.IsTallySheet)
                    {
                        var pit = db.PITs.Find(result.Id);
                        pit.Notes = result.Notes;
                        pit.SubmissionDate = DateTime.Now;
                        db.SaveChanges();
                        pitCsv.WriteField(pit.PITId);
                        pitCsv.WriteField(pit.Notes, true);
                        pitCsv.WriteField(pit.CreatedDate);
                        pitCsv.WriteField(pit.User.FirstName + " " + pit.User.LastName);
                        pitCsv.WriteField(pit.Latitude);
                        pitCsv.WriteField(pit.Longitude);
                        pitCsv.WriteField(pit.GenderAnswer, true);
                        pitCsv.WriteField(pit.AgeAnswer, true);
                        pitCsv.WriteField(pit.FamilyAnswer, true);
                        pitCsv.WriteField(pit.DwellingAnswer, true);
                        pitCsv.WriteField(pit.LocationAnswer, true);
                        pitCsv.NextRecord();
                    }
                    else
                    {
                        var sqlStatment =
                            "update ClientSurveys set [email protected], [email protected] where ClientSurveyId = @Id";
                        var notes = new SqlParameter("Notes", !string.IsNullOrEmpty(result.Notes) ? result.Notes : " ");
                        var submissionDate = new SqlParameter("SubmissionDate", DateTime.Now);
                        var id = new SqlParameter("Id", result.Id);

                        ids.Add(result.Id);
                        db.Database.ExecuteSqlCommand(sqlStatment, new[] {notes, submissionDate, id});
                    }
                }
            }

            var css = db.ClientSurveys.Where(x => ids.Contains(x.ClientSurveyId)).Include(x => x.Client).Include(x=>x.User);
            if (css.Any())
            {
                var allQuestions =
                    db.SurveyQuestions.Where(s => s.SurveyId == css.FirstOrDefault().SurveyId)
                        .Include(sq => sq.Question)
                        .Select(s => s.Question);

                var questionIds = allQuestions.Select(q => q.QuestionId).ToList();
                var surveyWriter =
                    new StreamWriter(
                        string.Format(
                            AppDomain.CurrentDomain.BaseDirectory + "\\PitData\\PitSurvey-{0}-{1}-{2}-{3}{4}{5}.csv",
                            current.Day, current.Month, current.Year, current.Hour, current.Minute, current.Millisecond));
                var surveyCsv = new CsvWriter(surveyWriter);
                surveyCsv.Configuration.HasHeaderRecord = true;
                surveyCsv.WriteField("Id");
                surveyCsv.WriteField("Notes");
                surveyCsv.WriteField("Created");
                surveyCsv.WriteField("CreatedBy");
                surveyCsv.WriteField("Latitude");
                surveyCsv.WriteField("Longitude");
                foreach (var qId in questionIds)
                {
                    var quest = allQuestions.FirstOrDefault(q => q.QuestionId == qId);
                    if (quest != null)
                    {
                        surveyCsv.WriteField(quest.QuestionText, true);
                    }
                }
                surveyCsv.NextRecord();

                foreach (var cs in css)
                {
                    surveyCsv.WriteField(cs.ClientSurveyId);
                    surveyCsv.WriteField(cs.Notes, true);
                    surveyCsv.WriteField(cs.SurveyDate);
                    surveyCsv.WriteField(cs.User.FirstName + " " + cs.User.LastName);
                    surveyCsv.WriteField(cs.Client.Latitude);
                    surveyCsv.WriteField(cs.Client.Longitude);
                    foreach (var qId in questionIds)
                    {
                        var csr = cs.Responses.FirstOrDefault(c => c.QuestionId == qId);
                        surveyCsv.WriteField(csr != null ? csr.Value : "", true);
                    }
                    surveyCsv.NextRecord();
                }

                surveyCsv.Dispose();
            }

            pitCsv.Dispose();
            return RedirectToAction(MVC.Pit.TallySheets());
        }

        private void readCSV(string link)
        {
            try
            {
                using (TextReader reader = File.OpenText(link))
                {

                    CsvConfiguration config = new CsvConfiguration()
                    {
                        Delimiter = ",",
                        QuoteAllFields = false,
                        IgnoreHeaderWhiteSpace = true,
                        IsHeaderCaseSensitive = true
                    };

                    var csv = new CsvReader(reader, config);

                    ReadLine(reader, 6);

                    var records = csv.GetRecords<InSetup>();

                    string newlink = link.Remove(link.Length - 4) + "-new.csv";
                    TextWriter tw = File.CreateText(newlink);
                    var writer = new CsvWriter(tw);
                    writer.WriteField("Date");
                    writer.WriteField("Description");
                    writer.WriteField("Amount");
                    writer.WriteField("Type");
                    writer.NextRecord();
                    foreach (InSetup record in records)
                    {
                        //write record field by field
                        writer.WriteField(record.Date);

                        string description = GetDescription(record);
                        writer.WriteField(description);

                        string amount = PosAmount(record.Amount.ToString());
                        writer.WriteField(amount);

                        string classification = Classify(description);
                        writer.WriteField(classification);

                        //ensure you write end of record when you are using WriteField method
                        writer.NextRecord();
                    }

                    writer.Dispose();
                    reader.Dispose();
                    reader.Close();
                    MessageBox.Show("All Done!");
                }

            }
            catch (CsvMissingFieldException e)
            {
                MessageBox.Show("Please remove any spaces in the CSV headers");
            }
            catch (IOException e)
            {
                MessageBox.Show("File is being used by another program. Cannot open");
            }


        }

 public void flush_throws_if_disposed()
 {
     var writer = new CsvWriter(new MemoryStream());
     writer.Dispose();
     Assert.Throws<ObjectDisposedException>(() => writer.Flush());
 }

 public async Task flush_async_throws_if_disposed()
 {
     var writer = new CsvWriter(new MemoryStream());
     writer.Dispose();
     await Assert.ThrowsAsync<ObjectDisposedException>(() => writer.FlushAsync());
 }

 public async Task write_records_async_throws_if_disposed()
 {
     var writer = new CsvWriter(new MemoryStream());
     writer.Dispose();
     await Assert.ThrowsAsync<ObjectDisposedException>(() => writer.WriteRecordsAsync(new RecordBase[1], 0, 1));
 }

 public void value_separator_throws_if_disposed()
 {
     var writer = new CsvWriter(new MemoryStream());
     writer.Dispose();
     Assert.Throws<ObjectDisposedException>(() => writer.ValueSeparator);
 }

 public void force_delimit_throws_if_disposed()
 {
     var writer = new CsvWriter(new MemoryStream());
     writer.Dispose();
     Assert.Throws<ObjectDisposedException>(() => writer.ForceDelimit);
 }

 public void write_records_throws_if_disposed()
 {
     var writer = new CsvWriter(new MemoryStream());
     writer.Dispose();
     Assert.Throws<ObjectDisposedException>(() => writer.WriteRecords(new RecordBase[1], 0, 1));
 }

 public void record_number_throws_if_disposed()
 {
     var writer = new CsvWriter(new MemoryStream());
     writer.Dispose();
     Assert.Throws<ObjectDisposedException>(() => writer.RecordNumber);
 }

 public async Task write_record_async_values_throws_if_disposed()
 {
     var writer = new CsvWriter(new MemoryStream());
     writer.Dispose();
     await Assert.ThrowsAsync<ObjectDisposedException>(() => writer.WriteRecordAsync("one", "two", "three"));
 }

 public async Task write_record_async_record_throws_if_disposed()
 {
     var writer = new CsvWriter(new MemoryStream());
     writer.Dispose();
     await Assert.ThrowsAsync<ObjectDisposedException>(() => writer.WriteRecordAsync(new HeaderRecord()));
 }

 public void write_record_values_throws_if_disposed()
 {
     var writer = new CsvWriter(new MemoryStream());
     writer.Dispose();
     Assert.Throws<ObjectDisposedException>(() => writer.WriteRecord("one", "two", "three"));
 }

 public void write_record_record_throws_if_disposed()
 {
     var writer = new CsvWriter(new MemoryStream());
     writer.Dispose();
     Assert.Throws<ObjectDisposedException>(() => writer.WriteRecord(new HeaderRecord()));
 }

 public void new_line_throws_if_disposed()
 {
     var writer = new CsvWriter(new MemoryStream());
     writer.Dispose();
     Assert.Throws<ObjectDisposedException>(() => writer.NewLine);
 }