SANHOPE.mes.check/wwwroot/api/v001/TestForm/getTestFormDetail.ashx

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

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

/// <summary>
/// 获取实验单信息
/// xuwei add 2021-08-31
/// </summary>
public class getTestFormDetail : IHttpHandler
{

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

        using (IDataAccess conn = DataAccess.Create())
        {
            Dictionary<string, object> dd = new Dictionary<string, object>();
            DataTable dt = conn.ExecuteDatatable(@"
                SELECT 
                    m.GUID,
                    m.ID,
                    m.NAME,
                    m.PERSON,
                    m.OBJECTIVES,
                    m.METHOD,
                    m.BACKGROUND,
                    m.RESULT,
                    m.STATE
                FROM
                    TP_PM_TESTFORM2 m
                WHERE 
                    m.VALUEFLAG = '1'
                    AND m.STATE = 0
                    AND m.ID = @ID@

				",
                new CDAParameter("ID", context.Request["ID"] + "")
            );
            if (dt != null && dt.Rows.Count > 0)
            {
                foreach (DataColumn col in dt.Columns)
                {
                    dd.Add(col.ColumnName, dt.Rows[0][col.ColumnName]);
                }
                DataTable dt1 = conn.ExecuteDatatable(@"
                    SELECT DISTINCT
                        TG.BARCODE,
                        G.GOODSCODE,
                        GT.GOODSTYPENAME
                    FROM
                        TP_PM_TESTFORM2_GOODS TG
                        LEFT JOIN  
                        TP_PM_GROUTINGDAILYDETAIL GDD
                        ON TG.BARCODE = GDD.BARCODE
                        LEFT JOIN  
                        TP_MST_GOODS G
                        ON GDD.GOODSID = G.GOODSID
                        LEFT JOIN  
                        TP_MST_GOODSTYPE GT
                        ON G.GOODSTYPEID = GT.GOODSTYPEID
                    WHERE 
                        TG.TESTFORMGUID = @ID@
                        AND TG.VALUEFLAG = 1

				    ",
                    new CDAParameter("ID", context.Request["ID"] + "")
                );
                dd.Add("data", dt1);
                context.Response.Write(new JsonResult(dd).ToJson());
            }
            else {
                context.Response.Write(new JsonResult() { success = false,message = "无明细数据",total = 0,rows = "" }.ToJson()) ;
            }
        }

    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}