Medical/Html/ajax/getdistinctdata.ashx.cs

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

using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;

namespace WebApplication.Html.ajax
{
    /// <summary>
    /// getdistinctdata 的摘要说明
    /// </summary>
    public class getdistinctdata : IHttpHandler
    {

        public void ProcessRequest(HttpContext context)
        {
            context.Response.ContentType = "text/plain";
            //context.Response.Write("Hello World");
            if (context.Request["selid"] != null) 
            {
                DataTable dt = new DataTable();
                dt = DBUtility.DbHelperSQL.Query("select distinct Year  from [GZXX_U_Magazine]").Tables[0];
                string html = "";
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    string ck = "";
                    if (context.Request["selid"] == dt.Rows[i]["Year"].ToString()) {
                        ck = " selected=\"selected\" ";
                    }
                    html += "<option value='" + dt.Rows[i]["Year"].ToString() + "' "+ck+">" + dt.Rows[i]["Year"].ToString() + "年</option>";
                }
                context.Response.Write(html);
            }
        }

        public bool IsReusable
        {
            get
            {
                return false;
            }
        }
    }
}