public IHttpActionResult Create(YY.Edu.Sys.Models.VenueInfo venueInfo) { if (!ModelState.IsValid) { return(Ok(Comm.ResponseModel.ResponseModelBase.GetRes(ValidationMsg))); } try { venueInfo.AddTime = DateTime.Now; var result = Comm.Helper.DapperHelper.Instance.Insert(venueInfo); if (result > 0) { return(Ok(Comm.ResponseModel.ResponseModelBase.Success())); } else { return(Content(HttpStatusCode.OK, Comm.ResponseModel.ResponseModelBase.GetRes(Comm.ResponseModel.ResponseModelErrorEnum.SystemError))); } } catch (Exception ex) { logs.Error("场馆信息添加失败", ex); return(BadRequest()); } }
public IHttpActionResult Save(YY.Edu.Sys.Models.VenueInfo venueInfo) { if (!ModelState.IsValid) { return(Ok(Comm.ResponseModel.ResponseModelBase.GetRes(ValidationMsg))); } //IPredicate predList = Predicates.Field<YY.Edu.Sys.Models.VenueInfo>( // f => f.VenueID, Operator.Eq, venueInfo.VenueID //); var sql = "select COUNT(VInfoID) from venueinfo where venueid=@venueid"; var result = DapperHelper.Instance.Query <int>(sql, new { venueid = venueInfo.VenueID }); int count = result.FirstOrDefault();// Comm.Helper.DapperHelper.Instance.Count<YY.Edu.Sys.Models.VenueInfo>(predList); return(count > 0 ? Edit(venueInfo) : Create(venueInfo)); }