基本操作增删改查

来源：互联网发布：智能app软件下载编辑：程序博客网时间：2024/04/29 06:45
class TestUserManager    {        //得到所有的数据        public IList<TestUser> GetAllUser()        {            using ( var session = NHibemateHelper.OpenSession())            {                using(var transaction = session.BeginTransaction())                {                    var userList = session.QueryOver<TestUser>();                    transaction.Commit(); //提交                    return userList.List();                }            }        }        //通过userName 得到一条数据        public IList<TestUser> GetUserByUsername(string username)        {            using (var session = NHibemateHelper.OpenSession())            {                using (var transaction = session.BeginTransaction())                {                    var userList = session.QueryOver<TestUser>().Where(user=>user.Username == username);                    transaction.Commit(); //提交                    return userList.List();                }            }        }        //储存一条新的数据        public void SaveUser(TestUser user)        {            using (var session = NHibemateHelper.OpenSession())            {                using (var transaction = session.BeginTransaction())                {                    session.Save(user);                    transaction.Commit(); //提交                }            }        }        //根据id删除一条数据        public void DeleteById(int id)        {            using (var session = NHibemateHelper.OpenSession())            {                using (var transaction = session.BeginTransaction())                {                    TestUser user = new TestUser();                    user.Id = id;                    session.Delete(user);                    transaction.Commit(); //提交                }            }        }        //修改        public void UpdateUser(TestUser tu)        {            using (var session = NHibemateHelper.OpenSession())            {                using (var transaction = session.BeginTransaction())                {                    session.Update(tu);                    transaction.Commit(); //提交                }            }        }
0 0