/// <summary> /// 删除分类栏 /// </summary> /// <param name="onticeId"></param> /// <returns></returns> public ActionResult NoticetypeDelete(int NoticeTypeID) { try { B_NoticeTypeTable dbNoticeTable = (from tbNoticetype in myDYXTEntities.B_NoticeTypeTable where tbNoticetype.NoticeTypeID == NoticeTypeID select tbNoticetype).Single(); //删除数据 myDYXTEntities.B_NoticeTypeTable.Remove(dbNoticeTable); myDYXTEntities.SaveChanges(); return(Json(true, JsonRequestBehavior.AllowGet)); } catch (Exception e) { Console.WriteLine(e); //"数据异常!"; } return(Json(false, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 修改公告类型保存 /// </summary> /// <param name="NoticeTypeTable"></param> /// <returns></returns> public ActionResult UpdateNoticeType(B_NoticeTypeTable NoticeTypeTable) { //定义返回 string strMsg = "fail"; if (!string.IsNullOrEmpty(NoticeTypeTable.NoticeTypeName)) { //查询除了自身外 公告类型名称查询是否已经存在 int oldCount = (from tbNoticeType in myDYXTEntities.B_NoticeTypeTable where tbNoticeType.NoticeTypeID != NoticeTypeTable.NoticeTypeID && tbNoticeType.NoticeTypeName == NoticeTypeTable.NoticeTypeName.Trim() select tbNoticeType).Count(); if (oldCount == 0) { try { //修改公告类型 myDYXTEntities.Entry(NoticeTypeTable).State = System.Data.Entity.EntityState.Modified; if (myDYXTEntities.SaveChanges() > 0) { strMsg = "success"; } } catch (Exception e) { Console.WriteLine(e); } } else { strMsg = "exist";//已经存在 } } else { strMsg = "nofull";//数据不完整 } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }
/// <summary> /// 添加分类栏目 /// </summary> /// <param name="NoticeType"></param> /// <returns></returns> public ActionResult InsertNoticeType(B_NoticeTypeTable NoticeType) { //定义返回 string strMsg = "fail"; if (!string.IsNullOrEmpty(NoticeType.NoticeTypeName)) { //根据公告名称查询是否已经存在 int oldCount = (from tbNoticeType in myDYXTEntities.B_NoticeTypeTable where tbNoticeType.NoticeTypeName == NoticeType.NoticeTypeName.Trim() select tbNoticeType).Count(); if (oldCount == 0) { try { myDYXTEntities.B_NoticeTypeTable.Add(NoticeType); if (myDYXTEntities.SaveChanges() > 0) { strMsg = "success";//成功 } } catch (Exception) { } } else { strMsg = "exist";//已经存在 } } else { strMsg = "nofull";//数据不完整 } return(Json(strMsg, JsonRequestBehavior.AllowGet)); }