ios开发中和web数据的交互的总结(三)

3，服务器端的编写

1）传统的写法：返回xml

 [WebMethod]
    public DataSet getCookBook(int storeID)
    {
        
        try
        {
            conn.Open();
            string selectnews = " select * from View_foodCooke where storeID='" + storeID + "'";
            SqlDataAdapter Adapter = new SqlDataAdapter(selectnews, conn);
            DataSet Ds = new DataSet();
            Adapter.Fill(Ds);
            conn.Close();
                  
            return Ds;
        }
        catch
        {
            return null;
        } 
        
    }

2，放回xml+json——————需要引用（using Newtonsoft.Json）

 public string getOnlineBookInfomation()
    {
        try
        {
            conn.Open();
            string selectnews = " select * from onlineBook";
            SqlDataAdapter Adapter = new SqlDataAdapter(selectnews, conn);
            DataSet ds = new DataSet();
            Adapter.Fill(ds);
            conn.Close();
             string str=null;
             if (ds != null && ds.Tables[0].Rows.Count > 0)
             {
                 List<Hashtable> testList = new List<Hashtable>();
                 for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                 {
                     Hashtable ht = new Hashtable();
                     DataRow row = ds.Tables[0].Rows[i] as DataRow;

                     
                    
                     ht["id"] = Convert.ToString(row["bookid"]).Trim();
                     ht["type"] = Convert.ToString(row["booktype"]).Trim();
                     ht["bookdata"] = Convert.ToString(row["bookdata"]).Trim();
                     ht["bookname"] = Convert.ToString(row["bookname"]).Trim();
                     ht["indexpic"] = "http://iphone.demo.whnuke.com/fileUploadpdf/indexpic/" + Convert.ToString(row["bookindexpic"]).Trim();
                     ht["pdf"] = "http://iphone.demo.whnuke.com/fileUploadpdf/" + Convert.ToString(row["pdffile"]).Trim();
                     ht["bookinfomation"] = Convert.ToString(row["bookinfomation"]).Trim();
                     testList.Add(ht);



                 }
                 string json = JavaScriptConvert.SerializeObject(testList);
                 str += json;
             }
             return str;
        }
        catch
        {
            return null;
        }
    }

返回结果的形式是：<result>json string</result>

3,返回纯json数据

添加一个aspx和aspx.cs文件

aspx文件只留下以下代码：

<%@ Page Language="C#" AutoEventWireup="true"  ValidateRequest="false" CodeFile="getjosndata.aspx.cs" Inherits="getjosndata" %>

aspx.cs里的方法

//获取www.test.com/getjosndata.aspx?id=[id] id的值

 int cangguanID = Convert.ToInt32(Request.QueryString["ID"]);

 protected void Eat_API_GetCanguanCaipu(int canguanID)
    {
        DataSet ds = new DataSet();
        ds = Eat_API_Getinfomation("Eat_API_GetCanguanCaipu", canguanID);
        string str = null;


        if (ds != null && ds.Tables[0].Rows.Count > 0)
        {
            List<Hashtable> testList = new List<Hashtable>();
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                Hashtable ht = new Hashtable();
                DataRow row = ds.Tables[0].Rows[i] as DataRow;
                ht["id"] = Convert.ToString(row["CaipuID"]).Trim();
                ht["cx"] = Convert.ToString(row["CaixiTypeID"]).Trim();
                ht["name"] = Convert.ToString(row["Mingcheng"]).Trim();
                if (Convert.ToString(row["ImageURL"]).Trim() != "")
                {
                    ht["imgurl"] = "http://caipu.demo.alldnnskins.cn/Portals/0/caipu/" + Convert.ToString(row["ImageURL"]).Trim();
                }
                else
                {
                    ht["imgurl"] = "";
                }
                //ht["Summary"] = Convert.ToString(row["Summary"]).Trim();
                ht["Price"] = Convert.ToString(row["Price"]).Trim();

                //ht["FabuRen"] = Convert.ToString(row["FabuRen"]).Trim();
               // ht["CreatedOn"] = Convert.ToString(row["CreatedOn"]).Trim();
              //  ht["ModifiedOn"] = Convert.ToString(row["ModifiedOn"]).Trim();
                ht["IsApproved"] = Convert.ToString(row["IsApproved"]).Trim();
               // ht["IsHidden"] = Convert.ToString(row["IsHidden"]).Trim();
              //  ht["IsFeatured"] = Convert.ToString(row["IsFeatured"]).Trim();
                testList.Add(ht);
            }
            string json = JavaScriptConvert.SerializeObject(testList);
            str += json;
        }
        Response.Write(str);
    }

得到的结果是纯json结果