首页 > 代码库 > ajax从asp后台获取数据
ajax从asp后台获取数据
1.前台
$.ajax({ //url: "demo/data/taskTree.txt", url: "GanttChart.aspx?taskList=1" , cache: false, success: function (text) { var data =http://www.mamicode.com/ mini.decode(text); gantt.loadTasks(data); gantt.unmask(); //折叠全部 //gantt.collapseAll(); } });
2.后台
?
1 2 3 4 | if (Request.QueryString[ "taskList" ] != null ) { GetTaskList(); } |
StringBuilder taskStr = new StringBuilder ( "["); using (SqlConnection conn = new SqlConnection(connString)) { conn.Open(); string strSQL = @"select * from Tasks order by OrderNumber" ; //SqlCommand cmd = new SqlCommand(strSQL, conn); //SqlDataReader rdr = cmd.ExecuteReader(); SqlDataAdapter myda = new SqlDataAdapter(strSQL, conn); DataSet myds = new DataSet(); myda.Fill(myds); DataTable tb = myds.Tables[0]; for (int i = 0; i < tb.Rows.Count; i++) { DataRow row = tb.Rows[i]; int UID = int .Parse(row[ "OrderNumber"].ToString()); string taksName = row["Title" ].ToString(); DateTime StartDate = DateTime .Parse(row[ "StartDate"].ToString()); DateTime DueDate = DateTime .Parse(row[ "DueDate"].ToString()); TimeSpan ts = DueDate.Subtract(StartDate); int FatherTask = int .Parse(row[ "FatherTask"].ToString()); int datelenth = ts.Days; taskStr.Append( "{" ); taskStr.Append( "‘UID‘: ‘" + UID + "‘," ); taskStr.Append( "‘Name‘: ‘" + taksName + "‘," ); taskStr.Append( "‘Duration‘: " + datelenth + "," ); taskStr.Append( "‘Start‘: ‘" + StartDate.ToString() + ":T00:00:00" + "‘,"); taskStr.Append( "‘Finish‘: ‘" + DueDate.ToString() + ":T00:00:00" + "‘,"); taskStr.Append( "‘PercentComplete‘: " + 0 + "," ); if (FatherTask == -1) taskStr.Append( "‘Summary‘: " + 1 + "," ); else taskStr.Append( "‘Summary‘: " + 0 + "," ); taskStr.Append( "‘Critical‘: " + 1 + "," ); taskStr.Append( "‘Milestone‘: " + 0 + "," ); taskStr.Append( "‘PredecessorLink‘: 0," ); taskStr.Append( "‘ParentTaskUID‘: " + FatherTask + "," ); taskStr.Append( "}" ); if (i != tb.Rows.Count - 1) taskStr.Append( "," ); } taskStr.Append( "]" ); } Response.Write(taskStr.ToString()); Response.End();
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。