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 * from HangVe"; 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 SoChoConTrong"; 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 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 NhanVien Where TinhTrang!=N'Đã xóa'"; var rs = ProcessData.LoadData(sql); return(rs); }
public int Delete(string id) { string sql = string.Format("Update NhanVien Set TinhTrang=N'Đã xóa' Where MaNhanVien='{0}'", id); var rs = ProcessData.ExecuteNonQuery(sql); return(rs); }
public int Update(SoChoConTrong SoChoConTrong) { string sql = string.Format("Update SoChoConTrong Set MaHangVe='{1}', SoChoConTrong='{2}' Where MaLichBay='{0}'", SoChoConTrong.MaLichBay, SoChoConTrong.MaHangVe, SoChoConTrong.SoChoTrong); var rs = ProcessData.ExecuteNonQuery(sql); return(rs); }
public int Insert(SoChoConTrong SoChoConTrong) { string sql = string.Format("Insert into LichLamViec(MaLichBay, MaHangVe, SoChoConTrong) Values('{0}','{1}','{2}')", SoChoConTrong.MaLichBay, SoChoConTrong.MaHangVe, SoChoConTrong.SoChoTrong); var rs = ProcessData.ExecuteNonQuery(sql); return(rs); }
public int Update(KhachHang KhachHang) { string sql = string.Format("Update KhachHang Set TenKhachHang='{1}', SoDienThoai='{2}', CMND='{3}' Where MaKhachHang='{0}'", KhachHang.MaKhachHang, KhachHang.TenKhachHang, KhachHang.SoDienThoai, KhachHang.CMND); var rs = ProcessData.ExecuteNonQuery(sql); return(rs); }
public int Update(LichLamViec LichLamViec) { string sql = string.Format("Update LichLamViec Set Ngay='{1}', Ca='{2}' Where MaNhanVien='{0}'", LichLamViec.MaNhanVien, LichLamViec.Ngay, LichLamViec.Ca); var rs = ProcessData.ExecuteNonQuery(sql); return(rs); }
public int Insert(LichLamViec LichLamViec) { string sql = string.Format("Insert into LichLamViec(MaNhanVien, Ngay, Ca) Values('{0}','{1}','{2}')", LichLamViec.MaNhanVien, LichLamViec.Ngay, LichLamViec.Ca); var rs = ProcessData.ExecuteNonQuery(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 int Update(LichBay LichBay) { string sql = string.Format("Update LichBay Set MaChuyenBay='{1}', Ngay='{2}', GioKhoiHanh='{3}', GioKetThuc='{4}', TinhTrang=N'{5}' Where MaLichBay='{0}'", LichBay.MaLichBay, LichBay.MaChuyenBay, LichBay.Ngay, LichBay.GioKhoiHanh, LichBay.GioKetThuc, LichBay.TinhTrang); var rs = ProcessData.ExecuteNonQuery(sql); return(rs); }
public int Update(NhanVien NhanVien) { string sql = string.Format("Update NhanVien Set HoTen'{1}', MatKhau='{2}', TinhTrang'{3}', MaNguoiQuanLy='{4}', NgaySinh='{5}', GioiTinh'{6}', ChucVu='{7}', DiaChi='{8}', SoDienThoai='{9}' Where MaNhanVien='{0}'", NhanVien.MaNhanVien, NhanVien.HoTen, NhanVien.MatKhau, NhanVien.TinhTrang, NhanVien.MaNguoiQuanLy, NhanVien.NgaySinh, NhanVien.GioiTinh, NhanVien.ChucVu, NhanVien.DiaChi, NhanVien.SoDienThoai); var rs = ProcessData.ExecuteNonQuery(sql); return(rs); }
public int Update(Ve Ve) { string sql = string.Format("Update LichBay Set MaLichBay='{1}', MaHangVe='{2}' Where MaNhanVien='{0}'", Ve.MaVe, Ve.MaLichBay, Ve.MaHangVe); var rs = ProcessData.ExecuteNonQuery(sql); return(rs); }
public int Delete(string id) { string sql = string.Format("Delete from LichLamViec Where MaVe='{0}'", id); var rs = ProcessData.ExecuteNonQuery(sql); return(rs); }
public int Delete(string id) { string sql = string.Format("Update ChuyenBay Set DaXoa=N'Đã xóa' Where MaChuyenBay='{0}'", id); var rs = ProcessData.ExecuteNonQuery(sql); return(rs); }
public int Update(HangVe HangVe) { string sql = string.Format("Update GiaoDich Set MaHangVe='{1}', MaChuyenBay='{2}', GiaVe='{3}', SoCho='{4}' Where MaGiaoDich={0}", HangVe.MaHangVe, HangVe.MaChuyenBay, HangVe.GiaVe, HangVe.SoCho); var rs = ProcessData.ExecuteNonQuery(sql); return(rs); }
public int Insert(HangVe HangVe) { string sql = string.Format("Insert into HangVe(MaHangVe, MaChuyenBay, GiaVe, SoCho) Values('{0}','{1}',{2},{3})", HangVe.MaHangVe, HangVe.MaChuyenBay, HangVe.GiaVe, HangVe.SoCho); var rs = ProcessData.ExecuteNonQuery(sql); return(rs); }
public int Delete(string id) { string sql = string.Format("Delete from ChuyenBay Where MaHangVe={0}", id); var rs = ProcessData.ExecuteNonQuery(sql); return(rs); }
public int Delete(string id) { string sql = string.Format("Delete from ChiTietGiaoDich Where Id={0}", id); var rs = ProcessData.ExecuteNonQuery(sql); return(rs); }
public int Update(GiaoDich GiaoDich) { string sql = string.Format("Update GiaoDich Set SoTienGiaoDich='{1}', ThoiGianGiaoDich='{2}', GiaoDich.MaKhachHang='{3}', MaNhanVien='{4}', SoTaiKhoanChuyenDen='{5}', GiaoDich.MaLichBay='{6}' Where MaGiaoDich={0}", GiaoDich.MaGiaoDich, GiaoDich.SoTienGiaoDich, GiaoDich.ThoiGianGiaoDich, GiaoDich.MaKhachHang, GiaoDich.MaNhanVien, GiaoDich.SoTaiKhoanChuyenDen, GiaoDich.MaLichBay); var rs = ProcessData.ExecuteNonQuery(sql); return(rs); }
public int Insert(ChiTietGiaoDich ChiTiet) { string sql = string.Format("Insert into ChiTietGiaoDich(MaGiaoDich, MaVe) Values('{0}','{1}')", ChiTiet.MaGiaoDich, ChiTiet.MaVe); var rs = ProcessData.ExecuteNonQuery(sql); return(rs); }
public int Update(ChuyenBay ChuyenBay) { string sql = string.Format("Update ChuyenBay Set HangHangKhong=N'{1}', DiemKhoiHanh=N'{2}', DiemDen=N'{3}', SoLuongKhach={4} Where MaChuyenBay='{0}'", ChuyenBay.MaChuyenBay, ChuyenBay.HangHangKhong, ChuyenBay.DiemKhoiHanh, ChuyenBay.DiemDen, ChuyenBay.SoLuongKhach); var rs = ProcessData.ExecuteNonQuery(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); }
public int Insert(Ve Ve, int amount, string idTran) { string path = @"Data Source=.\SQLEXPRESS;Initial Catalog=QLBanvechuyenbay;Integrated Security=True"; SqlConnection conn = new SqlConnection(path); string sql = string.Format("Select MAX(MaVe) From Ve"); SqlCommand command = new SqlCommand(sql, conn); conn.Open(); var rd = command.ExecuteReader(); string tmp = ""; if (rd.Read()) { tmp = rd.GetString(0); } conn.Close(); int id = int.Parse(tmp.Remove(0, 1)); int rs = 0; int temp = id; for (id++; id <= temp + amount + 1; id++) { tmp = "V"; if (id < 10) { tmp += "00"; } else if (id < 100) { tmp += "0"; } tmp += id; sql = string.Format("Insert into Ve(MaVe, MaLichBay, MahangVe) Values('{0}','{1}','{2}')", tmp, Ve.MaLichBay, Ve.MaHangVe); rs += ProcessData.ExecuteNonQuery(sql); sql = string.Format("Insert into ChiTietGiaoDich(MaGiaoDich, MaVe) values('{0}','{1}')", idTran, tmp); rs += ProcessData.ExecuteNonQuery(sql); } return(rs); }
public int Insert(ChuyenBay ChuyenBay) { string path = @"Data Source=.\SQLEXPRESS;Initial Catalog=QLBanvechuyenbay;Integrated Security=True"; SqlConnection conn = new SqlConnection(path); string sql = string.Format("Select MAX(MaChuyenBay) From ChuyenBay"); SqlCommand command = new SqlCommand(sql, conn); conn.Open(); var rd = command.ExecuteReader(); string tmp = ""; if (rd.Read()) { tmp = rd.GetString(0); } conn.Close(); int id = int.Parse(tmp.Remove(0, 2)); id++; tmp = "CB"; if (id < 10) { tmp += "00"; } else if (id < 100) { tmp += "0"; } tmp += id; sql = string.Format("Insert into ChuyenBay(MaChuyenBay, HangHangKhong, DiemKhoiHanh, DiemDen, SoLuongKhach, DaXoa) Values('{0}','{1}',N'{2}',N'{3}','{4}','{5}')", tmp, ChuyenBay.HangHangKhong, ChuyenBay.DiemKhoiHanh, ChuyenBay.DiemDen, ChuyenBay.SoLuongKhach, ChuyenBay.DaXoa); var rs = ProcessData.ExecuteNonQuery(sql); return(rs); }
public int Insert(GiaoDich GiaoDich) { string path = @"Data Source=.\SQLEXPRESS;Initial Catalog=QLBanvechuyenbay;Integrated Security=True"; SqlConnection conn = new SqlConnection(path); string sql = string.Format("Select MAX(MaGiaoDich) From GiaoDich"); SqlCommand command = new SqlCommand(sql, conn); conn.Open(); var rd = command.ExecuteReader(); string tmp = ""; if (rd.Read()) { tmp = rd.GetString(0); } conn.Close(); int id = int.Parse(tmp.Remove(0, 2)); id++; tmp = "GD"; if (id < 10) { tmp += "00"; } else if (id < 100) { tmp += "0"; } tmp += id; sql = string.Format("Insert into GiaoDich(MaGiaoDich, SoTienGiaoDich, ThoiGianGIaoDich,MaKhachHang,MaNhanVien,MaLichBay) Values('{0}',{1},'{2}','{3}','{4}','{5}')", tmp, GiaoDich.SoTienGiaoDich, GiaoDich.ThoiGianGiaoDich, GiaoDich.MaKhachHang, GiaoDich.MaNhanVien, GiaoDich.MaLichBay); var rs = ProcessData.ExecuteNonQuery(sql); return(rs); }