HEGII.ss.mes.web/wwwroot/mes/mst/defectgroup/getDefect.ashx

<%@ WebHandler Language="C#" Class="getDefect" %>

using System;
using System.Web;
using System.Web.SessionState;
using System.Data;
using System.Text;
using System.Collections;
using System.Collections.Generic;
using Newtonsoft.Json;
using Newtonsoft.Json.Linq;
using Curtain.DataAccess;
using DK.XuWei.WebMes;

public class getDefect : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";
        using (IDataAccess conn = DataAccess.Create())
        {
            DataTable dt = conn.ExecuteDatatable(@"
                SELECT
	                D.DEFECTID,
	                D.DEFECTCODE,
	                D.DEFECTNAME,
	                T.DEFECTTYPENAME || '_' || D.DEFECTNAME AS DEFECTFULLNAME 
                FROM
	                TP_MST_DEFECT D
	                LEFT JOIN TP_MST_DEFECTTYPE T ON D.DEFECTTYPEID = T.DEFECTTYPEID 
                WHERE
	                t.DEFECTTYPEID > 0 
	                AND d.VALUEFLAG = '1'
                ORDER BY
	                t.DISPLAYNO,
	                d.DISPLAYNO
            ",
                new CDAParameter("ACCOUNTID", context.Session["accountId"])
                );

            DataRow dr = dt.NewRow();
            dr["DEFECTID"] = 0;
            dr["DEFECTCODE"] = "";
            dr["DEFECTNAME"] = "无";
            dr["DEFECTFULLNAME"] = "无";
            dt.Rows.InsertAt(dr,0);

            if (context.Request["select"] is object)
                context.Response.Write(dt.ToJson());
            else
                context.Response.Write(new JsonResult(dt).ToJson());
        }

    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}