HEGII.ss.mes.check/wwwroot/main/Login/api/UpdateReworkProduce.ashx

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

using System.Web;
using System.Data;
using System.Web.SessionState;
using System.Web.Configuration;
using Newtonsoft.Json.Linq;
using Curtain.DataAccess;
using Curtain.Log;
using DK.XuWei.WebMes;

/// <summary>
/// 质量登记改判，再查询一遍，修改返工工序
/// </summary>
public class UpdateReworkProduce : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        using (IDataAccess conn = DataAccess.Create())
        {
            conn.BeginTransaction();

            //barcode
            string barcode = context.Request["barcode"].ToString(); 

            
            DataTable dt = conn.ExecuteDatatable(@"
                select gt.GOODSTYPECODE
                from TP_PM_GROUTINGDAILYDETAIL t 
                left join tp_mst_goods g on g.goodsid = t.goodsid
                left join tp_mst_goodstype gt on g.goodstypeid = gt.goodstypeid
                where t.BARCODE =  @barcode@ 
				",
                new CDAParameter("barcode", barcode)
            );
         
            context.Response.Write(new JsonResult(dt).ToJson());
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}