/**  
* OA_BaozhengjinBLL.cs
*
* 功 能： 合作客户业务逻辑类
* 类 名： OA_BaozhengjinBLL
*
* Ver    变更日期             负责人  变更内容
* ───────────────────────────────────
* V0.01  2013-4-2 15:11       吴辉      初版
* V0.02  2013-5-29 17:43      吴崎均    增加转换在线会员为厂商客户方法 
*
*
*
*
*
*
*/
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
{
    public class OA_BaozhengjinBLL
    {
        IOA_BaozhengjinDAL _IOA_BaozhengjinDAL = null;

        /// <summary>
        /// 初始化构造
        /// </summary>
        public OA_BaozhengjinBLL()
        {
            //获取OA_Baozhengjin DAL实现
            _IOA_BaozhengjinDAL = Factory.GetDALByInterfaceName(DALInterface.IOA_BaozhengjinDAL) as IOA_BaozhengjinDAL;


        }

        /// <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_Baozhengjin m_OA_Baozhengjin)
        {
            try
            {

                return _IOA_BaozhengjinDAL.InserModel(m_OA_Baozhengjin);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

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

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


        /// <summary>
        /// 根据formid获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public IEnumerable<Model.OA_Baozhengjin> GetModelByformid(Guid formid)
        {

            return _IOA_BaozhengjinDAL.GetModelByformid(formid);
        }

        /// <summary>
        /// 获取全部合作客户
        /// </summary>
        /// <param name="Keyid">主键id</param>
        /// <returns></returns>
        public OA_Baozhengjin GetModelByKeyid(int keyid)
        {

            return _IOA_BaozhengjinDAL.GetModelByKeyid(keyid);
        }

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

        /// <summary>
        /// 查询合作客户分页列表
        /// </summary>
        /// <param name="pa"></param>
        /// <returns></returns>
        public IEnumerable<OA_Baozhengjin> SelectModelPage(Pagination pa, Guid FirmId, string CreateTimeStart, string CreateTimeEnd,
   string Zhanghuleixing, string Fukuanzhanghu, string Shoukuandanwei, string remark, string TuikuanStatus)
        {
            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(Zhanghuleixing))
                Condition += " and  ok.ReceiveWay = '" + Zhanghuleixing + "'";

            if (!string.IsNullOrEmpty(Fukuanzhanghu))
                Condition += " and  ok.Account = " + Fukuanzhanghu + "    ";
            if (!string.IsNullOrEmpty(Shoukuandanwei))
                Condition += " and  ok.Shoukuandanwei like '%" + Shoukuandanwei + "%'    ";
            if (!string.IsNullOrEmpty(remark))
                Condition += " and  ok.remark   like '%" + remark + "%' ";
            if (!string.IsNullOrEmpty(TuikuanStatus))
                Condition += " and  ok.[TuikuanStatus] = '" + TuikuanStatus + "'";

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

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


        /// <summary>
        /// 查询合作客户分页列表
        /// </summary>
        /// <param name="pa"></param>
        /// <returns></returns>
        public IEnumerable<OA_Baozhengjin> SelectModelPageweikaipiao(Pagination pa, Guid FirmId, string CreateTimeStart, string CreateTimeEnd,
   string Creater, string SupplierName, string shifoufukuan, string selFukuanyongtu)
        {
            string Condition = " and ok.FirmId ='" + FirmId + "' and ok.ApprovalStatus = 1 and ok.Youwufapiao !=2 and ok.FukuanStatus = 2 ";

            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(Creater))
                Condition += " and  ok.Creater like '%" + Creater + "%'";

            if (!string.IsNullOrEmpty(SupplierName))
                Condition += " and  ok.SupplierName like '%" + SupplierName + "%'    ";
            if (!string.IsNullOrEmpty(shifoufukuan))
                Condition += " and  ok.FukuanStatus = '" + shifoufukuan + "'";
            if (!string.IsNullOrEmpty(selFukuanyongtu))
                Condition += " and  ok.[Fukuanyongtu] = '" + selFukuanyongtu + "'";

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

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

    }
}