protected void BackTest_btn_Click(object sender, System.EventArgs e)
{
Database.MSSQL DB = new Database.MSSQL("web");
List<SqlParameter> PMS = new List<SqlParameter>();
PMS = new List<SqlParameter>();
PMS.Add(new SqlParameter("@tmp", 1));
PMS.Add(new SqlParameter("@tmp_N", 100));
DataTable Time_Temp = DB.QueryStoredProcedure("[Get_Time_N]", PMS.ToArray());
/*for (int i = 1; i < Time_Temp.Rows.Count; i++)
{
Response.Write(Time_Temp.Rows[i][0].ToString() + "<br />");
}*/
DataTable StockTime = DB.QuerySQL("SELECT TOP 20 證券代號 ,收盤價 ,資料日期 FROM Sourcebook WHERE 證券代號 = '1101' ORDEr BY 資料日期 DESC");
}
private void SaveOrInsertSheet_Source(HSSFSheet u_sheet)
{
Database.MSSQL DB = new Database.MSSQL("Web");
List<SqlParameter> PMS = new List<SqlParameter>();
//因為要讀取的資料列不包含標頭，所以i從u_sheet.FirstRowNum + 1開始讀
/*一列一列地讀取資料*/
int Company_check = 0;
for (int i = u_sheet.FirstRowNum + 1; i <= u_sheet.LastRowNum; i++)
{
HSSFRow row = (HSSFRow)u_sheet.GetRow(i);//取得目前的資料列 2015/03/18[新增資料區段]
for (int j = 0; j < Stock_Num.Rows.Count; j++)
{
if (Equals(Stock_Num.Rows[j][0], row.GetCell(0).ToString()))
{
Company_check = 1;
}
}
if (Company_check == 1)
{
PMS = new List<SqlParameter>();
PMS.Add(new SqlParameter("@證券代號", row.GetCell(0).ToString()));
PMS.Add(new SqlParameter("@成交股數", Convert.ToInt32(row.GetCell(2).ToString())));
PMS.Add(new SqlParameter("@成交筆數", Convert.ToInt32(row.GetCell(3).ToString())));
PMS.Add(new SqlParameter("@成交金額", Convert.ToSingle(row.GetCell(4).ToString())));
PMS.Add(new SqlParameter("@開盤價", Convert.ToSingle(row.GetCell(5).ToString())));
PMS.Add(new SqlParameter("@最高價", Convert.ToSingle(row.GetCell(6).ToString())));
PMS.Add(new SqlParameter("@最低價", Convert.ToSingle(row.GetCell(7).ToString())));
PMS.Add(new SqlParameter("@收盤價", Convert.ToSingle(row.GetCell(8).ToString())));
PMS.Add(new SqlParameter("@最後揭示買價", Convert.ToSingle(row.GetCell(11).ToString())));
PMS.Add(new SqlParameter("@最後揭示買量", Convert.ToInt32(row.GetCell(12).ToString())));
PMS.Add(new SqlParameter("@最後揭示賣價", Convert.ToSingle(row.GetCell(13).ToString())));
PMS.Add(new SqlParameter("@最後揭示賣量", Convert.ToInt32(row.GetCell(14).ToString())));
PMS.Add(new SqlParameter("@資料日期", Convert.ToDateTime(DataTime_Source_txt.Text)));
PMS.Add(new SqlParameter("@下載日期", dt));
DB.ExecutionStoredProcedure("[Source_Insert]", PMS.ToArray());
}
Company_check = 0;
}
}
private void SaveOrInsertSheet(HSSFSheet u_sheet)
{
Database.MSSQL DB = new Database.MSSQL("Web");
List<SqlParameter> PMS = new List<SqlParameter>();
//因為要讀取的資料列不包含標頭，所以i從u_sheet.FirstRowNum + 1開始讀
/*一列一列地讀取資料*/
int Company_check = 0;
for (int i = u_sheet.FirstRowNum + 1; i <= u_sheet.LastRowNum; i++)
{
HSSFRow row = (HSSFRow)u_sheet.GetRow(i);//取得目前的資料列 2015/03/18[新增資料區段]
for (int j = 0; j < Stock_Num.Rows.Count; j++ )
{
if (Equals(Stock_Num.Rows[j][0], row.GetCell(0).ToString()))
{
Company_check = 1;
}
}
if (Company_check == 0)
{
PMS = new List<SqlParameter>();
PMS.Add(new SqlParameter("@C_ID", row.GetCell(0).ToString()));
PMS.Add(new SqlParameter("@C_Name", row.GetCell(1).ToString()));
DB.ExecutionStoredProcedure("[GetStockNum_Insert]", PMS.ToArray());
}
PMS = new List<SqlParameter>();
PMS.Add(new SqlParameter("@證券代號", row.GetCell(0).ToString()));
PMS.Add(new SqlParameter("@本益比", Convert.ToSingle(row.GetCell(2).ToString())));
PMS.Add(new SqlParameter("@殖利率", Convert.ToSingle(row.GetCell(3).ToString())));
PMS.Add(new SqlParameter("@股價淨值比", Convert.ToSingle(row.GetCell(4).ToString())));
PMS.Add(new SqlParameter("@資料日期", Convert.ToDateTime(DataTime_PYS_txt.Text)));
PMS.Add(new SqlParameter("@下載日期", dt));
DB.ExecutionStoredProcedure("[PYS_Insert]", PMS.ToArray());
Company_check = 0;
}
}
protected void Page_Load(object sender, EventArgs e)
{
Database.MSSQL DB = new Database.MSSQL("Web");
Stock_Num = DB.QuerySQL("SELECT [C_ID] FROM [Analysis].[dbo].[Company] ORDER BY [C_ID]");
}
