本文整理汇总了C#中CsvWriter.WriteRecords方法的典型用法代码示例。如果您正苦于以下问题:C# CsvWriter.WriteRecords方法的具体用法?C# CsvWriter.WriteRecords怎么用?C# CsvWriter.WriteRecords使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类CsvWriter
的用法示例。
在下文中一共展示了CsvWriter.WriteRecords方法的15个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: CSV
public FileStreamResult CSV()
{
MemoryStream ms;
using (var memoryStream = new MemoryStream())
using (var streamWriter = new StreamWriter(memoryStream))
using (var csvWriter = new CsvWriter(streamWriter))
{
csvWriter.WriteRecords(adminOrchestrator.AllAppData());
streamWriter.Flush();
var result = memoryStream.ToArray();
ms = new MemoryStream(result);
}
return new FileStreamResult(ms, "text/csv") { FileDownloadName = "SlpApplications.csv" };
}
示例2: AccountsImport
public FineUploaderResult AccountsImport(FineUpload upload)
{
try
{
List<Account> list;
using (var csv = new CsvReader(new StreamReader(upload.InputStream)))
{
csv.Configuration.ClassMapping<AccountMap, Account>();
list = csv.GetRecords<Account>().ToList();
}
//save to \\userdata01\Localuser\Users\HTMLEngager
var folder = ConfigurationManager.AppSettings["WebDriver/AccountImport/Folder"];
var fileName = string.Format("{0}\\{1:yyyyMMddHHmmssfff}.csv", folder, DateTime.UtcNow);
using (var csv = new CsvWriter(new StreamWriter(fileName)))
{
csv.Configuration.ClassMapping<AccountMap, Account>();
csv.WriteRecords(list);
}
//call mark sporc and wait for results
var conn = new SqlConnection(ConfigurationManager.ConnectionStrings["WebDriverEngager"].ConnectionString);
var p = new DynamicParameters();
p.Add("@SourceFilename", fileName);
p.Add("@Updated", dbType: DbType.Int32, direction: ParameterDirection.Output);
p.Add("@Inserted", dbType: DbType.Int32, direction: ParameterDirection.Output);
conn.Open();
conn.Execute("HTMLEngagerUpsert", p, commandType: CommandType.StoredProcedure);
conn.Close();
//delete file after import
System.IO.File.Delete(fileName);
return new FineUploaderResult(true, new
{
accountCount = list.Count(),
insertCount = p.Get<int>("@Inserted"),
updateCount = p.Get<int>("@Updated")
});
}
catch (Exception ex)
{
return new FineUploaderResult(false, error: ex.Message);
}
}
示例3: Main
private static void Main()
{
using (
var client = new HttpClient {BaseAddress = new Uri(ConfigurationManager.AppSettings["VSOnlineBaseUrl"])}
)
{
var history = new Historian(
new WorkItemRepository(new TfsConnection(ConfigurationManager.AppSettings["username"],
ConfigurationManager.AppSettings["password"], client)));
var burnup = history.GetBurnUpDataSince(new DateTime(2014, 7, 7, 23, 59, 59), @"BPS.Scrum\Dev -SEP Project");
using (var writer = new StreamWriter(@".\completed" + DateTime.Now.ToString("yyyymmmmdd") + ".xls"))
{
var csvWriter = new CsvWriter(writer, new CsvConfiguration { Delimiter = "\t" });
csvWriter.WriteRecords(burnup.First(s => s.Title == "Completed").Data);
}
using (var writer = new StreamWriter(@".\requested" + DateTime.Now.ToString("yyyymmmmdd") + ".xls"))
{
var csvWriter = new CsvWriter(writer, new CsvConfiguration { Delimiter = "\t" });
csvWriter.WriteRecords(burnup.First(s => s.Title == "Requested").Data);
}
}
}
示例4: GeneratePerformaceReport
static void GeneratePerformaceReport()
{
var iterations = 50;
using (var stream = new MemoryStream())
using (var reader = new StreamReader(stream))
using (var writer = new StreamWriter(stream))
using (var csv = new CsvWriter(writer))
{
csv.WriteHeader(typeof(PerformaceTestResult));
/* csv.WriteRecords(DoTestsForSettings(iterations, false, false, false));
csv.WriteRecords(DoTestsForSettings(iterations, false, false, true));
csv.WriteRecords(DoTestsForSettings(iterations, false, true, false));
csv.WriteRecords(DoTestsForSettings(iterations, false, true, true));
csv.WriteRecords(DoTestsForSettings(iterations, true, false, false));
csv.WriteRecords(DoTestsForSettings(iterations, true, false, true));
csv.WriteRecords(DoTestsForSettings(iterations, true, true, false));
*/
csv.WriteRecords(DoTestsForSettings(iterations, true, true, true));
writer.Flush();
stream.Position = 0;
var text = reader.ReadToEnd();
File.WriteAllText("Report.csv", text);
}
}
示例5: FiltersForLineItemType
public void FiltersForLineItemType()
{
// Arrange
var sw = new StringWriter();
using (var csv = new CsvWriter(sw))
{
var lineItems = new[]
{
new LineItem {RecordType = "Dummy"},
new LineItem {RecordType = "LineItem", RecordId = "Hoojey"}
};
csv.WriteHeader<LineItem>();
csv.WriteRecords(lineItems);
}
// Act
List<LineItem> parsedItems;
using (var reader = new StringReader(sw.ToString()))
{
using (var parser = new LineItemCsvParser(reader))
{
parsedItems = parser.GetLineItems().ToList();
}
}
// Assert
parsedItems.Count.Should().Be(1);
parsedItems[0].RecordId.Should().Be("Hoojey");
}
示例6: btnOutputCsv_Click
/// <summary>
/// CSV出力ボタンクリック処理
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnOutputCsv_Click(object sender, EventArgs e)
{
// フォルダチェック
if (!ExistsPath(txtFolderPath.Text)) return;
// ファイル保存先の指定
dlgFileSave.FileName = "tree.csv";
dlgFileSave.Filter = "CSVファイル(*.csv)|*.csv";
dlgFileSave.Title = "保存先のファイルを指定してください";
dlgFileSave.RestoreDirectory = true;
if (dlgFileSave.ShowDialog() != DialogResult.OK)
{
return;
}
// ファイル取得
var records = ToCsvRecord(txtFolderPath.Text);
// CSV出力
using (var sr = new StreamWriter(dlgFileSave.FileName, false, Encoding.GetEncoding(932)))
using (var csv = new CsvWriter(sr))
{
csv.Configuration.Encoding = Encoding.GetEncoding(932);
csv.Configuration.AllowComments = false;
csv.Configuration.HasHeaderRecord = true;
csv.Configuration.RegisterClassMap<CsvRecordMap>();
csv.Configuration.QuoteAllFields = true;
csv.WriteRecords(records);
}
MessageBox.Show("終わったよ!");
}
示例7: WriteMultipleNamesTest
public void WriteMultipleNamesTest()
{
var records = new List<MultipleNamesAttributeClass>
{
new MultipleNamesAttributeClass { IntColumn = 1, StringColumn = "one" },
new MultipleNamesAttributeClass { IntColumn = 2, StringColumn = "two" }
};
string csv;
using( var stream = new MemoryStream() )
using( var reader = new StreamReader( stream ) )
using( var writer = new StreamWriter( stream ) )
using( var csvWriter = new CsvWriter( writer ) )
{
csvWriter.Configuration.AttributeMapping<MultipleNamesAttributeClass>();
csvWriter.WriteRecords( records );
writer.Flush();
stream.Position = 0;
csv = reader.ReadToEnd();
}
var expected = string.Empty;
expected += "int1,string1\r\n";
expected += "1,one\r\n";
expected += "2,two\r\n";
Assert.NotNull( csv );
Assert.Equal( expected, csv );
}
示例8: WriteDynamicExpandoObjectsTest
public void WriteDynamicExpandoObjectsTest()
{
using( var stream = new MemoryStream() )
using( var reader = new StreamReader( stream ) )
using( var writer = new StreamWriter( stream ) )
using( var csv = new CsvWriter( writer ) )
{
var list = new List<dynamic>();
dynamic obj = new ExpandoObject();
obj.Id = 1;
obj.Name = "one";
list.Add( obj );
obj = new ExpandoObject();
obj.Id = 2;
obj.Name = "two";
list.Add( obj );
csv.WriteRecords( list );
writer.Flush();
stream.Position = 0;
var expected = "Id,Name\r\n";
expected += "1,one\r\n";
expected += "2,two\r\n";
Assert.AreEqual( expected, reader.ReadToEnd() );
}
}
示例9: Migration
public ActionResult Migration(string start, string end)
{
DateTime StartDate = Convert.ToDateTime(start);
DateTime EndDate = Convert.ToDateTime(end);
var context = new IPTV2Entities();
foreach (DateTime day in MyUtility.EachDay(StartDate, EndDate))
{
DateTime startDt = Convert.ToDateTime(String.Format("{0} {1}", day.ToString("yyyy/MM/dd"), "00:00:00"));
DateTime endDt = Convert.ToDateTime(String.Format("{0} {1}", day.ToString("yyyy/MM/dd"), "23:59:59"));
var report = context.Users
.Join(context.Countries, userdetails => userdetails.CountryCode, country => country.Code, (userdetails, country) => new { userdetails, country })
.Join(context.GomsSubsidiaries, user => user.country.GomsSubsidiaryId, subsidiary => subsidiary.GomsSubsidiaryId, (user, subsidiary) => new { user, subsidiary })
.Where(result => result.user.userdetails.RegistrationDate >= @startDt && result.user.userdetails.RegistrationDate <= @endDt && result.user.userdetails.TfcNowUserName != null)
.GroupBy(result => result.subsidiary.Description)
.Select(result => new { description = result.Key, count = result.Count() })
.OrderByDescending(result => result.count).ToList();
string filePath = @"C:\bin\global dropbox\Audie\Migration\";
string fileName = startDt.ToString("yyyyMMdd") + ".csv";
using (StreamWriter writer = new StreamWriter(filePath + fileName))
{
var csv = new CsvWriter(writer);
csv.WriteRecords(report);
}
}
return null;
}
示例10: WriteAllRecordsWithMapping
public void WriteAllRecordsWithMapping()
{
var records = new List<CustomObject>
{
new CustomObject
{
GuidColumn = new Guid("f96a1c66-4777-4642-86fa-703098065f5f"),
IntColumn = 1,
StringColumn = "one",
CustomTypeColumn = new CustomType
{
First = 1,
Second = 2,
Third = 3,
},
},
new CustomObject
{
GuidColumn = new Guid("06776ed9-d33f-470f-bd3f-8db842356330"),
IntColumn = 2,
StringColumn = "two",
CustomTypeColumn = new CustomType
{
First = 4,
Second = 5,
Third = 6,
},
},
};
Benchmark.This("CsvWriter.WriteRecords", () =>
{
using (var memoryStream = new MemoryStream())
using (var streamWriter = new StreamWriter(memoryStream))
using (var writer = new CsvWriter(streamWriter))
{
writer.Configuration.RegisterClassMap<CsvHelperMappingForCustomObject>();
writer.WriteRecords(records);
streamWriter.Flush();
}
})
.Against.This("FlatFileEngine.Write", () =>
{
var layout = new FlatFileMappingForCustomObject();
using (var stream = new MemoryStream())
{
var factory = new DelimitedFileEngineFactory();
var flatFile = factory.GetEngine(layout);
flatFile.Write(stream, records);
}
})
.WithWarmup(1000)
.For(10000)
.Iterations()
.PrintComparison();
}
示例11: ExportCsv
public static void ExportCsv(string path)
{
using (var csv = new CsvWriter(new StreamWriter(path)))
{
csv.Configuration.RegisterClassMap<Models.GroupCsvMap>();
csv.WriteRecords(SearchGroups());
}
}
示例12: Export
public void Export(IEnumerable<Record> records, TextWriter writer)
{
var csv = new CsvWriter(writer);
TopcatMapping.ApplyStandardTopcatCsvConfiguration(csv.Configuration);
csv.WriteRecords(records);
}
示例13: Main
static void Main(string[] args)
{
var repo = new DeployRepository();
var deploys = repo.Collection.FindAll().ToList();
using (var csv = new CsvWriter(new StreamWriter("black-mesa.tsv")))
{
csv.Configuration.Delimiter = "\t";
csv.WriteRecords<Deploy>(deploys);
}
}
示例14: ExportAllJournals
public void ExportAllJournals(Stream stream)
{
Requires.NotNull(stream, "stream");
using (var streamWriter = new StreamWriter(stream))
using (var csvWriter = new CsvWriter(streamWriter, CsvConfiguration))
{
csvWriter.WriteRecords((IEnumerable)this.GetExportJournals());
}
}
示例15: To
public void To(string file, List<GameStats> stats)
{
using (var writer = new StreamWriter(file))
{
using (var csv = new CsvWriter(writer))
{
csv.Configuration.RegisterClassMap<GameStatsMap>();
csv.WriteHeader<GameStats>();
csv.WriteRecords(stats);
}
}
}