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, "错误"); } }