public JsonResult Query(string filter) { var result = new JsonResultModel() { }; try { var filters = JsonConvert.DeserializeObject <QueryPageFilter>(filter); var objs = ServiceAppContext.Instance.DataBaseClassHelper.GetQueryResultN(filters); result.SetData(objs).SetTotal(objs.Length); } catch (Exception ex) { if (ex is ApiException) { ApiException e = ex as ApiException; result.SetCode(e.Code).SetMsg(e.Message); } else { result.SetCode(ResultCode.CUSTOMEXCEPTION).SetMsg(ex.Message); } } JsonResult re = new JsonResult(result); return(re); }
public void OnException(ExceptionContext context) { Exception ex = context.Exception; JsonResultModel resultModel = new JsonResultModel(); if (ex is ApiException) { var apiEx = ex as ApiException; resultModel.SetCode(apiEx.Code).SetMsg(apiEx.Message); } else { resultModel.SetCode(ResultCode.CUSTOMEXCEPTION).SetMsg(ex.Message); } Logger.Default.Error(context.HttpContext.Request.Path, context.Exception); context.Result = new JsonResult(resultModel); context.ExceptionHandled = true; }
public JsonResult batchInsert(string tb, string objs) { var result = new JsonResultModel() { }; try { var dic = JsonConvert.DeserializeObject <Dictionary <string, object>[]>(objs); ServiceAppContext.Instance.DataBaseClassHelper.BatchInsert(tb, dic); } catch (Exception ex) { result.SetCode(ResultCode.CUSTOMEXCEPTION).SetMsg(ex.Message); } JsonResult re = new JsonResult(result); return(re); }
public JsonResult FilterDelete(string filter) { var result = new JsonResultModel() { }; try { var filters = JsonConvert.DeserializeObject <QueryPageFilter>(filter); ServiceAppContext.Instance.DataBaseClassHelper.DeleteObjects(filters); } catch (Exception ex) { result.SetCode(ResultCode.CUSTOMEXCEPTION).SetMsg(ex.Message); } JsonResult re = new JsonResult(result); return(re); }
public JsonResult Delete(string ids, string tb) { var result = new JsonResultModel() { }; try { var idInfos = JsonConvert.DeserializeObject <string[]>(ids); ServiceAppContext.Instance.DataBaseClassHelper.DeleteObjects(tb, idInfos); } catch (Exception ex) { result.SetCode(ResultCode.CUSTOMEXCEPTION).SetMsg(ex.Message); } JsonResult re = new JsonResult(result); return(re); }
public JsonResult Update(string objs, string tb, string pu) { var result = new JsonResultModel() { }; try { bool isPartialUpdates = false; if (!string.IsNullOrEmpty(pu) && pu == "1") { isPartialUpdates = true; } var dic = JsonConvert.DeserializeObject <Dictionary <string, object>[]>(objs); ServiceAppContext.Instance.DataBaseClassHelper.UpdateObjects(tb, dic, isPartialUpdates); } catch (Exception ex) { result.SetCode(ResultCode.CUSTOMEXCEPTION).SetMsg(ex.Message); } JsonResult re = new JsonResult(result); return(re); }