62,243
社区成员




string newstr = "";
public string showtreenume_danye(int tids)
{
string sql_danye = "select * from aaa";
fx_DataReader dr_danye = new fx_DataReader(sql_danye);
while (dr_danye.Read())
{
if (tids == 0)
{
newstr = newstr + "111";
}
else
{
newstr = newstr + "222";
}
string myid = dr_danye["id"].ToString();
this.showtreenume_danye(Convert.ToInt32(myid));
}
dr_danye.Close();
return newstr;
}
刚才发的错了 想想应该放这里
public string showtreenume_danye(int tids, string tbname, string objurl, int steeps)
{
Response.Write(DateTime.Now.ToString() + "</br>");
//记录时间你测试一下时间差
string sql_danye = "select tname,id,tn from " + tbname + " where tn=" + tids + " order by px asc";
fx_DataReader dr_danye = new fx_DataReader(sql_danye);
while (dr_danye.Read())
{
if (tids == 0)
{
newstr = newstr + "a.add(" + (Convert.ToInt32(dr_danye["id"]) + Convert.ToInt32(steeps)) + ",0,'" + dr_danye["tname"] + "','" + objurl + dr_danye["id"] + "');\n";
}
else
{
newstr = newstr + "a.add(" + (Convert.ToInt32(dr_danye["id"]) + Convert.ToInt32(steeps)) + "," + (Convert.ToInt32(dr_danye["tn"]) + Convert.ToInt32(steeps)) + ",'" + dr_danye["tname"] + "','" + objurl + dr_danye["id"] + "');\n";
}
this.showtreenume_danye(Convert.ToInt32(dr_danye["id"].ToString()), tbname, objurl, steeps);
dr_danye.Close(); //马上去关闭不影响效率好像,放这里
}
//dr_danye.Close();最后放这里测试一下时间是多少?
Response.Write(DateTime.Now.ToString() + "</br>");
return newstr;
}