function.sql

oracle 数据库自动备份的窗口模式解压不会把原档案删除

insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0018', '002', 'HospLeaveWithdrawAction', 'com.kmlss.sds.actions.HospitalActionPkg.HospLeaveWithdrawAction', null, '出院回退中间过程', '0', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0019', '002', 'HospPrescriptionImportFileAction', 'com.kmlss.sds.actions.HospitalActionPkg.HospPrescriptionImportFileAction', null, '明细文件倒入中间过程', '0', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0020', '002', 'HospPrescriptionInputAction', 'com.kmlss.sds.actions.HospitalActionPkg.HospPrescriptionInputAction', null, '明细录入中间过程', '0', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0021', '002', 'HospReckoningCountAction', 'com.kmlss.sds.actions.HospitalActionPkg.HospReckoningCountAction', null, '费用结算中间过程', '0', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0005', '001', 'chpasswd', 'com.kmlss.sds.actions.umsActionPkg.userChangePasswdAction', '/sds/ums/userChPasswd.do', '更改密码', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0027', '002', 'HospitalQueryAction', 'com.kmlss.sds.actions.HospitalActionPkg.HospitalQueryAction', null, '住院查询中间过程', '0', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0028', '002', 'admitqueryleavereckoning', 'com.kmlss.sds.actions.HospitalActionPkg.HospitalizationAuditQueryAction', '/sds/hospital/admitqueryleavereckoning.do', '出院结算(老)', '0', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0026', '002', 'listhospitalinfo', 'com.kmlss.sds.actions.HospitalActionPkg.HospitalQueryAction', '/sds/hospital/hospitalqueryaction.do?method=listInhospitalInfo', '住院查询', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0004', '001', 'listRole', 'com.kmlss.sds.actions.umsActionPkg.roleListAction', '/sds/ums/roleList.do', '角色管理', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0003', '001', 'updateUser', 'com.kmlss.sds.actions.umsActionPkg.userUpdateAction', '/sds/ums/userUpdate.do', '更改用户信息', '0', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('00261', '002', 'feecheck', 'com.kmlss.sds.actions.HospitalActionPkg.HospitalQueryAction', '/sds/hospital/hospitalqueryaction.do?method=feeCheck', '医保对帐', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('00292', '002', 'admitquerymodify', 'com.kmlss.sds.actions.HospitalActionPkg.HospitalQueryAction', '/sds/hospital/admitquerymodify.do', '入院修改', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('00291', '002', 'HospitalizationAuditModifyAction', 'com.kmlss.sds.actions.HospitalActionPkg.HospitalizationAuditModifyAction', null, '入院修改中间过程', '0', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0022', '002', 'admitqueryhtmlfile', 'com.kmlss.sds.actions.HospitalActionPkg.HospitalizationAuditQueryAction', '/sds/hospital/admitqueryhtmlfile.do', '明细倒入', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0023', '002', 'BatchPrescriptionFileAction', 'com.kmlss.sds.actions.HospitalActionPkg.BatchPrescriptionFileAction', null, '明细倒入中间过程', '0', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0024', '002', 'presQuery', 'com.kmlss.sds.actions.HospitalActionPkg.PrescriptionQueryAction', '/sds/hospital/presQuery.do?method=listPatient', '明细查询', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0029', '003', 'backFee', 'com.kmlss.sds.actions.center.BackFeeAction', '/sds/center/backFee.do?method=listHospital', '退费查询', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0030', '003', 'inHospital', 'com.kmlss.sds.actions.center.InHospitalAction', '/sds/center/inHospital.do?method=listHospital', '住院查询', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('001', null, 'ums', null, null, '系统功能', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0001', '001', 'addUser', 'com.kmlss.sds.actions.umsActionPkg.userAddAction', '/sds/ums/userAdd.do', '新增用户', '0', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0002', '001', 'listUser', 'com.kmlss.sds.actions.umsActionPkg.userListAction', '/sds/ums/userList.do', '用户管理', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('003', null, 'center', null, null, '保险业务', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0006', '003', 'presCheck', 'com.kmlss.sds.actions.center.PresCheckAction', '/sds/center/presCheck.do?method=listHospital', '费用审核', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0008', '003', 'compensateCheckBack', 'com.kmlss.sds.actions.center.CompensateCheckBackAction', '/sds/center/compensateCheckBack.do?method=listHospital', '审核回退', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0010', '003', 'queryStatics', 'com.kmlss.sds.actions.center.QueryStaticsAction', '/sds/center/queryStatics.do?method=listHospital', '审核查询', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('002', null, 'hospital', null, null, '医院支付', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0011', '002', 'cardlogin', 'com.kmlss.sds.actions.HospitalActionPkg.HospitalizationRegisterAction', '/sds/hospital/cardlogin.do', '入院登记', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0012', '002', 'admitQueryPrescription', 'com.kmlss.sds.actions.HospitalActionPkg.HospitalizationAuditQueryAction', '/sds/hospital/admitQueryPrescription.do', '明细录入', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0013', '002', 'admitQueryReckoning', 'com.kmlss.sds.actions.HospitalActionPkg.HospitalizationAuditQueryAction', '/sds/hospital/admitQueryReckoning.do', '模拟结算', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0014', '002', 'admitqueryleavecardreckoning', 'com.kmlss.sds.actions.HospitalActionPkg.HospitalQueryAction', '/sds/hospital/admitqueryleavecardreckoning.do', '出院结算', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0015', '002', 'cardloginwithdraw', 'com.kmlss.sds.actions.HospitalActionPkg.HospitalizationRegisterAction', '/sds/hospital/cardloginwithdraw.do', '出院回退', '1', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0016', '002', 'HospitalizationAuditAction', 'com.kmlss.sds.actions.HospitalActionPkg.HospitalizationAuditAction', null, '入院审核中间过程', '0', null, null, null, null, null);
insert into FUNCTION (ID, PID, NAME, ACTION, URL, TITLE, TYPE, TARGET, ICON, ICONOPEN, OPENED, REMARK)
values ('0017', '002', 'HospLeaveCheckOutAction', 'com.kmlss.sds.actions.HospitalActionPkg.HospLeaveCheckOutAction', null, '出院结算中间过程', '0', null, null, null, null, null);
commit;