public List <DateTime?> GetListTime(string selectType, string yearMonth)
{
List <DateTime?> lstResult = new List <DateTime?>();
using (DepotManagementDataContext ctx = CommentParameter.DepotDataContext)
{
var varNextData = from a in ctx.Sys_RunLog
where a.YearMonth == ctx.Fun_get_NextYearMonth(yearMonth) &&
a.RecordType == selectType
select a;
var varNowData = from a in ctx.Sys_RunLog
where a.YearMonth == yearMonth &&
a.RecordType == selectType
select a;
var varPrevData = from a in ctx.Sys_RunLog
where a.YearMonth == ctx.Fun_get_PrevYearMonth(yearMonth) &&
a.RecordType == selectType
select a;
if (varNowData.Count() > 0)
{
if (varNextData.Count() > 0)
{
lstResult.Add(varNowData.ToList().OrderByDescending(k => k.RecordTime).First().StartTime);
lstResult.Add(varNowData.ToList().OrderByDescending(k => k.RecordTime).First().EndTime);
return(lstResult);
}
}
lstResult.Add(varPrevData.ToList().OrderByDescending(k => k.RecordTime).First().EndTime);
lstResult.Add(null);
}
return(lstResult);
}
