国产探花免费观看_亚洲丰满少妇自慰呻吟_97日韩有码在线_资源在线日韩欧美_一区二区精品毛片,辰东完美世界有声小说,欢乐颂第一季,yy玄幻小说排行榜完本

首頁 > 編程 > C# > 正文

c#中Linq to Sql 增刪除的實例

2020-01-24 03:16:38
字體:
來源:轉載
供稿:網友

抽像類:  

復制代碼 代碼如下:

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

復制代碼 代碼如下:

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

        }
    }
}

復制代碼 代碼如下:

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

發表評論 共有條評論
用戶名: 密碼:
驗證碼: 匿名發表
主站蜘蛛池模板: 延川县| 池州市| 卢龙县| 铅山县| 当涂县| 石林| 吴桥县| 古蔺县| 合作市| 清苑县| 介休市| 拉萨市| 铜梁县| 建宁县| 乾安县| 雅江县| 铁岭县| 班戈县| 江华| 瑞昌市| 蒙自县| 九台市| 依兰县| 兴安县| 乐山市| 千阳县| 晋州市| 大名县| 洞口县| 晋江市| 庆阳市| 鲁甸县| 蒙阴县| 东乌珠穆沁旗| 巴林右旗| 普格县| 三台县| 孝昌县| 广宁县| 临桂县| 宣城市|