public static void ImportFileByReaderOld(string sid, string date, TextReader reader) { //string sid = file.Substring(file.LastIndexOf("\\") + 1); StockLog.Log.Debug(sid + " start "); DateTime beginning = DateTime.Now; BizApi.CreateDataTable(sid); string file = sid + "_" + date; try { //decimal weight = BizApi.QueryWeight(sid); decimal[] extractlist = BizApi.QueryExtractList(sid); DateTime lastupdate = BizApi.QueryExtractLastUpdate(sid); List <BasicData> list = ReadCsvByReader(sid, date, reader, extractlist, lastupdate); foreach (BasicData bd in list) { //Console.WriteLine(bd.time+" "+bd.sellshare); BizApi.InsertBasicData(bd); } TimeSpan end = DateTime.Now - beginning; StockLog.Log.Debug(file + " complete at " + end); } catch { StockLog.Log.Error(file + " import fail"); } }
public static void DownloadSingle(string sid) { string startDate = BizApi.QueryExtractLastUpdate(sid).AddDays(1).ToString("yyyy-MM-dd"); string endDate = StockUtil.FormatDate(DateTime.Now); DataDownload.DownloadDataToCsvByReader(sid, startDate, endDate); if (!Constant.CLEAN) { StockUtil.UpdateDownloadTimeStamp(sid, endDate); } StockLog.Log.Info(sid + " updated " + startDate + " " + endDate); }
public static void Main(string[] args) { // BizData.QueryByWeek("sz000830", 500, new DateTime(2015, 1, 1), new DateTime(2015, 3, 3)); //List<BasicData> list = ImportRawData.ReadCsvFolder(@"D:\workspace\myproject\sz000830", 2000); //foreach (BasicData bd in list) //{ // //Console.WriteLine(bd.time+" "+bd.sellshare); // BizData.InsertTable(bd); //} IList <BasicData> list = BizApi.QueryByWeek("sz000830", 2000, new DateTime(2014, 7, 1), new DateTime(2014, 12, 12));; Console.WriteLine(BizApi.QueryExtractLastUpdate("sz000830")); }
public static void ImportFileByReader(string sid, string date, TextReader reader) { //string sid = file.Substring(file.LastIndexOf("\\") + 1); StockLog.Log.Debug(sid + " start "); DateTime beginning = DateTime.Now; //BizApi.CreateDataTable(sid); //try //{ //decimal weight = BizApi.QueryWeight(sid); decimal[] ext_list = BizApi.QueryExtractList(sid); decimal[] extractlist = new decimal[ext_list.Length + 1]; for (int i = 0; i < ext_list.Length; i++) { extractlist[i] = ext_list[i]; } extractlist[ext_list.Length] = 0; //decimal[] extractlist = new decimal[4]; //extractlist[0] = 0; //extractlist[1] = 500; //extractlist[2] = 1000; //extractlist[3] = 2000; try { if (sid == "sh600048") { StockLog.Log.Debug(sid + " complete at "); } DateTime lastupdate = BizApi.QueryExtractLastUpdate(sid); List <BasicData> list = ReadCsvByReader(sid, date, reader, extractlist, lastupdate); foreach (BasicData bd in list) { BizApi.InsertBasicData(bd); } TimeSpan end = DateTime.Now - beginning; StockLog.Log.Debug(sid + " complete at " + end); } catch (Exception e) { StockLog.Log.Error(sid + " import fail"); } }
public string QueryLastUpdate(string id) { return(BizCommon.ParseToString(BizApi.QueryExtractLastUpdate(id))); }