public ActionResult InsertContactCertificatet(S_ContactCertificate sysNoticeType)
{
string strMsg = "falied";
if (!string.IsNullOrEmpty(sysNoticeType.ContactCertificateName))
{
int oldCount = (from tbNoticeType in MyModels.S_ContactCertificate
where tbNoticeType.ContactCertificateName == sysNoticeType.ContactCertificateName.Trim()
select tbNoticeType).Count();
if (oldCount == 0)
{
try
{
MyModels.S_ContactCertificate.Add(sysNoticeType);
if (MyModels.SaveChanges() > 0)
{
strMsg = "success";
}
}
catch (Exception)
{
}
}
else
{
strMsg = "exist";//已经存在
}
}
else
{
strMsg = "nofull";//数据不完整
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
public ActionResult SelectContactCertificateID(int noticeTypeId)
{
try
{
S_ContactCertificate noticeType = (from tbNoticeType in MyModels.S_ContactCertificate
where tbNoticeType.ContactCertificateID == noticeTypeId
select tbNoticeType).Single();
return(Json(noticeType, JsonRequestBehavior.AllowGet));
}
catch (Exception e)
{
Console.WriteLine(e);
return(Json(null, JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteContactCertificate(int noticeTypeId)
{
//定义返回
string strMsg = "fail";
try
{
S_ContactCertificate dbNoticeType = (from tbNoticeTypeDetails in MyModels.S_ContactCertificate
where tbNoticeTypeDetails.ContactCertificateID == noticeTypeId
select tbNoticeTypeDetails).Single();
MyModels.S_ContactCertificate.Remove(dbNoticeType);//删除
if (MyModels.SaveChanges() > 0)
{
strMsg = "success";
}
}
catch (Exception)
{
}
return(Json(strMsg, JsonRequestBehavior.AllowGet));
}
