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();
}
}
