using Model.ModelDto.SysDto;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using SqlSugar;
using WMS.Entity.Context;
using WMS.Entity.SysEntity;
using WMS.IDAL.ISysInterface;
using Dm;

namespace WMS.DAL.SysInfrastructure
{
    /// <summary>
    /// 部门仓储实践
    /// </summary>
    public class DepartmentRepository : BaseRepository<SysDepartment>, IDepartmentRepository
    {
        private static readonly SqlSugarScope Db = DataContext.Db;
        public DepartmentRepository() : base(Db)
        {
        }


        /// <summary>
        /// 获取部门信息列表
        /// </summary>
        /// <param name="DepartmentName">部门名称</param>
        /// <param name="DepartmentNo">部门号</param>
        /// <returns></returns>
        public List<DepartmentDto> GetDepartmentList(string DepartmentName, string DepartmentNo)
        {
            string str = "select dep.*,user1.RealName CreateUserName from SysDepartment dep left join SysUserInfor user1 on dep.CreateUser = user1.id where dep.IsDel = @isdel";
            //判断部门名称是否为空
            if (!string.IsNullOrEmpty(DepartmentName))
            {
                str += " and dep.DepartmentName like @departmentname";
            }
            //判断部门号是否为空
            if (!string.IsNullOrEmpty(DepartmentNo))
            {
                str += " and dep.DepartmentNo like @departmentno";
            }
            List<DepartmentDto> departmentlist = Db.Ado.SqlQuery<DepartmentDto>(str, new
            {
                isdel = "0", //是否删除
                departmentname = "%" + DepartmentName + "%", //部门名称
                departmentno = "%" + DepartmentNo + "%" //部门号
            });
            return departmentlist;
        }

        /// <summary>
        /// 根据id获取部门信息
        /// </summary>
        /// <param name="id">部门id</param>
        /// <returns></returns>
        public SysDepartment GetDepartmentById(int id)
        {
            string str = "select * from SysDepartment where IsDel = '0' and Id = @id";
            var departmentlist = Db.Ado.SqlQuerySingle<SysDepartment>(str, new
            {
                id //id
            });
            return departmentlist;
        }

        /// <summary>
        /// 根据部门号获取部门信息
        /// </summary>
        /// <param name="DepartmentNo">部门号</param>
        /// <returns></returns>
        public List<SysDepartment> GetDepartmentByNo(string DepartmentNo)
        {
            string str = "select * from SysDepartment where DepartmentNo = @departmentno";
            List<SysDepartment> departmentlist = Db.Ado.SqlQuery<SysDepartment>(str, new
            {
                departmentno = DepartmentNo //部门号
            });
            return departmentlist;
        }

        /// <summary>
        /// 新增部门信息
        /// </summary>
        /// <param name="department">部门实体模型</param>
        /// <returns></returns>
        public async Task<int> AddDepartment(SysDepartment department)
        {
            string str = "insert into SysDepartment values(@departmentno, @departmentname, @demo, @isdel, @createtime, @createuser, null, null)";
            int i = await Db.Ado.ExecuteCommandAsync(str, new
            {
                departmentno = department.DepartmentNo, //部门号
                departmentname = department.DepartmentName, //部门名称
                demo = department.Demo, //备注
                isdel = "0", //是否删除
                createtime = Db.GetDate(), //创建时间
                createuser = department.CreateUser //创建人
            });
            return i;
        }

        /// <summary>
        /// 删除部门信息
        /// </summary>
        /// <param name="department">部门实体模型</param>
        /// <returns></returns>
        public async Task<int> DelDepartment(SysDepartment department)
        {
            string str = "update SysDepartment set IsDel = @isdel, UpdateTime = @updatetime, UpdateUser = @updateuser where id = @id";
            int i = await Db.Ado.ExecuteCommandAsync(str, new
            {
                isdel = "1", //是否删除
                updatetime = Db.GetDate(), //更改时间
                updateuser = department.UpdateUser, //更改人
                id = department.Id //id
            });
            return i;
        }

        /// <summary>
        /// 编辑部门信息
        /// </summary>
        /// <param name="department">部门实体模型</param>
        /// <returns></returns>
        public async Task<int> ExitDepartment(SysDepartment department)
        {

            string str = "update SysDepartment set DepartmentNo = @departmentno, DepartmentName = @departmentname,Demo = @demo, UpdateTime = @updatetime, UpdateUser = @updateuser where id = @id";
            int i = await Db.Ado.ExecuteCommandAsync(str, new
            {
                departmentno = department.DepartmentNo, //部门号
                departmentname = department.DepartmentName, //部门名称
                demo = department.Demo, //备注
                updatetime = Db.GetDate(), //更改时间
                updateuser = department.UpdateUser, //更改人
                id = department.Id //id
            });
            return i;
        }
    }
}