HEGII.gt.mes.check/wwwroot/main/PreProductCheck/api/GetProductCheckDefect.ashx

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

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

/// <summary>
/// 从WCF接口获取 产品缺陷名称
/// xuwei 2019-10-26
/// </summary>
public class GetProductCheckDefect : IHttpHandler, IRequiresSessionState
{
    public void ProcessRequest(HttpContext context)
    {
        using (IDataAccess conn = DataAccess.Create())
        {
            string m = context.Request["m"] is object ? context.Request["m"].ToString() : "";
            string sqlStr = "";
            //全部
            if( m == "0")
            {
                sqlStr = @"
                    SELECT
	                    DEFECTTYPEID, --缺陷类别编号
	                    DEFECTID, --缺陷编号
	                    DEFECTCODE, --缺陷编码
	                    DEFECTNAME --缺陷名称
                    FROM
	                    TP_MST_DEFECT 
                    WHERE
	                    VALUEFLAG = '1' --有效标识
                        AND DEFECTTYPEID > 0
                    ORDER BY
	                    DEFECTTYPEID, --缺陷类别编号
	                    DISPLAYNO --显示顺序
                    ";
            }
            //次品
            if( m == "1")
            {
                sqlStr = @"
                    SELECT
	                    DEFECTTYPEID, --缺陷类别编号
	                    DEFECTID, --缺陷编号
	                    DEFECTCODE, --缺陷编码
	                    DEFECTNAME --缺陷名称
                    FROM
	                    TP_MST_DEFECT 
                    WHERE
	                    VALUEFLAG = '1' --有效标识
                        AND DEFECTTYPEID > 0
					    AND (INSTR(DEFECTCODE,'0') <> 1 AND INSTR(DEFECTCODE,'9') <> 1 OR INSTR(DEFECTNAME,'水箱盖')>0)
                    ORDER BY
	                    DEFECTTYPEID, --缺陷类别编号
	                    DISPLAYNO --显示顺序
                    ";
            }
            //副品
            if( m == "2")
            {
                sqlStr = @"
                    SELECT
	                    DEFECTTYPEID, --缺陷类别编号
	                    DEFECTID, --缺陷编号
	                    DEFECTCODE, --缺陷编码
	                    DEFECTNAME --缺陷名称
                    FROM
	                    TP_MST_DEFECT 
                    WHERE
	                    VALUEFLAG = '1' --有效标识
                        AND DEFECTTYPEID > 0
					    AND (INSTR(DEFECTCODE,'0') = 1 OR INSTR(DEFECTCODE,'9') = 1 OR INSTR(DEFECTNAME,'水箱盖')>0)
                    ORDER BY
	                    DEFECTTYPEID, --缺陷类别编号
	                    DISPLAYNO --显示顺序
                    ";
            }

            context.Response.Write(new JsonResult(conn.ExecuteDatatable(sqlStr)).ToJson());
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}