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();
}
}
