HEGII.ss.mes.check/wwwroot/main/FqcProductCheck/api/GetItemsDataDetail_WCF.ashx

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

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

public class GetItemsDataDetail_WCF : IHttpHandler
{
    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";
        using (IDataAccess conn = DataAccess.Create())
        {
            string barcode = context.Request["barcode"].ToString();
            string type = context.Request["type"].ToString();

            //包装条码
            //if (barcode.Length > 11)
            //{
            //    DataTable procedurename1 = conn.ExecuteDatatable(@"
            //    SELECT BARCODE
            //      FROM TP_PM_GROUTINGDAILYDETAIL
            //     WHERE OUTLABELCODE = @OUTLABELCODE@",
            //    new CDAParameter("OUTLABELCODE", barcode)
            //    );
            //    barcode = procedurename1.Rows[0]["BARCODE"].ToString();
            //}
            if (barcode.Length ==8)
            {
                DataTable procedurename1 = conn.ExecuteDatatable(@"
                SELECT BARCODE
                  FROM TP_PM_GROUTINGDAILYDETAIL
                 WHERE SERVICECODE = @OUTLABELCODE@",
                new CDAParameter("OUTLABELCODE", barcode.Substring(barcode.IndexOf('-')+1))
                );
                barcode = procedurename1.Rows[0]["BARCODE"].ToString();
            }
            else if (barcode.Length == 28)
            {
                DataTable procedurename1 = conn.ExecuteDatatable(@"
                SELECT BARCODE
                  FROM TP_PM_GROUTINGDAILYDETAIL
                 WHERE OUTLABELCODE = @OUTLABELCODE@",
                new CDAParameter("OUTLABELCODE", barcode)
                );
                barcode = procedurename1.Rows[0]["BARCODE"].ToString();
            }
            DataTable procedurename = conn.ExecuteDatatable(@"
                    SELECT  
                        FD.ITEMSID,
                        FD.ITEMSDETAILID,
                        FD.INSPECTITEM,
                        FD.INSPECTVALUE,
                        FD.ISQUALIFIED,
                        FD.REMARKS
                    FROM TP_PM_FQCITEMSDATA FD
                    LEFT JOIN TP_MST_DATADICTIONARY D ON FD.INSPECTTYPE = D.DICTIONARYID
                    WHERE FD.VALUEFLAG = '1'
                    AND FD.BARCODE = @BARCODE@
                    AND D.DICTIONARYVALUE = @TYPE@ 
                    ORDER BY FD.CREATETIME,FD.ITEMSDETAILID",
            new CDAParameter("BARCODE", barcode),
            new CDAParameter("TYPE", type)
            );
            context.Response.Write(new JsonResult(procedurename).ToJson());

        }

    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}