public void selectall2() { Database2 db = new Database2(); MySqlConnection conn = db.getConn(); try { conn.Open(); String sql = String.Format("select * from `c#_store`.stock_supplier"); MySqlCommand comm = new MySqlCommand(sql, conn); MySqlDataAdapter sda = new MySqlDataAdapter(); sda.SelectCommand = comm; //数据集 DataSet ds = new DataSet(); sda.Fill(ds, "stock_store"); dataGridView2.DataSource = ds.Tables[0]; dataGridView2.Columns[0].HeaderText = "id"; dataGridView2.Columns[1].HeaderText = "商品名"; dataGridView2.Columns[2].HeaderText = "价格"; dataGridView2.Columns[3].HeaderText = "数量"; } catch (Exception e) { Console.WriteLine(e); MessageBox.Show(e.Message.ToString()); } finally { conn.Close(); } }
private void update_Click(object sender, EventArgs e) { Database2 db = new Database2(); MySqlConnection conn = db.getConn(); try { conn.Open(); int index = dataGridView1.CurrentRow.Index; String value = dataGridView1.Rows[index].Cells[0].Value.ToString(); String value0 = dataGridView1.Rows[index].Cells[1].Value.ToString(); String value1 = dataGridView1.Rows[index].Cells[2].Value.ToString(); String value2 = dataGridView1.Rows[index].Cells[3].Value.ToString(); String sql = String.Format( "update `c#_store`.stock_supplier set `c#_store`.stock_supplier.supplier_shop_name='{0}',`c#_store`.stock_supplier.supplier_shop_price='{1}',`c#_store`.stock_supplier.supplier_shop_number='{2}' where `c#_store`.stock_supplier.stock_supplier_id='{3}'", value0, value1, value2, value); MySqlCommand comm = new MySqlCommand(sql, conn); comm.ExecuteNonQuery(); MessageBox.Show("修改成功"); selectall(); } catch (Exception exception) { Console.WriteLine(exception); MessageBox.Show(exception.Message.ToString() + "打开数据库失败"); } finally { conn.Close(); } }
public void selectall3() { Database2 db = new Database2(); MySqlConnection conn = db.getConn(); try { conn.Open(); String sql12 = String.Format("select * from user_customer"); MySqlCommand comm12 = new MySqlCommand(sql12, conn); MySqlDataAdapter sda12 = new MySqlDataAdapter(); sda12.SelectCommand = comm12; //数据集 DataSet ds12 = new DataSet(); sda12.Fill(ds12, "user_customer"); dataGridView3.DataSource = ds12.Tables[0]; dataGridView3.Columns[0].HeaderText = "id"; dataGridView3.Columns[1].HeaderText = "订单人"; } catch (Exception e1) { MessageBox.Show(e1.Message.ToString()); } finally { conn.Close(); } }
public void selectall4() { Database2 db = new Database2(); MySqlConnection conn = db.getConn(); try { conn.Open(); String sql1 = String.Format("select * from `c#_store`.user_supplier"); MySqlCommand comm11 = new MySqlCommand(sql1, conn); MySqlDataAdapter sda11 = new MySqlDataAdapter(); sda11.SelectCommand = comm11; //数据集 DataSet ds11 = new DataSet(); sda11.Fill(ds11, "stock_store"); dataGridView1.DataSource = ds11.Tables[0]; dataGridView1.Columns[0].HeaderText = "id"; dataGridView1.Columns[1].HeaderText = "订单人"; } catch (Exception e) { Console.WriteLine(e); MessageBox.Show(e.Message.ToString()); } finally { conn.Close(); } }
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(); } }
public void selectall2() { Database2 db = new Database2(); MySqlConnection conn = db.getConn(); try { conn.Open(); String sql11 = String.Format("select * from stock_store"); MySqlCommand comm11 = new MySqlCommand(sql11, conn); MySqlDataAdapter sda11 = new MySqlDataAdapter(); sda11.SelectCommand = comm11; //数据集 DataSet ds11 = new DataSet(); sda11.Fill(ds11, "stock_store"); dataGridView2.DataSource = ds11.Tables[0]; dataGridView2.Columns[0].HeaderText = "id"; dataGridView2.Columns[1].HeaderText = "商品名"; dataGridView2.Columns[2].HeaderText = "价格"; dataGridView2.Columns[3].HeaderText = "数量"; } catch (Exception e1) { MessageBox.Show(e1.Message.ToString()); } finally { conn.Close(); } }
private void add2_Click(object sender, EventArgs e) { Database2 db = new Database2(); MySqlConnection conn = db.getConn(); try { conn.Open(); int index = dataGridView1.CurrentRow.Index; String value0 = dataGridView1.Rows[index].Cells[0].Value.ToString(); String value1 = dataGridView1.Rows[index].Cells[1].Value.ToString(); String value2 = dataGridView1.Rows[index].Cells[2].Value.ToString(); String value3 = dataGridView1.Rows[index].Cells[3].Value.ToString(); String sql = String.Format( "insert into stock_store (stock_id,stock_shop_name,stock_shop_price,stock_shop_number) values('{0}','{1}','{2}','{3}')", value0, value1 , value2, value3); MySqlCommand comm = new MySqlCommand(sql, conn); comm.ExecuteNonQuery(); MessageBox.Show("插入成功"); Form1.form1.库存管理ToolStripMenuItem_Click(null, null); } catch (Exception exception) { Console.WriteLine(exception); MessageBox.Show(exception.Message.ToString() + "数据库打开失败"); } finally { conn.Close(); } }
private void deleteone_Click(object sender, EventArgs e) { Database2 db = new Database2(); MySqlConnection conn = db.getConn(); try { conn.Open(); int index = dataGridView1.CurrentRow.Index; String value = dataGridView1.Rows[index].Cells[0].Value.ToString(); String sql = String.Format("delete from stock_store where stock_id = '{0}'", value); MySqlCommand comm = new MySqlCommand(sql, conn); comm.ExecuteNonQuery(); MessageBox.Show("删除成功"); Form1.form1.库存管理ToolStripMenuItem_Click(null, null); } catch (Exception exception) { Console.WriteLine(exception); MessageBox.Show(exception.Message.ToString() + "数据库打开失败"); } finally { conn.Close(); } }
private void button1_Click(object sender, EventArgs e) { String username = this.textBox1.Text; String password = this.textBox2.Text; Database2 db2 = new Database2(); MySqlConnection conn = db2.getConn(); if (username.Equals("") || password.Equals("")) { MessageBox.Show("账号密码为空"); } else { try { conn.Open(); String sql1 = String.Format("select * from `c#_store`.user_store where username= '******'", username); MySqlCommand comm1 = new MySqlCommand(sql1, conn); String sql2 = String.Format("insert into `c#_store`.user_store (username,password) values ('{0}','{1}')", username, password); MySqlCommand comm2 = new MySqlCommand(sql2, conn); if (Convert.ToInt32(comm1.ExecuteScalar()) > 0) { MessageBox.Show("账号已经注册,请登录"); login l = new login(); l.Show(); this.Hide(); } else { comm2.ExecuteNonQuery(); MessageBox.Show("注册成功"); login l = new login(); l.Show(); this.Hide(); } } catch (Exception exception) { Console.WriteLine(exception); } finally { conn.Close(); } } }
public void select() { Database2 db = new Database2(); MySqlConnection conn = db.getConn(); try { conn.Open(); String sql = String.Format( "select outbound_id,outbound_shop_name,outbound_shop_price,outbound_shop_number,outbound_to_person,outbound_to_phone,outbound_to_address,outbound_data,c.username from outbound o,user_customer c where o.out_user_id = c.id "); MySqlCommand comm = new MySqlCommand(sql, conn); MySqlDataAdapter sda = new MySqlDataAdapter(); sda.SelectCommand = comm; //数据集 DataSet ds = new DataSet(); sda.Fill(ds, "outbound"); dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Columns[0].HeaderText = "id"; dataGridView1.Columns[1].HeaderText = "商品名"; dataGridView1.Columns[2].HeaderText = "价格"; dataGridView1.Columns[3].HeaderText = "数量"; dataGridView1.Columns[4].HeaderText = "收货人"; dataGridView1.Columns[5].HeaderText = "电话"; dataGridView1.Columns[6].HeaderText = "地址"; dataGridView1.Columns[7].HeaderText = "创建时间"; dataGridView1.Columns[8].HeaderText = "订单人"; } catch (Exception e) { Console.WriteLine(e); MessageBox.Show(e.Message.ToString()); } finally { conn.Close(); } }
public void selectall3() { Database2 db = new Database2(); MySqlConnection conn = db.getConn(); try { conn.Open(); String sql = String.Format( "select m.manu_id, manu_shop_name, manu_shop_price, manu_shop_number, manu_re_person, manu_re_phone, manu_re_address, manu_data, s.username from `c#_store`.manu m,`c#_store`.user_supplier s where m.manu_out_user = s.id"); MySqlCommand comm = new MySqlCommand(sql, conn); MySqlDataAdapter sda = new MySqlDataAdapter(); sda.SelectCommand = comm; //数据集 DataSet ds = new DataSet(); sda.Fill(ds, "stock_store"); dataGridView3.DataSource = ds.Tables[0]; dataGridView3.Columns[0].HeaderText = "id"; dataGridView3.Columns[1].HeaderText = "商品名"; dataGridView3.Columns[2].HeaderText = "价格"; dataGridView3.Columns[3].HeaderText = "数量"; dataGridView3.Columns[4].HeaderText = "收货人"; dataGridView3.Columns[5].HeaderText = "电话"; dataGridView3.Columns[6].HeaderText = "地址"; dataGridView3.Columns[7].HeaderText = "创建时间"; dataGridView3.Columns[8].HeaderText = "订单人"; } catch (Exception e) { Console.WriteLine(e); MessageBox.Show(e.Message.ToString()); } finally { conn.Close(); } }
private void update11_Click(object sender, EventArgs e) { Database2 db = new Database2(); MySqlConnection conn = db.getConn(); try { conn.Open(); int index = dataGridView1.CurrentRow.Index; String value0 = dataGridView1.Rows[index].Cells[0].Value.ToString(); String value1 = dataGridView1.Rows[index].Cells[1].Value.ToString(); String value2 = dataGridView1.Rows[index].Cells[2].Value.ToString(); String value3 = dataGridView1.Rows[index].Cells[3].Value.ToString(); String value4 = dataGridView1.Rows[index].Cells[4].Value.ToString(); String value5 = dataGridView1.Rows[index].Cells[5].Value.ToString(); String value6 = dataGridView1.Rows[index].Cells[6].Value.ToString(); String value7 = dataGridView1.Rows[index].Cells[7].Value.ToString(); String sql = String.Format( "update outbound set outbound_shop_name = '{0}',outbound_shop_price='{1}',outbound_shop_number='{2}',outbound_to_person='{3}',outbound_to_phone = '{4}',outbound_to_address = '{5}',outbound_data='{6}' where outbound_id='{7}'", value1, value2, value3, value4, value5, value6, value7, value0); MySqlCommand comm = new MySqlCommand(sql, conn); comm.ExecuteNonQuery(); MessageBox.Show("修改成功"); } catch (Exception exception) { Console.WriteLine(exception); MessageBox.Show(exception.Message.ToString() + "数据库打开失败"); } finally { conn.Close(); } }
private void button1_Click(object sender, EventArgs e) { String shop_name = this.shop_name_box.Text; String shop_price = this.shop_price_box.Text; String shop_number = this.shop_number_box.Text; Database2 db = new Database2(); MySqlConnection conn = db.getConn(); try { conn.Open(); if (shop_name == "" && shop_price == "" && shop_number == "") { MessageBox.Show("填入信息为空"); } else { if (shop_name != "" && shop_price == "" && shop_number == "") { String sql1 = String.Format("select * from `c#_store`.stock_supplier where `c#_store`.stock_supplier.supplier_shop_name like '%{0}%'", shop_name); MySqlCommand comm = new MySqlCommand(sql1, conn); MySqlDataAdapter sda = new MySqlDataAdapter(); sda.SelectCommand = comm; //数据集 DataSet ds = new DataSet(); sda.Fill(ds, "stock_supplier"); dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Columns[0].HeaderText = "id"; dataGridView1.Columns[1].HeaderText = "商品名"; dataGridView1.Columns[2].HeaderText = "价格"; dataGridView1.Columns[3].HeaderText = "数量"; } else if (shop_name == "" && shop_price != "" && shop_number == "") { String sql1 = String.Format("select * from `c#_store`.stock_supplier where `c#_store`.stock_supplier.supplier_shop_price like '%{0}%'", shop_price); MySqlCommand comm = new MySqlCommand(sql1, conn); MySqlDataAdapter sda = new MySqlDataAdapter(); sda.SelectCommand = comm; //数据集 DataSet ds = new DataSet(); sda.Fill(ds, "stock_supplier"); dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Columns[0].HeaderText = "id"; dataGridView1.Columns[1].HeaderText = "商品名"; dataGridView1.Columns[2].HeaderText = "价格"; dataGridView1.Columns[2].HeaderText = "价格"; dataGridView1.Columns[3].HeaderText = "数量"; } else if (shop_name == "" && shop_price == "" && shop_number != "") { String sql1 = Strings.Format("select * from `c#_store`.stock_supplier group by `c#_store`.stock_supplier.supplier_shop_number having count(*) < '{0}' ", shop_number); MySqlCommand comm = new MySqlCommand(sql1, conn); MySqlDataAdapter sda = new MySqlDataAdapter(); sda.SelectCommand = comm; //数据集 DataSet ds = new DataSet(); sda.Fill(ds, "stock_supplier"); dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Columns[0].HeaderText = "id"; dataGridView1.Columns[1].HeaderText = "商品名"; dataGridView1.Columns[2].HeaderText = "价格"; dataGridView1.Columns[3].HeaderText = "数量"; } else if (shop_name != "" && shop_price != "" && shop_number == "") { String sql1 = String.Format( "select * from `c#_store`.stock_supplier where `c#_store`.stock_supplier.supplier_shop_name like '%{0}%' and `c#_store`.stock_supplier.supplier_shop_price like '%{1}%'", shop_name, shop_price); MySqlCommand comm = new MySqlCommand(sql1, conn); MySqlDataAdapter sda = new MySqlDataAdapter(); sda.SelectCommand = comm; //数据集 DataSet ds = new DataSet(); sda.Fill(ds, "stock_supplier"); dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Columns[0].HeaderText = "id"; dataGridView1.Columns[1].HeaderText = "商品名"; dataGridView1.Columns[2].HeaderText = "价格"; dataGridView1.Columns[3].HeaderText = "数量"; } else if (shop_name != "" && shop_price == "" && shop_number != "") { String sql1 = String.Format( "select * from `c#_store`.stock_supplier where `c#_store`.stock_supplier.supplier_shop_name like '%{0}%' and `c#_store`.stock_supplier.supplier_shop_number like '%{1}%'", shop_name, shop_number); MySqlCommand comm = new MySqlCommand(sql1, conn); MySqlDataAdapter sda = new MySqlDataAdapter(); sda.SelectCommand = comm; //数据集 DataSet ds = new DataSet(); sda.Fill(ds, "stock_supplier"); dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Columns[0].HeaderText = "id"; dataGridView1.Columns[1].HeaderText = "商品名"; dataGridView1.Columns[2].HeaderText = "价格"; dataGridView1.Columns[3].HeaderText = "数量"; } else if (shop_name == "" && shop_price != "" && shop_number != "") { String sql1 = String.Format( "select * from `c#_store`.stock_supplier where `c#_store`.stock_supplier.supplier_shop_name like '%{0}%' and `c#_store`.stock_supplier.supplier_shop_price like '%{1}%'", shop_name, shop_price); MySqlCommand comm = new MySqlCommand(sql1, conn); MySqlDataAdapter sda = new MySqlDataAdapter(); sda.SelectCommand = comm; //数据集 DataSet ds = new DataSet(); sda.Fill(ds, "stock_supplier"); dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Columns[0].HeaderText = "id"; dataGridView1.Columns[1].HeaderText = "商品名"; dataGridView1.Columns[2].HeaderText = "价格"; dataGridView1.Columns[3].HeaderText = "数量"; } else { String sql1 = String.Format( "select * from `c#_store`.stock_supplier where `c#_store`.stock_supplier.supplier_shop_name like '%{0}%' and `c#_store`.stock_supplier.supplier_shop_price like '%{1}%' and `c#_store`.stock_supplier.supplier_shop_number like '%{2}%'", shop_name, shop_price, shop_number); MySqlCommand comm = new MySqlCommand(sql1, conn); MySqlDataAdapter sda = new MySqlDataAdapter(); sda.SelectCommand = comm; //数据集 DataSet ds = new DataSet(); sda.Fill(ds, "stock_supplier"); dataGridView1.DataSource = ds.Tables[0]; dataGridView1.Columns[0].HeaderText = "id"; dataGridView1.Columns[1].HeaderText = "商品名"; dataGridView1.Columns[2].HeaderText = "价格"; dataGridView1.Columns[3].HeaderText = "数量"; } } } catch (Exception exception) { Console.WriteLine(exception); MessageBox.Show(exception.Message.ToString()); } finally { conn.Close(); } }
private void submit1_Click(object sender, EventArgs e) { Database2 db = new Database2(); MySqlConnection conn = db.getConn(); try { conn.Open(); String sql = String.Format("select count(*) from outbound "); MySqlCommand comm = new MySqlCommand(sql, conn); int out_bound_num = Convert.ToInt32(comm.ExecuteScalar()); if (out_bound_num > 0) { for (int i = 1; i <= out_bound_num; i++) { String sql1 = String.Format("select * from outbound limit {0}", i.ToString()); MySqlCommand comm1 = new MySqlCommand(sql1, conn); MySqlDataAdapter sda = new MySqlDataAdapter(); sda.SelectCommand = comm1; //数据集 DataSet ds = new DataSet(); sda.Fill(ds, "outbound"); String shop_name = ds.Tables[0].Rows[0]["OUTBOUND_SHOP_NAME"].ToString().Trim(); String shop_number = ds.Tables[0].Rows[0]["outbound_shop_number"].ToString().Trim(); String sql2 = String.Format("select * from stock_store where stock_shop_name = '{0}'", shop_name); MySqlCommand comm2 = new MySqlCommand(sql2, conn); MySqlDataAdapter sda1 = new MySqlDataAdapter(); sda1.SelectCommand = comm2; DataSet ds1 = new DataSet(); sda1.Fill(ds1, "stock_store"); if (Convert.ToInt32(comm2.ExecuteScalar()) > 0) { String stock_number = ds1.Tables[0].Rows[0]["stock_shop_number"].ToString().Trim(); if (Convert.ToInt32(stock_number) > Convert.ToInt32(shop_number)) { String stock_sql = String.Format( "update stock_store set stock_shop_number = '{0}'-'{1}' where stock_shop_name = '{2}'", stock_number, shop_number, shop_name); MySqlCommand comm_stock_sql = new MySqlCommand(stock_sql, conn); int stock_sql_num1 = comm_stock_sql.ExecuteNonQuery(); if (stock_sql_num1 > 0) { String outbound_sql = String.Format("delete from outbound where outbound_shop_name = '{0}'", shop_name); MySqlCommand comm_outbound_sql = new MySqlCommand(outbound_sql, conn); int out_sql_num = comm_outbound_sql.ExecuteNonQuery(); if (out_sql_num > 0) { db.insert_to("出库订单更新成功"); MessageBox.Show("订单更新成功"); } else { db.insert_to("订单更新失败"); MessageBox.Show("订单更新失败"); } } else { db.insert_to("请求订单失败"); MessageBox.Show("请求订单失败"); } } else { db.insert_to("库存不足"); MessageBox.Show("库存不足"); String num2 = Interaction.InputBox("库存剩余量" + stock_number + ",是否选择选择剩余库存量进行提交", "订单处理", "", 3, 3); if (num2 == "") { db.insert_to("该订单请求已经取消"); MessageBox.Show("该订单请求已经取消"); } else { String sql3 = String.Format( "update stock_store set stock_shop_number = '{0}'-'{1}' where stock_shop_name = '{2}' ", stock_number, num2, shop_name); MySqlCommand comm3 = new MySqlCommand(sql3, conn); int num = comm3.ExecuteNonQuery(); if (num > 0) { String sql5 = String.Format( "update outbound set outbound_shop_number = '{0}'-'{1}' where outbound_shop_name = '{2}'", shop_number, num2, shop_name); MySqlCommand comm5 = new MySqlCommand(sql5, conn); int num5 = comm5.ExecuteNonQuery(); if (num5 > 0) { db.insert_to("出库订单更新成功"); MessageBox.Show("该订单提交成功"); } else { db.insert_to("该订单提交失败"); MessageBox.Show("该订单提交失败"); } } else { db.insert_to("订单处理失败"); MessageBox.Show("订单处理失败"); // String sql4 = String.Format("update stock_store set stock_number = {0}+{1} where stock_shop_name = '{2}' ",stock_number,shop_number,shop_name); // MySqlCommand comm4 = new MySqlCommand(sql4,conn); // int num4 = comm4.ExecuteNonQuery(); // if (num4>0) // { // // } // else // { // MessageBox.Show(""); // } } } } } else { db.insert_to("无订单库存"); MessageBox.Show("无该订单库存"); } } } else { db.insert_to("处理订单为空"); 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(); } }
private void delete1_Click(object sender, EventArgs e) { Database2 db = new Database2(); MySqlConnection conn = db.getConn(); try { String name = Interaction.InputBox("商品名", "删除", "", 3, 3); if (name == "") { MessageBox.Show("输入为空"); } else { conn.Open(); String sql = String.Format("select stock_shop_number from stock_store where stock_shop_name = '{0}'", name); String sql2 = String.Format("select * from stock_store where stock_shop_name = '{0}'", name); MySqlCommand comm1 = new MySqlCommand(sql, conn); MySqlCommand comm = new MySqlCommand(sql2, conn); int num3 = Convert.ToInt32(comm.ExecuteScalar()); if (num3 > 0) { int numbers = Convert.ToInt32(comm1.ExecuteScalar()); if (numbers < 5 && numbers > 0) { MessageBox.Show(name + "库存仅剩" + numbers.ToString() + "请及时进货"); } else { MessageBox.Show(name + "剩余数量为" + numbers.ToString()); } String num2 = Interaction.InputBox("要删除数量", "删除", "", 3, 3); int num22 = Convert.ToInt32(num2); if (num22 >= numbers) { MessageBox.Show("删除商品数量够多,库存不足"); } else { String sql3 = String.Format( "update stock_store set stock_shop_number= '{0}' where stock_shop_name='{1}'", (numbers - num22).ToString(), name); MySqlCommand COMM = new MySqlCommand(sql3, conn); int num4 = COMM.ExecuteNonQuery(); if (num4 > 0) { MessageBox.Show("删除成功"); Form1.form1.库存管理ToolStripMenuItem_Click(null, null); } else { MessageBox.Show("删除失败"); } } } else { MessageBox.Show("该商品已无"); } } } catch (Exception exception) { Console.WriteLine(exception); MessageBox.Show(exception.Message.ToString()); } finally { conn.Close(); } }
//添加库存 private void add1_Click(object sender, EventArgs e) { Database2 db = new Database2(); MySqlConnection conn = db.getConn(); try { string shop_name = Interaction.InputBox("商品名", "添加库存信息", "", 3, 3); if (shop_name == "") { MessageBox.Show("填写为空 "); } else { conn.Open(); String sql2 = String.Format("select * from `c#_store`.stock_supplier where `c#_store`.stock_supplier.supplier_shop_name = '{0}' ", shop_name); MySqlCommand comm1 = new MySqlCommand(sql2, conn); if (Convert.ToInt32(comm1.ExecuteScalar()) > 0) { string shop_number = Interaction.InputBox("商品数量", "添加库存信息", "", 3, 3); int nums = Convert.ToInt32(shop_number); if (shop_number == "") { MessageBox.Show("输入的数量为空"); } else { String sql4 = String.Format("select `c#_store`.stock_supplier.supplier_shop_number from `c#_store`.stock_supplier where `c#_store`.stock_supplier.supplier_shop_name = '{0}'", shop_name); String sql5 = String.Format("select `c#_store`.stock_supplier.supplier_shop_price from `c#_store`.stock_supplier where `c#_store`.stock_supplier.supplier_shop_name = '{0}'", shop_name); MySqlCommand comm3 = new MySqlCommand(sql4, conn); MySqlCommand comm5 = new MySqlCommand(sql5, conn); int numbers = Convert.ToInt32(comm3.ExecuteScalar()); String sql3 = String.Format( "update `c#_store`.stock_supplier set `c#_store`.stock_supplier.supplier_shop_number='{2}' where `c#_store`.stock_supplier.supplier_shop_name='{0}' ", shop_name, comm5.ExecuteNonQuery().ToString(), (numbers + nums).ToString()); MySqlCommand comm4 = new MySqlCommand(sql3, conn); int num1 = comm4.ExecuteNonQuery(); if (num1 > 0) { MessageBox.Show("插入成功"); selectall(); } else { MessageBox.Show("插入失败"); } } } else { string shop_price2 = Interaction.InputBox("商品价格", "添加库存信息", "", 3, 3); string shop_number2 = Interaction.InputBox("商品数量", "添加库存信息", "", 3, 3); if (shop_price2 == "" || shop_number2 == "") { MessageBox.Show("输入为空"); } else { String sql = String.Format( "insert into `c#_store`.stock_supplier (`c#_store`.stock_supplier.supplier_shop_name,`c#_store`.stock_supplier.supplier_shop_price,`c#_store`.stock_supplier.supplier_shop_number) values ('{0}','{1}','{2}')", shop_name, shop_price2, shop_number2); MySqlCommand comm = new MySqlCommand(sql, conn); int num = comm.ExecuteNonQuery(); if (num > 0) { MessageBox.Show("插入成功"); selectall(); } else { MessageBox.Show("插入失败"); } } } } } catch (Exception exception) { Console.WriteLine(exception); MessageBox.Show(exception.Message.ToString()); } finally { conn.Close(); } }
private void button1_Click(object sender, EventArgs e) { String username = this.textBox1.Text; String password = this.textBox2.Text; Database2 db = new Database2(); MySqlConnection conn = db.getConn(); if (username.Equals("") || password.Equals("")) { MessageBox.Show("账号或密码为空"); } else { try { conn.Open(); String sql1 = String.Format("select * from `c#_store`.user_store where username= '******' ", username); MySqlCommand comm2 = new MySqlCommand(sql1, conn); if (Convert.ToInt32(comm2.ExecuteScalar()) > 0) { String sql = String.Format("select username,password from `c#_store`.user_store where username = '******' limit 1", username); MySqlCommand comm1 = new MySqlCommand(sql, conn); MySqlDataReader reader = comm1.ExecuteReader(); while (reader.Read()) { String username1 = reader[0].ToString(); String password1 = reader[1].ToString(); if (username1 != null && password.Equals(password1)) { // db.insert(sql); Form1 form1 = new Form1(); form1.username = username; db.insert("登录成功"); MessageBox.Show("登录成功"); this.Hide(); form1.Show(); } else { db.insert("登录失败"); MessageBox.Show("密码错误,请重新输入"); } } reader.Close(); } else { MessageBox.Show("账户不存在,请注册"); register r = new register(); r.Show(); this.Hide(); } } catch (Exception exception) { Console.WriteLine(exception); MessageBox.Show(exception.Message.ToString()); } finally { conn.Close(); } } }
private void createbox1_Click(object sender, EventArgs e) { String ord_name = this.ord_name.Text; Database2 db = new Database2(); MySqlConnection conn = db.getConn(); String shop_name = this.shop_name.Text; String shop_price = this.pricebox.Text; String shop_number = this.numberbox.Text; String person = this.person.Text; String phone = this.phonebox.Text; String address = this.addressbox.Text; if (ord_name == "" || shop_name == "" || shop_price == "" || shop_number == "" || person == "" || phone == "" || address == "") { MessageBox.Show("输入为空"); } else { try { conn.Open(); String sql = String.Format("select * from `c#_store`.user_customer where username = '******'", ord_name); MySqlCommand comm = new MySqlCommand(sql, conn); if (Convert.ToInt32(comm.ExecuteScalar()) > 0) { MessageBox.Show("该用户已存入系统,将更新订单"); String sql6 = String.Format("select id from `c#_store`.user_customer where username = '******'", ord_name); String sql7 = String.Format("select * from `c#_store`.outbound where outbound_shop_name='{0}'", shop_name); MySqlCommand comm6 = new MySqlCommand(sql6, conn); MySqlCommand COMM7 = new MySqlCommand(sql7, conn); int num6 = comm6.ExecuteNonQuery(); int num7 = Convert.ToInt32(COMM7.ExecuteScalar()); //该用户的该订单商品存在 if (num7 > 0) { String num = Interaction.InputBox("添加商品数量", "添加", "", 3, 3); String sql8 = String.Format( "update `c#_store`.outbound set outbound_shop_number= outbound_shop_number+ '{0}' ,outbound_data='{1}'", num, DateTime.Now.ToString()); MySqlCommand comm8 = new MySqlCommand(sql8, conn); int num8 = comm8.ExecuteNonQuery(); if (num8 > 0) { MessageBox.Show("更新订单成功"); } else { MessageBox.Show("更新订单失败"); } } else { MessageBox.Show("该订单不存在"); String sql10 = String.Format("select id from `c#_store`.user_customer where username = '******'", ord_name); MySqlCommand comm10 = new MySqlCommand(sql10, conn); int num10 = Convert.ToInt32(comm10.ExecuteScalar()); String sql9 = String.Format( "insert into `c#_store`.outbound (outbound_shop_name, outbound_shop_price, outbound_shop_number, outbound_to_person, outbound_to_phone, outbound_to_address, outbound_data, out_user_id) VALUES ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}')", shop_name, shop_price, shop_number, person, phone, address, DateTime.Now.ToString(), num10.ToString()); MySqlCommand comm9 = new MySqlCommand(sql9, conn); int num9 = comm9.ExecuteNonQuery(); if (num9 > 0) { MessageBox.Show("订单更新成功"); } else { MessageBox.Show("订单更新失败"); } } } else { MessageBox.Show("该用户为新用户,将注册"); String sql2 = String.Format(" insert into `c#_store`.user_customer (username) values ('{0}') ", ord_name); MySqlCommand comm2 = new MySqlCommand(sql2, conn); comm2.ExecuteNonQuery(); String sql4 = String.Format("select id from `c#_store`.user_customer where username = '******'", ord_name); MySqlCommand comm4 = new MySqlCommand(sql4, conn); int num = Convert.ToInt32(comm4.ExecuteScalar()); if (num > 0) { String sql3 = String.Format( "insert into `c#_store`.outbound (outbound_shop_name, outbound_shop_price, outbound_shop_number, outbound_to_person, outbound_to_phone, outbound_to_address, outbound_data,out_user_id) values ('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}') ", shop_name, shop_price, shop_number, person, phone, address, DateTime.Now.ToString(), num.ToString()); MySqlCommand comm3 = new MySqlCommand(sql3, conn); int num3 = comm3.ExecuteNonQuery(); if (num3 > 0) { MessageBox.Show("添加订单成功"); } else { MessageBox.Show("添加订单失败"); } } else { MessageBox.Show("添加订单失败"); string sql5 = String.Format("delete from `c#_store`.user_customer where username='******'", ord_name); MySqlCommand comm5 = new MySqlCommand(sql5, conn); comm5.ExecuteNonQuery(); } } } catch (Exception exception) { Console.WriteLine(exception); MessageBox.Show(exception.Message.ToString()); } finally { conn.Close(); } } }