혀니의 기술과 삶

using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Configuration;
using System.Web.Configuration;
using System.Collections.Generic;
using System.Runtime.Serialization;
using System.ServiceModel;
using System.ServiceModel.Activation;
using System.ServiceModel.Web;
using System.Text;
using System.Data.SqlClient;
using System.Data;
using System.Runtime.Serialization;
using System.Runtime.Serialization.Json;
using Pesta.Utilities.Helpers;

//네임스페이스는 SandwichServices 입니다.
namespace SandwichServices
{

    [ServiceContract(Namespace = "SandwichServices")]
    [AspNetCompatibilityRequirements(RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]
    public class CostService : BaseCode
    {
        [OperationContract]
        public string CostOfSandwiches()
        {
            //BaseCode에서 연결 문자열을 가져옵니다.
            //코드 내용은아래에 있습니다.
            BaseCode bc = new BaseCode();
            string strConnection = bc.strConnection;

            //데이터베이스에 연결하고 오픈합니다.
            SqlConnection con = new SqlConnection();
            con.ConnectionString = strConnection;
            con.Open();

            //데이터를 가져오기 위한 쿼리 문자열을 생성합니다.
            //운영할 때 편이성을 위해 이렇게 코드에 쿼리를 넣는 것 보다는 SP로 하는게 더 낫습니다.
            string Query = string.Empty;
            Query = "select * from leeho_test";

            SqlCommand cmd = new SqlCommand(Query, con);
            SqlDataAdapter adp = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            adp.Fill(ds);

            //데이터 셋을 JSONHelper 객체로 보내 JSON 문자열을 생성합니다.
            Pesta.Utilities.Helpers.JSONHelper jh = new Pesta.Utilities.Helpers.JSONHelper();
            string ss = jh.ToJSON(ds);

            return ss;
           
        }
    }
}

//아래는 JSON 헬퍼 입니다.
//헬퍼 클래스는 2개의 메서드를 가지는데 하나는 데이터 셋을 인자로 받고, 다른 하나는 데이터 테이블을 직접 전달할 수
//있게 되어 있습니다.
namespace Pesta.Utilities.Helpers
{

    public class JSONHelper
    {
        #region Made from datatable of dataset to JSON string
        /// <summary>
        /// WriteDate : 2010-06-14
        /// Author : Jonghyun, Park
        /// Content: Made from DataTable of DataSet to JSON
        /// </summary>
        /// <param name="obj">DataSet</param>
        /// <returns>jsonBuilder</returns>
        public string ToJSON(DataTable dt)
        {
            return MakeData(dt);
        }
        #endregion

        #region Made from DataSet of dataset to JSON
        /// <summary>
        /// WriteDate : 2010-06-14
        /// Author : Jonghyun, Park
        /// Content: Made from DataSet of dataset to JSON
        /// </summary>
        /// <param name="obj">DataSet</param>
        /// <returns>jsonBuilder</returns>
        public string ToJSON(DataSet obj)
        {
            DataTable dt = obj.Tables[0];
            return MakeData(dt);
        }
        #endregion

        #region Make Data
        /// <summary>
        /// WriteDate : 2010-06-14
        /// Author : Jonghyun, Park
        /// Content: Make Data
        /// </summary>
        /// <param name="dt">DataTable</param>
        /// <returns></returns>
        private static string MakeData(DataTable dt)
        {
            StringBuilder jsonBuilder = new StringBuilder();
            jsonBuilder.Append("[");
           
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                jsonBuilder.Append("{");
                for (int j = 0; j < dt.Columns.Count; j++)
                {
                    jsonBuilder.Append("\""+ dt.Columns[j].Caption +"\":\"");
                    jsonBuilder.Append(dt.Rows[i][j].ToString());
                    jsonBuilder.Append("\",");
                }
                jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
                jsonBuilder.Append("},");
            }
            jsonBuilder.Remove(jsonBuilder.Length - 1, 1);

            jsonBuilder.Append("]");
            return jsonBuilder.ToString();
        }
        #endregion
    }
}

 using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Configuration;

namespace SandwichServices
{
    public class BaseCode
    {
        public string DBKEY = string.Empty;
        public string GETKey = tring.Empty;
        private string dbkey {
            get {
                return DBKEY;
            }
            set {
                dbkey = DBKEY;
            }
        }
        public string strConnection = ConfigurationManager.ConnectionStrings["ApplicationServices"].ToString();
    }
}