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