public class datagrid_data : IHttpHandler {
public void ProcessRequest (HttpContext context) {
HttpRequest request=context.Request;
context.Response.ContentType = "text/plain";
if(request.QueryString["a"]=="json")
{
//context.Response.Write("" +
// "{ \"total\":239," +
// "\"rows\":[{\"code\":\"001\",\"name\":\"Name 1\",\"addr\":\"Address 11\",\"col4\":\"col4 data\"}," +
// "{\"code\":\"010\",\"name\":\"Name 10\",\"addr\":\"Address 78\",\"col4\":\"col4 data\"}" +
// "]}");
//context.Response.Write("{\"total\":239,\"rows\":[{\"code\":\"16093\",\"name\":\"齐秀兰\",\"addr\":\"心语心理咨询室\",\"col4\":\"True\"}," +
// "{\"code\":\"75744\",\"name\":\"郭蓄芳\",\"addr\":\"郭蓄芳心理工作室\",\"col4\":\"True\"}]}");
//context.Response.Write("{\"total\":239,\"rows\":[{\"id\":\"16093\",\"realname\":\"齐秀兰\",\"title\":\"心语心理咨询室\",\"way1\":\"True\"},{\"id\":\"75744\",\"realname\":\"郭蓄芳\",\"title\":\"郭蓄芳心理工作室\",\"way1\":\"True\"}]}");
//string myJson = ShowConsultantTuijian();
context.Response.Write(ShowConsultantTuijian());
}
}
public string ShowConsultantTuijian()
{
using (DataTable dt = SqlHelper.ExecuteDataTable("select top 2 consultant.id,realname,title,way1 from consultant join v_member on v_member.id=consultant.id where consultant.istuijian=1 and status=2")) // order by dbo.f_GetPY(title)
{
string dt2Json = DataTable2Json.myDataTable2Json(dt,0);
return dt2Json;
}
}
public bool IsReusable {
get {
return false;
}
}
}
这里需要注意的是在转换成json数据的时候,json只识别反斜杠的格式来输出字符串,而不能是通常我们熟悉的c#或者是java的语法格式,比如是在双引号间使用单引号,而json只能使用转义字符,比如:"{ \"total\":239,"