public DataTable load_hoadon1(room_DTO r)
{
string query = "SELECT * FROM t_hoadonthu WHERE Idphong = '" + r.Temp + "'";
DataTable result = new DataTable();
result = processdata.Instance.ExecuteQuery(query);
return(result);
}
public List <room_DTO> loadroomlist()
{
string query = "SELECT * FROM t_phong,t_loaiphong,t_tinhtrang where t_phong.Idloai = t_loaiphong.IDLP and t_tinhtrang.ID = t_phong.Idtinhtrang";
List <room_DTO> roomlist = new List <room_DTO>();
DataTable data = processdata.Instance.ExecuteQuery(query);
foreach (DataRow item in data.Rows)
{
room_DTO room = new room_DTO(item);
roomlist.Add(room);
}
return(roomlist);
}
public DataTable load_hoadon1(room_DTO r)
{
return(loadroom_DAO.Instance.load_hoadon1(r));
}
