Excel-DNA で XLL をつくる（その12）

using System;
using System.Collections.Generic;
using System.Text;
using ExcelDna.Integration;
using System.Net;
using Codeplex.Data;
using System.Windows.Forms;


public static class ZipDecode
{
    const string ZIP_URL = 
             @"http://groovetechnology.co.jp/ZipSearchService/v1/zipsearch?";

    [ExcelFunctionAttribute(Description = "郵便番号から住所を取得します", 
                                   Name = "ZipDecode")]
    public static string Decode(string ZipCode)
    {
        try
        {
            string query_url = @ZIP_URL + @"zipcode=" + @ZipCode;
            List<dynamic> items = new List<dynamic>();

            var reply = new WebClient().DownloadData(query_url);
            var json = DynamicJson.Parse(Encoding.UTF8.GetString(reply));
            foreach (var item in json["zipcode"])
            {
                items.Add(item);
            }
            if (items.Count == 1)
            {
                return items[0].Value["prefecture"] + 
                       items[0].Value["city"] + 
                       items[0].Value["town"];
            }
            else
            {
                ShowList(items);
            }

            return "複数あります";
        }
        catch (Exception)
        {
            return "err";
        }
    }

    [ExcelFunctionAttribute(Description = "住所から郵便番号を取得します", 
                                   Name = "ZipEncode")]
    public static string Encode(string Address)
    {
        try
        {
            string query_url = @ZIP_URL + @"word=" + @Address;
            List<dynamic> items = new List<dynamic>();

            var reply = new WebClient().DownloadData(query_url);
            var json = DynamicJson.Parse(Encoding.UTF8.GetString(reply));
            foreach (var item in json["zipcode"])
            {
                items.Add(item);
            }
            if (items.Count == 1)
            {
                return items[0].Value["zipcode"];
            }
            else
            {
                ShowList(items);
            }
            return "複数あります";
        }
        catch (Exception)
        {
            return "err";
        }
    }

    private static void ShowList(List<dynamic> items)
    {
        StringBuilder strbld = new StringBuilder();
        foreach (var item in items)
        {
            strbld.Append(item.Value["zipcode"]);
            strbld.Append(":");
            strbld.Append(item.Value["prefecture"]);
            strbld.Append(":");
            strbld.Append(item.Value["city"]);
            strbld.Append(":");
            strbld.AppendLine(item.Value["town"]);
        }
        MessageBox.Show(strbld.ToString(), "〒");
    }
}