void update()
{
MidDataBaseEntities dbContext = new MidDataBaseEntities();
var q = (from p in dbContext.tMember
where p.fId.Equals(Member.fId)
select p).FirstOrDefault();
lblGold.Text = q.fGold.ToString();
}
void addNPC()
{
MidDataBaseEntities dbContext = new MidDataBaseEntities();
var q = (from p in dbContext.tNPC
where p.fID.Equals(1)//id寫死
select p).FirstOrDefault();
Copper.fName = q.fName;
Copper.fGold = q.fGold;
}
private void Shop_Load(object sender, EventArgs e)
{
MidDataBaseEntities dbContext = new MidDataBaseEntities();
var q = (from p in dbContext.tShop
where p.fID == 3
select p).FirstOrDefault();
Sshop.fName = q.fName;
Sshop.fPrice = q.fPrice;
lblShop1Name.Text = Sshop.fName;
lblShop1Price.Text = Sshop.fPrice.ToString();
pbxSHOP1.Image = Image.FromFile(q.fPhoto);
}
private void btnCheckOut_Click(object sender, EventArgs e)
{
MidDataBaseEntities dbContext = new MidDataBaseEntities();
if (listBox1.Items.Count == 0)
{
return;
}
if (MessageBox.Show("請問是否購買?", "是否購買", MessageBoxButtons.YesNo) == DialogResult.No)
{
return;
}
var q = (from p in dbContext.tMember
where p.fId.Equals(Member.fId)
select p).FirstOrDefault();
if (q.fGold < Sshop.fPrice)
{
MessageBox.Show("金額不足");
return;
}
q.fGold = q.fGold - Sshop.fPrice;
dbContext.SaveChanges();
Form f = Application.OpenForms["Main"];
((Main)f).lblGold.Text = q.fGold.ToString(); //同步更新
//==============================================
var q1 = (from p in dbContext.tShop
where p.fID.Equals(3)
select p).FirstOrDefault();
itemform.Ssop.fID = q1.fID;
itemform.Member.fId = q.fId;
itemform.TopLevel = false;
itemform.Dock = DockStyle.Fill;
panel1.Controls.Add(itemform);//
itemform.Show();
//==============================================
}
private void Item_Load(object sender, EventArgs e)
{
MidDataBaseEntities dbContext = new MidDataBaseEntities();
var q = (from p in dbContext.fItemBox
from c in dbContext.tShop
from m in dbContext.tMember
where p.fID == Member.fId && p.fID == c.fID
select c).FirstOrDefault();
for (int i = 1; i < 3; i++)
{
for (int j = 1; j < 5; j++)
{
PictureBox btn1 = new PictureBox();
btn1.Height = 50;
btn1.Width = 50;
btn1.Location = new Point(20 + 60 * (j - 1), 50 + 60 * (i - 1));
btn1.Name = "btn" + j;
btn1.Text = btn1.Name;
btn1.BorderStyle = BorderStyle.Fixed3D;
this.Controls.Add(btn1);
if (i == 2)
{
btn1.Name = "btn" + (j + 4);
btn1.Text = btn1.Name;
btn1.BorderStyle = BorderStyle.Fixed3D;
this.Controls.Add(btn1);
}
if (btn1.Name == "btn1" && q != null)
{
btn1.Image = Image.FromFile(q.fPhoto);
btn1.SizeMode = PictureBoxSizeMode.Zoom;
}
}
}
InitializeTimer();
}
private void timer1_Tick(object sender, EventArgs e)
{
if (Ssop.fID == 0 || Member.fId == 0)
{
return;
}
MidDataBaseEntities dbContext = new MidDataBaseEntities();
IitemBox.fID = Ssop.fID;
IitemBox.fMemberID = Member.fId;
dbContext.fItemBox.Add(IitemBox);
dbContext.SaveChanges();
if (IitemBox.fID > 0)
{
timer1.Enabled = false;
}
//if (Ssop.fID == 0)
//{
// timer1.Enabled = true;
//}
//================================================
}
private void btnAddGold(object sender, EventArgs e)
{
addNPC();
MidDataBaseEntities dbContext = new MidDataBaseEntities();
var q = (from p in dbContext.tMember
where p.fId.Equals(Member.fId)
select p).FirstOrDefault();
q.fGold = q.fGold + Copper.fGold;
lblGold.Text = q.fGold.ToString();
dbContext.SaveChanges();
//if (NowFrom == InformationForm)//如果是開個人資料頁面
//{
// Form f = Application.OpenForms["Information"];
// ((Information)f).lblGold.Text = q.fGold.ToString(); //同步更新
//}
//else if (NowFrom == ItemForm)//如果是開物品欄頁面
//{
// Form f = Application.OpenForms["Item"];
// ((Item)f).lblGold.Text = q.fGold.ToString(); //同步更新
//}
}