源码网商城,靠谱的源码在线交易网站 我的订单 购物车 帮助

源码网商城

c#中Linq to Sql 增删除的实例

  • 时间:2020-02-13 02:31 编辑: 来源: 阅读:
  • 扫一扫,手机访问
摘要:c#中Linq to Sql 增删除的实例
抽像类:  
[u]复制代码[/u] 代码如下:
 public abstract class AbUserAll     {         public abstract IQueryable<User_ALL> FindUserAll();         public abstract User_ALL FindUserAllById(int userid);         public abstract void Add(User_ALL user);         public abstract void Update(User_ALL user);         public abstract void Delete(User_ALL user);         public abstract void Save();     }
[u]复制代码[/u] 代码如下:
using System; using System.Collections.Generic; using System.Linq; using System.Web; namespace WF.Models.DAL {     public class UserDal:IDAL.AbUserAll     {         private PL_ModelDataContext db = new PL_ModelDataContext();         public override IQueryable<User_ALL> FindUserAll()         {             return db.User_ALL;         }         public override void Delete(User_ALL user)         {             db.User_ALL.DeleteOnSubmit(user);         }         public override void Save()         {             db.SubmitChanges();         }         public override User_ALL FindUserAllById(int userid)         {             return db.User_ALL.SingleOrDefault(o => o.INT == userid);         }         public override void Add(User_ALL user)         {             db.User_ALL.InsertOnSubmit(user);         }         public override void Update(User_ALL user)         {             var editStudent = db.User_ALL.SingleOrDefault<User_ALL>(s => s.INT == user.INT);             if (editStudent != null)             {                 editStudent.UserName = user.UserName;                 editStudent.Address = user.Address;             }             db.SubmitChanges();         }     } }
[u]复制代码[/u] 代码如下:
using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.Mvc; namespace WF.Controllers {     public class UserController : Controller     {         Models.DAL.UserDal dbuser = new Models.DAL.UserDal();         //         // GET: /User/         public ActionResult UserList()         {             return View(dbuser.FindUserAll());         }           //         // GET: /User/Create         public ActionResult Create()         {             return View();         }         //         // POST: /User/Create         [HttpPost]         public ActionResult Create(FormCollection collection,Models.User_ALL user)         {             try             {                 dbuser.Add(user);                 dbuser.Save();                 return RedirectToAction("UserList");             }             catch             {                 return View();             }         }         //         // GET: /User/Edit/5         public ActionResult UserEdit(int id)         {             return View(dbuser.FindUserAllById(id));         }         //         // POST: /User/Edit/5         [HttpPost]         public ActionResult UserEdit(Models.User_ALL user, FormCollection collection)         {             try             {                  dbuser.Update(user);                 dbuser.Save();                 return RedirectToAction("UserList");             }             catch             {                 return View();             }         }     } }
  • 全部评论(0)
联系客服
客服电话:
400-000-3129
微信版

扫一扫进微信版
返回顶部