/// <summary> /// 获取域名 /// </summary> /// <param name="sqlstr"></param> /// <returns></returns> public List <realmNameInfo> GetRealmList(string sqlstr) { List <realmNameInfo> rList = new List <realmNameInfo>(); DataTable dt = SqlHelper.ExecuteDataSet("select * from realmNameInfo " + sqlstr).Tables[0]; if (dt.Rows.Count < 1) { return(null); } foreach (DataRow row in dt.Rows) { realmNameInfo rInfo = new realmNameInfo(); rInfo.Id = (int)row["Id"]; rInfo.realmName = (string)row["realmName"]; rInfo.realmAddress = (string)row["realmAddress"]; rInfo.isUseing = (bool)row["isUseing"]; rList.Add(rInfo); } return(rList); }
public ActionResult Edit([Bind(Include = "Id,RealmName,RealmAddress,IsUsing")] realmNameInfo realmNameInfo) { if (ModelState.IsValid) { try { if (realmNameInfo.Id == "0") { if (IsExist(realmNameInfo.RealmAddress)) { return(Json(new { errorMsg = "该地址已经存在,无需添加!" }, JsonRequestBehavior.AllowGet)); } else { realmNameInfo.Id = Guid.NewGuid().ToString(); db.realmNameInfo.Add(realmNameInfo); } } else { var ise2 = db.realmNameInfo.Where(o => o.Id != realmNameInfo.Id && o.RealmAddress == realmNameInfo.RealmAddress).FirstOrDefault(); if (IsExist(realmNameInfo.RealmAddress) && ise2 != null) { return(Json(new { errorMsg = "该地址已经存在!" }, JsonRequestBehavior.AllowGet)); } else { db.Entry(realmNameInfo).State = EntityState.Modified; } } db.SaveChanges(); return(Json(new { success = true }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { errorMsg = ex.Message }, JsonRequestBehavior.AllowGet)); } } return(Json(new { errorMsg = "数据保存时出错,请联系管理员" }, JsonRequestBehavior.AllowGet)); }
public async Task <ActionResult> Delete(string id) { if (string.IsNullOrEmpty(id)) { return(Json(new { errorMsg = "id不能为空" }, JsonRequestBehavior.AllowGet)); } realmNameInfo re = await db.realmNameInfo.FindAsync(id); if (re == null) { return(Json(new { errorMsg = "为找到该条数据" }, JsonRequestBehavior.AllowGet)); } try { db.realmNameInfo.Remove(re); await db.SaveChangesAsync(); return(Json(new { success = true }, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { return(Json(new { errorMsg = ex.Message }, JsonRequestBehavior.AllowGet)); } }