/*获取科室信息：提交医院编号，返回该医院的所有科室的信息*/
public AllSectionInfoEntity GetAllSectionInfo(string hospitalID) {
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
/*查询HospitalID域匹配的所有Section记录*/
var sections = from s in DEntities.Sections
where s.HospitalID == hospitalID
orderby s.SectionID
select s;
int cnt = 0;
int sectionCount = sections.Count();
AllSectionInfoEntity allSectionInfoEntity = null;
if (sectionCount > 0) {
allSectionInfoEntity = new AllSectionInfoEntity();
allSectionInfoEntity.Count = sectionCount;
allSectionInfoEntity.sectionInfoEntity = new SectionInfoEntity[sectionCount];
foreach (var s in sections) {
allSectionInfoEntity.sectionInfoEntity[cnt] = new SectionInfoEntity();
allSectionInfoEntity.sectionInfoEntity[cnt].HospitalID = s.HospitalID;
allSectionInfoEntity.sectionInfoEntity[cnt].SectionID = s.SectionID;
allSectionInfoEntity.sectionInfoEntity[cnt].Place = s.Place;
allSectionInfoEntity.sectionInfoEntity[cnt].Name = s.Name;
allSectionInfoEntity.sectionInfoEntity[cnt].Phone = s.Phone;
allSectionInfoEntity.sectionInfoEntity[cnt].Fax = s.Fax;
cnt++;
}
}
return allSectionInfoEntity;
}
/*搜索科室信息：提交关键词，返回含有该关键词的所有科室的信息*/
public AllSectionInfoEntity FindSectionByName(string keyword) {
DrPEDatabaseEntities DEntities = new DrPEDatabaseEntities();
/*查询Name域包含keyword的所有Section记录*/
keyword = keyword.ToLower();
var sections = from s in DEntities.Sections
where s.Name.ToLower().Contains(keyword)
//orderby s.sectionID
select s;
int cnt = 0;
int sectionCount = sections.Count();
AllSectionInfoEntity allSectionInfoEntity = null;
if (sectionCount > 0) {
allSectionInfoEntity = new AllSectionInfoEntity();
allSectionInfoEntity.Count = sectionCount;
allSectionInfoEntity.sectionInfoEntity = new SectionInfoEntity[sectionCount];
foreach (var s in sections) {
allSectionInfoEntity.sectionInfoEntity[cnt] = new SectionInfoEntity();
allSectionInfoEntity.sectionInfoEntity[cnt].HospitalID = s.HospitalID;
allSectionInfoEntity.sectionInfoEntity[cnt].SectionID = s.SectionID;
allSectionInfoEntity.sectionInfoEntity[cnt].Place = s.Place;
allSectionInfoEntity.sectionInfoEntity[cnt].Name = s.Name;
allSectionInfoEntity.sectionInfoEntity[cnt].Phone = s.Phone;
allSectionInfoEntity.sectionInfoEntity[cnt].Fax = s.Fax;
cnt++;
}
}
return allSectionInfoEntity;
}
/*获取科室信息：提交医院编号，返回该医院的所有科室的信息*/
public AllSectionInfoEntity GetAllSectionInfo(string hospitalID) {
AllSectionInfoEntity allSectionInfoEntity = openAccessDAO.GetAllSectionInfo(hospitalID);
if (allSectionInfoEntity == null) {
allSectionInfoEntity = new AllSectionInfoEntity();
allSectionInfoEntity.ErrorMessage = "132 No Sections in " + hospitalID + "! @Logic";
}
return allSectionInfoEntity;
}
/*搜索科室信息：提交关键词，返回含有该关键词的所有科室的信息*/
public AllSectionInfoEntity FindSectionByName(string keyword) {
AllSectionInfoEntity allSectionInfoEntity = openAccessDAO.FindSectionByName(keyword);
if (allSectionInfoEntity == null) {
allSectionInfoEntity = new AllSectionInfoEntity();
allSectionInfoEntity.ErrorMessage = "151 No Sections of " + keyword + "! @Logic";
}
return allSectionInfoEntity;
}
/*将AllSectionInfo对应的Entity翻译为数据契约，调用TranslateSectionInfoEntityToSectionInfoContractData()*/
private void TranslateAllSectionInfoEntityToAllSectionInfoContractData(
AllSectionInfoEntity allSectionInfoEntity,
AllSectionInfo allSectionInfo) {
int cnt = 0;
allSectionInfo.ErrorMessage = allSectionInfoEntity.ErrorMessage;
allSectionInfo.Count = allSectionInfoEntity.Count;
if (allSectionInfo.Count > 0) {
allSectionInfo.sectionInfo = new SectionInfo[allSectionInfo.Count];
for (cnt = 0; cnt < allSectionInfo.Count; cnt++) {
allSectionInfo.sectionInfo[cnt] = new SectionInfo();
TranslateSectionInfoEntityToSectionInfoContractData(
allSectionInfoEntity.sectionInfoEntity[cnt],
allSectionInfo.sectionInfo[cnt]);
}
}
}
/*搜索科室信息：提交关键词，返回含有该关键词的所有科室的信息*/
public AllSectionInfo FindSectionByName(string keyword) {
AllSectionInfoEntity allSectionInfoEntity = null;
if (keyword == null) {
allSectionInfoEntity = new AllSectionInfoEntity();
allSectionInfoEntity.ErrorMessage = "121 Empty Keyword of SectionName! @Service";
}
else {
allSectionInfoEntity = openAccessLogic.FindSectionByName(keyword);
}
AllSectionInfo allSectionInfo = new AllSectionInfo();
TranslateAllSectionInfoEntityToAllSectionInfoContractData(allSectionInfoEntity, allSectionInfo);
return allSectionInfo;
}
/*获取科室信息：提交医院编号，返回该医院的所有科室的信息*/
public AllSectionInfo GetAllSectionInfo(string hospitalID) {
AllSectionInfoEntity allSectionInfoEntity = null;
if (hospitalID == null) {
allSectionInfoEntity = new AllSectionInfoEntity();
allSectionInfoEntity.ErrorMessage = "102 Empty HospitalID! @Service";
}
else {
allSectionInfoEntity = openAccessLogic.GetAllSectionInfo(hospitalID);
}
AllSectionInfo allSectionInfo = new AllSectionInfo();
TranslateAllSectionInfoEntityToAllSectionInfoContractData(allSectionInfoEntity, allSectionInfo);
return allSectionInfo;
}