优化WMS前端首页，货位查询column数据库关键字处理

dengjunjie

2025-04-03 1e12c140c041c0cb52306a0db9ff0ba18354d0d8

 ÏîÄ¿´úÂë/WMS/WIDESEA_WMSServer/WIDESEA_BasicService/Base/LocationInfoService.cs

@@ -2,9 +2,12 @@
using System;
using System.Collections.Generic;
using System.Linq;
using System.Reflection.Metadata;
using System.Text;
using System.Threading.Tasks;
using WIDESEA_Common;
using WIDESEA_Core;
using WIDESEA_Core.BaseRepository;
using WIDESEA_Core.BaseServices;
using WIDESEA_Core.Enums;
using WIDESEA_Core.Helper;
@@ -41,7 +44,38 @@
        {
            return base.DeleteData(keys);
        }
        public override PageGridData<Dt_LocationInfo> GetPageData(PageDataOptions options)
        {
            return base.GetPageData(options);
        }
        /// <summary>
        /// ä¿®æ”¹è´§ä½çš„禁用状态
        /// </summary>
        /// <param name="saveModel"></param>
        /// <returns></returns>
        public WebResponseContent UpdateEnableStatus(SaveModel saveModel)
        {
            WebResponseContent content = new WebResponseContent();
            try
            {
                List<Dt_LocationInfo> locationInfos = Repository.QueryData(x => saveModel.DelKeys.Contains(x.Id));
                var values = Enum.GetValues(typeof(EnableStatusEnum));
                var Index = saveModel.Extra.ObjToInt();
                var EnableStatus = (EnableStatusEnum)values.GetValue(Index);
                locationInfos.ForEach(x =>
                {
                    x.EnableStatus = EnableStatus.ObjToInt();
                });
                Repository.UpdateData(locationInfos);
                content.OK();
            }
            catch (Exception ex)
            {
                content.Error(ex.Message);
            }

            return content;
        }
        public WebResponseContent LocationEnableStatus(int[] keys)
        {
            List<Dt_LocationInfo> locationInfos = Repository.QueryData(x => keys.Contains(x.Id));
@@ -76,6 +110,42 @@
            return LocationDisableStatus(new int[] { key });
        }

        public WebResponseContent GetLocationCodes()
        {
            WebResponseContent content = new WebResponseContent();
            try
            {
                //content.OK(_basicRepository.MaterielInfoRepository.Getmaterianame(saveModel).Message, Repository.QueryData(x => x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()).Select(x => x.LocationCode).ToList());
                content.OK(data: Repository.QueryData(x => x.EnableStatus == EnableStatusEnum.Normal.ObjToInt()).Select(x => x.LocationCode).ToList());
            }
            catch (Exception ex)
            {
                content.Error(ex.Message);
            }
            return content;
        }
        public object GetLocationLayer()
        {
            List<object> list = new List<object>();
            var data = Db.Ado.SqlQuery<LocationArea>(@"SELECT areaName,areaCode,roadwayNo,layer from Dt_AreaInfo as t1
                    INNER JOIN
                    (
                    select DISTINCT  AreaId,RoadwayNo,Layer from Dt_LocationInfo 
                    ) as t2
                    on t1.Id=t2.AreaId");
            foreach (var item in data.GroupBy(t => t.areaName))
            {
                var obj = new
                {
                    areaName = item.Key,
                    areaCode = item.Max(x => x.areaCode),
                    tunnel = item.Select(t => t.roadwayNo).OrderBy(t => t).Distinct().ToList(),
                    Layers = item.Select(t => t.layer).OrderBy(t => t).ToList(),
                };
                list.Add(obj);
            }
            return list;
        }
        public WebResponseContent InitializationLocation(InitializationLocationDTO initializationLocationDTO)
        {
            try
@@ -101,7 +171,7 @@
                                LocationType = LocationTypeEnum.Cube.ObjToInt(),
                                RoadwayNo = initializationLocationDTO.Roadway,
                                Row = i + 1,
                                MaxQty = i == 1 ? 24 : 12,
                                MaxQty = 12,
                                CurrentQty = 0,
                            };