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