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