/// <summary>
/// 預先讀取當前資料庫各地的機房資料。
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Page_Loaded(object sender, RoutedEventArgs e)
{
SecureDBContext db = new SecureDBContext();
var Engine_Room_Data =
from n in db.GetTblEngineRoomConfigQuery()
select n;
LoadOperation<tblEngineRoomConfig> lo_ERD =
db.Load<tblEngineRoomConfig>(Engine_Room_Data);
lo_ERD.Completed += (o_ERD, e_ERD) =>
{
if (lo_ERD.Entities.Count() != 0)
{
foreach (tblEngineRoomConfig _entity in lo_ERD.Entities)
{
this.Engine_Room_combobox.Items.Add(new ComboBoxItem()
{
VerticalContentAlignment = System.Windows.VerticalAlignment.Center,
HorizontalAlignment = System.Windows.HorizontalAlignment.Stretch,
HorizontalContentAlignment = System.Windows.HorizontalAlignment.Center,
Content = _entity.ERName,
Tag = _entity.ERID
});
}
}
else { MessageBox.Show("查詢不到各地區的機房資料!", "錯誤", MessageBoxButton.OK); }
};
// this.DBContext.tblEngineRoomConfigs.Clear();
}
