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