/// <summary> /// create Put A07 File /// </summary> /// <param name="type"></param> /// <param name="dateTime"></param> public bool create(TableType type, string dateTime) { bool flag = false; try { List <string> data = new List <string>(); SetFile f = new SetFile(type, dateTime); //ex: GetA07_20170908.csv string getFileName = f.getFileName(); //string getFileName = f.getGZFileName(); DateTime dt = DateTime.Now; DateTime dt2 = dt.AddMonths(-18); #region File data.Add("START-OF-FILE"); #region Title data.Add("FIRMNAME=" + f.getFIRMNAME()); data.Add("PROGRAMFLAG=" + f.getPROGRAMFLAG()); data.Add("FILETYPE=pc"); data.Add($"REPLYFILENAME={getFileName}"); data.Add($"DATERANGE={dt2.ToString("yyyyMMdd")}|{dt.ToString("yyyyMMdd")}"); data.Add("HIST_PERIOD=q"); data.Add("PROGRAMNAME=gethistory"); #endregion Title //空一行 data.Add(string.Empty); data.Add("# Automatically generated by Bloomberg Data License Request Builder version 7.0.1"); data.Add("# Build Code: 000000000000000148"); //空一行 data.Add(string.Empty); #region START-OF-FIELDS data.Add("START-OF-FIELDS"); data.Add("NAME"); data.Add("PX_LAST"); data.Add("LAST_UPDATE_DT"); data.Add("END-OF-FIELDS"); #endregion START-OF-FIELDS //空一行 data.Add(string.Empty); #region START-OF-DATA data.Add("START-OF-DATA"); new Econ_Domestic().GetType().GetProperties() .Skip(2).ToList().ForEach(x => { if (x.Name == "SINYI_HOUSE_PRICE_index" || x.Name == "CATHAY_ESTATE_index" || x.Name == "Real_GDP2011") { data.Add(x.Name); } else if (x.Name != "Econ_D_YYYYMMDD") { data.Add(x.Name.Replace("_", " ")); } }); data.Add("END-OF-DATA"); #endregion START-OF-DATA data.Add("END-OF-FILE"); #endregion File flag = new CreatePutFile().create( f.putA07FilePath(), f.putFileName(), data); } catch { flag = false; } return(flag); }
/// <summary> /// create Put Sample File /// </summary> /// <param name="dateTime"></param> public bool create(string dateTime) { bool flag = false; try { List <string> data = new List <string>(); SetFile f = new SetFile(TableType.C04, dateTime); //ex: GetC04_20170803.csv string getFileName = f.getFileName(); DateTime dt = DateTime.Now; DateTime dt2 = dt.AddMonths(-18); #region File data.Add("START-OF-FILE"); #region Title data.Add($"REPLYFILENAME={getFileName}"); data.Add("FILETYPE=pc"); data.Add("PROGRAMFLAG=" + f.getPROGRAMFLAG()); data.Add("FIRMNAME=" + f.getFIRMNAME()); data.Add($"DATERANGE={dt2.ToString("yyyyMMdd")}|{dt.ToString("yyyyMMdd")}"); data.Add("HIST_PERIOD=q"); data.Add("PROGRAMNAME=gethistory"); #endregion Title //空一行 data.Add(string.Empty); #region START-OF-FIELDS data.Add("START-OF-FIELDS"); data.Add("NAME"); data.Add("PX_LAST"); data.Add("LAST_UPDATE_DT"); data.Add("END-OF-FIELDS"); #endregion START-OF-FIELDS //空一行 data.Add(string.Empty); #region START-OF-DATA data.Add("START-OF-DATA"); new Econ_Foreign().GetType().GetProperties() .Skip(2).ToList().ForEach(x => { if (x.Name == "CNFRBAL_Index") //貿易收支 傳送要加$ { data.Add(x.Name.Replace("_", "$ ")); } else { data.Add(x.Name.Replace("_", " ")); } }); data.Add("END-OF-DATA"); #endregion START-OF-DATA data.Add("END-OF-FILE"); #endregion File //建立 req 檔案 flag = new CreatePutFile().create( f.putC04FilePath(), f.putFileName(), data); } catch { flag = false; } return(flag); }