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_MenuDAL : ISys_Permissions_MenuDAL
    {

        private Database _dataBase = null;

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

        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.Sys_Permissions_Menu trueModel = model as Model.Sys_Permissions_Menu;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                    new SqlParameter(){Direction=ParameterDirection.ReturnValue,SqlDbType = SqlDbType.Int},
                    new SqlParameter("@MenuName",trueModel.MenuName),
					new SqlParameter("@ParentId",trueModel.ParentId),
					new SqlParameter("@MenuPath",trueModel.MenuPath),
					new SqlParameter("@MenuIcon",trueModel.MenuIcon),
					new SqlParameter("@IsUsed",trueModel.IsUsed),
					new SqlParameter("@OrderCode",trueModel.OrderCode),
					new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
					new SqlParameter("@Operator",trueModel.Operator),
					new SqlParameter("@Remark",trueModel.Remark) 
            };
            try
            {
                _dataBase.Query("sp_Sys_Permissions_Menu_Insert", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
                trueModel.Keyid = CY.Infrastructure.Common.MyConvert.ConvertToInt32(sqlParms[0].Value);
            }
            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_Menu trueModel = model as Model.Sys_Permissions_Menu;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {	new SqlParameter("@Keyid",trueModel.Keyid),
                new SqlParameter("@MenuName",trueModel.MenuName),
					new SqlParameter("@ParentId",trueModel.ParentId),
					new SqlParameter("@MenuPath",trueModel.MenuPath),
					new SqlParameter("@MenuIcon",trueModel.MenuIcon),
					new SqlParameter("@IsUsed",trueModel.IsUsed),
					new SqlParameter("@OrderCode",trueModel.OrderCode),
					new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
					new SqlParameter("@Operator",trueModel.Operator),
					new SqlParameter("@Remark",trueModel.Remark) 
            };
            try
            {
                _dataBase.Query("sp_Sys_Permissions_Menu_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_Menu trueModel = model as Model.Sys_Permissions_Menu;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                	new SqlParameter("@Keyid",trueModel.Keyid)
            };
            try
            {
                _dataBase.Query("sp_Sys_Permissions_Menu_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_Menu> 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_Menu> SelectAllModel(Infrastructure.Query.Query query)
        {
            throw new NotImplementedException();
        }

        public IEnumerable<Model.Sys_Permissions_Menu> GetMenuByParentId(int parentId)
        {
            throw new NotImplementedException();
            //string tempName = string.Empty;
            //IDataReader reader = _Database.QueryDataReader("sp_GetMenuByParentId", System.Data.CommandType.StoredProcedure, new SqlParameter() { ParameterName = "@parentId", Value = parentId });
            //return Database.ReadDataToModelAndDispose<Sys_Permissions_Menu>(reader);
        }

        /// <summary>
        /// 根据上级编号查询全部菜单
        /// </summary>
        /// <param name="ParentId">编号</param>
        /// <returns></returns>
        public IEnumerable<Sys_Permissions_Menu> SelectListByParentId(int? ParentId)
        {
            if (ParentId == null)
                return null;//错误数据返会空 

            IList<Sys_Permissions_Menu> result = _dataBase.SelectModel<Sys_Permissions_Menu>("*", "Sys_Permissions_Menu", string.Format(" ParentId='{0}'  ORDER BY OrderCode ASC", ParentId)) as IList<Sys_Permissions_Menu>;//执行查询

            return result;//返回结果
        }

        /// <summary>
        /// 查询全部菜单
        /// </summary>
        /// <returns></returns>
        public DataTable SelectList()
        {
            return _dataBase.SelectModel("*", "Sys_Permissions_Menu", string.Format("1= 1 ORDER BY OrderCode ASC"));
        }

        /// <summary>
        /// 查询全部启用的菜单
        /// </summary>
        /// <returns></returns>
        public DataTable SelectAllUsedList()
        {
            return _dataBase.SelectModel("*", "Sys_Permissions_Menu", string.Format("1= 1 and IsUsed = 'True' ORDER BY OrderCode ASC"));
        }

        /// <summary>
        /// 根据编号查询单个信息
        /// </summary>
        /// <param name="Keyid">编号</param>
        /// <returns></returns>
        public Sys_Permissions_Menu SelectModelByKeyId(int? KeyId)
        {
            if (KeyId == null)
                return null;//错误数据返会空 

            Sys_Permissions_Menu m_Sys_Permissions_Menu = new Sys_Permissions_Menu();
            try
            {
                IList<Sys_Permissions_Menu> result = _dataBase.SelectModel<Sys_Permissions_Menu>("*", "Sys_Permissions_Menu", string.Format(" KeyId='{0}' ", KeyId)) as IList<Sys_Permissions_Menu>;//执行查询
                if (null == result || result.Count == 0)
                {
                    m_Sys_Permissions_Menu = null;
                }
                else
                {
                    m_Sys_Permissions_Menu = result[0];
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return m_Sys_Permissions_Menu;
        }

        /// <summary>
        /// 根据上级编号查询单个信息
        /// </summary>
        /// <param name="ParentId">上级编号</param>
        /// <returns></returns>
        public Sys_Permissions_Menu SelectModelByParentId(int? ParentId)
        {
            if (ParentId == null)
                return null;//错误数据返会空 

            Sys_Permissions_Menu m_Sys_Permissions_Menu = new Sys_Permissions_Menu();
            try
            {
                IList<Sys_Permissions_Menu> result = _dataBase.SelectModel<Sys_Permissions_Menu>("*", "Sys_Permissions_Menu", string.Format(" ParentId='{0}' ", ParentId)) as IList<Sys_Permissions_Menu>;//执行查询
                if (null == result || result.Count == 0)
                {
                    m_Sys_Permissions_Menu = null;
                }
                else
                {
                    m_Sys_Permissions_Menu = result[0];
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return m_Sys_Permissions_Menu;
        }

        /// <summary>
        /// 根据编号查询此菜单的一二三级
        /// </summary>
        /// <param name="MenuId">编号</param>
        /// <returns></returns>
        public Sys_Permissions_Menu GetAllKeyidByMenuId(int? MenuId)
        {
            if (MenuId == null)
                return null;//错误数据返会空 

            Sys_Permissions_Menu m_Sys_Permissions_Menu = new Sys_Permissions_Menu();
            try
            {
                IList<Sys_Permissions_Menu> result = _dataBase.SelectModel<Sys_Permissions_Menu>("a.Keyid AS MenuOneId,b.Keyid AS MenuTwoId,c.Keyid AS MenuThreeId", "dbo.Sys_Permissions_Menu AS a LEFT JOIN dbo.Sys_Permissions_Menu AS b ON a.Keyid = b.ParentId LEFT JOIN dbo.Sys_Permissions_Menu AS c ON b.Keyid = c.ParentId", string.Format(" c.Keyid='{0}' ", MenuId)) as IList<Sys_Permissions_Menu>;//执行查询
                if (null == result || result.Count == 0)
                {
                    m_Sys_Permissions_Menu = null;
                }
                else
                {
                    m_Sys_Permissions_Menu = result[0];
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return m_Sys_Permissions_Menu;
        }
    }
}