- <pre name="code" class="csharp"> //EF查询
- public userinfo GetUser(string username)
- {
- using (MyShopDBEntities1 entity = new MyShopDBEntities1())
- {
- userinfo user = entity.userinfo.SingleOrDefault(model => model.username == username);
- return user;
- }
- }
- //修改
- public userinfo Update(string username,string userpwd)
- {
- using (MyShopDBEntities1 entity = new MyShopDBEntities1())
- {
- // userinfo user = entity.userinfo.SingleOrDefault(model => model.username == username);
- userinfo user = entity.userinfo.FirstOrDefault(model => model.username == username);
- if (user != null)
- { user.userpassword=userpwd;
- entity.SaveChanges();
- }
- return user;
- }
- }
- //添加
- public userinfo Add(userinfo user)
- {
- using (MyShopDBEntities1 entity = new MyShopDBEntities1())
- {
- entity.userinfo.Add(
- new userinfo()
- {
- username = user.username,
- userpwd = user.userpwd
- });
- if (entity.SaveChanges() > 0)
- {
- return user;
- }
- else
- return null;
- }
- }
- //删除
- public void Deleted(string username)
- {
- using (MyShopDBEntities1 entity = new MyShopDBEntities1())
- {
- userinfo user = entity.userinfo.FirstOrDefault(m => m.username == username);
- if (user != null)
- {
- entity.userinfo.Remove(user);
- }
- if (entity.SaveChanges() > 0)
- {
- //return 0;
- }
- }
- }