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