public void Update(AscmWarelocation ascmWarelocation) { try { using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction()) { try { YnDaoHelper.GetInstance().nHibernateHelper.Update <AscmWarelocation>(ascmWarelocation); tx.Commit();//正确执行提交 } catch (Exception ex) { tx.Rollback();//回滚 YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmWarelocation)", ex); throw ex; } } } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Save AscmWarelocation)", ex); throw ex; } }
public void Delete(AscmWarelocation ascmWarelocation) { try { YnDaoHelper.GetInstance().nHibernateHelper.Delete <AscmWarelocation>(ascmWarelocation); } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("删除失败(Delete AscmWarelocation)", ex); throw ex; } }
public void Delete(int id) { try { AscmWarelocation ascmWarelocation = Get(id); Delete(ascmWarelocation); } catch (Exception ex) { throw ex; } }
public AscmWarelocation Get(int id) { AscmWarelocation ascmWarelocation = null; try { ascmWarelocation = YnDaoHelper.GetInstance().nHibernateHelper.Get <AscmWarelocation>(id); } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmWarelocation)", ex); throw ex; } return(ascmWarelocation); }
public void SetWarelocationDocNumber(List <AscmWmsPreparationDetail> list) { if (list == null || list.Count == 0) { return; } var warelocationIds = list.Select(P => P.warelocationId).Distinct(); var count = warelocationIds.Count(); string ids = string.Empty; for (int i = 0; i < count; i++) { if (!string.IsNullOrEmpty(ids)) { ids += ","; } ids += warelocationIds.ElementAt(i); if ((i + 1) % 500 == 0 || (i + 1) == count) { if (!string.IsNullOrEmpty(ids)) { string sql = "from AscmWarelocation where id in (" + ids + ")"; IList <AscmWarelocation> ilistAscmWarelocation = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWarelocation>(sql); if (ilistAscmWarelocation != null && ilistAscmWarelocation.Count > 0) { List <AscmWarelocation> listAscmWarelocation = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmWarelocation>(ilistAscmWarelocation); foreach (AscmWmsPreparationDetail ascmWmsPreparationDetail in list) { AscmWarelocation ascmWarelocation = listAscmWarelocation.Find(P => P.id == ascmWmsPreparationDetail.warelocationId); if (ascmWarelocation != null) { ascmWmsPreparationDetail.locationDocNumber = ascmWarelocation.docNumber; } } } } ids = string.Empty; } } }
public AscmWarelocation GetWarelocationByRfid(string rfid) { AscmWarelocation ascmWarelocation = null; try { if (!string.IsNullOrEmpty(rfid)) { IList <AscmWarelocation> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWarelocation>("from AscmWarelocation where rfid='" + rfid.Trim() + "'"); if (ilist != null && ilist.Count > 0) { ascmWarelocation = ilist.First(); ascmWarelocation.listAscmLocationMaterialLink = AscmLocationMaterialLinkService.GetInstance().GetList(ascmWarelocation.id, true); } } } catch (Exception ex) { throw ex; } return(ascmWarelocation); }
private void SetWarelocation(List <AscmLocationMaterialLink> list) { if (list != null && list.Count > 0) { var warelocationIds = list.Select(P => P.pk.warelocationId).Distinct(); var count = warelocationIds.Count(); string ids = string.Empty; for (int i = 0; i < count; i++) { if (!string.IsNullOrEmpty(ids)) { ids += ","; } ids += warelocationIds.ElementAt(i); if ((i + 1) % 500 == 0 || (i + 1) == count) { if (!string.IsNullOrEmpty(ids)) { string sql = "from AscmWarelocation where id in (" + ids + ")"; IList <AscmWarelocation> ilistWarelocation = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmWarelocation>(sql); if (ilistWarelocation != null && ilistWarelocation.Count > 0) { List <AscmWarelocation> listWarelocation = YnBaseClass2.Helper.ConvertHelper.ConvertIListToList <AscmWarelocation>(ilistWarelocation); foreach (AscmLocationMaterialLink locationMaterialLink in list) { AscmWarelocation warelocation = listWarelocation.Find(P => P.id == locationMaterialLink.pk.warelocationId); if (warelocation != null) { locationMaterialLink.locationDocNumber = warelocation.docNumber; locationMaterialLink.warehouseId = warelocation.warehouseId; } } } } ids = string.Empty; } } } }