private void Form7_Load(object sender, EventArgs e)
{
ClassSqlConnect sel = new ClassSqlConnect();
string showItems;
showItems = ("STAF");
DataSet ds = sel.Select(showItems);
this.DataGridView1.DataSource = ds;
this.DataGridView1.DataMember = "STAFF";
sel.Close();
}
//删除用户按钮事件
private void ButtonDel_Click(object sender, EventArgs e)
{
ClassSqlConnect del = new ClassSqlConnect();
string delItems;
delItems = ("USER" + TextUID1.Text.ToString() + " ");
del.Delete(delItems);
delItems = ("USER");
DataSet ds = del.Select(delItems);
this.DataGridView1.DataSource = ds;
this.DataGridView1.DataMember = "USERS";
del.Close();
}
//删除销售记录按钮事件
private void button4_Click(object sender, EventArgs e)
{
ClassSqlConnect del = new ClassSqlConnect();
string delItems;
delItems = ("SALE" + textBox1.Text.ToString() + "," + textBox5.Text.ToString() + "," + textBox7.Text.ToString() + " ");
del.Delete(delItems);
delItems = ("SALE");
DataSet ds = del.Select(delItems);
this.dataGridView1.DataSource = ds;
this.dataGridView1.DataMember = "SALE";
del.Close();
}
//更新销售记录按钮事件
private void button3_Click(object sender, EventArgs e)
{
ClassSqlConnect upd = new ClassSqlConnect();
string updItems;
updItems = ("SALE" + textBox1.Text.ToString() + "," + textBox2.Text.ToString() + "," + textBox3.Text.ToString() + "," + textBox4.Text.ToString() + ","
+ textBox5.Text.ToString() + "," + textBox6.Text.ToString() + "," + textBox7.Text.ToString() + " ");
upd.Update(updItems);
updItems = ("SALE");
DataSet ds = upd.Select(updItems);
this.dataGridView1.DataSource = ds;
this.dataGridView1.DataMember = "SALE";
upd.Close();
}
//创建销售记录按钮事件
private void button2_Click(object sender, EventArgs e)
{
ClassSqlConnect add = new ClassSqlConnect();
string addItems;
addItems = ("SALE" + textBox1.Text.ToString() + "," + textBox2.Text.ToString() + "," + textBox3.Text.ToString() + "," + textBox4.Text.ToString() + ","
+ textBox5.Text.ToString() + "," + textBox6.Text.ToString() + "," + textBox7.Text.ToString() + " ");
add.Insert(addItems);
addItems = ("SALE");
DataSet ds = add.Select(addItems);
this.dataGridView1.DataSource = ds;
this.dataGridView1.DataMember = "SALE";
add.Close();
}
//修改用户按钮事件
private void ButtonUpd_Click(object sender, EventArgs e)
{
ClassSqlConnect upd = new ClassSqlConnect();
string updItems;
updItems = ("USER" + TextUID1.Text.ToString() + "," + textUName1.Text.ToString()
+ "," + TextUPower1.Text.ToString() + "," + TextUP1.Text.ToString() + " ");
upd.Update(updItems);
updItems = ("USER");
DataSet ds = upd.Select(updItems);
this.DataGridView1.DataSource = ds;
this.DataGridView1.DataMember = "USERS";
upd.Close();
}
//新增用户按钮事件
private void ButtonAdd_Click(object sender, EventArgs e)
{
ClassSqlConnect add = new ClassSqlConnect();
string addItems;
addItems = ("USER" + TextUID1.Text.ToString() + "," + textUName1.Text.ToString()
+ "," + TextUPower1.Text.ToString() + "," + TextUP1.Text.ToString() + " ");
add.Insert(addItems);
addItems = ("USER");
DataSet ds = add.Select(addItems);
this.DataGridView1.DataSource = ds;
this.DataGridView1.DataMember = "USERS";
add.Close();
}
//修改出库记录按钮事件
private void button6_Click(object sender, EventArgs e)
{
ClassSqlConnect upd = new ClassSqlConnect();
string updItems;
updItems = ("OUST" + textBox7.Text.ToString() + "," + textBox8.Text.ToString() + "," + textBox9.Text.ToString() + "," + textBox10.Text.ToString() + " ");
upd.Update(updItems);
updItems = ("OUST");
DataSet ds = upd.Select(updItems);
this.dataGridView2.DataSource = ds;
this.dataGridView2.DataMember = "OUTSTORE";
upd.Close();
}
//窗体加载时显示列表信息
private void Form5_Load(object sender, EventArgs e)
{
ClassSqlConnect sel = new ClassSqlConnect();
string showItems;
showItems = ("INST");
DataSet ds = sel.Select(showItems);
this.dataGridView1.DataSource = ds;
this.dataGridView1.DataMember = "INSTORE";
sel.Close();
showItems = ("OUST");
ds = sel.Select(showItems);
this.dataGridView2.DataSource = ds;
this.dataGridView2.DataMember = "OUTSTORE";
sel.Close();
}
//添加出库记录按钮事件
private void button8_Click(object sender, EventArgs e)
{
ClassSqlConnect add = new ClassSqlConnect();
string addItems;
addItems = ("OUST" + textBox7.Text.ToString() + "," + textBox8.Text.ToString() + "," + textBox9.Text.ToString()
+ "," + textBox10.Text.ToString() + " ");
add.Insert(addItems);
addItems = ("OUST");
DataSet ds = add.Select(addItems);
this.dataGridView2.DataSource = ds;
this.dataGridView2.DataMember = "OUTSTORE";
add.Close();
}
