public ActionResult DeleteMemberAge(int MemberAgeId) //删除年龄信息 { string strMsg = "fail"; //定义返回 //查询数据 Models.S_MembershipAgeList dbMemberAge = (from tbMemberAge in MyModels.S_MembershipAgeList where tbMemberAge.MemberID == MemberAgeId select tbMemberAge).Single(); MyModels.S_MembershipAgeList.Remove(dbMemberAge);//删除 if (MyModels.SaveChanges() > 0) { strMsg = "success"; } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }
public ActionResult InsertAGe(string MemberName, string OriginationAge, string EndAge)//新增年龄信息 { string strAge = "falied"; try { //实例化对象 Models.S_MembershipAgeList myAge = new Models.S_MembershipAgeList(); //给表对象属性赋值 myAge.MemberName = MemberName.Trim(); myAge.OriginationAge = OriginationAge.Trim(); myAge.EndAge = EndAge.Trim(); //把表对象实体模型中 MyModels.S_MembershipAgeList.Add(myAge); //将对象实体插入到数据库中 MyModels.SaveChanges(); strAge = "ok"; } catch (Exception e) { Console.WriteLine(e); } return(Json(strAge, JsonRequestBehavior.AllowGet)); }