表格转为JSON数据格式

作者：敖士伟 Email：ikmb@163.com 转载注明作者

1、表格单元TD的CLASS属性至少有两个值，如：class="Name for_json"，第一个是JSON的键名，第二个

固定标识，表明此单元格要组合为JSON
2、表格行数据用"trsplit"分割
3、补充
String.prototype.trim = function() { return this.replace(/(^/s*)|(/s*$)/g, ""); }

作者：敖士伟 Email：ikmb@163.com 转载注明作者

JS

function ddd(tid) { $.post("test2.aspx", { msg: GetTDJsonStr(tid) }, function(data) { alert(data); }); } function GetTDJsonStr(tid) { var t_data = ""; var tr_data_temp = ""; var td_data_temp = ""; //tr var num_tr=$("#" + tid).find("tr").length; $("#" + tid).find("tr").each(function(i) { if (i < num_tr - 1) { //tr if ($("#" + tid).find("tr:eq(" + i + ")").find("td").filter(".for_json").length != 0) { tr_data_temp = ""; //td var num_for_json = $("#" + tid).find("tr:eq(" + i + ")").find("td").filter(".for_json").length; $("#" + tid).find("tr:eq(" + i + ")").find("td").filter(".for_json").each(function(j) { if ($(this).css("display") != "none") { if ($(this).find("input[type='text']").length == 0) { td_data_temp = $(this).text().trim(); } else { td_data_temp = $(this).find("input[type='text']:eq(0)").val().trim(); } if (j < num_for_json - 1) { td_data_temp = '"' + $(this).attr("class").split(" ")[0] + '":"' + td_data_temp + '",'; } else { td_data_temp = '"' + $(this).attr("class").split(" ")[0] + '":"' + td_data_temp + '"'; } tr_data_temp += td_data_temp; } }); t_data += "{" + tr_data_temp + "}trsplit"; } } }); return t_data; }

HTML

<table id="tb" style="width: 100%;"> <tr> <th> a </th> <th> b </th> </tr> <tr class="data_tr"> <td class="Name for_json c2"> 1 </td> <td class="Single for_json"> 2 </td> </tr> <tr class="data_tr"> <td class="Name for_json c2"> 11 </td> <td class="Single for_json"> 22 </td> </tr> <tr> <td>  </td> <td>  </td> </tr> </table> <input id="in1" type="button" onclick="ddd('tb');" value="dd" />

ASP.NET

protected void Page_Load(object sender, EventArgs e) { JavaScriptSerializer Serializer = new JavaScriptSerializer(); string[] split=new string[1] ; split[0]="trsplit"; string[] r = Request.Form["msg"].Split(split,StringSplitOptions.RemoveEmptyEntries); //{"Name":"MyName1","Single":"one"} t_json t_json_object=null; foreach (string t in r) { t_json_object = Serializer.Deserialize<t_json>(t); } Response.Write(t_json_object.Name); Response.End(); } class t_json { public float Name; public string Single; }

作者：敖士伟 Email：ikmb@163.com 转载注明作者