public IHttpActionResult GetRecordInfo(int id) { RecordInfoDetail rsl = new RecordInfoDetail(); try { view_recordinfo record = db.view_recordinfo.Find(id); if (record == null) { rsl.code = 101; rsl.msg = "记录不存在!"; return(Ok(rsl)); } rsl.code = 100; rsl.recNo = record.recordNo; rsl.result = record; return(Ok(rsl)); } catch (Exception e) { rsl.code = 103; rsl.msg = e.Message; return(Ok(rsl)); } }
public IHttpActionResult AddRecordInfo() { RecordInfoDetail rsl = new RecordInfoDetail(); try { HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; String jsonBean = context.Request.Form["jsonBean"]; if (jsonBean == null) { rsl.code = 101; rsl.msg = "参数验证失败!"; return(Ok(rsl)); //return BadRequest(ModelState); } view_recordinfo record = new view_recordinfo(); record = JsonConvert.DeserializeObject <view_recordinfo>(jsonBean); record_info rec = new record_info(); rec.content = record.title; rec.loc_disp = record.locDisp; rec.loc_name = record.locName; rec.record_loc = record.recordLoc; rec.record_type = record.recordType; rec.type = record.type; rec.uuid = record.uuid; rec.creater_id = record.creatorId; rec.create_time = DateTime.Now; db.record_info.Add(rec); db.SaveChanges(); string recNo = DateTime.Now.ToString("yyyyMMdd"); for (int i = 0; i < 5 - rec.sid.ToString().Length; i++) { recNo += "0"; } recNo += rec.sid.ToString(); rec.record_no = recNo; db.record_info.Attach(rec); var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(rec); stateEntity.SetModifiedProperty("record_no"); db.SaveChanges(); rsl.code = 100; rsl.recNo = recNo.Substring(recNo.Length - 5); return(Ok(rsl)); } catch (Exception e) { rsl.code = 103; rsl.msg = e.Message; return(Ok(rsl)); } }
public IHttpActionResult UpdateRecordInfo() { RecordInfoDetail rsl = new RecordInfoDetail(); try { HttpContextBase context = (HttpContextBase)Request.Properties["MS_HttpContext"]; String jsonBean = context.Request.Form["jsonBean"]; if (jsonBean == null) { rsl.code = 101; rsl.msg = "参数验证失败!"; return(Ok(rsl)); //return BadRequest(ModelState); } view_recordinfo record = new view_recordinfo(); record = JsonConvert.DeserializeObject <view_recordinfo>(jsonBean); int id = record.sid; var rec = db.record_info.Find(id); if (rec == null) { rsl.code = 102; rsl.msg = "记录不存在!"; return(Ok(rsl)); } rec.content = record.title; rec.loc_disp = record.locDisp; rec.loc_name = record.locName; rec.record_loc = record.recordLoc; rec.record_type = record.recordType; rec.type = record.type; db.record_info.Attach(rec); var stateEntity = ((IObjectContextAdapter)db).ObjectContext.ObjectStateManager.GetObjectStateEntry(rec); stateEntity.SetModifiedProperty("content"); stateEntity.SetModifiedProperty("loc_disp"); stateEntity.SetModifiedProperty("loc_name"); stateEntity.SetModifiedProperty("record_loc"); stateEntity.SetModifiedProperty("record_type"); stateEntity.SetModifiedProperty("type"); db.SaveChanges(); } catch (Exception e) { rsl.code = 103; rsl.msg = e.Message; return(Ok(rsl)); } return(StatusCode(HttpStatusCode.NoContent)); }