HEGII.ss.mes.check/wwwroot/main/PreProductCheck/api/GetDefectDeduction.ashx

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

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

/// <summary>
/// 获取 缺陷扣除
/// xuwei 2020-03-05
/// </summary>
public class GetDefectDeduction : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        using (IDataAccess conn = DataAccess.Create())
        {
            DataTable dt = conn.ExecuteDatatable(@"
                SELECT
	                D.DEFECTDEDUCTIONID,
	                D.DEFECTDEDUCTIONNUM 
                FROM
	                TP_MST_DEFECTDEDUCTION D
	                LEFT JOIN TP_MST_DEFECTDEDUCTIONRELATION DR ON D.DEFECTDEDUCTIONID = DR.DEFECTDEDUCTIONID 
                WHERE
	                DR.DEFECTID = @DEFECTID@
                ORDER BY
	                D.DISPLAYNO
                ",
                new CDAParameter("DEFECTID", context.Request["defectid"])
                );
            context.Response.Write(new JsonResult(dt).ToJson());
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}