genepoint_service/doc/基点设备信息配置SQL.txt

# 更新设备CU

UPDATE bank_equipment SET cu='1' WHERE id = '585';


#更新ltu, group
UPDATE bank_shelf SET ltu = '1'  WHERE equipmentid ='585';

UPDATE bank_shelf SET `group`= '1' WHERE equipmentid = '585' AND xstation<='4';

UPDATE bank_shelf SET `group`= '2' WHERE equipmentid = '585' AND xstation>'4';

#boxtype tubetype 
UPDATE bank_shelf SET boxtype='101', tubetype='201' WHERE equipmentid = '585';

#unit需手动更新
一般按照生成顺序依次往下排(参照bank_shelf表  xtation 或 ystation字段)



#更新冻存盒pos
UPDATE bank_box SET pos='13' WHERE equipmentid='585' AND xstation='1';
UPDATE bank_box SET pos='12' WHERE equipmentid='585' AND xstation='2';
UPDATE bank_box SET pos='11' WHERE equipmentid='585' AND xstation='3';
UPDATE bank_box SET pos='10' WHERE equipmentid='585' AND xstation='4';
UPDATE bank_box SET pos='9' WHERE equipmentid='585' AND xstation='5';
UPDATE bank_box SET pos='8' WHERE equipmentid='585' AND xstation='6';
UPDATE bank_box SET pos='7' WHERE equipmentid='585' AND xstation='7';
UPDATE bank_box SET pos='6' WHERE equipmentid='585' AND xstation='8';
UPDATE bank_box SET pos='5' WHERE equipmentid='585' AND xstation='9';
UPDATE bank_box SET pos='4' WHERE equipmentid='585' AND xstation='10';
UPDATE bank_box SET pos='3' WHERE equipmentid='585' AND xstation='11';
UPDATE bank_box SET pos='2' WHERE equipmentid='585' AND xstation='12';
UPDATE bank_box SET pos='1' WHERE equipmentid='585' AND xstation='13';