private void GenerateFm2()
{
string where = String.Format("WHERE Type ='FM2' AND CONVERT(VARCHAR(25), InsertDbDate , 126) LIKE '{0}%'", DateTime.Now.AddDays(-9).ToString("yyyy-MM-dd"));
var nda1 = new Nda();
var fm2 = ManagerBase.Select(tableName, new string[] { "*" }, where);
foreach (DataRow row in fm2.Rows)
{
Dictionary <string, string> newInfos = new Dictionary <string, string>
{
{ "englishname", row["EnglishName"].ToString() },
{ "fullname", row["FullName"].ToString() },
{ "shortname", row["ShortName"].ToString() },
{ "price", row["Price"].ToString() },
{ "listingshares", row["ListingShares"].ToString() },
{ "effectivedate", ((DateTime)row["EffectiveDate"]).ToString("dd-MMM-yyyy") },
{ "offeringdate", row["OfferingDate"].ToString() },
{ "insertdbdate", row["InsertDbDate"].ToString() },
{ "type", row["Type"].ToString() },
{ "code", row["Code"].ToString() },
{ "market", row["Market"].ToString() }
};
newInfos.Add("traditionalname", ChineseConverter.Convert(newInfos["shortname"], ChineseConversionDirection.SimplifiedToTraditional));
nda1.AddProp(newInfos);
}
if (fm2.Rows.Count > 0)
{
nda1.GenerateAndSave("CnIaAddFutDat", String.Format("{0}IaAddFutDat_{1}.csv", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM")));
nda1.GenerateAndSave("CnLotAdd", String.Format("{0}LotAdd_{1}.csv", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM")));
nda1.GenerateAndSave("CnQaAddFutDat", String.Format("{0}QaAddFutDat_{1}.csv", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM")));
nda1.GenerateAndSave("CnQaChgFtd", String.Format("{0}QaChgFtd_{1}.csv", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM")));
nda1.GenerateAndSave("CnTickAdd", String.Format("{0}TickAdd_{1}.csv", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM")));
}
}
protected override void Start()
{
var datas = new List <Dictionary <string, string> >();
var ordNda = new Nda(FileMode.WriteOnly);
var ordIdn = new Idn(FileMode.WriteOnly);
try
{
SetTemplates();
datas.AddRange(_configObj.Rics.Select(GetData));
ordIdn.LoadFromTemplate(_ordIdn, datas);
ordIdn.Save(Path.Combine(_configObj.WorkingDir, String.Format("IdnAdd{0}.txt", _configObj.Market)));
AddResult("Idn Add file", ordIdn.Path, "idn");
ordNda.LoadFromTemplate(_ordNda, datas);
ordNda.Save(Path.Combine(_configObj.WorkingDir, String.Format("NdaAdd{0}.csv", _configObj.Market)));
AddResult("Nda Add file", ordNda.Path, "nda");
}
catch (Exception ex)
{
LogMessage("Task failed, error: " + ex.Message, Logger.LogType.Error);
throw new Exception("Task failed, error: " + ex.Message, ex);
}
finally
{
}
}
protected override void Start()
{
List <string> rics = configObj.Rics;
try
{
dplyNames = QueryGats(PrepareRicsForGats(rics));
var bulkFile = new Nda();
foreach (string ric in rics)
{
var infosRic = GenerateFm(ric);
if (infosRic != null)
{
bulkFile.AddProp(infosRic);
}
}
if (bulkFile.format.Prop.Length > 0)
{
//remove the "\r\n" in the last line in the file end
bulkFile.GenerateAndSave("TwIdnCb", String.Format("{0}TwIdnCb_{1}.txt", configObj.WorkingDir, DateTime.Now.ToString("ddMM")));
//bulkFile.GenerateAndSave("TwCbBulk", String.Format("{0}TwCbBulk_{1}.csv", configObj.WorkingDir, DateTime.Now.ToString("ddMM")));
RemoveEndLineStr(String.Format("{0}TwIdnCb_{1}.txt", configObj.WorkingDir, DateTime.Now.ToString("ddMM")));
//TaskResultList.Add(new TaskResultEntry("bulk file", "", String.Format("{0}TwIdnCb_{1}.txt", configObj.WorkingDir, DateTime.Now.ToString("ddMM"))));
//TaskResultList.Add(new TaskResultEntry("bulk file", "", String.Format("{0}TwCbBulk_{1}.csv", configObj.WorkingDir, DateTime.Now.ToString("ddMM"))));
AddResult("bulk file1", String.Format("{0}TwIdnCb_{1}.txt", configObj.WorkingDir, DateTime.Now.ToString("ddMM")), "");
//AddResult("bulk file2", String.Format("{0}TwCbBulk_{1}.csv", configObj.WorkingDir, DateTime.Now.ToString("ddMM")), "");
}
}
catch (Exception ex)
{
Logger.Log("Task failed, error: " + ex.Message, Logger.LogType.Error);
throw new Exception("Task failed, error: " + ex.Message, ex);
}
}
protected override void Start()
{
Thread.Sleep(2000);
var props = new List <Dictionary <string, string> >
{
new Dictionary <string, string>
{
{ "ric", "12345" },
{ "commonname", "first company" }
},
new Dictionary <string, string>
{
{ "ric", "33322" },
{ "commonname", "other company" }
}
};
var myNda = new Nda();
LogMessage("create nda from template");
myNda.Load(@"C:\Users\websiting\Documents\ricpresentation\nda.csv");
Thread.Sleep(2000);
//myNda.Content[0].
//LogMessage("save nda in : " + configObj.ExcelName);
//LogMessage("task done");
}
protected override void Start()
{
var datas = new Dictionary <string, string>();
var cleanData = new List <Dictionary <string, string> >();
var ordNda = new Nda(FileMode.WriteOnly);
var ordQuoteFuture = new Nda(FileMode.WriteOnly);
var ordIssueFuture = new Nda(FileMode.WriteOnly);
var ordFm = new Fm();
var ordIdn = new Idn(FileMode.WriteOnly);
try
{
SetTemplates();
foreach (var ric in _configObj.Rics)
{
datas = GetInfos(ric.Trim());
cleanData.Add(CleanData(datas));
}
ordIssueFuture.LoadFromTemplate(_ordIssueFuture, cleanData);
ordIssueFuture.Save(Path.Combine(_configObj.WorkingDir, String.Format("IssueFutureAdd{0}.csv", _configObj.Market)));
AddResult("Issue Future Add file", ordIssueFuture.Path, "nda");
ordIdn.LoadFromTemplate(_ordIdn, cleanData);
ordIdn.Save(Path.Combine(_configObj.WorkingDir, String.Format("IdnAdd{0}.txt", _configObj.Market)));
AddResult("Idn Add file", ordIdn.Path, "idn");
ordNda.LoadFromTemplate(_ordNda, cleanData);
ordNda.Save(Path.Combine(_configObj.WorkingDir, String.Format("NdaAdd{0}.csv", _configObj.Market)));
AddResult("Nda Add file", ordNda.Path, "nda");
ordQuoteFuture.LoadFromTemplate(_ordQuoteFuture, cleanData);
ordQuoteFuture.Save(Path.Combine(_configObj.WorkingDir, String.Format("QuoteFutureAdd{0}.csv", _configObj.Market)));
AddResult("Quote Future Add file", ordQuoteFuture.Path, "nda");
ordFm.LoadFromTemplate(_ordFm, cleanData);
ordFm.Save(Path.Combine(_configObj.WorkingDir, String.Format("Fm{0}.txt", _configObj.Market)));
AddResult("Fm file", ordFm.Path, "fm");
}
catch (Exception ex)
{
LogMessage("Task failed, error: " + ex.Message, Logger.LogType.Error);
throw new Exception("Task failed, error: " + ex.Message, ex);
}
finally
{
}
}
protected override void Start()
{
Thread.Sleep(2000);
LogMessage("task start");
var props = new List <Dictionary <string, string> >
{
new Dictionary <string, string>
{
{ "ric", "12345" },
{ "commonname", "first company" }
},
new Dictionary <string, string>
{
{ "ric", "33322" },
{ "commonname", "other company" }
}
};
var myNda = new Nda();
var test = typeof(Nda);
LogMessage("Load nda from File");
myNda.Load(@"C:\Users\websiting\Documents\ricpresentation\result.xls");
myNda.Save(@"C:\Users\websiting\Documents\ricpresentation\result4.xls");
Thread.Sleep(2000);
//LogMessage("the first ric is : " + myNda.Content[0].Ric);
////foreach (NdaEntry testentry in myNda)
////{
//// var commoname = testentry.AssetCommonName;
////}
//var test42 = from NdaEntry entry in myNda
// where entry.Ric == "ORD"
// select entry;
//LogMessage("[DYNAMIC]the first ric is : " + myNda.DynamicContent[0].RIC);
LogMessage("task done");
}
private void GenerateFm1()
{
string where = String.Format("WHERE Type ='FM1' AND CONVERT(VARCHAR(25), InsertDbDate , 126) LIKE '{0}%'", DateTime.Now.AddDays(-9).ToString("yyyy-MM-dd"));
var ndaSh = new Nda();
var ndaSz = new Nda();
var ndaSz0 = new Nda();
var ndaSz2 = new Nda();
var ndaSz3 = new Nda();
var fm1 = ManagerBase.Select(tableName, new string[] { "*" }, where);
foreach (DataRow row in fm1.Rows)
{
Dictionary <string, string> newInfos = new Dictionary <string, string>
{
{ "englishname", row["EnglishName"].ToString() },
{ "fullname", row["FullName"].ToString() },
{ "shortname", row["ShortName"].ToString() },
{ "price", row["Price"].ToString() },
{ "listingshares", row["ListingShares"].ToString() },
{ "effectivedate", ((DateTime)row["EffectiveDate"]).ToString("dd-MMM-yyyy") },
{ "offeringdate", row["OfferingDate"].ToString() },
{ "insertdbdate", row["InsertDbDate"].ToString() },
{ "type", row["Type"].ToString() },
{ "code", row["Code"].ToString() },
{ "market", row["Market"].ToString() }
};
newInfos.Add("traditionalname", ChineseConverter.Convert(newInfos["shortname"], ChineseConversionDirection.SimplifiedToTraditional));
if (newInfos["market"] == "Shanghai")
{
if (newInfos["code"].EndsWith("5") || newInfos["code"].EndsWith("7") || newInfos["code"].EndsWith("9"))
{
newInfos.Add("exlname", "SSE_EQB_CNY_ARIC3");
}
else if (newInfos["code"].EndsWith("4") || newInfos["code"].EndsWith("6") || newInfos["code"].EndsWith("8"))
{
newInfos.Add("exlname", "SSE_EQB_CNY_EVEN");
}
else
{
newInfos.Add("exlname", "SSE_EQB_CNY_ODD");
}
ndaSh.AddProp(newInfos);
}
else
{
if (newInfos["code"].StartsWith("000"))
{
ndaSz0.AddProp(newInfos);
}
else if (newInfos["code"].StartsWith("002"))
{
ndaSz2.AddProp(newInfos);
}
else
{
ndaSz3.AddProp(newInfos);
}
ndaSz.AddProp(newInfos);
}
}
if (ndaSh.format.Prop.Length > 0)
{
ndaSh.GenerateAndSave("CnQaAddCNord3", String.Format("{0}SH_QaAddCNord3_{1}.csv", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM")));
ndaSh.GenerateAndSave("CnQaChg", String.Format("{0}SH_Chg_{1}.csv", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM")));
ndaSh.GenerateAndSave("CnBgChg", String.Format("{0}SH_BgChg_{1}.csv", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM")));
ndaSh.GenerateAndSave("CnIdnAddSS", String.Format("{0}SH_IdnAddSS_{1}.txt", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM")));
}
if (ndaSz.format.Prop.Length > 0)
{
ndaSz.GenerateAndSave("CnQaChg", String.Format("{0}SZ_Chg_{1}.csv", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM")));
ndaSz.GenerateAndSave("CnBgChg", String.Format("{0}SZ_BgChg_{1}.csv", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM")));
ndaSz.GenerateAndSave("CnIdnAddSZ", String.Format("{0}SZ_IdnAddSZ_{1}.txt", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM")));
}
if (ndaSz0.format.Prop.Length > 0)
{
ndaSz.GenerateAndSave("CnQaAddCNord4", String.Format("{0}SZ_QaAddCNord4_{1}.csv", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM")));
}
if (ndaSz2.format.Prop.Length > 0)
{
ndaSz.GenerateAndSave("CnQaAddCNord2", String.Format("{0}SZ_QaAddCNord2_{1}.csv", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM")));
}
if (ndaSz3.format.Prop.Length > 0)
{
ndaSz.GenerateAndSave("CnQaAddCNord", String.Format("{0}SZ_QaAddCNord_{1}.csv", configObj.ResultFolderPath, DateTime.Now.ToString("ddMM")));
}
}
