印特支持中心
-
查询客户现有积分值
SELECT * from CRM_CustomerPoint where Code='客户编号'
-
增加积分字段
INSERT INTO [EMSXDB].[dbo].[CRM_CustomerPoint]
([Id]
,[Code]
,[PointYear]
,[Bonus]
,[Recharge]
,[CustomA]
,[CustomB]
,[CustomC]
,[ShopCode]
,[Sys4CreateTime]
,[Sys4Version])
VALUES
(NEWID()
,'客户编号' /*变更客户编号*/
,2018 /*创建年份*/
,0
,0
,0
,0
,0
,门店编号 /*变更同步门店*/
,GETDATE()
,0)
GO -
将积分字段同步到门店
EXEC SYS_SyncPushToShop_Insert 0,'CRM_CustomerPoint','Id','id值',0,'Insert','','','',10
-
转移积分
Update CRM_CustomerPoint Set Recharge = 数值 where id= 'id值'
-
清除往年积分
Update CRM_CustomerPoint Set Recharge = 0 where Code= '客户编号' And PointYear <> 年份
-
同步本年积分至门店
EXEC SYS_SyncPushToShop_InsertAsSQL 0,'Update CRM_CustomerPoint Set Recharge = 数值 where id= ''id值''',0,10
-
同步清除门店往年积分
EXEC SYS_SyncPushToShop_InsertAsSQL 0,'Update CRM_CustomerPoint Set Recharge = 0 where Code= ''客户编号'' And PointYear <> 年份',0,10