private Expression <Func <InlinePeopleEntity, bool> > ListFilter(InlinePeopleListParam param)
{
var expression = LinqExtensions.True <InlinePeopleEntity>();
if (param != null)
{
if (!string.IsNullOrEmpty(param.sId))
{
expression = expression.And(t => t.sId.Contains(param.sId));
}
if (!string.IsNullOrEmpty(param.dtCheckIn.ParseToString()))
{
var endtime = (param.dtCheckIn.Value.ToString("yyyy-MM-dd") + " 23:59:59").ParseToDateTime();
expression = expression.And(t => t.dtCheckIn <= endtime && t.dtCheckIn >= param.dtCheckIn);
}
if (param.nType > -1)
{
expression = expression.And(t => t.nType.Equals(param.nType));
}
if (!string.IsNullOrEmpty(param.sPatientId))
{
expression = expression.And(t => t.sPatientId.Equals(param.sPatientId));
}
}
return(expression);
}
public async Task <List <InlinePeopleEntity> > GetPageList(InlinePeopleListParam param, Pagination pagination)
{
var expression = ListFilter(param);
var list = await this.BaseRepository().FindList(expression, pagination);
return(list.ToList());
}
public async Task <TData <List <InlinePeopleEntity> > > GetPageList(InlinePeopleListParam param, Pagination pagination)
{
TData <List <InlinePeopleEntity> > obj = new TData <List <InlinePeopleEntity> >();
obj.Data = await inlinePeopleService.GetPageList(param, pagination);
obj.Total = pagination.TotalCount;
obj.Tag = 1;
return(obj);
}
public async Task <TData <List <InlinePeopleEntity> > > GetList(InlinePeopleListParam param)
{
TData <List <InlinePeopleEntity> > obj = new TData <List <InlinePeopleEntity> >();
obj.Data = await inlinePeopleService.GetList(param);
obj.Total = obj.Data.Count;
obj.Tag = 1;
return(obj);
}
private Expression <Func <InlinePeopleEntity, bool> > ListFilter(InlinePeopleListParam param)
{
var expression = LinqExtensions.True <InlinePeopleEntity>();
if (param != null)
{
if (param.sPatIdArr != null && param.sPatIdArr.Length > 0)
{
expression = expression.And(t => param.sPatIdArr.Contains(t.sPatientId) && t.nType != (int)nTypeEnum.Patient);
}
if (param.Ids != null && param.Ids.Length > 0)
{
expression = expression.And(t => param.Ids.ToList().Contains((t.Id ?? 0)));
}
if (!string.IsNullOrEmpty(param.sId))
{
if (!string.IsNullOrEmpty(param.RequestMethod) && param.RequestMethod.Equals("webapi"))
{
expression = expression.And(t => t.sId.Equals(param.sId));
}
else
{
expression = expression.And(t => t.sId.Contains(param.sId));
}
}
if (!string.IsNullOrEmpty(param.dtCheckIn))
{
var DateArr = param.dtCheckIn.Split('-');
var sa = DateArr[0] + "-" + DateArr[1] + "-" + DateArr[2];
var saa = DateArr[3] + "-" + DateArr[4] + "-" + DateArr[5];
var startTime = DateTime.Parse(sa);
var endTime = DateTime.Parse(saa);
expression = expression.And(t => t.dtCheckIn <= endTime && t.dtCheckIn >= startTime);
//var endtime = (param.dtCheckIn.Value.ToString("yyyy-MM-dd") + " 23:59:59").ParseToDateTime();
//expression = expression.And(t => t.dtCheckIn <= endtime&&t.dtCheckIn>=param.dtCheckIn);
}
if (param.nType > -1)
{
expression = expression.And(t => t.nType.Equals(param.nType));
}
if (!string.IsNullOrEmpty(param.sPatientId))
{
expression = expression.And(t => t.sPatientId.Equals(param.sPatientId));
}
}
return(expression);
}
public async Task <ActionResult> GetInLineDetailJson(InlinePeopleListParam param, Pagination pagination)
{
TData <List <HospMonitorInLinePeopleViewModel> > obj = await inlinePeopleBLL.GetInLineDetailsList(param, pagination);
return(Json(obj));
}
public async Task <ActionResult> GetPageListJson(InlinePeopleListParam param, Pagination pagination)
{
TData <List <InlinePeopleEntity> > obj = await inlinePeopleBLL.GetPageList(param, pagination);
return(Json(obj));
}
public async Task <TData <List <HospMonitorInLinePeopleViewModel> > > GetInLineDetailsList(InlinePeopleListParam param, Pagination pagination = null)
{
TData <List <HospMonitorInLinePeopleViewModel> > obj = new TData <List <HospMonitorInLinePeopleViewModel> >();
List <InlinePeopleEntity> inlinePeopleEntities = null;
if (pagination != null)
{
inlinePeopleEntities = await inlinePeopleService.GetPageList(param, pagination);
}
else
{
inlinePeopleEntities = await inlinePeopleService.GetList(param);
}
if (inlinePeopleEntities == null)
{
obj.Tag = 0;
obj.Message = "查询失败";
return(obj);
}
BaseInfoListParam baseInfoListParam = new BaseInfoListParam
{
sId = param.sId,
sName = param.sName
};
List <BaseInfoEntity> baseInfoEntities = await baseInfoService.GetList(baseInfoListParam);
#region 左外连
//obj.Data = (from inline in inlinePeopleEntities
// join baseInfo in baseInfoEntities on inline.sId equals baseInfo.sId into InLineDetails
// from details in InLineDetails.DefaultIfEmpty()
// select new HospMonitorInLinePeopleViewModel
// {
// Id = inline.Id.ToString(),
// sId = details?.sId,
// nType = inline.nType,
// dtCheckIn = inline.dtCheckIn,
// sPatientId = inline.sPatientId,
// sName = details?.sName,
// sPhone = details?.sPhone,
// sAddress = details?.sAddress,
// sBedNo = details?.sBedNo,
// sArea = details?.sArea,
// sDoc = details?.sDoc,
// sSex = details?.sSex,
// sAge = details?.sAge,
// sRemarks = details?.sRemarks,
// sExtend = details?.sExtend
// }).ToList();
#endregion
#region 内联
obj.Data =
(from inline in inlinePeopleEntities
join baseInfo in baseInfoEntities on inline.sId equals baseInfo.sId
select new HospMonitorInLinePeopleViewModel
{
Id = inline.Id.ToString(),
sId = inline?.sId,
nType = inline.nType,
dtCheckIn = inline.dtCheckIn,
sPatientId = inline.sPatientId,
sName = baseInfo?.sName,
sPhone = baseInfo?.sPhone,
sAddress = baseInfo?.sAddress,
sBedNo = baseInfo?.sBedNo,
sArea = baseInfo?.sArea,
sDoc = baseInfo?.sDoc,
sSex = baseInfo?.sSex,
sAge = baseInfo?.sAge,
sRemarks = baseInfo?.sRemarks,
sExtend = baseInfo?.sExtend
}).ToList();
#endregion
obj.Total = pagination?.TotalCount ?? 0;
obj.Tag = 1;
return(obj);
}