DB_51aspx/2014年/图标update sql2014-9-18/图标添加912-医疗保健.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

select count(*) from [wx_PicStore] where  [picTemplates]='医疗保健'

select * from [wx_PicStore]where  [picTemplates]='医疗保健'

--delete  from [wx_PicStore] where  [picTemplates]='医疗保健'
-- 紫色
--  
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('注射' ,'/images/templates/tubiao_zi/yiliaobaojian/25.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',1,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('知识讲座' ,'/images/templates/tubiao_zi/yiliaobaojian/24.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',2,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('在线留言' ,'/images/templates/tubiao_zi/yiliaobaojian/23.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',3,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('预约挂号' ,'/images/templates/tubiao_zi/yiliaobaojian/22.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',4,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('医院图册' ,'/images/templates/tubiao_zi/yiliaobaojian/21.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',5,'zi');

INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('科室介绍' ,'/images/templates/tubiao_zi/yiliaobaojian/20.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',6,'zi');

INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('医院介绍' ,'/images/templates/tubiao_zi/yiliaobaojian/19.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',7,'zi');

INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('医学研究' ,'/images/templates/tubiao_zi/yiliaobaojian/18.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',8,'zi');

INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('医疗期刊' ,'/images/templates/tubiao_zi/yiliaobaojian/17.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',9,'zi');

INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('医疗案例' ,'/images/templates/tubiao_zi/yiliaobaojian/19.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',10,'zi');

INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('一键拨号' ,'/images/templates/tubiao_zi/yiliaobaojian/15.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',11,'zi');

INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('药品研究' ,'/images/templates/tubiao_zi/yiliaobaojian/14.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',12,'zi');

INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('药品管理' ,'/images/templates/tubiao_zi/yiliaobaojian/13.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',13,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('新闻资讯' ,'/images/templates/tubiao_zi/yiliaobaojian/12.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',14,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('微名片' ,'/images/templates/tubiao_zi/yiliaobaojian/11.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',15,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('输液' ,'/images/templates/tubiao_zi/yiliaobaojian/10.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',16,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('名医推荐' ,'/images/templates/tubiao_zi/yiliaobaojian/9.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',17,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('链接分享' ,'/images/templates/tubiao_zi/yiliaobaojian/8.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',18,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('救护设备' ,'/images/templates/tubiao_zi/yiliaobaojian/7.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',19,'zi');
 
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('救护配备' ,'/images/templates/tubiao_zi/yiliaobaojian/9.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',20,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('红丝带' ,'/images/templates/tubiao_zi/yiliaobaojian/5.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',21,'zi');
INSERT INTO  [wx_PicStore] ([picName] ,[picUri] ,[picTemplates] ,[picType] ,[picUsedType] ,[picValue] ,[picCreatePerson],[createDate],sort_id,color)
     VALUES ('合作机构' ,'/images/templates/tubiao_zi/yiliaobaojian/4.png' ,'医疗保健',9,'分类icon','','李朴','2019-9-12',22,'zi');