数据库
https://blog.csdn.net/qq_47795870/article/details/121377654
后端代码
public ActionResult Index()
{
return View();
}
//修改
public ActionResult EditRole(string info)
{
using (AAAEntities db = new AAAEntities())
{
var newModel = info.ToObject<Models.Student>();
var model = db.Student.Find(newModel.id);
model.Sex = newModel.Sex;
model.institute = newModel.institute;
model.phone = newModel.phone;
model.Addtime = newModel.Addtime;
model.Admissiontime = newModel.Admissiontime;
model.Called = newModel.Called;
model.Class = newModel.Class;
model.Name = newModel.Name;
model.IsDel = 1;
if (db.SaveChanges() > 0)
{
return Content("OK");
}
else
{
return Content("Error");
}
}
}
//添加修改共同的用id判断
public ActionResult Addorupdate(string id)
{
using (AAAEntities db = new AAAEntities())
{
var model = new Models.Student();
if (!String.IsNullOrWhiteSpace(id))
{
model = db.Student.Find(id);
}
return View(model);
}
}
//添加
public ActionResult AddRole(string info)
{
var model = info.ToObject<Models.Student>();
using (AAAEntities db = new AAAEntities())
{
model.id = Common.StringHelper.GetPrimaryKey();
model.IsDel = 1;
db.Student.Add(model);
if (db.SaveChanges() > 0)
{
return Content("OK");
}
else
{
return Content("Error");
}
}
}
//删除
public ActionResult Del(string id)
{
using (AAAEntities db = new AAAEntities())
{
string[] lst = id.Split(',');
foreach (var item in lst)
{
var model = db.Student.Find(item);
model.IsDel = 0;
}
if (db.SaveChanges() > 0)
{
return Content("OK");
}
else
{
return Content("Error");
}
}
}
//查询
public ActionResult students(int page, int limit)
{
using (AAAEntities db = new AAAEntities())
{
var query = (from a in db.Student
select new ViewModel.TTbate
{
id = a.id,
Name = a.Name,
institute = a.institute,
Sex = a.Sex,
Class = a.Class,
Called = a.Called,
phone = a.phone,
Addtime = (DateTime)a.Addtime,
Admissiontime = (DateTime)a.Admissiontime,
IsDel = a.IsDel.Value
});
query = query.Where(u => u.IsDel == 1);
if (!String.IsNullOrWhiteSpace(Request["name"]))
{
string name = Request["name"].ToString();
query = query.Where(u => u.Name.Contains(name));
}
if (!String.IsNullOrWhiteSpace(Request["institute"]))
{