// JObject here is very very important... public ActionResult <string> Post2([FromBody] JObject entityObj) { //声明要插入的对象 OTHER_COMPONENT_MODEL_MST postedEntity = entityObj.ToObject <OTHER_COMPONENT_MODEL_MST>(); //获取表格中已有的数据 var orderListEntity = myContext.OTHER_COMPONENT_MODEL_MST.Where(d => d.BUMP_TYPE != null); if (!String.IsNullOrEmpty(postedEntity.BUMP_TYPE)) //修改已有数据 { orderListEntity = orderListEntity.Where(d => d.BUMP_TYPE.Equals(postedEntity.BUMP_TYPE)); } if (orderListEntity.Count() == 0) //如果表中没有任何数据,则插入新数据 { // INSERT myContext.OTHER_COMPONENT_MODEL_MST.Add(postedEntity); myContext.SaveChanges(); return(""); } else //如果表中有数据,则插入新数据 { orderListEntity.First().BUMP_TYPE = postedEntity.BUMP_TYPE; orderListEntity.First().BASE_TYPE = postedEntity.BASE_TYPE; orderListEntity.First().COUPLING_HOOD_TYPE = postedEntity.COUPLING_HOOD_TYPE; orderListEntity.First().COUPLING_BUMP_COUPLET = postedEntity.COUPLING_BUMP_COUPLET; orderListEntity.First().COUPLING_ELECTRIC_COUPLET = postedEntity.COUPLING_ELECTRIC_COUPLET; orderListEntity.First().COUPLING_PIN = postedEntity.COUPLING_PIN; orderListEntity.First().COUPLING_JUMP_RING = postedEntity.COUPLING_JUMP_RING; myContext.SaveChanges(); return(""); } }
public ActionResult <string> Delete(string BUMP_TYPE) { Boolean isSuccess = true; string data = "Delete success"; if (!String.IsNullOrEmpty(BUMP_TYPE)) { String[] BUMP_TYPE_LIST = BUMP_TYPE.Split(","); String[] RESULTS_BUMP_TYPE_LIST = new String [BUMP_TYPE_LIST.Length]; for (int i = 0; i < BUMP_TYPE_LIST.Length; i++) { RESULTS_BUMP_TYPE_LIST[i] = BUMP_TYPE_LIST[i].Replace('*', '/'); } foreach (string BUMP_ITEM in RESULTS_BUMP_TYPE_LIST) { OTHER_COMPONENT_MODEL_MST delMstEntity = new OTHER_COMPONENT_MODEL_MST() { BUMP_TYPE = BUMP_ITEM }; if (delMstEntity.Equals(null)) { isSuccess = false; data = "No such data."; break; } else { // FIND DB ITEM myContext.OTHER_COMPONENT_MODEL_MST.Attach(delMstEntity); // DELETE DB ITEM var delRes = myContext.OTHER_COMPONENT_MODEL_MST.Remove(delMstEntity); if (delRes.State == EntityState.Deleted) { // SAVE CHANGES AND DO NOT RETURN myContext.SaveChanges(); } else { isSuccess = false; data = "No such data."; break; } } } } else { isSuccess = false; data = "No such data."; } JsonRes res = new JsonRes(); res.isSuccess = isSuccess; res.data = data; return(JsonConvert.SerializeObject(res)); }