GetPreProductCheck.ashx 1.1 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. <%@ WebHandler Language="C#" Class="GetPreProductCheck" %>
  2. using System.Web;
  3. using System.Data;
  4. using System.Web.SessionState;
  5. using System.Web.Configuration;
  6. using Newtonsoft.Json.Linq;
  7. using Curtain.DataAccess;
  8. using Curtain.Log;
  9. using DK.XuWei.WebMes;
  10. /// <summary>
  11. /// 获取 预检数据
  12. /// xuwei 2020-06-11
  13. /// </summary>
  14. public class GetPreProductCheck : IHttpHandler, IReadOnlySessionState
  15. {
  16. public void ProcessRequest(HttpContext context)
  17. {
  18. using (IDataAccess conn = DataAccess.Create())
  19. {
  20. DataTable dt = conn.ExecuteDatatable(@"
  21. SELECT
  22. i.GOODSLEVELTYPEID,
  23. i.REWORKPROCEDUREID
  24. FROM
  25. TP_PM_INPRODUCTION i
  26. WHERE
  27. i.BARCODE = @BARCODE@
  28. AND i.MODELTYPE = -4
  29. ",
  30. new CDAParameter("BARCODE", context.Request["barCode"])
  31. );
  32. context.Response.Write(new JsonResult(dt).ToJson());
  33. }
  34. }
  35. public bool IsReusable
  36. {
  37. get
  38. {
  39. return false;
  40. }
  41. }
  42. }