C# Entities.FailureAnalysisEntities类代码示例

 /// <summary>
 /// Finds the asynchronous.
 /// </summary>
 /// <param name="id">The identifier.</param>
 /// <returns></returns>
 public async Task<FARUploadDto> SingleAsync(int id)
 {
     FARUploadDto result = null;
     try
     {
         using (FailureAnalysisEntities context = new FailureAnalysisEntities())
         {
             result = await (from item in context.LOG_FARUpload
                             where item.Id == id
                             select new FARUploadDto()
                             {
                                 Id = item.Id,
                                 MasterId = item.MasterId,
                                 FAType = item.FAType,
                                 FileName = item.FileName,
                                 ReasonId = item.ReasonId,
                                 UploadedDate = item.UploadedDate,
                                 UploadedBy = item.UploadedBy
                             }).SingleAsync();
         }
     }
     catch (Exception ex)
     {
         _logService.Error(ex.Message, ex);
         result = null;
     }
     return result;
 }

 /// <summary>
 /// Finds the asynchronous.
 /// </summary>
 /// <param name="id">The identifier.</param>
 /// <returns></returns>
 public async Task<MSTServiceDto> SingleAsync(int id)
 {
     MSTServiceDto result = null;
     try
     {
         using (FailureAnalysisEntities context = new FailureAnalysisEntities())
         {
             result = await (from item in context.MST_Services
                             where item.IsDeleted == false && item.Id == id
                             select new MSTServiceDto()
                             {
                                 Id = item.Id,
                                 Name = item.Name,
                                 Description = item.Description,
                                 IsDeleted = item.IsDeleted,
                                 LastUpdatedBy = item.LastUpdatedBy,
                                 LastUpdate = item.LastUpdate,
                             }).SingleAsync();
         }
     }
     catch (Exception ex)
     {
         _logService.Error(ex.Message, ex);
         result = null;
     }
     return result;
 }

 /// <summary>
 /// Finds the specified identifier.
 /// </summary>
 /// <param name="id">The identifier.</param>
 /// <returns></returns>
 public FARAnalystReassignLogDto Single(int id)
 {
     FARAnalystReassignLogDto result = null;
     try
     {
         using (FailureAnalysisEntities context = new FailureAnalysisEntities())
         {
             result = (from item in context.LOG_FARAnalystReassign
                       where item.IsDeleted == false && item.Id == id
                       select new FARAnalystReassignLogDto()
                       {
                           Id = item.Id,
                           MasterId = item.MasterId,
                           AnalystFrom = item.AnalystFrom,
                           AnalystTo = item.AnalystTo,
                           UpdatedDate = item.UpdatedDate,
                           IsDeleted = item.IsDeleted,
                           LastUpdatedBy = item.LastUpdatedBy,
                           LastUpdate = item.LastUpdate,
                       }).Single();
         }
     }
     catch (Exception ex)
     {
         _logService.Error(ex.Message, ex);
         result = null;
     }
     return result;
 }

 /// <summary>
 /// Finds the specified identifier.
 /// </summary>
 /// <param name="id">The identifier.</param>
 /// <returns></returns>
 public FARMechanismDto Single(int id)
 {
     FARMechanismDto result = null;
     try
     {
         using (FailureAnalysisEntities context = new FailureAnalysisEntities())
         {
             result = (from item in context.FAR_Mechanism
                       where item.IsDeleted == false && item.Id == id
                       select new FARMechanismDto()
                       {
                           Id = item.Id,
                           Name = item.Name,
                           Description = item.Description,
                           IsDeleted = item.IsDeleted,
                           LastUpdatedBy = item.LastUpdatedBy,
                           LastUpdate = item.LastUpdate,
                       }).Single();
         }
     }
     catch (Exception ex)
     {
         _logService.Error(ex.Message, ex);
         result = null;
     }
     return result;
 }

 /// <summary>
 /// Finds the specified identifier.
 /// </summary>
 /// <param name="id">The identifier.</param>
 /// <returns></returns>
 public SitesDto Single(int id)
 {
     SitesDto result = null;
     try
     {
         using (FailureAnalysisEntities context = new FailureAnalysisEntities())
         {
             result = (from item in context.MST_Sites
                       where item.IsDeleted == false && item.Id == id
                       select new SitesDto()
                       {
                           Id = item.Id,
                           Name = item.Name,
                           Address1 = item.Address1,
                           Address2 = item.Address2,
                           Phone = item.Phone,
                           Description = item.Description,
                           IsDeleted = item.IsDeleted,
                           LastUpdatedBy = item.LastUpdatedBy,
                           LastUpdate = item.LastUpdate,
                       }).Single();
         }
     }
     catch (Exception ex)
     {
         _logService.Error(ex.Message, ex);
     }
     return result;
 }

 /// <summary>
 /// Finds the specified identifier.
 /// </summary>
 /// <param name="id">The identifier.</param>
 /// <returns></returns>
 public MSTProcessTypesDto Single(int id)
 {
     MSTProcessTypesDto result = null;
     try
     {
         using (FailureAnalysisEntities context = new FailureAnalysisEntities())
         {
             result = (from item in context.MST_ProcessTypes
                       where item.IsDeleted == false && item.Id == id
                       select new MSTProcessTypesDto()
                       {
                           Id = item.Id,
                           Name = item.Name,
                           Description = item.Description,
                           Duration = item.Duration,
                           SeqNumber = item.SeqNumber,
                           IsDeleted = item.IsDeleted,
                           LastUpdatedBy = item.LastUpdatedBy,
                           LastUpdate = item.LastUpdate,
                       }).Single();
         }
     }
     catch (Exception ex)
     {
         _logService.Error(ex.Message, ex);
         result = null;
     }
     return result;
 }

        /// <summary>
        /// Finds the asynchronous.
        /// </summary>
        /// <param name="id">The identifier.</param>
        /// <returns></returns>
        public async Task<FARPriorityLogDto> SingleAsync(int id)
        {
            FARPriorityLogDto result = null;
            try
            {
                using (FailureAnalysisEntities context = new FailureAnalysisEntities())
                {
                    result = await (from item in context.LOG_FARPriority
                                    where item.IsDeleted == false && item.Id == id
                                    select new FARPriorityLogDto()
                                    {
                                        Id = item.Id,
                                        MasterId = item.MasterId,
                                        PriorityIdNew = item.PriorityNew,
                                        PriorityIdOld = item.PriorityOld,
                                        PriorityNew = new MSTPriorityDto { Name = item.MST_Priority1.Name },
                                        PriorityOld = new MSTPriorityDto { Name = item.MST_Priority.Name },
                                        ReasonId = item.ReasonId,
                                        Reason = new DelayReasonDto { Description = item.MST_Reason.Description },
                                        IsDeleted = item.IsDeleted,
                                        LastUpdatedBy = item.LastUpdatedBy,
                                        LastUpdate = item.LastUpdate,


                                    }).SingleAsync();
                }
            }
            catch (Exception ex)
            {
                _logService.Error(ex.Message, ex);
                result = null;
            }
            return result;
        }

 /// <summary>
 /// Finds the asynchronous.
 /// </summary>
 /// <param name="id">The identifier.</param>
 /// <returns></returns>
 public async Task<MSTFarReportDto> SingleAsync(int id)
 {
     MSTFarReportDto result = null;
     try
     {
         using (FailureAnalysisEntities context = new FailureAnalysisEntities())
         {
             result = await (from item in context.MST_FARReport
                             where item.IsDeleted == false && item.Id == id
                             select new MSTFarReportDto()
                             {
                                 Id = item.Id,
                                 ReportTypeId = item.ReportTypeId,
                                 OriginId = item.OriginId,
                                 Required = item.Required,
                                 ReportType = new ReportTypesDto { Id = item.MST_ReportTypes.Id, Name = item.MST_ReportTypes.Name, Description = item.MST_ReportTypes.Description },
                                 Origin = new MSTOriginDto { Id = item.MST_Origin.Id, Name = item.MST_Origin.Name, Description = item.MST_Origin.Description },
                                 Description = item.Description,
                                 LastUpdatedBy = item.LastUpdatedBy,
                                 LastUpdate = item.LastUpdate,
                             }).SingleAsync();
         }
     }
     catch (Exception ex)
     {
         result = null;
         _logService.Error(ex.Message, ex);
     }
     return result;
 }

 /// <summary>
 /// Finds the asynchronous.
 /// </summary>
 /// <param name="id">The identifier.</param>
 /// <returns></returns>
 public async Task<MSTCustomerDto> SingleAsync(int id)
 {
     MSTCustomerDto result = null;
     try
     {
         using (FailureAnalysisEntities context = new FailureAnalysisEntities())
         {
             result = await (from item in context.MST_Customer
                             where item.IsDeleted == false && item.Id == id
                             select new MSTCustomerDto()
                             {
                                 Id = item.Id,
                                 CustomerName = item.CustomerName,
                                 EndCustomer = item.EndCustomer,
                                 Location = item.Location,
                                 Strategic = item.Strategic,
                                 IsDeleted = item.IsDeleted,
                                 LastUpdatedBy = item.LastUpdatedBy,
                                 LastUpdate = item.LastUpdate,
                             }).SingleAsync();
         }
     }
     catch (Exception ex)
     {
         _logService.Error(ex.Message, ex);
         result = null;
     }
     return result;
 }

 /// <summary>
 /// Finds the specified identifier.
 /// </summary>
 /// <param name="id">The identifier.</param>
 /// <returns></returns>
 public DelayReasonDto Single(int id)
 {
     DelayReasonDto result = null;
     try
     {
         using (FailureAnalysisEntities context = new FailureAnalysisEntities())
         {
             result = (from item in context.MST_ReasonINIReport
                       where item.IsDeleted == false && item.Id == id
                       select new DelayReasonDto()
                       {
                           Id = item.Id,
                           Description = item.Description,
                           LastUpdatedBy = item.LastUpdatedBy,
                           LastUpdate = item.LastUpdate,
                       }).Single();
         }
     }
     catch (Exception ex)
     {
         _logService.Error(ex.Message, ex);
         result = null;
     }
     return result;
 }

 /// <summary>
 /// Finds the specified identifier.
 /// </summary>
 /// <param name="id">The identifier.</param>
 /// <returns></returns>
 public LOGHistoryDto Single(int id)
 {
     LOGHistoryDto result = null;
     try
     {
         using (FailureAnalysisEntities context = new FailureAnalysisEntities())
         {
             result = (from item in context.LOG_FARHistory
                       where item.IsDeleted == false && item.Id == id
                       select new LOGHistoryDto()
                       {
                           Id = item.Id,
                           MasterId = item.MasterId,
                           StatusId = item.StatusId,
                           ReasonId = item.ReasonId,
                           LogDate = item.LogDate,
                           IsDeleted = item.IsDeleted,
                           LastUpdatedBy = item.LastUpdatedBy,
                           LastUpdate = item.LastUpdate,
                       }).Single();
         }
     }
     catch (Exception ex)
     {
         _logService.Error(ex.Message, ex);
         result = null;
     }
     return result;
 }

 /// <summary>
 /// Finds the asynchronous.
 /// </summary>
 /// <param name="id">The identifier.</param>
 /// <returns></returns>
 public async Task<FARInitialTargetLogDto> SingleAsync(int id)
 {
     FARInitialTargetLogDto result = null;
     try
     {
         using (FailureAnalysisEntities context = new FailureAnalysisEntities())
         {
             result = await (from item in context.LOG_FARInitialTarget
                             where item.IsDeleted == false && item.Id == id
                             select new FARInitialTargetLogDto()
                             {
                                 Id = item.Id,
                                 MasterId = item.MasterId,
                                 ReasonId = item.ReasonId,
                                 TargetDate = item.TargetDate,
                                 IsDeleted = item.IsDeleted,
                                 LastUpdatedBy = item.LastUpdatedBy,
                                 LastUpdate = item.LastUpdate,
                                 
                                
                             }).SingleAsync();
         }
     }
     catch (Exception ex)
     {
         _logService.Error(ex.Message, ex);
         result = null;
     }
     return result;
 }

 /// <summary>
 /// Finds the asynchronous.
 /// </summary>
 /// <param name="id">The identifier.</param>
 /// <returns></returns>
 public async Task<RecordLockDto> SingleAsync(int id)
 {
     RecordLockDto result = null;
     try
     {
         using (FailureAnalysisEntities context = new FailureAnalysisEntities())
         {
             result = await (from item in context.FAR_RecordLock
                             where item.IsDeleted == false && item.Id == id
                             select new RecordLockDto()
                             {
                                 Id = item.Id,
                                 ProcessHistoryId = item.ProcessHistoryId,
                                 LockBy = item.LockBy,
                                 LockDate = item.LockDate,
                                 MasterId = item.MasterId,
                                 ReleaseDate = item.ReleaseDate,
                                 LastUpdatedBy = item.LastUpdatedBy,
                                 LastUpdate = item.LastUpdate,
                             }).SingleAsync();
         }
     }
     catch (Exception ex)
     {
         result = null;
         _logService.Error(ex.Message, ex);
     }
     return result;
 }

 public async Task<FARCancelLogDto> SingleAsync(int id)
 {
     FARCancelLogDto result = null;
     try
     {
         using (FailureAnalysisEntities context = new FailureAnalysisEntities())
         {
             result = await (from item in context.LOG_FARCancel
                             where item.IsDeleted == false && item.Id == id
                             select new FARCancelLogDto()
                             {
                                 Id = item.Id,
                                 MasterId = item.MasterId,
                                 StatusId = item.StatusId,
                                 ReasonId = item.ReasonId,
                                 CancelledDate = item.CancelledDate,
                                 IsDeleted = item.IsDeleted,
                                 InsertedBy = item.InsertedBy,
                                 InsertedOn = item.InsertedOn,
                                 UpdatedBy = item.UpdatedBy,
                                 UpdatedOn = item.UpdatedOn,
                             }).SingleAsync();
         }
     }
     catch (Exception ex)
     {
         _logService.Error(ex.Message, ex);
         result = null;
     }
     return result;
 }

 /// <summary>
 /// Finds the specified identifier.
 /// </summary>
 /// <param name="id">The identifier.</param>
 /// <returns></returns>
 public FARDeviceDetailsDto Single(int id)
 {
     FARDeviceDetailsDto result = null;
     try
     {
         using (FailureAnalysisEntities context = new FailureAnalysisEntities())
         {
             result = (from item in context.FAR_DeviceDetails
                       where item.IsDeleted == false && item.Id == id
                       select new FARDeviceDetailsDto()
                       {
                           Id = item.Id,
                           MasterId = item.MasterId,
                           Master = new FARMasterDto()
                           {
                               Id = item.FAR_Master.Id,
                               Number = item.FAR_Master.Number,
                               Analyst = item.FAR_Master.Analyst,
                               Requestor = item.FAR_Master.Requestor,
                               RefNo = item.FAR_Master.RefNo,
                               StatusId = item.FAR_Master.StatusId,
                               Product = item.FAR_Master.Product,
                               Customer = item.FAR_Master.Customer,
                               FailureRate = item.FAR_Master.FailureRate,
                               RequestDate = item.FAR_Master.RequestDate,
                               FailureDesc = item.FAR_Master.FailureDesc,
                           },
                           WaferNo = item.WaferNo,
                           SerialNo = item.SerialNo,
                           LotNo = item.LotNo,
                           MfgPartNo = item.MfgPartNo,
                           TechnologyId = item.TechnologyId,
                           Technogoly = new MSTTechnogolyDto() { Id = item.MST_Technology.Id, Name = item.MST_Technology.Name, Description = item.MST_Technology.Description, },
                           PackageTypeId = item.PackageTypeId,
                           PackageType = new MSTPackageTypesDto() { Id = item.MST_PackageTypes.Id, Name = item.MST_PackageTypes.Name, Description = item.MST_PackageTypes.Description, },
                           AssemblySiteId = item.AssembliesSiteId,
                           AssemblySites = new MSTAssemblySiteDto() { Id = item.MST_AssemblySites.Id, Name = item.MST_AssemblySites.Code, Description = item.MST_AssemblySites.Description, },
                           FabSiteId = item.FabSiteId,
                           FabSite = new FabSiteDto() { Id = item.FabSites.Id, Name = item.FabSites.Name, Description = item.FabSites.Description, },
                           ServiceId = item.ServiceId,
                           FARServices = new MSTServiceDto() { Id = item.MST_Services.Id, Name = item.MST_Services.Name, Description = item.MST_Services.Description },
                           DateCode = item.DateCode,
                           Quantity = item.Quantity,
                           Stage = item.Stage,
                           IsDeleted = item.IsDeleted,
                           LastUpdatedBy = item.LastUpdatedBy,
                           LastUpdate = item.LastUpdate,
                       }).Single();
         }
     }
     catch (Exception ex)
     {
         _logService.Error(ex.Message, ex);
         result = null;
     }
     return result;
 }