uc/ucKind.ascx.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 uc_ucKind : System.Web.UI.UserControl
{
    protected DataTable dtkind, dtcolor, dtsize, dtprice, dtjingping;
    protected string cur_Code, cur_kind, cur_color, cur_size, cur_price, cur_sortnostr;
    protected void Page_Load(object sender, EventArgs e)
    {
        getList();
        getKedword();
    }
    private void getList()
    {
        cur_Code = Request.QueryString["Code"];   //接收Code
        if (string.IsNullOrEmpty(cur_Code))                //如果没有Code传进，自定义Code
        {
            cur_Code = "0";
        }
        if (cur_Code.Length == 4)
        {
            cur_Code = cur_Code.Remove(2, 2);
        }
        if (!string.IsNullOrEmpty(Request.QueryString["sortno"]))                //如果没有Code传进，自定义Code
        {
            cur_sortnostr = "&sortno=" + Request.QueryString["sortno"];
        }

        //dtkind = BLL.Product.Kind.getList("", 2);
        if (cur_Code == "0")
        {
            dtkind = new DataTable();
        }
        else
        {
            dtkind = CSA.DAL.DBAccess.getRS("select * from bs_ProKind where code like '" + cur_Code + "__' order by sortno asc");
        }
        //dtkind = BLL.Product.Kind.getList("02", 2);
        string sql = "select * from bs_ProProPerty where code like '01__' order by sortno asc";
        dtcolor = CSA.DAL.DBAccess.getRS(sql);
        sql = "select * from bs_ProProPerty where code like '02__' order by sortno asc";
        dtprice = DBAccess.getRS(sql);
        //sql = "select * from bs_ProProPerty where code like '03__' order by sortno asc";
        //dtjingping = DBAccess.getRS(sql);
        dtjingping = BLL.Product.Kind.getList("", 1);
        sql = "select * from bs_ProProPerty where code like '04__' order by sortno asc";
        dtsize = DBAccess.getRS(sql);
    }

    private void getKedword()
    {
        txt_kind.Value = Request.QueryString["kind"] == null ? "0" : Request.QueryString["kind"].ToString();
        txt_color.Value = Request.QueryString["color"] == null ? "0" : Request.QueryString["color"];