public void SetWipEntities(List <AscmWipRequirementOperations> list) { if (list != null && list.Count > 0) { var wipEntityIds = list.Select(P => P.wipEntityId).Distinct(); var count = wipEntityIds.Count(); string ids = string.Empty; for (int i = 0; i < count; i++) { if (!string.IsNullOrEmpty(ids)) { ids += ","; } ids += wipEntityIds.ElementAt(i); if ((i + 1) % 500 == 0 || (i + 1) == count) { if (!string.IsNullOrEmpty(ids)) { string sql = "from AscmWipEntities where wipEntityId in (" + ids + ")"; IList <AscmWipEntities> ilistAscmWipEntities = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWipEntities>(sql); sql = "from AscmWipDiscreteJobs where wipEntityId in (" + ids + ")"; IList <AscmWipDiscreteJobs> ilistAscmWipDiscreteJobs = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWipDiscreteJobs>(sql); List <AscmWipEntities> listAscmWipEntities = null; List <AscmWipDiscreteJobs> listAscmWipDiscreteJobs = null; if (ilistAscmWipEntities != null && ilistAscmWipEntities.Count > 0) { listAscmWipEntities = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmWipEntities>(ilistAscmWipEntities); } if (ilistAscmWipDiscreteJobs != null && ilistAscmWipDiscreteJobs.Count > 0) { listAscmWipDiscreteJobs = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmWipDiscreteJobs>(ilistAscmWipDiscreteJobs); AscmWipDiscreteJobsService.GetInstance().SetLookupValues(listAscmWipDiscreteJobs); AscmWipDiscreteJobsService.GetInstance().SetScheduleGroups(listAscmWipDiscreteJobs); AscmWipDiscreteJobsService.GetInstance().SetMaterialItem(listAscmWipDiscreteJobs); } foreach (AscmWipRequirementOperations wipRequirementOperations in list) { if (listAscmWipEntities != null) { AscmWipEntities ascmWipEntities = listAscmWipEntities.Find(e => e.wipEntityId == wipRequirementOperations.wipEntityId); if (ascmWipEntities != null) { wipRequirementOperations.ascmWipEntities = ascmWipEntities; } } if (listAscmWipDiscreteJobs != null) { AscmWipDiscreteJobs ascmWipDiscreteJobs = listAscmWipDiscreteJobs.Find(e => e.wipEntityId == wipRequirementOperations.wipEntityId); if (ascmWipDiscreteJobs != null) { wipRequirementOperations.ascmWipDiscreteJobs = ascmWipDiscreteJobs; } } } } ids = string.Empty; } } } }
public AscmWipEntities Get(int id) { AscmWipEntities ascmDeliveryNotify = null; try { ascmDeliveryNotify = YnDaoHelper.GetInstance().nHibernateHelper.Get <AscmWipEntities>(id); } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmWipEntities)", ex); throw ex; } return(ascmDeliveryNotify); }
public void SetWipEntities(List <AscmWmsPreparationDetail> list) { if (list == null || list.Count == 0) { return; } var wipEntityIds = list.Select(P => P.wipEntityId).Distinct(); var count = wipEntityIds.Count(); string ids = string.Empty; for (int i = 0; i < count; i++) { if (!string.IsNullOrEmpty(ids)) { ids += ","; } ids += wipEntityIds.ElementAt(i); if ((i + 1) % 500 == 0 || (i + 1) == count) { if (!string.IsNullOrEmpty(ids)) { string sql = "from AscmWipEntities where wipEntityId in (" + ids + ")"; IList <AscmWipEntities> ilistAscmWipEntities = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWipEntities>(sql); if (ilistAscmWipEntities != null && ilistAscmWipEntities.Count > 0) { List <AscmWipEntities> listAscmWipEntities = ilistAscmWipEntities.ToList(); foreach (AscmWmsPreparationDetail ascmWmsPreparationDetail in list) { AscmWipEntities ascmWipEntities = listAscmWipEntities.Find(P => P.wipEntityId == ascmWmsPreparationDetail.wipEntityId); if (ascmWipEntities != null) { ascmWmsPreparationDetail.wipEntityName = ascmWipEntities.name; } } } } ids = string.Empty; } } }
public void SetWipEntities(List <AscmWmsContainerDelivery> list) { if (list != null && list.Count > 0) { var wipEntityIds = list.Select(P => P.wipEntityId).Distinct(); var count = wipEntityIds.Count(); string ids = string.Empty; for (int i = 0; i < count; i++) { if (!string.IsNullOrEmpty(ids)) { ids += ","; } ids += wipEntityIds.ElementAt(i); if ((i + 1) % 500 == 0 || (i + 1) == count) { if (!string.IsNullOrEmpty(ids)) { string sql = "from AscmWipEntities where wipEntityId in (" + ids + ")"; IList <AscmWipEntities> ilistWipEntities = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWipEntities>(sql); if (ilistWipEntities != null && ilistWipEntities.Count > 0) { List <AscmWipEntities> listWipEntities = ilistWipEntities.ToList(); foreach (AscmWmsContainerDelivery containerDelivery in list) { AscmWipEntities wipEntities = listWipEntities.Find(P => P.wipEntityId == containerDelivery.wipEntityId); if (wipEntities != null) { containerDelivery.wipEntityName = wipEntities.name; } } } } ids = string.Empty; } } } }