asp.net 中的三层体系结构问题



我有一个三层架构的 asp.net 项目。我在解决方案中添加了业务访问层 (BAL) 和数据访问层 (DAL) 作为类库,并在 BAL 中添加了 DAL 的引用,并在 UI 中添加了 BAL 的引用。

我已经在 BAL 的一个类中编写了一些方法并且它工作正常,但现在我正在向任何访问 UI 中新添加方法的 BAL 类添加新方法。所以新添加的方法在 UI 中无法访问,它给了我错误

'巴尔。TaskBAL' 不包含 "删除所选任务BAL"并且没有扩展方法 'deleteSelectedTaskBAL' 接受类型的第一个参数 '巴尔。可以找到 TaskBAL'(您是否缺少 using 指令或 程序集引用?
D:\Mohsin\当前工作\ManageTaskBALDAL\AdminHomePage.aspx.cs

这里deleteSelectedBAL是新添加的方法

在这里你可以尝试两件事

1)从UI文件夹的bin中删除.dll文件,然后尝试再次添加。2)您可以通过右键单击解决方案来设置项目依赖项。那么你不需要一次又一次地添加

我过去遇到过这个问题。有时清理和重建 BAL 项目也会有所帮助。

此外,请确保使用调用该方法的代码文件中的命名空间。

作为项目生成项目的程序集的引用。如果引用的是构建构件,则依赖项链已断开。删除引用并改为添加项目引用

namespace BLL
{
    public class tblSubCategory
    {
        public tblSubCategory()
        {
            //
            // TODO: Add constructor logic here
            //
        }
        private int iSubCatId;
        private string sSubCatName;
        private string sImagePath;
        private int iCategoryId;
        private string sDescription;
        private decimal decPrice;
        private int sCategoryName;
        public int SubCatId
        {
            get
            { return iSubCatId; }
            set
            { iSubCatId = value; }
        }
        public string SubCatName
        {
            get
            {
                return sSubCatName;
            }
            set
            { sSubCatName = value; }
        }
        public string ImagePath
        {
            get
            {
                return sImagePath;
            }
            set
            { sImagePath = value; }
        }
        public int CategoryId
        {
            get
            {
                return iCategoryId;
            }
            set
            { iCategoryId = value; }
        }
        public string Description
        {
            get
            { return sDescription; }
            set
            { sDescription = value; }
        }
        public decimal Price
        {
            get
            { return decPrice; }
            set
            { decPrice = value; }
        }
        public int CategoryName
        {
            get
            {
                return sCategoryName;
            }
            set
            { sCategoryName = value; }
        }
        public int InserttblSubCategory()
        {
            DBAccess db = new DBAccess();
            db.AddParameter("@sSubCatName", sSubCatName);
            db.AddParameter("@sImagePath", sImagePath);
            db.AddParameter("@iCategoryId", iCategoryId);
            db.AddParameter("@sDescription", sDescription);
            db.AddParameter("@decPrice", decPrice);
            return db.ExecuteNonQuery("[tblSubCategory_Insert]", true);
        }
        public DataSet SelectAlltblSubCategory()
        {
            DBAccess db = new DBAccess();
            //db.AddParameter("@iSubCatId", iSubCatId);
            //return db.ExecuteDataSet("tblSubCategory_SelectAllForDDL");
            return db.ExecuteDataSet("tblSubCategory_SelectAll");
        }
        public int UpdatetblSubCategory()
        {
            DBAccess db = new DBAccess();
            db.AddParameter("@iSubCatId", iSubCatId);
            db.AddParameter("@sSubCatName", sSubCatName);
            //db.AddParameter("@sImagePath", sImagePath);
            //db.AddParameter("@iCategoryId", iCategoryId);
            db.AddParameter("@sDescription", sDescription);
            db.AddParameter("@decPrice", decPrice);
            return db.ExecuteNonQuery("[tblSubCategory_Update]", true);
        }
        public int DeletetblSubCategory()
        {
            DBAccess db = new DBAccess();
            db.AddParameter("@iSubCatId", iSubCatId);
            return db.ExecuteNonQuery("[tblSubCategory_Delete]", true);
        }
        public DataSet SubCategoryAscByCategory()
        {
            DBAccess db = new DBAccess();
            db.AddParameter("@iCategoryId", CategoryId);
            return db.ExecuteDataSet("[tblSubCategory_SelectAsc]");
        }
        public DataSet SubCategoryDescByCategory()
        {
            DBAccess db = new DBAccess();
            db.AddParameter("@iCategoryId", CategoryId);
            return db.ExecuteDataSet("[tblSubCategory_SelectDescPrice]");
        }
        public DataSet InnerjointblSubCategory1()
        {
            DBAccess db = new DBAccess();
            db.AddParameter("@iCategoryId", CategoryId);
            return db.ExecuteDataSet("[tblSubCategory_InnerJoin1]");
        }
        public DataSet SelectDesctblSubCategory()
        {
            DBAccess db = new DBAccess();
            db.AddParameter("@iCategoryId", iCategoryId);
            //db.AddParameter("@sSubCatName", sSubCatName);
            return db.ExecuteDataSet("tblSubCategory_SelectDesc");
        }
        public DataSet SelectSubCatName()
        {
            DBAccess db = new DBAccess();
            db.AddParameter("@iCategoryId", iCategoryId);
            return db.ExecuteDataSet("tblSubCategory_SelectSubCatName");
        }
        public DataSet SelectProductsBySubCategory()
        {
            DBAccess db = new DBAccess();
            db.AddParameter("@iSubCatId", iSubCatId);
            return db.ExecuteDataSet("tblProduct_ProductBySubCat");
        }
        public DataSet selectallsub()
        {
            DBAccess db = new DBAccess();
            //db.AddParameter("@iSubCatId", iSubCatId);
            //return db.ExecuteDataSet("tblSubCategory_SelectAllForDDL");
            return db.ExecuteDataSet("tblSubCategory_InnerJoin2");
        }
        public DataSet selectallsubasc()
        {
            DBAccess db = new DBAccess();
            //db.AddParameter("@iSubCatId", iSubCatId);
            //return db.ExecuteDataSet("tblSubCategory_SelectAllForDDL");
            return db.ExecuteDataSet("tblSubCategory_InnerJoinDesc");
        }
        public DataSet SelectSubCategoryBySubCatId()
        {
            DBAccess db = new DBAccess();
            db.AddParameter("@iSubCatId", iSubCatId);
            return db.ExecuteDataSet("tblSubCategory_ddlProduct");
        }
        public DataSet SelectSubCategoryByCategory()
        {
            DBAccess db = new DBAccess();
            db.AddParameter("@iCategoryId", iCategoryId);
            return db.ExecuteDataSet("tblSubCategory_SelectSubCategoryByCategory");
        }
        public DataSet GetSubCategory()
        {
            DBAccess db = new DBAccess();
            db.AddParameter("@sSubCatName", sSubCatName);
            return db.ExecuteDataSet("tblSubCategory_SelectSname");
        }
        public DataSet SubCategoryByCatAsc()
        {
            DBAccess db = new DBAccess();
            db.AddParameter("@iCategoryId", iCategoryId);
            return db.ExecuteDataSet("tblSubCategory_asc");
        }
        public DataSet SubCategoryByCatDesc()
        {
            DBAccess db = new DBAccess();
            db.AddParameter("@iCategoryId", iCategoryId);
            return db.ExecuteDataSet("tblSubCategory_desc");
        }
        public DataSet CategoryByCatId()
        {
            DBAccess db = new DBAccess();
            db.AddParameter("@iCategoryId", iCategoryId);
            return db.ExecuteDataSet("tblCategory_SelectAllCat");
        }
        public DataSet InnerjointblSubCategoryTop3()
        {
            DBAccess db = new DBAccess();
            //db.AddParameter("@sCategoryName", CategoryName);
            db.AddParameter("@iCategoryId", CategoryId);
            return db.ExecuteDataSet("[tblSubCategory_InnerJoinTop3]");
        }
    }
}

最新更新