/*获取该科室的Tips*/
public AllVerandaEntity GetSectionVeranda(string sectionID) {
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
var verandas = from ve in DEntities.VerandaLonelies
where ve.SectionID == sectionID
orderby ve.ID descending
select ve;
int cnt = 0;
int verandaCount = verandas.Count();
AllVerandaEntity allVerandaEntity = null;
if (verandaCount > 0) {
allVerandaEntity = new AllVerandaEntity();
allVerandaEntity.Count = verandaCount;
allVerandaEntity.verandaEntity = new VerandaEntity[verandaCount];
foreach (var ve in verandas) {
allVerandaEntity.verandaEntity[cnt] = new VerandaEntity();
allVerandaEntity.verandaEntity[cnt].Title = ve.Title;
allVerandaEntity.verandaEntity[cnt].Image = ve.Image;
allVerandaEntity.verandaEntity[cnt].Text = ve.Text;
cnt++;
}
}
return allVerandaEntity;
}
/*医生登录：校验(ID,Password)是否与数据库记录匹配*/
public DoctorInfoEntity Login(string doctorID, string password) {
/*数据库访问实例*/
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
/*查询(DoctorID,password)对是否匹配*/
Doctor doctor = (from d in DEntities.Doctors
where ((d.DoctorID == doctorID) && (d.Password == password))
select d).FirstOrDefault();
/*将结果转写为Entity，仅转写必要登录信息*/
DoctorInfoEntity doctorInfoEntity = null;
if (doctor != null) {
doctorInfoEntity = new DoctorInfoEntity() {
DoctorID = doctor.DoctorID,
LastName = doctor.LastName,
FirstName = doctor.FirstName,
SectionID = doctor.SectionID,
Designation = doctor.Designation,
LastLoginDate = doctor.LastLoginDate
};
/*更新该User的LastLoginDate域*/
doctor.LastLoginDate = DateTime.Now;
DEntities.SaveChanges();
}
return doctorInfoEntity;
}
/*药房登录: 向数据库提交select查询，若成功则并更新LastLoginDate域，将结果转写为Entity*/
public PharmacyInfoEntity Login(string pharmacyID, string password) {
/*数据库访问实例*/
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
/*查询(pharmacyID,password)对是否匹配*/
Pharmacy pharmacy = (from p in DEntities.Pharmacies
where ((p.PharmacyID == pharmacyID) && (p.Password == password))
select p).FirstOrDefault();
/*将结果转写为Entity，仅转写必要登录信息*/
PharmacyInfoEntity pharmacyInfoEntity = null;
if (pharmacy != null) {
pharmacyInfoEntity = new PharmacyInfoEntity() {
PharmacyID = pharmacyID,
Name = pharmacy.Name,
LastLoginDate = pharmacy.LastLoginDate
};
/*更新该Pharmacy的LastLoginDate域*/
pharmacy.LastLoginDate = DateTime.Now;
DEntities.SaveChanges();
}
return pharmacyInfoEntity;
}
/*进行就医消去挂号 FinishAppointment(Guid gGuid)*/
public string FinishAppointment(Guid gGuid) {
/*数据库访问实例*/
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
/*查询符合要求的Appointment, 未做时间判断*/
Appointment appointment = (from ap in DEntities.Appointments
where (ap.AppointmentID == gGuid)
select ap).FirstOrDefault();
/*若该预约不存在*/
if (appointment == null) {
return "No Such Appointment! @Data";
}
else {
appointment.Status = "[Finished]";
}
/*完成消号过程*/
try {
DEntities.SaveChanges();
}
catch {
return "Saving Denied! @Data";
}
return null;
}
/*根据挂号信息查询UserID UserIDThroughAppointment(Guid gGuid)*/
public string UserIDThroughAppointment(Guid gGuid) {
/*数据库访问实例*/
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
/*查询符合要求的Appointment, 未做时间判断，是否销号判断*/
Appointment appointment = (from ap in DEntities.Appointments
where (ap.AppointmentID == gGuid)
select ap).FirstOrDefault();
/*返回UserID*/
if (appointment == null) {
return null;
}
else {
return appointment.UserID;
}
}
/*获取指定时间区间中药房所有的交易记录*/
public AllTransactionInfoEntity GetTransactionHistory(string pharmacyID, DateTime? startDate, DateTime? endDate) {
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
/*查询[startDate, endDate]区间中产生的交易记录*/
var transactions = from t in DEntities.Transactions
where ((startDate <= t.Date) && (t.Date <= endDate) && (t.PharmacyID == pharmacyID))
orderby t.Date descending
select t;
int cnt = 0;
int transactionCount = transactions.Count();
AllTransactionInfoEntity allTransactionInfoEntity = null;
if (transactionCount > 0) {
allTransactionInfoEntity = new AllTransactionInfoEntity();
allTransactionInfoEntity.Count = transactionCount;
allTransactionInfoEntity.transactionInfoEntity = new TransactionInfoEntity[transactionCount];
foreach (var t in transactions) {
allTransactionInfoEntity.transactionInfoEntity[cnt] = new TransactionInfoEntity();
User user = (from u in DEntities.Users
where u.UserID == t.UserID
select u).FirstOrDefault();
allTransactionInfoEntity.transactionInfoEntity[cnt].TransactionID = t.TransactionID;
allTransactionInfoEntity.transactionInfoEntity[cnt].LastName = user.LastName;
allTransactionInfoEntity.transactionInfoEntity[cnt].FirstName = user.FirstName;
allTransactionInfoEntity.transactionInfoEntity[cnt].PharmacyID = pharmacyID;
allTransactionInfoEntity.transactionInfoEntity[cnt].Amount = t.Amount;
allTransactionInfoEntity.transactionInfoEntity[cnt].Date = t.Date;
if (t.Detail == null) {
allTransactionInfoEntity.transactionInfoEntity[cnt].Action = "[Pending]";
}
else {
allTransactionInfoEntity.transactionInfoEntity[cnt].Action = "[Taken]";
}
cnt++;
}
}
return allTransactionInfoEntity;
}
/*获取药房信息：提交城市名，返回该城市的所有药房的信息*/
public AllPharmacyInfoEntity GetAllPharmacyInfo(string city) {
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
var pharmacies = from ph in DEntities.Pharmacies
where ph.City == city
orderby ph.PharmacyID
select ph;
int cnt = 0;
int pharmacyCount = pharmacies.Count();
AllPharmacyInfoEntity allPharmacyInfoEntity = null;
if (pharmacyCount > 0) {
allPharmacyInfoEntity = new AllPharmacyInfoEntity();
allPharmacyInfoEntity.Count = pharmacyCount;
allPharmacyInfoEntity.pharmacyInfoEntity = new PharmacyInfoEntity[pharmacyCount];
foreach (var pharmacy in pharmacies) {
allPharmacyInfoEntity.pharmacyInfoEntity[cnt] = new PharmacyInfoEntity();
allPharmacyInfoEntity.pharmacyInfoEntity[cnt].PharmacyID = pharmacy.PharmacyID;
allPharmacyInfoEntity.pharmacyInfoEntity[cnt].Name = pharmacy.Name;
allPharmacyInfoEntity.pharmacyInfoEntity[cnt].City = pharmacy.City;
allPharmacyInfoEntity.pharmacyInfoEntity[cnt].Address = pharmacy.Address;
allPharmacyInfoEntity.pharmacyInfoEntity[cnt].Latitude = pharmacy.Latitude;
allPharmacyInfoEntity.pharmacyInfoEntity[cnt].Longitude = pharmacy.Longitude;
allPharmacyInfoEntity.pharmacyInfoEntity[cnt].HospitalID = pharmacy.HospitalID;
allPharmacyInfoEntity.pharmacyInfoEntity[cnt].Phone = pharmacy.Phone;
allPharmacyInfoEntity.pharmacyInfoEntity[cnt].Fax = pharmacy.Fax;
cnt++;
}
}
return allPharmacyInfoEntity;
}
/*修改病历*/
public CaseInfoEntity ModifyCase(CaseInfoEntity newCase) {
CaseHistory oldCase = new CaseHistory();
CaseInfoEntity modifiedCase = new CaseInfoEntity();
if (newCase.CaseID == null) {
modifiedCase.ErrorMessage = "Case GUID Missing! @Data";
return modifiedCase;
}
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
oldCase = (from c in DEntities.CaseHistories
where ((c.CaseID == newCase.CaseID) && (c.DoctorID == newCase.DoctorID))
select c).FirstOrDefault();
if (newCase == null) {
modifiedCase.ErrorMessage = "Invalid Case GUID! @Data";
return modifiedCase;
}
if (oldCase.ModifiedDate != null) {
modifiedCase.ErrorMessage = "Modification Denied! @Data";
return modifiedCase;
}
if (oldCase.ExaminationID == null) {
oldCase.ExaminationID = newCase.ExaminationID;
}
if (oldCase.PrescriptionID == null) {
oldCase.PrescriptionID = newCase.PrescriptionID;
}
if (oldCase.ChiefComplaint == null) {
oldCase.ChiefComplaint = newCase.ChiefComplaint;
}
if (oldCase.TentativeDiagnosis == null) {
oldCase.TentativeDiagnosis = newCase.TentativeDiagnosis;
}
if (oldCase.DifferentialDiagnosis == null) {
oldCase.DifferentialDiagnosis = newCase.DifferentialDiagnosis;
}
if (oldCase.TreatmentPlan == null) {
oldCase.TreatmentPlan = newCase.TreatmentPlan;
}
bool IsSent = oldCase.CountercheckDate.HasValue;
if (IsSent == false) {
oldCase.CountercheckDate = newCase.CountercheckDate;
}
if (newCase.IsDraft == false) {
oldCase.ModifiedDate = DateTime.Now;
}
try {
DEntities.SaveChanges();
}
catch {
modifiedCase.ErrorMessage = "Invalid Case! @Data";
return modifiedCase;
}
if ((IsSent == false) && (oldCase.CountercheckDate.HasValue)) {
Doctor doctor = (from d in DEntities.Doctors
where d.DoctorID == oldCase.DoctorID
select d).FirstOrDefault();
Section section = (from s in DEntities.Sections
where s.SectionID == doctor.SectionID
select s).FirstOrDefault();
User user = (from u in DEntities.Users
where u.UserID == oldCase.UserID
select u).FirstOrDefault();
DateTime lastVisit = (DateTime)oldCase.CreatedDate;
DateTime countercheckDate = (DateTime)oldCase.CountercheckDate;
DateTime currentTime = DateTime.Now;
Message message = new Message();
message.MessageID = Guid.NewGuid();
message.Sender = section.HospitalID;
message.Receiver = newCase.UserID;
message.Date = countercheckDate.AddDays(-3).AddMinutes(currentTime.Minute).AddSeconds(currentTime.Second).AddMilliseconds(currentTime.Millisecond);
message.Type = "H2U";
message.Text = String.Format(
"Dear {0}.{1} {2},\nDuring your visit on {3}, Dr.{4} {5} ({6}) suggested you pay another visit on {7}. It might be a good idea to make an appointment before it's too late.\nSincerely,\nDr.PE",
(user.Gender.ToLower() == "female") ? "Ms" : "Mr",
user.LastName, user.FirstName,
lastVisit.ToLongDateString(),
doctor.LastName, doctor.FirstName,
section.Name,
countercheckDate.ToLongDateString());
try {
DEntities.Messages.AddObject(message);
DEntities.SaveChanges();
}
catch {
modifiedCase.ErrorMessage = "Can't Create Appointment Inform! @Data";
return modifiedCase;
}
}
modifiedCase.CaseID = oldCase.CaseID;
modifiedCase.ExaminationID = oldCase.ExaminationID;
modifiedCase.PrescriptionID = oldCase.PrescriptionID;
modifiedCase.UserID = oldCase.UserID;
modifiedCase.DoctorID = oldCase.DoctorID;
modifiedCase.SectionID = oldCase.SectionID;
modifiedCase.Date = oldCase.CreatedDate;
modifiedCase.ChiefComplaint = oldCase.ChiefComplaint;
modifiedCase.TentativeDiagnosis = oldCase.TentativeDiagnosis;
modifiedCase.DifferentialDiagnosis = oldCase.DifferentialDiagnosis;
modifiedCase.TreatmentPlan = oldCase.TreatmentPlan;
modifiedCase.CountercheckDate = oldCase.CountercheckDate;
return modifiedCase;
}
/*获取特定医师信息：提交DoctorID，返回该医师的信息*/
public DoctorInfoEntity GetDoctorInfo(string doctorID) {
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
/*查询Doctor域为doctorID的Doctor记录*/
var doctor = (from d in DEntities.Doctors
where d.DoctorID == doctorID
select d).FirstOrDefault();
DoctorInfoEntity doctorInfoEntity = null;
if (doctor != null) {
doctorInfoEntity = new DoctorInfoEntity();
doctorInfoEntity.SectionID = doctor.SectionID;
doctorInfoEntity.DoctorID = doctor.DoctorID;
doctorInfoEntity.UserID = doctor.UserID;
doctorInfoEntity.LastName = doctor.LastName;
doctorInfoEntity.FirstName = doctor.FirstName;
doctorInfoEntity.Designation = doctor.Designation;
doctorInfoEntity.Resume = doctor.Resume;
doctorInfoEntity.Phone = doctor.Phone;
doctorInfoEntity.Fax = doctor.Fax;
doctorInfoEntity.Email = doctor.Email;
doctorInfoEntity.Vocation = doctor.Vocation;
doctorInfoEntity.Portrait = doctor.Portrait;
}
return doctorInfoEntity;
}
/*将文本中的ICD-10编码翻译为文字*/
private string TranslateICD(string context) {
if (context == null) {
return null;
}
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
Disease disease = null;
string answer = context;
string code = null;
string hugCode = null;
int pos1 = answer.IndexOf("[[");
int pos2 = 0;
if (pos1 >= 0) {
pos2 = answer.IndexOf("]]", pos1);
}
while ((pos1 >= 0) && (pos2 >= 0)) {
code = answer.Substring(pos1 + 2, pos2 - pos1 - 2);
hugCode = "[[" + code + "]]";
disease = (from d in DEntities.Diseases
where d.DiseaseID == code
select d).FirstOrDefault();
/*使用Replace方法，减少数据库查询以及不必要的String类生成*/
if (disease == null) {
answer = answer.Replace(hugCode, code);
}
else {
answer = answer.Replace(hugCode, disease.Name);
}
pos1 = answer.IndexOf("[[");
if (pos1 >= 0) {
pos2 = answer.IndexOf("]]", pos1);
}
}
return answer;
}
/*获取用户\患者信息*/
public UserInfoEntity GetUserInfo(string userID) {
/*数据库访问实例*/
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
/*查询UserID是否有匹配*/
User user = (from u in DEntities.Users
where u.UserID == userID
select u).FirstOrDefault();
/*将结果转写为Entity，未转写密码等敏感信息*/
UserInfoEntity userInfoEntity = null;
if (user != null) {
userInfoEntity = new UserInfoEntity() {
UserID = user.UserID,
LastName = user.LastName,
FirstName = user.FirstName,
Nationality = user.Nationality,
Gender = user.Gender,
ABO = user.ABO,
Rh = user.Rh,
Birthplace = user.Birthplace,
Birthday = user.Birthday,
Deathplace = user.Deathplace,
Deathday = user.Deathday,
Balance = user.Balance,
//LastLoginDate = user.LastLoginDate,
City = user.City,
Address = user.Address,
Phone = user.Phone,
Email = user.Email,
EmergencyContactPerson = user.EmergencyContactPerson
};
}
return userInfoEntity;
}
/*搜索药物信息：提交关键词，返回含有该关键词的所有药物的信息*/
public AllPhysicInfoEntity FindPhysicByName(string keyword) {
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
keyword = keyword.ToLower();
/*查询所有的药物记录*/
var physics = from p in DEntities.Physics
where p.Name.ToLower().Contains(keyword)
orderby p.PhysicID
select p;
int cnt = 0;
int physicCount = physics.Count();
AllPhysicInfoEntity allPhysicInfoEntity = null;
if (physicCount > 0) {
allPhysicInfoEntity = new AllPhysicInfoEntity();
allPhysicInfoEntity.Count = physicCount;
allPhysicInfoEntity.physicInfoEntity = new PhysicInfoEntity[physicCount];
foreach (var p in physics) {
allPhysicInfoEntity.physicInfoEntity[cnt] = new PhysicInfoEntity();
allPhysicInfoEntity.physicInfoEntity[cnt].PhysicID = p.PhysicID;
allPhysicInfoEntity.physicInfoEntity[cnt].Name = p.Name;
allPhysicInfoEntity.physicInfoEntity[cnt].Description = p.Description;
allPhysicInfoEntity.physicInfoEntity[cnt].Method = p.Method;
allPhysicInfoEntity.physicInfoEntity[cnt].Notice = p.Notice;
cnt++;
}
}
return allPhysicInfoEntity;
}
/*获取特定药品信息：输入PhysicID，返回该药品的完整信息*/
public PhysicInfoEntity GetPhysicInfo(string physicID) {
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
var physic = (from d in DEntities.Physics
where d.PhysicID == physicID
select d).FirstOrDefault();
PhysicInfoEntity physicInfoEntity = null;
if (physic != null) {
physicInfoEntity = new PhysicInfoEntity();
physicInfoEntity.PhysicID = physic.PhysicID;
physicInfoEntity.Name = physic.Name;
physicInfoEntity.Description = physic.Description;
physicInfoEntity.Method = physic.Method;
physicInfoEntity.Notice = physic.Notice;
}
return physicInfoEntity;
}
/*获取特定疾病信息：输入DiseaseID，返回该疾病的完整信息*/
public DiseaseInfoEntity GetDiseaseInfo(string diseaseID) {
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
var disease = (from d in DEntities.Diseases
where d.DiseaseID == diseaseID
select d).FirstOrDefault();
DiseaseInfoEntity diseaseInfoEntity = null;
if (disease != null) {
diseaseInfoEntity = new DiseaseInfoEntity();
diseaseInfoEntity.DiseaseID = disease.DiseaseID;
diseaseInfoEntity.Name = disease.Name;
diseaseInfoEntity.Description = disease.Description;
diseaseInfoEntity.Notice = disease.Notice;
}
return diseaseInfoEntity;
}
/*取回所有疾病编号和名称*/
public AllDiseaseInfoEntity RetrieveDiseaseList() {
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
/*查询所有的疾病记录*/
var diseases = from d in DEntities.Diseases
orderby d.DiseaseID
select d;
int cnt = 0;
int diseaseCount = diseases.Count();
AllDiseaseInfoEntity allDiseaseInfoEntity = null;
if (diseaseCount > 0) {
allDiseaseInfoEntity = new AllDiseaseInfoEntity();
allDiseaseInfoEntity.Count = diseaseCount;
allDiseaseInfoEntity.diseaseInfoEntity = new DiseaseInfoEntity[diseaseCount];
foreach (var d in diseases) {
allDiseaseInfoEntity.diseaseInfoEntity[cnt] = new DiseaseInfoEntity();
allDiseaseInfoEntity.diseaseInfoEntity[cnt].DiseaseID = d.DiseaseID;
allDiseaseInfoEntity.diseaseInfoEntity[cnt].Name = d.Name;
cnt++;
}
}
return allDiseaseInfoEntity;
}
/*取回所有药物编号和名称*/
public AllPhysicInfoEntity RetrievePhysicList() {
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
/*查询所有的药物记录*/
var physics = from p in DEntities.Physics
orderby p.Name
select p;
int cnt = 0;
int physicCount = physics.Count();
AllPhysicInfoEntity allPhysicInfoEntity = null;
if (physicCount > 0) {
allPhysicInfoEntity = new AllPhysicInfoEntity();
allPhysicInfoEntity.Count = physicCount;
allPhysicInfoEntity.physicInfoEntity = new PhysicInfoEntity[physicCount];
foreach (var p in physics) {
allPhysicInfoEntity.physicInfoEntity[cnt] = new PhysicInfoEntity();
allPhysicInfoEntity.physicInfoEntity[cnt].PhysicID = p.PhysicID;
allPhysicInfoEntity.physicInfoEntity[cnt].Name = p.Name;
cnt++;
}
}
return allPhysicInfoEntity;
}
public string CreatePrescription(PrescriptionInfoEntity prescriptionInfoEntity) {
Prescription newPrescription = new Prescription();
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
newPrescription.Detail = "";
for (int i = 0; i < prescriptionInfoEntity.Count; i++) {
string sPhysicID = prescriptionInfoEntity.physicID[i];
Physic physic = (from p in DEntities.Physics
where p.PhysicID == sPhysicID
select p).FirstOrDefault();
if (physic == null) {
return "Invalid PhysicID! @Data";
}
newPrescription.Detail += prescriptionInfoEntity.physicID[i] + ":" + prescriptionInfoEntity.number[i].ToString() + ";";
}
newPrescription.PrescriptionID = Guid.NewGuid();
try {
DEntities.Prescriptions.AddObject(newPrescription);
DEntities.SaveChanges();
}
catch {
return "Invalid Case! @Data";
}
return String.Format("EA{0}", newPrescription.PrescriptionID.ToString());
}
/*搜索疾病信息：提交关键词，返回含有该关键词的所有疾病的信息*/
public AllDiseaseInfoEntity FindDiseaseByName(string keyword) {
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
keyword = keyword.ToLower();
/*查询所有的疾病记录*/
var diseases = from d in DEntities.Diseases
where d.Name.ToLower().Contains(keyword)
orderby d.DiseaseID
select d;
int cnt = 0;
int diseaseCount = diseases.Count();
AllDiseaseInfoEntity allDiseaseInfoEntity = null;
if (diseaseCount > 0) {
allDiseaseInfoEntity = new AllDiseaseInfoEntity();
allDiseaseInfoEntity.Count = diseaseCount;
allDiseaseInfoEntity.diseaseInfoEntity = new DiseaseInfoEntity[diseaseCount];
foreach (var d in diseases) {
allDiseaseInfoEntity.diseaseInfoEntity[cnt] = new DiseaseInfoEntity();
allDiseaseInfoEntity.diseaseInfoEntity[cnt].DiseaseID = d.DiseaseID;
allDiseaseInfoEntity.diseaseInfoEntity[cnt].Name = d.Name;
allDiseaseInfoEntity.diseaseInfoEntity[cnt].Description = d.Description;
allDiseaseInfoEntity.diseaseInfoEntity[cnt].Notice = d.Notice;
cnt++;
}
}
return allDiseaseInfoEntity;
}
public PrescriptionInfoEntity GetPrescriptionInfo(Guid gPrescriptionID) {
PrescriptionInfoEntity prescriptionInfoEntity = new PrescriptionInfoEntity();
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
Prescription prescription = (from p in DEntities.Prescriptions
where p.PrescriptionID == gPrescriptionID
select p).FirstOrDefault();
/*若处方不存在*/
if (prescription == null) {
prescriptionInfoEntity.ErrorMessage = "No Such Prescription! @Data";
return prescriptionInfoEntity;
}
/*解析Detail域内容*/
int cnt = 0;
int pos = 0;
string sPhysicID = null;
string sNumber = null;
string[] detail = prescription.Detail.Split(';');
prescriptionInfoEntity.physicID = new string[detail.Length];
prescriptionInfoEntity.number = new int[detail.Length];
foreach (string s in detail) {
/*逐条解析Detail域内容*/
pos = s.IndexOf(':');
if (pos < 0) {
break;
}
sPhysicID = s.Substring(0, pos);
sNumber = s.Substring(pos + 1);
prescriptionInfoEntity.physicID[cnt] = sPhysicID;
prescriptionInfoEntity.number[cnt] = Convert.ToInt32(sNumber);
cnt++;
}
prescriptionInfoEntity.Count = cnt;
prescriptionInfoEntity.PrescriptionID = gPrescriptionID;
return prescriptionInfoEntity;
}
/*获取特定药房信息：提交PharmacyID，返回该药房的信息*/
public PharmacyInfoEntity GetPharmacyInfo(string pharmacyID) {
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
/*查询PharmacyID是否存在*/
Pharmacy pharmacy = (from p in DEntities.Pharmacies
where p.PharmacyID == pharmacyID
select p).FirstOrDefault();
PharmacyInfoEntity pharmacyInfoEntity = null;
if (pharmacy != null) {
pharmacyInfoEntity = new PharmacyInfoEntity();
pharmacyInfoEntity.PharmacyID = pharmacy.PharmacyID;
pharmacyInfoEntity.Name = pharmacy.Name;
pharmacyInfoEntity.City = pharmacy.City;
pharmacyInfoEntity.Address = pharmacy.Address;
pharmacyInfoEntity.Latitude = pharmacy.Latitude;
pharmacyInfoEntity.Longitude = pharmacy.Longitude;
pharmacyInfoEntity.HospitalID = pharmacy.HospitalID;
pharmacyInfoEntity.Phone = pharmacy.Phone;
pharmacyInfoEntity.Fax = pharmacy.Fax;
}
return pharmacyInfoEntity;
}
/*读取化验单 GetExaminationInfo(string examinationID)*/
public ExaminationInfoEntity GetExaminationInfo(Guid gExaminationID) {
ExaminationInfoEntity examinationInfoEntity = new ExaminationInfoEntity();
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
Examination examination = (from ex in DEntities.Examinations
where ex.ExaminationID == gExaminationID
select ex).FirstOrDefault();
if (examination == null) {
examinationInfoEntity.ErrorMessage = "No Such Examination Record! @Data";
return examinationInfoEntity;
}
examinationInfoEntity.ExaminationID = gExaminationID;
examinationInfoEntity.Date = examination.Date;
examinationInfoEntity.Type = examination.Type;
examinationInfoEntity.Text = examination.Text;
examinationInfoEntity.Advice = examination.Advice;
examinationInfoEntity.Image = examination.Image;
return examinationInfoEntity;
}
///*获取某医生在某区间内所有未完成的病历*/
//public CaseHistoryEntity RetrieveMyDraft(string doctorID, DateTime? startDate, DateTime? endDate) {
// return null;
//}
#endregion
#region 获取某科室全体医生撰写的病历 RetrieveSectionCase(string sectionID, DateTime? startDate, DateTime? endDate, bool isDraft, bool showICD)
/*获取某科室在某区间内所有已完成的病历(isDraft为false时)，或未完成的病历*/
public CaseHistoryEntity RetrieveSectionCase(string sectionID, DateTime? startDate, DateTime? endDate, bool isDraft, bool showICD) {
CaseHistoryEntity caseHistoryEntity = new CaseHistoryEntity();
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
IQueryable<CaseHistory> cases = null;
/*根据时间和科室ID查找病历*/
if (isDraft == false) {
cases = from c in DEntities.CaseHistories
where ((c.ModifiedDate != null) && (startDate <= c.ModifiedDate) && (c.ModifiedDate <= endDate) && (c.SectionID == sectionID))
orderby c.ModifiedDate
select c;
}
else {
cases = from c in DEntities.CaseHistories
where ((c.ModifiedDate == null) && (startDate <= c.CreatedDate) && (c.CreatedDate <= endDate) && (c.SectionID == sectionID))
orderby c.CreatedDate
select c;
}
/*处理无结果的情况*/
int caseCount = cases.Count();
if (caseCount <= 0) {
caseHistoryEntity.ErrorMessage = String.Format("No Case Histories Created in Section {2} Modified Between {0} and {1}! @Data",
startDate, endDate, sectionID);
return caseHistoryEntity;
}
/*逐条进行转录*/
int cnt = 0;
//caseHistoryEntity = new CaseHistoryEntity();
caseHistoryEntity.Count = caseCount;
caseHistoryEntity.caseInfoEntity = new CaseInfoEntity[caseCount];
foreach (var c in cases) {
caseHistoryEntity.caseInfoEntity[cnt] = new CaseInfoEntity();
/*复制病历部分信息*/
caseHistoryEntity.caseInfoEntity[cnt].CaseID = c.CaseID;
caseHistoryEntity.caseInfoEntity[cnt].ExaminationID = c.ExaminationID;
caseHistoryEntity.caseInfoEntity[cnt].PrescriptionID = c.PrescriptionID;
caseHistoryEntity.caseInfoEntity[cnt].UserID = c.UserID;
caseHistoryEntity.caseInfoEntity[cnt].DoctorID = c.DoctorID;
caseHistoryEntity.caseInfoEntity[cnt].SectionID = c.SectionID;
caseHistoryEntity.caseInfoEntity[cnt].CountercheckDate = c.CountercheckDate;
caseHistoryEntity.caseInfoEntity[cnt].Date = c.ModifiedDate;
/*针对ICD编码进行转写*/
if (showICD == false) {
caseHistoryEntity.caseInfoEntity[cnt].ChiefComplaint = TranslateICD(c.ChiefComplaint);
caseHistoryEntity.caseInfoEntity[cnt].TentativeDiagnosis = TranslateICD(c.TentativeDiagnosis);
caseHistoryEntity.caseInfoEntity[cnt].DifferentialDiagnosis = TranslateICD(c.DifferentialDiagnosis);
caseHistoryEntity.caseInfoEntity[cnt].TreatmentPlan = TranslateICD(c.TreatmentPlan);
}
else {
caseHistoryEntity.caseInfoEntity[cnt].ChiefComplaint = c.ChiefComplaint;
caseHistoryEntity.caseInfoEntity[cnt].TentativeDiagnosis = c.TentativeDiagnosis;
caseHistoryEntity.caseInfoEntity[cnt].DifferentialDiagnosis = c.DifferentialDiagnosis;
caseHistoryEntity.caseInfoEntity[cnt].TreatmentPlan = c.TreatmentPlan;
}
cnt++;
}
return caseHistoryEntity;
}
/*获取指定病历的信息*/
public CaseInfoEntity GetCaseInfo(Guid caseID, bool showICD) {
CaseInfoEntity caseInfoEntity = new CaseInfoEntity();
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
/*根据编号查找该病历*/
CaseHistory caseInfo = (from c in DEntities.CaseHistories
where c.CaseID == caseID
select c).FirstOrDefault();
if (caseInfo == null) {
caseInfoEntity.ErrorMessage = "Invalid Case GUID! @Data";
return caseInfoEntity;
}
/*复制病历部分信息*/
caseInfoEntity.CaseID = caseInfo.CaseID;
caseInfoEntity.ExaminationID = caseInfo.ExaminationID;
caseInfoEntity.PrescriptionID = caseInfo.PrescriptionID;
caseInfoEntity.UserID = caseInfo.UserID;
caseInfoEntity.DoctorID = caseInfo.DoctorID;
caseInfoEntity.SectionID = caseInfo.SectionID;
caseInfoEntity.CountercheckDate = caseInfo.CountercheckDate;
/*判断病历是否完成*/
caseInfoEntity.Date = caseInfo.ModifiedDate;
if (caseInfoEntity.Date == null) {
caseInfoEntity.IsDraft = true;
}
else {
caseInfoEntity.IsDraft = false;
}
/*针对ICD编码进行转写*/
if (showICD == false) {
caseInfoEntity.ChiefComplaint = TranslateICD(caseInfo.ChiefComplaint);
caseInfoEntity.TentativeDiagnosis = TranslateICD(caseInfo.TentativeDiagnosis);
caseInfoEntity.DifferentialDiagnosis = TranslateICD(caseInfo.DifferentialDiagnosis);
caseInfoEntity.TreatmentPlan = TranslateICD(caseInfo.TreatmentPlan);
}
else {
caseInfoEntity.ChiefComplaint = caseInfo.ChiefComplaint;
caseInfoEntity.TentativeDiagnosis = caseInfo.TentativeDiagnosis;
caseInfoEntity.DifferentialDiagnosis = caseInfo.DifferentialDiagnosis;
caseInfoEntity.TreatmentPlan = caseInfo.TreatmentPlan;
}
return caseInfoEntity;
}
/*医生查看发件箱*/
public AllMessageEntity MessageSent(string doctorID, DateTime? startDate, DateTime? endDate) {
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
AllMessageEntity allMessageEntity = new AllMessageEntity();
/*提交查询*/
Doctor doctor = (from d in DEntities.Doctors
where d.DoctorID == doctorID
select d).FirstOrDefault();
if (doctor == null) {
allMessageEntity.ErrorMessage = "Invalid Sender DoctorID! @Data";
return allMessageEntity;
}
var messages = from m in DEntities.Messages
where ((m.Sender == doctorID) && (startDate <= m.Date) && (m.Date <= endDate))
orderby m.Date descending
select m;
/*处理无结果的情况*/
int messageCount = messages.Count();
if (messageCount <= 0) {
allMessageEntity.ErrorMessage = String.Format("Doctor {0} Sent No Messages Between {1} and {2}! @Data",
doctor.DoctorID, startDate, endDate);
return allMessageEntity;
}
int cnt = 0;
allMessageEntity.Count = messageCount;
allMessageEntity.messageEntity = new MessageEntity[messageCount];
foreach (var m in messages) {
allMessageEntity.messageEntity[cnt] = new MessageEntity();
allMessageEntity.messageEntity[cnt].MessageID = m.MessageID;
allMessageEntity.messageEntity[cnt].Sender = m.Sender;
allMessageEntity.messageEntity[cnt].Receiver = m.Receiver;
allMessageEntity.messageEntity[cnt].Status = m.Type;
allMessageEntity.messageEntity[cnt].Date = m.Date;
allMessageEntity.messageEntity[cnt].Context = m.Text;
cnt++;
}
return allMessageEntity;
}
/*创建病历并针对复查日期创建message*/
public CaseInfoEntity CreateCase(CaseInfoEntity caseInfoEntity) {
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
CaseHistory newCase = new CaseHistory();
CaseInfoEntity addedCase = new CaseInfoEntity();
newCase.CaseID = Guid.NewGuid();
newCase.ExaminationID = caseInfoEntity.ExaminationID;
newCase.PrescriptionID = caseInfoEntity.PrescriptionID;
newCase.UserID = caseInfoEntity.UserID;
newCase.DoctorID = caseInfoEntity.DoctorID;
Doctor doctor = (from d in DEntities.Doctors
where d.DoctorID == newCase.DoctorID
select d).FirstOrDefault();
if (doctor == null) {
addedCase.ErrorMessage = "Invalid DoctorID! @Data";
return addedCase;
}
else {
newCase.SectionID = doctor.SectionID;
}
newCase.CreatedDate = DateTime.Now;
if (caseInfoEntity.IsDraft == false) {
newCase.ModifiedDate = newCase.CreatedDate;
}
newCase.ChiefComplaint = caseInfoEntity.ChiefComplaint;
newCase.TentativeDiagnosis = caseInfoEntity.TentativeDiagnosis;
newCase.DifferentialDiagnosis = caseInfoEntity.DifferentialDiagnosis;
newCase.TreatmentPlan = caseInfoEntity.TreatmentPlan;
newCase.CountercheckDate = caseInfoEntity.CountercheckDate;
try {
DEntities.CaseHistories.AddObject(newCase);
DEntities.SaveChanges();
}
catch {
addedCase.ErrorMessage = "Invalid Case! @Data";
return addedCase;
}
if (caseInfoEntity.CountercheckDate != null) {
Section section = (from s in DEntities.Sections
where s.SectionID == doctor.SectionID
select s).FirstOrDefault();
User user = (from u in DEntities.Users
where u.UserID == caseInfoEntity.UserID
select u).FirstOrDefault();
DateTime lastVisit = (DateTime)newCase.CreatedDate;
DateTime countercheckDate = (DateTime)newCase.CountercheckDate;
DateTime currentTime = DateTime.Now;
Message message = new Message();
message.MessageID = Guid.NewGuid();
message.Sender = section.HospitalID;
message.Receiver = newCase.UserID;
message.Date = countercheckDate.AddDays(-3).AddMinutes(currentTime.Minute).AddSeconds(currentTime.Second).AddMilliseconds(currentTime.Millisecond);
message.Type = "H2U";
message.Text = String.Format(
"Dear {0}.{1} {2},\nDuring your visit on {3}, Dr.{4} {5} ({6}) suggested you pay another visit on {7}. It might be a good idea to make an appointment before it's too late.\nSincerely,\nDr.PE",
(user.Gender.ToLower() == "female") ? "Ms" : "Mr",
user.LastName, user.FirstName,
lastVisit.ToLongDateString(),
doctor.LastName, doctor.FirstName,
section.Name,
countercheckDate.ToLongDateString());
try {
DEntities.Messages.AddObject(message);
DEntities.SaveChanges();
}
catch {
addedCase.ErrorMessage = "Can't Create Appointment Inform! @Data";
return addedCase;
}
}
addedCase.CaseID = newCase.CaseID;
addedCase.ExaminationID = newCase.ExaminationID;
addedCase.PrescriptionID = newCase.PrescriptionID;
addedCase.UserID = newCase.UserID;
addedCase.DoctorID = newCase.DoctorID;
addedCase.SectionID = newCase.SectionID;
addedCase.Date = newCase.CreatedDate;
addedCase.ChiefComplaint = newCase.ChiefComplaint;
addedCase.TentativeDiagnosis = newCase.TentativeDiagnosis;
addedCase.DifferentialDiagnosis = newCase.DifferentialDiagnosis;
addedCase.TreatmentPlan = newCase.TreatmentPlan;
addedCase.CountercheckDate = newCase.CountercheckDate;
if (newCase.ModifiedDate == null) {
addedCase.IsDraft = true;
}
else {
addedCase.IsDraft = false;
}
return addedCase;
}
/*获取特定科室信息：提交SectionID，返回该科室的信息*/
public SectionInfoEntity GetSectionInfo(string sectionID) {
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
/*查询SectionID域匹配的Section记录*/
var section = (from s in DEntities.Sections
where s.SectionID == sectionID
select s).FirstOrDefault();
SectionInfoEntity sectionInfoEntity = null;
if (section != null) {
sectionInfoEntity = new SectionInfoEntity();
sectionInfoEntity.HospitalID = section.HospitalID;
sectionInfoEntity.SectionID = section.SectionID;
sectionInfoEntity.Place = section.Place;
sectionInfoEntity.Name = section.Name;
sectionInfoEntity.Phone = section.Phone;
sectionInfoEntity.Fax = section.Fax;
}
return sectionInfoEntity;
}
/*医生撰写邮件Doctor to User*/
public string MessageCompose(string senderID, string receiverID, string text) {
Message message = new Message();
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
Doctor doctor = (from d in DEntities.Doctors
where d.DoctorID == senderID
select d).FirstOrDefault();
if (doctor == null) {
return "Invalid Sender DoctorID!";
}
User user = (from u in DEntities.Users
where u.UserID == receiverID
select u).FirstOrDefault();
if (user == null) {
return "Invalid Receiver UserID!";
}
message.MessageID = Guid.NewGuid();
message.Sender = doctor.DoctorID;
message.Receiver = user.UserID;
message.Type = "D2U";
message.Date = DateTime.Now;
message.Text = text;
try {
DEntities.Messages.AddObject(message);
DEntities.SaveChanges();
}
catch {
return "Sending Failed! @Data";
}
return null;
}
public string SetExceptionSchedule(string doctorID, DateTime? date) {
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
Doctor doctor = (from d in DEntities.Doctors
where d.DoctorID == doctorID
select d).FirstOrDefault();
if (doctor == null) {
return "Invalid DoctorID! @Data";
}
if (date == null) {
return "Paremeter Date is Null! @Data";
}
DateTime newDate = (DateTime)date;
DateTime dDate = newDate.Date;
if (newDate.CompareTo(dDate.AddHours(12)) >= 0) {
dDate = dDate.AddHours(12);
}
Schedule schedule = (from s in DEntities.Schedules
where s.DoctorID == doctorID
select s).FirstOrDefault();
if (schedule == null) {
schedule = new Schedule();
schedule.DoctorID = doctor.DoctorID;
schedule.Exception = dDate;
schedule.LastCheck = DateTime.Now;
DEntities.Schedules.AddObject(schedule);
}
else {
if (schedule.Addition != null) {
if (((DateTime)schedule.Addition) == dDate) {
return "Conflict with Additonal Date! @Data";
}
}
schedule.Exception = dDate;
schedule.LastCheck = DateTime.Now;
}
try {
DEntities.SaveChanges();
}
catch {
return "Set Exceptional Schedule Failed! @Data";
}
return null;
}
public string SetDailySchedule(string doctorID, DayOfWeek dayOfWeek, int am) {
string setting = null;
switch (dayOfWeek) {
case DayOfWeek.Sunday:
setting = "Sun";
break;
case DayOfWeek.Monday:
setting = "Mon";
break;
case DayOfWeek.Tuesday:
setting = "Tue";
break;
case DayOfWeek.Wednesday:
setting = "Wed";
break;
case DayOfWeek.Thursday:
setting = "Thu";
break;
case DayOfWeek.Friday:
setting = "Fri";
break;
case DayOfWeek.Saturday:
setting = "Sat";
break;
default:
return "Invalid Weekday! @Data";
}
if (am > 0) {
setting += ":A";
}
else {
setting += ":P";
}
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
Doctor doctor = (from d in DEntities.Doctors
where d.DoctorID == doctorID
select d).FirstOrDefault();
if (doctor == null) {
return "Invalid DoctorID!";
}
Schedule schedule = (from s in DEntities.Schedules
where s.DoctorID == doctorID
select s).FirstOrDefault();
if (schedule == null) {
schedule = new Schedule();
schedule.DoctorID = doctor.DoctorID;
schedule.Weekday = setting;
schedule.LastCheck = DateTime.Now;
DEntities.Schedules.AddObject(schedule);
}
else {
schedule.Weekday = setting;
schedule.LastCheck = DateTime.Now;
}
try {
DEntities.SaveChanges();
}
catch {
return "Set Daily Schedule Failed! @Data";
}
return null;
}
/*查看当前时间段多少人选择*/
public AllAppointmentEntity GetMyAppointment(string doctorID) {
AllAppointmentEntity allAppointmentEntity = new AllAppointmentEntity();
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
Doctor doctor = (from d in DEntities.Doctors
where d.DoctorID == doctorID
select d).FirstOrDefault();
if (doctor == null) {
allAppointmentEntity.ErrorMessage = "312 Invalid DoctorID! @Data";
return allAppointmentEntity;
}
DateTime newDate = DateTime.Now;
DateTime bedTime = newDate.Date;
if (newDate.CompareTo(bedTime.AddHours(12)) >= 0) {
bedTime = bedTime.AddHours(12);
}
var appointments = (from ap in DEntities.Appointments
where (ap.DoctorID == doctorID) && (ap.Date == bedTime)
orderby ap.Rank
select ap);
int appointmentCount = appointments.Count();
allAppointmentEntity.Count = appointmentCount;
if (appointmentCount <= 0) {
allAppointmentEntity.ErrorMessage = "313 No Appointment! @Data";
}
else {
allAppointmentEntity.appointment = new AppointmentEntity[appointmentCount];
int cnt = 0;
foreach (var app in appointments) {
allAppointmentEntity.appointment[cnt] = new AppointmentEntity();
allAppointmentEntity.appointment[cnt].gGuid = app.AppointmentID;
allAppointmentEntity.appointment[cnt].UserID = app.UserID;
allAppointmentEntity.appointment[cnt].DoctorID = app.DoctorID;
allAppointmentEntity.appointment[cnt].Date = app.Date;
allAppointmentEntity.appointment[cnt].Rank = app.Rank;
if (app.Status == null) {
allAppointmentEntity.appointment[cnt].Finished = false;
}
else {
allAppointmentEntity.appointment[cnt].Finished = true;
}
cnt++;
}
}
return allAppointmentEntity;
}