correlationarticle.aspx.cs

易想商城系统

using System;
using System.Collections;
using System.Configuration;
using System.Data;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Text;

namespace YXShop.Web.Admin.Product
{
    public partial class CorrelationArticle : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            StringBuilder articleList = new StringBuilder();
            articleList.Append("<select name=\"selPro_RelatingArtID\" size=\"14\" multiple=\"multiple\" style=\"width: 98%\">");
            try
            {
                string keyWord = Request.QueryString["keyWord"];
                YXShop.BLL.YixiangArticle BLL = new YXShop.BLL.YixiangArticle();
                DataSet ds = BLL.searchArticle("", keyWord,1);
                DataTable dt = ds.Tables[0];
                if (dt.Rows.Count > 0)
                {
                    articleList.Append("<option value=\"0\">请选择相关文章...</option>");
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        articleList.Append("<option value=\"" + ds.Tables[0].Rows[i][0].ToString() + "\">" + ds.Tables[0].Rows[i][1].ToString() + "</option>");
                    }
                    articleList.Append("</select>");
                    Response.Write(articleList.ToString());
                }
                else
                {
                    articleList.Append("<option value=\"0\">无相关文章</option>");
                    articleList.Append("</select>");
                    Response.Write(articleList.ToString());
                }
            }
            catch
            {
                articleList.Append("<option value=\"0\">无相关文章</option>");
                articleList.Append("</select>");
                Response.Write(articleList.ToString());
            }
        }
    }
}