// 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);
}
