using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY.IDAL;
using CY.Model;
using AbstractFactory;
using CY.IBaseDAL;
using CY.Infrastructure.DESEncrypt;
using CY.Infrastructure.Query;

namespace CY.BLL.OA
{
    public class OA_YujihuikuanBLL
    {
        IOA_YujihuikuanDAL _IOA_YujihuikuanDAL = null;

        /// <summary>
        /// 初始化构造
        /// </summary>
        public OA_YujihuikuanBLL()
        {
            //获取OA_Yujihuikuan DAL实现
            _IOA_YujihuikuanDAL = Factory.GetDALByInterfaceName(DALInterface.IOA_YujihuikuanDAL) as IOA_YujihuikuanDAL;


        }

        /// <summary>
        /// 新增送货安排
        /// </summary>
        /// <param name="rType"></param>
        /// <param name="m_OA_CustomerCommunications"></param>
        /// <param name="m_EC_AcceptWayByCustomers"></param>
        /// <returns></returns>
        public bool InsertModel(CY.Model.OA_Yujihuikuan m_OA_Yujihuikuan)
        {
            try
            {

                return _IOA_YujihuikuanDAL.InserModel(m_OA_Yujihuikuan);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 修改送货安排
        /// </summary>
        /// <param name="rType"></param>
        /// <returns></returns>
        public bool UpdateModel(CY.Model.OA_Yujihuikuan m_OA_Yujihuikuan)
        {
            try
            {
                return _IOA_YujihuikuanDAL.UpdateModel(m_OA_Yujihuikuan);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 获取全部合作客户
        /// </summary>
        /// <param name="Keyid">主键id</param>
        /// <returns></returns>
        public IEnumerable<OA_Yujihuikuan> GetModelList()
        {
            Query query = new Query();
            return _IOA_YujihuikuanDAL.SelectAllModel(query);
        }


        

        /// <summary>
        /// 获取全部合作客户
        /// </summary>
        /// <param name="Keyid">主键id</param>
        /// <returns></returns>
        public OA_Yujihuikuan GetModelByKeyid(Guid? keyid, Guid? BuyerId, string shoukuanshijian = "")
        {

            return _IOA_YujihuikuanDAL.GetModelByKeyid(keyid, BuyerId, shoukuanshijian);
        }

        /// <summary>
        /// 删除合作客户
        /// </summary>
        /// <param name="rType"></param>
        /// <returns></returns>
        public bool DeleteModel(CY.Model.OA_Yujihuikuan rType)
        {
            try
            {
                _IOA_YujihuikuanDAL.DeleteModel(rType);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 查询合作客户分页列表
        /// </summary>
        /// <param name="pa"></param>
        /// <returns></returns>
        public IEnumerable<OA_Yujihuikuan> SelectModelPage(Pagination pa, Guid FirmId, string CreateTimeStart, string CreateTimeEnd,
  string Kaipiaoshenqing, string Kehuqianshou, string BusinessManagerId, string CustormerName)
        {
            string Condition = " and ok.FirmId ='" + FirmId + "'  ";

            if (!string.IsNullOrEmpty(CreateTimeStart))
                Condition += " and DATEDIFF(day,ok.[CreateTime],'" + CreateTimeStart + "')<=0 ";

            if (!string.IsNullOrEmpty(CreateTimeEnd))
                Condition += " and DATEDIFF(day,ok.[CreateTime],'" + CreateTimeEnd + "')>=0 ";

            if (!string.IsNullOrEmpty(Kaipiaoshenqing))
                Condition += " and  ok.Kaipiaoshenqing = '" + Kaipiaoshenqing + "'";
            if (!string.IsNullOrEmpty(Kehuqianshou))
                Condition += " and  ok.Kehuqianshou = '" + Kehuqianshou + "'";
            if (!string.IsNullOrEmpty(BusinessManagerId))
                Condition += " and  ok.BusinessManagerId = '" + BusinessManagerId + "'";
            if (!string.IsNullOrEmpty(CustormerName))
                Condition += " and  oe.CompanyName like '%" + CustormerName + "%'";

            Query query = new Query();
            IList<Criterion> criterias = new List<Criterion>()
            {
                new Criterion("", Condition),

                new Criterion("orderBy"," SellerOrderId desc   ")
            };
            query.Criteria = criterias;
            return _IOA_YujihuikuanDAL.SelectModelPage(query, pa);
        }


    }
}