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