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