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