/// <summary>
/// 获取标准诊断列表
/// </summary>
/// <returns></returns>
public string GetDiagnosisList()
{
return(base.ExecuteActionJsonResult("获取标准诊断列表", () =>
{
InpatientFilter filter = GetPageData <InpatientFilter>(0);
//List<CD_BasicInpatientInfo> list = inpatientService.GetAll(_CommonFilter).Where(f => f.IsCance != 1).ToList();//该表并无作废标志
List <AI_Diagnosis> list = operationRecordService.GetDiagnosisList(filter);
return new WebApi_Result()
{
data = list, count = list.Count
};
}));
}
/// <summary>
/// 获取住院病人列表
/// </summary>
/// <returns></returns>
public string GetAll()
{
return(base.ExecuteActionJsonResult("获取住院病人列表", () =>
{
InpatientFilter filter = GetPageData <InpatientFilter>(0);
//List<CD_BasicInpatientInfo> list = inpatientService.GetAll(_CommonFilter).Where(f => f.IsCance != 1).ToList();//该表并无作废标志
List <CD_BasicInpatientInfo> list = inpatientService.GetAll(filter);
int curpage = 0, limit = 3;
int.TryParse(Request["page"], out curpage);
int.TryParse(Request["limit"], out limit);
var myskip = curpage > 0 ? limit * (curpage - 1) : 0;
return new WebApi_Result()
{
data = list.Skip(myskip).Take(limit), count = list.Count
};
}));
}
/// <summary>
/// 根据筛选条件查询病案首页数据列表
/// </summary>
/// <param name="iFilter"></param>
/// <returns></returns>
public List <CD_MedicalRecordHomePage> GetAll(InpatientFilter iFilter)
{
string filter = "1=1";
if (!string.IsNullOrWhiteSpace(iFilter.keyword))
{
filter += string.Format(" and {1} like '%{0}%'", iFilter.keyword, iFilter.KeywordType);
}
filter += iFilter.GetQueryString();
List <CD_MedicalRecordHomePage> list = EntityOperate <CD_MedicalRecordHomePage> .GetEntityList(filter, "OrganID");
if (list == null || list.Count <= 0)
{
return(new List <CD_MedicalRecordHomePage>());
}
return(list);
}
/// <summary>
/// 获取手术记录列表
/// </summary>
/// <returns></returns>
public string GetAll()
{
return(base.ExecuteActionJsonResult("获取手术记录列表", () =>
{
InpatientFilter filter = GetPageData <InpatientFilter>(0);
//List<CD_BasicInpatientInfo> list = inpatientService.GetAll(_CommonFilter).Where(f => f.IsCance != 1).ToList();//该表并无作废标志
List <CD_OperationRecord> list = operationRecordService.GetAll(filter);
list.ForEach(f => {
f.AnesthesiaWayName = CommonService.GetDictNameByID("450", f.AnesthesiaWayCode + "");
f.HealingLevelName = CommonService.GetDictNameByID("343", f.HealingLevel + "");
f.OperationLevelName = CommonService.GetDictNameByID("170", f.OperationLevel + "");
});
int curpage = 0, limit = 3;
int.TryParse(Request["page"], out curpage);
int.TryParse(Request["limit"], out limit);
var myskip = curpage > 0 ? limit * (curpage - 1) : 0;
return new WebApi_Result()
{
data = list.Skip(myskip).Take(limit), count = list.Count
};
}));
}
/// <summary>
/// 根据筛选条件查询住院病人数据列表
/// </summary>
/// <param name="iFilter"></param>
/// <param name="where">其他条件</param>
/// <returns></returns>
public List <CD_Inpatient> GetAll(InpatientFilter iFilter, string where = "")
{
string filter = "1=1";
//关键词
if (!string.IsNullOrWhiteSpace(iFilter.keyword))
{
filter += string.Format(" and {1} like '%{0}%'", iFilter.keyword, iFilter.KeywordType);
}
//档案状态，1：在院，2：已出院，3：待归档，4：已归档
if (!string.IsNullOrWhiteSpace(iFilter.Status))
{
switch (iFilter.Status)
{
case "1": filter += string.Format(" and LeaveTime is null "); break; //在院
case "2": filter += string.Format(" and LeaveTime is not null and MedicalRecordState<>1 "); break; //已出院 不包括已归档
case "3": filter += string.Format(" and MedicalRecordState=0 "); break; //待归档
case "4": filter += string.Format(" and MedicalRecordState=1 "); break; //已归档
default: break;
}
}
//病历所属
if (!string.IsNullOrWhiteSpace(iFilter.Group) && !string.IsNullOrWhiteSpace(iFilter.UserID))
{
switch (iFilter.Group)
{
case "1": filter += string.Format(" and AttendingDoctorId='{0}' ", iFilter.UserID); break; //主诊医生过滤
case "4": filter += string.Format(" and INPATIENTID in (select INPATIENTID from CD_InpatientAuthorized where AUTHORIZEDPERSONID='{0}' and sysdate+numtodsinterval(-" + inpatientauthorizedservice.AuthorizedHours + ",'hour')<= AUTHORIZEDPERSONTIME) ", iFilter.UserID); break; //授权病人
case "5": filter += string.Format(" and CurrentDeptID in (select DPETID from GI_USERINFO where USERID='{0}') ", iFilter.UserID);; break; //本科室
default: break;
}
}
filter += iFilter.GetQueryString() + where;
List <CD_Inpatient> list = EntityOperate <CD_Inpatient> .GetEntityList(filter, "OrganID");
if (list == null || list.Count <= 0)
{
return(new List <CD_Inpatient>());
}
list.ForEach((f) => {
#region 科室和病区组
//科室
AI_DeptInfo deptInfo = EntityOperate <AI_DeptInfo> .GetEntityById(f.CurrentDeptID, "DeptID");
f.CurrentDeptName = deptInfo == null ? "" : deptInfo?.DeptName;
//病区
AI_DeptInfo Ward = EntityOperate <AI_DeptInfo> .GetEntityById(f.CurrentWardID, "DeptID");
f.CurrentWardName = Ward == null ? "" : Ward?.DeptName;
#endregion
});
return(list);
}
