上一篇寫到用 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(); }
}
}
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;
}
如此一來,就能把數據無刷新地寫入資料庫。
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 本身具備不安全性與不穩定性,對於較重要的數據,建議還是尋求更可靠的方法。