App_Code/Product/Kind.cs

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

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

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

namespace BLL.Product
{
    /// <summary>
    /// ProductKind 的摘要说明
    /// </summary>
    public class Kind
    {   
        private static string  tblName = "bs_prokind";
        public Kind()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }      
        /// <summary>
        /// 获取产品分类
        /// </summary>
        /// <param name="pcode">父类编号,null则表示全部分类,""则表示顶级分类</param>
        /// <param name="deep">子类深度,0表示全部</param>
        /// <returns></returns>
        public static DataTable getList(string pcode, int deep)
        {
            string sql = "select * from "+tblName+" where status=0 ";
            if (pcode == null)
            {                
               // sql += " and len(code)=2";
            }
            else if (pcode == "")
            {
                sql += " and len(code)=2";
            }
            else
            {
                sql += " and code like '" + pcode + "%'";
                if (deep > 0)
                {
                    sql += " and len(code)=" + (pcode.Length * deep).ToString();
                }
            }
            sql += " order by sortno,id";
            return CSA.DAL.DBAccess.getRS(sql);
        }

        public static DataTable getList1(string pcode, int deep)
        {
            string sql = "select * from " + tblName + " where status=0 ";
            if (pcode == null)
            {
                // sql += " and len(code)=2";
            }