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