private void btnLogin_Click(object sender, EventArgs e)
{
if (txtName.Text == "PJ" && txtPwdP.Text == "123")
{
FormMain fm = new FormMain();
fm.Show();
}
else if (txtName.Text != null && txtPwdP.Text != null)
{
string sql = @"SELECT [EmpID]
,[DName]
,[Sex]
,[Age]
,[Tel]
,[Pwd]
FROM [test2011].[dbo].[Driver]
WHERE DName=@DName and Pwd=@Pwd";
SqlParameter[] para = { new SqlParameter("@DName", txtName.Text),
new SqlParameter("@Pwd", txtPwdP.Text) };
DataTable dt = DBHelperSQL.TableSelect(sql, para);
if (dt != null)
{
FormDriver fd = new FormDriver(txtName.Text, txtPwdP.Text);
fd.Show();
}
else
{
MessageBox.Show("登录失败！\n请检查用户名和密码！");
}
}
else
{
MessageBox.Show("登录失败！");
}
}
private void btnBSearch_Click(object sender, EventArgs e)
{
string sql = "select * from Buses where BusID=@BusID or Supplier=@Supplier";
SqlParameter[] para = { new SqlParameter("@BusID", txtBusID.Text),
new SqlParameter("@Supplier", txtSupplier.Text) };
dvB.DataSource = DBHelperSQL.TableSelect(sql, para);
}
private void btnStatistics_Click(object sender, EventArgs e)
{
string sql = @"select EmpID,COUNT(*) 发车次数
from Timetable
group by EmpID";
dvStatistics.DataSource = DBHelperSQL.TableSelect(sql);
}
private void btnS2_Click(object sender, EventArgs e)
{
string sql = @"select *
from Buses a,Driver b,Lines c,Timetable d
where a.BusID=d.BusID and b.EmpID=d.EmpID and c.LineID=d.LineID and c.StartP=@StartP";
SqlParameter[] para = { new SqlParameter("@StartP", txtStartS.Text) };
dvStatistics.DataSource = DBHelperSQL.TableSelect(sql, para);
}
private void btnLSearch_Click(object sender, EventArgs e)
{
string sql = @"SELECT [LineID]
,[StartP]
,[EndP]
,[Distance]
FROM [test2011].[dbo].[Lines]
WHERE [LineID] = @LineID";
SqlParameter[] para = { new SqlParameter("@LineID", txtLineID.Text) };
dvL.DataSource = DBHelperSQL.TableSelect(sql, para);
}
private void btnTSearch_Click(object sender, EventArgs e)
{
string sql = @"SELECT [LineID]
,[EmpID]
,[BusID]
,[StartTime]
FROM [test2011].[dbo].[Timetable]
WHERE [LineID] = @LineID And [BusID] = @BusID and [EmpID] =@EmpID";
SqlParameter[] para = { new SqlParameter("@LineID", txtLineIDT.Text),
new SqlParameter("@EmpID", txtEmpIDT.Text),
new SqlParameter("@BusID", txtBusIDT.Text) };
dvL.DataSource = DBHelperSQL.TableSelect(sql, para);
}
private void btnDSearch_Click(object sender, EventArgs e)
{
string sql = @"SELECT [EmpID]
,[DName]
,[Sex]
,[Age]
,[Tel]
,[Pwd]
FROM [test2011].[dbo].[Driver]
where [EmpID] =@EmpID";
SqlParameter[] para = { new SqlParameter("@EmpID", txtEmpID.Text) };
dvD.DataSource = DBHelperSQL.TableSelect(sql, para);
}
private void FormDriver_Load(object sender, EventArgs e)
{
string sql = @"SELECT [EmpID]
,[DName]
,[Sex]
,[Age]
,[Tel]
,[Pwd]
FROM [test2011].[dbo].[Driver]
WHERE DName=@DName and Pwd=@Pwd";
SqlParameter[] para = { new SqlParameter("@DName", name),
new SqlParameter("@Pwd", pwd) };
DataTable dt = DBHelperSQL.TableSelect(sql, para);
DataRow dr = dt.Rows[0];
txtEmpID.Text = dr["EmpID"].ToString();
txtDName.Text = dr["DName"].ToString();
txtSex.Text = dr["Sex"].ToString();
txtAge.Text = dr["Age"].ToString();
txtTel.Text = dr["Tel"].ToString();
txtPwd.Text = dr["Pwd"].ToString();
}
public void BusesShow()
{
string sql = "select * from Buses";
dvB.DataSource = DBHelperSQL.TableSelect(sql);
}
public void TimetableShow()
{
string sql = "select * from Timetable";
dvL.DataSource = DBHelperSQL.TableSelect(sql);
}
public void LinesShow()
{
string sql = "select * from Lines";
dvL.DataSource = DBHelperSQL.TableSelect(sql);
}
public void DriverShow()
{
string sql = "select * from Driver";
dvD.DataSource = DBHelperSQL.TableSelect(sql);
}
