private void AdminMana_Load(object sender, EventArgs e) { string sql = "select * from admin"; conn = dh.Connection; dh.OpenConnection(); MySqlDataAdapter da = new MySqlDataAdapter(sql, conn); ds = new DataSet(); da.Fill(ds, "adm_adm"); dt = ds.Tables["adm_adm"]; dataGridView1.DataSource = dt.DefaultView; }
//显示数据按钮 private void button3_Click(object sender, EventArgs e) { string sql = "select * from thingsInfo"; conn = dh.Connection; dh.OpenConnection(); MySqlDataAdapter da = new MySqlDataAdapter(sql, conn); ds = new DataSet(); da.Fill(ds, "adm_tsi"); dt = ds.Tables["adm_tsi"]; dataGridView1.DataSource = dt.DefaultView; }
private void OutDayThings_Load(object sender, EventArgs e) { string sql = "SELECT * FROM thingsinfo WHERE endtime <NOW();"; conn = dh.Connection; dh.OpenConnection(); MySqlDataAdapter da = new MySqlDataAdapter(sql, conn); ds = new DataSet(); da.Fill(ds, "adm_adm"); dt = ds.Tables["adm_adm"]; dataGridView1.DataSource = dt.DefaultView; }
private void StockSerch_Load(object sender, EventArgs e) { string sql = "SELECT vnum,name,stock FROM thingsinfo WHERE stock>0;"; conn = dh.Connection; dh.OpenConnection(); MySqlDataAdapter da = new MySqlDataAdapter(sql, conn); ds = new DataSet(); da.Fill(ds, "adm_tsi"); dt = ds.Tables["adm_tsi"]; dataGridView1.DataSource = dt.DefaultView; }
private void button1_Click(object sender, EventArgs e) { if (textBox1.Text == "" || textBox2.Text == "") { MessageBox.Show("密码或账号不能为空", "提示"); } else { string username = textBox1.Text.Trim(); string userpwd = textBox2.Text.Trim(); string sql = "select * from admin where username='******' and pwd='" + userpwd + "'"; conn = dh.Connection; dh.OpenConnection(); cmd = new MySqlCommand(sql, conn); MySqlDataReader sread = cmd.ExecuteReader();//查询语句 try { if (sread.Read()) { MessageBox.Show("登录成功", "登录"); using (MainWin mw = new MainWin()) { this.Hide(); mw.ShowDialog(); this.Dispose(); this.Close(); } } else { MessageBox.Show("用户名或密码错误"); } } catch (Exception e1) { MessageBox.Show(e1.ToString()); } finally { conn.Close(); //关闭连接 conn.Dispose(); //释放连接 } } }
//添加 private void button4_Click(object sender, EventArgs e) { if (Check()) { try { conn = dh.Connection; dh.OpenConnection(); string vnum = textBox1.Text.Trim(); //1编号 string name = textBox2.Text.Trim(); string begintime = textBox3.Text.Trim(); string shortname = textBox4.Text.Trim(); string endtime = textBox5.Text.Trim(); string stock = textBox6.Text.Trim(); string sql = string.Format(@"insert into thingsInfo(vnum,name,shortname,begintime,endtime,stock) values ('{0}','{1}','{2}','{3}','{4}','{5}')", vnum, name, shortname, begintime, endtime, stock); cmd = new MySqlCommand(sql, conn); if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("添加成功! ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); this.Dispose(); } else { MessageBox.Show("添加失败! ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { cmd.Dispose(); dh.CloseConnection();//关闭数据库连接 } } }
//保存 private void button4_Click(object sender, EventArgs e) { if (Check()) { try { conn = dh.Connection; dh.OpenConnection(); string vnum = textBox1.Text.Trim(); string name = textBox2.Text.Trim(); string begintime = textBox3.Text.Trim(); string shortname = textBox4.Text.Trim(); string endtime = textBox5.Text.Trim(); //int stock = 0; string sql = "UPDATE thingsinfo set vnum='" + vnum + "',name='" + name + "',begintime='" + begintime + "',shortname='" + shortname + "',endtime='" + endtime + "'where vnum ='" + vnums + "'"; cmd = new MySqlCommand(sql, conn); if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("修改成功! ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); this.Dispose(); } else { MessageBox.Show("修改失败! ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { cmd.Dispose(); dh.CloseConnection();//关闭数据库连接 } } }
private void button1_Click(object sender, EventArgs e) { if (Check()) { try { conn = dh.Connection; dh.OpenConnection(); string name = textBox1.Text.Trim(); string username = textBox2.Text.Trim(); string pwd = textBox3.Text.Trim(); string id = textBox4.Text.Trim(); string sql = "update admin set name='" + name + "',username='******',pwd='" + pwd + "',id='" + id + "'where name ='" + names + "'"; cmd = new MySqlCommand(sql, conn); if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("修改成功! ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); this.Dispose(); } else { MessageBox.Show("修改失败! ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { cmd.Dispose(); dh.CloseConnection();//关闭数据库连接 } } }
//添加 private void button1_Click(object sender, EventArgs e) { if (Check()) { try { conn = dh.Connection; dh.OpenConnection(); string name = textBox1.Text.Trim(); string username = textBox2.Text.Trim(); string pwd = textBox3.Text.Trim(); string id = textBox4.Text.Trim(); string sql = string.Format(@"insert into admin(name,username,pwd,id) values ('{0}','{1}','{2}','{3}')", name, username, pwd, id); cmd = new MySqlCommand(sql, conn); if (cmd.ExecuteNonQuery() == 1) { MessageBox.Show("添加成功! ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information); this.Close(); this.Dispose(); } else { MessageBox.Show("添加失败! ", "提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } } catch (Exception ex) { MessageBox.Show(ex.Message, "异常提示", MessageBoxButtons.OK, MessageBoxIcon.Error); } finally { cmd.Dispose(); dh.CloseConnection();//关闭数据库连接 } } }