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 = "操作异常"
}));
}
}
