GetPackingDefect_WCF.ashx 1.0 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243
  1. <%@ WebHandler Language="C#" Class="GetDataDictionary_WCF" %>
  2. using System.Web;
  3. using System.Web.SessionState;
  4. using System.Web.Configuration;
  5. using Newtonsoft.Json.Linq;
  6. using Curtain.DataAccess;
  7. using System.Data;
  8. using DK.XuWei.WebMes;
  9. /// <summary>
  10. /// 从WCF接口获取 数据字典
  11. /// </summary>
  12. public class GetDataDictionary_WCF : IHttpHandler, IReadOnlySessionState
  13. {
  14. public void ProcessRequest(HttpContext context)
  15. {
  16. using (IDataAccess conn = DataAccess.Create())
  17. {
  18. DataTable dt = null;
  19. dt = conn.ExecuteDatatable(@"
  20. SELECT D.DICTIONARYVALUE,D.Remarks
  21. FROM TP_MST_DATADICTIONARY D
  22. WHERE VALUEFLAG = '1'
  23. AND D.DICTIONARYTYPE = @DICTIONARYTYPE@ ",
  24. new CDAParameter("DICTIONARYTYPE", "TPC019"));
  25. context.Response.Write(new JsonResult(dt).ToJson());
  26. }
  27. }
  28. public bool IsReusable
  29. {
  30. get
  31. {
  32. return false;
  33. }
  34. }
  35. }