// PUT api/syslog/5 public HttpResponseMessage Putsyslog(long id, syslog syslog) { if (!ModelState.IsValid) { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } if (id != syslog.id) { return(Request.CreateResponse(HttpStatusCode.BadRequest)); } db.Entry(syslog).State = EntityState.Modified; try { db.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex)); } return(Request.CreateResponse(HttpStatusCode.OK)); }
// GET api/syslog/5 public syslog Getsyslog(long id) { syslog syslog = db.syslog.Find(id); if (syslog == null) { throw new HttpResponseException(Request.CreateResponse(HttpStatusCode.NotFound)); } return(syslog); }
// POST api/syslog public HttpResponseMessage Postsyslog(syslog syslog) { if (ModelState.IsValid) { db.syslog.Add(syslog); db.SaveChanges(); HttpResponseMessage response = Request.CreateResponse(HttpStatusCode.Created, syslog); response.Headers.Location = new Uri(Url.Link("DefaultApi", new { id = syslog.id })); return(response); } else { return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, ModelState)); } }
// DELETE api/syslog/5 public HttpResponseMessage Deletesyslog(long id) { syslog syslog = db.syslog.Find(id); if (syslog == null) { return(Request.CreateResponse(HttpStatusCode.NotFound)); } db.syslog.Remove(syslog); try { db.SaveChanges(); } catch (DbUpdateConcurrencyException ex) { return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex)); } return(Request.CreateResponse(HttpStatusCode.OK, syslog)); }
public List <syslog> GetLogList(string sql, string sql_c, out int Count) { List <syslog> ls = new List <syslog>(); int LogCount = 1; try { LogCount = Convert.ToInt32(helper.GetOne(sql_c)); } catch { LogCount = 1; } Count = LogCount; using (DataTable dt = helper.GetDataTable(sql)) { if (dt != null && dt.Rows.Count > 0) { try { foreach (DataRow r in dt.Rows) { syslog s = new syslog { orderNo = r["orderNo"].ToString(), addOn = Convert.ToDateTime(r["addOn"]), uid = Convert.ToInt32(r["uid"]), workNo = r["workNo"].ToString(), adminName = r["adminName"].ToString(), content = r["content"].ToString(), lType = Convert.ToInt16(r["lType"]), lt = Convert.ToInt16(r["lt"]), uName = "--" }; if (s.uid > 0) { user u = new _User().GetUser("", "", s.uid); if (u != null) { s.uName = u.contact; if (s.uName.Length == 0) { s.uName = u.nickName; } } } else { if (s.lType == 5) { s.adminName = "[" + s.workNo + "]" + s.adminName; } } ls.Add(s); } } catch (Exception ex) { } } } return(ls); }