HEGII.ss.mes.dashboard/wwwroot/main/packingform/index.ashx

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

using System;
using System.Web;
using System.Data;
using Curtain.DataAccess;
using DK.XuWei.WebMes;

public class index : IHttpHandler
{

    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";

        using (IDataAccess conn = DataAccess.Create())
        {
            string SqlStr = @"SELECT
					M.PACKINGLINE AS 线号,
					G.GOODSCODE AS 产品型号,
					G.OUTLETDISTANCE AS 出水距,
					L.LOGONAME AS 商标,
					G.MATERIALREMARK AS 商标物料描述,
					NVL( ML.LOGONAME, '' ) AS 商标变更,
					(SELECT MATERIALREMARK FROM TP_MST_GOODSLOGOSAP WHERE LOGOID= ML.LOGOID AND GOODSCODE=G.GOODSCODE) AS 商标变更物料描述,
					GM.MATERIALCODE AS 物料编码,
					M.PLATENUM AS 出库数量,
					M.OUTNUM AS 已出数量,
					CASE WHEN M.STATUS = '-1' THEN '未确认' WHEN M.STATUS = '0' THEN '队列中' WHEN M.STATUS = '1' THEN '执行中' WHEN M.STATUS = '2' THEN '已完成'  WHEN M.STATUS = '3' THEN '异常终止'  END AS 状态,
					M.CREATETIME AS 下单时间 
				FROM
					TP_MST_PACKINGFORM M
					LEFT JOIN V_GOODS_MATERIALCODE GM ON GM.GOODSID = M.GOODSID AND GM.MATERIALCODE = M.MATERIALCODE
					LEFT JOIN TP_MST_GOODS G ON G.GOODSID = M.GOODSID 
					LEFT JOIN TP_MST_LOGO L ON L.LOGOID = G.LOGOID
					LEFT JOIN TP_MST_LOGO ML ON ML.LOGOID = M.LOGOID 
				WHERE
					M.VALUEFLAG = '1' AND M.STATUS < 2 ";
            if (!string.IsNullOrEmpty(context.Request["linenumber"].ToString()))
            {
                SqlStr += " AND M.PACKINGLINE=" + context.Request["linenumber"].ToString();
            }
            SqlStr += " ORDER BY M.STATUS,G.OUTLETDISTANCE";
            DataTable dt = conn.ExecuteDatatable(SqlStr);

            string jsonStr = new JsonResult(dt).ToJson();
            context.Response.Write(jsonStr);

        }

    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}