新增和删除的部分代码总结

开发工具与关键技术： 新增和删除的部分代码总结（3）
作者：冉启东  年级：1804
撰写时间：2019年4月19日
本技术文献起止时间 2019年 4月19日～ 2019年4月28日
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
新增的部分代码总结
public ActionResult SelectAcamede(LayuiTablePage layuiTablePage)
{
linq 
var listAcamede = myModel.PW_Employee.ToList();
int totals = listAcamede.Count();
listAcamede = listAcamede.Skip(layuiTablePage.GetStartIndex())
Take(layuiTablePage.limit).ToList();
listAcamede = listAcamede.OrderByDescending(m => m.employeeID)
.Skip(layuiTablePage.GetStartIndex())
.Take(layuiTablePage.limit).ToList();
LayuiTableData<PW_Employee> layuiTable = new LayuiTableData<PW_Employee>();
layuiTable.data = listAcamede;
layuiTable.count = totals;
return Json(layuiTable, JsonRequestBehavior.AllowGet);
}
public ActionResult InsertAcamede(string employeeNum, string employeeName, string telphone, string address)
{
ReturnJson msg = new ReturnJson();
if (!string.IsNullOrEmpty(employeeNum) && !string.IsNullOrEmpty(employeeName)&&
!string.IsNullOrEmpty(telphone) && !string.IsNullOrEmpty(address))
{
PW_Employee modAcademe = new PW_Employee(); //
modAcademe.employeeNum = employeeNum;
modAcademe.employeeName = employeeName;
modAcademe.telphone = telphone;
modAcademe.address = address;
myModel.PW_Employee.Add(modAcademe);
myModel.SaveChanges();
msg.State = true;
msg.Text = "新增成功";
}
else
{
msg.State = false;
msg.Text = "数据不能为空";
}
return Json(msg, JsonRequestBehavior.AllowGet); 
}
点击新增 ![在这里插入图片描述](https://img-blog.csdnimg.cn/20190419204221247.png)，弹出新增界面![在这里插入图片描述](https://img-blog.csdnimg.cn/20190419204233466.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU0MDY3Mg==,size_16,color_FFFFFF,t_70) 。
输入新增信息![在这里插入图片描述](https://img-blog.csdnimg.cn/20190419204251118.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDU0MDY3Mg==,size_16,color_FFFFFF,t_70) 然后点击保存按钮，新增完成。
删除部分代码总结
public ActionResult DeleteAcamede(int employeeID)
{
ReturnJson msg = new ReturnJson();
msg.State = false;
try
{goes to 
var listEmployee = myModel.PW_Employee.
Where(m => m.employeeID == employeeID).ToList();
if (listEmployee.Count > 0)
{
myModel.PW_Employee.Remove(listEmployee[0]);
if (myModel.SaveChanges() > 0)
{
msg.State = true;
msg.Text = "删除成功！";
}
}
else
{
msg.Text = "该学院不存在";
}
}
catch (Exception)
{
msg.Text = "删除的代码出现了bug,赶紧查看";
}
return Json(msg, JsonRequestBehavior.AllowGet);
}