public HttpResponseBase QueryErrorLog() { string jsonStr = "{success:false}"; string startDate = Request.Form["startDate"] ?? ""; string endDate = Request.Form["endDate"] ?? ""; //添加 級別 的查詢條件 add by zhuoqin0830w 2015/02/04 string level = Request.Form["level"] ?? ""; if (startDate.Equals("1970-01-01 08:00:00")) { startDate = ""; } if (endDate.Equals("1970-01-01 08:00:00")) { endDate = ""; } int startPage = Convert.ToInt32(Request.Form["start"] ?? "0"); int endPage = Convert.ToInt32(Request.Form["limit"] ?? "20"); int totalCount = 0; try { IErrorLogImplMgr _errorMgr = new ErrorLogMgr(connectionString); List<ErrorLog> errorList = new List<ErrorLog>(); //添加 級別 的查詢條件 edit by zhuoqin0830w 2015/02/05 errorList = _errorMgr.QueryErrorLog(startDate, endDate, startPage, endPage, out totalCount, level); jsonStr = "{success:true,totalCount:" + totalCount + ",data:" + JsonConvert.SerializeObject(errorList) + "}"; } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } this.Response.Clear(); this.Response.Write(jsonStr); this.Response.End(); return this.Response; }
/// <summary> /// 獲取 ErrorLog 中所有的 Level /// </summary> /// <returns></returns> public JsonResult GetLevel() { JsonResult json = null; try { IErrorLogImplMgr _errorMgr = new ErrorLogMgr(connectionString); List<ErrorLog> errorList = new List<ErrorLog>(); errorList = _errorMgr.GetLevel(); var result = from f in errorList select new { Level = f.Level }; if (result == null) { json = Json("[]"); } else { json = Json(result); } } catch (Exception ex) { Log4NetCustom.LogMessage logMessage = new Log4NetCustom.LogMessage(); logMessage.Content = string.Format("TargetSite:{0},Source:{1},Message:{2}", ex.TargetSite.Name, ex.Source, ex.Message); logMessage.MethodName = System.Reflection.MethodBase.GetCurrentMethod().Name; log.Error(logMessage); } return json; }