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

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

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 GetCheckFlag : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        using (IDataAccess conn = DataAccess.Create())
        {
            if (context.Request["m"] == "getCheckFlag")
            {
                DataTable dt = conn.ExecuteDatatable(@"
                SELECT * FROM (
                    SELECT
	                    PRODUCTIONDATAID
                    FROM
	                    TP_PM_PRODUCTIONDATA
                    WHERE
	                    VALUEFLAG = 1
                        AND PROCEDUREID = 80
                        AND BARCODE = @BARCODE@
                    ORDER BY 
                        PRODUCTIONDATAID DESC
                    ) T 
                WHERE 
                    ROWNUM=1
                ",
                    new CDAParameter("BARCODE", context.Request["barcode"])
                    );
                if (dt.Rows.Count == 0)
                {
                    DataTable dt1 = conn.ExecuteDatatable(@"
                    SELECT * FROM (
                        SELECT
	                        T.PRODUCTIONDATAID, T.PROCEDUREID
                        FROM
	                        TP_PM_PRODUCTIONDATAIN T
	                        INNER JOIN TP_PM_INPRODUCTION INP ON INP.BARCODE = T.BARCODE 
	                        AND NVL(T.KILNCARBATCHNO, 0) = NVL(INP.KILNCARBATCHNO, 0) 
                        WHERE
	                        T.MODELTYPE = -4 -- 成检交接模型 
	                        AND T.VALUEFLAG = '1' 
	                        AND T.BARCODE = @BARCODE@
                        ORDER BY 
                            T.PRODUCTIONDATAID DESC
                        ) T 
                    WHERE 
                        ROWNUM=1
                ",
                        new CDAParameter("BARCODE", context.Request["barcode"])
                    );
                    if (dt1.Rows.Count == 0)
                    {
                        context.Response.Write(new JsonResult(dt1){message = "1" }.ToJson());
                    }
                    else
                    {
                        context.Response.Write(new JsonResult(dt1){message = "2" }.ToJson());
                    }
                }
                else {
                    DataTable dt2 = conn.ExecuteDatatable(@"
                    SELECT * FROM (
                        SELECT
	                        PRODUCTIONDATAID
                        FROM
	                        TP_PM_PRODUCTIONDATA
                        WHERE
	                        VALUEFLAG = 1
                            AND PROCEDUREID = 104
                            AND BARCODE = @BARCODE@
                            AND PRODUCTIONDATAID > @PDID@
                        ORDER BY 
                            PRODUCTIONDATAID DESC
                        ) T 
                    WHERE 
                        ROWNUM=1
                ",
                        new CDAParameter("BARCODE", context.Request["barcode"]),
                        new CDAParameter("PDID", dt.Rows[0]["PRODUCTIONDATAID"])
                    );
                    if (dt2.Rows.Count == 0)
                    {
                        context.Response.Write(new JsonResult(dt2){message = "3" }.ToJson());
                    }
                    else {
                        context.Response.Write(new JsonResult(dt2){message = "4" }.ToJson());
                    }
                }
            }
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}