public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string act = context.Request["action"]; if (act == "studentToClassname") { DataTable dt = new DataTable(); try { dt = SqlHelper.ExecuteDataTable("select cid,classname from class"); } catch (Exception e) { context.Response.Write("访问数据库错误!"); } string json = DataTableToJson.DataTableToJsonWithJavaScriptSerializer(dt); context.Response.Write(json); } else if (act == "classToTname") { DataTable dt = new DataTable(); try { dt = SqlHelper.ExecuteDataTable("select tid,tname from teacher"); } catch (Exception e) { context.Response.Write("访问数据库错误!"); } string json = DataTableToJson.DataTableToJsonWithJavaScriptSerializer(dt); context.Response.Write(json); } }
public void ProcessRequest(HttpContext context) { context.Response.ContentType = "text/plain"; string act = context.Request["action"]; if (act == "student") { DataTable dt = new DataTable(); int PageNumber = 1; if (context.Request["PageNumber"] != null) { Regex r = new Regex(@"^\d*$"); if (r.IsMatch(context.Request["PageNumber"])) { PageNumber = int.Parse(context.Request["PageNumber"].ToString()); } } try { dt = SqlHelper.ExecuteDataTable("select * from (select *,ROW_NUMBER() over( order by sid asc) as num from student) s,class where s.cid=class.cid and s.num>@Start and s.num<@End", new SqlParameter("@Start", (PageNumber - 1) * 3), new SqlParameter("@End", PageNumber * 3 + 1)); } catch (Exception e) { context.Response.Write("访问数据库出错!"); } string json = DataTableToJson.DataTableToJsonWithJavaScriptSerializer(dt); context.Response.Write(json); } else if (act == "class") { DataTable dt = new DataTable(); int PageNumber = 1; if (context.Request["PageNumber"] != null) { Regex r = new Regex(@"^\d*$"); if (r.IsMatch(context.Request["PageNumber"])) { PageNumber = int.Parse(context.Request["PageNumber"].ToString()); } } try { dt = SqlHelper.ExecuteDataTable("select * from (select *,ROW_NUMBER() over( order by cid asc) as num from class) c,teacher where c.tid=teacher.tid and c.num>@Start and c.num<@End", new SqlParameter("@Start", (PageNumber - 1) * 3), new SqlParameter("@End", PageNumber * 3 + 1)); } catch (Exception e) { context.Response.Write("访问数据库出错!"); } string json = DataTableToJson.DataTableToJsonWithJavaScriptSerializer(dt); context.Response.Write(json); } else if (act == "teacher") { DataTable dt = new DataTable(); int PageNumber = 1; if (context.Request["PageNumber"] != null) { Regex r = new Regex(@"^\d*$"); if (r.IsMatch(context.Request["PageNumber"])) { PageNumber = int.Parse(context.Request["PageNumber"].ToString()); } } try { dt = SqlHelper.ExecuteDataTable("select * from (select *,ROW_NUMBER() over( order by tid asc) as num from teacher) t where t.num>@Start and t.num<@End", new SqlParameter("@Start", (PageNumber - 1) * 3), new SqlParameter("@End", PageNumber * 3 + 1)); } catch (Exception e) { context.Response.Write("访问数据库出错!"); } string json = DataTableToJson.DataTableToJsonWithJavaScriptSerializer(dt); context.Response.Write(json); } }