简介
排队叫号系统包括以下4个部分：
1、医生叫号器
医生通过《医生叫号器》进行“下一个”、“重叫”、“暂停”，“继续”等叫号操作，并能够通过《医生叫号器》查看当前队列情况。
2、队列数据同步服务
用于定时从PACS中获取数据，插入当日队列
3、屏显和语音服务
用于将队列的信息发送到硬件设备
4、队列管理系统
管理员可以通过《队列管理系统》维护系统
护士可以通过《队列管理系统》维护队列
目前已经完成了“医生叫号器”和“队列数据同步服务”的开发。
运行时悬浮在屏幕右上方，不妨碍用户日常业务操作。
点击“详细”按钮，可以查看队列信息。
队列数据同步服务定时根据设置从PACS库中提取数据，插入当日队列
屏显和语音服务定时将队列信息发送到所有的LED屏幕上。
下一步的工作主要有以下两点：
1、确定如何从PACS库查询检查项目（判断是否阴超），确定业务细节，修改SP_Queue_Post_PACS、SP_Get_Queue、SP_Call_Next 这3个存储过程。
2、调试LED的显示。
/*==============================================================*/
/* Table: CallLog */
/*==============================================================*/
if not exists (select * from sysobjects where id = object_id(N'[dbo].[CallLog]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
create table CallLog
(
CallLogID [int] IDENTITY(1,1) not null,
LogTime datetime null,
Action varchar(20) null,
QueueID varchar(32) null,
UserCode varchar(20) null,
LogText varchar(200) null,
constraint PK_CALLLOG primary key clustered (CallLogID)
);
end
go
/*==============================================================*/
/* Table: CallQueue */
/*==============================================================*/
if not exists (select * from sysobjects where id = object_id(N'[dbo].[CallQueue]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
create table CallQueue
(
QueueID varchar(32) not null,
QueueCode varchar(20) not null,
CallNum varchar(10) not null,
QueueTitle varchar(20) null,
DisplayText varchar(200) null,
VoiceText varchar(200) null,
Status varchar(10) null,
CreateTime datetime null,
CreateDay varchar(10) null,
CreateBy varchar(50) null,
CallTime datetime null,
CallByRoom varchar(20) null,
constraint PK_CALLQUEUE primary key (QueueID)
);
end
go
/*==============================================================*/
/* Index: Index_RoomCodeCallNum */
/*==============================================================*/
if not exists (select * from sys.indexes WHERE object_id=object_id(N'[dbo].[CallQueue]') and name='Index_RoomCodeCallNum')
begin
create index Index_RoomCodeCallNum on CallQueue (
QueueCode ASC,
CallNum ASC
);
end
go
/*==============================================================*/
/* Table: QueueHistory */
/*==============================================================*/
if not exists (select * from sysobjects where id = object_id(N'[dbo].[QueueHistory]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
create table QueueHistory
(
HistoryID [int] IDENTITY(1,1) not null,
QueueID varchar(32) not null,
QueueCode varchar(20) not null,
CallNum varchar(10) not null,
QueueTitle varchar(20) null,
DisplayText varchar(200) null,
VoiceText varchar(200) null,
Status varchar(10) null,
CreateTime datetime null,
CreateDay varchar(10) null,
CreateBy varchar(50) null,
CallTime datetime null,
CallByRoom varchar(20) null,
constraint PK_QUEUEHISTORY primary key clustered (HistoryID)
);
end
go
/*==============================================================*/
/* Table: QueueList */
/*==============================================================*/
if not exists (select * from sysobjects where id = object_id(N'[dbo].[QueueList]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
create table QueueList
(
QueueCode varchar(20) not null,
QueueName varchar(50) null,
constraint PK_QUEUELIST primary key clustered (QueueCode)
);
end
go
/*==============================================================*/
/* Table: QueueSetting */
/*==============================================================*/
if not exists (select * from sysobjects where id = object_id(N'[dbo].[QueueSetting]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
create table QueueSetting
(
QueueCode varchar(20) not null,
SettingName varchar(50) not null,
SettingValue varchar(200) null,
constraint PK_QUEUESETTING primary key clustered (QueueCode, SettingName)
);
end
go
/*==============================================================*/
/* Table: RoomList */
/*==============================================================*/
if not exists (select * from sysobjects where id = object_id(N'[dbo].[RoomList]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
create table RoomList
(
RoomCode varchar(20) not null,
RoomName varchar(50) null,
constraint PK_ROOMLIST primary key clustered (RoomCode)
);
end
go
/*==============================================================*/
/* Table: RoomSetting */
/*==============================================================*/
if not exists (select * from sysobjects where id = object_id(N'[dbo].[RoomSetting]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
create table RoomSetting
(
RoomCode varchar(20) not null,
SettingName varchar(50) not null,
SettingValue varchar(200) null,
constraint PK_ROOMSETTING primary key clustered (RoomCode, SettingName)
);
end
go
/*==============================================================*/
/* Table: ScreenList */
/*==============================================================*/
if not exists (select * from sysobjects where id = object_id(N'[dbo].[ScreenList]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
create table ScreenList
(
ScreenCode varchar(20) not null,
ScreenName varchar(50) null,
constraint PK_SCREENLIST primary key clustered (ScreenCode)
);
end
go
/*==============================================================*/
/* Table: ScreenQueue */
/*==============================================================*/
if not exists (select * from sysobjects where id = object_id(N'[dbo].[ScreenQueue]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
create table ScreenQueue
(
QueueCode varchar(20) not null,
ScreenCode varchar(20) not null,
constraint PK_SCREENQUEUE primary key clustered (QueueCode, ScreenCode)
);
end
go
/*==============================================================*/
/* Table: ScreenSetting */
/*==============================================================*/
if not exists (select * from sysobjects where id = object_id(N'[dbo].[ScreenSetting]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
create table ScreenSetting
(
ScreenCode varchar(20) not null,
SettingName varchar(50) not null,
SettingValue varchar(200) null,
constraint PK_SCREENSETTING primary key clustered (ScreenCode, SettingName)
);
end
go
/*==============================================================*/
/* Table: Setting */
/*==============================================================*/
if not exists (select * from sysobjects where id = object_id(N'[dbo].[Setting]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
create table Setting
(
SettingName varchar(50) not null,
SettingValue varchar(200) null,
constraint PK_SETTING primary key clustered (SettingName)
);
end
go
/*==============================================================*/
/* Table: Users */
/*==============================================================*/
if not exists (select * from sysobjects where id = object_id(N'[dbo].[Users]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
create table Users
(
UserCode varchar(20) not null,
UserName varchar(50) null,
PassWord varchar(50) null,
UserType varchar(20) null,
constraint PK_USERS primary key clustered (UserCode)
);
end
go
/*==============================================================*/
/* Table: VoiceOut */
/*==============================================================*/
if not exists (select * from sysobjects where id = object_id(N'[dbo].[VoiceOut]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
create table VoiceOut
(
VoiceId [int] IDENTITY(1,1) not null,
ScreenCode varchar(20) not null,
QueueID varchar(32) not null,
VoiceText varchar(200) null,
PlayTimes int null,
CreateTime datetime null,
Status varchar(10) null,
PlayTime datetime null,
constraint PK_VOICEOUT primary key clustered (VoiceId)
);
end
go
扫一扫
5462
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
