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