ScreenPro.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using BLL.Article;
using CSA.DAL;

public partial class ScreenPro : System.Web.UI.Page
{
    protected string cur_Code, cur_Id, kindname, title, content, name, navname, cur_kind, cur_color, cur_size, cur_price;
    protected DataRow drList;
    protected DataTable dtList, dtCat, dtProClass;

    protected void Page_Load(object sender, EventArgs e)
    {
        BindProducts();
    }

    protected void BindProducts()
    {

        cur_Code = Request.QueryString["Code"] == null ? "0" : Request.QueryString["Code"].ToString();   //接收Code
        cur_kind = Request.QueryString["kind"] == null ? "0" : Request.QueryString["kind"].ToString();
        cur_color = Request.QueryString["color"] == null ? "0" : Request.QueryString["color"];
        cur_size = Request.QueryString["size"] == null ? "0" : Request.QueryString["size"];
        cur_price = Request.QueryString["price"] == null ? "0" : Request.QueryString["price"];

        //dtCat = BLL.Product.Product.getList(cur_Code, 0);
        string sql1 = "";

        if (cur_Code != "0")
        {

            sql1 = "select * from bs_products where (bs_prokindcode like '" + cur_Code + "__' or bs_proKindcode like '" + cur_Code + "') ";


        }
        else
        {
            sql1 = "select * from bs_products where bs_prokindcode like '%%' ";

        }

        if (cur_kind != "0")
        {
            sql1 += " and bs_prokindcode like '" + cur_kind + "' ";
        }
        if (cur_color != "0")
        {
            sql1 += " and color like '%" + cur_color + "%' ";
        }
        if (cur_size != "0")
        {
            sql1 += " and size like '%" + cur_size + "%' ";
        }
        if (cur_price != "0")
        {
            sql1 += " and PriceRange like '%" + cur_price + "%' ";