private void 管理员账户管理_Load(object sender, EventArgs e)
{
C_conn c1 = new C_conn();
my_conn = c1.get_conn();
my_adapter = new SqlDataAdapter("select * from users", my_conn);
SqlCommandBuilder my_cb = new SqlCommandBuilder(my_adapter);
my_ds = new DataSet();
my_adapter.Fill(my_ds, "users");
my_conn.Close();
my_bind = new BindingSource();
my_bind.DataSource = my_ds;
my_bind.DataMember = "users";
dataGridView1.DataSource = my_bind;
dataGridView1.AllowUserToAddRows = false;
dataGridView1.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
dataGridView1.Columns["userid"].HeaderText = "用户名";
dataGridView1.Columns["userid"].Width = 120;
dataGridView1.Columns["password"].HeaderText = "密码";
dataGridView1.Columns["password"].Width = 120;
dataGridView1.Columns["jobnum"].HeaderText = "职工号";
dataGridView1.Columns["jobnum"].Width = 120;
textBox1.DataBindings.Clear();
textBox2.DataBindings.Clear();
textBox3.DataBindings.Clear();
textBox1.DataBindings.Add("text", my_bind, "userid");
textBox2.DataBindings.Add("text", my_bind, "password");
textBox3.DataBindings.Add("text", my_bind, "jobnum");
}
private void 线路录入_Load(object sender, EventArgs e)
{
C_conn c1 = new C_conn();
my_conn = c1.get_conn();
my_ds = new DataSet();
my_adapter = new SqlDataAdapter("select * from line", my_conn);
my_adapter.Fill(my_ds, "type");
}
private void 乘客录入_Load(object sender, EventArgs e)
{
C_conn c1 = new C_conn();
my_conn = c1.get_conn();
my_ds = new DataSet();
my_adapter = new SqlDataAdapter("select * from bus", my_conn);
my_adapter.Fill(my_ds, "type");
comboBox1.DataSource = my_ds.Tables["type"];
comboBox1.DisplayMember = my_ds.Tables["type"].Columns["num"].ColumnName.ToString();
comboBox1.ValueMember = my_ds.Tables["type"].Columns["num"].ColumnName.ToString();
my_conn.Close();
}
private void Form1_Load(object sender, EventArgs e)
{
C_conn c1 = new C_conn();
my_conn = c1.get_conn();
if (textBox1.Text.Trim() == "")
{
this.pictureBox2.Image = null;
button3.Enabled = false;
button4.Enabled = false;
button5.Enabled = false;
button6.Enabled = false;
button7.Enabled = false;
button8.Enabled = false;
button9.Enabled = false;
}
}
private void 车辆管理系统_驾驶员查询窗口__Load(object sender, EventArgs e)
{
C_conn c1 = new C_conn();
my_conn = c1.get_conn();
textBox4.Enabled = false;
textBox5.Enabled = false;
if (textBox1.Text.Trim() == "")
{
button3.Enabled = false;
button4.Enabled = false;
button5.Enabled = false;
}
my_ds = new DataSet();
my_adapter = new SqlDataAdapter("select * from bus", my_conn);
my_adapter.Fill(my_ds, "type");
comboBox1.DataSource = my_ds.Tables["type"];
comboBox1.DisplayMember = my_ds.Tables["type"].Columns["drivername"].ColumnName.ToString();
comboBox1.ValueMember = my_ds.Tables["type"].Columns["drivername"].ColumnName.ToString();
my_conn.Close();
}
private void 线路管理系统_发到站查询窗口__Load(object sender, EventArgs e)
{
C_conn c1 = new C_conn();
my_conn = c1.get_conn();
textBox1.Enabled = false;
textBox2.Enabled = false;
textBox3.Enabled = false;
textBox4.Enabled = false;
textBox5.Enabled = false;
textBox6.Enabled = false;
textBox7.Enabled = false;
textBox8.Enabled = false;
my_ds = new DataSet();
my_adapter = new SqlDataAdapter("select * from line", my_conn);
my_adapter.Fill(my_ds, "type");
comboBox1.DataSource = my_ds.Tables["type"];
comboBox1.DisplayMember = my_ds.Tables["type"].Columns["busend"].ColumnName.ToString();
comboBox1.ValueMember = my_ds.Tables["type"].Columns["busend"].ColumnName.ToString();
my_conn.Close();
}
private void 旅客管理系统_车辆查询窗口__Load(object sender, EventArgs e)
{
C_conn c1 = new C_conn();
my_conn = c1.get_conn();
if (textBox1.Text.Trim() == "")
{
this.pictureBox2.Image = null;
button3.Enabled = false;
button4.Enabled = false;
button5.Enabled = false;
button6.Enabled = false;
button7.Enabled = false;
button8.Enabled = false;
button9.Enabled = false;
}
my_adapter = new SqlDataAdapter("select id,name,num from peo", my_conn);
my_ds = new DataSet();
my_adapter.Fill(my_ds, "type");
comboBox1.DataSource = my_ds.Tables["type"];
comboBox1.DisplayMember = my_ds.Tables["type"].Columns["num"].ColumnName.ToString();
comboBox1.ValueMember = my_ds.Tables["type"].Columns["num"].ColumnName.ToString();
my_conn.Close();
}
private void 退票系统_Load(object sender, EventArgs e)
{
C_conn c1 = new C_conn();
my_conn = c1.get_conn();
}
