[FORM]
MTBLNAME=HT_BS_HOUSE
DTBLNAME=HT_HS_HOUSEINFOCYD
;pcDTabpostion=top
pcMDTabpostion=top
;pcTabpostion=bottom
;bMaximize=0
;bMinimiaze=0
housenofield=M011
mainhousenofield=M011
paBarcode=1
FormMinimiaze=1
paBottomUnvisible=1
myfavorate=fhthsHOUSEINFOCY

[MENUOPENFORM]
b01=ahthsOHOUSECY
b03=ahthsOHOUSECY
b06=ahtbsHOUSE
b07=absMEMBERCHARGE

[ONOFF]
CALCMSHEETNO=999
CALCM=1
CALCDSHEETNO=999
CALCD=0
NOINITSQCP=1
AUTOAPP=1

[LOADFANGTAI]
STOP=0
FilterField=M012
InfoValue=M011
Colcount=12
fangtaicode=M024
PG0Filter=大厅
PG1Filter=普通包房
PG2Filter=豪华包房

[JumpToAppendRecord]
mminame=b02;b04;b05;b08

b02TOFORM=fhthsOHOUSECY
b02toAction=ahthsOHOUSECY
b02TOTBLNAME=HT_HS_OHOUSECYM
b02TOTBLNAMED=HT_HS_OHOUSECYTABLED
b02TOTBLNAMELOOPDATASET=D
b02TOTBLFBRNO=M001
b02TOFORMTYPE=01

b02MFIELDS=M001;M022
b02MFIELDSVALUE=M001;M011
b02MFIELDSVALUEJZ=M,M

b02DGRIDMARK=D2
b02DFIELDS=D010;D011;D029
b02DFIELDSVALUE=M011;M012;M011
b02DFIELDSVALUEJZ=M,M,M

b02DLFields=
b02DLValues= 

b04TOFORM=fhthsOHOUSECY
b04toAction=ahthsOHOUSECY
b04TOTBLNAME=HT_HS_OHOUSECYM
b04TOTBLNAMED=HT_HS_OHOUSECYTABLED
b04TOTBLNAMELOOPDATASET=D
b04TOTBLFBRNO=M001
b04TOFORMTYPE=01

b04MFIELDS=M001;M022;M003;M201
b04MFIELDSVALUE=M001;M011;003;宾客预留
b04MFIELDSVALUEJZ=M,M,M,M

b04DGRIDMARK=D2
b04DFIELDS=D010;D011;D029
b04DFIELDSVALUE=M011;M012;M011
b04DFIELDSVALUEJZ=M,M,M

b04DLFields=
b04DLValues=

b05TOFORM=fhthsOHOUSECYXF
b05toAction=ahthsOHOUSECYXF
b05TOTBLNAME=HT_HS_OHOUSECYXFM
b05TOTBLNAMED=
b05TOTBLNAMELOOPDATASET=D
b05TOTBLFBRNO=M001
b05TOFORMTYPE=01

b05MFIELDS=M021;M034;M001;M003;M201;M037
b05MFIELDSVALUE=M026;M011;M001;001;吧台消费;M500
b05MFIELDSVALUEJZ=M,M,M,M,M,M

b05DFIELDS=
b05DFIELDSVALUE=
b05DFIELDSVALUEJZ=

b05DLFields=
b05DLValues=

b08TOFORM=fhthsOHOUSECYXF
b08toAction=ahthsOHOUSECYXF
b08TOTBLNAME=HT_HS_OHOUSECYXFM
b08TOTBLNAMED=
b08TOTBLNAMELOOPDATASET=D
b08TOTBLFBRNO=M001
b08TOFORMTYPE=01

b08MFIELDS=M021;M034;M001;M003;M201
b08MFIELDSVALUE=M026;M011;M001;002;外卖
b08MFIELDSVALUEJZ=M,M,M,M,M

b08DFIELDS=
b08DFIELDSVALUE=
b08DFIELDSVALUEJZ=

[CALCDATETIMEIIM]
FIELDS=D500;D501

D500SHEETNO=999
D500TYPE=D
D500DATEFIELDS=M505;M507
D500STRTIMEFIELDS=M506;M508
D500BTIME=12:00:00
D500bNow=0
D500SSWR=xiaoshuincone

D501SHEETNO=999
D501TYPE=D
D501DATEFIELDS=M505;M507
D501STRTIMEFIELDS=M506;M508
D501BTIME=12:00:00
D501bNow=1
D501SSWR=xiaoshuincone

[CALCFIELDM]
FIELDS=D500;D501;D502
FIELDSTITLE=预住天数;已住天数;应收押金
FIELDSTYPE=I;I;I

SQL=SQL1
SQL1FIELDS=D501;D500;D502
SQL1=
SQL1WHERE=M013
SQL1WHEREVALUE=D010
SQL1WHEREGRIDMARK=D

D500CALCDATETIME=1
D500DOTNUM=0
D500VALUE=
D500VAUEGRIDMARK=
D500INDEX=11

D501CALCDATETIME=1
D501DOTNUM=0
D501VALUE=
D501VAUEGRIDMARK=
D501INDEX=12

D502CALCDATETIME=0
D502DOTNUM=0
D502VALUE=D501*M019
D502VAUEGRIDMARK=M;M
D502INDEX=13

[CALCDATETIMEIISQ]
FIELDS=D500;D501

D500SHEETNO=999
D500TYPE=D
D500DATEFIELDS=M505;M507
D500STRTIMEFIELDS=M506;M508
D500BTIME=12:00:00
D500bNow=0
D500SSWR=xiaoshuincone

D501SHEETNO=999
D501TYPE=D
D501DATEFIELDS=M505;M507
D501STRTIMEFIELDS=M506;M508
D501BTIME=12:00:00
D501bNow=1
D501SSWR=xiaoshuincone

[CALCFIELDSQ]
FIELDS=D500;D501;D502
FIELDSTITLE=预住天数;已住天数;应收押金
FIELDSTYPE=I;I;I

SQL=SQL1
SQL1FIELDS=D501;D500;D502
SQL1=
SQL1WHERE=M013
SQL1WHEREVALUE=D010
SQL1WHEREGRIDMARK=D

D500CALCDATETIME=1
D500DOTNUM=0
D500VALUE=
D500VAUEGRIDMARK=
D500INDEX=10

D501CALCDATETIME=1
D501DOTNUM=0
D501VALUE=
D501VAUEGRIDMARK=
D501INDEX=11

D502CALCDATETIME=0
D502DOTNUM=0
D502VALUE=D501*M019
D502VAUEGRIDMARK=SQ;SQ
D502INDEX=12

[CALCFIELDD]
FIELDS=D500;D501;D502
FIELDSTITLE=消费金额|应收;消费金额|实收;消费数量
FIELDSTYPE=I;I;I

SQL=SQL1
SQL1FIELDS=D500;D501;D502
SQL1=
SQL1WHERE=M013
SQL1WHEREVALUE=D010
SQL1WHEREGRIDMARK=D

D500DOTNUM=4
D500VALUE=D027*D012*M025
D500VAUEGRIDMARK=D;D;D
D500INDEX=9

D501DOTNUM=4
D501VALUE=D027*D013*M025
D501VAUEGRIDMARK=D;D;D
D501INDEX=10

D502DOTNUM=4
D502VALUE=D027*M025
D502VAUEGRIDMARK=D;D
D502INDEX=8

[DBGRIDFOOTERD]
STOP=0
FIELDS=D010;D027;D500;D501
COL=
TYPE=fvtStaticText;fvtSum;fvtSum;fvtSum
D010VALUE=统 计

[DBGRIDFOOTERM]
STOP=1
FIELDS=M011;M512
COL=
TYPE=fvtStaticText;fvtSum
M011VALUE=统 计

[DBGRIDFOOTERSQ]
STOP=1
FIELDS=M011;M512
COL=
TYPE=fvtStaticText;fvtSum
M011VALUE=统 计

[CHECKACTION] 
Actions=b01;b02;b03;b04;b05

b01DoAction=aCHECKHASAPPEM
b01aCHECKHASAPPEMSHEETNO=999

b02DoAction=aCHECKHASAPPEM
b02aCHECKHASAPPEMSHEETNO=999

b03DoAction=aCHECKHASAPPEM
b03aCHECKHASAPPEMSHEETNO=999

b04DoAction=aCHECKHASAPPEM
b04aCHECKHASAPPEMSHEETNO=999

b05DoAction=aCHECKHASAPPEM
b05aCHECKHASAPPEMSHEETNO=999

[CHECKHASAPPEDM]
SQLS=SQL1;SQL2;SQL3;SQL4;SQL5

SQL1SHEETNO=999
SQL1FIELDS=M011
SQL1FVALUE=M011
SQL1=SELECT * FROM HT_BS_HOUSE WHERE M001='SYSFBRNO' AND M024 <> 'ky'
SQL1TIP=此餐台/房间不可用,不能开单
SQL1ACTION=b02

SQL2SHEETNO=999
SQL2FIELDS=M011
SQL2FVALUE=M011
SQL2=SELECT * FROM HT_BS_HOUSE WHERE M001='SYSFBRNO' AND M024 <> 'ky'
SQL2TIP=此餐台/房间不可用,不能开单
SQL2ACTION=b04

SQL3SHEETNO=999
SQL3FIELDS=M011
SQL3FVALUE=M011
SQL3=SELECT * FROM HT_BS_HOUSE WHERE M001='SYSFBRNO' AND M024 <> 'zy'
SQL3TIP=此餐台/房间无人用,不能开单
SQL3ACTION=b05

SQL4SHEETNO=999
SQL4FIELDS=M011
SQL4FVALUE=M011
SQL4=SELECT * FROM HT_BS_HOUSE WHERE M001='SYSFBRNO' AND M024 <> 'zy'
SQL4TIP=此餐台/房间无人用,不能增加消费
SQL4ACTION=b01

SQL5SHEETNO=999
SQL5FIELDS=M011
SQL5FVALUE=M011
SQL5=SELECT * FROM HT_BS_HOUSE WHERE M001='SYSFBRNO' AND M024 <> 'zy'
SQL5TIP=此餐台/房间无人用,不能结帐
SQL5ACTION=b03