tijian_tieying/数据库更新文档.md at main

xinyilu 8cce97a58a v1

2025-02-20 12:14:39 +08:00

8.3 KiB

Raw Permalink Blame History

2023.08.02：oa数据库，ERPTreeList表增加菜单

--oa数据库中插入如下信息，并且在角色中添加相应页面的权限即可
set IDENTITY_INSERT  ERPTreeList on
INSERT [dbo].[ERPTreeList] ([ID], [TextStr], [ImageUrlStr], [ValueStr], [NavigateUrlStr], [Target], [ParentID], [QuanXianList], [PaiXuStr], [ParentClass], [nodisplay]) VALUES (601, N'有害因素维护', N'~/Controls/images/menus/flow.gif', N'有害因素维护', N'/dccdc/Dictionaries/HarmfulFactorsMaintain', N'rform', 288, N'A_添加|M_修改|D_删除|E_导出', 150, N'', 0)
INSERT [dbo].[ERPTreeList] ([ID], [TextStr], [ImageUrlStr], [ValueStr], [NavigateUrlStr], [Target], [ParentID], [QuanXianList], [PaiXuStr], [ParentClass], [nodisplay]) VALUES (602, N'体检小组和前置条件维护', N'~/Controls/images/menus/flow.gif', N'体检小组和前置条件维护', N'/dccdc/Dictionaries/GroupqztjResult', N'rform', 288, N'A_添加|M_修改|D_删除|E_导出', 151, N'', 0)
INSERT [dbo].[ERPTreeList] ([ID], [TextStr], [ImageUrlStr], [ValueStr], [NavigateUrlStr], [Target], [ParentID], [QuanXianList], [PaiXuStr], [ParentClass], [nodisplay]) VALUES (603, N'目标疾病维护', N' ~/Controls/images/menus/flow.gif ', N'目标疾病维护', N' /dccdc/Dictionaries/MbjbResult', N'rform', 288, N'A_添加|M_修改|D_删除|E_导出', 152, N'', 0)

set IDENTITY_INSERT  ERPTreeList off

2023.08.02：dccdc数据库，exam_project_maintain 表修改x光透视项目的名称

--dccdc数据库中更改
update exam_project_maintain set project_name = 'x光透视' where id = 6

2023.08.14：dccdc数据库，medical_scheme_project_maintain表从业方案绑定体检项目

set IDENTITY_INSERT  medical_scheme_project_maintain  on
INSERT [dbo].[medical_scheme_project_maintain] ([id], [medical_scheme], [medical_scheme_maintain_id], [team_name], [project_name], [exam_project_maintain_project_id]) VALUES (3440, N'公共场所', 1, N'病毒性肝炎检测', N'抗HAV-IgM', N'11044')
INSERT [dbo].[medical_scheme_project_maintain] ([id], [medical_scheme], [medical_scheme_maintain_id], [team_name], [project_name], [exam_project_maintain_project_id]) VALUES (3441, N'公共场所', 1, N'病毒性肝炎检测', N'抗HEV-IgM', N'11260')
INSERT [dbo].[medical_scheme_project_maintain] ([id], [medical_scheme], [medical_scheme_maintain_id], [team_name], [project_name], [exam_project_maintain_project_id]) VALUES (3442, N'公共场所', 1, N'X光透视', N'x光透视', N'11015')
INSERT [dbo].[medical_scheme_project_maintain] ([id], [medical_scheme], [medical_scheme_maintain_id], [team_name], [project_name], [exam_project_maintain_project_id]) VALUES (3443, N'食品从业', 2, N'X光透视', N'x光透视', N'11015')
INSERT [dbo].[medical_scheme_project_maintain] ([id], [medical_scheme], [medical_scheme_maintain_id], [team_name], [project_name], [exam_project_maintain_project_id]) VALUES (3444, N'食品从业', 2, N'大便培养', N'霍乱', N'22233')
INSERT [dbo].[medical_scheme_project_maintain] ([id], [medical_scheme], [medical_scheme_maintain_id], [team_name], [project_name], [exam_project_maintain_project_id]) VALUES (3445, N'食品从业', 2, N'病毒性肝炎检测', N'抗HAV-IgM', N'11044')
INSERT [dbo].[medical_scheme_project_maintain] ([id], [medical_scheme], [medical_scheme_maintain_id], [team_name], [project_name], [exam_project_maintain_project_id]) VALUES (3446, N'食品从业', 2, N'病毒性肝炎检测', N'抗HEV-IgM', N'11260')


set IDENTITY_INSERT  medical_scheme_project_maintain  off

2023.08.15：dccdc数据库，添加系统参数设置

其中的"xxx"需要根据实际情况填写检验医生的姓名，或者添加到数据库后，再从系统中修改名字

set IDENTITY_INSERT System_Parms on
INSERT [dbo].[System_Parms] ([id], [parm_name], [Parm_value], [Parm_remarks]) VALUES (2154, N'shys', N'xxx', N'伤寒或副伤寒(沙门氏)默认医生')
INSERT [dbo].[System_Parms] ([id], [parm_name], [Parm_value], [Parm_remarks]) VALUES (2155, N'hlys', N'xxx', N'霍乱默认医生')
INSERT [dbo].[System_Parms] ([id], [parm_name], [Parm_value], [Parm_remarks]) VALUES (2156, N'havys', N'xxx', N'抗HAV-IgM默认医生')
INSERT [dbo].[System_Parms] ([id], [parm_name], [Parm_value], [Parm_remarks]) VALUES (2157, N'hevys', N'xxx', N'抗HEV-IgM默认医生')
INSERT [dbo].[System_Parms] ([id], [parm_name], [Parm_value], [Parm_remarks]) VALUES (2158, N'bslys', N'xxx', N'辨色力默认医生')
INSERT [dbo].[System_Parms] ([id], [parm_name], [Parm_value], [Parm_remarks]) VALUES (2159, N'xdtys', N'xxx', N'心电图默认医生')
INSERT [dbo].[System_Parms] ([id], [parm_name], [Parm_value], [Parm_remarks]) VALUES (2160, N'yxgybmkyys', N'xxx', N'乙型肝炎表面抗原默认医生')
INSERT [dbo].[System_Parms] ([id], [parm_name], [Parm_value], [Parm_remarks]) VALUES (2161, N'yxgyekyys', N'xxx', N'乙型肝炎E抗原默认医生')

set IDENTITY_INSERT  System_Parms off

2023.08.25：oa数据库，ERPTreeList表增加菜单

--oa数据库中插入如下信息，并且在角色中添加相应页面的权限即可
set IDENTITY_INSERT ERPTreeList on
INSERT [dbo].[ERPTreeList] ([ID], [TextStr], [ImageUrlStr], [ValueStr], [NavigateUrlStr], [Target], [ParentID], [QuanXianList], [PaiXuStr], [ParentClass], [nodisplay]) VALUES (604, N'体检进度', N'~/Controls/images/menus/flow.gif', N'体检进度', N'/dccdc/Registration/ProjectProcess', N'rform', 287, N'A_添加|M_修改|D_删除|E_导出', 10, N'', 0)
set IDENTITY_INSERT  ERPTreeList off

2023.09.11：dccdc数据库，更新数据库中已有的体检结果表，填充计量单位；

UPDATE professionalExam_project_result  SET project_unit = 
(SELECT unit FROM exam_project_maintain WHERE exam_project_maintain.project_id = professionalExam_project_result.project_id);

2023.10.09：dccdc数据库，修改字段长度

  ALTER TABLE professionalExam_register
  ALTER COLUMN hazards text;
  ALTER TABLE occupation_exam_scheme_maintain
  ALTER COLUMN hazards text;

2023.10.23：dccdc数据库，登记表添加字段

--添加一般主检结论、一般处理意见、危害因素文本
alter table professionalExam_register add common_result text
alter table professionalExam_register add common_advise text
alter table professionalExam_register add hazards_text text

2023.10.31：dccdc数据库，修改字段长度

--修改职业史表的危害因素字段长度
alter table occupation_history
drop constraint DF__occupatio__facto__34A9A997
ALTER TABLE occupation_history
ALTER COLUMN factory text;
--修改职业导入表的危害因素字段长度
ALTER TABLE occupation_data_import_object
ALTER COLUMN factor text;
--团检报告需求变更，取消修改
--ALTER TABLE professionalExam_register ALTER COLUMN hazards_alias text;
--ALTER TABLE professionalExam_register ALTER COLUMN hazards text;
--ALTER TABLE occupation_data_import_object ALTER COLUMN hazard_names text;
--团检报告增加字段
alter table occupation_report add hazards_text text  
alter table occupation_report add check_items text
alter table occupation_report add target_disease text

2023.11.08：dccdc数据库，增加字段

alter table doctor_inquiry add marry_history varchar(50)

2023.11.13：dccdc数据库，修改字段长度

ALTER TABLE professionalExam_project_result
ALTER COLUMN electronic_signature varchar(1000);

2023.11.20：dccdc数据库，增加打印项目字段

 alter table occupation_exam_scheme_maintain add print_item_ids varchar(2000)
 alter table professionalExam_register add print_item_ids varchar(2000)

2023.12.21：oa数据库，修改图标

update erptreelist set ImageUrlStr='~/Controls/images/menus/report.png' where TextStr='体检管理';
update erptreelist set ImageUrlStr='~/Controls/images/menus/charge.png' where TextStr='收费管理';
update erptreelist set ImageUrlStr='~/Controls/images/menus/internet.png' where TextStr='系统管理';
update erptreelist set ImageUrlStr='~/Controls/images/menus/statistics.png' where TextStr='查询统计';
update erptreelist set ImageUrlStr='~/Controls/images/menus/person.png' where TextStr='个人办公';
update erptreelist set ImageUrlStr='~/Controls/images/menus/data.png' where TextStr='基础数据维护';

2024.01.24：dccdc数据库，登记表添加体检结果字段

alter table professionalExam_register add check_result text

8.3 KiB Raw Permalink Blame History Unescape Escape

8.3 KiB

Raw Permalink Blame History