HEGII.ss.mes.check/wwwroot/main/WareHouse/api/setPackingMove.ashx

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

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

public class setPackingMove : IHttpHandler {

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

        using (IDataAccess conn = DataAccess.Create())
        {
            int result = conn.ExecuteNonQuery(@"
                BEGIN

                    -- 更新包材明细移库状态
                    UPDATE 
	                    TP_MST_PACKINGMOVEDETAIL D
                    SET 
	                    STATUS = @PACKINGMOVESTATUS@
                    WHERE
	                    EXISTS (SELECT 1 FROM TP_MST_PACKINGMOVE P WHERE D.PACKINGMOVEID = P.PACKINGMOVEID)
                        AND EXISTS (SELECT 1 FROM TP_MST_PACKING PG WHERE D.PACKINGID = PG.PACKINGID AND PG.MATNR IN ({PACKINGID}))
	                    AND D.PACKINGMOVEID IN ({PACKINGMOVEID});

                    -- 更新包材总单移库状态
				    UPDATE 
                        TP_MST_PACKINGMOVE PM
				    SET
					    PM.PACKINGMOVESTATUS = @PACKINGMOVESTATUS@
				    WHERE
	                    NOT EXISTS (SELECT 1 FROM TP_MST_PACKINGMOVEDETAIL PD WHERE PD.PACKINGMOVEID = PM.PACKINGMOVEID AND PD.STATUS <> @PACKINGMOVESTATUS@)
					    AND PM.PACKINGMOVEID IN ({PACKINGMOVEID});


                END;
				".Replace("{PACKINGMOVEID}",context.Request["id"])
                .Replace("{PACKINGID}",context.Request["id2"]),
                new CDAParameter("PACKINGMOVESTATUS",Convert.ToInt32(context.Request["s"]))
            );
            if (result > 0 || result == -1)
            {
                //移库成功，调用SAP接口回写数据-------------------------

                //占位

                //------------------------------------------------------

                context.Response.Write(new JsonResult() { success = true, message = "移库操作成功！" + result.ToString() }.ToJson());
            }
            else
            {
                context.Response.Write(new JsonResult() { success = false, message = "移库操作失败！" + result.ToString() }.ToJson());
            }
        }


    }

    public bool IsReusable {
        get {
            return false;
        }
    }

}