public string GetList() { string sql = "select * from XXCLOUDALL.dbo.T_SHFYOrderInfo"; //string sql = "select * from T_BlacklistInf"; DataTable dt; try { dt = SQLHelper2.ExecuteDataTable(sql, System.Data.CommandType.Text, null); return("{\"code\":1,\"data\":" + ConvertHelper.DataTableToJson(dt) + "}"); } catch (Exception e) { //在webapi中要想抛出异常必须这样抛出,否则只抛出一个默认500的异常 var resp = new HttpResponseMessage(HttpStatusCode.InternalServerError) { Content = new StringContent(e.ToString()), ReasonPhrase = "error" }; throw new HttpResponseException(resp); } }