//门店执行操作：

Update CRM_Customer Set ICCardNumbers = 1 where Code In (Select CustomerCode From CRM_Card Where SN = '卡片序号') /*根据客户得卡片序号，修正客户卡片为共享并可见*/

EXEC SYS_SyncPushToShare_InsertAsSQL 'Update CRM_Customer Set ICCardNumbers = 1 where Code In (Select CustomerCode From CRM_Card Where SN = ''卡片序号'')',198,0    /*在门店数据，同步数据到总部*/

Select * From CRM_Card Where SN = '卡片序号'/*查询卡片记录是否有这张卡片*/

EXEC SYS_SyncPushToShop_Insert 门店编号,'CRM_Card','Code','Code值',0,'Insert','','','',10 /*同步这张卡片信息到 门店编号 店*/

EXEC  SYS_SyncPushToShop_InsertAsSQL 门店编号,'Update CRM_Customer Set ICCardNumbers = 1 where Code In (Select CustomerCode From CRM_Card Where SN = ''卡片序号'')',0,10 /*调整这张卡片为共享状态*/

-----/*同步客户资料信息至对应门店*/------

select * from  crm_customer where code='客户编号'

Exec SYS_SyncPushToShop_Insert 门店编号,'CRM_Customer','Code','客户编号',0,'Insert','','','',10

//1、总部执行操作（将总部可见的卡片信息同步到门店）： 

Select * From CRM_Card Where SN = '卡片序号'

EXEC SYS_SyncPushToShop_Insert 101,'CRM_Card','Code','Code值',0,'Insert','','','',10

//2、门店执行操作（将储值客户的扣减储值操作设置为可见）：

Update CRM_Customer Set ICCardNumbers = 1 where Code In (Select CustomerCode From CRM_Card Where SN = '卡片序号')