public DataTable LoadList()
{
string sql = "Select * from Ve";
var rs = ProcessData.LoadData(sql);
return(rs);
}
public DataTable LoadList()
{
string sql = "Select GiaoDich.*, KhachHang.TenKhachHang From GiaoDich, KhachHang Where GiaoDich.MaKhachHang = KhachHang.MaKhachHang";
var rs = ProcessData.LoadData(sql);
return(rs);
}
public DataTable LoadList()
{
string sql = "Select * from ChuyenBay Where DaXoa=N'Chưa xóa'";
var rs = ProcessData.LoadData(sql);
return(rs);
}
public DataTable LoadList()
{
string sql = "Select LichLamViec.MaNhanVien, NhanVien.HoTen, LichLamViec.Ngay, LichLamViec.Ca from LichLamViec, NhanVien where LichLamViec.MaNhanVien = NhanVien.MaNhanVien";
var rs = ProcessData.LoadData(sql);
return(rs);
}
public DataTable Search(string diemkhoihanh, string diemden, string date)
{
string sql = string.Format("Select lb.malichbay,hanghangkhong,giokhoihanh,gioketthuc,mahangve,sochocontrong,tinhtrang from LichBay lb,ChuyenBay cb, SoChoTrong sct where lb.MaLichBay = sct.MaLichBay AND lb.MaChuyenBay = cb.MaChuyenBay AND DiemKhoiHanh = N'{0}' AND DiemDen = N'{1}' AND Ngay = '{2}'", diemkhoihanh, diemden, date);
var rs = ProcessData.LoadData(sql);
return(rs);
}
public DataTable LoadList()
{
string sql = "Select * from NhanVien Where TinhTrang!=N'Đã xóa'";
var rs = ProcessData.LoadData(sql);
return(rs);
}
public DataTable DetailLoad(string id)
{
string sql = string.Format("Select HangVe.*, SoChoTrong.SoChoConTrong From LichBay, HangVe, SoChoTrong Where LichBay.MaLichBay='{0}' and LichBay.MaChuyenBay = HangVe.MaChuyenBay and SoChoTrong.MaHangVe=HangVe.MaHangVe and SoChoTrong.MaLichBay=LichBay.MaLichBay",
id);
var rs = ProcessData.LoadData(sql);
return(rs);
}
public DataTable LoadList(string id)
{
string sql = string.Format("Select Ve.MAVE, LichBay.* "
+ "From GiaoDich, ChiTietGiaoDich, Ve, LichBay "
+ "Where Ve.MaVe=ChiTietGiaoDich.MaVe and GiaoDich.MaGiaoDich = ChiTietGiaoDich.MaGiaoDich "
+ "and GiaoDich.MaKhachHang = '{0}' and LichBay.MaLichBay = Ve.MaLichBay ",
id);
var rs = ProcessData.LoadData(sql);
return(rs);
}