/// <summary> /// 根据模具警报类型获得模具警报信息 /// </summary> /// <param name="type">模具警报类型</param> /// <returns>模具警报信息列表</returns> public List <MoldWarnInfo> GetMoldWarnInfo(MoldWarnType type) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IMoldRepository moldRepostitory = new MoldRepository(unitwork); List <MoldView> molds = moldRepostitory.GetByWarnType(type); List <MoldWarnInfo> moldWarnInfos = new List <MoldWarnInfo>(); foreach (MoldView m in molds) { MoldWarnInfo moldWarnInfo = new MoldWarnInfo() { MoldNR = m.MoldNR, Type = m.TypeName, ProjectName = m.ProjectName, MaxLendHour = (double)m.MaxLendHour, LendTime = (DateTime)m.LastRecordDate, CurrentPosition = m.StorageRecordNR.HasValue ? moldRepostitory.GetMoldCurrPosiByRecordNR((Guid)m.StorageRecordNR) : string.Empty }; moldWarnInfos.Add(moldWarnInfo); } return(moldWarnInfos); } }
/// <summary> /// 根据模具警报状态获得模具视图 /// </summary> /// <param name="type">模具警报状态</param> /// <returns>模具视图列表</returns> public List <MoldView> GetByWarnType(MoldWarnType type) { List <MoldView> molds = type == MoldWarnType.OutTime ? (context.MoldView.Where(m => (m.State == MoldStateType.NotReturned) && (m.LastRecordDate.Value.AddHours((double)m.MaxLendHour) < DateTime.Now)).ToList()) : (context.MoldView.Where(m => (m.State == MoldStateType.NotReturned) && (m.LastRecordDate.Value.AddHours((double)m.MaxLendHour) >= DateTime.Now)).ToList()); return(molds.Distinct().ToList()); }
/// <summary> /// 根据模具警报状态获得模具视图 /// </summary> /// <param name="type">模具警报状态</param> /// <returns>模具视图列表</returns> public List<MoldView> GetByWarnType(MoldWarnType type) { List<MoldView> molds = type == MoldWarnType.OutTime ? (context.MoldView.Where(m => (m.State == MoldStateType.NotReturned) && (m.LastRecordDate.Value.AddHours((double)m.MaxLendHour) < DateTime.Now)).ToList()) : (context.MoldView.Where(m => (m.State == MoldStateType.NotReturned) && (m.LastRecordDate.Value.AddHours((double)m.MaxLendHour) >= DateTime.Now)).ToList()); return molds.Distinct().ToList(); }
/// <summary> /// 根据模具警报类型获得模具警报信息 /// </summary> /// <param name="type">模具警报类型</param> /// <returns>模具警报信息列表</returns> public List<MoldWarnInfo> GetMoldWarnInfo(MoldWarnType type) { using (IUnitOfWork unitwork = MSSqlHelper.DataContext()) { IMoldRepository moldRepostitory = new MoldRepository(unitwork); List<MoldView> molds = moldRepostitory.GetByWarnType(type); List<MoldWarnInfo> moldWarnInfos = new List<MoldWarnInfo>(); foreach (MoldView m in molds) { MoldWarnInfo moldWarnInfo = new MoldWarnInfo() { MoldNR = m.MoldNR, Type = m.TypeName, ProjectName = m.ProjectName, MaxLendHour = (double)m.MaxLendHour, LendTime = (DateTime)m.LastRecordDate, CurrentPosition = m.StorageRecordNR.HasValue ? moldRepostitory.GetMoldCurrPosiByRecordNR((Guid)m.StorageRecordNR) : string.Empty }; moldWarnInfos.Add(moldWarnInfo); } return moldWarnInfos; } }