//添加数据
private void 添加()
{
//获取数据
商品 sp = new 商品();
sp.条码 = 条码.Text.Trim().ToString();
sp.称 = 称.Text.Trim().ToString();
sp.厂家 = 厂家.Text.Trim().ToString();
sp.类别 = 类别.Text.Trim().ToString();
sp.价格 = Double.Parse(价格.Text.Trim().ToString());
sp.库存 = int.Parse(数量.Text.Trim().ToString());
//sql语句
String sql = "INSERT INTO commodity(Barcode, name, factory, category, price,sum) " +
"VALUES ('{0}', '{1}', '{2}', '{3}', {4},{5});";
sql = String.Format(sql, sp.条码, sp.称, sp.厂家, sp.类别, sp.价格, sp.库存);
//建立链接
MySqlConnection cnn = 系统.链接();
cnn.Open();
//执行
MySqlCommand command = new MySqlCommand(sql, cnn);
command.ExecuteNonQuery();
cnn.Close();
MessageBox.Show("添加成功");
this.Close();
}
//添加库存
private void 添加库存()
{
商品 sp = new 商品();
sp.编号 = int.Parse(编号.Text.ToString());
sp.条码 = 编号.Text.ToString();
int sum = int.Parse(数量.Text.ToString());
//打开链接
MySqlConnection cnn = 系统.链接();
cnn.Open();
string sql = "SELECT * FROM commodity WHERE id=" + sp.编号 + " or Barcode='" + sp.条码 + "'";
//执行
MySqlCommand command = new MySqlCommand(sql, cnn);
MySqlDataReader sdr = command.ExecuteReader();
if (sdr.Read())
{
sp.编号 = sdr.GetInt32("id");
sp.条码 = sdr.GetString("Barcode");
sp.库存 = sdr.GetInt32("sum");
sp.称 = sdr.GetString("name");
sp.厂家 = sdr.GetString("factory");
ListViewItem ltem = new ListViewItem();
//首列名
ltem.Text = sp.编号.ToString();
ltem.SubItems.Add(sp.条码);
ltem.SubItems.Add(sp.称);
ltem.SubItems.Add(sp.厂家);
ltem.SubItems.Add(sum.ToString()); //数量
sum = sum + sp.库存;
ltem.SubItems.Add(sum.ToString()); //库存
this.listView1.Items.Add(ltem);
cnn.Close();
}
else
{
MessageBox.Show("商品不存在");
return;
}
sql = "UPDATE commodity SET sum=" + sum + " WHERE id =" + sp.编号;
//打开链接
MySqlConnection cnn2 = 系统.链接();
cnn2.Open();
//执行
MySqlCommand command2 = new MySqlCommand(sql, cnn2);
command2.ExecuteNonQuery();
//关闭数据链接
cnn2.Close();
}
//加入商品
private void 加入商品(商品 sp, int sum)
{
ListViewItem ltem = new ListViewItem();
//首列名
ltem.Text = sp.编号.ToString();
ltem.SubItems.Add(sp.称);
ltem.SubItems.Add(sp.类别);
ltem.SubItems.Add(sp.价格.ToString());
ltem.SubItems.Add(sum.ToString());//数量
double money = sum * sp.价格;
ltem.SubItems.Add(money.ToString());//合计
this.listView1.Items.Add(ltem);
显示金额();
}
//添加数据
private void 添加数据()
{
//获取编号和数量
商品 sp = new 商品();
sp.编号 = int.Parse(编号.Text.ToString());
sp.条码 = 编号.Text.ToString();
int sum = int.Parse(数量.Text.ToString());
//打开链接
MySqlConnection cnn = 系统.链接();
cnn.Open();
string sql = "SELECT * FROM commodity WHERE id=" + sp.编号 + " or Barcode='" + sp.条码 + "'";
//执行
MySqlCommand command = new MySqlCommand(sql, cnn);
MySqlDataReader sdr = command.ExecuteReader();
if (sdr.Read())
{
sp.编号 = sdr.GetInt32("id");
sp.条码 = sdr.GetString("Barcode");
sp.库存 = sdr.GetInt32("sum");
sp.称 = sdr.GetString("name");
sp.厂家 = sdr.GetString("factory");
sp.类别 = sdr.GetString("category");
sp.价格 = sdr.GetDouble("price");
if (sp.库存 >= sum)
{
加入商品(sp, sum);
}
else
{
MessageBox.Show("库存不足");
return;
}
}
else
{
MessageBox.Show("商品不存在");
}
//关闭数据链接
cnn.Close();
}
//编辑前
private void dataGridView1_CellBeginEdit(object sender, DataGridViewCellCancelEventArgs e)
{
try
{
if (编辑模式)
{
行 = dataGridView1.CurrentCell.RowIndex;
列 = dataGridView1.CurrentCell.ColumnIndex;
sp = new 商品();
sp.编号 = int.Parse(dataGridView1.Rows[行].Cells[0].Value.ToString());
sp.条码 = dataGridView1.Rows[行].Cells[1].Value.ToString();
sp.称 = dataGridView1.Rows[行].Cells[2].Value.ToString();
sp.厂家 = dataGridView1.Rows[行].Cells[3].Value.ToString();
sp.类别 = dataGridView1.Rows[行].Cells[4].Value.ToString();
sp.价格 = Double.Parse(dataGridView1.Rows[行].Cells[5].Value.ToString());
sp.销量 = int.Parse(dataGridView1.Rows[行].Cells[6].Value.ToString());
sp.库存 = int.Parse(dataGridView1.Rows[行].Cells[7].Value.ToString());
}
}
catch (Exception)
{
MessageBox.Show("操作异常！");
}
}
