private void GenerateFile(string path, List <List <string> > template) { try { if (!Directory.Exists(Path.GetDirectoryName(path))) { Directory.CreateDirectory(Path.GetDirectoryName(path)); } if (File.Exists(path)) { File.Delete(path); } XlsOrCsvUtil.GenerateStringCsv(path, template); } catch (Exception ex) { string msg = string.Format("\r\n ClassName: {0}\r\n MethodName: {1}\r\n Message: {2}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message); Logger.Log(msg, Logger.LogType.Error); } }
private void GenerateOutputFile(Dictionary <string, List <string> > dicList, string path) { try { if (File.Exists(path)) { File.Delete(path); } if (path.EndsWith(".csv")) { XlsOrCsvUtil.GenerateStringCsv(path, dicList); } else { XlsOrCsvUtil.GenerateXls0rCsv(path, dicList); } AddResult("ReportDiff", path, configObj.OutputFileType.ToString()); } catch (Exception ex) { string msg = string.Format("\r\n ClassName: {0}\r\n MethodName: {1}\r\n Message: {2}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message); Logger.Log(msg, Logger.LogType.Error); } }
private void generateXls(List <Dictionary <string, string> > propsCw, string path) { var dicList = new Dictionary <string, List <string> >(); var listTile = new List <string>() { "Effective Date", "SYMBOL", "DSPLY_NAME", "RIC", "OFFCL_CODE", "EX_SYMBOL", "BCKGRNDPAG", "BCAST_REF", "#INSTMOD_EXPIR_DATE", "#INSTMOD_LONGLINK1", "#INSTMOD_LONGLINK2", "#INSTMOD_MATUR_DATE", "#INSTMOD_OFFC_CODE2", "#INSTMOD_STRIKE_PRC", "#INSTMOD_WNT_RATIO", "#INSTMOD_MNEMONIC", "#INSTMOD_TDN_SYMBOL", "#INSTMOD_LONGLINK3", "EXL_NAME", "Old Chain", "New BCU", "NDA Common Name", "Primary Listing", "Organisation Name DIRNAME", "Issue Date", "First Exercise Date", "Last Exercise Date", "Outstanding Warrant Quantity", "Exercise Period" }; dicList.Add("title", listTile); //foreach (var dic in propsCw) for (int index = 0; index < propsCw.Count; index++) { List <string> listBody = propsCw[index].Values.ToList(); dicList.Add(index.ToString(), listBody); } if (dicList == null || dicList.Count <= 1) { return; } XlsOrCsvUtil.GenerateXls0rCsv(path, dicList); }
private void GenerateBulkFile(string file, Dictionary <string, List <string> > dicList) { if (dicList == null || dicList.Count <= 1) { string msg = string.Format("no column need to generate bulk file."); Logger.Log(msg, Logger.LogType.Info); return; } try { if (!Directory.Exists(outPutPath)) { Directory.CreateDirectory(outPutPath); } if (File.Exists(file)) { File.Delete(file); } } catch (Exception ex) { string msg = string.Format("delete old the file :{0} error. msg:{1}", file, ex.ToString()); Logger.Log(msg, Logger.LogType.Error); return; } try { XlsOrCsvUtil.GenerateStringCsv(file, dicList); attacheFileList.Add(file); AddResult("bulk file", file, "CSV Bulk File"); //TaskResultList.Add(new TaskResultEntry(MethodBase.GetCurrentMethod().DeclaringType.FullName.Replace("Ric.Generator.Lib.", ""), "ResultFile", file)); } catch (Exception ex) { string msg = string.Format("generate the file :{0} error. msg:{1}", file, ex.ToString()); Logger.Log(msg, Logger.LogType.Error); } }
private void GenerateOutPutFile(List <TFEXBulkFileTemplate> listTFEX) { List <List <string> > listListOutput = new List <List <string> >(); string path = Path.Combine(configObj.FolderPath, string.Format("TFEX_QA_Add_{0}.csv", configObj.DateOfSource)); try { listListOutput.Add(title); FormateTemplate(listTFEX, listListOutput); XlsOrCsvUtil.GenerateStringCsv(path, listListOutput); AddResult("TFEX_yyy-MM-dd.csv", path, "Bulk file"); } catch (Exception ex) { string msg = string.Format("\r\n ClassName: {0}\r\n MethodName: {1}\r\n Message: {2}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message); Logger.Log(msg, Logger.LogType.Error); } }
private void StartExtract2() { List <List <string> > bulkFileFilter = null; List <LineFound> bulkFile = null; pdftron.PDFNet.Initialize("Reuters Technology China Ltd.(thomsonreuters.com):CPU:1::W:AMC(20121010):AD5EE33F2505D1CAF1B425461F9C92BAA89204FA0AD8AAA17E07887EF0FA"); PDFDoc doc = new PDFDoc(config.FilePath2); doc.InitSecurityHandler(); string patternTitle = @"コード"; int page = 5; PdfString ricPosition = GetRicPosition(doc, patternTitle, page); if (ricPosition == null) { return; } ricPosition.Position.x1 = 106.8; ricPosition.Position.x2 = 99.12; ricPosition.Position.y1 = 29.5105; ricPosition.Position.y2 = 44.8734; string patternRic = @"\d{4}"; //string patternValue = @"\-?(\,\.\d)*"; string patternValue = @"(\-|\+)?\d+(\,|\.|\d)+"; bulkFile = GetValue(doc, ricPosition, patternRic, patternValue); int indexOK = 0; bulkFileFilter = FilterBulkFile(bulkFile, indexOK); string filePath = Path.Combine(config.OutputFolder, string.Format("{0}.csv", Path.GetFileNameWithoutExtension(config.FilePath2))); if (File.Exists(filePath)) { File.Delete(filePath); } XlsOrCsvUtil.GenerateStringCsv(filePath, bulkFileFilter); AddResult(Path.GetFileNameWithoutExtension(filePath), filePath, "type2"); }
private void GenerateOutputFile(Dictionary <string, List <string> > dicList, string path) { try { try { if (File.Exists(path)) { File.Delete(path); } } catch (Exception ex) { Logger.Log(string.Format("delete alerday exist file: {0} error.msg:{1}", path, ex.Message), Logger.LogType.Error); } if (path.ToLower().EndsWith(".xls") || path.ToLower().EndsWith(".xlsx")) { XlsOrCsvUtil.GenerateXls0rCsv(path, dicList); } else if (path.ToLower().EndsWith(".csv")) { XlsOrCsvUtil.GenerateStringCsv(path, dicList); } else { MessageBox.Show("Output path must be end with .xls(x) or .csv"); } } catch (Exception ex) { string msg = string.Format("\r\n ClassName: {0}\r\n MethodName: {1}\r\n Message: {2}", System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString(), System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message); Logger.Log(msg, Logger.LogType.Error); } }
protected override void Start() { try { int i = 1; var propsPc = new List <Dictionary <string, string> >(); foreach (Dictionary <string, string> infos in GetPages().Select(page => CleanInfos(GetInfos(page))) .Where(infos => infos != null) .Where(infos => infos["subject"] == "Adjustment")) { propsPc.Add(infos); i++; } if (i > 1) { string path = string.Format("{0}Price_Change_{1}.xlsx", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM")); List <string> title = new List <string>() { "RIC", "Symbol", "ISIN", "OLD_RATIO", "#INSTMOD_WNT_RATIO", "OLD_PRC", "#INSTMOD_STRIKE_PRC" }; List <List <string> > bulkFile = new List <List <string> >(); bulkFile.Add(title); FillInBulkFile(bulkFile, propsPc); XlsOrCsvUtil.GenerateXls0rCsv(path, bulkFile); AddResult(Path.GetFileNameWithoutExtension(path), path, ""); //var ndaDw1 = new Nda(FileMode.WriteOnly); //ndaDw1.LoadFromTemplate(TemplateFm.ThPriceChange, propsPc); //ndaDw1.Save(String.Format("{0}Price_Change_{1}.xlsx", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM"))); //AddResult("Price change Nda bulk file", ndaDw1.Path, "nda"); } } catch (Exception ex) { throw new Exception("Task failed, error: " + ex.Message, ex); } }