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