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_UserCaseDAL : ISys_Permissions_UserCaseDAL
    {

        private Database _dataBase = null;

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

        /// <summary>
        /// 新增
        /// </summary>
        /// <param name="model"></param>
        /// <returns></returns>
        public bool InserModel(Infrastructure.Domain.IAggregateRoot model)
        {
            Model.Sys_Permissions_UserCase trueModel = model as Model.Sys_Permissions_UserCase;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                    new SqlParameter(){Direction=ParameterDirection.ReturnValue,SqlDbType = SqlDbType.Int},
                    new SqlParameter("@MenuId",trueModel.MenuId),
					new SqlParameter("@UserCaseName",trueModel.UserCaseName),
					new SqlParameter("@IsUsed",trueModel.IsUsed),
					new SqlParameter("@ListId",trueModel.ListId),
					new SqlParameter("@ControId",trueModel.ControId),
					new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
					new SqlParameter("@Operator",trueModel.Operator),
					new SqlParameter("@Remark",trueModel.Remark) 
            };
            try
            {
                _dataBase.Query("sp_Sys_Permissions_UserCase_Insert", CommandType.StoredProcedure, sqlParms.ToArray<SqlParameter>());
                trueModel.Keyid = (int)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_UserCase trueModel = model as Model.Sys_Permissions_UserCase;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {new SqlParameter("@Keyid",trueModel.Keyid),
                new SqlParameter("@MenuId",trueModel.MenuId),
					new SqlParameter("@UserCaseName",trueModel.UserCaseName),
					new SqlParameter("@IsUsed",trueModel.IsUsed),
					new SqlParameter("@ListId",trueModel.ListId),
					new SqlParameter("@ControId",trueModel.ControId),
					new SqlParameter("@LastUpdateTime",trueModel.LastUpdateTime),
					new SqlParameter("@Operator",trueModel.Operator),
					new SqlParameter("@Remark",trueModel.Remark) 
            };
            try
            {
                _dataBase.Query("sp_Sys_Permissions_UserCase_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_UserCase trueModel = model as Model.Sys_Permissions_UserCase;
            if (trueModel == null)
            {
                return false;
            }
            IList<SqlParameter> sqlParms = new List<SqlParameter>()
            {
                new SqlParameter("@Keyid",trueModel.Keyid)
            };
            try
            {
                _dataBase.Query("sp_Sys_Permissions_UserCase_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_UserCase> 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_UserCase> SelectAllModel(Infrastructure.Query.Query query)
        {
            throw new NotImplementedException();
        }

        /// <summary>
        /// 根据菜单编号查询用例
        /// </summary>
        /// <param name="MenuId">菜单编号</param>
        /// <returns></returns>
        public DataTable SelectList(int? MenuId)
        {
            return _dataBase.SelectModel("*", "Sys_Permissions_UserCase", string.Format(" MenuId= '" + MenuId + "' ORDER BY Keyid ASC"));
        }

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

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

        /// <summary>
        /// 根据路径和角色编号去除用例
        /// </summary>
        /// <param name="MenuPath"></param>
        /// <param name="RoleId"></param>
        /// <returns></returns>
        public IEnumerable<Model.Sys_Permissions_UserCase> GetNoExitCaseList(string MenuPath, int? RoleId)
        {
            try
            {
                IList<Sys_Permissions_UserCase> result = _dataBase.SelectModel<Sys_Permissions_UserCase>(" a.* ", " dbo.Sys_Permissions_UserCase AS a LEFT JOIN dbo.Sys_Permissions_Menu AS b ON a.MenuId = b.Keyid LEFT JOIN dbo.Sys_Permissions_RoleMenuRelation AS c ON b.Keyid = c.MenuIdThree ", string.Format(" b.MenuPath like '%{0}' AND c.RoleId ='{1}' AND CHARINDEX(CONVERT(VARCHAR(20),a.Keyid),c.FuncId)>=0 ", MenuPath, RoleId)) as IList<Sys_Permissions_UserCase>;//执行查询

                return result;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 通过页面创建用例
        /// </summary>
        /// <param name="menupath"></param>
        /// <param name="attrs"></param>
        /// <param name="texts"></param>
        /// <returns></returns>
        public bool CreatUserCaseByPage(string menupath, string attrs, string texts)
        {
            try
            {
                if (string.IsNullOrEmpty(attrs.Trim(',')) || string.IsNullOrEmpty(texts.Trim(',')))
                {
                    return false;
                }
                attrs = "'" + attrs.Trim(',').Replace(",", "','") + "'";
                texts = "'" + texts.Trim(',').Replace(",", "','") + "'";
                string[] caseids = attrs.Replace("'", "").Split(',');
                string[] casenames = texts.Replace("'", "").Split(',');
                List<string> old_caseidsList = caseids.ToList();
                List<string> old_casenamesList = casenames.ToList();
                List<string> caseidsList = new List<string>();
                List<string> casenamesList = new List<string>();

                for (int i = 0; i < old_caseidsList.Count; i++)
                {
                    if (caseidsList.IndexOf(old_caseidsList[i]) == -1)
                    {
                        caseidsList.Add(old_caseidsList[i]);
                        casenamesList.Add(old_casenamesList[i]);
                    }
                }

                IList<Sys_Permissions_Menu> m_Sys_Permissions_MenuList = _dataBase.SelectModel<Sys_Permissions_Menu>(" * ", " Sys_Permissions_Menu ", string.Format(" MenuPath like '{0}%' ", menupath)) as IList<Sys_Permissions_Menu>;//执行查询
                if (m_Sys_Permissions_MenuList != null && m_Sys_Permissions_MenuList.Count > 0)
                {
                    int? Menuid = m_Sys_Permissions_MenuList[0].Keyid;

                    IList<Sys_Permissions_UserCase> m_Sys_Permissions_UserCaseList = _dataBase.SelectModel<Sys_Permissions_UserCase>(" * ", " Sys_Permissions_UserCase ", string.Format(" MenuId='{0}' and ControId in ({1}) ", Menuid, attrs)) as IList<Sys_Permissions_UserCase>;//执行查询
                    if (m_Sys_Permissions_UserCaseList != null && m_Sys_Permissions_UserCaseList.Count > 0)
                    {
                        int m = 0;
                        foreach (Sys_Permissions_UserCase m_Sys_Permissions_UserCase in m_Sys_Permissions_UserCaseList)
                        {
                            if (caseids.Contains(m_Sys_Permissions_UserCase.ControId))
                            {
                                casenamesList.RemoveAt(caseidsList.IndexOf(m_Sys_Permissions_UserCase.ControId));
                                caseidsList.Remove(m_Sys_Permissions_UserCase.ControId);
                            }
                            m++;
                        }
                    }

                    for (int i = 0; i < caseidsList.Count; i++)
                    {
                        Sys_Permissions_UserCase m_Sys_Permissions_UserCase = new Sys_Permissions_UserCase();
                        m_Sys_Permissions_UserCase.ControId = caseidsList[i].ToString();
                        m_Sys_Permissions_UserCase.IsUsed = true;
                        m_Sys_Permissions_UserCase.LastUpdateTime = DateTime.Now;
                        m_Sys_Permissions_UserCase.ListId = "";
                        m_Sys_Permissions_UserCase.MenuId = Menuid;
                        m_Sys_Permissions_UserCase.Operator = "";
                        m_Sys_Permissions_UserCase.Remark = "";
                        m_Sys_Permissions_UserCase.UserCaseName = casenamesList[i].ToString();

                        InserModel(m_Sys_Permissions_UserCase);
                    }
                }

                return true;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
    }
}