医药

merge into CT_HOS_Yiyuanflzc a
using (select fl.FNUMBER, cu.FProvince, fl.CFFlqssj,fl.CFFlzzsj 
         from CT_XZK_Sybyyectjfl fl
        inner join T_BD_Customer   cu 
           on cu.fid = fl.CFBasedataID) t
on (a.fnumber = t.FNUMBER)
when matched then
  update set a.CFReturnedstart = t.CFFlqssj ,a.CFReturnedend = t.CFFlzzsj 
  
  
     
  merge   into CT_HOS_YiyuanflzcEntry a  using(
      select  *  from   CT_HOS_Yiyuanflzc 
    ) t on (t.fid=a.FParentID and ( a.CFRebatestart is null  or  a.CFRebateend is null  )  )  when matched then
  update set    a.CFRebatestart=t.CFReturnedstart, a.CFRebateend = t.CFReturnedend 
  
  

---批量修改目标终端的单据状态为提交

update  CT_XZK_Targetterminal set CFBillstatus='PROCESSED'  where FNumber

in(

'MBZD-202102-000029',
'MBZD-202102-000184',
'MBZD-202102-000187',
'MBZD-202102-000190' ,
'MBZD-202102-000191' ,
'MBZD-202102-000192'  
)

 

 

-----事业部医院二次谈价返利
update  CT_XZK_Sybyyectjfl  set CFZclx=3  where CFZclx=2

update  CT_XZK_Sybyyectjfl  set CFZclx=2  where CFZclx=1





--医院返利政策  
select * from CT_HOS_Yiyuanflzc   where   FNUMBER in  (   SELECT  fnumber   FROM   CT_XZK_Sybyyectjfl  )
-- 修改医院返利政策

  update   CT_HOS_Yiyuanflzc  set  CFPOLICYTYPE=3  where CFPOLICYTYPE=2   and   FNUMBER in  (   SELECT  fnumber   FROM   CT_XZK_Sybyyectjfl  )

  update   CT_HOS_Yiyuanflzc  set  CFPOLICYTYPE=2 where CFPOLICYTYPE=1   and   FNUMBER in  (   SELECT  fnumber   FROM   CT_XZK_Sybyyectjfl  )