using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using CY.IDAL;
using System.Data.SqlClient;
using System.Data;
using CY.Model;

namespace CY.SQLDAL
{
    public class Sys_Permissions_RoleMenuRelationDAL : ISys_Permissions_RoleMenuRelationDAL
    {

        private Database _dataBase = null;

        public Sys_Permissions_RoleMenuRelationDAL()
        {
            _dataBase = new Database();
        }

        public Sys_Permissions_RoleMenuRelationDAL(Database dDatabase)
        {
            _dataBase = dDatabase;
        }

        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.Sys_Permissions_RoleMenuRelation trueModel = model as Model.Sys_Permissions_RoleMenuRelation;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                	new SqlParameter("RoleId",trueModel.RoleId),
					new SqlParameter("FuncId",trueModel.FuncId),
					new SqlParameter("MenuIdOne",trueModel.MenuIdOne),
					new SqlParameter("MenuIdTwo",trueModel.MenuIdTwo),
					new SqlParameter("MenuIdThree",trueModel.MenuIdThree)
            };
            try
            {
                _dataBase.Query("sp_Sys_Permissions_RoleMenuRelation_Insert", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 修改
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool UpdateModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.Sys_Permissions_RoleMenuRelation trueModel = model as Model.Sys_Permissions_RoleMenuRelation;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                	new SqlParameter("RoleId",trueModel.RoleId),
					new SqlParameter("FuncId",trueModel.FuncId),
					new SqlParameter("MenuIdOne",trueModel.MenuIdOne),
					new SqlParameter("MenuIdTwo",trueModel.MenuIdTwo),
					new SqlParameter("MenuIdThree",trueModel.MenuIdThree)
            };
            try
            {
                _dataBase.Query("sp_Sys_Permissions_RoleMenuRelation_Update", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 删除
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        public bool DeleteModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.Sys_Permissions_RoleMenuRelation trueModel = model as Model.Sys_Permissions_RoleMenuRelation;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                new SqlParameter("@RoleId",trueModel.RoleId)
            };
            try
            {
                _dataBase.Query("sp_Sys_Permissions_RoleMenuRelation_DeleteRow", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return true;
        }

        /// <summary>
        /// 分页查询
        /// </summary>
        /// <param name="query"></param>
        /// <param name="pagination"></param>
        /// <returns></returns>
        public IEnumerable<Model.Sys_Permissions_RoleMenuRelation> SelectModelPage(Infrastructure.Query.Query query, Infrastructure.Query.Pagination pagination)
        {
            throw new NotImplementedException();
        }

        /// <summary>
        /// 单个查询
        /// </summary>
        /// <param name="query"></param>
        /// <returns></returns>
        public IEnumerable<Model.Sys_Permissions_RoleMenuRelation> SelectAllModel(Infrastructure.Query.Query query)
        {
            throw new NotImplementedException();
        }

        /// <summary>
        /// 根据角色查询全部关系
        /// </summary>
        /// <param name="RoleId">编号</param>
        /// <returns></returns>
        public IEnumerable<Sys_Permissions_RoleMenuRelation> SelectListByRoleId(int? RoleId)
        {
            try
            {
                IList<Sys_Permissions_RoleMenuRelation> result = _dataBase.SelectModel<Sys_Permissions_RoleMenuRelation>("*", "Sys_Permissions_RoleMenuRelation", string.Format(" RoleId='{0}' ", RoleId)) as IList<Sys_Permissions_RoleMenuRelation>;//执行查询
                return result;//返回结果
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 根据角色和菜单编号查询全部关系
        /// </summary>
        /// <param name="RoleId"></param>
        /// <param name="MenuIdOne"></param>
        /// <param name="MenuIdTwo"></param>
        /// <param name="MenuIdThree"></param>
        /// <returns></returns>
        public Sys_Permissions_RoleMenuRelation SelectModelByRoleIdAndMenuId(int? RoleId, int? MenuIdOne, int? MenuIdTwo, int? MenuIdThree)
        {
            try
            {
                IList<Sys_Permissions_RoleMenuRelation> result = _dataBase.SelectModel<Sys_Permissions_RoleMenuRelation>("*", "Sys_Permissions_RoleMenuRelation", string.Format(" RoleId='{0}' and MenuIdOne='{1}' and MenuIdTwo='{2}' and MenuIdThree='{3}' ", RoleId, MenuIdOne, MenuIdTwo, MenuIdThree)) as IList<Sys_Permissions_RoleMenuRelation>;//执行查询
                if (result != null && result.Count > 0)
                {
                    return result[0];
                }
                else
                {
                    return null;
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }


        /// <summary>
        /// 更新菜单时，自动更新用户权限
        /// </summary>
        /// <param name="MenuIdOne"></param>
        /// <param name="MenuIdTwo"></param>
        /// <param name="MenuIdThree"></param>
        /// <returns></returns>
        public bool UpdateMenuToMember(int? MenuIdOne, int? MenuIdTwo, int? MenuIdThree)
        {
            try
            {
                int? result_1 = _dataBase.ExecuteSql("UPDATE Sys_Permissions_RoleMenuRelation SET MenuIdOne = '" + MenuIdTwo + "' WHERE MenuIdTwo ='" + MenuIdThree + "' ");
                int? result_2 = _dataBase.ExecuteSql("UPDATE Sys_Permissions_RoleMenuRelation SET MenuIdOne = '" + MenuIdOne + "', MenuIdTwo = '" + MenuIdTwo + "' WHERE MenuIdThree ='" + MenuIdThree + "' ");
                return true;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

    }
}