static void Main(string[] args) { Tearsheet ts = new Tearsheet(); //string outputAddress = args[0]; //int UpdateType = Convert.ToInt16(args[1]); //QueryManager qm = new QueryManager(outputAddress); //switch (UpdateType) //{ // case 0: // string[] DealList = args[2].Split(','); // qm.AddBonds(DateTime.Today, DealList); // break; // case 1: // qm.CurrentPortfolioBehindScene(DateTime.Today); // break; // default: // break; //} }
public void DoSomeWork(Tearsheet ts, DateTime _AsOfDate) { // Variable declaration List <string> DealList = new List <string>(); List <List <string> > queryResult; AsOfDate = _AsOfDate; // Initialization ReadInQueries(); queryResult = ConnectDB.ReadDB(2, string.Format("SELECT `CDONETNAME`,`LABEL`,SUM(`NOTIONAL`) AS `FACE` FROM GHIF_HOLDINGS " + "WHERE `PURCHASEDATE` <= '{0}' GROUP BY `CDONETNAME` HAVING SUM(`NOTIONAL`) > 0", AsOfDate.ToString("yyyy-MM-dd"))); foreach (List <string> iRow in queryResult) { DealList.Add(string.Format("{0}.{1}", iRow[0], iRow[1])); } ProcessQueries_MultipleDeals(DealList.ToArray(), 1); CleanUp(); ts.SetDataSource(MasterTable); }