本文整理汇总了C#中CsvWriter.Dispose方法的典型用法代码示例。如果您正苦于以下问题:C# CsvWriter.Dispose方法的具体用法?C# CsvWriter.Dispose怎么用?C# CsvWriter.Dispose使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类CsvWriter
的用法示例。
在下文中一共展示了CsvWriter.Dispose方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Save
public void Save(List<BouncingBallClass> balls, string FilePath)
{
CsvWriter csv = new CsvWriter(new StreamWriter(FilePath));
csv.WriteRecords(balls);
csv.Dispose();
}
示例2: SubmitResponses
//.........这里部分代码省略.........
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());
}
示例3: readCSV
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");
}
}
示例4: flush_throws_if_disposed
public void flush_throws_if_disposed()
{
var writer = new CsvWriter(new MemoryStream());
writer.Dispose();
Assert.Throws<ObjectDisposedException>(() => writer.Flush());
}
示例5: flush_async_throws_if_disposed
public async Task flush_async_throws_if_disposed()
{
var writer = new CsvWriter(new MemoryStream());
writer.Dispose();
await Assert.ThrowsAsync<ObjectDisposedException>(() => writer.FlushAsync());
}
示例6: write_records_async_throws_if_disposed
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));
}
示例7: value_separator_throws_if_disposed
public void value_separator_throws_if_disposed()
{
var writer = new CsvWriter(new MemoryStream());
writer.Dispose();
Assert.Throws<ObjectDisposedException>(() => writer.ValueSeparator);
}
示例8: force_delimit_throws_if_disposed
public void force_delimit_throws_if_disposed()
{
var writer = new CsvWriter(new MemoryStream());
writer.Dispose();
Assert.Throws<ObjectDisposedException>(() => writer.ForceDelimit);
}
示例9: write_records_throws_if_disposed
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));
}
示例10: record_number_throws_if_disposed
public void record_number_throws_if_disposed()
{
var writer = new CsvWriter(new MemoryStream());
writer.Dispose();
Assert.Throws<ObjectDisposedException>(() => writer.RecordNumber);
}
示例11: write_record_async_values_throws_if_disposed
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"));
}
示例12: write_record_async_record_throws_if_disposed
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()));
}
示例13: write_record_values_throws_if_disposed
public void write_record_values_throws_if_disposed()
{
var writer = new CsvWriter(new MemoryStream());
writer.Dispose();
Assert.Throws<ObjectDisposedException>(() => writer.WriteRecord("one", "two", "three"));
}
示例14: write_record_record_throws_if_disposed
public void write_record_record_throws_if_disposed()
{
var writer = new CsvWriter(new MemoryStream());
writer.Dispose();
Assert.Throws<ObjectDisposedException>(() => writer.WriteRecord(new HeaderRecord()));
}
示例15: new_line_throws_if_disposed
public void new_line_throws_if_disposed()
{
var writer = new CsvWriter(new MemoryStream());
writer.Dispose();
Assert.Throws<ObjectDisposedException>(() => writer.NewLine);
}