/// <summary> /// 產生的按鈕事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void Button_Click(object sender, RoutedEventArgs e) { //得到按鈕名稱,也就是賽事玩法項目資料表名稱,並執行SQL回傳賽事玩法項目資料DataView string btnMatchItem = ((Button)sender).Content.ToString(); string querySql = "SELECT * " + " FROM [sportslotterydb].[dbo]." + propertiesList[btnMatchItem] + " " + " WHERE Id = " + selectedId + " " + "ORDER BY [CreateDate]"; DataView dataView = executeSql(querySql); matchItemFileLogPropertiesList = new NameValueCollection(); readMatchItemFileLogProperties(matchItemFileLogPropertiesList, matchItemFileLog_ini, btnMatchItem); //得到DataView有幾個欄位 int colCount = dataView.Table.Columns.Count; int listCount = 0; for (int i = 0; i < colCount; i++) { //第一、倒數第二、倒數第一欄不改欄位名稱 if (i > 0 && (i < colCount - 2)) { dataView.Table.Columns[i].ColumnName = matchItemFileLogPropertiesList[listCount]; listCount += 1; } } //建立MatchItemWindow類別,傳遞賽事號碼以及賽事玩法項目資料DataView,接著開啟視窗 matchItemWindow = MatchItemWindow.GetInstance(); matchItemWindow.SelectedId = selectedId; matchItemWindow.MatchItemDataView = dataView; matchItemWindow.Show(); }
//MatchItemWindow實例建立設定 public static MatchItemWindow GetInstance() { if (staticInstance == null) { staticInstance = new MatchItemWindow(); } return(staticInstance); }
//視窗即將關閉事件設定 private void WindowOnClosed(object sender, EventArgs e) { staticInstance = null; }