/// <summary>
/// 编辑保存
/// </summary>
/// <param name="ModuleTable"></param>
/// <returns></returns>
public ActionResult Updatabianji(B_ModuleTable ModuleTable)
{
//定义返回
string strMsg = "fail";
//查询除了自身外查询是否已经存在
int oldCount = (from tbModuleTable in myDYXTEntities.B_ModuleTable
where tbModuleTable.ModuleID != ModuleTable.ModuleID &&
tbModuleTable.Name.Trim() == ModuleTable.Name.Trim()
select tbModuleTable).Count();
if (oldCount == 0)
{
try
{
ModuleTable.UpdateTime = DateTime.Now;
//修改公告类型
myDYXTEntities.Entry(ModuleTable).State = System.Data.Entity.EntityState.Modified;
if (myDYXTEntities.SaveChanges() > 0)
{
strMsg = "success";
}
}
catch (Exception e)
{
Console.WriteLine(e);
}
}
else
{
strMsg = "exist";//已经存在
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
public ActionResult DeleteModule(int ModuleID)
{
string strMsg = "fail";
try
{
B_ModuleTable varFundCost = (from tModuleTable in myDYXTEntities.B_ModuleTable
where tModuleTable.ModuleID == ModuleID
select tModuleTable).Single();
//删除数据
myDYXTEntities.B_ModuleTable.Remove(varFundCost);
myDYXTEntities.SaveChanges();
strMsg = "success";
}
catch (Exception e)
{
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
