public void GetThreeMonthRevenue(string FilePath, string TableName) { StreamReader sr = new StreamReader(FilePath, System.Text.Encoding.Default); StockDatabase data = new StockDatabase(); string line; string [] temp; float[] tempData;//每筆(整列)資料佔存 if (!sr.EndOfStream) { line = sr.ReadLine(); temp = line.Split(','); string[] tempp = new string[temp.Length - 1]; for (int i = 1; i < temp.Length; i++) { tempp[i - 1] = temp[i]; } #region try creatTable try { CreatTable(TableName, tempp); } catch (Exception ee) { Console.WriteLine(ee.Message); } #endregion } else { return; } int ss; while (!sr.EndOfStream) { nonqueryCommand.CommandText = @"use StockDatabase"; Console.WriteLine(nonqueryCommand.CommandText); nonqueryCommand.ExecuteNonQuery(); line = sr.ReadLine(); temp = line.Split(','); if (temp[0].CompareTo(" ") == 0 || temp[0].CompareTo("") == 0) { break; } tempData = new float[temp.Length - 1]; for (int i = 1; i < temp.Length; i++) { try { if (temp[i].CompareTo("-") == 0) { tempData[i - 1] = 0; } else if (temp[i].CompareTo("") == 0) { tempData[i - 1] = 0; } else if (temp[i].CompareTo(" ") == 0) { tempData[i - 1] = 0; } else { tempData[i - 1] = float.Parse(temp[i]); } } catch (Exception ee) { Console.WriteLine(ee.Message); } } data.AddData(temp[0], TableName, tempData);//加入資料 #region TempUseCode//暫時休息 讓CPU不會占用太多資源 // System.Threading.Thread.Sleep(500); #endregion } sr.Close(); sr.Dispose(); }
public static void CreateDatabase(dynamicControlExcelTest.Excel_Use myExcel)//創造新的Table { StockDatabase.myExcel = myExcel; float[] tempData;//每筆(整列)資料佔存 StockDatabase data = new StockDatabase(); for (int k = 0; k < myExcel.mySheet.Length; k++) { myExcel.UsingSheet = k; #region try creatTable try { // data.CreatTable(myExcel.mySheet[k].Name); } catch (Exception ee) { Console.WriteLine(ee.Message); } #endregion tempData = new float[myExcel.CountExcelWidth - 1]; for (int i = 1; i < myExcel.CountExcelHeight; i++) { for (int j = 1; j < myExcel.CountExcelWidth; j++) { string tempp = myExcel.mySheet[k].Cells[i + 1, j + 1].Text; try { if (myExcel.mySheet[k].Cells[i + 1, j + 1].Text.CompareTo("-") == 0) { tempData[j - 1] = 0; } else if (myExcel.mySheet[k].Cells[i + 1, j + 1].Text.CompareTo("") == 0) { tempData[j - 1] = 0; } else if (myExcel.mySheet[k].Cells[i + 1, j + 1].Text.CompareTo(" ") == 0) { tempData[j - 1] = 0; } else { tempData[j - 1] = float.Parse(myExcel.mySheet[k].Cells[i + 1, j + 1].Text); } } catch (Exception e) { Console.WriteLine(e.Message); } } //data.AddData(myExcel.mySheet[k].Cells[i + 1, 1].Text,, tempData);//加入資料 #region TempUseCode//暫時休息 讓CPU不會占用太多資源 System.Threading.Thread.Sleep(500); #endregion } } }