lyfz_repos/经典版源码/document/数据库维护脚本/查看选片或选设计时的选中和删除的相片.sql

-- 查看选片时选中的相片no;
-- 查询结果如:	006,005,003,002
select no from dindansp where id='20141129-020'

-- 查看选设计时选中的相片no2;
-- 查询结果如:	006,005,003,002
select no2 from dindansp where id='20141129-020'

-- 查看选片时被删除的相片delphotos;
-- 查询结果如:	;004;012;008;009;
select delphotos from dindan where id='20141129-020'

-- 查看选设计时被删除的相片delphotos2;
-- 查询结果如:	;004;012;008;009;
select delphotos2 from dindan where id='20141129-020'

-- 637版本将分隔符统一按"|"坚线作为分隔符.

-- 将逗号和分号改为"|"
update dindansp set [no]=replace([no],',','|'),[no2]=replace([no2],',','|')
update dindan set [delphotos]=replace([delphotos],';','|'),[delphotos2]=replace([delphotos2],';','|')

-- 将"|"改回逗号和分号
update dindansp set [no]=replace([no],'|',','),[no2]=replace([no2],'|',',')
update dindan set [delphotos]=replace([delphotos],'|',';'),[delphotos2]=replace([delphotos2],'|',';')


-- 删除二维码
delete [dbo].[photo] from [version]--无效;
select [printer1],[reverse3],[reverse1],setcheck1 from version
update version set photo=NULL,[reverse3]=1