using
System;
using
System.Collections
.Generic;
using
System.Data.Entity;
using
System.IO;
using
System.Linq;
using
System.Text
.RegularExpressions;
using
System.Threading
.Tasks;
using
System.Web;
using
System.Web
.Mvc;
using WebApplication1
.Models;
using WebApplication1
.Scripts;
using Newtonsoft
.Json;
using WebApplication1
.Controllers;
namespace GameManage
.Controllers
{
[LoginActionFitter(IsCheck = true)]
public class JobManagemController : Controller
{
AoutEntities1 db = new AoutEntities1();
WebApplication1
.Models
.ReturnListJson
Data json
Data = new WebApplication1
.Models
.ReturnListJson
Data();
// GET: JobManagem
#region 职位信息管理界面
public ActionResult Index()
{
return View();
}
#endregion
#region 模糊查询
/// <summary>
/// 模糊查询
/// </summary>
/// <param name="page"></param>
/// <param name="limit"></param>
/// <param name="name"></param>
/// <param name="code"></param>
/// <returns></returns>
public ActionResult GetList(int page, int limit, string name, string code)
{
var list = db
.Job
.Where(a => a
.IsDel == false)
.ToList();
//
if (!string
.IsNullOrEmpty(name))
{
list = list
.Where(a => a
.JobName
.Contains(name))
.ToList();
}
if (!string
.IsNullOrEmpty(code))
{
list = list
.Where(a => a
.JobCode
.Contains(code))
.ToList();
}
var offset = (page - 1) * limit;
var
data = list
.OrderByDescending(a => a
.ModifyDate)
.Skip(offset)
.Take(limit);
json
Data.code = 0;
json
Data.count = list
.Count;
json
Data.data =
data;
return Json(json
Data, JsonRequestBehavior
.AllowGet);
}
#endregion
#region 删除
/// <summary>
/// 删除数据
/// </summary>
/// <returns></returns>
public ActionResult DelInfo(Guid? id)
{
if (id == Guid
.Empty)
{
json
Data.code = 1;
json
Data.msg = "删除失败,未找到当行数据";
}
else
{
//逻辑删除
var entity = db
.Job
.Find(id);
entity
.IsDel = true;
db
.Entry<Job>(entity)
.State =
System.Data.Entity
.EntityState.Modified;
//真实删除
//var entity1 = db
.Job
.Find(id);
//db
.Job
.Remove(entity1);
var result = db
.SaveChanges();
if (result > 0)
{
json
Data.code = 0;
json
Data.msg = "删除成功";
}
else
{
json
Data.code = 1;
json
Data.msg = "删除失败,请联系管理员";
}
}
return Json(json
Data, JsonRequestBehavior
.AllowGet);
}
#endregion
#region 新增和修改方法
/// <summary>
/// 新增职位信息，和修改
/// </summary>
/// <param name="job"></param>
/// <returns></returns>
public ActionResult Add(Job job)
{
if (job
.ID == Guid
.Empty)
{
job
.ID = Guid
.NewGuid();
job
.CreateDate = DateTime
.Now;
job
.ModifyDate = DateTime
.Now;
job
.IsDel = false;
//插入数据
db
.Job
.Add(job);
}
else
{
Job entity = db
.Job
.Find(job
.ID);
if (entity != null)
{
entity
.JobCode = job
.JobCode;
entity
.JobName = job
.JobName;
entity
.ModifyDate = DateTime
.Now;
entity
.IsDel = false;
//给数据库修改的指令
db
.Entry<Job>(entity)
.State =
EntityState.Modified;
}
}
var result1 = db
.SaveChanges();
//判断是否成功
if (result1 > 0)
{
json
Data.code = 0;
json
Data.msg = "保存成功";
}
else
{
json
Data.code = 1;
json
Data.msg = "保存失败";
}
return Json(json
Data, JsonRequestBehavior
.AllowGet);
}
#endregion
}
}
这个是职位管理的代码请仿写它给我实现编辑和添加功能
探讨使用EF与MVC三层架构进行Web开发时遇到的问题，包括EF版本与Model层版本匹配、System.Data.EntityState使用及版本差异解决方案。
扫一扫
2084
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
