SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--=============================================================================================
--Author     <...8065>
--Alter Date <...2016.09.13>
--Description<...客户资料表与病人信息表资料同步>
--History    <...增加同步数据类型@AOperType1=病人信息同步到CRM 2=病人信息同步到CRM>
--==============================================================================================
ALTER Proc [HOCRM_VAA1_Synchronize] @SCA01 int , @VAA01 int = 0 , @AOperType int = 1 
As
  /*姓名、拼音码、五笔码、性别、出生日期、年龄、年龄单位、身份证号*/
  IF (@AOperType = 1) and (@SCA01 > 0)
  BEGIN
    Update a
      SET a.SCA06 = b.VAA05 ,
         a.ABBRP = b.ABBRP ,
         a.ABBRW = b.ABBRW ,
         a.ABW01 = b.ABW01 ,
         a.SCA11 = b.VAA12 ,
         a.SCA12 = b.VAA10 ,
         a.AAU01 = b.AAU01 ,
         a.SCA22 = b.VAA15   
    from SCA1 a with(rowlock)
      join VAA1 b with(nolock) on b.VAA01 = a.VAA01
    where a.SCA01 = @SCA01     
  END ELSE IF (@AOperType = 2) and (@VAA01 > 0)
  BEGIN
    Update a
      SET a.SCA06 = b.VAA05 ,
         a.ABBRP = b.ABBRP ,
         a.ABBRW = b.ABBRW ,
         a.ABW01 = b.ABW01 ,
         a.SCA11 = b.VAA12 ,
         a.SCA12 = b.VAA10 ,
         a.AAU01 = b.AAU01 ,
         a.SCA22 = b.VAA15   
    from SCA1 a with(rowlock)
      join VAA1 b with(nolock) on b.VAA01 = a.VAA01
    where a.VAA01 = @VAA01    
  END