开屏1.0 2.0批量替换店号SQL

admin

-- 1. 更新 记录绑定 表
UPDATE [lj_kp].[dbo].[记录绑定]
SET 范围组ID = 115
WHERE
    设备ID IN (
'10948','10272','10935','10339','11303','10410','11365','10569','100322','10110019',
'10110016','70725','11166','10832','11076','10963','120701','11137','11459','10163',
'10121','11173','11388','10314','11559','10411','10942','10277','10098','50029',
'50028','10673','10497','11493','10599','100323','151279','10110008','10110001',
'10110020','70539','30782','31551','91562','10136'
    )
    AND 范围组ID = 0;


-- 2. 批量更新 NEW_KP 表
UPDATE [lj_kp].[dbo].[NEW_KP]
SET
    特殊门店 = 1,   
    当前资源 = 'http://kb.ljcvs.com:11520/update/scr/ljcs20260402.zip'
WHERE
    店号 IN (
'10948','10272','10935','10339','11303','10410','11365','10569','100322','10110019',
'10110016','70725','11166','10832','11076','10963','120701','11137','11459','10163',
'10121','11173','11388','10314','11559','10411','10942','10277','10098','50029',
'50028','10673','10497','11493','10599','100323','151279','10110008','10110001',
'10110020','70539','30782','31551','91562','10136'
    )
    AND 特殊门店 = 0 and 是否强制角度 = 0;

admin

-- 批量更新：符合指定店号 + 非独立设备 → ResourceID = 1142 且 副屏标识=1
UPDATE d
SET d.ResourceID = 1142,       -- 资源ID更新为1142
    d.isIndependent = 1  -- 改成独立
FROM [Lj_CloudCMS].[dbo].[Device] d
INNER JOIN [Lj_CloudCMS].[dbo].[Store] s
    ON d.StoreID = s.ID
WHERE
    s.StoreCode IN (
'131504','131454','131480','131546','131502','131508','131491','141308','141349','141474',
'141481','141484','140987','130772','81467','91536','91003','91552','90309','91376',
'80791','81037','81127','81248','81409','80216','81463','81582','11578','11545',
'10157','10136','10455','10015','10105','10099','11121','10280','10279','10494',
'11071','10231','10673','11204','10875','11515','11456','11430','10135','10798',
'10310','10853','11384','10687','101521','100850','100849','100907','101030','61302',
'151410','151434','150654','151164','151334','60818','60928','60970','60998','61280',
'61398','60519','60647','60934','61385','160562','160663','300604','301341','301250',
'161320','170984','170567','170967','170815','171407','171420','171510','171548','71424',
'71197','30301','30510','190839','191590','191591','191483','191593','30340','31399',
'30845','31353','30714','30910','30507'
    )
    AND d.isIndependent = 0  ---独立为0
    AND d.is_secondary_screen = 0  --副屏为0
        AND   d.isIndependent = 0     --是否特殊
  AND   d.RotationAngle = 0     --角度为0