public ApiResult Add(string access_token, string Name, string GradeName) { result = AccessToken.Check(access_token, "api/honor/add"); if (result == null) { #region 参数验证 if (Name == "" || Name == null || GradeName == "" || GradeName == null) { Dictionary <string, string> errorFields = new Dictionary <string, string>(); if (Name == "" || Name == null) { errorFields.Add("Name", "Name字段不能为空"); } if (GradeName == "" || GradeName == null) { errorFields.Add("GradeName", "GradeName"); } return(Error("参数格式错误", errorFields)); } #endregion #region 逻辑操作 var honorModel = from T_Honor in db.T_Honor where (T_Honor.Name == Name && T_Honor.GradeName == GradeName) select T_Honor; if (honorModel.Any()) { return(Error("该条记录已存在")); } else { try { T_Honor model = new T_Honor(); model.HonorID = Guid.NewGuid().ToString(); model.Name = Name; model.GradeName = GradeName; db.T_Honor.Add(model); db.SaveChanges(); return(Success("添加成功")); } catch { return(Error("添加失败,请检查参数是否正确")); } } #endregion } return(result); }
public ApiResult Delete(string access_token, string honorID) { result = AccessToken.Check(access_token, "api/honor/delete"); if (result == null) { #region 参数验证 if (honorID == null || honorID == "") { Dictionary <string, string> errorFields = new Dictionary <string, string>(); errorFields.Add("honorID", "honorID字段不能为空"); return(Error("参数格式错误", errorFields)); } #endregion #region 逻辑操作 var honorModel = from T_Honor in db.T_Honor where (T_Honor.HonorID == honorID) select T_Honor; if (honorModel.Any()) { var honorList = from T_HnrRecord in db.T_HnrRecord where (T_HnrRecord.HonorID == honorID) select T_HnrRecord; if (honorList.Any()) { return(Error("数据库中包含此奖项获奖记录,不能删除")); } else { try { T_Honor model = db.T_Honor.Find(honorID); db.T_Honor.Remove(model); db.SaveChanges(); return(Success("删除成功")); } catch { return(Error("删除失败")); } } } else { return(Error("数据库中不包含此奖项ID")); } #endregion } return(result); }
public ApiResult Modify([FromBody] HonorModify model) { result = AccessToken.Check(model.access_token, "api/honor/modify"); if (result == null) { result = ParameterCheck.CheckParameters(model); if (result == null) { #region 参数验证 #endregion #region 逻辑操作 T_Honor honorModel = db.T_Honor.Find(model.honorID); if (honorModel != null) { try { honorModel.Name = model.Name; honorModel.GradeName = model.GradeName; db.SaveChanges(); return(Success("修改成功")); } catch { return(Success("修改失败")); } } else { return(Error("数据错误,无法查找到此条记录")); } #endregion } return(result); } return(result); }