IMEX.mes.api/wwwroot/api/test/update/update.ashx

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

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

public class update : IHttpHandler, IReadOnlySessionState
{
    public void ProcessRequest(HttpContext context)
    {
        context.Response.ContentType = "text/plain";

        if (context.Request["m"] is object)
        {
            using (IDataAccess conn = DataAccess.Create())
            {
                switch (context.Request["m"].ToString())
                {
                    case "updateProcedureId":
                        {
                            //更新工序ID
                            int result = conn.ExecuteNonQuery(@"
				                UPDATE TP_PM_INPRODUCTION 
				                SET
					                FLOWPROCEDUREID = @FLOWPROCEDUREID@,
					                PROCEDUREID = @PROCEDUREID@
				                WHERE 
					                BARCODE = @BARCODE@
				                ",
                                new CDAParameter("BARCODE", context.Request["BARCODE"].ToString()),
                                new CDAParameter("FLOWPROCEDUREID", context.Request["PROCEDUREID"].ToString()),
                                new CDAParameter("PROCEDUREID", context.Request["PROCEDUREID"].ToString())
                            );

                            context.Response.Write(new JsonResult( JsonStatus.success).ToJson());
                            break;
                        }
                    case "updateProcedureIds":
                        {
                            //更新工序ID
                            int result = conn.ExecuteNonQuery(@"
				                UPDATE TP_PM_INPRODUCTION 
				                SET
					                FLOWPROCEDUREID = @FLOWPROCEDUREID@,
					                PROCEDUREID = @PROCEDUREID@
				                WHERE 
					                BARCODE IN
                                        (
                                        '60000269701',
                                        '60000269702',
                                        '60000269703',
                                        '60000269704',
                                        '60000269705'
                                        )
				                ",
                                new CDAParameter("FLOWPROCEDUREID", context.Request["PROCEDUREID"].ToString()),
                                new CDAParameter("PROCEDUREID", context.Request["PROCEDUREID"].ToString())
                            );

                            context.Response.Write(new JsonResult( JsonStatus.success).ToJson());
                            break;
                        }
                    default:
                        {
                            context.Response.Write(new JsonResult( JsonStatus.error).ToJson());
                            break;
                        }
                }
            }
        }
        else
        {
            context.Response.Write(new JsonResult(JsonStatus.loginError).ToJson());
        }
    }

    public bool IsReusable
    {
        get
        {
            return false;
        }
    }

}