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

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

public class getPackingMoveDetail : IHttpHandler {

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

        using (IDataAccess conn = DataAccess.Create())
        {
            DataTable dt = conn.ExecuteDatatable(@"
                SELECT
	                p.MATNR AS 物料,
	                p.PACKINGNAME AS 名称,
	                SUM(d.PACKINGNUM) AS 数量 
                FROM
	                TP_MST_PACKINGMOVEDETAIL d
	                LEFT JOIN TP_MST_PACKING p ON p.PACKINGID = d.PACKINGID
                WHERE
                    d.PACKINGMOVEID IN ({ID})
                    AND d.STATUS = @STATUS@
                GROUP BY 
	                p.MATNR,
                    p.PACKINGNAME
				".Replace("{ID}", context.Request["id"].ToString()),
                new CDAParameter("STATUS",context.Request["s"])
            );
            context.Response.Write(new JsonResult(dt).ToJson());
        }


    }

    public bool IsReusable {
        get {
            return false;
        }
    }

}