App_Code/BLL/Product.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;
using SystemDAL;
using SystemModel;
using System.Data.OleDb;
using Wuqi.Webdiyer;
/// <summary>
/// Product 的摘要说明
/// </summary>
/// 
namespace SystemProduct
{
    public class Product
    {

        public Product()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }
        #region 根据获取的classid 绑定数据(后台：分类快捷查找)
        /// <summary>
        /// 根据获取的classid 绑定数据(后台：分类快捷查找)
        /// </summary>
        /// <param name="asp">控件</param>
        /// <param name="classid">分类id</param>
        /// <returns>dataset</returns>
        public static DataSet GetMsgBYCid(AspNetPager asp,string classid)
        {
            string cmdText = "";
            //cmdText = "select [product].*,[productclass].*,[productimage].* from [product],[productclass],[productimage]";
            //cmdText += " where [product].classid=[productclass].id and [productimage].pcid=[product].pid";
            //cmdText += " and [product].classid=@classid";
            cmdText = "select [product].*,[productclass].* from [product],[productclass]";
            cmdText += " where [product].classid=[productclass].id";
            cmdText += " and [product].classid=@classid";
            try
            {
                OleDbParameter[] OleDbParameter =
            {
                new OleDbParameter("@classid",classid)
            };
                DAL dal = new DAL();
                DataSet ds = dal.OleExecuteDataSetAspnet(asp,cmdText,OleDbParameter);
                return ds;
            }
            catch (Exception E)
            {
                throw E;
            }
        }
        /// <summary>