/// <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));
}
