private void dealButton_Click(object sender, EventArgs e)
{
float amount = SqlManage.amountQuery(orderId);
Order order = SqlManage.orderQuery(orderId);
int customerId = order.CustomerId;
Customer customer = SqlManage.customerQuery(customerId);
order.IsDealed = true;
if (amount < customer.Balance + customer.CustomerCreditLimit)
{
Bill bill = null;
DateTime payDate = DateTime.Now;
float amountPayable = amount;
float payAmount;
int billId = SqlManage.queryMaxBillId() + 1;
if (customer.Balance < amount)
{
payAmount = customer.Balance;
}
else
{
payAmount = amount;
}
bill = new Bill(billId, orderId, amountPayable, payDate, payAmount);
SqlManage.insertBill(bill);
customer.Balance -= amount;
if (SqlManage.updateCustomer(customer) &&
SqlManage.updateOrder(order))
{
//更新库存
for (int i = 0; i < myDataGridView.RowCount - 1; i++)
{
int goodsId = Convert.ToInt32(myDataGridView[0, i].Value);
Goods goods = SqlManage.goodsQuery(goodsId);
int goodsNum = Convert.ToInt32(myDataGridView[1, i].Value);
goods.ActualStorage -= goodsNum;
SqlManage.updateGoods(goods);
}
MessageBox.Show("支付成功!");
}
}
else
{
MessageBox.Show("已超出最大赊购限额！");
}
}