HEGII.ss.mes.dashboard/wwwroot/main/Procedure/test11/warehouse.ashx

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

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

public class warehouse : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";

        //取产品库存列表
        if(context.Request["m"]=="isfull" && context.Request["isfull"] is object)
        {
            string jsonStr = QianRunApi.GetGoodsCode("","",context.Request["isfull"]);
            jsonStr = jsonStr.Replace("\"GoodsType\"", "\"产品型号\"");
            jsonStr = jsonStr.Replace("\"GoodsSeries\"", "\"产品类型\"");
            jsonStr = jsonStr.Replace("\"GoodsCount\"", "\"产品数量\"");
            context.Response.Write(jsonStr);
        }

        //取产品库位列表
        if(context.Request["m"]=="all")
        {
            int isFull = context.Request["allFull"] is object ? Convert.ToInt32(context.Request["allFull"].ToString()) : 0;
            string jsonStr = QianRunApi.GetStorageStatus(isFull);
            context.Response.Write(jsonStr);
        }

        //获取正在出库的产品
        if(context.Request["m"] == "outing")
        {
            using (IDataAccess conn = DataAccess.Create())
            {
                DataTable dt = conn.ExecuteDatatable(@"
                    SELECT
	                    G.GOODSCODE,
	                    B.MATNR,
                        F.STATUS
                    FROM
	                    TP_MST_PACKINGFORM F
	                    LEFT JOIN TP_MST_PACKINGBOM B ON B.PACKINGBOMID = F.PACKINGBOMID
	                    LEFT JOIN TP_MST_GOODS G ON G.GOODSID = B.GOODSID
                    WHERE
	                    STATUS = '1'
                        OR STATUS = '0'
                    ORDER BY
                        STATUS ASC
				");
                context.Response.Write(new JsonResult(dt).ToJson());
            }
        }

    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}