www.pudn.com > MyShop.rar > Bank.cs

using System; 
using System.Collections.Generic; 
 
using System.Data; 
 
 
using MyShop.DALFactory; 
using MyShop.IDAL; 
using MyShop.Model; 
 
namespace MyShop.BLL 
{ 
     public  class Bank 
    { 
 
        private IBank dal = DataAccess.CreateBank(); 
 
        #region IBank 
 
        public int Add(BankInfo model) 
        { 
            if (model == null) 
            { 
                return 0; 
            } 
            return dal.Add(model); 
        } 
 
        public int Delete(string filter) 
        { 
            if (string.IsNullOrEmpty(filter)) 
                return 0; 
            return dal.Delete(filter); 
        } 
 
        public bool Exist(string filter) 
        { 
            filter = filter.Trim(); 
            if (string.IsNullOrEmpty(filter)) 
                return false; 
            return dal.Exist(filter); 
        } 
        public DataSet GetDataSet() 
        { 
            return dal.GetDataSet(); 
        } 
 
        public DataSet GetDataSet(string filter) 
        { 
            filter = filter.Trim(); 
            if (string.IsNullOrEmpty(filter)) 
                return null; 
            return dal.GetDataSet(filter); 
        } 
 
        public BankInfo GetModel(DataRow dr) 
        { 
            if (dr == null) 
                return null; 
            return dal.GetModel(dr); 
        } 
 
        private DataSet Query(string sql) 
        { 
            sql = sql.Trim(); 
            if (string.IsNullOrEmpty(sql)) 
                return null; 
            return dal.Query(sql); 
        } 
 
        public int Update(BankInfo model, string filter) 
        { 
            if (model == null) 
                return 0; 
            filter = filter.Trim(); 
            if (string.IsNullOrEmpty(filter)) 
                return 0; 
            return dal.Update(model, filter); 
        } 
 
        #endregion 
 
        #region common 
 
        public int Add(BankInfo model, out string msg) 
        { 
            msg = ""; 
            if (model == null) 
            { 
                msg = msg + "
数据不能为空
"; 
                return 0; 
            } 
            bool isErr = false; 
 
            if (string.IsNullOrEmpty(model.BankName.Trim())) 
            { 
                msg = msg + "
名称不能为空
"; 
                isErr = true; 
            } 
            if (isErr) 
                return 0; 
 
            int count = 0; 
            count = Add(model); 
            if (count == 0) 
                msg = "
系统发生错误,请重新添加!
"; 
            if (count == 1) 
                msg = "
添加成功!
"; 
            return count; 
        } 
 
        public int Delete(int bankID) 
        { 
            if (string.IsNullOrEmpty(bankID.ToString())) 
                return 0; 
            string filer; 
            filer = " bankID =" + bankID; 
            return Delete(filer); 
        } 
        public int Update(BankInfo model) 
        { 
 
            if (model == null) 
            { 
                return 0; 
            } 
            string filter; 
            filter = " bankID=" + model.BankID; 
            return Update(model, filter); 
        } 
 
        public BankInfo GetModel(int bankID) 
        { 
            DataSet dataset = new DataSet(); 
            dataset = GetDataSet(" bankId=" + bankID); 
            if (dataset != null && dataset.Tables[0].Rows.Count > 0) 
                return GetModel(dataset.Tables[0].Rows[0]); 
            return null; 
        } 
 
         public BankInfo GetModel(string BankShortName) 
         { 
             if (string.IsNullOrEmpty(BankShortName)) 
                 return null; 
             DataSet dataset = new DataSet(); 
             dataset = GetDataSet(" BankShortName='" + BankShortName + "'"); 
             if (dataset != null && dataset.Tables[0].Rows.Count > 0) 
                 return GetModel(dataset.Tables[0].Rows[0]); 
             return null; 
         } 
 
        #endregion 
 
 
 
        #region 后台管理 
        public DataSet GetDataSetOrderByOrderId() 
        { 
            return GetDataSet(" BankID > 0 Order by  OrderId  "); 
        } 
         /// 
 
         /// 可用的银行 
         /// 
 
         ///  
        public DataSet GetDataSetEnabledOrderByOrderId() 
        { 
            return GetDataSet(" ([IsDisabled] = 0) ORDER BY [IsDefault] DESC,[OrderID] "); 
        } 
 
        /// 
 
        /// 把为bankId的记录改为默认,同时将其它记录改为不是默认 
        /// 
 
        ///  
        ///  
         public int MakeDefault(int BankID) 
        { 
            string filter = " [Isdefault] = 1 "; 
            DataSet dataset = new DataSet(); 
            BankInfo model = new BankInfo(); 
 
            dataset = GetDataSet(filter); 
            //把其它的改为不是默认 
            if (dataset.Tables[0].Rows.Count > 0) 
            { 
                for (int i = 0; i < dataset.Tables[0].Rows.Count; i++) 
                { 
                    model = GetModel(dataset.Tables[0].Rows[i]); 
                    model.IsDefault = 0; 
                    Update(model); 
                } 
            } 
 
            model = GetModel(BankID); 
            model.IsDefault = 1; 
            return Update(model); 
        } 
 
        /// 
 
        /// 检查银行名称是否存在 
        /// 
 
        ///  
        ///  
         public bool IsExist(string BankShortName) 
        { 
            BankShortName = Utils.ReplaceBadSQL(BankShortName.Trim()); 
            if (string.IsNullOrEmpty(BankShortName)) 
                return false; 
            string filter = " BankShortName='" + BankShortName + "'"; 
 
            return Exist(filter); 
        } 
 
 
        #endregion 
    } 
 
}