/**  
* OA_DriverRecordBLL.cs
*
* 功 能： 合作客户业务逻辑类
* 类 名： OA_DriverRecordBLL
*
* 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_DriverRecordBLL
    {
        IOA_DriverRecordDAL _IOA_DriverRecordDAL = null;

        /// <summary>
        /// 初始化构造
        /// </summary>
        public OA_DriverRecordBLL()
        {
            //获取OA_DriverRecord DAL实现
            _IOA_DriverRecordDAL = Factory.GetDALByInterfaceName(DALInterface.IOA_DriverRecordDAL) as IOA_DriverRecordDAL;


        }

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


       

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

            return _IOA_DriverRecordDAL.GetModelByKeyid(keyid);
        }

         
        /// <summary>
        /// 查询合作客户分页列表
        /// </summary>
        /// <param name="pa"></param>
        /// <returns></returns>
        public IEnumerable<OA_DriverRecord> SelectModelPage(Pagination pa, string CreatTimeStart, string CreatTimeEnd,
            string CarID, string CreaterName,string ClockType)
        {
            string Condition = "  ";
            string sort = " CreatTime desc   ";


            if (!string.IsNullOrEmpty(CreatTimeStart))
            {
                Condition += " and DATEDIFF(day,'" + CreatTimeStart + "',od.[CreatTime]) >= 0    ";
              
            }

            if (!string.IsNullOrEmpty(CreatTimeEnd))
            {
                Condition += " and DATEDIFF(day,'" + CreatTimeEnd + "',od.[CreatTime]) <= 0    ";
             
            }


            if (!string.IsNullOrEmpty(CarID))
                Condition += " and  od.CarID = " + CarID + "";
            if (!string.IsNullOrEmpty(ClockType))
                Condition += " and  od.ClockType = " + ClockType + "";
            

            if (!string.IsNullOrEmpty(CreaterName))
                Condition += " and  od.Creater like '%" + CreaterName + "%'";


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

                new Criterion("orderBy",sort)
            };
            query.Criteria = criterias;
            return _IOA_DriverRecordDAL.SelectModelPage(query, pa);
        }


 
    }
}