private void btnBDelete_Click(object sender, EventArgs e)
{
string sql = "delete Buses where BusID=@BusID";
SqlParameter[] para = { new SqlParameter("@BusID", txtBusID.Text) };
DBHelperSQL.TableChange(sql, para);
BusesShow();
}
private void btnDDelete_Click(object sender, EventArgs e)
{
string sql = @"DELETE FROM [test2011].[dbo].[Driver]
WHERE [EmpID] =@EmpID";
SqlParameter[] para = { new SqlParameter("@EmpID", txtEmpID.Text) };
DBHelperSQL.TableChange(sql, para);
DriverShow();
}
private void btnBUpdate_Click(object sender, EventArgs e)
{
string sql = "update Buses set Supplier=@Supplier where BusID=@BusID";
SqlParameter[] para = { new SqlParameter("@BusID", txtBusID.Text),
new SqlParameter("@Supplier", txtSupplier.Text) };
DBHelperSQL.TableChange(sql, para);
BusesShow();
}
private void btnBAdd_Click(object sender, EventArgs e)
{
string sql = "insert into Buses values(@BusID,@Supplier)";
SqlParameter[] para = { new SqlParameter("@BusID", txtBusID.Text),
new SqlParameter("@Supplier", txtSupplier.Text) };
DBHelperSQL.TableChange(sql, para);
BusesShow();
}
private void btnLDelete_Click(object sender, EventArgs e)
{
string sql = @"DELETE FROM [test2011].[dbo].[Lines]
WHERE [LineID] = @LineID";
SqlParameter[] para = { new SqlParameter("@LineID", txtLineID.Text) };
DBHelperSQL.TableChange(sql, para);
LinesShow();
}
private void btnTDelete_Click(object sender, EventArgs e)
{
string sql = @"DELETE 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) };
DBHelperSQL.TableChange(sql, para);
TimetableShow();
}
private void btnTUpdate_Click(object sender, EventArgs e)
{
string sql = @"UPDATE [test2011].[dbo].[Timetable]
SET [EmpID] =@EmpID
,[BusID] = @BusID
,[StartTime] =@StartTime
WHERE [LineID] = @LineID";
SqlParameter[] para = { new SqlParameter("@LineID", txtLineIDT.Text),
new SqlParameter("@EmpID", txtEmpIDT.Text),
new SqlParameter("@BusID", txtBusIDT.Text),
new SqlParameter("@StartTime", txtStartTime.Text) };
DBHelperSQL.TableChange(sql, para);
TimetableShow();
}
private void btnLUpdate_Click(object sender, EventArgs e)
{
string sql = @"UPDATE [test2011].[dbo].[Lines]
SET [StartP] = @StartP
,[EndP] = @EndP
,[Distance] = @Distance
WHERE [LineID] = @LineID";
SqlParameter[] para = { new SqlParameter("@LineID", txtLineID.Text),
new SqlParameter("@StartP", txtStart.Text),
new SqlParameter("@EndP", txtEnd.Text),
new SqlParameter("@Distance", txtDistance.Text) };
DBHelperSQL.TableChange(sql, para);
LinesShow();
}
private void btnTAdd_Click(object sender, EventArgs e)
{
string sql = @"INSERT INTO [test2011].[dbo].[Timetable]
([LineID]
,[EmpID]
,[BusID]
,[StartTime])
VALUES(@LineID,@EmpID,@BusID,@StartTime)";
SqlParameter[] para = { new SqlParameter("@LineID", txtLineIDT.Text),
new SqlParameter("@EmpID", txtEmpIDT.Text),
new SqlParameter("@BusID", txtBusIDT.Text),
new SqlParameter("@StartTime", txtStartTime.Text) };
DBHelperSQL.TableChange(sql, para);
TimetableShow();
}
private void btnLAdd_Click(object sender, EventArgs e)
{
string sql = @"INSERT INTO [test2011].[dbo].[Lines]
([LineID]
,[StartP]
,[EndP]
,[Distance])
VALUES(@LineID,@StartP,@EndP,@Distance)";
SqlParameter[] para = { new SqlParameter("@LineID", txtLineID.Text),
new SqlParameter("@StartP", txtStart.Text),
new SqlParameter("@EndP", txtEnd.Text),
new SqlParameter("@Distance", txtDistance.Text) };
DBHelperSQL.TableChange(sql, para);
LinesShow();
}
private void btnDUpdate_Click(object sender, EventArgs e)
{
string sql = @"UPDATE [test2011].[dbo].[Driver]
SET [DName] = @DName,
[Sex] =@Sex,
[Age] = @Age,
[Tel] = @Tel,
[Pwd] = @Pwd
WHERE [EmpID] =@EmpID";
SqlParameter[] para = { new SqlParameter("@EmpID", txtEmpID.Text),
new SqlParameter("@DName", txtDName.Text),
new SqlParameter("@Sex", txtSex.Text),
new SqlParameter("@Age", txtAge.Text),
new SqlParameter("@Tel", txtTel.Text),
new SqlParameter("@Pwd", txtPwd.Text) };
DBHelperSQL.TableChange(sql, para);
}
private void btnDAdd_Click(object sender, EventArgs e)
{
string sql = @"INSERT INTO [test2011].[dbo].[Driver]
([EmpID]
,[DName]
,[Sex]
,[Age]
,[Tel]
,[Pwd])
VALUES(@EmpID,@DName,@Sex,@Age,@Tel,@Pwd)";
SqlParameter[] para = { new SqlParameter("@EmpID", txtEmpID.Text),
new SqlParameter("@DName", txtDName.Text),
new SqlParameter("@Sex", txtSex.Text),
new SqlParameter("@Age", txtAge.Text),
new SqlParameter("@Tel", txtTel.Text),
new SqlParameter("@Pwd", txtPwd.Text) };
DBHelperSQL.TableChange(sql, para);
DriverShow();
}
