public string ShowClass(string fid)
{
string tid = GetTypeID("产品");
if (fid == "0")
{
fid = tid;
}
//int i, j, max = 9;
string inner = "";
string strConn = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString.ToString();
SqlConnection conn = new SqlConnection(strConn);
conn.Open();
string sql = "select *,(F040_CPGS + F041_GYGS) as ZGS from [Fenlei] left Join [Lujing] on [fenlei].F000_ID = [Lujing].L900_FGID where [Lujing].L005_FID = " + fid + "";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader sdr = cmd.ExecuteReader();
while (sdr.Read())
{
if (fid == tid)
{
inner = inner + "<b><a href=/"sjk_default.aspx?fid=" + sdr["F000_ID"].ToString() + "/" title=/"" + sdr["F005_FLMC"].ToString() + "/">" + sdr["F005_FLMC"].ToString() + "</a> (" + sdr["F035_ZLGS"].ToString() + ")</b><br>";
inner = inner + ShowClass(sdr["F000_ID"].ToString());
}
else
{
inner = inner + "<a href=/"sjk_default.aspx?fid=" + sdr["F000_ID"].ToString() + "/" title=/"" + sdr["F005_FLMC"].ToString() + "/">" + sdr["F005_FLMC"].ToString() + "</a> (" + sdr["ZGS"].ToString() + ")<br>";
}
}
inner = inner + "<br>";
if (fid != tid)
{
return inner;
}
else
{
this.div2.InnerHtml = this.div2.InnerHtml + inner;
return "";
}
}
//显示商城商品列表
protected void ShowSP()
{
string typeid = GetTypeID("产品");
int i,j,max = 12;
string inner = "",img="";
string strConn = ConfigurationManager.ConnectionStrings["connectionString"].ConnectionString.ToString();
SqlConnection conn = new SqlConnection(strConn);
conn.Open();
string sql = "select top " + max.ToString() + " *,convert(decimal (12,2),N045_XJ) as N045_XJ1,convert(Decimal(12,2),N050_YJ) as N050_YJ1 from [Neirong] where N900_FGID = " + typeid + " order by N000_ID DESC";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataReader dr = cmd.ExecuteReader();
inner = "<table border=/"0/" width=/"502/" cellpadding=/"6/" style=/"border-collapse: collapse/" height=/"142/">";
inner = inner + "<tr><td colspan=/"3/" style=/"height:6px;/"></td></tr>";
for(i=0;i<4;i++)
{
inner = inner + "<tr>";
for(j=0;j<3;j++)
{
if (dr.Read())
{
img = FormatImg(dr["N010_CSML"].ToString(), dr["N015_BCHZ"].ToString());
inner = inner + "<td style=/"width:33%;text-align:left;font-size:12px;line-height:140%;/">";
inner = inner + "<div style=/"border:1px solid #aaaaaa;background:#f0f0f0;line-height:160%;/"><div style=/"text-align:center;margin-top:1px;/"><a href=/"dp_xinxiyl.aspx?n000_id=" + dr["N000_ID"].ToString() + "/" title=/"" + dr["N005_MC"].ToString() + "/" target=/"blank/"><img src = /"" + img + "/" alt=/"" + dr["N005_MC"].ToString() + "/" style=/"width:150px;height:112px;border:0px solid #aaaaaa;/"></a></div>";
inner = inner + "/n/t【名 称】<span title=/"" + dr["N005_MC"].ToString() + "/">" + getStr(dr["N005_MC"].ToString(),14) + "</span><br>/n/t【编 号】" + dr["N000_ID"].ToString() + "<br>/n/t【型 号】" + dr["N035_CPXH"].ToString() + "<br>/n/t【单 位】" + dr["N040_JLDW"].ToString() + "<br>/n/t【现 价】" + dr["N045_XJ1"].ToString() + "<br>/n/t【原 价】" + dr["N050_YJ1"].ToString() + "<br>/n/t【发布日期】" + FucFromatDate(dr["N020_FBRQ"].ToString()) + "<br></div>";
inner = inner + "<div style=/"border:1px solid #aaaaaa;border-top:0px;text-align:center;background:#f0f0f0;height:36px;line-height:200%;padding-top:8px;margin-bottom:4px;/"><a href=/"dp_xinxiyl.aspx?n000_id=" + dr["N000_ID"].ToString() + "/" target=/"_blank/" title=/"商品详情/"><img src=/"images/xq.jpg/" border=/"0/"></a> <a href=/"javascript:void(0);/" οnclick=/"javascript:AddFavorite('dp_xinxiyl.aspx?n000_id=" + dr["N000_ID"].ToString() + "','" + dr["N005_MC"].ToString() + "')/"><img src=/"images/sc.jpg/" border=/"0/"></a></div>";
inner = inner + "</td>";
}
else
{
inner = inner + "<td style=/"width:33%;text-align:center;/"> </td>";
}
}
inner = inner + "</tr>";
//inner = inner + "<tr><td colspan=/"3/" style=/"height:4px;/"></td></tr>";
}
inner = inner + "</table>";
this.div1.InnerHtml = inner;
}