public BaseResponse <IList <REGQUESTION> > GetEvaluationHis(NursingFilter request) { var response = new BaseResponse <IList <REGQUESTION> >(); var q = from n in unitOfWork.GetRepository <LTC_REGQUESTION>().dbSet.Where(m => m.FEENO == request.FeeNo.Value && m.QUESTIONID == request.QuestionId) join e in unitOfWork.GetRepository <LTC_EMPFILE>().dbSet on n.EVALUATEBY equals e.EMPNO into res from re in res.DefaultIfEmpty() orderby n.EVALDATE descending select new { OutValue = n, EmpName = re.EMPNAME }; Action <IList> mapperResponse = (IList list) => { response.Data = new List <REGQUESTION>(); foreach (dynamic item in list) { REGQUESTION newItem = Mapper.DynamicMap <REGQUESTION>(item.OutValue); newItem.EVALUATEBY = item.EmpName; response.Data.Add(newItem); } }; var result = q.ToList(); mapperResponse(result); return(response); }
public BaseResponse <IList <Evaluation> > QueryEvaluationList(NursingFilter request) { BaseResponse <IList <Evaluation> > response = new BaseResponse <IList <Evaluation> >(); LTC_QUESTION currentQuestion = unitOfWork.GetRepository <LTC_QUESTION>().dbSet.Where(x => x.CODE == request.Code && x.ORGID == SecurityHelper.CurrentPrincipal.OrgId).FirstOrDefault(); if (currentQuestion == null) { response.ResultCode = 2; response.ResultMessage = "請先維護" + request.Code + "評估表單數據!"; return(response); } List <Evaluation> list = null; request.Id = currentQuestion.QUESTIONID; response.Id = currentQuestion.QUESTIONID; if (request != null && request.PageSize > 0) { } else { StringBuilder sb = new StringBuilder(); string sql = string.Format(@" SELECT REG.REGNO,REG.NAME,REG.SEX,IPD.FEENO,Q.RECORDID, Q.EVALDATE,Q.NEXTEVALDATE, (SELECT EMPNAME FROM LTC_EMPFILE WHERE Q.EVALUATEBY=EMPNO) AS EVALUATEBY, (SELECT EMPNAME FROM LTC_EMPFILE WHERE Q.NEXTEVALUATEBY=EMPNO) AS NEXTEVALUATEBY, (SELECT COUNT(*) FROM LTC_REGQUESTION WHERE REGNO=REG.REGNO AND QUESTIONID={0}) AS QUANTITY FROM LTC_REGFILE REG LEFT JOIN (SELECT * FROM ( SELECT * FROM LTC_REGQUESTION ORDER BY EVALDATE DESC) T GROUP BY FEENO) Q ON REG.REGNO=Q.REGNO AND Q.QUESTIONID={0} INNER JOIN LTC_IPDREG IPD ON IPD.REGNO=REG.REGNO AND (IPD.IPDFLAG='I' OR IPD.IPDFLAG='N') WHERE REG.ORGID='{1}'", request.Id, SecurityHelper.CurrentPrincipal.OrgId); sb.Append(sql); if (request != null) { if (!string.IsNullOrEmpty(request.Name)) { sb.Append(string.Format(" AND REG.NAME like '%{0}%'", request.Name)); } if (request.FeeNo.HasValue && request.FeeNo.Value > 0) { sb.Append(string.Format(" AND IPD.FEENO {0}", request.FeeNo.Value)); } if (!string.IsNullOrEmpty(request.Sex)) { sb.Append(string.Format(" AND REG.SEX= '{0}' ", request.Sex)); } } list = unitOfWork.GetRepository <Evaluation>().SqlQuery(sb.ToString()).ToList(); // list.ForEach(p => p.SEX = CodeHelper.GetItemName(p.SEX, "A00.001")); } response.Data = list; return(response); }
public BaseResponse <IList <CareDemandEval> > QueryCareDemandHis(NursingFilter requestData) { BaseRequest <NursingFilter> request = new BaseRequest <NursingFilter>(); request.Data = requestData; request.PageSize = 0; var response = base.Query <LTC_CAREDEMANDEVAL, CareDemandEval>(request, (q) => { q = q.Where(m => m.FEENO == request.Data.FeeNo.Value); return(q); }); return(response); }
public BaseResponse <IList <EvaluationRecord> > QueryNurDemandEvalList(NursingFilter request) { BaseResponse <IList <EvaluationRecord> > response = new BaseResponse <IList <EvaluationRecord> >(); List <EvaluationRecord> list = null; if (request != null && request.PageSize > 0) { } else { StringBuilder sb = new StringBuilder(); string sql = string.Format(@"SELECT REG.REGNO,REG.RESIDENGNO,REG.NAME,REG.SEX,IPD.FEENO,Q.ID, Q.EVALDATE,Q.NEXTEVALDATE, (SELECT EMPNAME FROM LTC_EMPFILE WHERE Q.EVALUATEBY=EMPNO) AS EVALUATEBY, (SELECT EMPNAME FROM LTC_EMPFILE WHERE Q.NEXTEVALUATEBY=EMPNO) AS NEXTEVALUATEBY ,(SELECT COUNT(*) FROM LTC_CAREDEMANDEVAL WHERE FEENO=IPD.FEENO ) AS QUANTITY FROM LTC_IPDREG IPD LEFT JOIN (SELECT * FROM( select * from LTC_CAREDEMANDEVAL ORDER BY EVALDATE ) T GROUP BY FEENO) Q ON IPD.FEENO=Q.FEENO INNER JOIN LTC_REGFILE REG ON IPD.REGNO=REG.REGNO AND IPD.IPDFLAG='I' WHERE REG.ORGID='{0}'", SecurityHelper.CurrentPrincipal.OrgId); sb.Append(sql); if (request != null) { if (!string.IsNullOrEmpty(request.Name)) { sb.Append(string.Format(" AND REG.NAME like '%{0}%'", request.Name)); } if (request.FeeNo.HasValue && request.FeeNo.Value > 0) { sb.Append(string.Format(" AND IPD.FEENO = {0}", request.FeeNo.Value)); } if (!string.IsNullOrEmpty(request.residengno)) { sb.Append(string.Format(" AND REG.RESIDENGNO = {0}", request.residengno)); } if (!string.IsNullOrEmpty(request.Sex)) { sb.Append(string.Format(" AND REG.SEX= '{0}' ", request.Sex)); } } list = unitOfWork.GetRepository <EvaluationRecord>().SqlQuery(sb.ToString()).ToList(); //list.ForEach(p => p.SEX = CodeHelper.GetItemName(p.SEX, "A00.001")); } response.Data = list; return(response); }
public IHttpActionResult Query([FromUri] NursingFilter request) { try { var response = nursingSvc.QueryNurDemandEvalList(request); return(Ok(response)); } catch (Exception ex) { LogHelper.WriteError(ex.ToString()); return(Ok(new BaseResponse <string> { ResultCode = (int)EnumResponseStatus.ExceptionHappened, ResultMessage = "操作异常" })); } }
//針劑 原始 // public BaseResponse<IList<InjectionView>> QueryInjection(NursingFilter request) // { // BaseResponse<IList<InjectionView>> response = new BaseResponse<IList<InjectionView>>(); // List<InjectionView> list = null; // // // if (request.RegNO == -1) // { // } // else // { // StringBuilder sb = new StringBuilder(); // string sql = string.Format(@"SELECT * FROM( // SELECT REG.REGNO,IPD.FEENO,REG.NAME,INJECT.ITEMTYPE,INJECT.STATE,INJECT.INJECTDATE, // (SELECT EMPNAME FROM LTC_EMPFILE WHERE EMPNO=INJECT.OPERATOR) AS OPERATOR,INJECT.TRACESTATE, INJECT.ID, // ROW_NUMBER() OVER (PARTITION BY REG.REGNO ORDER BY INJECTDATE) AS GROUP_IDX // ,(SELECT COUNT(*) FROM dbo.LTC_VACCINEINJECT WHERE REGNO=REG.REGNO) AS QUANTITY // FROM dbo.LTC_REGFILE REG // LEFT JOIN dbo.LTC_VACCINEINJECT INJECT // ON REG.REGNO=INJECT.REGNO // INNER JOIN LTC_IPDREG IPD // ON IPD.REGNO=REG.REGNO AND (IPD.IPDFLAG='I' OR IPD.IPDFLAG='N') // WHERE REG.ORGID='{0}' // ) T // WHERE T.GROUP_IDX=1 ", SecurityHelper.CurrentPrincipal.OrgId); // sb.Append(sql); // if (request != null) // { // if (request.RegNO>1) // { // sb.Append(string.Format(" AND REGNO='{0}'", request.RegNO)); // } // //if (!string.IsNullOrEmpty(request.Name)) // //{ // // sb.Append(string.Format(" AND NAME LIKE '%{0}%'", request.Name)); // //} // //if (!string.IsNullOrEmpty(request.Date)) // //{ // // sb.Append(string.Format(" AND INJECTDATE= CONVERT(DATE,'{0}',120) ", request.Date)); // //} // } // list = unitOfWork.GetRepository<InjectionView>().SqlQuery(sb.ToString()).ToList(); // } // response.Data = list; // return response; // } // 針劑 姚丙慧 public BaseResponse <IList <Vaccineinject> > QueryInjection(NursingFilter request) { var response = new BaseResponse <IList <Vaccineinject> >(); //这边获取list的集合 List <Vaccineinject> CheckReclist = new List <Vaccineinject>(); List <LTC_VACCINEINJECT> regQuestion = unitOfWork.GetRepository <LTC_VACCINEINJECT>().dbSet.Where(m => m.REGNO == request.RegNO).ToList(); Mapper.CreateMap <LTC_VACCINEINJECT, Vaccineinject>(); Mapper.Map(regQuestion, CheckReclist); response.Data = CheckReclist; response.RecordsCount = regQuestion.Count; response.Data = CheckReclist.OrderByDescending(m => m.ID).Skip((request.CurrentPage - 1) * request.PageSize).Take(request.PageSize).ToList(); response.PagesCount = GetPagesCount(request.PageSize, response.RecordsCount); return(response); }
public BaseResponse <IList <CareDemandEval> > QueryCareDemandHis(NursingFilter requestData) { BaseRequest <NursingFilter> request = new BaseRequest <NursingFilter>(); request.Data = requestData; request.PageSize = 0; BaseResponse <IList <CareDemandEval> > response = new BaseResponse <IList <CareDemandEval> >(); var q = from n in unitOfWork.GetRepository <LTC_CAREDEMANDEVAL>().dbSet join e in unitOfWork.GetRepository <LTC_EMPFILE>().dbSet on n.EVALUATEBY equals e.EMPNO into res from re in res.DefaultIfEmpty() select new { CareDemandRec = n, EVALUATEName = re.EMPNAME }; if (request.Data.FeeNo.HasValue) { q = q.Where(m => m.CareDemandRec.FEENO == request.Data.FeeNo); } Action <IList> mapperResponse = (IList list) => { response.Data = new List <CareDemandEval>(); foreach (dynamic item in list) { CareDemandEval newItem = Mapper.DynamicMap <CareDemandEval>(item.CareDemandRec); newItem.EVALUATEName = item.EVALUATEName; response.Data.Add(newItem); } }; if (request != null && request.PageSize > 0) { var list = q.Skip((request.CurrentPage - 1) * request.PageSize).Take(request.PageSize).ToList(); response.PagesCount = GetPagesCount(request.PageSize, response.RecordsCount); mapperResponse(list); } else { var list = q.ToList(); mapperResponse(list); } return(response); }
public IHttpActionResult Query(int currentPage, int pageSize, int regno) { NursingFilter request = new NursingFilter(); request.RegNO = regno; request.CurrentPage = currentPage; request.PageSize = pageSize; try { var response = injectionSvc.QueryInjection(request); return(Ok(response)); } catch (Exception ex) { LogHelper.WriteError(ex.ToString()); return(Ok(new BaseResponse <string> { ResultCode = (int)EnumResponseStatus.ExceptionHappened, ResultMessage = "操作异常" })); } }