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;
}
}
}
}
