GetGoodsRepair.ashx 1.2 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546
  1. <%@ WebHandler Language="C#" Class="GetGoodsRepair" %>
  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 2022-04-18
  13. /// </summary>
  14. public class GetGoodsRepair : IHttpHandler, IRequiresSessionState
  15. {
  16. public void ProcessRequest(HttpContext context)
  17. {
  18. using (IDataAccess conn = DataAccess.Create())
  19. {
  20. DataTable dt = conn.ExecuteDatatable(@"
  21. SELECT
  22. BARCODE,
  23. REPAIRPATH
  24. FROM
  25. TP_PM_GOODSREPAIR
  26. WHERE
  27. VALUEFLAG = '1'
  28. AND BARCODE = @BARCODE@
  29. ",
  30. new CDAParameter("BARCODE", context.Request["barcode"] is object ? context.Request["barcode"].ToString() : "0")
  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. }