------------连锁版本设置：1、Single单店，不连锁;2、Complete完全连锁管理;------------------
--------------------------3、CRMWithReports会员管理;4、OnlyReports只管理报表数据----------------
UPDATE [dbo].[HotelEnvironmentSettings]
   SET [ParamValue] = 'Single'
   where [ParamCode] = 'ChainType'
------------连锁分店设置，使用web版连锁网站，0为单店，1为分店---------------------
UPDATE [dbo].[HotelEnvironmentSettings]
   SET [ParamValue] = '0'
   where [ParamCode] = 'IsSubbranch'
------------------会员卡同步设置，'连锁汇总 = 0,连锁分店=1,普通版本=2'---------------
UPDATE [dbo].[HotelEnvironmentSettings]
   SET [ParamValue] = '2'
   where [ParamCode] = 'SubBranchType'
go


update hotelenvironmentsettings set paramvalue = '' where paramcode = 'Syn4OrgAuthCode'


-----修改连锁标志
update dbo.HotelEnvironmentSettings
set ParamValue = 'Single'
where ParamCode = 'ChainType'
GO
DELETE dbo.SynIP4DataSyn
DELETE dbo.SynIP
-------重置好助手
delete dbo.HotelEnvironmentSettings 
WHERE   ParamCode = 'CloudOrgId' ----商户ID
        OR ParamCode = 'CloudBranchId'----门店ID
        OR ParamCode = 'CloudToken' ----好助手数据库令牌
        OR ParamCode = 'HelperBranchUniqueId'----注册好助手时，生成的门店唯一标识
		OR ParamCode='HelperBranchNo'
	    OR ParamCode='HelperMerchantNo'
GO
-------重置支付
UPDATE dbo.HotelEnvironmentSettings
SET ParamValue=''
WHERE ParamCode='ZhFBCustomers' OR ParamCode='WXZFCustomers'
GO
UPDATE dbo.Meal_EnvironmentSettings
SET Description=''
WHERE ParamCode='WeixinSN'
GO
----去掉好会员地址和标识
update dbo.meal_environmentsettings
set description =''
where paramcode='WeixinSN'
GO
update dbo.meal_environmentsettings
set description =''
where paramcode='WeixinCloudUrl'

UPDATE dbo.HotelEnvironmentSettings
SET ParamValue='False'
WHERE ParamCode='IsRegionWeiXin'





--断开erp后好会员设置灰色


delete from BranchEmpowerment_Action where ControlName = 'Meal_FrmWeixinSettingWXAddress'

update HotelEnvironmentSettings set ParamValue = 'false' where ParamCode ='IsBranchSettingsManage'