private void ShowAllCustomerOrderData() { try { dataGridViewOrders.Rows.Clear(); var orders = CustomerOrderDataAccess.GetAllCustomerOrders(); foreach (var order in orders) { int rowId = dataGridViewOrders.Rows.Add(); DataGridViewRow row = dataGridViewOrders.Rows[rowId]; row.Cells["OrderId"].Value = order.Id.ToString(); row.Cells["CustomerId"].Value = order.Customer_Id.ToString(); row.Cells["Username"].Value = order.Username; row.Cells["BookISBN"].Value = order.Book_ISBN; row.Cells["Title"].Value = order.Title; row.Cells["OrderDate"].Value = order.Order_Date.ToString(); row.Cells["Amount"].Value = order.Amount.ToString(); row.Cells["TotalPrice"].Value = order.Total_Price.ToString(); row.Cells["Status"].Value = order.Status; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void dataGridViewWaitingForReviewOrders_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dataGridViewWaitingForReviewOrders.Columns[e.ColumnIndex].Name == "Review" && e.RowIndex >= 0) { string OrderId_Value = dataGridViewWaitingForReviewOrders.Rows[e.RowIndex].Cells["OrderId5"].Value.ToString(); OrderOfCustomerModel order = _waitingForReviewOrders.FindLast(o => o.Id.ToString().Equals(OrderId_Value)); string ISBN_Value = order.Book_ISBN; bool is_reviewed = ReviewDataAccess.IsReviewed(CustomerInfo.customer.Id, ISBN_Value); if (!BookDataAccess.IsBookExisted(ISBN_Value)) { MessageBox.Show("图书不存在"); return; } if (is_reviewed) { DialogResult result = MessageBox.Show("您已对该书做出评价,是否更新评论内容?", "消息", MessageBoxButtons.OKCancel); if (result == DialogResult.Cancel) { CustomerOrderDataAccess.FinishOrder(OrderId_Value); ShowAll(); return; } } var book = BookDataAccess.GetFullBookByISBN(ISBN_Value); WriteReviewForm writeReviewForm = new WriteReviewForm(); SendBookInfoEvent += writeReviewForm.ShowDetail; SendBookInfoEvent.Invoke(OrderId_Value, book, is_reviewed); writeReviewForm.ShowDialog(); ShowAll(); } }
private void buttonFuzzySearch_Click(object sender, EventArgs e) { if (textBoxSearch.Text.Equals("")) { MessageBox.Show("检索关键词为空"); return; } try { switch (comboBoxOption.SelectedIndex) { case 0: ShowCustomerOrderData(CustomerOrderDataAccess.SelectOrderById(textBoxSearch.Text)); break; case 1: ShowCustomerOrderData(CustomerOrderDataAccess.SelectOrderByCustomerId(textBoxSearch.Text)); break; case 2: ShowCustomerOrderData(CustomerOrderDataAccess.SelectOrderByVagueISBN(textBoxSearch.Text)); break; case 3: ShowCustomerOrderData(CustomerOrderDataAccess.SelectOrderByVagueTitle(textBoxSearch.Text)); break; case 4: ShowCustomerOrderData(CustomerOrderDataAccess.SelectOrderByOrderDate(textBoxSearch.Text)); break; case 5: ShowCustomerOrderData(CustomerOrderDataAccess.SelectOrderByAmount(textBoxSearch.Text)); break; case 6: ShowCustomerOrderData(CustomerOrderDataAccess.SelectOrderByTotalPrice(textBoxSearch.Text)); break; case 7: ShowCustomerOrderData(CustomerOrderDataAccess.SelectOrderByStatusId(textBoxSearch.Text)); break; case 8: ShowCustomerOrderData(CustomerOrderDataAccess.SelectOrderByVagueStatusName(textBoxSearch.Text)); break; } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void dataGridViewCanceledOrders_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dataGridViewCanceledOrders.Columns[e.ColumnIndex].Name == "Delete2" && e.RowIndex >= 0) { string OrderId_Value = dataGridViewCanceledOrders.Rows[e.RowIndex].Cells["OrderId7"].Value.ToString(); OrderOfCustomerModel order = _canceledOrders.FindLast(o => o.Id.ToString().Equals(OrderId_Value)); try { CustomerOrderDataAccess.DeleteOrder(OrderId_Value); MessageBox.Show("删除订单成功"); } catch (Exception ex) { MessageBox.Show("删除订单失败\r\n" + ex.Message); } ShowAll(); } }
private void dataGridViewPendingPaymentOrders_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dataGridViewPendingPaymentOrders.Columns[e.ColumnIndex].Name == "Pay" && e.RowIndex >= 0) { string OrderId_Value = dataGridViewPendingPaymentOrders.Rows[e.RowIndex].Cells["OrderId2"].Value.ToString(); OrderOfCustomerModel order = _pendingPaymentOrders.FindLast(o => o.Id.ToString().Equals(OrderId_Value)); if (order == null) { MessageBox.Show("错误:找不到订单"); return; } if (!BookDataAccess.IsBookExisted(order.Book_ISBN)) { MessageBox.Show("错误:图书不存在"); return; } try { CustomerDataAccess.DeductBalance(CustomerInfo.customer.Id, order.Total_Price); CustomerOrderDataAccess.PayOrder(order.Id.ToString()); MessageBox.Show("付款成功"); ShowAll(); } catch (Exception ex) { MessageBox.Show(ex.Message); return; } } else if (dataGridViewPendingPaymentOrders.Columns[e.ColumnIndex].Name == "Cancel1" && e.RowIndex >= 0) { string OrderId_Value = dataGridViewPendingPaymentOrders.Rows[e.RowIndex].Cells["OrderId2"].Value.ToString(); try { CustomerOrderDataAccess.CancelOrder(OrderId_Value); MessageBox.Show("取消成功"); } catch (Exception ex) { MessageBox.Show("取消失败\r\n" + ex.Message); } ShowAll(); } }
private void iconButtonSubmit_Click(object sender, EventArgs e) { if (_book == null) { MessageBox.Show("错误:找不到图书"); return; } try { CustomerOrderDataAccess.SubmitOrder(CustomerInfo.customer.Id, _book.ISBN, _amount, _totalPrice, DateTime.Now); CartDataAccess.DeleteCartItem(CustomerInfo.customer.Id, _book.ISBN); MessageBox.Show("提交订单成功"); Close(); } catch (Exception ex) { MessageBox.Show("提交订单失败\r\n" + ex.Message); } }
private void dataGridViewWaitingForDeliveryOrders_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dataGridViewWaitingForDeliveryOrders.Columns[e.ColumnIndex].Name == "Refund" && e.RowIndex >= 0) { string OrderId_Value = dataGridViewWaitingForDeliveryOrders.Rows[e.RowIndex].Cells["OrderId3"].Value.ToString(); OrderOfCustomerModel order = _waitingForDeliveryOrders.FindLast(o => o.Id.ToString().Equals(OrderId_Value)); try { CustomerDataAccess.TopUp(CustomerInfo.customer.Id, order.Total_Price); CustomerInfo.UpdateInfo(); CustomerOrderDataAccess.CancelOrder(OrderId_Value); MessageBox.Show("退款成功"); } catch (Exception ex) { MessageBox.Show("退款失败\r\n" + ex.Message); } ShowAll(); } }
private void iconButtonOK_Click(object sender, EventArgs e) { if (textBoxReviewContent.Text.Length > 1000) { MessageBox.Show("评论内容请不要超过1000字"); return; } bool is_review_content_null = false; if (textBoxReviewContent.Text.Length == 0) { is_review_content_null = true; } GetReviewRate(); try { if (_isReviewed) { ReviewDataAccess.UpdateReview(CustomerInfo.customer.Id, _book.ISBN, _reviewRate, textBoxReviewContent.Text, DateTime.Now, is_review_content_null); CustomerOrderDataAccess.FinishOrder(_orderId); MessageBox.Show("评论更新成功"); } else { ReviewDataAccess.InsertReview(CustomerInfo.customer.Id, _book.ISBN, _reviewRate, textBoxReviewContent.Text, DateTime.Now, is_review_content_null); CustomerOrderDataAccess.FinishOrder(_orderId); MessageBox.Show("评论成功"); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
private void dataGridViewOrders_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dataGridViewOrders.Columns[e.ColumnIndex].Name == "CustomerDetail" && e.RowIndex >= 0) { string Username_Value = dataGridViewOrders.Rows[e.RowIndex].Cells["CustomerId"].Value.ToString(); var customer = CustomerDataAccess.GetCustomerById(Username_Value); CustomerDetailForm customerDetailForm = new CustomerDetailForm(); SendCustomerInfoEvent += customerDetailForm.ShowDetail; SendCustomerInfoEvent.Invoke(customer); customerDetailForm.ShowDialog(); } else if (dataGridViewOrders.Columns[e.ColumnIndex].Name == "BookDetail" && e.RowIndex >= 0) { string OrderId_Value = dataGridViewOrders.Rows[e.RowIndex].Cells["OrderId"].Value.ToString(); string BookISBN_Value = CustomerOrderDataAccess.GetBookISBNById(OrderId_Value); //string BookISBN_Value = dataGridViewOrders.Rows[e.RowIndex].Cells["BookISBN"].Value?.ToString(); if (BookISBN_Value == null) { MessageBox.Show("图书不存在"); return; } var book = BookDataAccess.GetFullBookByISBN(BookISBN_Value); BookDetailForm bookDetailForm = new BookDetailForm(); SendBookInfoEvent += bookDetailForm.ShowDetail; SendBookInfoEvent.Invoke(book); bookDetailForm.ShowDialog(); } else if (dataGridViewOrders.Columns[e.ColumnIndex].Name == "Ship" && e.RowIndex >= 0) { string OrderId_Value = dataGridViewOrders.Rows[e.RowIndex].Cells["OrderId"].Value.ToString(); string BookISBN_Value = CustomerOrderDataAccess.GetBookISBNById(OrderId_Value); if (BookISBN_Value == null) { MessageBox.Show("图书不存在"); return; } CustomerOrderStatusModel Status_Value = (CustomerOrderStatusModel)dataGridViewOrders.Rows[e.RowIndex].Cells["Status"].Value; if (Status_Value.Id == 2) { int quantity = BookDataAccess.GetBookQuantityByISBN(BookISBN_Value); int amount = CustomerOrderDataAccess.GetAmountById(OrderId_Value); if (quantity >= amount) { CustomerOrderDataAccess.ShipOrder(OrderId_Value); BookDataAccess.UpdateBookQuantity(BookISBN_Value, quantity - amount); } else { MessageBox.Show("库存不足"); return; } } ShowAllCustomerOrderData(); } else if (dataGridViewOrders.Columns[e.ColumnIndex].Name == "Cancel" && e.RowIndex >= 0) { string OrderId_Value = dataGridViewOrders.Rows[e.RowIndex].Cells["OrderId"].Value.ToString(); CustomerOrderDataAccess.CancelOrder(OrderId_Value); ShowAllCustomerOrderData(); } else if (dataGridViewOrders.Columns[e.ColumnIndex].Name == "Delete" && e.RowIndex >= 0) { string OrderId_Value = dataGridViewOrders.Rows[e.RowIndex].Cells["OrderId"].Value.ToString(); CustomerOrderDataAccess.DeleteOrder(OrderId_Value); ShowAllCustomerOrderData(); } }