public static void DelRecord()
{
DBHandler tDBHandler = new DBHandler(DBHandler.DBConnection);
var tContacts = from Contacts in tDBHandler.Contacts
where Contacts.CNAME == "HERO"
select Contacts;
Contacts A = tContacts.First();
A.XML = null;
tDBHandler.SubmitChanges();
}
public void AddSCORE()
{
//腳色死亡 將分數寫回資料庫
DBHandler tDBHandler = new DBHandler(DBHandler.DBConnection);
Contacts_Score DATA = new Contacts_Score();
DATA.Lv = GamePage.HERO_LV;
DATA.Score = GamePage.HERO_SCORE2;
DATA.Datetime = DateTime.Now;
tDBHandler.Contacts_Score.InsertOnSubmit(DATA);
tDBHandler.SubmitChanges();
}
public MainPage()
{
TARY_Library_Silverlight.ProdKey.Register(101);//產品序號
InitializeComponent();
tDBHandler = new DBHandler(DBHandler.DBConnection);
if (tDBHandler.DatabaseExists() == false)
{
tDBHandler.CreateDatabase();
Contacts A = new Contacts();
A.CNAME = "HERO";
A.XML = null;
tDBHandler.Contacts.InsertOnSubmit(A);
tDBHandler.SubmitChanges();
}
isload();
}
/// <summary>
/// 允許頁面執行邏輯，例如更新環境、
/// 檢查衝突、收集輸入和播放音訊。
/// </summary>
private void OnUpdate(object sender, GameTimerEventArgs e)
{
touchState = TouchPanel.GetState();
// TODO: 在此處加入更新邏輯
if (LOCAL == "遊戲")
{
if (PANEL_STOP.Visibility == System.Windows.Visibility.Visible)
{
PANEL_STOP.Visibility = System.Windows.Visibility.Collapsed;
}
if (PANEL_MENU.Visibility == System.Windows.Visibility.Visible)
{
PANEL_MENU.Visibility = System.Windows.Visibility.Collapsed;
}
if (R_LV == null)
{
R_LV = new LV(HERO_LV);
}
R_LV.update(); //關卡怪物
R_HERO.update(); //畫英雄
R_MFired.update(); //怪物攻擊球
R_BAR.update();
R_MonsterThg.update(); //寶物
R_BG.update(); //背景
}
else if (LOCAL == "遊戲暫停")
{
if (PANEL_MENU.Visibility == System.Windows.Visibility.Visible)
{
PANEL_MENU.Visibility = System.Windows.Visibility.Collapsed;
}
if (PANEL_STOP.Visibility == System.Windows.Visibility.Collapsed)
{
PANEL_STOP.Visibility = System.Windows.Visibility.Visible;
}
}
else if (LOCAL == "選單")
{
if (PANEL_STOP.Visibility == System.Windows.Visibility.Visible)
{
PANEL_STOP.Visibility = System.Windows.Visibility.Collapsed;
}
if (PANEL_MENU.Visibility == System.Windows.Visibility.Collapsed)
{
PANEL_MENU.Visibility = System.Windows.Visibility.Visible;
}
if (tR_MENU)
{
R_MENU.Update();//重新撈取 英雄資料
tR_MENU = false;
}
MENU_UPDATE();//不斷一直抓取資料
}
else if (LOCAL == "死亡")
{
R_MENU_DEAD.update();
}
else if (LOCAL == "離開遊戲")
{
myHERO SaveGame = new myHERO();
SaveGame.Save(); //將所有要存檔的資料彙整
MemoryStream ms = new MemoryStream();
Serialize(ms, SaveGame);
ms.Position = 0;
ms.Close();
byte[] by = ms.ToArray();
//-------------------------------
DBHandler tDBHandler = new DBHandler(DBHandler.DBConnection);
var tContacts = from Contacts in tDBHandler.Contacts
where Contacts.CNAME == "HERO"
select Contacts;
Contacts A = tContacts.First();
A.XML = by;
tDBHandler.SubmitChanges();
GamePage.R_BAR.PowerLv = 0;//將英雄能源清除
if (NavigationService.CanGoBack)
{
NavigationService.GoBack();
}
}
else if (LOCAL == "死亡離開遊戲")
{
GamePage.R_BAR.PowerLv = 0;//將英雄能源清除
if (NavigationService.CanGoBack)
{
NavigationService.GoBack();
}
}
else if (LOCAL == "破關")
{
R_GAME_END.update();
}
else if (LOCAL == "新遊戲")
{
if (PANEL_NEWGAME.Visibility == System.Windows.Visibility.Collapsed)
{
PANEL_NEWGAME.Visibility = System.Windows.Visibility.Visible;
}
if (PANEL_STOP.Visibility == System.Windows.Visibility.Visible)
{
PANEL_STOP.Visibility = System.Windows.Visibility.Collapsed;
}
if (PANEL_MENU.Visibility == System.Windows.Visibility.Visible)
{
PANEL_MENU.Visibility = System.Windows.Visibility.Collapsed;
}
}
}