HEGII.ss.mes.check/wwwroot/api/v001/TestForm/getTestFormList.ashx

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

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

/// <summary>
/// 获取实验单列表
/// xuwei add 2021-08-31
/// </summary>
public class getTestFormList : IHttpHandler
{

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

        using (IDataAccess conn = DataAccess.Create())
        {
            //条件限定：未完结的实验单，当前用户可操作的实验单
            DataTable dt = conn.ExecuteDatatable(@"
            SELECT
                T.ID,
	            CONCAT( T.ID, T.NAME ) AS NAME 
            FROM
	            TP_PM_TESTFORM2 T
	            LEFT JOIN TP_PM_TESTFORM2_USER TU ON T.ID = TU.TESTFORMGUID 
            WHERE
	            T.VALUEFLAG = 1 
	            AND TU.VALUEFLAG = 1
	            AND T.STATE = 0 
	            AND INSTR(','||TU.USERCODELIST||',',','||@USERCODE@||',') >0
				",
                new CDAParameter("USERCODE", context.Request["USERCODE"] + "")
            );
            if (dt != null && dt.Rows.Count > 0)
            {
                context.Response.Write(new JsonResult(dt).ToJson());
            }
            else {
                //context.Response.Write(new JsonResult(JsonStatus.error).ToJson());
                context.Response.Write(new JsonResult() { success = false,message = "无相关测试单",total = 0,rows = "" }.ToJson()) ;
            }

        }

    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}