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