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

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

public class getPackingMove : IHttpHandler {

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

        using (IDataAccess conn = DataAccess.Create())
        {
            DataTable dt = conn.ExecuteDatatable(@"
				SELECT DISTINCT
                    m.ORDERNO AS 顺序,
					m.PACKINGMOVEID AS 单号,
                    m.PACKINGMOVENAME AS 名称,
                    m.PACKINGMOVESTATUS AS 状态,
                    f.PACKINGFORMNAME AS 包装单名称,
                    (SELECT USERNAME FROM TP_MST_USER WHERE USERID = m.UPDATEUSERID) AS 创建人,
                    m.CREATETIME AS 时间
				FROM
					TP_MST_PACKINGMOVE m
                    LEFT JOIN TP_MST_PACKINGFORM f ON f.PACKINGFORMID = m.PACKINGFORMID
                    LEFT JOIN TP_MST_PACKINGMOVEDETAIL pd ON m.PACKINGMOVEID = pd.PACKINGMOVEID
				WHERE
					pd.STATUS = @PACKINGMOVESTATUS@
                ORDER BY
                    m.ORDERNO
				",
                new CDAParameter("PACKINGMOVESTATUS",Convert.ToInt32(context.Request["s"]))
            );
            context.Response.Write(new JsonResult(dt).ToJson());
        }


    }

    public bool IsReusable {
        get {
            return false;
        }
    }

}