ajax从asp后台获取数据
2020-11-24 03:22
标签:style blog class code java tar 1.前台 2.后台 ajax从asp后台获取数据,搜素材,soscw.com ajax从asp后台获取数据 标签:style blog class code java tar 原文地址:http://www.cnblogs.com/yixiaozi/p/3703619.html$.ajax({
//url: "demo/data/taskTree.txt",
url: "GanttChart.aspx?taskList=1" ,
cache: false,
success: function (text) {
var data = mini.decode(text);
gantt.loadTasks(data);
gantt.unmask();
//折叠全部
//gantt.collapseAll();
}
});
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 )
{
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();
上一篇:jquery读写json