<%@ WebHandler Language="C#" Class="getMyCD" %>

using System;
using System.Web;
using System.Collections;
using System.Data;

public class getMyCD : IHttpHandler {
    
    public void ProcessRequest (HttpContext context) {
        string userid = context.Request.QueryString["userid"].ToString();
        
        ArrayList result = new ArrayList();
        //string username = "金开来";
        DataTable dt = getCD(userid);
        foreach (DataRow dr in dt.Rows)
        {
            Hashtable ht = new Hashtable();
            ht.Add("menuid", dr[1].ToString());
            ht.Add("menudesc", dr[3].ToString());
            result.Add(ht);
        }
        
        string nt = Newtonsoft.Json.JsonConvert.SerializeObject(result);
        context.Response.Write(nt);
    }

    private DataTable getCD(string userid)
    {
        string sql = "select * from XT_KJCD where userid='" + userid + "' order by ord";
        DbOperate dbo = new DbOperate();
        return dbo.executeAdapter(sql);
    }
    
    public bool IsReusable {
        get {
            return false;
        }
    }

}