select * from T_Receive where F_ID = '接待单号'

select *From T_CHECKOUT where F_ID =  '结账单号'


更新

update T_CHECKOUT set F_ISDATAUPLOAD ='0' where F_ID = '001-011865'


查一天单子
select *From T_CHECKOUT 
where F_DATETIME between '2017-03-08 03:00:00' and '2017-03-09 02:59:59'
上传一天单子：
update T_CHECKOUT set F_ISDATAUPLOAD ='0',F_ischecked = '0' 
where F_DATETIME between '2017-03-08 03:00:00' and '2017-03-09 02:59:59'


delete