public frmMain() { hibernateTemplate = ContextRegistry.GetContext().GetObject("HibernateTemplate") as HibernateTemplate; InitializeComponent(); InitData(); BindEvent(); InitRigthMenu(); }
public object DoInTransaction(ITransactionStatus status) { Assert.IsTrue(TransactionSynchronizationManager.HasResource(sf), "Has thread session"); HibernateTemplate ht = new HibernateTemplate(sf); ht.TemplateFlushMode = TemplateFlushMode.Eager; ht.Execute(new HibernateDelegate(Del)); status.SetRollbackOnly(); return(null); }
public object DoInTransaction(ITransactionStatus status) { Assert.IsTrue(TransactionSynchronizationManager.HasResource(sfProxy), "Has thread session"); Assert.IsTrue(TransactionSynchronizationManager.HasResource(provider), "Hasn't thread db provider"); Assert.IsFalse(TransactionSynchronizationManager.CurrentTransactionReadOnly); Assert.IsTrue(TransactionSynchronizationManager.ActualTransactionActive); HibernateTemplate ht = new HibernateTemplate(sfProxy); return(ht.Find("some query string")); }
public void Update(IList obj) { if (obj != null) { foreach (Match item in obj) { HibernateTemplate.Update(item); } } }
public Province GetProvinceByProvinceCode(string code) { return(HibernateTemplate.Execute <Province>(x => { var c = x.CreateCriteria <Province>() .Add(Expression.Eq("ProvinceCode", code)); HibernateTemplate.PrepareCriteria(c); return c.List <Province>().FirstOrDefault(); })); }
public City GetCityByCityCode(string code) { return(HibernateTemplate.Execute <City>(x => { var c = x.CreateCriteria <City>() .Add(Expression.Eq("CityCode", code)); HibernateTemplate.PrepareCriteria(c); return c.List <City>().FirstOrDefault(); })); }
public IList <District> GetDistrictByCityCode(string code) { return(HibernateTemplate.ExecuteFind <District>(x => { var c = x.CreateCriteria <District>() .Add(Expression.Eq("CityCode", code)); HibernateTemplate.PrepareCriteria(c); return c.List <District>(); })); }
public District GetDistrictByName(string name) { return(HibernateTemplate.Execute <District>(x => { var c = x.CreateCriteria <District>() .Add(Restrictions.Like("DistrictName", "%" + name + "%")); HibernateTemplate.PrepareCriteria(c); return c.List <District>().FirstOrDefault(); })); }
public IList <Province> GetAllProvince() { return(HibernateTemplate.ExecuteFind <Province>(x => { var c = x.CreateCriteria <Province>() .AddOrder(Order.Asc("OrderSort")) .AddOrder(Order.Asc("PinYinNameAbbr")); HibernateTemplate.PrepareCriteria(c); return c.List <Province>(); })); }
/// <summary> /// Liefert die Anzahl aller Objekte. /// </summary> /// <returns>Anzahl der Objekte.</returns> public long GetCount() { HibernateDelegate <long> find = delegate(ISession session) { ICriteria criteria = session.CreateCriteria(typeof(T)); criteria.SetProjection(Projections.RowCountInt64()); return(criteria.UniqueResult <long>()); }; return(HibernateTemplate.Execute(find)); }
/// <summary> /// Liefert ein Entity anhand seines Primäschlüssels. /// </summary> /// <param name="primaryKey">Der Primärschlüssel.</param> /// <returns>Das Entity mit dem angegebenen Primärschlüssel.</returns> public virtual T GetByPrimaryKey(TKey primaryKey) { T loadedEntity = HibernateTemplate.Get <T>(primaryKey); if (loadedEntity == null) { throw new ObjectNotFoundException(primaryKey, typeof(T)); } return(loadedEntity); }
/// <summary> /// 数据访问实现:添加用户 /// </summary> /// <param name="entity">参数:实体对象(Consumer:用户)</param> /// <returns></returns> public bool InsertConsumer(Consumer entity) { if (HibernateTemplate.Save(entity) != null) { return(true); } return(false); throw new NotImplementedException(); }
public View Save(View view) { if (view.Id == Guid.Empty) { view.Id = Guid.NewGuid(); } view.FlushVisualTree(); HibernateTemplate.Save(view); return(view); }
private long CreateDomain(string domainName) { // if domain doesn't exist try to create a new one PKGenEntity entity = new PKGenEntity(); entity.DomainName = domainName; entity.Value = startingIdValue; HibernateTemplate.Save(entity); return(entity.Value); }
public void Delete(IList obj) { if (obj != null) { foreach (Case item in obj) { HibernateTemplate.Update(item); } } }
static NHibernateExtension() { var applicationContext = ContextRegistry.GetContext(); var setName = "hibernatetemplate"; if (applicationContext.ContainsObject(setName)) { _hibernateTemplate = applicationContext.GetObject(setName) as HibernateTemplate; } }
public IList <ActionInfo> GetActionByPath(string path) { return(HibernateTemplate.ExecuteFind <ActionInfo>(x => { var c = x.CreateCriteria <ActionInfo>() .Add(Expression.Eq("UrlPath", path)); HibernateTemplate.PrepareCriteria(c); return c.List <ActionInfo>(); })); }
public void ExceptionTranslator() { ISessionFactory sessionFactory = ctx["SessionFactory"] as ISessionFactory; HibernateTemplate template = new HibernateTemplate(sessionFactory); IAdoExceptionTranslator translator = template.AdoExceptionTranslator; Assert.IsNotNull(translator, "ADO.NET exception translator should not be null"); Assert.That(translator, Is.InstanceOf(typeof(ErrorCodeExceptionTranslator))); }
protected virtual T DoSaveEntity(T daoObj) { User u = AuthorizationService.GetCurrentUser(); if (!u.UserRoleID.HasValue) { throw new AccessDeniedException("User have no rights to save entity"); } UserRoleId role = (UserRoleId)(u.UserRoleID.Value); return((T)HibernateTemplate.SaveOrUpdateCopy(daoObj)); /* * if (!(daoObj is BaseEntity)) * { * return (T) HibernateTemplate.SaveOrUpdateCopy(daoObj); * } * * // now daoObj IS BaseEntity * BaseEntity entity = daoObj as BaseEntity; * if (entity.IsNew) * { * // shorj: pretty ugly right check but i can't contrive better implementation now * // without large amount of coding * entity = (BaseEntity) HibernateTemplate.SaveOrUpdateCopy(daoObj); * if (role != UserRoleId.GlobalAdmin) * { * IList list = * FindByNamedParam(new string[] {"entity.ID"}, null, "entity.ID = :id", null, new string[] {"id"}, * new object[] {entity.ID}, false); * if ((list == null) || (list.Count == 0)) * { * HibernateTemplate.Delete(string.Format("from {0} entity where entity.ID = ?", typeof (T).Name), * entity.ID, NHibernateUtil.Int64); * throw new AccessDeniedException("User have no rights to save entity"); * } * } * } * else * { * if (role != UserRoleId.GlobalAdmin) * { * IList list = * FindByNamedParam(new string[] {"entity.ID"}, null, "entity.ID = :id", null, new string[] {"id"}, * new object[] {entity.ID}, false); * if ((list == null) || (list.Count == 0)) * { * throw new AccessDeniedException("User have no rights to save entity"); * } * } * entity = (BaseEntity) HibernateTemplate.SaveOrUpdateCopy(daoObj); * } * * return (entity as T);*/ }
public IList <Property> FindByBusinessEntityId(Guid businessEntityId) { string[] paramNames = { "businessEntityId" }; object[] paramValues = { businessEntityId }; IList <Property> result = HibernateTemplate.FindByNamedQueryAndNamedParam <Property>( "Property.FindByBusinessEntityId", paramNames, paramValues); return(result); }
public IList <Property> FindByStorageInfoId(Guid storageInfoId) { string[] paramNames = { "storageInfoId" }; object[] paramValues = { storageInfoId }; IList <Property> result = HibernateTemplate.FindByNamedQueryAndNamedParam <Property>( "Property.FindByStorageInfoId", paramNames, paramValues); return(result); }
public object DoInTransaction(ITransactionStatus status) { Assert.IsTrue(!TransactionSynchronizationManager.HasResource(sf), "Hasn't thread session"); Assert.IsFalse(TransactionSynchronizationManager.CurrentTransactionReadOnly); Assert.IsFalse(TransactionSynchronizationManager.ActualTransactionActive); HibernateTemplate ht = new HibernateTemplate(sf); ht.TemplateFlushMode = TemplateFlushMode.Eager; return(ht.ExecuteFind(new NotSupportedTxCallbackInner())); }
public bool DeleteSupplierByIdList(string sidList) { var sql = string.Format("Delete from SupplierInfo Where SupplierId in ({0})", sidList); return(HibernateTemplate.Execute <bool>(x => { var q = x.CreateQuery(sql) .ExecuteUpdate(); return q > 0; })); }
public void TransactionWithPropagationSupportsAndInnerTransaction() { DbConnection connection = A.Fake <DbConnection>(); ISessionFactory sessionFactory = A.Fake <ISessionFactory>(); ISession session1 = A.Fake <ISession>(); ISession session2 = A.Fake <ISession>(); ITransaction transaction = A.Fake <ITransaction>(); A.CallTo(() => sessionFactory.OpenSession()).Returns(session1).Once() .Then.Returns(session2).Once(); A.CallTo(() => session1.Connection).Returns(connection); A.CallTo(() => session1.SessionFactory).Returns(sessionFactory); A.CallTo(() => session1.FlushMode).Returns(FlushMode.Auto); A.CallTo(() => session2.Connection).Returns(connection); A.CallTo(() => session2.BeginTransaction(IsolationLevel.ReadCommitted)).Returns(transaction); A.CallTo(() => session2.FlushMode).Returns(FlushMode.Auto); A.CallTo(() => session2.IsOpen).Returns(true); LocalSessionFactoryObjectStub lsfo = new LocalSessionFactoryObjectStub(sessionFactory); lsfo.AfterPropertiesSet(); ISessionFactory sfProxy = (ISessionFactory)lsfo.GetObject(); Assert.IsNotNull(sfProxy); HibernateTransactionManager tm = new HibernateTransactionManager(sessionFactory); tm.TransactionSynchronization = TransactionSynchronizationState.Always; TransactionTemplate tt = new TransactionTemplate(tm); tt.PropagationBehavior = TransactionPropagation.Supports; TransactionTemplate tt2 = new TransactionTemplate(tm); tt2.PropagationBehavior = TransactionPropagation.Required; HibernateTemplate ht = new HibernateTemplate(sessionFactory); ht.TemplateFlushMode = TemplateFlushMode.Eager; ht.ExposeNativeSession = true; Assert.IsTrue(!TransactionSynchronizationManager.HasResource(sessionFactory), "Hasn't thread session"); tt.Execute(new TransactionWithPropagationSupportsAndInnerTransactionTxCallback(tt2, sessionFactory, ht, session1, session2)); Assert.IsTrue(!TransactionSynchronizationManager.HasResource(sessionFactory), "Hasn't thread session"); A.CallTo(() => transaction.Commit()).MustHaveHappenedOnceExactly(); A.CallTo(() => session1.Flush()).MustHaveHappenedTwiceExactly(); A.CallTo(() => session2.Flush()).MustHaveHappenedOnceExactly(); A.CallTo(() => session2.Close()).MustHaveHappenedOnceExactly(); }
/// <summary> /// 数据访问实现:添加单个实体对象信息 /// </summary> /// <param name="entity">参数:Product 实体对象</param> /// <returns>返回:bool</returns> public bool InsertProducts(DemoProduct entity) { //HibernateTemplate.Save(entity); if (HibernateTemplate.Save(entity) != null) { return(true); } return(false); throw new NotImplementedException(); }
/// <summary> /// Ruft alle offenen Zahlungen für einen Nutzer ab. /// </summary> /// <param name="pageRequest"></param> /// <param name="currentUser"></param> /// <returns></returns> public IPage <Payment> FindPendingPaymentsByUser(IPageable pageRequest, User user) { HibernateDelegate <IPage <Payment> > finder = delegate(ISession session) { IQueryOver <Payment, Payment> queryOver = session.QueryOver <Payment>(); queryOver.Where(payment => payment.RequestRecipient == user || payment.RequestSender == user) .And(payment => payment.PaymentStatus == PaymentStatus.Pending); return(FindPage(queryOver, pageRequest)); }; return(HibernateTemplate.Execute(finder)); }
public void TearDown() { Ca.Infoway.Messagebuilder.CollUtils.Reverse(this.createdObjects); for (IIterator <Object> iterator = new ILOG.J2CsMapping.Collections.Generics.IteratorAdapter <System.Object>(this.createdObjects.GetEnumerator()); iterator .HasNext();) { Object createdObj = iterator.Next(); HibernateTemplate.Delete(createdObj); } ILOG.J2CsMapping.Collections.Generics.Collections.Clear(this.createdObjects); }
/// <summary> /// Sucht nach allen offenen Rechnungen /// </summary> /// <returns></returns> public IList <Bill> FindUnsettledBills() { FindHibernateDelegate <Bill> finder = delegate(ISession session) { ICriteria criteria = session.CreateCriteria(typeof(Bill)); criteria.Add(Restrictions.Eq("IsSettled", false)); return(criteria.List <Bill>()); }; return(HibernateTemplate.ExecuteFind(finder)); }
public List <EmployeeRelation> GetEmployeeRelationByCountryId(long countryid) { string hql = @"SELECt entity FROM EmployeeRelation entity, Employee empl, Store stores WHERE empl.id=entity.EmployeeID AND empl.MainStoreID=stores.id AND stores.CountryID={0} order by entity.EmployeeID asc, entity.BeginTime asc"; hql = String.Format(hql, countryid); return(GetTypedListFromIList(HibernateTemplate.FindByNamedParam(hql, new string[] { }, new object[] { }))); }
public IList <StoredProcedure> FindAllByPackageId(Guid packageId) { string[] paramNames = { "packageId" }; object[] paramValues = { packageId }; IList <StoredProcedure> storedProcedures = HibernateTemplate.FindByNamedQueryAndNamedParam <StoredProcedure>( "StoredProcedure.FindAllByPackageId", paramNames, paramValues); return(storedProcedures); }
public List <AvgWorkingDaysInWeek> GetAllAvgWorkingDaysInWeek() { IList lst = (IList)HibernateTemplate.Execute(delegate(ISession session) { ICriteria criteria = session.CreateCriteria(typeof(AvgWorkingDaysInWeek)); return(criteria.List()); } ); return(GetTypedListFromIList(lst)); }