/// <summary>
/// 将csv文件导入数据库(不推荐使用)
/// </summary>
/// <param name="code">证券代码</param>
/// <param name="name">证券名称</param>
/// <param name="csvPath">csv文件路径</param>
/// <returns>受影响行数</returns>
public int ImportFromCSVAsDB(string code, string name, string csvPath)
{
DataTable dt = CSVUtility.ReadCSVAsDB(csvPath);
if (dt == null)
{
return(0);
}
else
{
int insertedLinesCount = 0;
foreach (DataRow row in dt.Rows)
{
StockDayPrice stock1 = new StockDayPrice();
stock1.Code = code;
stock1.Name = name;
stock1.Date = (DateTime)row["Date"];
stock1.Open = (double)row["Open"];
stock1.High = (double)row["High"];
stock1.Low = (double)row["Low"];
stock1.Close = (double)row["Close"];
stock1.Volume = Convert.ToDouble(row["Volume"]);//(double)会报错Specified cast is not valid.奇怪！！！超过int范围时row["Volume"]为DBNull
stock1.AdjClose = (double)row["Adj Close"];
int j = this.AddNew(stock1);
insertedLinesCount += j;
}
return(insertedLinesCount);
}
}