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

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

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

/// <summary>
/// 添加产品到实验单
/// xuwei add 2021-08-31
/// </summary>
public class setTestFormGoods : IHttpHandler
{

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

        using (IDataAccess conn = DataAccess.Create())
        {
            //实验单ID
            string testformid = context.Request["TESTFORMID"];
            //产品条码
            string barcode = context.Request["BARCODE"];
            //用户ID
            string usercode = context.Request["USERCODE"];
            //操作方式 add 添加 delete 删除
            string mode = context.Request["MODE"] is object ? context.Request["MODE"].ToString() : "";
            if (mode == "add")
            {
                //添加产品处理
                object result0 = conn.ExecuteScalar(@"
                    SELECT 1 FROM TP_PM_TESTFORM2_GOODS WHERE TESTFORMGUID = @TESTFORMID@ AND BARCODE =@BARCODE@ AND VALUEFLAG = 1
                    ",
                    new CDAParameter("BARCODE", barcode),
                    new CDAParameter("TESTFORMID", testformid)
                );
                if (result0+"" == "1")
                {
                    context.Response.Write(new JsonResult() { success = false, message = "条码重复", total = 0, rows = "" }.ToJson());
                }
                else
                {

                    //添加产品处理
                    int result = conn.ExecuteNonQuery(@"
                    INSERT INTO TP_PM_TESTFORM2_GOODS(TESTFORMGUID,BARCODE,VALUEFLAG,CREATEUSERID,UPDATEUSERID,ACCOUNTID)
                    VALUES(@TESTFORMID@, @BARCODE@, 1, (SELECT USERID FROM TP_MST_USER WHERE USERCODE = @USERCODE@), (SELECT USERID FROM TP_MST_USER WHERE USERCODE = @USERCODE@), 1) 
                    ",
                        new CDAParameter("BARCODE", barcode),
                        new CDAParameter("TESTFORMID", testformid),
                        new CDAParameter("USERCODE", usercode)
                    );
                    if (result > 0)
                    {
                        context.Response.Write(new JsonResult() { success = true, message = "保存成功", total = result, rows = "" }.ToJson());
                    }
                    else
                    {
                        context.Response.Write(new JsonResult() { success = false, message = "保存失败", total = 0, rows = "" }.ToJson());
                    }
                }

            }
            if (mode == "delete")
            {
                //删除产品处理，valueflag置为0，updateuserid更新为当前用户
                int result = conn.ExecuteNonQuery(@"
                            UPDATE TP_PM_TESTFORM2_GOODS 
                            SET
                                VALUEFLAG = 0,
                                UPDATEUSERID = (SELECT USERID FROM TP_MST_USER WHERE USERCODE = @USERCODE@),
                                UPDATETIME = SYSDATE
                            WHERE
                                VALUEFLAG = 1
                                AND TESTFORMGUID = @TESTFORMID@
                                AND BARCODE = @BARCODE@
                            ",
                    new CDAParameter("BARCODE", barcode),
                    new CDAParameter("TESTFORMID", testformid),
                    new CDAParameter("USERCODE", usercode)
                );
                if (result > 0)
                {
                    context.Response.Write(new JsonResult() { success = true, message = "删除成功", total = result, rows = "" }.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;
        }
    }

}