public IHttpActionResult Add(InputStorePersonModel input)
{
try
{
if (!ModelState.IsValid)
{
//返回错误
return(JsonResultHelper.JsonResult(1000, ModelState.Values.SelectMany(p => p.Errors.Select(s => s.ErrorMessage))));
}
else
{
string sql = string.Format("SELECT IdPerson FROM REF_STORE_PERSON WHERE IdPerson={0}", input.IdPerson);
//获取中间表中的人员id
var personlist = DbContext.Database.SqlQuery <decimal>(sql).ToList();
if (personlist.Count() > 0)
{
return(JsonResultHelper.JsonResult(1000, "该人员已有门店"));
}
else
{
string insert = string.Format("INSERT REF_STORE_PERSON(IdPerson,IdStore)VALUES({0},{1})", input.IdPerson, input.IdStore);
DbContext.Database.ExecuteSqlCommand(insert);
return(JsonResultHelper.JsonResult(0, "添加成功"));
}
}
}
catch (Exception ex)
{
return(JsonResultHelper.JsonResult(1000, ex.Message));
}
}
public IHttpActionResult Update(InputStorePersonModel input)
{
try
{
if (!ModelState.IsValid)
{
//返回错误
return(JsonResultHelper.JsonResult(1000, ModelState.Values.SelectMany(p => p.Errors.Select(s => s.ErrorMessage))));
}
else
{
string update = string.Format("UPDATE REF_STORE_PERSON SET IdStore={0} WHERE IdPerson={1}", input.IdStore, input.IdPerson);
DbContext.Database.ExecuteSqlCommand(update);
return(JsonResultHelper.JsonResult(0, "添加成功"));
}
}
catch (Exception ex)
{
return(JsonResultHelper.JsonResult(1000, ex.Message));
}
}
