145 lines
8.3 KiB
Markdown
145 lines
8.3 KiB
Markdown
2023.08.02：oa数据库，ERPTreeList表增加菜单
|
||
|
||
```sql
|
||
--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光透视项目的名称
|
||
|
||
```sql
|
||
--dccdc数据库中更改
|
||
update exam_project_maintain set project_name = 'x光透视' where id = 6
|
||
```
|
||
|
||
2023.08.14：dccdc数据库，medical_scheme_project_maintain表从业方案绑定体检项目
|
||
|
||
```sql
|
||
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"需要根据实际情况填写检验医生的姓名，或者添加到数据库后，再从系统中修改名字**
|
||
|
||
```sql
|
||
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表增加菜单
|
||
|
||
```sql
|
||
--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数据库，更新数据库中已有的体检结果表，填充计量单位；
|
||
|
||
```sql
|
||
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数据库，修改字段长度
|
||
|
||
```sql
|
||
ALTER TABLE professionalExam_register
|
||
ALTER COLUMN hazards text;
|
||
ALTER TABLE occupation_exam_scheme_maintain
|
||
ALTER COLUMN hazards text;
|
||
```
|
||
|
||
2023.10.23：dccdc数据库，登记表添加字段
|
||
|
||
```sql
|
||
--添加一般主检结论、一般处理意见、危害因素文本
|
||
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数据库，修改字段长度
|
||
|
||
```sql
|
||
--修改职业史表的危害因素字段长度
|
||
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数据库，增加字段
|
||
|
||
```sql
|
||
alter table doctor_inquiry add marry_history varchar(50)
|
||
```
|
||
|
||
2023.11.13：dccdc数据库，修改字段长度
|
||
|
||
```sql
|
||
ALTER TABLE professionalExam_project_result
|
||
ALTER COLUMN electronic_signature varchar(1000);
|
||
```
|
||
|
||
2023.11.20：dccdc数据库，增加打印项目字段
|
||
|
||
```sql
|
||
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数据库，修改图标
|
||
|
||
```sql
|
||
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数据库，登记表添加体检结果字段
|
||
|
||
```sql
|
||
alter table professionalExam_register add check_result text
|
||
```
|
||
|