public DS_Hotels.HotelsDataTable GetHotelDetail(int hotelID) { if (hotelID <= 0) return null; string sql = @" SELECT hotelID, hotelName, starRank, description, priceInfo, contactInfo, status FROM Hotels WHERE hotelID=@hotelID"; SqlParameter[] para = { new SqlParameter("@hotelID", hotelID) }; DS_Hotels ds = new DS_Hotels(); m_dao.FillDataSet(ds, "Hotels", sql, para); return ds.Hotels; }
public DS_Hotels.HotelsDataTable GetHotelList(int status) { string sql = @" SELECT hotelID, hotelName, starRank, description, priceInfo, contactInfo, status FROM Hotels "; if (status > 0) { sql += " where status>0"; } sql += " order by hotelName"; DS_Hotels ds = new DS_Hotels(); m_dao.FillDataSet(ds, "Hotels", sql, null); return ds.Hotels; }