public void Cardinality(string casesFilesDir, int maxNumOfDiag)
{
CSVExport myExport = new CSVExport();
List <PhysioCaseInstance> physioCases = new List <PhysioCaseInstance>();
List <string> files = Directory.GetFiles(casesFilesDir).ToList();
foreach (string file in files)
{
PhysioCaseInstance physioCase = caseParser.ParseCase(file);
if (physioCase != null)
{
physioCases.Add(physioCase);
}
}
foreach (PhysioCaseInstance physioCase in physioCases)
{
if (physioCase.Diagnoses.Count < 2 || (maxNumOfDiag > 0 && physioCase.Diagnoses.Count > maxNumOfDiag))
{
continue;
}
myExport.AddRow();
myExport["Observation"] = physioCase.Id;
myExport["RealDiagCard"] = physioCase.RealDiagCardinality;
myExport["MaxCard"] = physioCase.MaxCardinality;
myExport["MinCard"] = physioCase.MinCardinality;
}
myExport.ExportToFile("Physiotherapy_Cardinality.csv");
}
public ActionResult ExportCoursesDeadline(string check)
{
string searchCheck = check.Split('^')[0];
string Course_Name = check.Split('^')[1];
string Semester_ID = check.Split('^')[2];
Course_Name = Course_Name == "2" ? "" : Course_Name;
Semester_ID = Semester_ID == "3" ? "" : Semester_ID;
List <Cour_dealine> list = new List <Cour_dealine>();
if (searchCheck != "1")
{
list = unitOfWork.DeadLine.GetPageList(Course_Name, Semester_ID);
}
var myExport = new CSVExport();
foreach (var course in list)
{
myExport.AddRow();
myExport[""] = course.groupRowNo;
myExport["Subject ID"] = course.Subject_ID;
myExport["Course Name"] = course.Courses_Name;
myExport["Deadline"] = course.deadlineString;
myExport["Semester"] = course.Semester_Name;
}
return(File(myExport.ExportToBytes(), "text/csv", "Courses-Deadline.csv"));
}
public override async Task <ExportResponse> Handle(Query request, CancellationToken cancellationToken) =>
new ExportResponse(
CSVExport.GenerateFilename("cryptos"),
CSVExport.Generate(
(await _storage.GetCryptos(request.UserId))
)
);
protected void btnExportLearningContacts_Click(object sender, EventArgs e)
{
var constituents = Learning();
var dataset = from p in db.CRM_Persons
where db.CRM_FormFieldResponses.Any(r =>
r.CRM_FormFieldItemID != null && constituents.Contains((int)r.CRM_FormFieldItemID) &&
r.TargetReference == p.Reference)
let constituentOutput = p.ConstituentTypeOutput(db, " ")
where !p.IsArchived
select new {
p.Title,
p.Firstname,
p.Lastname,
p.IsAnnualPassHolder,
p.PrimaryEmail,
p.CalculatedSalutation,
constituentOutput,
p.PrimaryAddressLine1,
p.PrimaryAddressLine2,
p.PrimaryAddressLine3,
p.PrimaryAddressLine4,
p.PrimaryAddressLine5,
p.PrimaryAddressTown,
p.PrimaryAddressCounty,
p.PrimaryAddressPostcode,
p.PrimaryAddressCountry,
p.NextExpiryDate,
p.IsDoNotEmail,
p.IsDoNotMail
};
CSVExport.GenericExport(dataset.ToArray(), "learning-contacts");
}
private void btnExportOrgContacts_Click(object sender, EventArgs e)
{
var dataset = from p in db.CRM_PersonOrganisations
where !p.CRM_Organisation.IsArchived
where !p.CRM_Person.IsArchived
let Role = p.CRM_Role.Name
orderby p.CRM_Organisation.Name
select new
{
p.CRM_OrganisationID,
p.CRM_Organisation.Name,
p.Title,
p.Firstname,
p.Lastname,
Role,
p.Email,
p.Telephone,
p.OrgAddress1,
p.OrgAddress2,
p.OrgAddress3,
p.OrgPostcode
};
CSVExport.GenericExport(dataset.ToArray(), "org-contacts");
}
public IExport Create(string exportFormat)
{
IExport export;
_log.Info("Selected export format - " + exportFormat);
switch (exportFormat)
{
case "csv":
_log.Debug("Create CSVExport");
export = new CSVExport(_log);
break;
case "xlsx":
_log.Debug("Create CSVExport");
export = new ExcelExport(_log);
break;
default:
_log.Warn("Wrong exportFormat, select CSVExport");
export = new CSVExport(_log);
break;
}
return(export);
}
public void FilenameEndsWithCSV()
{
var filename = CSVExport.GenerateFilename("option");
Assert.Contains("option", filename);
Assert.EndsWith("csv", filename);
}
public override async Task <ExportResponse> Handle(Query request, CancellationToken cancellationToken)
{
var stocks = await _storage.GetStocks(request.UserId);
var filename = CSVExport.GenerateFilename("stocks");
return(new ExportResponse(filename, CSVExport.Generate(stocks)));
}
public override async Task <ExportResponse> Handle(Query query, CancellationToken cancellationToken)
{
var notes = await _storage.GetNotes(query.UserId);
var filename = CSVExport.GenerateFilename("notes");
return(new ExportResponse(filename, CSVExport.Generate(notes)));
}
public override async Task <ExportResponse> Handle(Query request, CancellationToken cancellationToken)
{
var alerts = await _alertsStorage.GetAlerts(request.UserId);
var filename = CSVExport.GenerateFilename("alerts");
return(new ExportResponse(filename, CSVExport.Generate(alerts.Where(a => a.PricePoints.Count > 0))));
}
protected void btnExportAudit_Click(object sender, EventArgs e)
{
var members = from p in db.CRM_AnnualPasses
where p.StartDate <= endDate
where p.ExpiryDate >= startDate
where !p.IsArchived
select p;
CSVExport.MemberAudit(members, Response);
}
public void ExportNotes()
{
var note = new Note(Guid.NewGuid(), "my note", "stockticker", DateTimeOffset.UtcNow);
var report = CSVExport.Generate(new[] { note });
Assert.Contains(CSVExport.NOTE_HEADER, report);
Assert.Contains(note.State.RelatedToTicker, report);
Assert.Contains("my note", report);
}
public IActionResult CSVExport([FromBody] CSVExport csvExp)
{
using (TextWriter writer = new StreamWriter($"output\\{csvExp.Name}.csv", false, Encoding.UTF8))
{
var csv = new CsvWriter(writer);
csv.Configuration.Delimiter = ";";
csv.WriteRecords(csvExp.Features);
}
return(NoContent());
}
public static void ExportCSV <TBody, TBodyList>(string configFile, string tableId, string exportId, Stream targetStream, TBodyList tList,
DataValidatingHandler <TBody, TBodyList> dataValidater = null, GetValueHandler <TBody> getValueCallback = null)
where TBody : class
where TBodyList : class
{
CSVExport <TBody, TBodyList> export = CreateCSVExport <TBody, TBodyList>(configFile, tableId, exportId, dataValidater, getValueCallback);
export.Export(targetStream, tList);
export.Dispose();
}
public void ExportStocksHeader()
{
var stock = new OwnedStock("tsla", Guid.NewGuid());
stock.Purchase(1, 100, DateTime.UtcNow, "some note");
var report = CSVExport.Generate(new[] { stock });
Assert.Contains(CSVExport.STOCK_HEADER, report);
Assert.Contains("TSLA", report);
}
/// <summary>
/// 保存文件到path，可能是源文件也可能是其他文件
/// </summary>
/// <param name="path"></param>
/// <returns保存是否成功></returns>
public bool SaveFile(string path)
{
SaveLayout();
DataGridViewConsoleForm.Level verifyLevel = VerifySelfAndShowConsole("保存文件");
bool canSave = false;
if (verifyLevel == DataGridViewConsoleForm.Level.Info)
{
canSave = true;
}
else if (verifyLevel == DataGridViewConsoleForm.Level.Warning)
{
if (MessageBox.Show("您现在有Warning，确定存储吗?", "提示", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
canSave = true;
}
}
if (canSave)
{
// 保存文件
CSVExport myExport = new CSVExport(",", false);
try
{
for (int rowIdx = 0; rowIdx < m_DataTable.Rows.Count; rowIdx++)
{
myExport.AddRow();
DataRow dataRow = m_DataTable.Rows[rowIdx];
for (int colIdx = 0; colIdx < m_DataTable.Columns.Count; colIdx++)
{
string value = (string)dataRow[colIdx];
myExport[colIdx.ToString()] = value;
}
}
myExport.ExportToFile(path);
}
catch (Exception ex)
{
DebugUtility.ShowExceptionMessageBox(string.Format("保存文件({0})失败", path), ex);
return(false);
}
return(true);
}
else
{
MessageBox.Show(string.Format("保存文件({0})失败", path), "提示");
return(false);
}
}
public override async Task <ExportResponse> Handle(Query request, CancellationToken cancellationToken)
{
var stocks = await _storage.GetStocks(request.UserId);
var open = stocks
.Where(s => s.State.Owned > 0)
.Select(s => new OwnedStockView(s))
.OrderByDescending(s => s.Cost);
var filename = CSVExport.GenerateFilename("openstocks");
return(new ExportResponse(filename, CSVExport.Generate(open)));
}
public void ExportCryptos()
{
var crypto = new OwnedCrypto("btc", Guid.NewGuid());
crypto.Purchase(quantity: 1.2m, dollarAmountSpent: 200, date: DateTimeOffset.UtcNow);
crypto.Sell(quantity: 0.2m, dollarAmountReceived: 100, date: DateTimeOffset.UtcNow);
var report = CSVExport.Generate(new[] { crypto });
Assert.Contains(CSVExport.CRYPTOS_HEADER, report);
Assert.Contains("BTC", report);
Assert.Contains("buy", report);
Assert.Contains("sell", report);
}
public override async Task<ExportResponse> Handle(Query request, CancellationToken cancellationToken)
{
var stocks = await _storage.GetStocks(request.UserId);
var closedTransactions = stocks
.SelectMany(s => s.State.Transactions.Where(t => t.IsPL))
.Select(t => new StockTransactionView(t))
.OrderByDescending(p => p.Date)
.ToList();
var filename = CSVExport.GenerateFilename("closedstocks");
return new ExportResponse(filename, CSVExport.Generate(closedTransactions));
}
public override async Task <ExportResponse> Handle(Query request, CancellationToken cancellationToken)
{
var stocks = await _storage.GetStocks(request.UserId);
var trades = stocks
.SelectMany(s => s.State.PositionInstances)
.Where(p => p.IsClosed)
.Select(p => new StockTradeView(p))
.OrderByDescending(p => p.Closed)
.ToList();
var filename = CSVExport.GenerateFilename("closedstocks");
return(new ExportResponse(filename, CSVExport.Generate(trades)));
}
protected void btnExportByInterest_Click(object sender, EventArgs e)
{
//var dataset = from p in db.CRM_Persons
// where !p.IsArchived
// let Responses = db.CRM_FormFieldResponses.Where(r => r.TargetReference == p.Reference && r.CRM_FormFieldID == 1)
// select new ExportByInterestHelper{
// Person = p,
// Responses = Responses
// };
//List<CRM_FormFieldItem> items = db.CRM_FormFieldItems.Where(r => r.CRM_FormFieldID == 1).ToList(); // Constituents
//CSVExport.ContactsByInterest(dataset.ToList(), items, Response);
var dataset = from p in db.CRM_Persons
where db.CRM_FormFieldResponses.Any(r =>
r.CRM_FormFieldItemID != null && ddlInterest.SelectedValue == ((int)r.CRM_FormFieldItemID).ToString() &&
r.TargetReference == p.Reference)
let constituentOutput = p.ConstituentTypeOutput(db, " ")
where !p.IsArchived
select new
{
p.Title,
p.Firstname,
p.Lastname,
p.IsAnnualPassHolder,
p.PrimaryEmail,
p.CalculatedSalutation,
p.PrimaryAddressLine1,
p.PrimaryAddressLine2,
p.PrimaryAddressLine3,
p.PrimaryAddressLine4,
p.PrimaryAddressLine5,
p.PrimaryAddressTown,
p.PrimaryAddressCounty,
p.PrimaryAddressPostcode,
p.PrimaryAddressCountry,
p.NextExpiryDate,
p.IsDoNotEmail,
p.IsDoNotMail,
constituentOutput
};
CSVExport.GenericExport(dataset.ToArray(), "byinterest-contacts");
}
public async Task <ExportResponse> Handle(Users.Export request, CancellationToken cancellationToken)
{
var pairs = await _storage.GetUserEmailIdPairs();
var users = new List <User>();
foreach (var(email, userId) in pairs)
{
var guid = new System.Guid(userId);
var user = await _storage.GetUser(guid);
users.Add(user);
}
var filename = CSVExport.GenerateFilename("users");
return(new ExportResponse(filename, CSVExport.Generate(users)));
}
/// <summary>
/// Initializes a new instance of the <see cref="SerializerCSV{T}"/> class.
/// </summary>
public SerializerCSV()
{
this.PropertyValueConverters = typeof(T).GetProperties().Select(x =>
{
if (x.PropertyType == typeof(DateTime))
{
return(Tuple.Create(x, (Func <Object, String>)(o => CSVExport.FromDate((DateTime)o))));
}
else if (x.PropertyType == typeof(DateTime?))
{
return(Tuple.Create(x, (Func <Object, String>)(o => CSVExport.FromNullableDate((DateTime?)o))));
}
else
{
return(Tuple.Create(x, (Func <Object, String>)CSVExport.From));
}
}).ToList();
}
public void ExportOptionsHeader()
{
var option = new OwnedOption(
"tlsa",
2.5m,
OptionType.CALL,
DateTimeOffset.UtcNow.AddDays(1),
Guid.NewGuid());
option.Sell(1, 20, DateTimeOffset.UtcNow, "some note");
var report = CSVExport.Generate(new[] { option });
Assert.Contains(CSVExport.OPTION_HEADER, report);
Assert.Contains("TLSA", report);
Assert.Contains("CALL", report);
Assert.Contains("2.5", report);
}
protected override void Done()
{
base.Done();
CSVExport csvExport = Export as CSVExport;
csvExport.Separator = tbSeparator.Text;
if (cbbCodepage.SelectedIndex == 0)
{
csvExport.Encoding = Encoding.Default;
}
else if (cbbCodepage.SelectedIndex == 1)
{
csvExport.Encoding = Encoding.UTF8;
}
else if (cbbCodepage.SelectedIndex == 2)
{
csvExport.Encoding = Encoding.GetEncoding(CultureInfo.CurrentCulture.TextInfo.OEMCodePage);
}
csvExport.DataOnly = cbDataOnly.Checked;
}
public override void Init(ExportBase export)
{
base.Init(export);
CSVExport csvExport = Export as CSVExport;
tbSeparator.Text = csvExport.Separator;
if (csvExport.Encoding == Encoding.Default)
{
cbbCodepage.SelectedIndex = 0;
}
else if (csvExport.Encoding == Encoding.UTF8)
{
cbbCodepage.SelectedIndex = 1;
}
else if (csvExport.Encoding == Encoding.GetEncoding(CultureInfo.CurrentCulture.TextInfo.OEMCodePage))
{
cbbCodepage.SelectedIndex = 2;
}
cbDataOnly.Checked = csvExport.DataOnly;
}
public void RealWC(string casesFilesDir, int maxNumOfDiag, BatchCostEstimator bce)
{
CSVExport myExport = new CSVExport();
List <PhysioCaseInstance> physioCases = new List <PhysioCaseInstance>();
string bceType = bce.Type();
string overhead = bce.Overhead + "";
List <string> files = Directory.GetFiles(casesFilesDir).ToList();
foreach (string file in files)
{
PhysioCaseInstance physioCase = caseParser.ParseCase(file);
if (physioCase != null)
{
physioCases.Add(physioCase);
}
}
foreach (PhysioCaseInstance physioCase in physioCases)
{
if (physioCase.Diagnoses.Count < 2 || (maxNumOfDiag > 0 && physioCase.Diagnoses.Count > maxNumOfDiag))
{
continue;
}
SystemState currSystemState = new SystemState(physioCase.Diagnoses.Components);
currSystemState.Diagnoses = physioCase.Diagnoses; //!! check for bug
double wc = bce.WastedCostUtility(new RepairAction(physioCase.RealDiagnosis.Diag), currSystemState);
myExport.AddRow();
myExport["Objective Function"] = bceType;
myExport["Overhead"] = overhead;
myExport["Observation"] = physioCase.Id;
myExport["RealDiag"] = physioCase.RealDiagnosis;
myExport["RealWC"] = wc;
}
string fileName = "Physiotherapy_RealWC";
if (maxNumOfDiag > 0)
{
fileName += "_maxDiag=" + maxNumOfDiag;
}
fileName += "_" + bceType + "_o=" + overhead;
myExport.ExportToFile(fileName + ".csv");
}
private static CSVExport <TBody, TBodyList> CreateCSVExport <TBody, TBodyList>(string configFile, string tableId, string exportId,
DataValidatingHandler <TBody, TBodyList> dataValidater, GetValueHandler <TBody> getValueCallback)
where TBody : class
where TBodyList : class
{
CSVExport <TBody, TBodyList> export = new CSVExport <TBody, TBodyList>(configFile, tableId);
export.ExportId = exportId;
if (dataValidater != null)
{
export.SourceDataValidating += dataValidater;
}
if (getValueCallback != null)
{
export.GetValueCallback += getValueCallback;
}
return(export);
}
public ActionResult ExportCoursera(string check)
{
string searchCheck = check.Split('^')[0];
string Email = check.Split('^')[1];
string Semester_ID = check.Split('^')[2];
string Campus_ID = check.Split('^')[3];
var students = unitOfWork.Students.GetAll();
if (searchCheck != "1")
{
if (Email != "2")
{
students = students.Where(s => s.Email.Trim().ToUpper().Contains(Email.Trim().ToUpper())).ToList();
}
if (Semester_ID != "3")
{
students = students.Where(s => s.Semester_ID.Trim() == Semester_ID.Trim()).ToList();
}
if (Campus_ID != "4")
{
students = students.Where(s => s.Campus_ID.Trim() == Campus_ID.Trim()).ToList();
}
}
var myExport = new CSVExport();
foreach (var student in students)
{
myExport.AddRow();
myExport["Full Name"] = student.Full_Name;
myExport["Email"] = student.Email;
var subject = unitOfWork.SubjectStudent.getListSubject(student.Roll + "^" + student.Semester_ID).ToString();
myExport["External ID"] = subject + "@" + student.Campus_ID + "-" + student.Roll;
}
return(File(myExport.ExportToBytes(), "text/csv", "Coursera-Invitation.csv"));
}
public ActionResult Export(string check)
{
string searchCheck = check.Split('^')[0];
string Email = check.Split('^')[1];
string Semester_ID = check.Split('^')[2];
string Campus_ID = check.Split('^')[3];
var students = unitOfWork.Students.GetAll();
if (searchCheck != "1")
{
if (Email != "2")
{
students = students.Where(s => s.Email.Trim().ToUpper().Contains(Email.Trim().ToUpper())).ToList();
}
if (Semester_ID != "3")
{
students = students.Where(s => s.Semester_ID.Trim() == Semester_ID.Trim()).ToList();
}
if (Campus_ID != "4")
{
students = students.Where(s => s.Campus_ID.Trim() == Campus_ID.Trim()).ToList();
}
}
var myExport = new CSVExport();
foreach (var student in students)
{
myExport.AddRow();
myExport["Roll Number"] = student.Roll;
myExport["Full Name"] = student.Full_Name;
myExport["Email"] = student.Email;
}
return(File(myExport.ExportToBytes(), "text/csv", "Student.csv"));
}
private void P4_lblExport_Click(object sender, EventArgs e)
{
try
{
string saveFileName = "";
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Filter = "CSV文件(逗号分割)|*.csv|文本文件|*.txt";
saveFileDialog1.Title = "查询日志导出文件";
saveFileDialog1.ShowDialog();
if (String.IsNullOrEmpty(saveFileDialog1.FileName))
{
return;
}
else
{
saveFileName = saveFileDialog1.FileName;
}
List<ClientIPViewModel> exportList = new List<ClientIPViewModel>();
int index = 1;
if (p4_chk_onlyNotMatched.Checked)
{
foreach (var item in _clientIPLogsNotMatched)
{
ClientIPViewModel ipView = new ClientIPViewModel(item);
ipView.SeqNo = index;
exportList.Add(ipView);
index++;
}
}
else
{
foreach (var item in _clientIPLogs)
{
ClientIPViewModel ipView = new ClientIPViewModel(item);
ipView.SeqNo = index;
exportList.Add(ipView);
index++;
}
}
var csvExport = new CSVExport<ClientIPViewModel>(exportList);
Dictionary<string, string> headerNames = new Dictionary<string, string>();
//{ "No.", "查询时间", "录入人", "待验证运营商", "详细地址", "IP", "查询结果", "判断结果" }
headerNames.Add("SeqNo", "No.");
headerNames.Add("QueryDate", "查询时间");
headerNames.Add("Recordor", "录入人");
headerNames.Add("ExpectedISP", "待验证运营商");
headerNames.Add("Address", "详细地址");
headerNames.Add("IP", "IP");
headerNames.Add("RealISP", "查询结果");
headerNames.Add("StatusDisplay", "判断结果");
csvExport.ExportToFile(saveFileName, headerNames);
MessageBox.Show("查询日志已成功导出到 " + saveFileName + "。", "导出成功");
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "错误");
}
}
