1.Form1
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
namespace SCUT2018
{
public partial class Form1 : Form
{
private DB db;
public Form1()
{
InitializeComponent();
db = new DB();
}
private void Form1_Load(object sender, EventArgs e)
{
tabPage1_Click(sender, e);
}
//选项卡改变事件
private void tabControl1_SelectedChanged(object sender, EventArgs e)
{
if (tabControl1.SelectedIndex == 0)
{
tabPage1_Click(sender, e);
}
else if (tabControl1.SelectedIndex == 1)
{
tabPage2_Click(sender, e);
}
else if (tabControl1.SelectedIndex == 2)
{
tabPage3_Click(sender, e);
}
}
//1查询
private void tabPage1_Click(object sender, EventArgs e)
{
dataGridView1.DataSource = db.getBySql(@"select businessman.busno as 经销商, businessman.busname as 经销商名, [order].good as 商品名称
from businessman, [order]
where businessman.busNo = [order].busNo ");
DataTable table = db.getBySql("select * from BusinessMan");
comboBox1.DataSource = table;
comboBox1.DisplayMember = "busNo";
comboBox1.ValueMember = "busNo";
comboBox2.DataSource = table;
comboBox2.DisplayMember = "busName";
comboBox2.ValueMember = "busName";
comboBox3.DataSource = db.getBySql("select * from [Order]");
comboBox3.DisplayMember = "good";
comboBox3.ValueMember = "good";
}
//2统计
private void tabPage2_Click(object sender, EventArgs e)
{
//(1)按地方统计订单金额:
dataGridView2.DataSource = db.getBySql(@"select businessman.city as 城市, sum([order].money) as 订单总金额
from businessman, [order]
where businessman.busNo = [order].busNo
group by businessman.city
order by 订单总金额 asc");
//(2)按经销商统计订单金额(按金额升序排列):
dataGridView3.DataSource = db.getBySql(@"select businessman.busName as 经销商, sum([order].money) as 订单总金额
from businessman, [order]
where businessman.busNo = [order].busNo
group by businessman.busNo, businessman.busName
order by 订单总金额 asc
");
}
//3数据维护
private void tabPage3_Click(object sender, EventArgs e)
{
DataTable table = db.getBySql(@"select * from BusinessMan");
dataGridView4.DataSource = table;
dataGridView4.Columns[0].HeaderText = "经销商编号";
dataGridView4.Columns[1].HeaderText = "经销商名称";
dataGridView4.Columns[2].HeaderText = "所在城市&#