//删除功能 public JsonResult DeleteEmp(List <int> IdList) { using (G3TextEntities db = new G3TextEntities()) { //包含集合 //先查询 var lst = db.T_Emp.Where(c => IdList.Contains(c.EmpId)).ToList(); foreach (var item in lst) { //移除 db.T_Emp.Remove(item); } int rs = db.SaveChanges(); if (rs > 0) { var obj = new { status = "success", msg = "删除成功..." }; return(Json(obj, JsonRequestBehavior.AllowGet)); } else { var obj = new { status = "error", msg = "删除失败..." }; return(Json(obj, JsonRequestBehavior.AllowGet)); } } }
//查询部门 public JsonResult GetDept() { using (G3TextEntities db = new G3TextEntities()) { var lst = db.T_Dept.Select(d => new { dept_id = d.DeptId, dept_name = d.DeptName }).ToList(); return(Json(lst, JsonRequestBehavior.AllowGet)); } }
//修改功能 public JsonResult GetEmp(int id) { using (G3TextEntities db = new G3TextEntities()) { var obj = db.T_Emp.Where(c => c.EmpId == id).ToList() .Select(c => new { emp_id = c.EmpId, emp_name = c.EmpName, emp_sex = c.EmpSex, emp_age = c.EmpAge, emp_birthday = c.EmpBirthday.ToString("yyyy-MM-dd"), dept_id = c.DeptId, }).FirstOrDefault(); return(Json(obj, JsonRequestBehavior.AllowGet)); } }
public JsonResult GetList(int page, int rows, string name, int?deptId) //可能为空值用? { using (G3TextEntities db = new G3TextEntities()) { //Request.QueryString //Request.Form //ASP.NET取值方式 //查询员工表 var lst = db.T_Emp.ToList() .Select(c => new { //返回匿名对象 emp_id = c.EmpId, emp_name = c.EmpName, emp_sex = c.EmpSex, emp_age = c.EmpAge, emp_birthday = c.EmpBirthday.ToString("yyyy-MM-dd"), dept_name = c.T_Dept.DeptName, dept_id = c.DeptId, }).ToList(); //判断搜索框字符串不为空----查询功能 if (!string.IsNullOrEmpty(name)) { lst = lst.Where(c => c.emp_name.Contains(name)).ToList(); } //判断下拉列表不为空,是否有值----查询功能 if (deptId.HasValue) { lst = lst.Where(c => c.dept_id == deptId).ToList(); } ; //创建匿名对象 var obj = new { //EF分页 total = lst.Count(), rows = lst.Skip((page - 1) * rows).Take(rows).ToList() }; //return Json(lst, JsonRequestBehavior.AllowGet); //采用分页 return(Json(obj, JsonRequestBehavior.AllowGet)); } }
public JsonResult CreateEmp(T_Emp emp) { using (G3TextEntities db = new G3TextEntities()) { db.T_Emp.Add(emp); int rs = db.SaveChanges(); if (rs > 0) { var obj = new { msg = "新增成功..." }; return(Json(obj)); } else { var obj = new { msg = "新增失败..." }; return(Json(obj)); } } }