private void shuaXinButton_Click(object sender, EventArgs e) { myDataGridView.DataSource = SqlManage.goodsBrowse().Tables[0]; for (int i = 0; i < myDataGridView.Rows.Count; i++) { int store = int.Parse(myDataGridView.Rows[i].Cells[4].Value.ToString()); int goodsId = int.Parse(myDataGridView.Rows[i].Cells[0].Value.ToString()); if (store < SqlManage.goodsQuery(goodsId).MinStorage) { myDataGridView.Rows[i].Cells[0].Style.BackColor = Color.Red; } } }
private void GoodsStatisticForm_Load(object sender, EventArgs e) { myDataGridView.DataSource = SqlManage.goodsBrowse().Tables[0]; for (int i = 0; i < myDataGridView.Rows.Count - 1; i++) { int store = int.Parse(myDataGridView.Rows[i].Cells[4].Value.ToString()); int goodsId = int.Parse(myDataGridView.Rows[i].Cells[0].Value.ToString()); if (store < SqlManage.goodsQuery(goodsId).MinStorage) { for (int j = 0; j < myDataGridView.ColumnCount; j++) { myDataGridView.Rows[i].Cells[j].Style.BackColor = Color.Red; } } } }
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("已超出最大赊购限额!"); } }