Merge branch 'csc'

chengsc

2025-06-11 1c2541b283ce6ba855e67c476412dffe2c693480

 Wms/WMS.BLL/HttpServer.cs

@@ -1,13 +1,17 @@
using Model.InterFaceModel;
using Model.ModelVm;
using Newtonsoft.Json;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using Utility.Tools;
using WMS.BLL.Logic;
using WMS.BLL.LogServer;
using WMS.DAL;
using WMS.Entity.BllAsnEntity;
using WMS.Entity.BllQualityEntity;
using WMS.Entity.BllSoEntity;
using WMS.Entity.Context;
using WMS.Entity.DataEntity;
@@ -22,15 +26,307 @@
        private static readonly SqlSugarScope Db = DataContext.Db;
        public HttpServer() { }


        public OutCommandDto RequestPalletIn(string palletNo, string houseNo, int palletNum, string Strlocate)
        {
            return null;
            //try
            //{
            //    #region 判断
            //    if (string.IsNullOrEmpty(palletNo)) 
            //    {
            //        throw new Exception("托盘号不能为空");
            //    }
            //    if (string.IsNullOrEmpty(houseNo))
            //    {
            //        throw new Exception("仓库号不能为空");
            //    }
            //    if (palletNum <= 0)
            //    {
            //        throw new Exception("托盘数量不能小等0");
            //    }
            //    if (string.IsNullOrEmpty(Strlocate))
            //    {
            //        throw new Exception("起始位置不能为空");
            //    }
            //    //获取储位信息
            //    var locateInfo = Db.Queryable<SysStorageLocat>().First(m => m.IsDel == "0" && m.WareHouseNo == houseNo && m.LocatNo == Strlocate);
            //    if (locateInfo == null)
            //    {
            //        throw new Exception("未查询到空储位");
            //    }
            //    if (locateInfo.Flag != "0")
            //    {
            //        throw new Exception("当前位置标识状态是非正常的");
            //    }

            //    #endregion

            //    #region MyRegion

            //    var stockDetail = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.PalletNo == palletNo).ToList();
            //    if (stockDetail.Count > 0)
            //    {
            //        throw new Exception("当前托盘在库内已有库存信息，请核实");
            //    }

            //    //获取托盘信息
            //    var pallet = Db.Queryable<SysPallets>().First(m => m.IsDel == "0" && m.PalletNo == palletNo);
            //    if (pallet == null)
            //    {
            //        throw new Exception("未查询到托盘信息");
            //    }
            //    if (pallet.Status != "0")
            //    {
            //        throw new Exception("托盘状态不能未使用状态");
            //    }
            //    //获取托盘信息
            //    var sku = Db.Queryable<SysMaterials>().First(m => m.IsDel == "0" && m.SkuNo == "100099");
            //    var pNum = 0;
            //    var bNum = 0;

            //    new Common().GetPackQtyInfo(sku.PackagNo, ref pNum, ref bNum);

            //    var datetime = Db.GetDate();
            //    Db.BeginTran();

            //    // 插入托盘绑定表
            //    var modelpb = new BllPalletBind
            //    {
            //        ASNNo = "",
            //        ASNDetailNo = 0,
            //        TaskNo = "", //任务号
            //        PalletNo = palletNo,
            //        Qty = palletNum,
            //        FullQty = pNum,
            //        Status = "3", //上架完成
            //        Type = "1", //0 物料托 1 空托
            //        LotNo = "",
            //        LotText = "",
            //        SupplierLot = "",
            //        InspectMark = "0", //0 否 1 是
            //        BitPalletMark = pNum == palletNum ? "0" : "1",
            //        IsBale = "0",
            //        IsBelt = "0",
            //        CreateUser = 0,
            //        CreateTime = Db.GetDate()
            //    };
            //    var id = Db.Insertable(modelpb).ExecuteReturnIdentity();
                 
            //    #region 库存明细
            //    var sd1 = new DataStockDetail()
            //    {
            //        LotNo = modelpb.LotNo,
            //        LotText = modelpb.LotText,
            //        SupplierLot = modelpb.SupplierLot,
            //        SkuNo = sku.SkuNo,
            //        SkuName = sku.SkuName,
            //        Standard = sku.Standard,
            //        Qty = modelpb.Qty,
            //        LockQty = 0,
            //        FrozenQty = 0,
            //        InspectQty = 0,
            //        ASNNo = modelpb.ASNNo,
            //        ASNDetailNo = modelpb.ASNDetailNo,
            //        WareHouseNo = "",
            //        RoadwayNo = "",
            //        AreaNo = "",
            //        LocatNo = "",
            //        PalletNo = modelpb.PalletNo,
            //        PalletNo2 = modelpb.PalletNo2,
            //        PalletNo3 = modelpb.PalletNo3,
            //        PalletTags = "0",
            //        CompleteTime = datetime,
            //        ProductionTime = modelpb.ProductionTime,
            //        ExpirationTime = modelpb.ExpirationTime,
            //        Status = "0",
            //        InspectMark = modelpb.InspectMark,
            //        InspectStatus = sku.IsInspect,
            //        BitPalletMark = modelpb.BitPalletMark,
            //        PackagNo = sku.PackagNo,
            //        IsBale = modelpb.IsBale,
            //        IsBelt = modelpb.IsBelt,


            //        IsDel = "0",
            //        CreateUser = 0,
            //        CreateTime = datetime
            //    };
            //    var sdId1 = Db.Insertable(sd1).ExecuteReturnIdentity();
            //    #endregion

            //    #region 库存 
            //    var dataStock1 = Db.Queryable<DataStock>().First(m => m.IsDel == "0" && m.SkuNo == sku.SkuNo);
            //    if (dataStock1 != null)
            //    {
            //        dataStock1.Qty += modelpb.Qty;
            //        if (modelpb.InspectMark == "1")
            //        {
            //            dataStock1.IsSampling = "0";
            //        }
            //        Db.Updateable(dataStock1).ExecuteCommand();
            //    }
            //    else
            //    {
            //        var stock = new DataStock()
            //        {
            //            SkuNo = sku.SkuNo,
            //            SkuName = sku.SkuName,
            //            Standard = sku.Standard,
            //            LotNo = "",
            //            LotText = "",
            //            Qty = modelpb.Qty,
            //            LockQty = 0,
            //            FrozenQty = 0,
            //            IsSampling = "0",
            //            IsDel = "0",
            //            CreateUser = 0,
            //            CreateTime = datetime
            //        };
            //        Db.Insertable(stock).ExecuteCommand();
            //    }
            //    #endregion


            //    #region 申请储位

            //    SysStorageLocat locate;
            //    var sku = skuList.FirstOrDefault(m => m.SkuNo == skuNo);
            //    if (sku == null)
            //    {
            //        throw new Exception("物料信息中未查询到入库单明细包含的物料信息，不可入库");
            //    }
            //    //判断物料是否含有类别信息
            //    if (string.IsNullOrWhiteSpace(sku.CategoryNo))
            //    {
            //        throw new Exception($"物料：{sku.SkuNo}未查询到类别信息");
            //    }

            //    var skuCategory = skuCategoryList.FirstOrDefault(m => m.CategoryNo == sku.CategoryNo);
            //    if (skuCategory == null)
            //    {
            //        throw new Exception($"未在类别信息中查询到物料：{sku.SkuNo}包含的类别");
            //    }

            //    var areaStr = skuCategory.AreaNo.Split(",");
            //    var areaList = new List<string>();
            //    foreach (var item in areaStr)
            //    {
            //        areaList.Add(item);
            //    }

            //    locate = allotLocate.GetSuiTableLocate(houseNo, areaList, "", ceng);


            //    #endregion

            //    #region 添加任务

            //    //添加巷道使用记录
            //    var log = new SysRoadwayUseLog
            //    {
            //        RoadwayNo = locateInfo.RoadwayNo,
            //        WareHouseNo = houseNo,
            //        Row = 0,
            //        Column = 0,
            //        Layer = 0,
            //    };
            //    Db.Insertable(log).ExecuteCommand();
            //    var taskNo = new Common().GetMaxNo("TK");
            //    var inTask = new LogTask    //入库任务
            //    {
            //        TaskNo = taskNo,
            //        Sender = "WMS",
            //        Receiver = "WCS",
            //        IsSuccess = 1, //是否下发成功 0失败 1成功
            //        SendDate = DateTime.Now,  //发送时间
            //        BackDate = DateTime.Now,  //返回时间
            //        StartRoadway = "",            // 起始巷道
            //        StartLocat = locate,//起始位置
            //        EndLocat = locateInfo.LocatNo,//目标位置
            //        EndRoadway = locateInfo.RoadwayNo,  // 目标巷道
            //        PalletNo = palletNo,//托盘码
            //        IsSend = 1,//是否可再次下发
            //        IsCancel = 1,//是否可取消
            //        IsFinish = 1,//是否可完成
            //        Type = "0",//任务类型 0 入库任务 1 出库任务  2 移库任务
            //        Status = "1",//任务状态0：等待执行1正在执行2执行完成
            //        OrderType = "0",//0 入库单 1 出库单  2 盘点单  3 移库单
            //        Msg = $"{locateInfo.LocatNo}到=>>" +  + "的入库任务", //关键信息

            //    };
            //    Db.Insertable(inTask).ExecuteCommand();
            //    var asnNo = "";
                
            //    //添加托盘上架记录
            //    var upShelf = new BllPalletUpShelf()
            //    {
            //        TaskNo = inTask.TaskNo,
            //        TraceNo = asnNo,
            //        PalletNo = palletNo,
            //        SkuNo = stockModel.SkuNo,
            //        SkuName = stockModel.SkuName,
            //        LotNo = stockModel.LotNo,
            //        Status = "1",

            //        WareHouseNo = houseNo,
            //        RoadwayNo = locate.RoadwayNo,
            //        AreaNo = locate.AreaNo,
            //        LocatNo = locate.LocatNo,

            //        CreateUser = 0,
            //    };
            //    Db.Insertable(upShelf).ExecuteCommand();
              


            //    locate.Status = "2";
            //    Db.Updateable(locate).ExecuteCommand();

            //    Db.CommitTran();
            //    comDto = new OutCommandDto()
            //    {
            //        TaskNo = taskNo, // 任务号
            //        TaskType = "0",// 任务类型
            //        PalletNo = palletNo,//托盘号

            //        StartRoadway = inTask.StartRoadway,
            //        StartLocate = inTask.StartLocat, // 起始位置
            //        EndLocate = inTask.EndLocat, // 目标位置 
            //        EndRoadway = inTask.EndRoadway,   // 目标巷道

            //        Order = 999,
            //        Type = PLCTypeEnum.AGV
            //    };

            //    #endregion

            //    // 更改托盘使用状态
            //    string sqlStr = string.Empty;
            //    sqlStr = $"update SysPallets set Status = '1' where PalletNo = '{palletNo}';";
            //    Db.Ado.ExecuteCommand(sqlStr);
            //    Db.CommitTran();
                  
            //    #endregion

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


        /// <summary>
        /// 申请储位  （立体库）
        /// </summary>
        /// <param name="palletNo"></param>
        /// <param name="houseNo"></param>
        /// <param name="roadwayNo"></param>
        /// <param name="ceng"></param>
        /// <returns></returns>
        /// <exception cref="Exception"></exception>
        public OutCommandDto RequestLocation(string palletNo, string houseNo)
        public OutCommandDto RequestLocation(string palletNo, string houseNo,string ceng)
        {
            try
            {
@@ -80,7 +376,7 @@
                    }
                }
                var upShelfOldList = Db.Queryable<BllPalletUpShelf>().Where(m => m.IsDel == "0" && m.PalletNo == palletNo && (m.Status == "0" || m.Status == "1")).ToList();
                if (upShelfOldList != null) //查询到入库信息
                if (upShelfOldList.Count != 0) //查询到入库信息
                {
                    var upShelfOld = upShelfOldList.First();
                    var beingTask = Db.Queryable<LogTask>().First(m => m.IsDel == "0" && m.TaskNo == upShelfOld.TaskNo);
@@ -239,7 +535,7 @@
                    areaList.Add(item);
                }

                locate = allotLocate.GetSuiTableLocate(houseNo, areaList, "");
                locate = allotLocate.GetSuiTableLocate(houseNo, areaList, "",ceng);
                

                #endregion
@@ -287,8 +583,8 @@
                    // 添加托盘绑定表托盘入库任务号 liudl
                    foreach (DataStockDetail stockModel in stockDetail)
                    {
                        var bindModel = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.Status == "2"
                        && m.PalletNo == stockModel.PalletNo && m.ASNNo == stockModel.ASNNo && m.ASNDetailNo == stockModel.ASNDetailNo);
                        var bindModel = Db.Queryable<BllPalletBind>().Where(m => m.IsDel == "0" && m.Status == "2"
                        && m.PalletNo == stockModel.PalletNo && m.ASNNo == stockModel.ASNNo && m.ASNDetailNo == stockModel.ASNDetailNo).OrderByDescending(m=>m.CreateTime).First();
                        if (bindModel != null && string.IsNullOrWhiteSpace(bindModel.TaskNo))
                        {
                            bindModel.TaskNo = taskNo;
@@ -416,6 +712,10 @@
                foreach (var item in stockDetail)
                {
                    var skuItem = skuList.First(m => m.SkuNo == item.SkuNo);
                    if (skuItem.SkuNo == "100099")
                    {
                        continue;
                    }
                    if (skuItem.Type != "2")
                    {
                        throw new Exception("托盘上有不是成品的物料");
@@ -526,9 +826,9 @@
                {
                    areaList.Add(item);
                }

                var roadStr = Db.Queryable<SysStorageRoadway>().Where(m => m.IsDel == "0" && m.Status == "0").Select(m=>m.RoadwayNo).ToList();
                //巷道组信息
                var roadList = Db.Queryable<SysStorageLocat>().Where(m => m.WareHouseNo == houseNo && areaList.Contains(m.AreaNo))
                var roadList = Db.Queryable<SysStorageLocat>().Where(m => m.IsDel == "0" && m.WareHouseNo == houseNo && areaList.Contains(m.AreaNo) && !string.IsNullOrWhiteSpace(m.RoadwayNo) && roadStr.Contains(m.RoadwayNo))
                    .GroupBy(m => m.RoadwayNo).OrderBy(m => m.RoadwayNo).Select(m => m.RoadwayNo).ToList();

                #endregion
@@ -586,8 +886,8 @@
                    
                    foreach (DataStockDetail stockModel in stockDetail)
                    {
                        var bindModel = Db.Queryable<BllPalletBind>().First(m => m.IsDel == "0" && m.Status == "2"
                        && m.PalletNo == stockModel.PalletNo && m.ASNNo == stockModel.ASNNo && m.ASNDetailNo == stockModel.ASNDetailNo);
                        var bindModel = Db.Queryable<BllPalletBind>().Where(m => m.IsDel == "0" && m.Status == "2"
                        && m.PalletNo == stockModel.PalletNo && m.ASNNo == stockModel.ASNNo && m.ASNDetailNo == stockModel.ASNDetailNo).OrderByDescending(m=>m.CreateTime).First();
                        if (bindModel != null && string.IsNullOrWhiteSpace(bindModel.TaskNo))
                        {
                            bindModel.TaskNo = taskNo;
@@ -719,6 +1019,10 @@
                foreach (var item in stockDetail)
                {
                    var skuItem = skuList.First(m => m.SkuNo == item.SkuNo);
                    if (skuItem.SkuNo == "100099")
                    {
                        continue;
                    }
                    if (skuItem.Type != "2")
                    {
                        throw new Exception("托盘上有不是成品的物料");
@@ -839,7 +1143,10 @@
                }

                locate = allotLocate.GetMiJiSuiTableLocate(roadwayNo, areaList);
                
                if (locate == null)
                {
                    throw new Exception($"没有空储位");
                }

                #endregion

@@ -1021,12 +1328,21 @@
                {
                    throw new Exception($"未查询到任务中的储位信息");
                }
                var pingAreaStr = Db.Queryable<SysStorageArea>().Where(m => m.IsDel == "0" && m.WareHouseNo == "W04" && m.AreaNo != "B06" && m.AreaNo != "B07").Select(m => m.AreaNo).ToList();
                var pingAreaStr = Db.Queryable<SysStorageArea>().Where(m => m.IsDel == "0" && m.WareHouseNo == "W04").Select(m => m.AreaNo).ToList();
                var pingLocateInfo = Db.Queryable<SysStorageLocat>().First(m => m.LocatNo == locate.LocatNo && pingAreaStr.Contains(m.AreaNo) && m.IsDel == "0");
                if (pingLocateInfo == null)
                {
                    throw new Exception("当前任务起始储位不在平库储位");
                }
                var stockDetail = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.PalletNo == task.PalletNo).ToList();
                foreach (var item in stockDetail)
                {
                    item.WareHouseNo = "";
                    item.RoadwayNo = "";
                    item.AreaNo = "";
                    item.LocatNo = "";
                }
                Db.Updateable(stockDetail).ExecuteCommand();
                locate.Status = "0";
                Db.Updateable(locate).ExecuteCommand();
            }
@@ -1117,7 +1433,629 @@
            }
        }

        /// <summary>
        /// 移库单的 移库任务完成JC34 兼容AGV小车移库
        /// </summary>
        /// <param name="taskNo"></param>
        /// <param name="userId"></param>
        /// <exception cref="Exception"></exception>
        public void MoveSuccess(string taskNo, int userId)
        {
            try
            {
                Db.BeginTran();
                //正常入库 
                var task = Db.Queryable<LogTask>().First(m => m.IsDel == "0" && m.TaskNo == taskNo);
                if (task == null)
                {
                    throw new Exception("未查询到任务信息");
                }
                if (task.Status == "2")
                {
                    throw new Exception("当前任务已完成");
                }

                var stockDetail = Db.Queryable<DataStockDetail>().Where(m => m.PalletNo == task.PalletNo).ToList();
                //判断是否是回流入库完成
                if (!stockDetail.Any())
                {
                    throw new Exception("没有查询到库存信息");
                }
                //当前任务中的储位信息
                var locate = Db.Queryable<SysStorageLocat>().First(m => m.LocatNo == task.StartLocat);
                if (locate == null)
                {
                    throw new Exception($"未查询到任务中的起始储位信息");
                }
                //当前任务中的储位信息
                var locate2 = Db.Queryable<SysStorageLocat>().First(m => m.LocatNo == task.EndLocat);
                if (locate2 == null)
                {
                    throw new Exception($"未查询到任务中的目标储位信息");
                }
                
                task.Status = "2";//任务状态
                task.IsSend = 0;
                task.IsCancel = 0;
                task.IsFinish = 0;
                task.FinishDate = DateTime.Now;//完成时间
                Db.Updateable(task).ExecuteCommand();
                if (userId != 0)
                {
                    //添加操作日志记录
                    var k = new OperationASNServer().AddLogOperationAsn("库内作业", "库内日志", taskNo, "完成", $"点击完成按钮、完成任务号为：{taskNo}的任务", userId);
                }

                foreach (var item in stockDetail)
                {
                    if (locate2.LocatNo == "B040101")
                    {
                        item.WareHouseNo = "";
                        item.RoadwayNo = "";
                        item.AreaNo = "";
                        item.LocatNo = "";
                    }
                    else
                    {
                        item.WareHouseNo = locate2.WareHouseNo;
                        item.RoadwayNo = locate2.RoadwayNo;
                        item.AreaNo = locate2.AreaNo;
                        item.LocatNo = locate2.LocatNo;
                    }
                    item.UpdateTime = DateTime.Now;
                    if (userId != 0)
                    {
                        item.UpdateUser = userId;
                    }
                }

                if (locate.WareHouseNo != "W04")
                {
                    locate.Status = "0";
                    Db.Updateable(locate).ExecuteCommand();
                }
                
                if (locate2.LocatNo == "B040101")
                {
                    locate2.Status = "0";
                    Db.Updateable(locate2).ExecuteCommand();
                }
                else
                {
                    locate2.Status = "1";
                    Db.Updateable(locate2).ExecuteCommand();
                }
                
                Db.Updateable(stockDetail).ExecuteCommand();
                Db.CommitTran();

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

        /// <summary>
        /// 出库单的移库任务，JC34 货架托盘下架
        /// </summary>
        /// <param name="taskNo">任务号</param>
        /// <param name="userId">操作人</param>
        /// <exception cref="Exception"></exception>
        public void ExMoveSuccess(string taskNo, int userId)
        {
            try
            {
                //当前任务信息
                var task = Db.Queryable<LogTask>().First(m => m.TaskNo == taskNo && m.IsDel == "0");
                if (task == null)
                {
                    throw new Exception($"未查询到任务号为：‘{taskNo}’的任务信息");
                }
                if (task.Status == "2")
                {
                    throw new Exception("当前任务已完成");
                }
                Db.BeginTran();
                //库存中当前托盘的信息
                var stockDetail = Db.Queryable<DataStockDetail>().Where(m => m.PalletNo == task.PalletNo).ToList();
                //当前任务中的目标储位信息
                //当前任务中的原储位
                var locate = Db.Queryable<SysStorageLocat>().First(m => m.LocatNo == task.StartLocat);
                if (locate == null)
                {
                    throw new Exception($"WMS系统中没有该{task.StartLocat}储位对应的信息");
                }
                var locate2 = Db.Queryable<SysStorageLocat>().First(m => m.LocatNo == task.EndLocat);
                if (locate2 == null)
                {
                    throw new Exception($"WMS系统中没有该{task.EndLocat}储位对应的信息");
                }
                //平库中储位集合
                var pingKuLocate = Db.Queryable<SysStorageLocat>().Where(m => m.WareHouseNo == "W04" && m.IsDel == "0").ToList();
                var pingKuList = pingKuLocate.Select(m => m.LocatNo).ToList();
                try
                {

                    //task.Status = "5";//任务状态
                    ////判断起始目标位置都是平库  
                    //if (pingKuList.Contains(task.StartLocat) && pingKuList.Contains(task.EndLocat))
                    //{
                    task.Status = "2";
                    //}

                    task.IsSend = 0;
                    task.IsCancel = 0;
                    task.IsFinish = 0;
                    task.FinishDate = DateTime.Now;//完成时间
                    Db.Updateable(task).ExecuteCommand();

                    #region 修改储位状态

                    if (!pingKuList.Contains(task.StartLocat))
                    {
                        //原储位改为空储位 0
                        locate.Status = "0";
                        Db.Updateable(locate).ExecuteCommand();
                    }


                    //目标储位改为有货物 1
                    locate2.Status = "1";
                    Db.Updateable(locate2).ExecuteCommand();
                    
                    foreach (var item in stockDetail)
                    {
                        item.WareHouseNo = locate2.WareHouseNo;
                        item.AreaNo = locate2.AreaNo;
                        item.RoadwayNo = locate2.RoadwayNo;
                        item.LocatNo = locate2.LocatNo;
                    }
                    Db.Updateable(stockDetail).ExecuteCommand();
                    


                    #endregion

                    Db.CommitTran();
                }
                catch (Exception ex)
                {
                    Db.RollbackTran();
                    throw new Exception(ex.Message);
                }
            }
            catch (Exception ex)
            {
                throw new Exception("完成反馈失败：" + ex.Message);
            }
        }



        /// <summary>
        /// PDA下发出库
        /// </summary>
        /// <param name="soNo"></param>
        /// <param name="detailId"></param>
        /// <param name="outMode"></param>
        /// <param name="palletNo"></param>
        /// <param name="userId"></param>
        /// <param name="url"></param>
        /// <param name="str"></param>
        /// <returns></returns>
        /// <exception cref="Exception"></exception>
        public List<OutCommandDto> IssueOutHouseLk(string soNo, string detailId,string outMode, string palletNo, int userId, string url, out string str)
        {
            try
            {
                var outDto1 = new List<OutCommandDto>(); //出库数据的集合（深度为1的储位）
                //记录错误信息的集合 //1:当前要出库的储位正在移出、2 出库的托盘储位信息错误(在储位表中未查询到)、3储位损坏不能出库、4 要出库的托盘正在入库
                 

                var com = new Common();
                var notice = Db.Queryable<BllExportNotice>().First(m => m.SONo == soNo && m.IsDel == "0");
                if (notice == null)
                {
                    throw new Exception($"未找到{soNo}出库单信息");
                }
                if (notice.WareHouseNo != "W02")
                {
                    throw new Exception("仓库号错误");
                }
                var intDetailId = int.Parse(detailId);
                if (intDetailId <=0) 
                {
                    throw new Exception("选择的出库单明细参数错误");
                }
                //所有要出库的出库分配信息(未下发的信息和待拣货的信息)
                var item = Db.Queryable<BllExportAllot>().First(a => a.IsDel == "0" && a.SONo == soNo && a.SODetailNo == intDetailId && a.PalletNo == palletNo && a.Status == "0" );
                if (item == null) //判断是否有需要下发的出库流水
                {
                    throw new Exception("当前出库单据无需要下发的托盘");
                }

                #region 集合 

                //要出库的明细集合
                var outStockDetail = Db.Queryable<DataStockDetail>().Where(m => m.IsDel == "0" && m.PalletNo == item.PalletNo).ToList();
                //物料编码表
                var skuList = Db.Queryable<SysMaterials>().Where(w => w.IsDel == "0");
                //包装表
                var packagList = Db.Queryable<SysPackag>().Where(w => w.IsDel == "0");
                Db.BeginTran();
                try
                {
                    List<LogTask> logTaskList = new List<LogTask>();//此次出库任务集合，为应对同托盘不同物料出库
                    var i = 0;
                    str = string.Empty;
                    var outLocatelist1 = Db.Queryable<SysStorageLocat>().Where(m => m.IsDel == "0" && m.AreaNo == "B02" && m.Flag == "0").ToList();
                    var outLocatelist2 = Db.Queryable<SysStorageLocat>().Where(m => m.IsDel == "0" && m.AreaNo == "B05" && m.Flag == "0").ToList();
                    //循环分配的信息生成出库任务
                     
                    var outModeLocate = outMode;
                        
                    var taskNoStr = "";

                    // 储位号
                    var locateNo = outStockDetail.First(m => m.PalletNo == item.PalletNo).LocatNo;

                    #region 判断

                    //判断托盘是否在库内
                    if (string.IsNullOrWhiteSpace(locateNo)) //库外
                    {
                        //判断托盘是否在入库中
                        var imBl = com.GetImTask(item.PalletNo);
                        if (imBl != null)
                        {
                            throw new Exception("要出库的托盘正在入库");
                        }
                        //判断是否是已经出过库又回库 
                        if (item.Status == "0")
                        {
                            //如果不在仓库内，当前分配信息直接更新出库完成 
                            item.Status = "2";//状态
                            item.OutMode = outModeLocate;//出库口 
                            Db.Updateable(item).ExecuteCommand();
                            var noticeDetail = Db.Queryable<BllExportNoticeDetail>().First(m => m.IsDel == "0" && m.Id == item.SODetailNo);
                            if (noticeDetail != null) //更新出库单据的下发数量
                            {
                                noticeDetail.FactQty += item.Qty;
                                Db.Updateable(noticeDetail).ExecuteCommand();
                            }

                            //var notice2 = Db.Queryable<BllExportNotice>().First(m => m.IsDel == "0" && m.SONo == item.SONo);
                            if (notice.Status == "0" || notice.Status == "1" || notice.Status == "2")
                            {
                                var detailList = Db.Queryable<BllExportNoticeDetail>().Where(m => m.IsDel == "0" && m.SONo == item.SONo).ToList();
                                if (detailList.Count(m => m.Qty >= m.AllotQty) > 0)
                                {
                                    notice.Status = "3"; //变更状态为正在执行
                                    Db.Updateable(notice).ExecuteCommand();
                                }
                            }
                            Db.CommitTran();
                            str = "托盘已在库外";
                            return outDto1;
                        }
                    }

                    var locate = Db.Queryable<SysStorageLocat>().First(m => m.LocatNo == locateNo && m.IsDel == "0");//当前出库的储位信息
                    if (locate == null)
                    {
                        throw new Exception("出库的托盘储位信息错误(在储位表中未查询到)");
                    }
                    //判断储位标志是否为损坏
                    if (locate.Flag == "2")
                    {
                        throw new Exception("储位损坏不能出库");
                    }
                    if (locate.WareHouseNo != "W02")
                    {
                        throw new Exception("托盘不在货架库上");
                    }
                    var locateEnd = Db.Queryable<SysStorageLocat>().First(m => m.LocatNo == outModeLocate && m.IsDel == "0");//当前出库的目标储位信息
                    if (locateEnd == null)
                    {
                        throw new Exception("出库的托盘储位信息错误(在储位表中未查询到)");
                    }
                    else if (locateEnd.Status != "0")
                    {
                        throw new Exception("目标储位状态不是空储位");
                    }
                    #endregion

                    if (locate.Status == "1") //有物品
                    {
                        #region 添加出库任务

                        var taskNo = new Common().GetMaxNo("TK");
                        var exTask = new LogTask    //出库任务
                        {
                            TaskNo = taskNo,
                            Sender = "WMS",
                            Receiver = "WCS",
                            IsSuccess = 0, //是否下发成功 0失败 1成功

                            StartLocat = locate.LocatNo,//起始位置
                            EndLocat = outModeLocate,//目标位置
                            PalletNo = item.PalletNo,//托盘码
                            IsSend = 1,//是否可再次下发
                            IsCancel = 1,//是否可取消
                            IsFinish = 1,//是否可完成
                            Type = "1",//任务类型 0 入库任务 1 出库任务  2 移库任务
                            Status = "0",//任务状态0：等待执行1正在执行2执行完成
                            OrderType = "1",//0 入库单 1 出库单  2 盘点单  3 移库单
                            Msg = "从" + locate.LocatNo + "到" + outModeLocate + "的出库任务", //关键信息
                        };
                        Db.Insertable(exTask).ExecuteCommand();
                        logTaskList.Add(exTask);

                        outDto1.Add(new OutCommandDto()
                        {
                            TaskNo = exTask.TaskNo, // 任务号
                            TaskType = "1",// 任务类型 (出库)0入 1出 2移 

                            PalletNo = item.PalletNo,//托盘号
                            StartLocate = locate.LocatNo, // 起始位置
                            StartRoadway = locate.RoadwayNo,//其实巷道
                            EndLocate = outModeLocate, // 目标位置 

                            Order = 999,
                            Type = PLCTypeEnum.AGV

                        });
                        taskNoStr = exTask.TaskNo;

                        #endregion

                        #region 改变数据
                        if (item.Status == "0")//判断托盘是否下发过
                        {
                            var noticeDetail = Db.Queryable<BllExportNoticeDetail>().First(m => m.IsDel == "0" && m.Id == item.SODetailNo);
                            if (noticeDetail != null) //更新出库单据的下发数量
                            {
                                noticeDetail.FactQty += item.Qty;
                                Db.Updateable(noticeDetail).ExecuteCommand();
                            }

                            //var notice2 = Db.Queryable<BllExportNotice>().First(m => m.IsDel == "0" && m.SONo == item.SONo);
                            if (notice.Status == "0" || notice.Status == "1" || notice.Status == "2")
                            {
                                var detailList = Db.Queryable<BllExportNoticeDetail>().Where(m => m.IsDel == "0" && m.SONo == item.SONo).ToList();
                                if (detailList.Count(m => m.Qty >= m.AllotQty) > 0)
                                {
                                    notice.Status = "3"; //变更状态为正在执行
                                    Db.Updateable(notice).ExecuteCommand();
                                }
                            }
                        }
                        locate.Status = "3"; //要出库的储位改变状态 正在出库
                        Db.Updateable(locate).ExecuteCommand();
                        var locate2 = Db.Queryable<SysStorageLocat>().First(m => m.LocatNo == outModeLocate && m.IsDel == "0");//当前出库的目标储位信息
                        locate2.Status = "4";
                        Db.Updateable(locate2).ExecuteCommand();

                        item.TaskNo = taskNoStr; // 出库分配信息中更新任务号
                        item.Status = "1"; // 出库分配信息状态改为正在执行 
                        //item.UnstackingMode = unstackingMode2;//拆垛方式
                        item.OutMode = outModeLocate;//出库口
                        //item.LoadingAddre = unstackingMode2 == "0" ? loadingAddre : "";//装车口
                        Db.Updateable(item).ExecuteCommand();

                        #endregion
                        
                    }
                    else if (locate.Status == "3") //出库中
                    {
                        #region 改变数据
                        //判断是否是已经出过库又回库（状态为待拣货的 1）
                        if (item.Status == "0")
                        {
                            var noticeDetail = Db.Queryable<BllExportNoticeDetail>().First(m => m.IsDel == "0" && m.Id == item.SODetailNo);
                            if (noticeDetail != null) //更新出库单据的下发数量
                            {
                                noticeDetail.FactQty += item.Qty;
                                Db.Updateable(noticeDetail).ExecuteCommand();
                            }

                            //var notice2 = Db.Queryable<BllExportNotice>().First(m => m.IsDel == "0" && m.SONo == item.SONo);
                            if (notice.Status == "0" || notice.Status == "1" || notice.Status == "2")
                            {
                                var detailList = Db.Queryable<BllExportNoticeDetail>().Where(m => m.IsDel == "0" && m.SONo == item.SONo).ToList();
                                if (detailList.Count(m => m.Qty >= m.AllotQty) > 0)
                                {
                                    notice.Status = "3"; //变更状态为正在执行
                                    Db.Updateable(notice).ExecuteCommand();
                                }
                            }
                        }
                        var taskNo = Db.Queryable<LogTask>().First(m => m.OrderType == "1" && m.TaskNo != item.TaskNo && m.Status == "1" && m.PalletNo == item.PalletNo);
                        if (taskNo == null)
                        {
                            taskNo = logTaskList.FirstOrDefault(m => m.PalletNo == item.PalletNo);//当前有同托盘不同物料出库
                        }
                        if (taskNo == null)
                        {
                            throw new Exception($"托盘号：{item.PalletNo},出库异常");
                        }
                        item.TaskNo = taskNo.TaskNo;
                        item.Status = "1"; // 出库分配信息状态改为正在执行 
                        item.OutMode = item.OutMode;//出库口
                        //item.UnstackingMode = unstackingMode2;//拆垛模式
                        Db.Updateable(item).ExecuteCommand();
                        
                        #endregion
                    }
                    else if (locate.Status == "5") //移出中
                    {
                        throw new Exception("当前要出库的储位正在移出");
                    }
                    

                    //添加操作日志记录
                    var k = new OperationSOServer().AddLogOperationSo("PDA模块", "下发出库", soNo, "出库", $"点击出库按钮出库单号为：{soNo}的出库单", userId);
                    Db.CommitTran();
                    
                    if (outDto1.Count > 0)
                    {
                        // 正式运行程序放开
                        var list2 = outDto1.Select(m => m.TaskNo).ToList();
                        var jsonData = JsonConvert.SerializeObject(outDto1);
                        string response = "";

                        try
                        {
                            var time1 = DateTime.Now;//发送时间 .ToString("yyyy-MM-dd HH:mm:ss")
                            response = HttpHelper.DoPost(url, jsonData, "下发给WCS出库命令", "WCS");
                            var time2 = DateTime.Now;//返回时间 .ToString("yyyy-MM-dd HH:mm:ss")

                            //解析返回数据 
                            var wcsModel = JsonConvert.DeserializeObject<WcsModel2>(response);
                            if (wcsModel.code == 200)
                            {
                                //更改任务的发送返回时间//
                                new TaskServer().EditTaskIssueOk(list2, time1, time2);
                                str = "下发成功";
                            }
                            else
                            {
                                new TaskServer().EditTaskIssueNo(list2, time1, time2, wcsModel.message);
                                throw new Exception(wcsModel.message);
                            }
                        }
                        catch (Exception ex)
                        {
                            throw new Exception(ex.Message);
                        }

                    }

                    return outDto1;
                }
                catch (Exception e)
                {
                    Db.RollbackTran();
                    throw new Exception(e.Message);
                }


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


        #region MyRegion


        /// <summary>
        /// 向Limes发送请验信息
        /// </summary>
        /// <param name="model">model.Id:请验单主键；model.Code:出库口 </param>
        /// <param name="userId">操作用户</param>
        /// <param name="url">Wcs地址</param>
        /// <returns></returns>
        public bool SendInspectionRequest(IdVm model, int userId, string url, string userName)
        {
            try
            {
                // 判断请验单状态
                var data = Db.Queryable<BllQualityInspectionRequest>()
                    .Where(m => m.QcNo == model.Code && m.IsDel == "0" && m.Status == "0").ToList().FirstOrDefault();
                if (data == null)
                {
                    throw new Exception("操作失败!请验单状态变更.");
                }

                // 记录任务日志
                //var taskNo = new Common().GetMaxNo("TK");
                //var exTask = new LogTask()
                //{
                //     TaskNo = taskNo,
                //     Sender = "WMS",
                //     Receiver = "Limes",
                //     IsSuccess = 0,                  //是否下发成功 0失败 1成功
                //     StartLocat = "",               //起始位置
                //     PalletNo = "",                 //托盘码
                //     IsSend = 1,                    //是否可再次下发
                //     IsCancel = 1,                  //是否可取消
                //     IsFinish = 1,                  //是否可完成    
                //     Status = "0",                  //任务状态0：等待执行1正在执行2执行完成
                //     OrderType = "5",               //0 入库单 1 出库单  2 盘点单  3 移库单 4 取样出库单 5 其他
                //     EndLocat = "",          //目标位置
                //     Type = "3",                     //任务类型 0 入库任务 1 出库任务  2 移库任务
                //     Msg = "请验任务"
                //};

                //// 插入任务日志
                //Db.Insertable(exTask).ExecuteCommand();


                // 调用Limes接口发起请验
                var sendModel = new SendLimesModel()
                {
                    QcNo = data.QcNo,
                    SkuNo = data.SkuNo,
                    Qty = data.Qty.ToString(),
                    LotNo = data.LotNo,
                    SupplierLot = data.SupplierLot,
                    RequestUser = userName,                       // 请验人
                };
                var jsonData = JsonConvert.SerializeObject(sendModel);
                string response = "";

                try
                {
                    var time1 = DateTime.Now;//发送时间 .ToString("yyyy-MM-dd HH:mm:ss")
                    //response = HttpHelper.DoPost(url, jsonData, "上传Limes系统发起请验", "Limes");
                    var time2 = DateTime.Now;//返回时间 .ToString("yyyy-MM-dd HH:mm:ss")

                    ////解析返回数据 
                    //var limesModel = JsonConvert.DeserializeObject<LimesModel>(response);
                    //if (limesModel.Success == 0)
                    //{
                    

                    // 更新请验单信息
                    data.Status = "1";
                    data.SamplingQty = 10;//decimal.Parse(limesModel.SamplingQty);
                    data.RequestUser = userId;
                    data.RequestTime = DateTime.Now;
                    data.UpdateTime = DateTime.Now;
                    data.UpdateUser = userId;

                    Db.Updateable(data).ExecuteCommand();
                    //}
                    //if (limesModel.Success == -1)
                    //{
                    
                    //    throw new Exception(limesModel.Message);
                    //}
                }
                catch (Exception ex)
                {
                    throw new Exception(ex.Message);
                }

                //添加操作日志记录
                var k = new OperationCrServer()
                    .AddLogOperationCr("质量管理", "质检请验", model.Code, "请验", $"向质量部分发起请验!", userId);

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

        #endregion


    }