public void ShowEntranceGuardInfo(EntranceGuardActionInfo data)
{
NameEntranceGuard.text = data.Name.ToString();
AreaEntranceGuard.text = data.AreadName.ToString();
CardEntranceGuard.text = data.Code.ToString();
TimeEntranceGuard.text = data.OperateTime.ToString();
StateEntranceGuard.text = data.nInOutState.ToString();
DevID = data.Id;
DepID = (int)data.AreadId;
}
public List <EntranceGuardActionInfo> GetEntranceActionInfoByPerson24Hours(int id)
{
DateTime dtNow = DateTime.Now;
DateTime dtOld = DateTime.Now.AddHours(-24);
long lNow = TimeConvert.DateTimeToTimeStamp(dtNow);
long lOld = TimeConvert.DateTimeToTimeStamp(dtOld);
List <EntranceGuardActionInfo> lst = new List <EntranceGuardActionInfo>();
List <int> lst2 = db.EntranceGuardCardToPersonnels.DbSet.Where(p => p.PersonnelId == id).Select(p => p.EntranceGuardCardId).ToList();
List <DbModel.LocationHistory.AreaAndDev.DevEntranceGuardCardAction> lst3 = null;
List <DbModel.Location.AreaAndDev.EntranceGuardCard> lst4 = db.EntranceGuardCards.ToList();
List <DbModel.Location.AreaAndDev.DevInfo> lst5 = db.DevInfos.ToList();
List <DbModel.Location.AreaAndDev.Area> lst6 = db.Areas.ToList();
if (lst2 == null)
{
return(lst);
}
var query = from t1 in db.DevEntranceGuardCardActions.DbSet
where lst2.Contains(t1.EntranceGuardCardId) && t1.OperateTimeStamp >= lOld && t1.OperateTimeStamp <= lNow
select t1;
if (query == null)
{
return(lst);
}
lst3 = query.ToList();
foreach (DbModel.LocationHistory.AreaAndDev.DevEntranceGuardCardAction item in lst3)
{
int DevInfoId = item.DevInfoId;
int EntranceGuardCardId = item.EntranceGuardCardId;
DateTime?OperateTime = item.OperateTime;
int nInOutState = item.nInOutState;
var card = lst4.Find(p => p.Id == EntranceGuardCardId);
if (card == null || card.Code == null || card.Code == "")
{
continue;
}
var devinfo = lst5.Find(p => p.Id == DevInfoId);
if (devinfo == null || devinfo.Name == null || devinfo.Name == "" || devinfo.ParentId == null)
{
continue;
}
string Name = devinfo.Name;
int AreaId = (int)devinfo.ParentId;
var area = lst6.Find(p => p.Id == AreaId);
if (area == null || area.Name == "" || area.Name == null)
{
continue;
}
EntranceGuardActionInfo ega = new EntranceGuardActionInfo();
ega.Id = DevInfoId;
ega.Name = Name;
ega.AreadId = AreaId;
ega.AreadName = area.Name;
ega.Code = card.Code;
ega.OperateTime = OperateTime;
ega.nInOutState = nInOutState;
lst.Add(ega);
}
return(lst);
}
