public void Update(AscmForklift ascmForklift) { try { using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession().BeginTransaction()) { try { YnDaoHelper.GetInstance().nHibernateHelper.Update <AscmForklift>(ascmForklift); tx.Commit();//正确执行提交 } catch (Exception ex) { tx.Rollback();//回滚 YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmForklift)", ex); throw ex; } } } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("修改失败(Update AscmForklift)", ex); throw ex; } }
public void Delete(AscmForklift ascmForklift) { try { YnDaoHelper.GetInstance().nHibernateHelper.Delete <AscmForklift>(ascmForklift); } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("删除失败(Delete AscmForklift)", ex); throw ex; } }
public void Delete(int id) { try { AscmForklift ascmForklift = Get(id); Delete(ascmForklift); } catch (Exception ex) { throw ex; } }
public AscmForklift Get(int id) { AscmForklift ascmForklift = null; try { ascmForklift = YnDaoHelper.GetInstance().nHibernateHelper.Get <AscmForklift>(id); } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("查询失败(Get AscmForklift)", ex); throw ex; } return(ascmForklift); }
public void AddForkliftContainerLog(string forkliftRfid, AscmReadingHead ascmReadingHead, AscmForklift ascmForklift, List <string> listRfid, string sessionKey) { try { if (listRfid.Count > 0) { DateTime dtServer = DateTime.Now; int times = 0; //该叉车最后一次读取 YnBaseDal.YnPage ynPage = new YnBaseDal.YnPage(); ynPage.SetPageSize(1); string sql = "from AscmForkliftContainerLog where passDate='" + dtServer.ToString("yyyy-MM-dd") + "' and forkliftId=" + ascmForklift.id + ""; IList <AscmForkliftContainerLog> ilist = YnDaoHelper.GetInstance().nHibernateHelper.Find <AscmForkliftContainerLog>(sql + " order by times desc", sql, ynPage, sessionKey); if (ilist != null && ilist.Count > 0) { AscmForkliftContainerLog ascmForkliftContainerLog = ilist[0]; DateTime dtCreateTime = Convert.ToDateTime(ascmForkliftContainerLog.createTime); TimeSpan ts = dtServer.Subtract(dtCreateTime); if (ascmForkliftContainerLog.readingHeadId == ascmReadingHead.id) { if (ts.TotalMinutes < 10)//10分钟同一叉车不重复计入 { return; } times = ascmForkliftContainerLog.times; } } //开始加入 times++; string maxIdKey = YnFrame.Services.YnBillKeyService.GetInstance().GetBillKey("AscmForkliftContainerLog", "", "", 10, listRfid.Count, sessionKey); long maxId = Convert.ToInt64(maxIdKey); List <AscmForkliftContainerLog> listAscmForkliftContainerLog = new List <AscmForkliftContainerLog>(); foreach (string rfid in listRfid) { AscmForkliftContainerLog ascmForkliftContainerLog = new AscmForkliftContainerLog(); ascmForkliftContainerLog.id = ++maxId; ascmForkliftContainerLog.forkliftId = ascmForklift.id; ascmForkliftContainerLog.forkliftIdRfidId = forkliftRfid; ascmForkliftContainerLog.containerRfidId = rfid; ascmForkliftContainerLog.createTime = dtServer.ToString("yyyy-MM-dd HH:mm"); ascmForkliftContainerLog.passDate = dtServer.ToString("yyyy-MM-dd"); ascmForkliftContainerLog.times = times; ascmForkliftContainerLog.readingHeadId = ascmReadingHead.id; ascmForkliftContainerLog.readingHeadIp = ascmReadingHead.ip; ascmForkliftContainerLog.status = ""; listAscmForkliftContainerLog.Add(ascmForkliftContainerLog); } using (ITransaction tx = YnDaoHelper.GetInstance().nHibernateHelper.GetCurrentSession(sessionKey).BeginTransaction()) { try { if (listAscmForkliftContainerLog.Count > 0) { YnDaoHelper.GetInstance().nHibernateHelper.SaveList(listAscmForkliftContainerLog, sessionKey); } tx.Commit();//正确执行提交 } catch (Exception ex) { tx.Rollback();//回滚 throw ex; } } //建立领料员单次领料与领料单的关联 AscmWmsMtlRequisitionMainService.GetInstance().WmsStoreIssueCheck(forkliftRfid, times, dtServer.ToString("yyyy-MM-dd HH:mm"), sessionKey); } } catch (Exception ex) { YnBaseClass2.Helper.LogHelper.GetLog().Error("记录日志失败(Find AscmForkliftContainerLog)", ex); throw ex; } }