【问】断网以后数据没传上来,如何解决? | ||
【适用版本】商锐9 | 【模块】档案管理 | 【点击数】51 |
【知识编号】P2017120800005 | ||
【问题描述】断网销售,联网以后数据没传上来。在分机已经做了数据重传(销售收银数据重传里检测,销售数据有,收银数据空)收银流水,和大类销售汇总没有数据,收银员对账有数据。12月1日的数据,数据一会发过去 |
go
–【处理销售流水】
Insert into t_rm_saleflow
(flow_id,flow_no,branch_no,item_no,source_price,sale_price,sale_qnty,sale_money,sell_way,
oper_id,sale_man,counter_no,oper_date,shift_no,spec_flag,pref_amt, in_price,posid,spec_sheet_no,
pr_spec_sheet_no,pr_spec_pref_amt,ot_spec_sheet_no,ot_spec_pref_amt,item_no_Fresh)
select
flow_id,flow_no,branch_no,item_no,source_price,sale_price,sale_qnty,sale_money,sell_way,
oper_id,sale_man,counter_no,oper_date,shift_no,spec_flag,pref_amt, in_price,posid,spec_sheet_no,
pr_spec_sheet_no,pr_spec_pref_amt,ot_spec_sheet_no,ot_spec_pref_amt,item_no_Fresh
from t_rm_saleflow_temp where flow_no not in (select flow_no from t_rm_saleflow)
go
–【处理付款流水】
Insert into t_rm_payflow (
flow_id,flow_no,sale_amount,branch_no,pay_way,sell_way,card_no,vip_no,coin_no,coin_rate,
pay_amount,oper_date,oper_id,counter_no,sale_man,memo,voucher_no,shift_no,posid)
select
flow_id,flow_no,sale_amount,branch_no,pay_way,sell_way,card_no,vip_no,coin_no,coin_rate,
pay_amount,oper_date,oper_id,counter_no,sale_man,memo,voucher_no,shift_no,posid
from t_rm_payflow_temp where flow_no not in (select flow_no from t_rm_payflow)
go注意:执行如上语句后。再执行如下语句
delete t_rm_saleflow_temp
delete t_rm_payflow_temp
go