<%@ WebHandler Language="C#" Class="getCD" %>

using System;
using System.Data;
using System.Collections;
using System.Web;
using System.Web.SessionState;

public class getCD : IHttpHandler, IRequiresSessionState
{
    
    public void ProcessRequest (HttpContext context) {
        //string username = "admin";
        string userid = context.Request.QueryString["userid"].ToString();
        ArrayList result = new ArrayList();
        DataTable dt = getCDMing(userid);
        foreach (DataRow dr in dt.Rows)
        {
            Hashtable ht = new Hashtable();
            ht.Add("ID", dr[0].ToString());
            ht.Add("CXID", dr[1].ToString());
            ht.Add("ZDYCX", dr[2].ToString());
            ht.Add("CaiDanXiangMing", dr[3].ToString());
            ht.Add("target", dr[4].ToString());
            ht.Add("CX",dr[5].ToString());
            result.Add(ht);
        }
        string nt = Newtonsoft.Json.JsonConvert.SerializeObject(result);
        context.Response.Write(nt);
    }

    private DataTable getCDMing(string id)
    {
        DbOperate dbo = new DbOperate();
        string parentID = System.Configuration.ConfigurationManager.AppSettings["RootMenuID"].ToString();
        string sql = "SELECT ID,CXID,ZDYCX,CaiDanXiangMing,target,CAIDANCIXU FROM COM_XTCDB WHERE ID in (SELECT c.id FROM COM_YHQXB a,COM_YHGWDZB b,COM_XTCDB c where a.GANGWEI_ID=b.GANGWEI_ID and a.CAIDAN_ID=c.ID and (b.RENYUAN_ID='" + id + "') and c.FuCaiDanID='" + parentID + "' and c.XIANSHI=1) ORDER BY CAIDANCIXU";
        return dbo.executeAdapter(sql);
    }
 
    public bool IsReusable {
        get {
            return false;
        }
    }

}