using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
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_StaffBLL
    {
        IOA_StaffDAL idal_IOA_StaffDAL = null;

        public OA_StaffBLL()
        {
            idal_IOA_StaffDAL = Factory.GetDALByInterfaceName(DALInterface.IOA_StaffDAL) as IOA_StaffDAL;
        }

        /// <summary>
        /// 添加
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InsertModel(Model.OA_Staff model)
        {
            return idal_IOA_StaffDAL.InserModel(model);
        }

        /// <summary>
        /// 更新
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateModel(Model.OA_Staff model)
        {

            return idal_IOA_StaffDAL.UpdateModel(model);
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool DeleteModel(Model.OA_Staff model)
        {

            return idal_IOA_StaffDAL.DeleteModel(model);
        }

        /// <summary>
        /// 根据编号获得信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public OA_Staff GetModelByKeyid(int? Keyid)
        {
            return idal_IOA_StaffDAL.GetModelByKeyid(Keyid);
        }

        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="pagination"></param>
        /// <param name="DepartmentId"></param>
        /// <param name="MemberId"></param>
        /// <param name="MemberName"></param>
        /// <param name="Status"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_Staff> SelectModelPage(Infrastructure.Query.Pagination pagination, int? DepartmentId, Guid MemberId, string MemberName, string Status)
        {
          var ssss  =  idal_IOA_StaffDAL.SelectModelPage(pagination, DepartmentId, MemberId, MemberName, Status);

            OA_FirmRoleBLL bll_OA_FirmRoleBLL = new OA_FirmRoleBLL();
            foreach (var oA_Staff   in ssss)
            {
              var sss =  bll_OA_FirmRoleBLL.SelectOA_StaffRoleRel(oA_Staff.Keyid);
                if(sss != null)
                {
                 var ssssss =   bll_OA_FirmRoleBLL.SelectModel(sss.RoleId);
                    if (ssssss != null)
                    {
                        oA_Staff.RoleName = ssssss.RoleName;
                    }
                   
                }
            }
            return ssss;
        }

        /// <summary>
        /// 更新员工信息
        /// </summary>
        /// <param name="m_OA_Staff"></param>
        /// <param name="m_EC_MemberBasic"></param>
        /// <returns></returns>
        public bool UpdateStaff(OA_Staff m_OA_Staff, EC_MemberBasic m_EC_MemberBasic, OA_StaffRoleRel m_OA_StaffRoleRel)
        {
            return idal_IOA_StaffDAL.UpdateStaff(m_OA_Staff, m_EC_MemberBasic, m_OA_StaffRoleRel);
        }

        /// <summary>
        /// 添加员工信息
        /// </summary>
        /// <param name="m_OA_Staff"></param>
        /// <param name="m_EC_MemberBasic"></param>
        /// <returns></returns>
        public bool AddStaff(OA_Staff m_OA_Staff, EC_MemberBasic m_EC_MemberBasic, OA_StaffRoleRel m_OA_StaffRoleRel)
        {
            return idal_IOA_StaffDAL.AddStaff(m_OA_Staff, m_EC_MemberBasic, m_OA_StaffRoleRel);
        }

        /// <summary>
        /// 根据员工会员编号获得信息
        /// </summary>
        /// <param name="MemberId">编号</param>
        /// <returns></returns>
        public OA_Staff GetModelByMemberId(Guid MemberId)
        {
            return idal_IOA_StaffDAL.GetModelByMemberId(MemberId);
        }

        /// <summary>
        /// 根据厂商编号获取员工列表
        /// </summary>
        /// <param name="FirmId"></param>
        /// <param name="IsBusinessManager"></param>
        /// <param name="IsAccountManager"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_Staff> SelectListByFirmId(Guid FirmId, bool? IsBusinessManager, bool? IsAccountManager)
        {
            return idal_IOA_StaffDAL.SelectListByFirmId(FirmId, IsBusinessManager, IsAccountManager);
        }

        /// <summary>
        /// 检测员工姓名是否重复
        /// </summary>
        /// <param name="Name"></param>
        /// <param name="MemberId"></param>
        /// <returns></returns>
        public int IsExitsName(string Name, Guid MemberId)
        {
            return idal_IOA_StaffDAL.IsExitsName(Name,MemberId);
        }

        /// <summary>
        /// 根据部门获取员工
        /// </summary>
        /// <returns></returns>
        public DataTable GetStaffByDep(Guid FirmId,string DepartmentId)
        {

            return idal_IOA_StaffDAL.GetStaffByDep(FirmId,DepartmentId);
        }

        /// <summary>
        /// 生日提醒
        /// </summary>
        /// <param name="pagination"></param>
        /// <param name="DepartmentId"></param>
        /// <param name="MemberId"></param>
        /// <param name="MemberName"></param>
        /// <param name="Status"></param>
        /// <returns></returns>
        public IEnumerable<Model.OA_Staff> BirthdayRemind(Infrastructure.Query.Pagination pagination, int? DepartmentId, Guid MemberId, string MemberName, string Status)
        {
            return idal_IOA_StaffDAL.BirthdayRemind(pagination, DepartmentId, MemberId, MemberName, Status);
        }
    }
}