public static List <PhieuThueDTO> layDSPT()
{
OleDbConnection link = null;
List <PhieuThueDTO> dsPhieu = new List <PhieuThueDTO>();
try
{
link = KetNoi();
string chuoiLenh = "select * from PhieuThue,Phong,LoaiPhong where PhieuThue.MaPhong=Phong.MaPhong and Phong.MaLoaiPhong=LoaiPhong.MaLoaiPhong";
OleDbCommand lenh = new OleDbCommand(chuoiLenh, link);
OleDbDataReader Doc = lenh.ExecuteReader();
while (Doc.Read())
{
PhieuThueDTO phieu = new PhieuThueDTO();
phieu.MaPhieuThue = Doc.GetString(0);
phieu.NgayThue = Doc.GetDateTime(2);
phieu.TienDV = Doc.GetInt32(3);
phieu.DaThanhToan = Doc.GetString(4);
PhongDTO phg = new PhongDTO();
phg.MaPhong = Doc.GetString(5);
phg.TenPhong = Doc.GetString(6);
phg.GhiChu = Doc.GetString(8);
phg.TinhTrang = Doc.GetString(9);
phg.SLKhach = Doc.GetInt32(10);
LoaiPhongDTO loai = new LoaiPhongDTO();
loai.MaLoaiPhong = Doc.GetInt32(11);
loai.TenLoaiPhong = Doc.GetString(12);
loai.DonGia = Doc.GetInt32(13);
loai.SLKhachToiDa = Doc.GetInt32(14);
phg.LoaiPhong = loai;
phieu.Phong = phg;
dsPhieu.Add(phieu);
}
for (int i = 0; i < dsPhieu.Count; i++)
{
List <KhachHangDTO> dskh = new List <KhachHangDTO>();
dskh = PhieuThueDAO.NhapDSKhach(dsPhieu[i].MaPhieuThue);
dsPhieu[i].DsKH = dskh;
}
}
catch (Exception ex)
{
dsPhieu = new List <PhieuThueDTO>();
}
finally
{
if (link != null && link.State == System.Data.ConnectionState.Open)
{
link.Close();
}
}
return(dsPhieu);
}
public static PhieuThueDTO layPT(string MPT)
{
OleDbConnection link = null;
PhieuThueDTO Phieu = new PhieuThueDTO();
try
{
link = KetNoi();
string chuoiLenh = "select * from PhieuThue,Phong,LoaiPhong where PhieuThue.MaPhong=Phong.MaPhong and Phong.MaLoaiPhong=LoaiPhong.MaLoaiPhong and MaPhieuThue=@MPT";
OleDbCommand lenh = new OleDbCommand(chuoiLenh, link);
OleDbParameter thamso = new OleDbParameter("@MPT", OleDbType.LongVarChar);
thamso.Value = MPT;
lenh.Parameters.Add(thamso);
OleDbDataReader Doc = lenh.ExecuteReader();
Doc.Read();
Phieu.MaPhieuThue = Doc.GetString(0);
Phieu.NgayThue = Doc.GetDateTime(2);
Phieu.TienDV = Doc.GetInt32(3);
Phieu.DaThanhToan = Doc.GetString(4);
PhongDTO phg = new PhongDTO();
phg.MaPhong = Doc.GetString(5);
phg.TenPhong = Doc.GetString(6);
phg.GhiChu = Doc.GetString(8);
phg.TinhTrang = Doc.GetString(9);
phg.SLKhach = Doc.GetInt32(10);
LoaiPhongDTO loai = new LoaiPhongDTO();
loai.MaLoaiPhong = Doc.GetInt32(11);
loai.TenLoaiPhong = Doc.GetString(12);
loai.DonGia = Doc.GetInt32(13);
loai.SLKhachToiDa = Doc.GetInt32(14);
phg.LoaiPhong = loai;
Phieu.Phong = phg;
List <KhachHangDTO> dskh = new List <KhachHangDTO>();
dskh = PhieuThueDAO.NhapDSKhach(Phieu.MaPhieuThue);
Phieu.DsKH = dskh;
}
catch (Exception ex)
{
Phieu = new PhieuThueDTO();
}
finally
{
if (link != null && link.State == System.Data.ConnectionState.Open)
{
link.Close();
}
}
return(Phieu);
}
public static List <ChiTietHoaDonDTO> layCTHD(string MHD)
{
OleDbConnection link = null;
List <ChiTietHoaDonDTO> dsChiTiet = new List <ChiTietHoaDonDTO>();
try
{
link = KetNoi();
string chuoiLenh = "select * from ChiTietHoaDon where MaHoaDon =@MHD";
OleDbCommand lenh = new OleDbCommand(chuoiLenh, link);
OleDbParameter thamso = new OleDbParameter("@MHD", OleDbType.LongVarChar);
thamso.Value = MHD;
lenh.Parameters.Add(thamso);
OleDbDataReader Doc = lenh.ExecuteReader();
while (Doc.Read())
{
ChiTietHoaDonDTO chitiet = new ChiTietHoaDonDTO();
chitiet.SoNgayThue = Doc.GetInt32(2);
chitiet.TienThue = Doc.GetInt32(3);
chitiet.TongCong = Doc.GetInt32(4);
string MPT = Doc.GetString(1);
PhieuThueDTO pt = new PhieuThueDTO();
pt = PhieuThueDAO.layPT(MPT);
chitiet.Phieuthue = pt;
dsChiTiet.Add(chitiet);
}
}
catch (Exception ex)
{
dsChiTiet = new List <ChiTietHoaDonDTO>();
}
finally
{
if (link != null && link.State == System.Data.ConnectionState.Open)
{
link.Close();
}
}
return(dsChiTiet);
}
