劳烦 xiyou哥，帮我分析一下代码的错误之处 -

bysxingyun - 2014/12/5 10:41:11

想在文章标题前增加所属分类及连接，但在数据调用时出错。帮忙解决一下，不胜感谢

<div class="article">
<ul>
<%
DataTable dt;
DataTable dt1;
DataRow dr;
DataRow dr1;
dt=Get_Data();
dt1=Get_Data("select * from pa_sublanmu where thetable='article'");

string parent_dir,lanmu_dir,sublanmu_dir;
for(int i=0;i<dt.Rows.Count;i++)
{
   dr=dt.Rows;
   for(int j=0;j<dt1.Rows.Count;j++)
    {
       dr1=dt1.Rows[j];

       if(dr["sublanmu_id"].ToString()==dr1["id"].ToString())
       {
        parent_dir = dr1["parent_dir"].ToString();
        lanmu_dir = dr1["lanmu_dir"].ToString();
        sublanmu_dir = dr1["sublanmu_dir"].ToString();
        }
        else{return;}
     }

%>
<li><span class="title">

<a href="<%=Sublanmu_Url(int.Parse(dr["site_id"].ToString()),int.Parse(dr["lanmu_id"].ToString()),int.Parse(dr["sublanmu_id"].ToString()),parent_dir,lanmu_dir,sublanmu_dir,dr["zdy_url"].ToString())%>">

[<%=Sort_Name(int.Parse(dr["sort_id"].ToString()))%>]

</a>
<a href="<%=Detail_Url(dr)%>" target="<%=Target%>" title=" <%=Server.HtmlEncode(dr["title"].ToString())%> " style="<%=dr["pa_style"]%>"><%=SubStr(dr["title"].ToString(),Title_Num,true)%></a></span>
<span class="date"> <%=((DateTime)dr["thedate"]).ToString("MM-dd")%>  </span>
<span class="clear"></span>
</li>
<%
}
%>
</ul></div>

附件: QQ图片20141205104436.jpg

xiyou - 2014/12/5 10:48:30

<%=Sublanmu_Url(int.Parse(dr["site_id"].ToString()),int.Parse(dr["lanmu_id"].ToString()),int.Parse(dr["sublanmu_id"].ToString()),"parent_dir".ToString(),"lanmu_dir".ToString(),"sublanmu_dir".ToString(),dr["zdy_url"].ToString())%>

Sublanmu_Url这个方法调用的是pa_sublanmu这个表的字段。所以应该是用dr1

<%=Sublanmu_Url(int.Parse(dr1["site_id"].ToString()),int.Parse(dr1["lanmu_id"].ToString()),int.Parse(dr1["id"].ToString()),dr1["parent_dir"].ToString(),dr1("lanmu_dir").ToString(),dr1("sublanmu_dir").ToString(),dr1["zdy_url"].ToString())%>>

bysxingyun - 2014/12/5 11:47:07

那如何对dr1赋值呢？企业Demo版 dr1 行数只有2行而且文章列表模型中还要使用dr，把 }else{return;}}放到后边之后网页只能调取一条数据。文章分类url是正确的。

附件: 360截图20141205114943421.jpg

bysxingyun - 2014/12/5 13:19:38

return用错了，使用break就可以了。谢谢xiyou哥；

<div class="article">
<ul>
<%
DataTable dt;
DataTable dt1;
DataRow dr;
DataRow dr1;
dt=Get_Data();
dt1=Get_Data("select * from pa_sublanmu where thetable='article'");
int site_id,lanmu_id,id;
string parent_dir,lanmu_dir,sublanmu_dir,zdy_url;
for(int i=0;i<dt.Rows.Count;i++)
{
   dr=dt.Rows;
      for(int j=0;j<dt1.Rows.Count;j++)
       {
        dr1=dt1.Rows[j];
        if(dr["sublanmu_id"].ToString()==dr1["id"].ToString())
        {
        site_id=int.Parse(dr1["site_id"].ToString());
        lanmu_id=int.Parse(dr1["lanmu_id"].ToString());
        id=int.Parse(dr1["id"].ToString());
        zdy_url=dr1["zdy_url"].ToString();
        parent_dir = dr1["parent_dir"].ToString();
        lanmu_dir = dr1["lanmu_dir"].ToString();
        sublanmu_dir = dr1["sublanmu_dir"].ToString();

%>
<li><span class="title">

<a href="<%=Sublanmu_Url(site_id,lanmu_id,id,parent_dir,lanmu_dir,sublanmu_dir,zdy_url)%>">

[<%=Sort_Name(int.Parse(dr["sort_id"].ToString()))%>]

</a>
<a href="<%=Detail_Url(dr)%>" target="<%=Target%>" title=" <%=Server.HtmlEncode(dr["title"].ToString())%> " style="<%=dr["pa_style"]%>"><%=SubStr(dr["title"].ToString(),Title_Num,true)%></a></span>
<span class="date"> <%=((DateTime)dr["thedate"]).ToString("MM-dd")%>  </span>
<span class="clear"></span>
</li>
<%
break;}
}
}
%>
</ul></div>

产品使用及交流论坛