public int losemoney(string shop_name)//购买物品减少金钱
{
SSHOP shop1 = new SSHOP();
PERSON person = new PERSON();
int allmoney = person.Tiqu_person_money();
int lose_money = shop1.Tiqu_shop_money(shop_name);
if (allmoney >= lose_money)
{
sql.Open();
string lose_money1 = "update person set person_money-=" + lose_money;
SqlCommand command_losemoney = new SqlCommand(lose_money1, sql);
try
{
command_losemoney.ExecuteNonQuery();
}
catch
{
MessageBox.Show("减少金钱失败");
}
finally
{
sql.Close();
}
return(1);
}
else
{
return(0);
}
}
private void button1_Click(object sender, EventArgs e)
{
SSHOP shop = new SSHOP();
ATTACK aTTACK = new ATTACK();
sql.Open();
int ID = Convert.ToInt32(dataGridView1.CurrentCell.RowIndex) + 1;
string shopcheck = "select *from shop where shop_id=" + ID;
SqlCommand command_shop = new SqlCommand(shopcheck, sql);
SqlDataReader reader = command_shop.ExecuteReader();
while (reader.Read())
{
shop_item = reader.GetString(reader.GetOrdinal("itemname"));
}
reader.Close();
if (shop.losemoney(shop_item) == 1)
{
aTTACK.bag_add(shop_item);
MessageBox.Show("购买成功", "恭喜您");
}
else
{
MessageBox.Show("您的金钱不够哦");
}
sql.Close();
}
private void button1_Click(object sender, EventArgs e)
{
string a = Convert.ToString(dataGridView1.CurrentCell.Value);
SSHOP shop = new SSHOP();
try
{
shop.useitems(a);
MessageBox.Show("使用物品成功");
sql.Open();
skinPictureBox1.Image = Image.FromFile("背包.jpg");
string str = " select *from bag ";
DataTable b = new DataTable();
SqlDataAdapter c = new SqlDataAdapter(str, sql);
c.Fill(b);
dataGridView1.DataSource = b;
sql.Close();
}
catch
{
MessageBox.Show("使用物品失败");
}
}
