首页 文章

c#和Asp.net web api中的URL编码

提问于
浏览
4

我有 ASP.NET web api 接收Web请求并返回 Json 数据 .
浏览到此网址:
http://1.2.3.4/api1/api/values/mypartname 将返回以下json字符串:

{
    \"PartName\": \"mypartname\",
    \"PartDes\": \"53.6X53.6APA/ALIM1NOTPAK\",
    \"PartLocation\": \"A36\"
}

但是当发送包含空格或引号的零件名称时: http://1.2.3.4/api1/api/values/my part na"me 我收到 404 - File or directory not found. 错误 .
我正在使用 json 消耗 json ,如下所示:

static void Main(string[] args)
    {
        try
        {
            string partName = "TAPE 56 3M 3/4\"";
            WebRequest wr = WebRequest.Create("http://1.2.3.4/api1/api/values/" +
                HttpUtility.UrlEncode(partName));
            wr.Credentials = CredentialCache.DefaultCredentials;
            HttpWebResponse hwr = (HttpWebResponse)wr.GetResponse();
            Stream dataStream = hwr.GetResponseStream();
            StreamReader reader = new StreamReader(dataStream);
            string json = reader.ReadToEnd();
            //some json parsing function
            des(json);
            reader.Close();
            dataStream.Close();
            hwr.Close();

        }
        catch (Exception ex)
        {
            Console.WriteLine(ex.Message);
        }
        finally
        {
            Console.ReadKey();
        }
    }

此行抛出异常: HttpWebResponse hwr = (HttpWebResponse)wr.GetResponse(); ,异常消息为: The remote server returned an error: (404) Not Found.

我在 mypartname 做错了吗?我还尝试根据这个来手动替换有问题的字符:HTML URL Encoding Reference并使用此函数: Uri.EscapeDataString(partName) 但没有运气 .

EDIT
这是routeConfig定义:

routes.IgnoreRoute("{resource}.axd/{*pathInfo}");

        routes.MapRoute(
            name: "Default",
            url: "{controller}/{action}/{id}",
            defaults: new { controller = "Home", action = "Index", id = UrlParameter.Optional }
        );

和api GET方法:

// GET api/values/5
    public string Get(string id)
    {

        List<dummy> dummies = new List<dummy>();
        string con = "user id=sa;" +
                     "password=1234" +
                     "server=someServer\\someInstance;" +
                     "database=game; " +
                     "connection timeout=30";

        //SqlConnection sqlConn = new SqlConnection(con);
        using (SqlConnection sqlconn = new SqlConnection(con))
        {
            sqlconn.Open();
            StringBuilder sb = new StringBuilder();
            sb.Append("SELECT PART.PARTNAME,PART.PARTDES, PARTPARAMA.LOCATION ");
            sb.Append("FROM PART LEFT JOIN PARTPARAMA ");
            sb.Append("ON PART.PART = PARTPARAMA.PARTPARAM ");
            sb.Append("WHERE PART.PARTNAME = @part");


            using (SqlCommand cmd = new SqlCommand(sb.ToString(), sqlconn))
            {
                cmd.Parameters.AddWithValue("part", id);
                SqlDataReader sdr = cmd.ExecuteReader();
                while (sdr.Read())
                {

                    dummies.Add(new dummy
                    {
                        PartName = sdr.IsDBNull(0) ? "Unknown" : sdr.GetString(0),
                        PartDes = sdr.IsDBNull(1) ? "Unknown" : sdr.GetString(1),
                        PartLocation = sdr.IsDBNull(2) ? "Unknown" : sdr.GetString(2)
                    });
                }
            }
        }

        if (dummies.Count() > 0)
        {
            string json = JsonConvert.SerializeObject(dummies[0]);
            return json;
        }
        else
        {
            string json = JsonConvert.SerializeObject(null);
            return json;
        }

1 回答

  • 3

    EDIT 2015年4月10日:

    我在这里留下这个答案给那些在搜索中找到它的人,不过凯文在下面说的是Scott Hanselman says here

    [UrlPathEncode]不会按照您的想法执行此操作...此方法非常具体,命名不佳,现在已完全过时 .


    我认为你的问题更多地与零件名称中的正斜杠有关 . 您可以使用处理空格和引号

    HttpUtility.UrlPathEncode(partName)

    而不是 HttpUtility.UrlEncode(partName) .

    处理正斜杠更成问题 . 有关详细信息,请参阅this post .

相关问题