Backup/c.ashx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Data;
using System.Text;
namespace 下拉框级联
{
    /// <summary>
    /// c 的摘要说明
    /// </summary>
    public class c : IHttpHandler
    {

        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            int id = int.Parse(context.Request["id"].ToString());
            DataTable dt = getTable(id);
            string ss = JSONHelper.DataTableToJsonEx(dt);
            context.Response.Write(ss);
        }
        DataTable getTable(int id)
        {
            StringBuilder sb = new StringBuilder();
            sb.Append(" select  s.name as name,s.sex as sex,s.age as age, ");
            sb.Append(" s.address as address,s.hobby as hobby, ");
            sb.Append(" c.name as classname from student as s,classes as c ");
            string sql = string.Empty;
            sql = sb.ToString();
            sql += string.Format("where s.c_id=c.id and s.id={0}",id);
         //   string sql = string.Format("select s.name as name,s.sex as sex,s.age as age,s.address as address,s.hobby as hobby,c.name as classname from student as s,classes as c  where s.c_id=c.id and s.id={0}", id);
            return SqlHelper.GetTable(sql);
          
        }
        public bool IsReusable
        {
            get
            {
                return false;
            }
        }
    }
}