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