public ICollection <User> GetAllUsers()
{
using (ISession session = MyNHibernateHelper.OpenSession()) //请求session
{
IList <User> users = session.CreateCriteria(typeof(User)).List <User>();
return(users);
}
}
public void Update(User user)
{
using (ISession session = MyNHibernateHelper.OpenSession()) //请求session
{
using (ITransaction transcation = session.BeginTransaction()) //建立事务
{
session.Update(user); //对数据库进行操作
transcation.Commit(); //提交事务
}
}
}
public User GetByUserName(string username)
{
using (ISession session = MyNHibernateHelper.OpenSession()) //请求session
{
//ICriteria criteria = session.CreateCriteria(typeof(User));
//criteria.Add(Restrictions.Eq("Username", username));
//User user = criteria.UniqueResult<User>();
User user = session.CreateCriteria(typeof(User)).Add(Restrictions.Eq("Username", username)).UniqueResult <User>();
return(user);
}
}
public User GetById(int id)
{
using (ISession session = MyNHibernateHelper.OpenSession()) //请求session
{
using (ITransaction transcation = session.BeginTransaction()) //建立事务
{
User user = session.Get <User>(id); //对数据库进行操作
transcation.Commit(); //提交事务
return(user);
}
}
}
public void Add(User user)
{
//ISession session = MyNHibernateHelper.OpenSession();
//session.Save(user);
//session.Close();
using (ISession session = MyNHibernateHelper.OpenSession()) //请求session
{
using (ITransaction transcation = session.BeginTransaction()) //建立事务
{
session.Save(user); //对数据库进行操作
transcation.Commit(); //提交事务
}
}
}
//验证登录
public bool VerifyUser(string username, string password)
{
using (ISession session = MyNHibernateHelper.OpenSession()) //请求session
{
User user = session.CreateCriteria(typeof(User))
.Add(Restrictions.Eq("Username", username))
.Add(Restrictions.Eq("Password", password))
.UniqueResult <User>();
if (user == null)
{
return(false);
}
else
{
return(true);
}
}
}
