Passing a JSON array to a WCF service 传递json数组到wcf service （自定义数据类型） - huangyi5209

While the following information is available on the Internet, I had to piece it together from various sources, so for my own documentation and hopefully to help someone else, here is a simple (I hope) example of passing a JSON array to a WCF service, all in one place. It can be easily generalized to passing any JSON-serialized object to WCF, but that is better documented than arrays.

Note: This sample uses jQuery and Douglas Crockford’s JSON2. It also uses some features of HTML 5, including placeholder text, autofocus fields and offline storage, but these aren’t essential for the solution.

First, let’s look at the HTML, because it’s probably the simplest part of the solution:

index.html

<!DOCTYPE html>

<html>

<head>

<title>Send Array to WCF Service</title>

</head>

<body>

<br />

<span>First Name: </span>

<br />

<span>Email: </span>

<br />

</form>

</div>

</p>

</body>

</html>

Pretty much a simple form with three fields and a button. Pay attention to the input elements name attributes – we will be using those in various places. Note that the form doesn’t have action or method attributes. We will assign an event handler to the button in a bit. There is also a p element with an id of app_status which will be used to display status messages.

With that out of the way, let’s look at the JavaScript:

main.js

var UserApp = {

docReady: function () {

UserApp.loadForm();

$("#save_button").bind("click", UserApp.sendFormData);

// Load form from saved data. Presumes that each input element's id is the same as its name.

loadForm: function () {

var formDataString = localStorage.getItem("user_data");

if (formDataString) {

var formData = JSON.parse(formDataString);

for (var i in formData) {

var fieldId = "#" + formData[i].name;

$(fieldId).val(formData[i].value);

}

// Save data from a form. Presumes there is only one form element on a page.

saveFormData: function () {

var formData = $("form").serializeArray();

localStorage.setItem("user_data", JSON.stringify(formData));

return { nvps: formData };

sendFormData: function () {

var formData = UserApp.saveFormData();

$.ajax({

type: "POST",

url: "MyProject/UserSvc.svc/SaveUserData",

data: JSON.stringify(formData),

contentType: "application/json; charset=utf-8",

dataType: "json",

success: function (data) {

if (data && data.d && data.d.Message) {

$("#app_status").html(data.d.Message);

}

error: function (req, status, error) {

if (req && req.responseText) {

var ex = JSON.parse(req.responseText);

if (ex && ex.Message) {

$("#app_status").html(ex.Message);

}

else {

$("#app_status").html("An error occurred saving the loan application data.");

}

});

}

};

$(document).ready(UserApp.docReady);

On the document becoming ready we execute the docReady function. It calls the loadForm function which loads the form values from local storage (if they exist), and also attaches the sendFormData function as the event handler for the “Save” button. We are storing the data in local storage using “user_data” as a key and a JSON-serialized array for the form elements (we will see how we create that array in the SaveFormData function). After parsing the JSON array we iterate over it to fill in the form input fields.

The saveFormData function is the opposite of the loadForm function in that it serializes the form’s input values using jQuery’s serializeArray function, which is one of the reasons I chose this approach. It does one other thing, which is to wrap the (unserialized) array in an object with a single member, nvps (which stands for “name-value pairs”), that holds the array, and returns this object. Again, we’ll see why later. To be clear, we are changing the bare array, which WCF will not accept as a method parameter:

[ { name: “last_name”, value: “Smith”}, {name: “first_name”, value: “John”}, {name: “email_address”, value: “john.smith@xyz.com”} ]

…to a wrapped object, which WCF will take:

{ nvps: [ { name: “last_name”, value: “Smith”}, {name: “first_name”, value: “John”}, {name: “email_address”, value: “john.smith@xyz.com”} ] }

Finally there is the sendFormData function, the event handler for the “Save” button. It consists of a single AJAX call to the WCF service, sending up the JSON-serialized wrapped object as the sole parameter for the SaveUserData method, and setting the status on the HTML page based on the success or failure of that call. Two things to note about that. First, on success the data coming down (a simple object with a single public property in it called Message) will be wrapped within a JavaScript object called data in a member called d. So any access to data returned on success is via data.d.xyz, in our case data.d.Message. This use of data.d as a (successful) response wrapper appears to be hold for all JSON-enabled WCF services.

Second, if there was a server-side exception it will come down to the error callback as the JSON-serialized responseText member of the (XMLHttpRequest) request parameter. After parsing the JSON you can get to various exception members, although in our case we are just interested in the exception’s Message member. When debugging both success and failures it is very helpful to use Fiddler or similar tools to see what is getting passed back and forth with each HTTP request and response.

Now it’s time to see the server-side implementation. Let’s look at the WCF interface definition first:

IUserSvc.cs

using System;

using System.Collections.Generic;

using System.Linq;

using System.Runtime.Serialization;

using System.ServiceModel;

using System.ServiceModel.Web;

using System.Text;

namespace MyProject

{

[ServiceContract]

public interface IUserSvc

{

[OperationContract]

[WebInvoke(Method = "POST", BodyStyle = WebMessageBodyStyle.WrappedRequest, ResponseFormat = WebMessageFormat.Json)]

ResultMessage SaveUserData(NameValuePairs nvps);

}

[DataContract]

public class NameValuePair

{

[DataMember]

public string name { get; set; }

[DataMember]

public string value { get; set; }

}

[DataContract]

public class ResultMessage

{

[DataMember]

public string Message { get; set; }

}

[CollectionDataContract(Namespace = "")]

public class NameValuePairs : List<NameValuePair>

{

}

The interface is pretty simple. There is a single SaveUserData method which takes in a collection of name-value pairs and returns a simple object that holds a result message. There are three things to notice here, and all are important. The first are the declarative attributes decorating the method. The following is where the real wiring for receiving and responding in JSON happens:

[WebInvoke(Method = "POST", BodyStyle = WebMessageBodyStyle.WrappedRequest, ResponseFormat = WebMessageFormat.Json)]

The Method can be either POST or GET (as long as your JavaScript code sends the request in the appropriate format). The BodyStyle and ResponseFormat parameters are required to get JSON in and out of the method. Any attempt to use a different BodyStyle (such as WebMessageBodyStyle.Bare) will result in a run-time exception because of settings in the web.config file, which we’ll see later.

Second, the parameter name to the method is nvps. Note this is the same name as the single member returned in the wrapper object on the array of form input field values in the JavaScript saveFormData function. This is some of the “magic” you just have to trust, but as far as I can tell, the parameter name to the WCF method must match the member name in the JavaScript wrapper object. In other words, it appears that when dealing with JSON, WCF is using name-matching between the JSON-serialized names and names in the managed code, probably via reflection.

Finally, while you don’t see it explicitly in the JavaScript code above, the jQuery serializeArray function returns an array of objects, one object for each input element in the form. Each object in the array contains two members - name, whose value matches the name attribute on the input element, and value, which contains the actual field’s value. Note that the NameValuePair class in the interface also uses name and value as member names. Again, these must match (as far as I can tell) the JavaScript member names to make all this work.

Here is the WCF implementation:

UserSvc.svc.cs

using System;

using System.Collections.Generic;

using System.Data;

using System.Data.SqlClient;

using System.Linq;

using System.Runtime.Serialization;

using System.ServiceModel;

using System.ServiceModel.Activation;

using System.ServiceModel.Web;

using System.Text;

namespace MyProject

{

[AspNetCompatibilityRequirements (RequirementsMode = AspNetCompatibilityRequirementsMode.Allowed)]

public class UserSvc : IUserSvc

{

public ResultMessage SaveUserData(NameValuePairs nvps)

{

var columns = new StringBuilder();

var parameters = new StringBuilder();

var rm = new ResultMessage() { Message = "User saved successfully." };

using (var conn = new SqlConnection(Properties.Settings.Default.AppDb))

using (var cmd = new SqlCommand() { CommandType = CommandType.Text, Connection = conn })

{

var paramCollection = cmd.Parameters;

var rows = 0;

try

{

if (nvps == null || nvps.Count == 0)

{

throw new ArgumentNullException("nvps");

}

foreach (NameValuePair nvp in nvps)

{

columns.Append(nvp.name).Append(",");

parameters.Append("@").Append(nvp.name).Append(",");

paramCollection.Add(new SqlParameter("@" + nvp.name, nvp.value));

}

// KLUDGE: Remove trailing commas.

columns.Remove(columns.Length - 1, 1);

parameters.Remove(parameters.Length - 1, 1);

cmd.CommandText = String.Format(Properties.Settings.Default.InsertSql, columns.ToString(), parameters.ToString());

conn.Open();

rows = cmd.ExecuteNonQuery();

rm.Message = String.Format(Properties.Settings.Default.SuccessMessage, rows, cmd.CommandText);

}

catch (Exception ex)

{

rm.Message = ex.Message;

}

return rm;

}

There isn’t really much going on here. As noted, the method parameter nvps must match the member within the JSON-serialized wrapper object around the array being sent to the method. As the code iterates through the array (collection), note also the use of name and value, again, matching the object member namess that are within the array. The code basically builds a dynamic, parameterized SQL INSERT statement (see the web.config) that assumes the underlying table column names are the same as the input elements name attributes. Cheesy, I know, but it shows we’re actually “doing something” on the server. I don’t claim this to be production-quality! The interesting thing about the code as written, however, is that by simply changing the form to add more input elements and altering the table to add more columns, additional data could be accommodated with no change in the JavaScript or managed code, which gives a bit of flexibility that I like.

Finally, we have the web.config file:

web.config

<?xml version="1.0"?>

</sectionGroup>

</configSections>

<system.web>

</system.web>

<system.serviceModel>

</security>

</binding>

</webHttpBinding>

</bindings>

</identity>

</endpoint>

</service>

</services>

</behavior>

</endpointBehaviors>

</behavior>

</serviceBehaviors>

</behaviors>

</system.serviceModel>

<system.webServer>

</system.webServer>

<MyProject.Properties.Settings>

<value>INSERT INTO Users ({0}) VALUES({1})</value>

</setting>

<value>server=.;initial catalog=ApplicationDB;integrated security=sspi;</value>

</setting>

<value>Inserted {0} rows using the following statement: {1}</value>

</setting>

</MyProject.Properties.Settings>

</applicationSettings>

</configuration>

I won’t go over all of this in detail, but simply call out the pieces that make the JSON work with WCF. You can also see the three properties being stored for access by the managed code at the end of the file. The important part is contained in the service element. Note first the binding attribute of the endpoint element is set to webHttpBinding. This is required for JSON to work. The endpoint also points via the behaviorConfiguration attribute to “JsonBehavior.” If you look at the “JsonBehavior” behavior element under endpointBehaviors, you will see an empty enableWebScript element. This is also required for JSON.

The serviceBehaviors element is basically set up to ease debugging. It enables GET requests (so you could do a URL-encoded request if you chose, even from a browser’s address bar) as well as turning on some debugging sugar. You won’t want that to go into production, however. The rest of the web.config is fairly self-evident. I’ve called out the things you need to pay attention to specifically for WCF services to interact with a JSON client, which could be JavaScript, or anything else that eats and excretes JSON (the list of which is fairly large).

Hopefully this post will help save someone some time by pulling all the required pieces into one place and calling out some of the more obscure aspects of JSON-to-WCF interaction. As always, I appreciate comments, corrections and questions.

huangyi5209

常用链接

留言簿

我参与的团队

文章分类

文章档案

搜索

最新评论

Sunday, October 10, 2010

Passing a JSON array to a WCF service