private void button1_Click(object sender, EventArgs e)
{
Database2 db = new Database2();
MySqlConnection conn = db.getConn();
try
{
conn.Open();
int index = dataGridView3.CurrentRow.Index;
String value = dataGridView3.Rows[index].Cells[0].Value.ToString();
String sql = String.Format("delete from `c#_store`.manu where `c#_store`.manu.manu_id = '{0}'", value);
MySqlCommand comm = new MySqlCommand(sql, conn);
comm.ExecuteNonQuery();
db.insert_re("删除成功");
MessageBox.Show("删除成功");
}
catch (Exception exception)
{
Console.WriteLine(exception);
MessageBox.Show(exception.Message.ToString() + "数据库打开失败");
}
finally
{
conn.Close();
}
}
private void sumbit1_Click(object sender, EventArgs e)
{
Database2 db = new Database2();
MySqlConnection conn = db.getConn();
try
{
conn.Open();
String sql = String.Format("select count(*) from `c#_store`.manu ");
MySqlCommand comm = new MySqlCommand(sql, conn);
int manu_num = Convert.ToInt32(comm.ExecuteScalar());
if (manu_num > 0)
{
for (int i = 1; i <= manu_num; i++)
{
String sql1 = String.Format("select * from `c#_store`.manu limit {0} ", i.ToString());
MySqlCommand comm1 = new MySqlCommand(sql1, conn);
MySqlDataAdapter sda = new MySqlDataAdapter();
sda.SelectCommand = comm1;
//数据集
DataSet ds = new DataSet();
sda.Fill(ds, "manu");
String shop_name = ds.Tables[0].Rows[0]["manu_shop_name"].ToString().Trim();
String shop_price = ds.Tables[0].Rows[0]["manu_shop_price"].ToString().Trim();
String shop_number = ds.Tables[0].Rows[0]["manu_shop_number"].ToString().Trim();
String sql21 = String.Format("select * from `c#_store`.stock_store where stock_shop_name = '{0}'", shop_name);
MySqlCommand comm_21 = new MySqlCommand(sql21, conn);
MySqlDataAdapter SDA2 = new MySqlDataAdapter();
SDA2.SelectCommand = comm_21;
DataSet ds2 = new DataSet();
SDA2.Fill(ds2, "stock_store");
String stock_store_shop_number = ds2.Tables[0].Rows[0]["stock_shop_number"].ToString().Trim();
String stock_supplier_shop_name =
String.Format(
"select * from `c#_store`.stock_supplier where `c#_store`.stock_supplier.supplier_shop_name='{0}'",
shop_name);
MySqlCommand comm_supplier = new MySqlCommand(stock_supplier_shop_name, conn);
if (Convert.ToInt32(comm_supplier.ExecuteScalar()) > 0)
{
MySqlDataAdapter sda1 = new MySqlDataAdapter();
sda1.SelectCommand = comm_supplier;
DataSet ds1 = new DataSet();
sda1.Fill(ds1, "stock_supplier");
String supplier_shop_number =
ds1.Tables[0].Rows[0]["SUPPLIER_SHOP_NUMBER"].ToString().Trim();
if (Convert.ToInt32((supplier_shop_number)) >= Convert.ToInt32(shop_number))
{
String shop_number_sql1 =
String.Format(
"update `c#_store`.stock_supplier set `c#_store`.stock_supplier.supplier_shop_number= '{0}'-'{1}' where supplier_shop_name ='{2}'",
supplier_shop_number, shop_number, shop_name);
MySqlCommand comm2 = new MySqlCommand(shop_number_sql1, conn);
if (comm2.ExecuteNonQuery() > 0)
{
//商品名是否存在
String select_a =
String.Format(
"select * from `c#_store`.stock_store where stock_shop_name ='{0}'",
shop_name);
MySqlCommand comm_s = new MySqlCommand(select_a, conn);
if (Convert.ToInt32(comm_s.ExecuteScalar()) > 0)
{
String sql10 = String.Format(
"select * from `c#_store`.stock_store where stock_shop_name ='{0}' limit 1",
shop_name);
MySqlCommand comm10 = new MySqlCommand(sql10, conn);
MySqlDataAdapter sda10 = new MySqlDataAdapter();
sda.SelectCommand = comm10;
//数据集
DataSet ds10 = new DataSet();
sda.Fill(ds10, "stock_store");
String number = ds10.Tables[0].Rows[0]["stock_shop_number"].ToString().Trim();
String update_sql = String.Format(
"update `c#_store`.stock_store set stock_shop_number='{0}'+'{1}' where stock_shop_name='{2}'",
number,
shop_number, shop_name);
MySqlCommand comm_update_sql = new MySqlCommand(update_sql, conn);
int num5 = comm_update_sql.ExecuteNonQuery();
if (num5 > 0)
{
String manu_sql = String.Format(
"delete from `c#_store`.manu where manu_shop_name ='{0}'", shop_name);
MySqlCommand comm6 = new MySqlCommand(manu_sql, conn);
int num6 = comm6.ExecuteNonQuery();
if (num6 > 0)
{
String sql7 = String.Format(
"delete from `c#_store`.stock_supplier where supplier_shop_number= 0");
MySqlCommand comm7 = new MySqlCommand(sql7, conn);
comm7.ExecuteNonQuery();
db.insert_re("订单更新成功");
MessageBox.Show("该订单更新成功");
}
else
{
db.insert_re("该订单库存删除失败");
MessageBox.Show("该订单库存删除失败");
}
}
else
{
db.insert_re("该订单更新插入失败");
MessageBox.Show("该订单更新插入失败");
}
}
else
{
String insert_sql = String.Format(
"insert into `c#_store`.stock_store (stock_shop_name, stock_shop_price, stock_shop_number) VALUES ('{0}','{1}','{2}')",
shop_name, shop_price, shop_number);
MySqlCommand comm4 = new MySqlCommand(insert_sql, conn);
int num4 = comm4.ExecuteNonQuery();
if (num4 > 0)
{
String manu_sql = String.Format(
"delete from `c#_store`.manu where manu_shop_name ='{0}'", shop_name);
MySqlCommand comm6 = new MySqlCommand(manu_sql, conn);
int num6 = comm6.ExecuteNonQuery();
if (num6 > 0)
{
String sql7 = String.Format(
"delete from `c#_store`.stock_supplier where supplier_shop_number= 0");
MySqlCommand comm7 = new MySqlCommand(sql7, conn);
comm7.ExecuteNonQuery();
db.insert_re("该订单更新成功");
MessageBox.Show("该订单更新成功");
}
else
{
db.insert_re("该订单库存删除失败");
MessageBox.Show("该订单库存删除失败");
}
}
else
{
db.insert_re("该订单更新插入失败");
MessageBox.Show("该订单更新插入失败");
}
}
}
else
{
db.insert_re("该订单库存请求，供应库存失败");
MessageBox.Show("该订单库存请求,供应商库存失败");
}
}
else
{
db.insert_re("该订单库存不足,是否需求剩余订单,请输入请求数量");
MessageBox.Show("该订单库存不足,是否需求剩余订单,请输入请求数量");
String manu_number1 = Interaction.InputBox("输入的 请求数量", "请求数量", "", 3, 3);
if (Convert.ToInt32(manu_number1) <= Convert.ToInt32(supplier_shop_number))
{
String manu_sql11 =
String.Format(
"update `c#_store`.stock_supplier set `c#_store`.stock_supplier.supplier_shop_number='{0}'-'{1}' where supplier_shop_name = '{2}'",
supplier_shop_number, manu_number1, shop_name);
MySqlCommand comm_manu = new MySqlCommand(manu_sql11, conn);
int manu_num1 = comm_manu.ExecuteNonQuery();
if (manu_num1 > 0)
{
db.insert_re("供应商库存更改成功");
MessageBox.Show("供应商库存更改成功");
String manu_sql13 = String.Format(
"select * from `c#_store`.stock_store where stock_shop_name = '{0}' ",
shop_name);
MySqlCommand comm_manu_sql13 = new MySqlCommand(manu_sql13, conn);
int manu_sql13_num = Convert.ToInt32(comm_manu_sql13.ExecuteScalar());
if (manu_sql13_num > 0)
{
String manu_sql_18 = String.Format(
"update `c#_store`.stock_store set stock_shop_number = '{0}'+'{1}' where stock_shop_name='{2}'",
manu_number1, stock_store_shop_number, shop_name);
MySqlCommand comm_sql_18 = new MySqlCommand(manu_sql_18, conn);
int num18 = comm_sql_18.ExecuteNonQuery();
if (num18 > 0)
{
String manu_sql_19_sql = String.Format(
"delete from `c#_store`.manu where manu_shop_name = '{0}'",
shop_name);
MySqlCommand manu_sql_19 = new MySqlCommand(manu_sql_19_sql, conn);
int manu_sql_15_15_num1 = manu_sql_19.ExecuteNonQuery();
if (manu_sql_15_15_num1 > 0)
{
db.insert_re("订单更新成功");
MessageBox.Show("该订单更新成功");
}
else
{
db.insert_re("订单更新失败");
MessageBox.Show("该订单更新失败");
}
}
else
{
MessageBox.Show("该订单请求失败");
String manu_sql20 =
String.Format(
"update `c#_store`.stock_supplier set `c#_store`.stock_supplier.supplier_shop_number=' {0}'+'{1}' where supplier_shop_name = '{2}'",
supplier_shop_number, manu_number1, shop_name);
MySqlCommand comm_manu20 = new MySqlCommand(manu_sql20, conn);
int manu_num20 = comm_manu20.ExecuteNonQuery();
if (manu_num20 > 0)
{
db.insert_re("该订单取消成功");
MessageBox.Show("该订单取消成功");
}
else
{
db.insert_re("该订单取消失败");
MessageBox.Show("该订单取消失败");
}
}
}
else
{
String manu_sql12 = String.Format(
"insert into `c#_store`.stock_store (stock_shop_name, stock_shop_price, stock_shop_number) VALUES ('{0}','{1}','{2}')",
shop_name, shop_price, manu_number1);
MySqlCommand manu_sql_13 = new MySqlCommand(manu_sql12, conn);
int manu_sql_13_num = manu_sql_13.ExecuteNonQuery();
if (manu_sql_13_num > 0)
{
String manu_sql_15_sql = String.Format(
"delete from `c#_store`.manu where manu_shop_name = '{0}'",
shop_name);
MySqlCommand manu_sql_15 = new MySqlCommand(manu_sql_15_sql, conn);
int manu_sql_15_15_num = manu_sql_15.ExecuteNonQuery();
if (manu_sql_15_15_num > 0)
{
db.insert_re("订单更新成功");
MessageBox.Show("该订单更新成功");
}
else
{
db.insert_re("订单更新失败");
MessageBox.Show("该订单更新失败");
}
}
else
{
db.insert_re("订单请求失败");
MessageBox.Show("该订单请求失败");
String manu_sql14 =
String.Format(
"update `c#_store`.stock_supplier set `c#_store`.stock_supplier.supplier_shop_number= '{0}'+'{1}' where supplier_shop_name = '{2}'",
supplier_shop_number, manu_number1, shop_name);
MySqlCommand comm_manu14 = new MySqlCommand(manu_sql14, conn);
int manu_num14 = comm_manu14.ExecuteNonQuery();
if (manu_num14 > 0)
{
db.insert_re("订单取消失败");
MessageBox.Show("该订单取消成功");
}
else
{
db.insert_re("该订单取消失败");
MessageBox.Show("该订单取消失败");
}
}
}
}
else
{
db.insert_re("订单更新失败");
MessageBox.Show("订单更新失败");
}
}
else
{
MessageBox.Show("请求数量大于库存");
}
}
}
else
{
db.insert_re("供应商订单无库存");
MessageBox.Show("供应商该订单无库存");
}
}
}
else
{
db.insert_re("处理订单为空");
MessageBox.Show("处理订单为空");
}
}
catch (Exception exception)
{
Console.WriteLine(exception);
MessageBox.Show(exception.Message.ToString());
}
finally
{
conn.Close();
}
}