/// <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);
}