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); }