【正文】
件,48,錯誤)endifif flag1=1 and flag2=0 and flag3=0 and flag4=0 select * from 客房信息表 where 客房價格=price1endifif flag1=0 and flag2=1 and flag3=0 and flag4=0 select * from 客房信息表 where 客房類型=style1endifif flag1=0 and flag2=0 and flag3=1 and flag4=0 select * from 客房信息表 where 客房狀態(tài)=departendifif flag1=0 and flag2=0 and flag3=0 and flag4=1 select * from 客房信息表 where 折扣情況=zhekouendifif flag1=1 and flag2=1 and flag3=0 and flag4=0 select * from 客房信息表 where 客房價格=price1 and 客房類型=style1endifif flag1=1 and flag2=0 and flag3=1 and flag4=0 select * from 客房信息表 where 客房價格=price1 and 客房狀態(tài)=departendifif flag1=1 and flag2=0 and flag3=0 and flag4=1 select * from 客房信息表 where 客房價格=price1 and 折扣情況=zhekouendifif flag1=0 and flag2=1 and flag3=1 and flag4=0 select * from 客房信息表 where 客房類型=style1 and 客房狀態(tài)=departendifif flag1=0 and flag2=0 and flag3=1 and flag4=1 select * from 客房信息表 where 折扣情況=zhekou and 客房狀態(tài)=departendifif flag1=0 and flag2=1 and flag3=0 and flag4=1 select * from 客房信息表 where 折扣情況=zhekou and 客房類型=style1endifif flag1=1 and flag2=1 and flag3=1 and flag4=0 select * from 客房信息表 where 客房價格=price1 and 客房類型=style1 and 客房狀態(tài)=departendifif flag1=1 and flag2=1 and flag3=0 and flag4=1 select * from 客房信息表 where 客房價格=price1 and 客房類型=style1 and 折扣情況=zhekouendifif flag1=0 and flag2=1 and flag3=1 and flag4=1 select * from 客房信息表 where 客房狀態(tài)=depart and 客房類型=style1 and 折扣情況=zhekouendifif flag1=1 and flag2=1 and flag3=1 and flag4=1 select * from 客房信息表 where 客房價格=price1 and 客房類型=style1 and 客房狀態(tài)=depart and 折扣情況=zhekouendif客戶查詢表單該表單功能為管理員管理客戶信息,通過姓名、客房號、入住時間幫助客戶確定客房。如下圖(1)查找按鈕代碼:set order to 客房號seek alltrim()if !found() messagebox(