在c#.net中如何嵌套页面vs2005技术

   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>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<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;/">&nbsp;</td>";
                }
            }
            inner = inner + "</tr>";
            //inner = inner + "<tr><td colspan=/"3/" style=/"height:4px;/"></td></tr>";
        }
        inner = inner + "</table>";
        this.div1.InnerHtml = inner;
    }

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值