DIV CSS 佈局教程網

如何使用JSON在前后台進行數據傳輸的實例
編輯:關於JavaScript     

上一篇寫到用 JavaScript 生成多組文本,讓數據輸入不受顯示限制;這裡接著說明如何把這些輸入以 JSON 寫入資料庫。

前端生成數據並序列化

function generateDtb() {

var txtName = document.getElementById("txtName").value;

var dtb = new Array();

for (var i = 0; i < firstGroup.length; i++) {

var row = new Object();

row.Name = txtName;

row.fullMoney = firstGroup[i].value;

row.discount = secondGroup[i].value;

dtb.push(row);

}

return dtb;

}

把陣列轉換成 JSON 串傳入後台:

$(function () {

$("#lbtnOK").click(function () {

var url = "DiscountManger.aspx?ajax=1";

var dtb = generateDtb();

if (dtb == null) { }

else {

var postdata = JSON.stringify(dtb); //序列化對象

$.post(url, { json: postdata }, function (json) {

if (json) { jBox.tip("添加成功!", "提示"); location.reload(); }

else { jBox.tip("添加失敗!", "提示"); location.reload(); }

}, "json") //異步請求

}

});

});

後台判斷並處理異步請求

if (!IsPostBack) {

if (Request.QueryString["ajax"] == "1") { ProcessRequest(); }

}

private void ProcessRequest() {

ArrayList arrDiscount = new ArrayList();

Response.ContentType = "text/html";

string json = Request.Form["json"];

if (json == null) { return; }

else {

DataTable newdtb = Json2Dtb(json);

for (int i = 0; i < newdtb.Rows.Count; i++) {

Entity.StrategyDiscount enStrategyDiscount = new Entity.StrategyDiscount();

enStrategyDiscount.name = newdtb.Rows[i]["Name"].ToString();

enStrategyDiscount.shopId = long.Parse(LoginInfo.ShopID);

enStrategyDiscount.fullMoney = Convert.ToDecimal(newdtb.Rows[i]["fullMoney"].ToString());

enStrategyDiscount.discount = Convert.ToDecimal(newdtb.Rows[i]["discount"].ToString());

arrDiscount.Add(enStrategyDiscount);

}

IStrategyBLL strategy = new StrategyBLL();

if (strategy.AddStrategyDiscount(arrDiscount)) { Response.Write("true"); Response.End(); }

else { Response.Write("false"); Response.End(); }

}

}

JSON 轉 DataTable

private DataTable Json2Dtb(string json) {

JavaScriptSerializer jss = new JavaScriptSerializer();

ArrayList dic = jss.Deserialize<ArrayList>(json);

DataTable dtb = new DataTable();

if (dic.Count > 0) {

foreach (Dictionary<string, object> drow in dic) {

if (dtb.Columns.Count == 0) {

foreach (string key in drow.Keys) { dtb.Columns.Add(key, drow[key].GetType()); }

}

DataRow row = dtb.NewRow();

foreach (string key in drow.Keys) { row[key] = drow[key]; }

dtb.Rows.Add(row);

}

}

return dtb;

}

如此一來,就能把數據無刷新地寫入資料庫。

反向:DataTable 轉 JSON 並回顯前台

private string Dtb2Json(DataTable dtb) {

JavaScriptSerializer jss = new JavaScriptSerializer();

ArrayList dic = new ArrayList();

foreach (DataRow row in dtb.Rows) {

Dictionary<string, object> drow = new Dictionary<string, object>();

foreach (DataColumn col in dtb.Columns) { drow.Add(col.ColumnName, row[col.ColumnName]); }

dic.Add(drow);

}

return jss.Serialize(dic);

}

前端接收並以表格呈現:

function createTable(json) {

var table = $("<table border='1'></table>");

for (var i = 0; i < json.length; i++) {

o1 = json[i];

var row = $("<tr></tr>");

for (key in o1) { var td = $("<td></td>"); td.text(o1[key].toString()); td.appendTo(row); }

row.appendTo(table);

}

table.appendTo($("#back"));

}

如此便完成了 JSON 向前後台傳輸數據與顯示後台數據的整個流程。當然,這只是一種傳輸方式;簡單字串用 GET 或 POST 即可,但由於 JavaScript 本身具備不安全性與不穩定性,對於較重要的數據,建議還是尋求更可靠的方法。

XML學習教程| jQuery入門知識| AJAX入門| Dreamweaver教程| Fireworks入門知識| SEO技巧| SEO優化集錦|
Copyright © DIV+CSS佈局教程網 All Rights Reserved