using Model.ModelDto.SysDto;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using WMS.Entity.Context;
using WMS.Entity.SysEntity;
using WMS.IBLL.ISysServer;

namespace WMS.BLL.SysServer
{
    public class RoleWareHouseServer: IRoleWareHouseServer
    {

        private static readonly SqlSugarScope Db = DataContext.Db;

        public List<SysRoleWareHouse> GetRoleWareHouseOneListById(int id)
        {
            try
            {
                var role = Db.Queryable<SysRoles>().First(m => m.IsDel == "0" && m.Id == id);
                if (role == null) 
                {
                    throw new Exception("没有找到角色信息");
                }
                var roleWare = Db.Queryable<SysRoleWareHouse>().Where(m => m.RoleNo == role.RoleNo && m.IsDel == "0").ToList();
                return roleWare;

            }
            catch (Exception e)
            {
                throw new Exception(e.Message);
            }
        }

        /// <summary>
        /// 获取仓库信息列表
        /// </summary>
        /// <param name="str">sql语句</param>
        /// <returns></returns>
        public List<SysWareHouse> GetHouseList(string UserId)
        {
            var userEntry = Db.Ado.SqlQuery<SysUserInfor>($"select * from SysUserInfor where Id ={UserId}").FirstOrDefault();
            //获取全部菜单信息
            string strmenu = "select * from SysWareHouse where IsDel = '0'";
             
            //分配权限只能分配当前登录用户有的权限
            if (userEntry != null && userEntry.UserName.ToUpper() != "ADMIN")
            {
                strmenu += $" and WareHouseNo in (select WareHouseNo from SysRoleWareHouse where RoleNo='{userEntry.RoleNo}')";
            }
            strmenu += "  order by WareHouseNo asc";
            List<SysWareHouse> houselist = Db.Ado.SqlQuery<SysWareHouse>(strmenu);
            return houselist;
        }

        /// <summary>
        /// 新增角色权限信息
        /// </summary>
        /// <param name="WareHouseNo">仓库号</param>
        /// <param name="RoleNo">角色号</param>
        /// <returns></returns>
        /// <exception cref="Exception">捕获异常</exception>
        public async Task<int> InsertRoleWareHouse(string WareHouseNo, string RoleNo, string userId)
        {
            //捕获异常
            try
            {
                //将菜单号进行分割 存储数组中
                var arr = WareHouseNo.Split(',');
                int i = 0;
                //查询该角色是否拥有权限
                List<SysRoleWareHouse> rolelist = await Db.Queryable<SysRoleWareHouse>().Where(m=>m.IsDel == "0" && m.RoleNo == RoleNo).ToListAsync();  
                //有
                if (rolelist.Count > 0)
                {
                    //删除该角色所有菜单信息 
                    i = await Db.Deleteable(rolelist).ExecuteCommandAsync();
                }
                //无
                else if (rolelist.Count == 0)
                {
                    i = 1;
                }
                //开始新增权限
                if (i > 0)
                {
                    
                    //循环将菜单数组分别加入到数据模型中
                    for (int j = 0; j < arr.Count(); j++)
                    {
                        if (string.IsNullOrWhiteSpace(arr[j]) || arr[j] == ",")
                        {
                            continue;
                        }
                        SysRoleWareHouse roleright = new SysRoleWareHouse();
                        roleright.RoleNo = RoleNo;//角色号
                        roleright.WareHouseNo = arr[j];//仓库号
                        roleright.CreateUser = Convert.ToInt32(userId);//创建人

                        //成功 将菜单号和角色号新增为新的数据
                        i += await Db.Insertable(roleright).ExecuteCommandAsync();
                    }
                     
                    //返回
                    return i;

                }
                else
                {
                    return i;
                }
            }
            catch (Exception ex)
            {
                //抛出异常
                throw new Exception("新增角色权限信息异常", ex);
            }
        }


    }
}