/*获取医师信息:提交科室编号,返回该科室的所有医师的信息*/ public AllDoctorInfoEntity GetAllDoctorInfo(string sectionID) { DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities(); /*查询SectionID域匹配的所有Doctor记录*/ var doctors = from d in DEntities.Doctors where d.SectionID == sectionID orderby d.DoctorID select d; int cnt = 0; int doctorCount = doctors.Count(); AllDoctorInfoEntity allDoctorInfoEntity = null; if (doctorCount > 0) { allDoctorInfoEntity = new AllDoctorInfoEntity(); allDoctorInfoEntity.Count = doctorCount; allDoctorInfoEntity.doctorInfoEntity = new DoctorInfoEntity[doctorCount]; foreach (var d in doctors) { allDoctorInfoEntity.doctorInfoEntity[cnt] = new DoctorInfoEntity(); allDoctorInfoEntity.doctorInfoEntity[cnt].SectionID = d.SectionID; allDoctorInfoEntity.doctorInfoEntity[cnt].DoctorID = d.DoctorID; allDoctorInfoEntity.doctorInfoEntity[cnt].UserID = d.UserID; allDoctorInfoEntity.doctorInfoEntity[cnt].LastName = d.LastName; allDoctorInfoEntity.doctorInfoEntity[cnt].FirstName = d.FirstName; allDoctorInfoEntity.doctorInfoEntity[cnt].Designation = d.Designation; allDoctorInfoEntity.doctorInfoEntity[cnt].Resume = d.Resume; allDoctorInfoEntity.doctorInfoEntity[cnt].Phone = d.Phone; allDoctorInfoEntity.doctorInfoEntity[cnt].Fax = d.Fax; allDoctorInfoEntity.doctorInfoEntity[cnt].Email = d.Email; allDoctorInfoEntity.doctorInfoEntity[cnt].Vocation = d.Vocation; allDoctorInfoEntity.doctorInfoEntity[cnt].Portrait = d.Portrait; cnt++; } } return allDoctorInfoEntity; }
/*搜索医师信息:提交关键词,返回含有该关键词的所有医师的信息*/ public AllDoctorInfoEntity FindDoctorByName(string keyword) { DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities(); /*查询Name域包含keyword的所有Doctor记录*/ keyword = keyword.ToLower(); var doctors = from d in DEntities.Doctors where (d.LastName + " " + d.FirstName).ToLower().Contains(keyword) || (d.FirstName + " " + d.LastName).ToLower().Contains(keyword) //orderby d.DoctorID select d; int cnt = 0; int doctorCount = doctors.Count(); AllDoctorInfoEntity allDoctorInfoEntity = null; if (doctorCount > 0) { allDoctorInfoEntity = new AllDoctorInfoEntity(); allDoctorInfoEntity.Count = doctorCount; allDoctorInfoEntity.doctorInfoEntity = new DoctorInfoEntity[doctorCount]; foreach (var d in doctors) { allDoctorInfoEntity.doctorInfoEntity[cnt] = new DoctorInfoEntity(); allDoctorInfoEntity.doctorInfoEntity[cnt].SectionID = d.SectionID; allDoctorInfoEntity.doctorInfoEntity[cnt].DoctorID = d.DoctorID; allDoctorInfoEntity.doctorInfoEntity[cnt].UserID = d.UserID; allDoctorInfoEntity.doctorInfoEntity[cnt].LastName = d.LastName; allDoctorInfoEntity.doctorInfoEntity[cnt].FirstName = d.FirstName; allDoctorInfoEntity.doctorInfoEntity[cnt].Designation = d.Designation; allDoctorInfoEntity.doctorInfoEntity[cnt].Resume = d.Resume; allDoctorInfoEntity.doctorInfoEntity[cnt].Phone = d.Phone; allDoctorInfoEntity.doctorInfoEntity[cnt].Fax = d.Fax; allDoctorInfoEntity.doctorInfoEntity[cnt].Email = d.Email; allDoctorInfoEntity.doctorInfoEntity[cnt].Vocation = d.Vocation; allDoctorInfoEntity.doctorInfoEntity[cnt].Portrait = d.Portrait; cnt++; } } return allDoctorInfoEntity; }
/*搜索医师信息:提交关键词,返回含有该关键词的所有医师的信息*/ public AllDoctorInfoEntity FindDoctorByName(string keyword) { AllDoctorInfoEntity allDoctorInfoEntity = openAccessDAO.FindDoctorByName(keyword); if (allDoctorInfoEntity == null) { allDoctorInfoEntity = new AllDoctorInfoEntity(); allDoctorInfoEntity.ErrorMessage = "152 No Doctors of " + keyword + "! @Logic"; } return allDoctorInfoEntity; }
/*获取医师信息:提交科室编号,返回该科室的所有医师的信息*/ public AllDoctorInfoEntity GetAllDoctorInfo(string sectionID) { AllDoctorInfoEntity allDoctorInfoEntity = openAccessDAO.GetAllDoctorInfo(sectionID); if (allDoctorInfoEntity == null) { allDoctorInfoEntity = new AllDoctorInfoEntity(); allDoctorInfoEntity.ErrorMessage = "133 No Doctors in " + sectionID + "! @Logic"; } return allDoctorInfoEntity; }
/*将AllDoctorInfo对应的Entity翻译为数据契约,调用TranslateDoctorInfoEntityToDoctorInfoContractData()*/ private void TranslateAllDoctorInfoEntityToAllDoctorInfoContractData( AllDoctorInfoEntity allDoctorInfoEntity, AllDoctorInfo allDoctorInfo) { int cnt = 0; allDoctorInfo.ErrorMessage = allDoctorInfoEntity.ErrorMessage; allDoctorInfo.Count = allDoctorInfoEntity.Count; if (allDoctorInfo.Count > 0) { allDoctorInfo.doctorInfo = new DoctorInfo[allDoctorInfo.Count]; for (cnt = 0; cnt < allDoctorInfo.Count; cnt++) { allDoctorInfo.doctorInfo[cnt] = new DoctorInfo(); TranslateDoctorInfoEntityToDoctorInfoContractData( allDoctorInfoEntity.doctorInfoEntity[cnt], allDoctorInfo.doctorInfo[cnt]); } } }
/*搜索医师信息:提交关键词,返回含有该关键词的所有医师的信息*/ public AllDoctorInfo FindDoctorByName(string keyword) { AllDoctorInfoEntity allDoctorInfoEntity = null; if (keyword == null) { allDoctorInfoEntity = new AllDoctorInfoEntity(); allDoctorInfoEntity.ErrorMessage = "122 Empty Keyword of DoctorName! @Service"; } else { allDoctorInfoEntity = openAccessLogic.FindDoctorByName(keyword); } AllDoctorInfo allDoctorInfo = new AllDoctorInfo(); TranslateAllDoctorInfoEntityToAllDoctorInfoContractData(allDoctorInfoEntity, allDoctorInfo); return allDoctorInfo; }
/*获取医师信息:提交科室编号,返回该科室的所有医师的信息*/ public AllDoctorInfo GetAllDoctorInfo(string sectionID) { AllDoctorInfoEntity allDoctorInfoEntity = null; if (sectionID == null) { allDoctorInfoEntity = new AllDoctorInfoEntity(); allDoctorInfoEntity.ErrorMessage = "103 Empty SectionID! @Service"; } else { allDoctorInfoEntity = openAccessLogic.GetAllDoctorInfo(sectionID); } AllDoctorInfo allDoctorInfo = new AllDoctorInfo(); TranslateAllDoctorInfoEntityToAllDoctorInfoContractData(allDoctorInfoEntity, allDoctorInfo); return allDoctorInfo; }