private void buttonPresiseSearch_Click(object sender, EventArgs e)
{
if (textBoxSearch.Text.Equals(""))
{
MessageBox.Show("检索关键词为空");
return;
}
try
{
switch (comboBoxOption.SelectedIndex)
{
case 0:
ShowSupplierOrdersData(SupplierOrderDataAccess.SelectOrderByOrderId(textBoxSearch.Text));
break;
case 1:
ShowSupplierOrdersData(SupplierOrderDataAccess.SelectOrderBySupplierId(textBoxSearch.Text));
break;
case 2:
ShowSupplierOrdersData(SupplierOrderDataAccess.SelectOrderByExactUsername(textBoxSearch.Text));
break;
case 3:
ShowSupplierOrdersData(SupplierOrderDataAccess.SelectOrderByOrderDate(textBoxSearch.Text));
break;
case 4:
ShowSupplierOrdersData(SupplierOrderDataAccess.SelectOrderByAmount(textBoxSearch.Text));
break;
case 5:
ShowSupplierOrdersData(SupplierOrderDataAccess.SelectOrderByStatusId(textBoxSearch.Text));
break;
case 6:
ShowSupplierOrdersData(SupplierOrderDataAccess.SelectOrderByExactStatusName(textBoxSearch.Text));
break;
case 7:
ShowSupplierOrdersData(SupplierOrderDataAccess.SelectOrderByIsNewBook(textBoxSearch.Text));
break;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void iconButtonSupply_Click(object sender, EventArgs e)
{
if (textBoxISBN.Text.Length == 0)
{
MessageBox.Show("ISBN不能为空");
return;
}
if (BookDataAccess.IsBookExisted(textBoxISBN.Text))
{
SupplierOrderDataAccess.InsertSupplierOrderOfExistentBook(SupplierInfo.supplier.Id, DateTime.Now, (int)numericUpDownAmount.Value, textBoxISBN.Text);
MessageBox.Show("发货成功");
}
else
{
MessageBox.Show("您供应的图书ISBN在书库中未被检索到，\r\n您需要录入关于新书的信息");
NewBookForm newBookForm = new NewBookForm();
SendOrderInfoEvent += newBookForm.GetInfo;
SendOrderInfoEvent.Invoke(textBoxISBN.Text, (int)numericUpDownAmount.Value);
newBookForm.ShowDialog();
}
}
private void ShowAllSupplierOrderData()
{
try
{
dataGridViewOrders.Rows.Clear();
var orders = SupplierOrderDataAccess.GetAllSupplierOrders();
foreach (var order in orders)
{
int rowId = dataGridViewOrders.Rows.Add();
DataGridViewRow row = dataGridViewOrders.Rows[rowId];
row.Cells["OrderId"].Value = order.Id;
row.Cells["SupplierId"].Value = order.Supplier.Id;
row.Cells["Username"].Value = order.Supplier.Username;
row.Cells["OrderDate"].Value = order.Order_Date.ToString("yyyy-MM-dd hh:mm:ss");
row.Cells["Amount"].Value = order.Amount;
row.Cells["Status"].Value = order.Status;
row.Cells["IsNew"].Value = order.Is_New ? "是" : "否";
}
}
catch (Exception ex)
{
MessageBox.Show("刷新失败\n" + ex.Message);
}
}
private void dataGridViewMyOrders_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridViewMyOrders.Columns[e.ColumnIndex].Name == "Detail" && e.RowIndex >= 0)
{
string OrderId_Value = dataGridViewMyOrders.Rows[e.RowIndex].Cells["OrderId"].Value?.ToString();
bool IsNewBook;
try
{
IsNewBook = SupplierOrderDataAccess.GetIsNewBook(OrderId_Value);
}
catch (MyException ex)
{
MessageBox.Show(ex.Message);
return;
}
if (!IsNewBook)
{
var book = BookDataAccess.GetFullBookBySupplierExistentBookOrderId(OrderId_Value);
if (book == null)
{
MessageBox.Show("图书不存在");
return;
}
BookDetailForm detailForm = new BookDetailForm();
SendBookInfoEvent += detailForm.ShowBookDetail;
SendBookInfoEvent.Invoke(book);
detailForm.ShowDialog();
}
else
{
var new_book = NewBookInfoOfSupplierOrderDataAccess.GetNewBookInfoBySupplierOrderId(OrderId_Value);
int status_id = new_book.Supplier_Order.Status.Id;
if (status_id == 1) // 未入库
{
BookUnstockedDetailForm detailForm = new BookUnstockedDetailForm();
SendNewBookInfoEvent += detailForm.ShowNewBookDetail;
SendNewBookInfoEvent.Invoke(new_book);
detailForm.ShowDialog();
}
else // 已入库
{
var book = BookDataAccess.GetFullBookByISBN(new_book.Book_ISBN);
if (book == null)
{
MessageBox.Show("图书不存在");
return;
}
BookDetailForm detailForm = new BookDetailForm();
SendBookInfoEvent += detailForm.ShowBookDetail;
SendBookInfoEvent.Invoke(book);
detailForm.ShowDialog();
}
}
}
else if (dataGridViewMyOrders.Columns[e.ColumnIndex].Name == "Cancel" && e.RowIndex >= 0)
{
string OrderId_Value = dataGridViewMyOrders.Rows[e.RowIndex].Cells["OrderId"].Value.ToString();
int StatusId_Value = SupplierOrderDataAccess.GetStatusIdValue(OrderId_Value);
if (StatusId_Value == 1)
{
try
{
SupplierOrderDataAccess.CancelOrder(OrderId_Value);
}
catch (Exception ex)
{
MessageBox.Show("取消订单失败\n" + ex.Message);
}
}
ShowMyOrders();
}
else if (dataGridViewMyOrders.Columns[e.ColumnIndex].Name == "Delete" && e.RowIndex >= 0)
{
string OrderId_Value = dataGridViewMyOrders.Rows[e.RowIndex].Cells["OrderId"].Value.ToString();
try
{
SupplierOrderDataAccess.DeleteOrder(OrderId_Value);
}
catch (Exception ex)
{
MessageBox.Show("删除订单失败\n" + ex.Message);
}
ShowMyOrders();
}
}
private void dataGridViewOrders_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (dataGridViewOrders.Columns[e.ColumnIndex].Name == "SupplierDetail" && e.RowIndex >= 0)
{
string Username_Value = dataGridViewOrders.Rows[e.RowIndex].Cells["SupplierId"].Value.ToString();
var supplier = SupplierDataAccess.GetSupplierById(Username_Value);
SupplierDetailForm supplierDetailForm = new SupplierDetailForm();
SendSupplierInfoEvent += supplierDetailForm.ShowDetail;
SendSupplierInfoEvent.Invoke(supplier);
supplierDetailForm.ShowDialog();
}
else if (dataGridViewOrders.Columns[e.ColumnIndex].Name == "BookDetail" && e.RowIndex >= 0)
{
string OrderId_Value = dataGridViewOrders.Rows[e.RowIndex].Cells["OrderId"].Value?.ToString();
bool IsNewBook;
try
{
IsNewBook = SupplierOrderDataAccess.GetIsNewBook(OrderId_Value);
}
catch (MyException ex)
{
MessageBox.Show(ex.Message);
return;
}
if (!IsNewBook)
{
var book = BookDataAccess.GetFullBookBySupplierExistentBookOrderId(OrderId_Value);
if (book == null)
{
MessageBox.Show("图书不存在");
return;
}
BookDetailForm detailForm = new BookDetailForm();
SendBookInfoEvent += detailForm.ShowDetail;
SendBookInfoEvent.Invoke(book);
detailForm.ShowDialog();
}
else
{
var new_book = NewBookInfoOfSupplierOrderDataAccess.GetNewBookInfoBySupplierOrderId(OrderId_Value);
int status_id = new_book.Supplier_Order.Status.Id;
if (status_id == 1) // 未入库
{
BookUnstockedDetailForm detailForm = new BookUnstockedDetailForm();
SendNewBookInfoEvent += detailForm.ShowNewBookDetail;
SendNewBookInfoEvent.Invoke(new_book);
detailForm.ShowDialog();
}
else // 已入库
{
var book = BookDataAccess.GetFullBookByISBN(new_book.Book_ISBN);
if (book == null)
{
MessageBox.Show("图书不存在");
return;
}
BookDetailForm detailForm = new BookDetailForm();
SendBookInfoEvent += detailForm.ShowDetail;
SendBookInfoEvent.Invoke(book);
detailForm.ShowDialog();
}
}
}
else if (dataGridViewOrders.Columns[e.ColumnIndex].Name == "Warehouse" && e.RowIndex >= 0)
{
string OrderId_Value = dataGridViewOrders.Rows[e.RowIndex].Cells["OrderId"].Value.ToString();
int StatusId_Value = SupplierOrderDataAccess.GetStatusIdValue(OrderId_Value);
if (StatusId_Value == 1)
{
bool IsNewBook;
try
{
IsNewBook = SupplierOrderDataAccess.GetIsNewBook(OrderId_Value);
}
catch (MyException ex)
{
MessageBox.Show(ex.Message);
return;
}
if (IsNewBook)
{
bool is_on_sale = MessageBox.Show("是否立即上架该图书？", "上架", MessageBoxButtons.OKCancel) == DialogResult.OK;
try
{
SupplierOrderDataAccess.WarehouseNewBook(OrderId_Value, is_on_sale);
}
catch (MyException ex)
{
MessageBox.Show(ex.Message);
}
}
else
{
try
{
SupplierOrderDataAccess.WarehouseExistentBook(OrderId_Value);
}
catch (MyException ex)
{
MessageBox.Show(ex.Message);
}
}
}
ShowAllSupplierOrderData();
}
else if (dataGridViewOrders.Columns[e.ColumnIndex].Name == "Cancel" && e.RowIndex >= 0)
{
string OrderId_Value = dataGridViewOrders.Rows[e.RowIndex].Cells["OrderId"].Value.ToString();
try
{
SupplierOrderDataAccess.CancelOrder(OrderId_Value);
}
catch (Exception ex)
{
MessageBox.Show("取消订单失败\n" + ex.Message);
}
ShowAllSupplierOrderData();
}
else if (dataGridViewOrders.Columns[e.ColumnIndex].Name == "Delete" && e.RowIndex >= 0)
{
string OrderId_Value = dataGridViewOrders.Rows[e.RowIndex].Cells["OrderId"].Value.ToString();
try
{
SupplierOrderDataAccess.DeleteOrder(OrderId_Value);
}
catch (Exception ex)
{
MessageBox.Show("删除订单失败\n" + ex.Message);
}
ShowAllSupplierOrderData();
}
}
