WEBUI/WMS.BZCore/TDb/BaseWarehouse.cs

using SqlSugar;
using System;
using System.Collections.Generic;
using WMS.Info;
using WMS.Util;

namespace WMS.Core
{
    public class BaseWarehouse
    {


        public const string WarehouseHead = "37731699696042abb0d46c7699e29c60";



        /// <summary>
        /// 获取列表数据
        /// <summary>
        /// <returns></returns>
        public IEnumerable<BASE_WAREHOUSE> GetList(string keyword)
        {
            try
            {
                return SysDbCore.GetDbCtx().Queryable<BASE_WAREHOUSE>().Where(it => it.F_ISDELETE == 0).WhereIF(!keyword.IsEmpty(), it => it.F_NO.Contains(keyword) || it.F_NAME.Contains(keyword)).ToList();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 获取启用列表数据
        /// <summary>
        /// <returns></returns>
        public IEnumerable<BASE_WAREHOUSE> GetEnableList()
        {
            try
            {
                return SysDbCore.GetDbCtx().Queryable<BASE_WAREHOUSE>().Where(it => it.F_ISDELETE == 0 && it.F_ISSTOP == 0).ToList();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 获取树型 
        /// </summary>
        /// <returns></returns>
        public List<TreeModel> GetCheckTree()
        {
            List<BASE_WAREHOUSE> list = SysDbCore.GetDbCtx().Queryable<BASE_WAREHOUSE>().Where(it => it.F_ISDELETE == 0 && it.F_ISSTOP == 0).ToList();
            List<TreeModel> treeList = new List<TreeModel>();
            {
                TreeModel node = new TreeModel();
                node.id = ACLAuthorize.ALLAuthorize;
                node.text = " 仓库";
                node.value = "";
                node.showcheck = true;
                node.checkstate = 0;
                node.isexpand = true;
                node.icon = ACLAuthorize.IcoAuthorize;
                node.parentId = "";
                treeList.Add(node);
            }
            foreach (var item in list)
            {
                TreeModel node = new TreeModel();
                node.id = item.F_NO;
                node.text = item.F_NAME;
                node.value = item.F_NO;
                node.showcheck = true;
                node.checkstate = 0;
                node.isexpand = true;
                node.icon = ACLAuthorize.IcoAuthorize;
                node.parentId = ACLAuthorize.ALLAuthorize;
                treeList.Add(node);
            }
            return treeList.ToTree();
        }
        /// <summary>
        /// 获取树型 
        /// </summary>
        /// <returns></returns>
        public List<TreeModel> GetCheckWWTree()
        {

            List<TreeModel> treeList = new List<TreeModel>();
            List<BASE_WAREHOUSE> list = SysDbCore.GetDbCtx().Queryable<BASE_WAREHOUSE>().Where(it => it.F_ISDELETE == 0 && it.F_ISSTOP == 0).ToList();
            foreach (var item in list)
            {
                TreeModel node = new TreeModel();
                node.id = item.F_NO;
                node.text = item.F_NAME;
                node.value = item.F_NO;
                node.showcheck = true;
                node.checkstate = 0;
                node.isexpand = true;
                node.icon = ACLAuthorize.IcoAuthorize;
                node.parentId = "";
                treeList.Add(node);
            }
            List<BASE_WAREA> warealist = SysDbCore.GetDbCtx().Queryable<BASE_WAREA>().Where(it => it.F_ISDELETE == 0 && it.F_ISSTOP == 0).ToList();
            foreach (var item in warealist)
            {
                TreeModel node = new TreeModel();
                node.id = item.F_NO;
                node.text = item.F_NAME;
                node.value = item.F_NO;
                node.showcheck = true;
                node.checkstate = 0;
                node.isexpand = true;
                node.icon = ACLAuthorize.IcoAuthorize;
                node.parentId = item.F_WAREHOUSENO;
                treeList.Add(node);
            }
            return treeList.ToTree();
        }


        public List<TreeModel> GetCheckWWTreeByLocation()
        {

            List<TreeModel> treeList = new List<TreeModel>();
            List<BASE_WAREHOUSE> list = SysDbCore.GetDbCtx().Queryable<BASE_WAREHOUSE>().Where(it => it.F_ISDELETE == 0 && it.F_ISSTOP == 0 && it.F_TYPENUM == 1).ToList();
            foreach (var item in list)
            {
                TreeModel node = new TreeModel();
                node.id = item.F_NO;
                node.text = item.F_NAME;
                node.value = item.F_NO;
                node.showcheck = true;
                node.checkstate = 0;
                node.isexpand = true;
                node.icon = ACLAuthorize.IcoAuthorize;
                node.parentId = "";
                treeList.Add(node);
            }

            return treeList.ToTree();
        }

        /// <summary>
        /// 获取树型 
        /// </summary>
        /// <returns></returns>
        public List<TreeModel> GetCheckWWACLTree()
        {

            List<TreeModel> treeList = new List<TreeModel>();
            List<BASE_WAREHOUSE> list = SysDbCore.GetDbCtx().Queryable<BASE_WAREHOUSE>().Where(it => it.F_ISDELETE == 0 && it.F_ISSTOP == 0).ToList();
            {
                TreeModel node = new TreeModel();
                node.id = ACLAuthorize.ALLAuthorize;
                node.text = " 仓库";
                node.value = "";
                node.showcheck = true;
                node.checkstate = 0;
                node.isexpand = true;
                node.icon = ACLAuthorize.IcoAuthorize;
                node.parentId = "";
                treeList.Add(node);
            }
            foreach (var item in list)
            {
                TreeModel node = new TreeModel();
                node.id = WarehouseHead + "_" + item.F_NO;
                node.text = item.F_NAME;
                node.value = WarehouseHead + "_" + item.F_NO;
                node.showcheck = true;
                node.checkstate = 0;
                node.isexpand = true;
                node.icon = ACLAuthorize.IcoAuthorize;
                node.parentId = ACLAuthorize.ALLAuthorize;
                treeList.Add(node);
            }
            //List<BASE_WAREA> warealist = SysDbCore.GetDbCtx().Queryable<BASE_WAREA>().Where(it => it.F_ISDELETE == 0 && it.F_ISSTOP == 0).ToList();
            //foreach (var item in warealist)
            //{
            //    TreeModel node = new TreeModel();
            //    node.id = item.F_NO;
            //    node.text = item.F_NAME;
            //    node.value = item.F_NO;
            //    node.showcheck = true;
            //    node.checkstate = 0;
            //    node.isexpand = true;
            //    node.icon = ACLAuthorize.IcoAuthorize;
            //    node.parentId = WarehouseHead + "_" + item.F_WAREHOUSENO;
            //    treeList.Add(node);
            //}
            return treeList.ToTree();
        }
        /// <summary>
        /// 获取分页数据
        /// <summary>
        /// <returns></returns>
        public IEnumerable<BASE_WAREHOUSE> GetPageList(string keyword, Pagination pagination)
        {
            try
            {
                int count = 0;
                var db = SysDbCore.GetDbCtx().Queryable<BASE_WAREHOUSE>().Where(it => it.F_ISDELETE == 0).WhereIF(!keyword.IsEmpty(), it => it.F_NO.Contains(keyword) || it.F_NAME.Contains(keyword));
                List<BASE_WAREHOUSE> list = new List<BASE_WAREHOUSE>();
                if (pagination.sord.ToUpper() == "ASC")
                {
                    list = db.OrderBy(pagination.sidx).ToPageList(pagination.page, pagination.rows, ref count);
                }
                else
                {
                    string orderstr = pagination.sidx + " desc";
                    list = db.OrderBy(orderstr).ToPageList(pagination.page, pagination.rows, ref count);
                }
                pagination.records = count;
                return list;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 获取实体数据
        /// <param name="keyValue">主键</param>
        /// <summary>
        /// <returns></returns>
        public BASE_WAREHOUSE GetEntity(string keyValue)
        {
            try
            {
                return SysDbCore.GetDbCtx().Queryable<BASE_WAREHOUSE>().Where(it => it.F_ISDELETE == 0 && it.F_NO == keyValue).First();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
        /// <summary>
        /// 删除实体数据
        /// <param name="keyValue">主键</param>
        /// <summary>
        /// <returns></returns>
        public void DeleteEntity(string keyValue)
        {
            try
            {
                //SysDbCore.GetDbCtx().Deleteable<BASE_WAREHOUSE>().Where(it => it.F_NO == keyValue).ExecuteCommand();
                SysDbCore.GetDbCtx().Updateable<BASE_WAREHOUSE>().UpdateColumns(it => new BASE_WAREHOUSE { F_ISDELETE = 1 }).Where(it => it.F_NO == keyValue).ExecuteCommand();
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }

        /// <summary>
        /// 保存实体数据（新增、修改）
        /// <param name="keyValue">主键</param>
        /// <summary>
        /// <returns></returns>
        public void SaveEntity(LoginUserInfo loginUserInfo, string keyValue, BASE_WAREHOUSE entity)
        {
            try
            {
                if (entity == null)
                {
                    throw SysExCore.ThrowFailException("输入数据为空。");
                }
                if (string.IsNullOrWhiteSpace(entity.F_NO))
                {
                    throw SysExCore.ThrowFailException("编码为空。");
                }
                if (string.IsNullOrWhiteSpace(entity.F_NAME))
                {
                    throw SysExCore.ThrowFailException("名称为空。");
                }
                entity.F_EDITTIME = DateTime.Now;
                entity.F_EDITUSERNO = loginUserInfo.UserNo;
                if (string.IsNullOrEmpty(keyValue))
                {
                    var item = SysDbCore.GetDbCtx().Queryable<BASE_WAREHOUSE>().First(v => v.F_NO == entity.F_NO);
                    if (item != null)
                    {
                        throw SysExCore.ThrowFailException("添加仓库时，仓库编号不能重复。");
                    }

                    entity.F_ADDTIME = DateTime.Now;
                    entity.F_ADDUSERNO = loginUserInfo.UserNo;
                    entity.F_ISDELETE = 0;
                    //entity.F_ISSTOP = 0;
                    SysDbCore.GetDbCtx().Insertable(entity).ExecuteCommand();
                }
                else
                {
                    SysDbCore.GetDbCtx().Updateable(entity).IgnoreColumns(it => new { it.F_ADDTIME, it.F_ADDUSERNO }).Where(it => it.F_NO == keyValue).ExecuteCommand();
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }


        /// <summary>
        /// 获取仓库和区域列表数据
        /// </summary>
        /// <param name="parentId">父节点主键（0表示顶层）</param>
        /// <param name="keyword">关键字查询（名称/编号）</param>
        /// <returns></returns>
        //public List<V_WMS_WAREHOUSEWAREA> GetList(string parentId, string keyword)
        //{
        //    try
        //    {
        //        //if (string.IsNullOrWhiteSpace(parentId))
        //        //{
        //        //    parentId = "0";
        //        //}
        //        //var db = SysDbCore.GetDbCtx().Queryable<V_WMS_WAREHOUSEWAREA>().Where(v => v.F_PARENTID == parentId);
        //        //var list = db.Where(t => t.F_NAME.Contains(keyword)).ToList();

        //        return null;
        //    }
        //    catch (Exception ex)
        //    {
        //        throw ex;
        //    }
        //}

        public Dictionary<string, BASE_WAREHOUSE> GetMap()
        {
            try
            {
                Dictionary<string, BASE_WAREHOUSE> dics = new Dictionary<string, BASE_WAREHOUSE>();
                SysDbCore.GetDbCtx().Queryable<BASE_WAREHOUSE>().ToList().ForEach(it => dics.Add(it.F_NO, it));
                return dics;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
    }
}