HEGII.ft.mes.dashboard/wwwroot/main/Report/api/Get_Report_Defect.ashx


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

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

public class Get_Report_Defect : IHttpHandler,IRequiresSessionState
{
    public void ProcessRequest(HttpContext context)
    {
        if (HttpContext.Current.Session["userCode"] is object)
        {

            using (IDataAccess conn = DataAccess.Create())
            {
                //统计语句
                string sqlStr = @"
                    SELECT
	                    DEFECTTYPEID, --缺陷类别编号
	                    DEFECTID, --缺陷编号
	                    DEFECTCODE, --缺陷编码
	                    DEFECTNAME --缺陷名称
                    FROM
	                    TP_MST_DEFECT 
                    WHERE
	                    VALUEFLAG = '1' --有效标识
                    ORDER BY
	                    DEFECTTYPEID, --缺陷类别编号
	                    DISPLAYNO --显示顺序
                ";
                DataTable dt = conn.ExecuteDatatable(sqlStr);

                //输出结果
                context.Response.Write(new JsonResult(dt).ToJson());
            }


        }
        else
        {
            context.Response.Write(new JsonResult(JsonStatus.otherError).ToJson());
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}