除此之外,今天还应用了,一个转化成JSon对象的方法,也把它记录下来:
服务器后台的代码是:WebForm4.aspx.cs
protected void Page_Load(object sender, EventArgs e)
{
DataSet ds = new DataSet();
ds = Departmentbll.GetAllList();
DataTable dt = ds.Tables[0];
int num=2;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
string DepartmentId = ds.Tables[0].Rows[i][0].ToString ();
if (DepartmentId.Length > num)
num = DepartmentId.Length;
}
//str += "{number:'"+num+"'}";
string str = "";
str = JsonHelper.ToJson(num, dt);
Response.Write(str);
Response.Flush();
Response.End();
}
其中转化成JSon的方法是:
public static string ToJson(int num, DataTable dt)
{
StringBuilder sb = new StringBuilder();
sb.Append("{");
sb.Append("number:" + num + ",");
sb.Append("rows: [");
for (int i = 0; i < dt.Rows.Count; i++)
{
sb.Append("{");
sb.Append("id:" + i);
sb.Append(",");
sb.Append("cell:");
sb.Append("[");
for (int j = 0; j < dt.Columns.Count; j++)
{
sb.Append("'" + dt.Rows[i][j] + "'");
if (j < dt.Columns.Count - 1)
{
sb.Append(",");
}//
else
{
sb.Append("");
}//
}//
sb.Append("]");
sb.Append("}");
if (i < dt.Rows.Count - 1)
{
sb.Append(",");
}//
else
{
sb.Append("");
}//
}//
sb.Append("]");
sb.Append("}");
return Convert.ToString(sb);
}
}
其中多了一个num.在Ajax中访问的方式为:
$(document ).ready(function (){
$.ajax({
url: "WebForm4.aspx",
type: "POST",
data:null ,//post参数信息
dataType: "json",
timeout: 1000,
error: function(data){alert("error");},
success: function(data)
{
alert ("你好");
var cell,row;
if(data.rows.length<=0)
return;
alert (data.number/2);
for(var inum=1;inum<data.number/2 +1;inum++)
{
for (var iRow=0;iRow<data.rows.length;iRow++)
{
var DepartmendId=data .rows[iRow].cell[0];
var Superior=data.rows[iRow].cell[5];
var Name=data.rows[iRow].cell[1];
if (DepartmendId.length ==inum *2)
{}
}
}
}
});