public static IEnumerable<patient_queue> PatientWaitingList(HQSWcfService.shinetriageEntities entities, queue_type queue_typeData, int Count)
{
var triageData = queue_typeData.triage;
int dayOfWeek = (int)DateTime.Now.DayOfWeek;
var queueTypeEnable = (
triageData.triage_type == 1 && queue_typeData.rlt_doctor2queue_type.Count(rlt => rlt.queue_type.triage_id == triageData.triage_id
&& rlt.onduty[dayOfWeek] != '0'
&& (DateTime.Now.Hour < 12 ? rlt.onduty[dayOfWeek] != '3' :
rlt.onduty[dayOfWeek] != '2')) == 1)
||
(triageData.triage_type == 2 && queue_typeData.rlt_pager2queue_type.Count(rlt => rlt.queue_type.triage_id == triageData.triage_id
&& rlt.onduty[dayOfWeek] != '0'
&& (DateTime.Now.Hour < 12 ? rlt.onduty[dayOfWeek] != '3' :
rlt.onduty[dayOfWeek] != '2')) == 1);
var patientQueueList = from patientQueueData in entities.patient_queue
where !patientQueueData.is_call
&& patientQueueData.queue_type_id == queue_typeData.queue_type_id
&& patientQueueData.state_triage != 5
&& (queueTypeEnable || (!patientQueueData.call_time.HasValue && patientQueueData.state_triage != 1))
orderby
patientQueueData.time_interval,
patientQueueData.is_priority descending,
patientQueueData.sub_queue_order descending,
patientQueueData.queue_num,
patientQueueData.fre_date
select patientQueueData;
var listPriority = (from p in patientQueueList
where p.is_priority
orderby p.opr_time
select p
).Take(Count).ToList();
if (listPriority.Count() == Count)
return listPriority;
var listFirst = (from p in patientQueueList
where !p.is_priority && p.state_call == 0 && p.state_triage == 0
select p).Take(Count).ToList();
var listPass = (from p in patientQueueList
where !p.is_priority && p.state_call == 1
orderby p.opr_time
select p).Take(Count).ToList();
var listReturn = (from p in patientQueueList
where !p.is_call && !p.is_priority && p.state_triage == 1 && p.state_call != 1
orderby p.opr_time
select p).Take(Count).ToList();
var tmpFirst = from p in listFirst
select new
{
data = p,
index = listFirst.IndexOf(p)
};
var tmpPass = from p in listPass
select new
{
data = p,
index = listPass.Take(listPass.IndexOf(p) + 1).Sum(t => t.return_flag).Value
};
var listFirstAndPass = (from p in tmpFirst.Union(tmpPass)
orderby p.index, p.data.state_call descending
select p.data).ToList();
var rtn = listPriority.Union(
from patient in
(
(from p in listFirstAndPass
select new
{
data = p,
index = listFirstAndPass.IndexOf(p)
}).Union(
from p in listReturn
select new
{
data = p,
index = listReturn.Take(listReturn.IndexOf(p) + 1).Sum(t => t.return_flag).Value
}
)
)
orderby patient.index, patient.data.state_triage descending
select patient.data).Take(Count);
return rtn;
}
public static IEnumerable <patient_queue> PatientWaitingList(HQSWcfService.shinetriageEntities entities, queue_type queue_typeData, int Count)
{
var triageData = queue_typeData.triage;
int dayOfWeek = (int)DateTime.Now.DayOfWeek;
var queueTypeEnable = (
triageData.triage_type == 1 && queue_typeData.rlt_doctor2queue_type.Count(rlt => rlt.queue_type.triage_id == triageData.triage_id &&
rlt.onduty[dayOfWeek] != '0' &&
(DateTime.Now.Hour < 12 ? rlt.onduty[dayOfWeek] != '3' :
rlt.onduty[dayOfWeek] != '2')) == 1)
||
(triageData.triage_type == 2 && queue_typeData.rlt_pager2queue_type.Count(rlt => rlt.queue_type.triage_id == triageData.triage_id &&
rlt.onduty[dayOfWeek] != '0' &&
(DateTime.Now.Hour < 12 ? rlt.onduty[dayOfWeek] != '3' :
rlt.onduty[dayOfWeek] != '2')) == 1);
var patientQueueList = from patientQueueData in entities.patient_queue
where !patientQueueData.is_call &&
patientQueueData.queue_type_id == queue_typeData.queue_type_id &&
patientQueueData.state_triage != 5 &&
(queueTypeEnable || (!patientQueueData.call_time.HasValue && patientQueueData.state_triage != 1))
orderby
patientQueueData.time_interval,
patientQueueData.is_priority descending,
patientQueueData.sub_queue_order descending,
patientQueueData.queue_num,
patientQueueData.fre_date
select patientQueueData;
var listPriority = (from p in patientQueueList
where p.is_priority
orderby p.opr_time
select p
).Take(Count).ToList();
if (listPriority.Count() == Count)
{
return(listPriority);
}
var listFirst = (from p in patientQueueList
where !p.is_priority && p.state_call == 0 && p.state_triage == 0
select p).Take(Count).ToList();
var listPass = (from p in patientQueueList
where !p.is_priority && p.state_call == 1
orderby p.opr_time
select p).Take(Count).ToList();
var listReturn = (from p in patientQueueList
where !p.is_call && !p.is_priority && p.state_triage == 1 && p.state_call != 1
orderby p.opr_time
select p).Take(Count).ToList();
var tmpFirst = from p in listFirst
select new
{
data = p,
index = listFirst.IndexOf(p)
};
var tmpPass = from p in listPass
select new
{
data = p,
index = listPass.Take(listPass.IndexOf(p) + 1).Sum(t => t.return_flag).Value
};
var listFirstAndPass = (from p in tmpFirst.Union(tmpPass)
orderby p.index, p.data.state_call descending
select p.data).ToList();
var rtn = listPriority.Union(
from patient in
(
(from p in listFirstAndPass
select new
{
data = p,
index = listFirstAndPass.IndexOf(p)
}).Union(
from p in listReturn
select new
{
data = p,
index = listReturn.Take(listReturn.IndexOf(p) + 1).Sum(t => t.return_flag).Value
}
)
)
orderby patient.index, patient.data.state_triage descending
select patient.data).Take(Count);
return(rtn);
}