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