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


using System; 
using System.Collections.Generic; 
 
using System.Data; 
 
 
using MyShop.DALFactory; 
using MyShop.IDAL; 
using MyShop.Model; 
 
namespace MyShop.BLL 
{ 
    public class Order 
    { 
        private IOrder dal = DataAccess.CreateOrder(); 
         
        #region IOrder 
 
 
        ///  
        /// 添加记录 
        ///  
        ///  
        /// 返回刚插入的记录的orderId 
        public int Add(OrderInfo model) 
        { 
            if (model == null) 
            { 
                return -1; 
            } 
            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 OrderInfo 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(OrderInfo 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(OrderInfo model, out string msg) 
        { 
            msg = ""; 
            if (model == null) 
            { 
                msg = "
  • 数据不能为空
    • "; 
                return -1; 
            } 
            return Add(model); 
        } 
 
        public int Delete(int orderId) 
        { 
            if ( string.IsNullOrEmpty( orderId.ToString()) ) 
                return 0; 
            string filer; 
            filer = " orderId =" + orderId; 
            return Delete(filer); 
        } 
        public int Update(OrderInfo model) 
        { 
 
            if (model == null) 
            { 
                return 0; 
            } 
            string filter; 
            filter = " orderId=" + model.orderId; 
            return Update(model, filter); 
        } 
 
        public OrderInfo GetModel(int orderId) 
        { 
            DataSet dataset = new DataSet(); 
            dataset = GetDataSet(" orderId=" + orderId); 
            if (dataset != null && dataset.Tables[0].Rows.Count > 0) 
                return GetModel(dataset.Tables[0].Rows[0]); 
            return null; 
 
        } 
 
 
 
        #endregion   
   
        public DataSet GetDataSet(int userId) 
        { 
            string filter = ""; 
            if (userId == -1) 
                return null; 
            filter = " [clientId]= " + userId; 
            return dal.GetDataSet(filter); 
        } 
        public DataSet GetDataSetByOrderNum(string orderNum) 
        { 
            if (orderNum == string.Empty) 
                return null; 
            string filter; 
            filter = " [orderNum]='" + orderNum + "'"; 
            return dal.GetDataSet(" orderNum='" + orderNum + "'"); 
        } 
        public OrderInfo GetModel(string orderNum) 
        { 
            if ( string.IsNullOrEmpty( orderNum )) 
                return null; 
            if (GetDataSetByOrderNum(orderNum).Tables[0].Rows.Count == 0) 
                return null; 
            return GetModel(GetDataSetByOrderNum(orderNum).Tables[0].Rows[0]);   
        } 
 
        ///  
        /// 是否已付清 
        ///  
        ///  
        ///  
        public bool IsPaid(int orderId) 
        { 
            OrderInfo model = new OrderInfo(); 
            Order order = new Order(); 
            model = order.GetModel(orderId); 
            if (model == null) 
                return true; //订单号码错误，直接返回true 
            if (model.status == 3 || model.moneyTotal == model.MoneyReceipt ) 
                return true; 
            else 
                return false; 
        } 
 
        ///  
        /// 是否已付清 
        ///  
        ///  
        ///  
        public bool IsPaid(string orderNum) 
        { 
            OrderInfo model = new OrderInfo(); 
            Order order = new Order(); 
            model = order.GetModel(orderNum); 
            if (model == null) 
                return true; //订单号码错误，直接返回true 
            if (model.status == 3 || model.moneyTotal == model.MoneyReceipt) 
                return true; 
            else 
                return false; 
        } 
 
        #region SearchOrder 
        ///  
        /// 快速搜索 
        ///  
        ///  
        ///  
        public DataSet QuickSearch(int searchType) 
        { 
            return dal.QuickSearch(searchType); 
 
        } 
 
        ///  
        /// 高级查询 
        ///  
        ///  
        ///  
        ///  
        public DataSet KeywordsSearch(string field, string keywords) 
        { 
            field = Utils.ReplaceBadSQL(field.Trim()); 
            keywords = Utils.ReplaceBadSQL(keywords.Trim()); 
            if (string.IsNullOrEmpty(field) || string.IsNullOrEmpty(keywords)) 
                return null; 
            return dal.KeywordsSearch( field, keywords); 
        } 
 
        #endregion 
 
        public DataSet GetDataSetByProductId(int productId) 
        { 
            if(string.IsNullOrEmpty(productId.ToString())) 
                return null; 
            return GetDataSet(" productId =" + productId); 
        } 
 
        public DataSet GetDataSetByOrderId(int orderId) 
        { 
            DataSet dataset = new DataSet(); 
            dataset = GetDataSet(" orderId=" + orderId); 
            return dataset; 
        } 
 
        #region  
 
        public int DeleteOrderByOrderId(int orderId) 
        { 
            return dal.DeleteOrderByOrderId(orderId); 
        } 
 
        ///  
        /// 当订单结清时，赠送相应会员购物积分 
        ///  
        ///  
        ///  
        public int AddUserExp(int orderId) 
        { 
            return dal.AddUserExp(orderId); 
        } 
 
        public DataSet GetDataSetOrderByDate() 
        { 
           return dal.GetDataSetOrderByDate(); 
        } 
        #endregion 
 
 
        ///  
        /// 获取今日订单 
        ///  
        ///  
        ///  
        public  DataSet GetTodayOrder(int userId) 
        { 
 
            return dal.GetTodayOrder(userId); 
        } 
 
    } 
}