correlationpro.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;
using System.Collections.Generic;

namespace YXShop.Web.Admin.Product
{
    public partial class CorrelationPro : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {
            StringBuilder proList = new StringBuilder();
            proList.Append("<select name=\"selPro_RelatingProID\" size=\"14\" multiple=\"multiple\" style=\"width: 98%\">");
            try
            {
                string searchWord = Request.QueryString["searchWord"];
                YXShop.BLL.Product BLL = new YXShop.BLL.Product();
                DataSet ds = BLL.GetSearchKey(0, "Pro_ID,Pro_Name", "YXShop_Product", "Pro_Name like '%" + searchWord.Trim() + "%'", "Pro_ID desc");
                DataTable dt = ds.Tables[0];
                if (dt.Rows.Count > 0)
                {
                    proList.Append("<option value=\"0\">请选择相关商品...</option>");
                    for (int i = 0; i < dt.Rows.Count; i++)
                    {
                        proList.Append("<option value=\"" + dt.Rows[i]["Pro_ID"].ToString() + "\">" + dt.Rows[i]["Pro_Name"].ToString() + "</option>");
                    }
                    proList.Append("</select>");
                    Response.Write(proList.ToString());
                }
                else
                {
                    proList.Append("<option value=\"0\">无相关商品</option>");
                    proList.Append("</select>");
                    Response.Write(proList.ToString());
                }
            }
            catch (Exception ex)
            {
                proList.Append("<option value=\"0\">程序出错，详细信息："+ex.ToString()+"</option>");
                proList.Append("</select>");
                Response.Write(proList.ToString());
            }
        }
    }
}