<%@ WebHandler Language="C#" Class="CheckPriKey"  %>

using System;
using System.Collections.Generic;
using System.Web;
using System.Data;
using System.IO;
using eMIS.Data;
using System.Text;
using System.Web.SessionState;
using eMIS;


public class CheckPriKey : IHttpHandler, IRequiresSessionState
{

    public void ProcessRequest (HttpContext context)
    {
        //string programId = context.Request.QueryString["pid"].ToString();
        string objectId = context.Request.QueryString["oid"].ToString();
        string recordId = context.Request.QueryString["rid"].ToString();
        string objectType = context.Request.QueryString["ot"].ToString();

        DataManager dm = new DataManager();

        DataTable  dt = dm.ExecuteTable("select * from COM_DXB where id=" + objectId);
        string sql = "";
        string qzzd = "", mszd = "", fwb = "", zjzd = "",menuId="",objectDesc="";
        if (dt.Rows.Count!=0)
        {
            qzzd = dt.Rows[0]["qzzd"].ToString();
            mszd = dt.Rows[0]["mszd"].ToString();
            fwb = dt.Rows[0]["fwb"].ToString();
            zjzd = dt.Rows[0]["zjzd"].ToString();
            menuId = dt.Rows[0]["cxid"].ToString();
            objectDesc = dt.Rows[0]["ms"].ToString();
        }

        string json = "{val:'',txt:''}";
        string[] a = recordId.Split(',');
        string val = "", txt = "";

        InstanceManager inst = new InstanceManager(context, dm, menuId);
        int ii;
        for (int i = 0; i < a.Length; i++)
        {
            sql = "select " + qzzd + " as val," + mszd + " as txt from " + fwb + " where " + zjzd + "='" + a[i] + "'";
            context.Response.Write(sql);
            dt = inst.BusinessDbOperator.ExecuteTable(sql);
            for (ii=0;ii<dt.Rows.Count;ii++)
            {
                val += "," + (objectType=="0"?"":objectId + "$") + dt.Rows[ii][0].ToString();
                txt += "," + (objectType=="0"?"":objectDesc + ":") + dt.Rows[ii][1].ToString();
            }
        }

        if (val != "")
        {
            val = val.Substring(1);
            txt = txt.Substring(1);
            txt = txt.Replace("\r\n","");
            json = "{val:'" + val + "',txt:'" + txt + "'}";
        }


        context.Response.ContentType = "text/plain";
        context.Response.ContentEncoding = System.Text.Encoding.UTF8;
        context.Response.Write(json);

    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}