private void button4_Click(object sender, EventArgs e) { string merchant_id = textBox1.Text.ToString(); stall_merchant.Merchant merchant = new stall_merchant.Merchant(); stall_merchant.Stall stall = new stall_merchant.Stall(); if (stall.staffexist(textBox2.Text.ToString())) { if (Convert.ToInt32(textBox2.Text) >= 700000 && Convert.ToInt32(textBox2.Text) <= 799999) { bool result = merchant.updateMerchant(merchant_id, textBox2.Text.ToString(), textBox3.Text.ToString(), textBox4.Text.ToString()); if (result) { merchant.showMerchant(merchant_id); textBox1.Text = merchant_id; textBox2.Text = merchant.staff_id; textBox3.Text = merchant.name; textBox4.Text = merchant.phone_number; MessageBox.Show("sucessful"); } else { MessageBox.Show("failed"); } } else { MessageBox.Show("请输入商家管理员工id"); } } else { MessageBox.Show("请输入正确的员工id"); } }
private void button3_Click(object sender, EventArgs e) //查询摊位信息 { if (textBox1.Text == String.Empty) //输入不能为空 { MessageBox.Show("输入不能为空!"); return; } string stall_id = textBox1.Text.ToString(); stall_merchant.Stall stall = new stall_merchant.Stall(); if (stall.stallexist(stall_id)) { sForm5_search_result f5 = new sForm5_search_result(); bool result = stall.showStall(stall_id); if (result) { { f5.Form5showStall(stall_id, stall.merchant_id, stall.staff_id, stall.area, stall.start_time, stall.end_time, stall.rent_money, stall.price); } this.Hide(); f5.ShowDialog(); this.Close(); } else { MessageBox.Show("failed"); } } else { MessageBox.Show("该摊位不存在"); } }
private void button4_Click(object sender, EventArgs e) //保存信息 { stall_merchant.Merchant merchant = new stall_merchant.Merchant(); stall_merchant.Stall stall = new stall_merchant.Stall(); if (stall.staffexist(textBox2.Text.ToString())) { if (Convert.ToInt32(textBox2.Text.ToString()) >= 700000 && Convert.ToInt32(textBox2.Text.ToString()) <= 799999) { bool result = merchant.addMerchant(textBox2.Text.ToString(), textBox3.Text.ToString(), textBox4.Text.ToString()); if (result) { textBox1.Text = merchant.merchant_id; } else { MessageBox.Show("failed"); } } else { MessageBox.Show("请输入商家管理员工id"); } } else { MessageBox.Show("请输入正确的员工id"); } }
private void button5_Click(object sender, EventArgs e) //结束日期 { DataSet ds = new DataSet(); stall_merchant.Stall stall = new stall_merchant.Stall(); ds = stall.selectStallwithEnd_time(textBox6.Text.ToString(), textBox7.Text.ToString()); dataGridView1.DataSource = ds; dataGridView1.DataMember = "stall"; }
private void button3_Click(object sender, EventArgs e) //标价 { DataSet ds = new DataSet(); stall_merchant.Stall stall = new stall_merchant.Stall(); ds = stall.selectStallwithPrice(textBox3.Text.ToString(), textBox4.Text.ToString()); dataGridView1.DataSource = ds; dataGridView1.DataMember = "stall,quotation"; }
private void button3_Click(object sender, EventArgs e) { DataSet ds = new DataSet(); stall_merchant.Stall stall = new stall_merchant.Stall(); ds = stall.selectQuotation(); dataGridView1.DataSource = ds; dataGridView1.DataMember = "quotation"; }
private void button2_Click(object sender, EventArgs e) //显示所有信息 { this.Hide(); sForm3_allmes f3 = new sForm3_allmes(); stall_merchant.Stall stall = new stall_merchant.Stall(); DataSet ds = new DataSet(); ds = stall.selectStall(); f3.Form3ShowShall(ds); f3.ShowDialog(); this.Close(); }
private void button2_Click(object sender, EventArgs e) //面积 { DataSet ds = new DataSet(); stall_merchant.Stall stall = new stall_merchant.Stall(); if (stall.areaexist(textBox2.Text.ToString())) { ds = stall.selectStallwithArea(textBox2.Text.ToString()); dataGridView1.DataSource = ds; dataGridView1.DataMember = "stall"; } else { MessageBox.Show("该面积的摊位不存在"); } }
private void button7_Click(object sender, EventArgs e) //商家ID { DataSet ds = new DataSet(); stall_merchant.Stall stall = new stall_merchant.Stall(); stall_merchant.Merchant merchant = new stall_merchant.Merchant(); if (merchant.merchantexist(textBox10.Text.ToString())) { ds = stall.selectStallwithMerchant_id(textBox10.Text.ToString()); dataGridView1.DataSource = ds; dataGridView1.DataMember = "stall"; } else { MessageBox.Show("该商家不存在"); } }
private void button4_Click(object sender, EventArgs e) //保存更改 { string warehouse_id = textBox1.Text; stall_merchant.Merchant merchant = new stall_merchant.Merchant(); stall_merchant.Stall stall = new stall_merchant.Stall(); Datebass.Warehouse warehouse = new Datebass.Warehouse(); if (merchant.merchantexist(textBox5.Text) == false) { MessageBox.Show("请输入正确的商家id"); return; } if (Convert.ToInt32(textBox6.Text) >= 500000 && Convert.ToInt32(textBox2.Text) <= 599999) { if (stall.staffexist(textBox6.Text) == false) { MessageBox.Show("请输入正确的员工id"); return; } } else { MessageBox.Show("该员工ID无法管理仓库,请输入正确的员工ID"); return; } bool result = Datebass.Warehouse.UpdateAnEntry(warehouse_id, Convert.ToDouble(textBox2.Text), Convert.ToDouble(textBox3.Text), Convert.ToDouble(textBox4.Text), textBox5.Text, textBox6.Text); if (result) { warehouse.SearchAnEntryByID(warehouse_id); textBox1.Text = warehouse_id; textBox2.Text = warehouse.area.ToString(); textBox3.Text = warehouse.full_capacity.ToString(); textBox4.Text = warehouse.left_capacity.ToString(); textBox5.Text = warehouse.merchant_id; textBox6.Text = warehouse.staff_id; MessageBox.Show("sucessful"); } else { MessageBox.Show("failed"); } }
private void button6_Click(object sender, EventArgs e) //划归员工 { if (textBox9.Text == String.Empty) { MessageBox.Show("输入不能为空!"); return; } stall_merchant.Stall stall = new stall_merchant.Stall(); if (stall.staffexist(textBox9.Text) == false) { MessageBox.Show("请输入正确的员工ID!"); return; } DataSet ds = new DataSet(); ds = Datebass.Warehouse.SearchByStaffID(textBox9.Text); dataGridView1.DataSource = ds; dataGridView1.DataMember = "warehouse"; }
private void button2_Click(object sender, EventArgs e) { stall_merchant.Stall stall = new stall_merchant.Stall(); if (stall.areaexist(textBox1.Text.ToString())) { bool result = stall.updateQuotation(textBox1.Text.ToString(), textBox2.Text.ToString()); if (result) { MessageBox.Show("sucessful"); } else { MessageBox.Show("failed"); } } else { MessageBox.Show("该摊位面积不存在"); } }
private void button4_Click(object sender, EventArgs e) //保存更改 { string stall_id = textBox1.Text.ToString(); stall_merchant.Stall stall = new stall_merchant.Stall(); stall_merchant.Merchant merchant = new stall_merchant.Merchant(); if (merchant.merchantexist(textBox2.Text.ToString()) && stall.staffexist(textBox3.Text.ToString())) { if (Convert.ToInt32(textBox3.Text) >= 600000 && Convert.ToInt32(textBox3.Text) <= 699999) { bool result = stall.updateStall(stall_id, textBox2.Text.ToString(), textBox3.Text.ToString(), textBox4.Text.ToString(), textBox5.Text.ToString(), textBox6.Text.ToString(), textBox7.Text.ToString()); if (result) { stall.showStall(stall_id); textBox1.Text = stall_id; textBox2.Text = stall.merchant_id; textBox3.Text = stall.staff_id; textBox4.Text = stall.area; textBox5.Text = stall.start_time; textBox6.Text = stall.end_time; textBox7.Text = stall.rent_money; textBox8.Text = stall.price; MessageBox.Show("sucessful"); } else { MessageBox.Show("failed"); } } else { MessageBox.Show("请输入摊位管理员工id"); } } else { MessageBox.Show("请输入正确的商家和员工id"); } }
private void button6_Click(object sender, EventArgs e) //员工ID { DataSet ds = new DataSet(); stall_merchant.Stall stall = new stall_merchant.Stall(); if (stall.staffexist(textBox9.Text.ToString())) { if (Convert.ToInt32(textBox9.Text.ToString()) >= 600000 && Convert.ToInt32(textBox9.Text.ToString()) <= 699999) { ds = stall.selectStallwithStaff_id(textBox9.Text.ToString()); dataGridView1.DataSource = ds; dataGridView1.DataMember = "stall"; } else { MessageBox.Show("请输入摊位部门的员工id"); } } else { MessageBox.Show("该员工不存在"); } }
private void button2_Click(object sender, EventArgs e) //员工ID查询 { DataSet ds = new DataSet(); stall_merchant.Merchant merchant = new stall_merchant.Merchant(); stall_merchant.Stall stall = new stall_merchant.Stall(); if (stall.staffexist(textBox1.Text.ToString())) { if (Convert.ToInt32(textBox1.Text) >= 700000 && Convert.ToInt32(textBox1.Text) <= 799999) { ds = merchant.selectMerchantwithStaff_id(textBox1.Text.ToString()); dataGridView1.DataSource = ds; dataGridView1.DataMember = "merchant"; } else { MessageBox.Show("请输入商家管理员工id"); } } else { MessageBox.Show("请输入正确员工id"); } }