private void Duyet_danh_sach_cho_ngoi() { { var withBlock = fm; lenh = "Select IdChuyen from ChuyenXe where IdTuyen = '" + fm.cbo_TenTuyenVe.SelectedValue.ToString() + "'" + " and NgayDi = '" + Convert.ToDateTime(fm.cbo_NgayVe.SelectedValue.ToString()) + "' and Gio = '" + fm.cbo_GioVe.SelectedValue.ToString() + "'" + " and So_Xe = '" + fm.cbo_XeVe.SelectedValue.ToString() + "'"; // Lay Idchuyen cua chuyen do ra bang_dat_ve = Ket_noi.Doc_bang(lenh); IdChuyen = bang_dat_ve.Rows[0]["IdChuyen"].ToString(); } lenh = "Select * from ChoNgoi where IdChuyen = '" + IdChuyen + "' and So_Xe = '" + fm.cbo_XeVe.SelectedValue.ToString() + "'"; SqlCommand com = new SqlCommand(lenh, Ket_noi.connect); try { Ket_noi.connect.Open(); SqlDataReader dr = com.ExecuteReader(); while (dr.Read() == true) { for (int i = 0; i <= grb_16.Controls.Count - 1; i++) { if (dr.GetValue(2).ToString() == grb_16.Controls[i].Text) { ((DevComponents.DotNetBar.ButtonX)grb_16.Controls[i]).Image = Properties.Resources.hanh_khach; } } } Ket_noi.connect.Close(); } catch (Exception ex) { MessageBox.Show("Không đọc được danh sách chỗ ngồi!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Hand); } }
private void btn_HienDanhSach_Click(object sender, EventArgs e) { if (flag) { luoi_Thoi_diem.ClearSelection(); lenh = "Select ChiTietTuyen.IdTuyen, TenTuyen , ThoiDiem.IdThoiDiem , Ngay, Gio from ThoiDiem, ChiTietTuyen, TuyenXe "; lenh += " where ChiTietTuyen.IdThoiDiem = ThoiDiem.IdThoiDiem and TuyenXe.IdTuyen = ChiTietTuyen.IdTuyen"; bang_danh_sach = Ket_noi.Doc_bang(lenh); luoi_Thoi_diem.DataSource = bang_danh_sach; cbo_MaSoTuyen.DataSource = bang_danh_sach; cbo_MaSoTuyen.DisplayMember = "IdTuyen"; cbo_MaSoTuyen.ValueMember = "IdTuyen"; cbo_MaSoTuyen1.DataBindings.Clear(); cbo_TenTuyen.DataBindings.Clear(); cbo_MaThoiDiem.DataBindings.Clear(); date_Chay.DataBindings.Clear(); txt_GioChay.DataBindings.Clear(); cbo_MaSoTuyen1.DataBindings.Add("Text", bang_danh_sach, "IdTuyen"); cbo_TenTuyen.DataBindings.Add("text", bang_danh_sach, "TenTuyen"); cbo_MaThoiDiem.DataBindings.Add("text", bang_danh_sach, "IdThoiDiem"); date_Chay.DataBindings.Add("text", bang_danh_sach, "Ngay"); txt_GioChay.DataBindings.Add("text", bang_danh_sach, "Gio"); btn_HienDanhSach.Text = "Lọc danh sách tuyến"; flag = false; } else { Update_ChiTietTuyen(); btn_HienDanhSach.Text = "Hiện tất cả danh sách"; flag = true; } }
private void Doc_Thoi_diem() { luoi_Thoi_diem.ClearSelection(); lenh = "Select IdTuyen, ThoiDiem.IdThoiDiem , Ngay, Gio from ThoiDiem, ChiTietTuyen where ChiTietTuyen.IdThoiDiem = ThoiDiem.IdThoiDiem "; bang_thoi_diem = Ket_noi.Doc_bang(lenh); luoi_Thoi_diem.DataSource = bang_thoi_diem; }
private void Doc_tuyen_xe() { lenh = "Select IdTuyen, TenTuyen from TuyenXe"; bang_Tuyen_xe = Ket_noi.Doc_bang(lenh); cbo_MaSoTuyen.DataSource = bang_Tuyen_xe; cbo_MaSoTuyen.DisplayMember = "IdTuyen"; cbo_MaSoTuyen.ValueMember = "IdTuyen"; cbo_MaSoTuyen1.Text = cbo_MaSoTuyen.Text; Xoa_lien_ket(); Tao_lien_ket(); }
public void update_() { lenh = "Delete from ChiTietTuyen where IdThoiDiem in (Select IdThoiDiem from ThoiDiem where Ngay < '" + Convert.ToString(DateTime.Today.Date) + "')"; SqlCommand com1 = new SqlCommand(lenh, Ket_noi.connect); try { Ket_noi.connect.Open(); com1.ExecuteNonQuery(); Ket_noi.connect.Close(); } catch (Exception ex) { Ket_noi.connect.Close(); } lenh = "Select * from ChiTietTuyen"; bang = Ket_noi.Doc_bang(lenh); if (bang.Rows.Count == 0) { lenh = "Delete from ThoiDiem"; } else { lenh = "Delete from ThoiDiem where Ngay < '" + Convert.ToString(DateTime.Today.Date) + "'"; } SqlCommand com2 = new SqlCommand(lenh, Ket_noi.connect); try { Ket_noi.connect.Open(); com2.ExecuteNonQuery(); Ket_noi.connect.Close(); } catch (Exception ex) { Ket_noi.connect.Close(); } // --------------------------------------------------Xu ly voi bang chuyenxxe, chongoi, banve lenh = "Delete from BanVe where IdChuyen in( Select IdChuyen from ChuyenXe where NgayDi < '" + System.Convert.ToString(DateTime.Today.Date) + "')"; SqlCommand com = new SqlCommand(lenh, Ket_noi.connect); try { Ket_noi.connect.Open(); com.ExecuteNonQuery(); Ket_noi.connect.Close(); } catch (Exception ex) { Ket_noi.connect.Close(); } lenh = "Delete from ChoNgoi where IdChuyen in( Select IdChuyen from ChuyenXe where NgayDi < '" + System.Convert.ToString(DateTime.Today.Date) + "')"; SqlCommand com4 = new SqlCommand(lenh, Ket_noi.connect); try { Ket_noi.connect.Open(); com4.ExecuteNonQuery(); Ket_noi.connect.Close(); } catch (Exception ex) { Ket_noi.connect.Close(); } lenh = "Select * from BanVe"; bang = Ket_noi.Doc_bang(lenh); if (bang.Rows.Count == 0) { lenh = "Delete from ChuyenXe"; } else { lenh = "Delete from ChuyenXe where IdChuyen <> (Select IdChuyen from BanVe)"; } SqlCommand com3 = new SqlCommand(lenh, Ket_noi.connect); try { Ket_noi.connect.Open(); com3.ExecuteNonQuery(); Ket_noi.connect.Close(); } catch (Exception ex) { Ket_noi.connect.Close(); } }