Productl.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 Productl : System.Web.UI.Page
{
    protected string cur_Code, cur_Id, kindname, title, content, name, navname;
    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"];   //接收Code
        cur_Id = Request.QueryString["Id"];               //接收传进来的Id
        if (string.IsNullOrEmpty(cur_Code))                //如果没有Code传进，自定义Code
        {
            cur_Code = "";
        }

        //dtCat = BLL.Product.Product.getList(cur_Code, 0);
        string sql1 = "select * from bs_products where bs_prokindcode ='" + cur_Code + "' or bs_prokindcode like'" + cur_Code + "__' " + getSortno();
        if (string.IsNullOrEmpty(cur_Code))                //如果没有Code传进，自定义Code
        {
            dtCat = BLL.Product.Product.getList("", 0);
        }
        else
        {
            dtCat = DBAccess.getRS(sql1);
        }
        int pageindex = 1;
        if (!string.IsNullOrEmpty(Request.QueryString["page"]))
        {
            pageindex = int.Parse(Request.QueryString["page"]);
        }
        string cur_sortno = Request.QueryString["sortno"];
        if (string.IsNullOrEmpty(cur_sortno))                //如果没有Code传进，自定义Code
        {
            cur_sortno = "2";
        }
        int pageSize = 10;
        AspNetPager1.UrlRewritePattern = "Productl!" + cur_sortno + "!" + cur_Code + "!{0}.html";
        AspNetPager1.RecordCount = dtCat != null ? dtCat.Rows.Count : 0;
        AspNetPager1.PageSize = pageSize;
        dtList = CSA.DAL.PageHelper.getPage(dtCat, pageSize, pageindex);
        this.AspNetPager1.CurrentPageIndex = pageindex;
        string sql = "select name from bs_prokind where code ='" + cur_Code + "'";

        //Response.Write("<script>alert('code:" + cur_Code + "  pageindex:" + pageindex + "')</script>");
        DataTable dtKind = CSA.DAL.DBAccess.getRS(sql);
        if (dtKind != null && dtKind.Rows.Count > 0)