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 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(); } }
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(); } }
/// <summary> /// 构造方法 /// </summary> /// <param name="source">数据库类型</param> /// <param name="connectString">数据库连接字符串</param> /// <param name="sql">SQL 语句</param> /// <param name="formateArguments">起始链接格式化参数</param> /// <param name="formateStrings">起始链接格式化模版</param> public DbRequestBuilder(Database2 source, string connectString, string sql, string[] formateArguments, params string[] formateStrings) { switch (source) { case Database2.MySql: { _connectionStringSettings = new ConnectionStringSettings("MySql", connectString, "MySql.Data.MySqlClient"); break; } case Database2.SqlServer: { _connectionStringSettings = new ConnectionStringSettings("SqlServer", connectString, "System.Data.SqlClient"); break; } default: { throw new SpiderException($"Database {source} is unsported right now"); } } _sql = sql; _formateStrings = formateStrings; _formateArguments = formateArguments; }
/// <summary> /// Create <see cref="ConnectionStringSettings"/> instance. /// </summary> /// <summary xml:lang="zh-CN"> /// 创建数据库配置对象 /// </summary> /// <param name="source">数据库 <see cref="Database"/></param> /// <param name="connectString">连接字符串</param> /// <returns>数据库配置对象 <see cref="ConnectionStringSettings"/></returns> public static ConnectionStringSettings GetConnectionStringSettings(Database2 source, string connectString) { switch (source) { case Database2.MySql: { return(new ConnectionStringSettings("MySql", connectString, DbProviderFactories.MySqlProvider)); } case Database2.SqlServer: { return(new ConnectionStringSettings("SqlServer", connectString, DbProviderFactories.SqlServerProvider)); } case Database2.PostgreSql: { return(new ConnectionStringSettings("PostgreSql", connectString, DbProviderFactories.PostgreSqlProvider)); } default: { throw new SpiderException($"Unsported databse: {source}"); } } }
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 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 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 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(); } }
/// <summary> /// Create <see cref="DbConnection"/> instance. /// </summary> /// <summary xml:lang="zh-CN"> /// 创建连接对象 /// </summary> /// <param name="source"><see cref="Database"/></param> /// <param name="connectString"></param> /// <returns></returns> public static DbConnection CreateDbConnection(Database2 source, string connectString) { DbProviderFactory factory; switch (source) { case Database2.MySql: { factory = DbProviderFactories.GetFactory(DbProviderFactories.MySqlProvider); break; } case Database2.SqlServer: { factory = DbProviderFactories.GetFactory(DbProviderFactories.SqlServerProvider); break; } case Database2.PostgreSql: { factory = DbProviderFactories.GetFactory(DbProviderFactories.PostgreSqlProvider); break; } default: { throw new SpiderException($"Unsported database: {source}"); } } for (int i = 0; i < 5; ++i) { try { var connection = factory.CreateConnection(); if (connection != null) { connection.ConnectionString = connectString; connection.Open(); return(connection); } } catch (Exception e) { if (e.Message.ToLower().StartsWith("authentication to host")) { Log.Logger.Error($"{e}"); Thread.Sleep(1000); } else { throw; } } } throw new SpiderException("Create connection failed"); }
public void AddDatabase(Database2 database) { if (database != null) { if (!HasDatabase(database.Name)) { _databases.Add(database); _storageManager.AddNewDatabase(database); } } else { throw new ArgumentNullException(nameof(database)); } }
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 bool UserAction(string userName, Restrictions action) { lock (Database.lockObjectDB) { if (userName.Length == 0) { return(false); } if (userName == "AkBarsAdmin" || userName == "UzcardAdmin") { if (action == Restrictions.Transport) { return(false); } return(true); } //любая страница начинается здесь, поэтому здесь проверяем на активность коннекта if (Database.Conn == null || Database.Conn.State != ConnectionState.Open) { Database.Connect(ConfigurationManager.ConnectionStrings["ConString"].ConnectionString); FormsAuthentication.SignOut(); FormsAuthentication.RedirectToLoginPage(); } if (Database2.Conn == null || Database2.Conn.State != ConnectionState.Open) { Database2.Connect(ConfigurationManager.ConnectionStrings["ConString"].ConnectionString); } object obj = null; string res = Database.ExecuteScalar($"select activepassword from aspnet_Users where username='******'", ref obj, null); if (!(bool)obj) { return(false); } res = Database.ExecuteScalar(String.Format("select count(*) from V_UserAction where UserName='******' and ActionId={1}", userName, (int)action), ref obj, null); return((int)obj > 0); } }
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(); } }
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(); } }
private async Task CouQueryComplete(IDialogContext context, IAwaitable <CouQueryForm> result) { CouQueryForm form = null; try { form = await result; } catch (OperationCanceledException) { } if (form != null) { List <Course> courses = Database2.GetCourse(form.CourseName); if (courses == null || courses.Count == 0) { await context.PostAsync($"Sorry, could not find Course for {form.CourseName} "); return; } StringBuilder sb2 = new StringBuilder(); sb2.Append($"Hi There! I was able to find **{courses.Count.ToString()}** Courses \n\n"); sb2.Append("--\n\n"); foreach (Course course in courses) { sb2.Append($"Course ID is **{course.CourseID}**;\n Course Name is **{course.CourseName}**;\n Course Department is **{course.Department}**; \n Course Level is **{course.Level}**;\n Course Intake is **{course.Intake}**; \n Course will have **{course.Assignments}** Assignments; \n Course is divided in following way \n Attendance **{course.Attendance}** %; \n Class Participation **{course.CP}** %; \n Exam 1 **{course.Exam1}** %; \n Exam2 **{course.Exam2}** %; \n Project **{course.Project}**; \n HomeWork **{course.HW}**%"); } var message = $"Looking for courses {form.CourseName} "; // var message1 = $"Looking for students {form.courseID}"; await context.PostAsync(sb2.ToString()); } context.Wait(MessageReceived); }
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 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(); } } }
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 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 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 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 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 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(); } }