HEGII.ss.mes.check/wwwroot/main/PreProductCheck/api/getSopBook.ashx

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

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 getSopBook : IHttpHandler
{
    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";
        using (IDataAccess conn = DataAccess.Create())
        {
            string barcode = context.Request["barcode"].ToString();
            if(barcode =="123")
            {
                DataTable dt = conn.ExecuteDatatable(@"
                    SELECT
	                    S.TITLE,
	                    S.IMGURL,
	                    S.REMARKS,
	                    'http://172.18.32.32:9300' || S.URL AS URL 
                    FROM
	                    TP_PC_SOPBOOK S
                    WHERE s.TYPE = 1
				    ");
                context.Response.Write(new JsonResult(dt).ToJson());
            }
            else
            {
                DataTable dt = conn.ExecuteDatatable(@"
                    SELECT
	                    S.TITLE,
	                    S.IMGURL,
	                    S.REMARKS,
	                    'http://172.18.32.32:9300' || S.URL AS URL 
                    FROM
	                    TP_PM_GROUTINGDAILYDETAIL gdd
                        INNER JOIN TP_MST_GOODS g on g.GOODSID = gdd.GOODSID
	                    INNER JOIN TP_MST_GOODSTYPE gt on gt.GOODSTYPEID = g.GOODSTYPEID 
	                    INNER JOIN TP_PC_SOPBOOK s ON 
                        --s.GOODSID = gdd.GOODSID 
                        (s.GOODSTYPE = 1 and gt.GOODSTYPECODE IN ('001001003','001001004')) OR (s.GOODSTYPE = 2 and gt.GOODSTYPECODE = '001001001')
                    WHERE
	                    gdd.barcode = @barcode@ 
	                    AND s.TYPE = 1
				    ",
                    new CDAParameter("barcode",barcode)
                 );
                context.Response.Write(new JsonResult(dt).ToJson());
            }


        }

    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}