public AscmWipRequirementOperations Get(int id)
{
AscmWipRequirementOperations wipRequirementOperations = null;
try
{
wipRequirementOperations = YnDaoHelper.GetInstance().nHibernateHelper.Get <AscmWipRequirementOperations>(id);
}
catch (Exception ex)
{
YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmWipRequirementOperations)", ex);
throw ex;
}
return(wipRequirementOperations);
}
public void Update(AscmWipRequirementOperations ascmDeliveryNotify)
{
using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction())
{
try
{
YnDaoHelper.GetInstance().nHibernateHelper.Update <AscmWipRequirementOperations>(ascmDeliveryNotify);
tx.Commit();//正确执行提交
}
catch (Exception ex)
{
tx.Rollback();//回滚
YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmWipRequirementOperations)", ex);
throw ex;
}
}
}
public void SetBomPrepareQuantity(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))
{
List <AscmWmsPreparationDetail> _list = list.FindAll(P => ids.Split(',').Contains(P.wipEntityId.ToString()));
string materialIds = string.Join(",", _list.Select(P => P.materialId).Distinct());
string hql = "from AscmWipRequirementOperations where wipEntityId in(" + ids + ") and inventoryItemId in(" + materialIds + ")";
IList <AscmWipRequirementOperations> ilistWipRequirementOperations = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWipRequirementOperations>(hql);
if (ilistWipRequirementOperations != null && ilistWipRequirementOperations.Count > 0)
{
List <AscmWipRequirementOperations> listWipRequirementOperations = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmWipRequirementOperations>(ilistWipRequirementOperations);
foreach (AscmWmsPreparationDetail preparationDetail in list)
{
AscmWipRequirementOperations wipRequirementOperations = listWipRequirementOperations.Find(P => P.wipEntityId == preparationDetail.wipEntityId && P.inventoryItemId == preparationDetail.materialId);
if (wipRequirementOperations != null)
{
preparationDetail.containerBindNumber = wipRequirementOperations.ascmPreparedQuantity;
}
}
}
}
ids = string.Empty;
}
}
}
