//修改某个商品信息页面
private void alterProductButton_Click(object sender, EventArgs e)
{
try
{
//获取将要修改的商品信息
int row = this.productDataGridView.CurrentRow.Index;
int productId = Int32.Parse(
this.productDataGridView.Rows[row].Cells[0].Value.ToString()
);
int amount = Int32.Parse(
this.productDataGridView.Rows[row].Cells[2].Value.ToString()
);
int price = Int32.Parse(
this.productDataGridView.Rows[row].Cells[1].Value.ToString()
);
//调用数据库操作
DBOperation.UpdateProductAmount(this.orderId, productId, amount, price);
//更新表格
this.productDataGridView.DataSource = DBOperation.GetProductData(orderId);
}
catch (FormatException exception)
{
MessageBox.Show(exception.Message, "ERROR", MessageBoxButtons.OK);
}
}
private void orderDataGridView_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
try
{
//获取选中的订单的订单号
int row = this.orderDataGridView.CurrentRow.Index;
int orderId = Int32.Parse(
this.orderDataGridView.Rows[row].Cells[0].Value.ToString()
);
//调用数据库操作
this.productDataGridView.DataSource = DBOperation.GetProductData(orderId);
this.productDataGridView.DataMember = "products";
}
catch (FormatException exception)
{
MessageBox.Show(exception.Message, "ERROR", MessageBoxButtons.OK);
}
}
public alterForm(int orderId, string recPerson, string recAddress)
{
InitializeComponent();
this.orderId = orderId;
this.RecPersonTextBox.Text = this.recPerson = recPerson;
this.RecAddressTextBox.Text = this.recAddress = recAddress;
//设置表格属性
this.productBindingSource_1.DataSource = DBOperation.GetProductData(orderId);
this.productDataGridView.DataSource = this.productBindingSource_1;
this.productDataGridView.DataMember = "products";
//除了商品数量列外均设置为只读
this.productDataGridView.Columns[0].ReadOnly = true;
this.productDataGridView.Columns[1].ReadOnly = true;
this.productDataGridView.Columns[3].ReadOnly = true;
this.productDataGridView.Columns[4].ReadOnly = true;
this.productDataGridView.Columns[5].ReadOnly = true;
}
//删除选中的商品
private void deleteProductButton_Click(object sender, EventArgs e)
{
try
{
//获取选中的商品的信息
int row = this.productDataGridView.CurrentRow.Index;
int productId = Int32.Parse(
this.productDataGridView.Rows[row].Cells[0].Value.ToString()
);
//调用数据库操作删除商品
DBOperation.DeleteProduct(orderId, productId);
//刷新表格
this.productDataGridView.DataSource = DBOperation.GetProductData(this.orderId);
}
catch (FormatException exception)
{
MessageBox.Show(exception.Message, "ERROR", MessageBoxButtons.OK);
}
}
//添加商品
private void Button_Click(object sender, EventArgs e)
{
try
{
//根据输入的信息添加商品
string name = this.productNameTextBox.Text;
double price = Double.Parse(
this.priceTextBox.Text);
int amount = Int32.Parse(
this.amountTextBox.Text);
int productId = Int32.Parse(
this.productIdtextBox.Text);
//调用数据库操作
DBOperation.AddProduct(productId, price, amount, name, this.orderId);
//刷新表格
data.DataSource = DBOperation.GetProductData(this.orderId);
}catch (FormatException exception)
{
MessageBox.Show(exception.Message, "ERROR", MessageBoxButtons.OK);
}
}