业务层

using System;
using System.Web;
using System.Web.Services;
using System.Web.Services.Protocols;
using DB_SJWTableAdapters;

namespace SJW.BLL.Admin
{

public class Administrators
{
    public static void Add(DB_SJW.T_AdminRow admin)
    {
        T_AdminTableAdapter Admins = new T_AdminTableAdapter();
        Admins.InsertQuery(admin.F_Username, admin.F_Password,admin.F_AuthorID);
    }

    public static void Edit(DB_SJW.T_AdminRow admin)
    {
        T_AdminTableAdapter Admins = new T_AdminTableAdapter();
        Admins.UpdateQuery(admin.F_Username, admin.F_Password, admin.F_AuthorID, admin.F_ID);
    }

    public static void Delete(DB_SJW.T_AdminRow admin)
    {
        T_AdminTableAdapter Admins = new T_AdminTableAdapter();
        Admins.DeleteQuery(admin.F_ID);
    }

    public static DB_SJW.T_AdminDataTable Show()
    {
        T_AdminTableAdapter Admins = new T_AdminTableAdapter();
        return Admins.GetAdmins();
    }
}
    [System.ComponentModel.DataObject]
    public class UserCompanyOP
    {
        private View_UserCompanyTableAdapter _UserCompanyAdapter = null;
        protected View_UserCompanyTableAdapter UserCompanyAdapter
        {
            get
            {
                if(_UserCompanyAdapter==null)
                    _UserCompanyAdapter= new View_UserCompanyTableAdapter();
                return _UserCompanyAdapter;
            }
        }

        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
        public DB_SJW.View_UserCompanyDataTable GetDataUserCompany()
        {
            return UserCompanyAdapter.GetData();
           
        }

        private T_UserTableAdapter _userAdapter = null;
        protected T_UserTableAdapter UserAdapter
        {
            get
            {
                if (_userAdapter == null)
                    _userAdapter = new T_UserTableAdapter();
                return _userAdapter;
            }
        }

        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, false)]
        public DB_SJW.T_UserDataTable GetDataUserByID(int id)
        {
            return UserAdapter.GetDataByID(id);
        }
       
        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Update, true)]
        public bool UpdateUserLevel(int? level,int original_F_ID)
        {
            DB_SJW.T_UserDataTable users = UserAdapter.GetDataByID(original_F_ID);
            if (users.Count == 0)
            { return false; }
            DB_SJW.T_UserRow userrow = users[0];
            //if (level == null) userrow.SetF_LevelNull();
            userrow.F_Level = Convert.ToInt32(level);
            //else userrow.F_Level=level.value;
            //userrow.Discontinued=discontinued;

            int rowsAffected = UserAdapter.User_UpdateLevel(level, original_F_ID, original_F_ID);
            return rowsAffected == 1;
        }

        private T_CompanyTableAdapter _companyAdapter = null;
        protected T_CompanyTableAdapter CompanyAdapter
        {
            get
            {
                if (_companyAdapter == null)
                {
                    _companyAdapter = new T_CompanyTableAdapter();
                }
                return _companyAdapter;
            }
        }

        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, false)]
        public DB_SJW.T_CompanyDataTable GetDataCompanyByUserID(int userid)
        {
            return CompanyAdapter.GetDataByUserID(userid);
        }

        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Update, true)]
        public bool UpdateCompany(int? istop, bool F_CheckStatus, int original_F_ID, int original_F_UseID)
        {
            DB_SJW.T_CompanyDataTable companys = CompanyAdapter.GetDataByUserID(original_F_UseID);
            if (companys.Count == 0)
            { return false; }
            DB_SJW.T_CompanyRow companyrow = companys[0];
            if (istop == null) companyrow.SetF_IsTopNull();
            else companyrow.F_IsTop = istop.Value;

            companyrow.F_CheckStatus = F_CheckStatus;

            int rowAffected = CompanyAdapter.Company_UpdateByAdmin(istop, F_CheckStatus, original_F_ID, original_F_ID);
            return rowAffected == 1;
        }

  
    }

    [System.ComponentModel.DataObject]
    public class UserNewsOP
    {
        private View_UserNews_NewsTableAdapter _newsAdapter = null;
        protected View_UserNews_NewsTableAdapter NewsAdapter
        {
            get
            {
                if (_newsAdapter == null)
                {
                    _newsAdapter = new View_UserNews_NewsTableAdapter();
                }
                return _newsAdapter;
            }
        }
        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
        public DB_SJW.View_UserNews_NewsDataTable GetDataNewsOP()
        {
            return NewsAdapter.GetData();
        }

        private T_UserNewsTableAdapter _usernewsAdapter = null;
        protected T_UserNewsTableAdapter UserNewsAdapter
        {
            get
            {
                if(_usernewsAdapter==null)
                {
                    _usernewsAdapter = new T_UserNewsTableAdapter();
                }
                return _usernewsAdapter;
            }
        }
        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)]
        public bool DeleteUserNewsByID(int original_F_ID)
        {
          
            int result = Convert.ToInt32(UserNewsAdapter.ScalarByID(original_F_ID));
            if (result == 0)
            { return false; }           
            int rowAffected = UserNewsAdapter.DeleteByID(original_F_ID);
            return rowAffected == 1;
        }

        private View_UserNews_ProxyTableAdapter _proxyAdapter = null;
        protected View_UserNews_ProxyTableAdapter ProxyAdapter
        {
            get
            {
                if (_proxyAdapter == null)
                { _proxyAdapter = new View_UserNews_ProxyTableAdapter(); }
                return _proxyAdapter;
            }
        }
        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
        public DB_SJW.View_UserNews_ProxyDataTable GetDataProxyOP()
        {
            return ProxyAdapter.GetData();
        }

        private View_UserNews_CooperationTableAdapter _cooperationAdapter = null;
        protected View_UserNews_CooperationTableAdapter CooperationAdapter
        {
            get
            {
                if (_cooperationAdapter == null)
                { _cooperationAdapter = new View_UserNews_CooperationTableAdapter(); }
                return _cooperationAdapter;
            }
        }
        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
        public DB_SJW.View_UserNews_CooperationDataTable GetDataCooperationOP()
        {
            return CooperationAdapter.GetData();
        }

        private View_UserNews_UnfoldsTableAdapter _unfoldsAdapter = null;
        protected View_UserNews_UnfoldsTableAdapter UnfoldsAdapter
        {
            get
            {
                if (_unfoldsAdapter == null)
                { _unfoldsAdapter = new View_UserNews_UnfoldsTableAdapter(); }
                return _unfoldsAdapter;
            }
        }
        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
        public DB_SJW.View_UserNews_UnfoldsDataTable GetDataUnfoldsOP()
        {
            return UnfoldsAdapter.GetData();
        }

        private View_UserNews_employmentTableAdapter _employmentAdapter = null;
        protected View_UserNews_employmentTableAdapter EmploymentAdapter
        {
            get
            {
                if (_employmentAdapter == null)
                { _employmentAdapter = new View_UserNews_employmentTableAdapter(); }
                return _employmentAdapter;
            }
        }
        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
        public DB_SJW.View_UserNews_employmentDataTable GetDataEmploymentOP()
        {
            return EmploymentAdapter.GetData();
        }

     
    }
    [System.ComponentModel.DataObject]
    public class ProductOP
    {
        private T_ProductInfoTableAdapter _productAdapter = null;
        protected T_ProductInfoTableAdapter ProductAdapter
        {
            get
            {
                if (_productAdapter == null)
                {
                    _productAdapter = new T_ProductInfoTableAdapter();
                }
                return _productAdapter;
            }
        }
        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Delete, true)]
        public bool DeleteProductByID(int original_F_ID)
        {

            int result = Convert.ToInt32(ProductAdapter.ScalarByID(original_F_ID));
            if (result == 0)
            { return false; }
            int rowAffected = ProductAdapter.ProductDeleteByID(original_F_ID);
            return rowAffected == 1;
        }
        private View_Product_BuyTableAdapter _buyAdapter = null;
        protected View_Product_BuyTableAdapter BuyAdapter
        {
            get
            {
                if (_buyAdapter == null)
                { _buyAdapter = new View_Product_BuyTableAdapter(); }
                return _buyAdapter;
            }
        }
        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
        public DB_SJW.View_Product_BuyDataTable GetDataBuyOP()
        {
            return BuyAdapter.GetData();
        }

        private View_Product_SupplyTableAdapter _supplyAdapter = null;
        protected View_Product_SupplyTableAdapter SupplyAdapter
        {
            get
            {
                if (_supplyAdapter == null)
                { _supplyAdapter = new View_Product_SupplyTableAdapter(); }
                return _supplyAdapter;
            }
        }
        [System.ComponentModel.DataObjectMethodAttribute(System.ComponentModel.DataObjectMethodType.Select, true)]
        public DB_SJW.View_Product_SupplyDataTable GetDataSupplyOP()
        {
            return SupplyAdapter.GetData();
        }
    }

}