using System;
using System.Collections.Generic;

using System.Data;

using MyShop.DALFactory;
using MyShop.IDAL;
using MyShop.Model;

namespace MyShop.BLL
{
    public class OrderItem
    {
        private IOrderItem dal = DataAccess.CreateOrderItem();

        private ConfigInfo configInfo = new ConfigInfo();
        private string tableName = "Ljh_OrderItems";
        public OrderItem()
        {
            Config config = new Config();
            configInfo = config.GetModel();
            if (!string.IsNullOrEmpty(configInfo.TablePrefix.Trim()))
                tableName = configInfo.TablePrefix + "OrderItems";
        }

        #region IOrderItem


        /// <summary>
        /// 添加记录
        /// </summary>
        /// <param name="model"></param>
        /// <returns>返回刚插入的记录的itemId</returns>
        public int Add(OrderItemInfo 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 OrderItemInfo 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(OrderItemInfo 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(OrderItemInfo model, out string msg)
        {
            msg = "";
            if (model == null)
            {
                msg = "<li>数据不能为空</li>";
                return 0;
            }
            return Add(model);
        }

        public int Delete(int itemId)
        {
            if (string.IsNullOrEmpty(itemId.ToString()))
                return 0;
            string filer;
            filer = " itemId =" + itemId;
            return Delete(filer);
        }
        public int Update(OrderItemInfo model)
        {

            if (model == null)
            {
                return 0;
            }
            string filter;
            filter = " itemId=" + model.ItemId;
            return Update(model, filter);
        }

        public OrderItemInfo GetModel(int itemId)
        {
            DataSet dataset = new DataSet();
            dataset = GetDataSet(" itemId=" + itemId);
            if (dataset != null && dataset.Tables[0].Rows.Count > 0)
                return GetModel(dataset.Tables[0].Rows[0]);
            return null;

        }

        public DataSet GetDataSet(int orderId)
        {
            string filter = " orderId=" + orderId;
            return GetDataSet(filter);
        }



        #endregion


        public DataSet GetDataSetByProductId(int productId)
        {
            return GetDataSet(" productId=" + productId);
        }


        public int DeleteByOrderId(int orderId)
        {
            string filter = " orderId =" + orderId;
            return Delete(filter);
        }


        #region SearchOrderItem
        /// <summary>
        /// 销售明细快速搜索
        /// </summary>
        /// <param name="searchType"></param>
        /// <returns></returns>
        public DataSet QuickSearch(int searchType)
        {
            
            
            return dal.QuickSearch(searchType);

        }

        /// <summary>
        /// 销售明细高级查询
        /// </summary>
        /// <param name="field"></param>
        /// <param name="keywords"></param>
        /// <returns></returns>
        public DataSet KeywordsSearch(string field, string keywords)
        {
            field = Utils.ReplaceBadSQL(field.Trim().ToLower());
            keywords = Utils.ReplaceBadSQL(keywords.ToLower().Trim());
            if (string.IsNullOrEmpty(field) || string.IsNullOrEmpty(keywords))
                return null;
            return dal.KeywordsSearch(field, keywords);
        }

        /// <summary>
        /// 所有商品销售统计
        /// </summary>
        /// <returns></returns>
        public DataSet SaleCount(int countType)
        {
            return dal.SaleCount(countType);
        }


        /// <summary>
        /// 商品销售统计快速搜索
        /// </summary>
        /// <param name="searchType"></param>
        /// <returns></returns>
        public DataSet SaleCount_QuickSearch(int searchType,int countType)
        {
            
            return dal.SaleCount_QuickSearch(searchType,countType);

        }


        /// <summary>
        /// 商品销售统计高级查询
        /// </summary>
        /// <param name="field"></param>
        /// <param name="keywords"></param>
        /// <returns></returns>
        public DataSet SaleCount_KeywordsSearch(string field, string keywords,int countType)
        {
            field = Utils.ReplaceBadSQL(field.Trim().ToLower());
            keywords = Utils.ReplaceBadSQL(keywords.ToLower().Trim());
            if (string.IsNullOrEmpty(field) || string.IsNullOrEmpty(keywords))
                return null;
            return dal.SaleCount_KeywordsSearch(field, keywords,countType);
        }
        #endregion
    }
}