학원관리 DB우편번호 불러오기 예제 소스

728x90

학원관리 DB우편번호 불러오기 예제 소스

 

location, zipname을 인자값으로 하는 우편번호 불러오기 예제

 

public static List<ZipCodeInfo> GetZipCodeList(string location, string zipname)
        {
            List<ZipCodeInfo> results = new List<ZipCodeInfo>();
            SqlHelper sql = new SqlHelper(_dbIP, _dbPort, _dbID, _dbPW, _dbName);
            try
            {
                if (!sql.Connect()) return results;

                string strProc = "SP_Zip_Select";
                System.Diagnostics.Debug.WriteLine(string.Format("{0}", strProc));

                List<SqlParameter> parameters = new List<SqlParameter>();
                parameters.Add(new SqlParameter("@Location", location));
                parameters.Add(new SqlParameter("@Address", "%" + zipname + "%"));

                DataTable tbl = sql.ExecuteProcedure(strProc, parameters);
                if (tbl != null)
                {
                    foreach (DataRow current in tbl.Rows)
                    {
                        string text = Convert.ToString(current["ZipCode"]);
                        string left = "";
                        string str2 = "";
                        if (text.Length == 6)
                        {
                            text = text.Substring(0, 3) + "-" + text.Substring(3);
                        }
                        left = string.Format("{0} {1} {2} {3} {4} {5}", current["SiDo"], current["Gu"], current["Dong"], current["Li"], current["DoSeo"], current["San"]);
                        if (current["Apt"].ToString().Trim().Length > 0)
                        {
                            left = string.Format("{0} {1}", left, current["Apt"]);
                            if (current["AptSta"].ToString().Trim().Length > 0)
                            {
                                str2 += Convert.ToString(current["AptSta"]);
                            }
                            if ((current["AptEnd"].ToString().Trim().Length > 0) & (str2.Length > 0))
                            {
                                str2 += "-";
                            }
                            if (current["AptEnd"].ToString().Length > 0)
                            {
                                str2 += Convert.ToString(current["AptEnd"]);
                            }
                        }
                        else
                        {
                            if (current["BunjiMiSta"].ToString().Trim().Length == 0)
                            {
                                str2 = Convert.ToString(current["BunjiMaSta"]);
                            }
                            else
                            {
                                str2 = string.Format("{0}-{1}", current["BunjiMaSta"], current["BunjiMiSta"]);
                            }
                            if ((current["BunjiMaEnd"].ToString().Trim().Length > 0) & (str2.Length > 0))
                            {
                                str2 += "~";
                            }
                            if (current["BunjiMiEnd"].ToString().Trim().Length == 0)
                            {
                                str2 += Convert.ToString(current["BunjiMaEnd"]);
                            }
                            else
                            {
                                str2 += string.Format("{0}-{1}", current["BunjiMaEnd"], current["BunjiMiEnd"]);
                            }
                        }
                        left = left.Replace("  ", " ").Trim();

                        results.Add(new ZipCodeInfo()
                        {
                            ZipCode = text,
                            Address = left,
                            Jibun = str2
                        }
                        );
                    }
                }
            }
            catch (Exception ee)
            {
                TraceManager.AddLog(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
                System.Diagnostics.Debug.WriteLine(string.Format("{0}r\n{1}", ee.StackTrace, ee.Message));
            }
            finally
            {
                sql.DisConnect();
            }

            return results;
        }