给的那个开源主页,如何把推荐信息那里的改为展示商场频道ID号99的产品
代码如下:
string TJ()
{
StringBuilder sb = new StringBuilder();
IDataReader rdr = (IDataReader)WMshow.Show("select top 6 * from life where enable=" + WM.True + " order by" + ZK.FieldOrderbyDesc("istop") + "time desc,id desc");
while (rdr.Read())
{
sb.Append("<li><a href=\"/life/" + rdr["id"].ToString() + ".htm\" title=\"" + rdr["title"].ToString() + "\" target=\"_blank\">" + red(rdr["isred"].ToString(), "#ff0000") + WM.cut(rdr["title"].ToString().Trim(), 30, "..") + red(rdr["isred"].ToString(), "") + "</a><img src=\"/T/1/skin/tj.gif\" /></li>");
}
rdr = (IDataReader)WMshow.Show("select top 2 * from housesell where enable=" + WM.True + " order by" + ZK.FieldOrderbyDesc("istop") + "time desc,id desc");
while (rdr.Read())
{
sb.Append("<li><a href=\"/housesell/" + rdr["id"].ToString() + ".htm\" title=\"" + rdr["title"].ToString() + "\" target=\"_blank\">" + red(rdr["isred"].ToString(), "#ff0000") + WM.cut(rdr["title"].ToString().Trim(), 30, "..") + red(rdr["isred"].ToString(), "") + "</a><img src=\"/T/1/skin/tj.gif\" /></li>");
}
rdr = (IDataReader)WMshow.Show("select top 2 * from job where enable=" + WM.True + " order by" + ZK.FieldOrderbyDesc("istop") + "time desc,id desc");
while (rdr.Read())
{
sb.Append("<li><a href=\"/job/" + rdr["id"].ToString() + ".htm\" title=\"" + rdr["title"].ToString() + "\" target=\"_blank\">" + red(rdr["isred"].ToString(), "#ff0000") + WM.cut(rdr["title"].ToString().Trim(), 30, "..") + red(rdr["isred"].ToString(), "") + "</a><img src=\"/T/1/skin/tj.gif\" /></li>");
}
rdr.Close(); rdr.Dispose();
return sb.ToString();
}
//
string GetMallAuto()
{
StringBuilder sb = new StringBuilder();
//and (classid=99)--------------这里就是你那天改的呀
IDataReader rdr = (IDataReader)WMshow.Show("select top 10 * from mall where enable=" + WM.True + " order by" + ZK.FieldOrderbyDesc("istop") + "time desc,id desc");
while (rdr.Read())
{
sb.Append("<li><a href=\"/mall/" + rdr["id"].ToString() + ".htm\" title=\"" + rdr["title"].ToString() + "\" target=\"_blank\">" + red(rdr["isred"].ToString(), "#ff0000") + WM.cut(rdr["title"].ToString().Trim(), 30, "..") + red(rdr["isred"].ToString(), "") + "</a><img src=\"/T/1/skin/tj.gif\" /></li>");
}
rdr.Close(); rdr.Dispose();
return sb.ToString(); }