private void InitializeMenu() { SQLStoreClass <SQLStoreDataSet.SQLTableDataTable> SqlStore = new SQLStoreClass <SQLStoreDataSet.SQLTableDataTable>(); int iCount = SqlStore.getSQLCount + 5, i = 0; SQLStoreDataSet.SQLTableDataTable SqlTable = SqlStore.GetAllData(); WindowsForm.MenuItem[] menuItem = new WindowsForm.MenuItem[iCount]; foreach (DataRow dr in SqlTable.Rows) { menuItem[i] = new WindowsForm.MenuItem(dr["SQLCommandName"].ToString(), (a, c) => { ClearScreen(); ExecuteSQL(a); }); i++; } menuItem[iCount - 5] = new WindowsForm.MenuItem("-"); menuItem[iCount - 4] = new WindowsForm.MenuItem("連線設定(C&)", (a, c) => { ConnectionWindow cw = new ConnectionWindow(); cw.ShowDialog(); }); menuItem[iCount - 3] = new WindowsForm.MenuItem("關於此程式(&B)", (a, c) => { AboutWindow win = new AboutWindow(); win.ShowDialog(); }); menuItem[iCount - 2] = new WindowsForm.MenuItem("-"); menuItem[iCount - 1] = new WindowsForm.MenuItem("結束(&X)", (a, c) => { this.Close(); }); this.cm_Menu = new System.Windows.Forms.ContextMenu(menuItem); this.m_notifyIcon.ContextMenu = cm_Menu; }
/// <summary> /// 取得一筆資料 (DataRow) /// </summary> /// <param name="Title">要查詢的條件 (如果是:SqlDataTable 就是SQLCommandName,如果是SqlConnectionTable 就使用DataSourceName)</param> /// <returns></returns> public DataRow GetOne(string Title) { DataRow result = null; if (SqlTabData is SQLStoreDataSet.SqlConnectionTableDataTable) //如果是:SqlConnectionTableDataTable 就是DataSourceName { SQLStoreDataSet.SqlConnectionTableDataTable c = SqlTabData as SQLStoreDataSet.SqlConnectionTableDataTable; DataRow[] dr = c.Select(string.Format("DataSourceName='{0}'", Title)); if (dr.Length > 0) { result = dr[0]; } } else if (SqlTabData is SQLStoreDataSet.SQLTableDataTable) //如果是SQLTableDataTable 就使用SQLCommandName { SQLStoreDataSet.SQLTableDataTable dt = SqlTabData as SQLStoreDataSet.SQLTableDataTable; DataRow[] dr = dt.Select(string.Format("SQLCommandName='{0}'", Title)); if (dr.Length > 0) { result = dr[0]; } } return(result); }