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();//关闭数据库连接
}
}
}
