Procedure For Doctor Register
create procedure sp_hospital_doctorsignup(@name varchar(20),@loginid varchar(20),@password varchar(20),
@department varchar(20),@specialization varchar(20),@phonenumber varchar(20),@address varchar(20),@email varchar(20))
as
begin
insert into hospital_doctorsignup values(@name,@loginid,@password,@department,@specialization,@phonenumber,@address,@email)
end
-----------------------------------------------------------------------------------------------------------------------------
Procedure For Employee Register
create procedure sp_hospital_empsignup(@name varchar(20),@loginid varchar(20),@password varchar(20),
@department varchar(20),@phonenumber varchar(20),@address varchar(20),@email varchar(20))
as
begin
insert into hospital_empsignup values(@name,@loginid,@password,@department,@phonenumber,@address,@email)
end
------------------------------------------------------------------------------------------------------------------------------
Procedure For Doctor Forgot Password
CREATE procedure sp_hospital_empforgot(@loginid varchar(20),@password varchar(20) out)
as
begin
select @password=password from hospital_empsignup where loginid=@loginid
end
------------------------------------------------------------------------------------------------------------------------------
Procedure For Employee Forgot Password
CREATE procedure sp_hospital_doctorforgot(@loginid varchar(20),@password varchar(20) out)
as
begin
select @password=password from hospital_doctorsignup where loginid=@loginid
end
------------------------------------------------------------------------------------------------------------------------------
Procedure For Patient Information
create procedure sp_hospital_patientinfoenter(@pid int,@patientname varchar(20),@age varchar(20),@department varchar(20),
@doctor varchar(20))
as
begin
insert into hospital_patientinfo values(@pid,@patientname,@age,@department,@doctor)
end
--------------------------------------------------------------------------------------------------------------------------------
Procedure For Inpatient
create procedure sp_hospital_inpatient(@patientname varchar(20),@gender varchar(20),@age int,@address varchar(20),
@phoneres bigint,@phonemob bigint,@maritual varchar(20),@occupation varchar(20),@admid int,@admdate datetime,@admtime datetime,
@status varchar(20),@symtoms varchar(20),@department varchar(20),@wardno int,@bedno int,@doctor varchar(20))
as
begin
insert into hospital_inpatient values(@patientname,@gender,@age,@address,@phoneres,@phonemob,@maritual,@occupation,@admid,
@admdate,@admtime,@status,@symtoms,@department,@wardno,@bedno,@doctor)
end
----------------------------------------------------------------------------------------------------------------------------------
Procedure For OutPatient
create procedure sp_hospital_outpatient(@patientname varchar(20) ,@gender varchar(20),@age int,@address varchar(20),
@assigndoctor varchar(20),@phoneres bigint,@phonemob bigint,@opdate datetime,@department varchar(20))
as
begin
insert into hospital_outpatient values(@patientname,@gender,@age,@address,@assigndoctor,@phoneres,@phonemob,@opdate,@department)
end
---------------------------------------------------------------------------------------------------------------------------------
Procedure For Surgery Information
create procedure sp_hospital_surgeryinfo(@pid int,@patientname varchar(20),@age varchar(20),@department varchar(20),@doctor varchar(20),
@surgerydate datetime)
as
begin
insert into hospital_surgeryinfo values(@pid,@patientname,@age,@department,@doctor,@surgerydate)
end
---------------------------------------------------------------------------------------------------------------------------------
Procedures For Blood Test
create procedure sp_hospital_bloodtest(@patienttype varchar(20),@patientid int,@patientname varchar(20),@mediclatestype varchar(20),
@bloodgroup varchar(20),@haemoglobin varchar(20),@bloodsugar varchar(20),@sacid varchar(20),@description varchar(40))
as
begin
insert into hospital_bloodtest values(@patienttype,@patientid,@patientname,@mediclatestype,@bloodgroup,@haemoglobin,
@bloodsugar,@sacid,@description)
end
-----------------------------------------------------------------------------------------------------------------------------------
Procedure For Urin Test
create procedure sp_hospital_urintest(@patienttype varchar(20),@patientid int,@patientname varchar(20),@mediclatestype varchar(20),
@color varchar(20),@clarity varchar(20),@odor varchar(20),@specificgravity varchar(20),@glucose varchar(40),@description varchar(40))
as
begin
insert into hospital_urintest values(@patienttype,@patientid,@patientname,@mediclatestype,@color,@clarity,
@odor,@specificgravity,@glucose,@description)
end
-------------------------------------------------------------------------------------------------------------------------------------
Procedure For Medical Test
create procedure sp_hospital_medicaltestout(@pid int)
as
begin
select patientname from hospital_outpatient where patientid=@pid
end
--------------------------------------------------------------------------------------------------------------------------------------
Procedure For Operation
create procedure sp_hospital_operation(@patienttype varchar(20),@patientid int,@patientname varchar(20),@refdoctor varchar(20),
@operationtype varchar(20),@operatonresult varchar(20))
as
begin
insert into hospital_operation values(@patienttype,@patientid,@patientname,@refdoctor,@operationtype,@operatonresult)
end
----------------------------------------------------------------------------------------------------------------------------------------
Procedure For Pharmacy
create procedure sp_hospital_pharmacy(@patienttype varchar(20),@patientid int,@department varchar(20),@patientname varchar(20),
@medicine varchar(20))
as
begin
insert into hospital_pharmacy values(@patienttype,@patientid,@department,@patientname,@medicine)
end
------------------------------------------------------------------------------------------------------------------------------------------
Procedure For Discharge Summary
create procedure sp_hospital_dischargesummary(@patientid int,@patientname varchar(20),
@joindate datetime,@dischargedate datetime)
as
begin
insert into hospital_dischargesummary values(@patientid,@patientname,@joindate,@dischargedate)
end
-------------------------------------------------------------------------------------------------------------------------------------------
没有合适的资源?快使用搜索试试~ 我知道了~
医院管理 系统是 基于 web 的应用程序开发使用 ASP.NET、 C#.NET,数据库和 SQL server
共114个文件
cs:31个
jpg:31个
aspx:30个
1.该资源内容由用户上传,如若侵权请联系客服进行举报
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
2.虚拟产品一经售出概不退款(资源遇到问题,请及时私信上传者)
版权申诉
0 下载量 118 浏览量
2023-03-01
15:26:16
上传
评论
收藏 10.18MB ZIP 举报
温馨提示
医院管理 系统是 基于 web 的应用程序开发使用 ASP.NET、 C#.NET,数据库和 SQL server 数据库。 这个项目完全自动的目的是在提供有效的管理 通过控制信息如医院服务病人细节、 人员安排、 手术室时间表、 房间 可用性和病人的发票.zip
资源推荐
资源详情
资源评论
收起资源包目录
医院管理 系统是 基于 web 的应用程序开发使用 ASP.NET、 C#.NET,数据库和 SQL server (114个子文件)
ipregister.aspx 7KB
medicaltests.aspx 5KB
doctorsignup.aspx 5KB
outpatient.aspx 4KB
empsignup.aspx 4KB
dischargesummary.aspx 4KB
pharmacy.aspx 3KB
surgeries.aspx 3KB
operationth.aspx 3KB
viewtests.aspx 3KB
appointments.aspx 3KB
patientinfo.aspx 3KB
doctorlogin.aspx 3KB
emplogin.aspx 2KB
contactus.aspx 2KB
viewappointments.aspx 2KB
viewsurgeries.aspx 2KB
viewoperations.aspx 2KB
doctorsden.aspx 2KB
doctorforgot.aspx 2KB
receptionhome.aspx 2KB
home.aspx 2KB
empforgot.aspx 1KB
Administration.aspx 1KB
emphome.aspx 1KB
registration.aspx 1KB
laborataries.aspx 1KB
ambulatoryinfo.aspx 1021B
main.aspx 910B
Default.aspx 450B
web.config 150B
medicaltests.aspx.cs 8KB
ipregister.aspx.cs 5KB
pharmacy.aspx.cs 4KB
operationth.aspx.cs 4KB
surgeries.aspx.cs 4KB
appointments.aspx.cs 3KB
viewtests.aspx.cs 3KB
dischargesummary.aspx.cs 3KB
doctorsignup.aspx.cs 2KB
outpatient.aspx.cs 2KB
empsignup.aspx.cs 2KB
viewsurgeries.aspx.cs 2KB
viewappointments.aspx.cs 2KB
viewoperations.aspx.cs 2KB
patientinfo.aspx.cs 2KB
doctorforgot.aspx.cs 1KB
empforgot.aspx.cs 1KB
emplogin.aspx.cs 1KB
doctorlogin.aspx.cs 1KB
MasterPage.master.cs 414B
ambulatoryinfo.aspx.cs 412B
Administration.aspx.cs 412B
receptionhome.aspx.cs 411B
registration.aspx.cs 410B
laborataries.aspx.cs 410B
doctorsden.aspx.cs 408B
contactus.aspx.cs 407B
emphome.aspx.cs 405B
home.aspx.cs 402B
main.aspx.cs 402B
Default.aspx.cs 380B
Thumbs.db 103KB
adminlogin.aspx.exclude 2KB
userlogin.aspx.exclude 2KB
adminforgot.aspx.exclude 1KB
adminlogin.aspx.cs.exclude 902B
adminforgot.aspx.cs.exclude 875B
userlogin.aspx.cs.exclude 407B
ref01_main-pic_patients&car[1].gif 149KB
ecg240x3201.gif 140KB
discharge.gif 3KB
ward.gif 3KB
medical store.gif 3KB
admin.gif 2KB
registration.gif 2KB
reception.gif 2KB
lab1.jpg 132KB
1135642872_330beb809b[1].jpg 102KB
Mp_1000nt_Patient_Monitor[1].jpg 97KB
reproductive_medicine_img.jpg 57KB
medi2[1].jpg 52KB
medical_report[1].jpg 47KB
4.jpg 39KB
11.jpg 39KB
14.jpg 39KB
2.jpg 39KB
5.jpg 38KB
hospital.jpg 36KB
10.jpg 35KB
6.jpg 35KB
8.jpg 33KB
12.jpg 33KB
3.jpg 32KB
1.jpg 31KB
7.jpg 31KB
kakinada_img_ban.jpg 30KB
13.jpg 30KB
9.jpg 27KB
15.jpg 26KB
共 114 条
- 1
- 2
资源评论
GZM888888
- 粉丝: 185
- 资源: 2957
下载权益
C知道特权
VIP文章
课程特权
开通VIP
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功