修改问题

DESKTOP-9BNTV8O

2024-12-13 6c3738d337fe68c2008b38ad58861aa4b48d5530

 Wms/WMS.BLL/BllTransServer/RcsServer.cs

@@ -1,8 +1,10 @@
using Newtonsoft.Json;
using Model.InterFaceModel;
using Newtonsoft.Json;
using SqlSugar;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Security.Policy;
using System.Text;
using Utility.Tools;
using WMS.DAL;
@@ -26,19 +28,28 @@
        /// <param name="warehouseno">库区</param>
        /// <param name="type">叫料类型</param>
        /// <returns></returns>
        public void GetPalletNo(Pallnetmsg pallnetmsg)
        public void GetPalletNo(Pallnetmsg model,string url,out string taskNo)
        {
            DataStockDetail pallet = new DataStockDetail();
            try
            {
                var house = "W01";//叫桶位置，后续根据位置关联或定义，来判断叫桶位置所属车间
                var url = "";//回传MES的接口地址
                if (string.IsNullOrEmpty(model.Location))
                {
                    throw new Exception("设备所在位置不可为空");
                }
                var locatInfo = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.LocatNo == model.Location);
                if (locatInfo == null)
                {
                    throw new Exception("设备储位信息不存在");
                }
                var house = locatInfo.WareHouseNo;//叫桶位置，后续根据位置关联或定义，来判断叫桶位置所属车间
                var urlMes = "";//回传MES的接口地址
                var noticeno = "0";//出入库单据明细ID
                var sql = "select PalletNo,LocatNo from DataStockDetail where Status = '0'";
                switch (pallnetmsg.Type)
                switch (model.Type)
                {
                    case "0"://叫净桶
                        sql += $"and WareHouseNo = '{house}' and AreaNo like '%01' and PalletStatus = '0' order by CreateTime desc";
                        sql += $"and WareHouseNo = '{house}' and (AreaNo like '%01' or AreaNo like '%11' or AreaNo like '%21' or AreaNo like '%31') and PalletStatus = '0' order by CreateTime desc";
                        pallet = Db.Ado.SqlQuery<DataStockDetail>(sql).FirstOrDefault();
                        if (pallet == null)
                        {
@@ -48,21 +59,12 @@
                        break;
                    case "1"://叫料桶（混料）
                        //判断是否有批次号
                        if (string.IsNullOrWhiteSpace(pallnetmsg.LotNo))
                        if (string.IsNullOrWhiteSpace(model.LotNo))
                        {
                            throw new Exception("批次号为空！");
                        }
                        /*BllArrivalNoticeDetail ArriveMes = new BllArrivalNoticeDetail();
                        //判断该批次是否有对应入库单
                        sql = $"select * from BllArrivalNoticeDetail where LotNo =  '{pallnetmsg.LotNo}' order by CreateTime desc";
                        ArriveMes = Db.Ado.SqlQuery<BllArrivalNoticeDetail>(sql).FirstOrDefault();
                        if (ArriveMes == null)
                        {
                            throw new Exception("该批次没有对应的入库单");
                        }
                        noticeno = ArriveMes.Id.ToString();*/
                        //查找库存中是否有可用的此批次的混料桶
                        sql= $@"select PalletNo,LocatNo from DataStockDetail where LotNo =  '{pallnetmsg.LotNo}'and AreaNo like '%02'
                        sql= $@"select PalletNo,LocatNo from DataStockDetail where LotNo = '{model.LotNo}'and  (AreaNo like '%02' or AreaNo like '%12' or AreaNo like '%22' or AreaNo like '%32')
                                   and WareHouseNo = '{house}' and status = '0' and PalletStatus = '1' order by CompleteTime desc";
                        pallet = Db.Ado.SqlQuery<DataStockDetail>(sql).FirstOrDefault();
                        if (pallet == null)
@@ -74,21 +76,21 @@
                    case "2"://叫料桶（下料）
                        BllExportNoticeDetail bllSo = new BllExportNoticeDetail();
                        //判断是否有批次号
                        if (string.IsNullOrWhiteSpace(pallnetmsg.LotNo))
                        if (string.IsNullOrWhiteSpace(model.LotNo))
                        {
                            throw new Exception("批次号为空！");
                        }
                        //查找是否有此批次出库单
                        sql = $"select * from BllExportNoticeDetail where LotNo =  '{pallnetmsg.LotNo}' order by CreateTime desc";
                        sql = $"select * from BllExportNoticeDetail where LotNo =  '{model.LotNo}' order by CreateTime desc";
                        bllSo = Db.Ado.SqlQuery<BllExportNoticeDetail>(sql).FirstOrDefault();
                        if (bllSo == null)
                        {
                            throw new Exception("该批次没有对应的出库单");
                        }
                        noticeno = bllSo.Id.ToString();
                        //查找库存中是否有此批次的下料桶
                        sql = $@"select PalletNo,LocatNo from DataStockDetail where LotNo = '{pallnetmsg.LotNo}'and AreaNo like '%03' 
                                    and WareHouseNo = '{house}' and status = '0' and PalletStatus = '2' order by CompleteTime desc";
                        //查找库存中是否有此批次的合格下料桶
                        sql = $@"select PalletNo,LocatNo from DataStockDetail where LotNo = '{model.LotNo}'and (AreaNo like '%03' or AreaNo like '%13' or AreaNo like '%23' or AreaNo like '%33')
                                    and WareHouseNo = '{house}' and status = '0' and PalletStatus = '2' and InspectStatus = '1' order by CompleteTime desc";
                        pallet = Db.Ado.SqlQuery<DataStockDetail>(sql).FirstOrDefault();
                        if (pallet == null)
                        {
@@ -97,7 +99,7 @@

                        break;
                    case "3"://叫脏桶
                        sql += $"and WareHouseNo = '{house}' and AreaNo like '%04' and PalletStatus='3' order by CreateTime desc";
                        sql += $"and WareHouseNo = '{house}' and  (AreaNo like '%04' or AreaNo like '%14' or AreaNo like '%24' or AreaNo like '%34') and PalletStatus='3' order by CreateTime desc";
                        List<DataStockDetail> palletList = Db.Ado.SqlQuery<DataStockDetail>(sql).ToList();
                        if (palletList.Count <= 0)
                        {
@@ -106,57 +108,74 @@
                        //遍历库存脏桶，返回MES验证
                        foreach (var item in palletList)
                        {
                            string jsonReq = JsonConvert.SerializeObject(item.PalletNo);
                            var response = HttpHelper.DoPost(url, jsonReq, "回传MES脏桶编号", "RCS").ToString();
                            var obj = JsonConvert.DeserializeObject<ReMes>(response);//解析返回数据
                            if (obj.Success == "0")
                            {
                                if (obj.Result != "1")//不可清洗，将脏桶冻结
                                {
                                    item.Status = "5";//异常冻结
                                    //修改该桶库存状态
                                    Db.Updateable(item).ExecuteCommand();
                            #region 去掉MES
                            //string jsonReq = JsonConvert.SerializeObject(item.PalletNo);
                            //var response = HttpHelper.DoPost(urlMes, jsonReq, "回传MES脏桶编号", "RCS").ToString();
                            //var obj = JsonConvert.DeserializeObject<ReMes>(response);//解析返回数据
                            //if (obj.Success == "0")
                            //{
                            //    if (obj.Result != "1")//不可清洗，将脏桶冻结
                            //    {
                            //        item.Status = "5";//异常冻结
                            //        //修改该桶库存状态
                            //        Db.Updateable(item).ExecuteCommand();

                                    continue;
                                }
                                //下发小车任务
                                var task2 = new TaskDetial
                                {
                                    Startport = item.LocatNo,
                                    Endport = pallnetmsg.Location,
                                    Pallno = item.PalletNo,
                                    Type = pallnetmsg.Type,
                                    Crtype = "1",
                                    Noticedetailno = int.Parse(noticeno),
                                };
                                CreateLotTask(task2);
                                return;
                            }
                            else
                            //        continue;
                            //    }
                            //    //下发小车任务
                            //    var task2 = new TaskDetial
                            //    {
                            //        Startport = item.LocatNo,
                            //        Endport = model.Location,
                            //        Pallno = item.PalletNo,
                            //        Type = model.Type,
                            //        Crtype = "1",
                            //        Noticedetailno = int.Parse(noticeno),
                            //    };
                            //    CreateLotTask(task2);
                            //    return;
                            //}
                            //else
                            //{
                            //    throw new Exception("回传MES净桶编号失败！");
                            //}
                            #endregion

                            //下发小车任务
                            var task2 = new TaskDetial
                            {
                                throw new Exception("回传MES净桶编号失败！");
                            }
                                Startport = item.LocatNo,
                                Endport = model.Location,
                                Pallno = item.PalletNo,
                                Type = model.Type,
                                Crtype = "1",
                                Noticedetailno = int.Parse(noticeno),
                            };
                            CreateLotTask(task2, url, out taskNo);
                            return;
                        }
                        break;
                    default:
                        throw new Exception("任务类型无效");
                }
                //下发小车任务
                var task = new TaskDetial
                {
                    Startport = pallet.LocatNo,
                    Endport = pallnetmsg.Location,
                    Pallno = pallet.PalletNo,
                    Type = pallnetmsg.Type,
                    Startport = pallet.LocatNo,//起始位置
                    Endport = model.Location,//目标位置
                    Pallno = pallet.PalletNo,//桶号
                    Type = model.Type,//桶类型
                    Crtype = "1",
                    Noticedetailno = int.Parse(noticeno),
                    LotNo = pallnetmsg.LotNo,
                    LotNo = model.LotNo,
                };
                CreateLotTask(task);
                CreateLotTask(task, url, out taskNo);
                return;
            }
            catch (Exception ex)
            {
                Db.Ado.RollbackTran();
                throw ex;
                throw new Exception(ex.Message);
            }
        }

@@ -165,7 +184,7 @@
        /// </summary>
        /// <param name="PalletNo"></param>
        /// <returns></returns>
        public void ChangePalletStatus(string PalletNo)
        public void ChangePalletStatus(string PalletNo,string url)
        {
            try
            {
@@ -204,7 +223,8 @@
                        Crtype = "2",
                        Noticedetailno = 0,
                    };
                    CreateLotTask(ztask);
                    string taskNo = "";
                    CreateLotTask(ztask, url, out taskNo);

                    statrtLocat.Status = "3";//出库中
                    //修改起始储位状态
@@ -228,7 +248,7 @@
        /// MES下发清洗锁定脏桶
        /// </summary>
        /// <param name="pallnetmsg"></param>
        public void CleanPallet(Pallnetmsg pallnetmsg)
        public void CleanPallet(Pallnetmsg pallnetmsg,string url)
        {
            try
            {
@@ -248,7 +268,8 @@
                    Noticedetailno = 0,
                    LotNo = "",
                };
                CreateLotTask(task);
                string taskNo = "";
                CreateLotTask(task,url, out taskNo);
            }
            catch (Exception ex)
            {
@@ -261,231 +282,171 @@
        /// </summary>
        /// <param name="PalletNo"></param>
        /// <returns></returns>
        public void ApplyLocatNo(Pallnetmsg pallnetmsg)
        public void ApplyLocatNo(Pallnetmsg model,string url, out string taskNo)
        {
            var sql = $"select LocatNo from SysStorageLocat where status = '0'";
            var sql2 = "";
            var house = "W01";//……叫桶位置，后续根据位置关联或定义，来判断叫桶位置所属车间
            var houseNo = "";//申请储位设备所在车间编号
            var noticeno = "0";//出入库单据明细ID
            SysStorageLocat loction = new SysStorageLocat();
            BllArrivalNoticeDetail ArriveMes = new BllArrivalNoticeDetail();
            SysStorageLocat loction = new SysStorageLocat();//目标储位信息
            BllArrivalNoticeDetail noticeDetail = new BllArrivalNoticeDetail();//入库单明细
            try
            {
                switch (pallnetmsg.Type)
                //设备所在储位信息
                var deviceLocatInfo = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.LocatNo == model.LotNo);
                if (deviceLocatInfo == null)
                {
                    case "0"://净桶申请储位
                        sql += $"and AreaNo like '%01' and WareHouseNo = '{house}'";
                    throw new Exception($"未查询到该设备所在储位信息，Location:{model.Location}");
                }
                houseNo = deviceLocatInfo.WareHouseNo;//设备所属车间
                switch (model.Type)
                {
                    case "3"://清洗设备申请储位（净桶申请储位）
                        sql += $" and (AreaNo like '%01' or AreaNo like '%11' or AreaNo like '%21' or AreaNo like '%31') and WareHouseNo = '{houseNo}'";
                        loction = Db.Ado.SqlQuery<SysStorageLocat>(sql).OrderByDescending(a => a.CreateTime).FirstOrDefault();
                        if (loction == null)
                        {
                            throw new Exception("库内暂无空余净桶储位");
                            throw new Exception("该车间净桶区暂无空余储位");
                        }
                        break;
                    case "1"://混料桶申请储位
                    case "0"://接料设备申请储位（预混料桶申请储位）
                        //判断是否有批次号
                        if (string.IsNullOrWhiteSpace(pallnetmsg.LotNo))
                        if (string.IsNullOrWhiteSpace(model.LotNo))
                        {
                            throw new Exception("批次号为空！");
                        }
                        sql += $" and (AreaNo like '%02' or AreaNo like '%12' or AreaNo like '%22' or AreaNo like '%32') and WareHouseNo = '{houseNo}'";
                        loction = Db.Ado.SqlQuery<SysStorageLocat>(sql).OrderByDescending(a => a.CreateTime).FirstOrDefault();
                        if (loction == null)
                        {
                            throw new Exception("该车间预混区暂无空余储位");
                        }
                        break;
                    case "1"://混料设备申请储位（半成品桶申请储位）
                        //判断是否有批次号
                        if (string.IsNullOrWhiteSpace(model.LotNo))
                        {
                            throw new Exception("批次号为空！");
                        }
                        //校验此批次是否有入库单
                        /*sql2 = $"select * from BllArrivalNoticeDetail where LotNo =  '{pallnetmsg.LotNo}' order by CreateTime desc";
                        ArriveMes = Db.Ado.SqlQuery<BllArrivalNoticeDetail>(sql).FirstOrDefault();
                        if (ArriveMes == null)
                        sql2 = $"select * from BllArrivalNoticeDetail where LotNo =  '{model.LotNo}' order by CreateTime desc";
                        noticeDetail = Db.Ado.SqlQuery<BllArrivalNoticeDetail>(sql2).FirstOrDefault();
                        if (noticeDetail == null)
                        {
                            throw new Exception("该批次没有对应的入库单");
                        }
                        noticeno = ArriveMes.Id.ToString();*/
                        sql += $"and AreaNo  like '%02' and WareHouseNo = '{house}'";
                        noticeno = noticeDetail.Id.ToString();
                        sql += $" and (AreaNo like '%03' or AreaNo like '%13' or AreaNo like '%23' or AreaNo like '%33') and WareHouseNo = '{houseNo}'";
                        loction = Db.Ado.SqlQuery<SysStorageLocat>(sql).OrderByDescending(a => a.CreateTime).FirstOrDefault();
                        if (loction == null)
                        {
                            throw new Exception("库内暂无空余混料桶储位");
                            throw new Exception("该车间半成品区暂无空余储位");
                        }
                        break;
                    case "2"://半成品桶申请储位
                        //判断是否有批次号
                        if (string.IsNullOrWhiteSpace(pallnetmsg.LotNo))
                        {
                            throw new Exception("批次号为空！");
                        }
                        //校验此批次是否有入库单
                        sql2 = $"select * from BllArrivalNoticeDetail where LotNo =  '{pallnetmsg.LotNo}' order by CreateTime desc";
                        ArriveMes = Db.Ado.SqlQuery<BllArrivalNoticeDetail>(sql2).FirstOrDefault();
                        if (ArriveMes == null)
                        {
                            throw new Exception("该批次没有对应的入库单");
                        }
                        noticeno = ArriveMes.Id.ToString();
                        sql += $"and AreaNo like '%03' and WareHouseNo = '{house}'";
                    case "2"://下料设备申请储位（脏桶申请储位）
                        sql += $" and (AreaNo like '%04' or AreaNo like '%14' or AreaNo like '%24' or AreaNo like '%34') and WareHouseNo = '{houseNo}'";
                        loction = Db.Ado.SqlQuery<SysStorageLocat>(sql).OrderByDescending(a => a.CreateTime).FirstOrDefault();
                        if (loction == null)
                        {
                            throw new Exception("库内暂无空余半成品桶储位");
                        }
                        break;
                    case "3"://脏桶申请储位
                        sql += $"and AreaNo like '%04' and WareHouseNo = '{house}'";
                        loction = Db.Ado.SqlQuery<SysStorageLocat>(sql).OrderByDescending(a => a.CreateTime).FirstOrDefault();
                        if (loction == null)
                        {
                            throw new Exception("库内暂无空余脏桶储位");
                            throw new Exception("该车间脏桶区暂无空余储位");
                        }
                        break;
                }
                var task = new TaskDetial
                {
                    Startport = pallnetmsg.Location,
                    Startport = model.Location,
                    Endport = loction.LocatNo,
                    Pallno = pallnetmsg.PalletNo,
                    Type = pallnetmsg.Type,
                    Crtype = "0",
                    Pallno = model.PalletNo,
                    Type = model.Type,
                    Crtype = "0",//入库
                    Noticedetailno = int.Parse(noticeno),
                    LotNo = pallnetmsg.LotNo,
                    LotNo = model.LotNo,
                };
                CreateLotTask(task);
            }
            catch (Exception)
            {

                throw;
            }
        }


        /// <summary>
        /// RCS生成任务
        /// </summary>
        /// <param name="taskCode"></param>
        /// <param name="taskType"></param>
        /// <param name="startPos">起始位置</param>
        /// <param name="endPos">目的位置</param>
        /// <param name="agvCode"></param>
        /// <param name="url">RCS地址</param>
        /// <returns></returns>
        public genAgvSchedulingTaskRep genAgvSchedulingTask(AgvTask agv,string url)
        {
            try
            {
                genAgvSchedulingTaskRep cbrep = new genAgvSchedulingTaskRep();
                PositionCodePath pcd1 = new PositionCodePath()
                {
                    positionCode = agv.startPos.ToString(),
                    type = "00",
                };
                PositionCodePath pcd2 = new PositionCodePath()
                {
                    positionCode = agv.endPos.ToString(),
                    type = "00",
                };
                List<PositionCodePath> lst = new List<PositionCodePath>();
                lst.Add(pcd1);
                lst.Add(pcd2);
                genAgvSchedulingTaskReq cbreq = new genAgvSchedulingTaskReq()
                {
                    reqCode = agv.taskCode.ToString(),
                    taskCode = agv.taskCode.ToString(),
                    taskTyp = agv.taskType,
                    positionCodePath = lst,
                    podCode = "",
                    agvCode = agv.agvCode,
                    ctnrTyp = "1",
                    //ctnrCode="2",

                };
                cbrep = genAgvSchedulingTask(cbreq,url);
                

                return cbrep;
            }
            catch (Exception ex) { throw ex; }
        }

        /// <summary>
        /// 生成任务单
        /// </summary>
        /// <param name="req"></param>
        /// <returns></returns>
        private genAgvSchedulingTaskRep genAgvSchedulingTask(genAgvSchedulingTaskReq req,string url)
        {
            genAgvSchedulingTaskRep rep = new genAgvSchedulingTaskRep()
            {
                code = "-1",
                message = "生产任务单失败"
            };
            if (req == null)
            {
                return rep;
            }
            try
            {
                string jsonReq = JsonConvert.SerializeObject(req);

                string jsonRep = HttpHelper.DoPost(url + "/genAgvSchedulingTask", jsonReq,"小车任务下发","RCS");
                jsonRep = jsonRep.TrimStart('\"');
                jsonRep = jsonRep.TrimEnd('\"');
                jsonRep = jsonRep.Replace("\\", "");
                rep = JsonConvert.DeserializeObject<genAgvSchedulingTaskRep>(jsonRep);
                return rep;
                CreateLotTask(task, url, out taskNo);
            }
            catch (Exception ex)
            {
                throw ex;
                throw new Exception(ex.Message);
            }
        }


        /// <summary>
        /// 生成任务单到LogTask
        /// </summary>
        /// <param name="req"></param>
        /// <returns></returns>
        public void CreateLotTask(TaskDetial taskDetial)
        public void CreateLotTask(TaskDetial taskDetial,string url,out string taskNo)
        {
            try
            {
                var stockDetail = Db.Queryable<DataStockDetail>().First(w => w.IsDel == "0" && w.PalletNo == taskDetial.Pallno);//桶库存明细
                if (stockDetail == null)
                {
                    throw new Exception($"该桶未在库存中，桶号：{taskDetial.Pallno}");
                }
                //开启事务
                Db.BeginTran();
                var na = "";
                var typeDesc = "";
                switch (taskDetial.Crtype)
                {
                    case "0":
                        na = "入库";
                        typeDesc = "入库";
                        break;
                    case "1":
                        na = "出库";
                        typeDesc = "出库";
                        break;
                    case "2":
                        na = "移库";
                        typeDesc = "移库";
                        break;
                }
                var bz = "";
                var msg = "";
                switch (taskDetial.Type)
                {
                    case "0":
                        bz = "净桶"+na+"任务";
                        msg = "净桶"+ typeDesc + "任务";
                        break;
                    case "1":
                        bz = "预混料桶" + na + "任务";
                        msg = "预混料桶" + typeDesc + "任务";
                        break;
                    case "2":
                        bz = "半成品料桶" + na + "任务";
                        msg = "半成品料桶" + typeDesc + "任务";
                        break;
                    case "3":
                        bz = "脏桶" + na + "任务";
                        msg = "脏桶" + typeDesc + "任务";
                        break;
                }
                #region 储位信息
                //起始储位地址信息
                var startLoction = Db.Queryable<SysStorageLocat>().First(w => w.IsDel=="0" && w.LocatNo == taskDetial.Startport);
                if (startLoction == null)
                {
                    throw new Exception($"起始目标储位信息不存在，桶号：{taskDetial.Startport}");
                }
                //目标储位地址信息
                var endLoction = Db.Queryable<SysStorageLocat>().First(w => w.IsDel == "0" && w.LocatNo == taskDetial.Endport);
                if (endLoction == null)
                {
                    throw new Exception($"目标目标储位信息不存在，桶号：{taskDetial.Endport}");
                }
                #endregion
                var sql = "";
                var sql2 = "";
                var ordertype = "3";
                //涉及出入库单据的状态信息改变
                if (taskDetial.Type == "2" && taskDetial.Crtype =="1")//半成品出库
                if (taskDetial.Type == "2" && taskDetial.Crtype == "1")//半成品出库
                {
                    ordertype = "1";
                    sql = $"UPDATE BllExportNotice SET Status ='1' " +
                        $"where asnno = (select ASNNO from BllExportNoticeDetail where id = {taskDetial.Noticedetailno})";
                        $"where SoNO = (select SoNO from BllExportNoticeDetail where id = {taskDetial.Noticedetailno})";
                    Db.Ado.ExecuteCommand(sql);
                }
                else if(taskDetial.Type =="2" && taskDetial.Crtype == "0")//半成品入库
                else if (taskDetial.Type == "0" && taskDetial.Crtype == "0")//接料设备申请储位（混料桶申请储位）
                {
                    stockDetail.LotNo = taskDetial.LotNo;//批次号
                    //更新桶库存明细批次号
                    Db.Updateable(stockDetail).ExecuteCommand();
                }   
                else if (taskDetial.Type == "1" && taskDetial.Crtype == "0")//混料设备申请储位（半成品桶申请储位）
                {
                    ordertype = "0";
                    var ArrivalMsg = Db.Queryable<BllArrivalNoticeDetail>().First(it => it.Id == taskDetial.Noticedetailno);
@@ -496,7 +457,7 @@
                    sql2 = $"UPDATE DataStockDetail SET SkuNo = '{ArrivalMsg.SkuNo}',SkuName = '{ArrivalMsg.SkuName}' " +
                        $"where PalletNo = '{taskDetial.Pallno}'and LotNo = '{taskDetial.LotNo}'";
                    Db.Ado.ExecuteCommand(sql2);
                }
                }               
                
                //判断任务是否为新任务
                if (string.IsNullOrWhiteSpace(taskDetial.Taskno))
@@ -521,46 +482,102 @@
                    OrderType = ordertype,//单据类型 0 入库 1 出库 3其他
                    Status = "0",//任务状态0：等待执行1正在执行2执行完成
                    NoticeDetailNo = int.Parse(taskDetial.Noticedetailno.ToString()),
                    Msg = bz, //关键信息
                    Msg = msg, //关键信息
                };
                var Agv = new AgvTask
                taskNo = logTaskEntry.TaskNo;

                #region 呼叫小车代码
                List<AgvSchedulingTask> agvTaskList = new List<AgvSchedulingTask>();

                List<PositionCodePath> pahtList = new List<PositionCodePath>();
                //起始位置
                PositionCodePath path1 = new PositionCodePath();
                path1.positionCode = taskDetial.Startport;
                if (taskDetial.Crtype == "1")//叫桶（桶出库）
                {
                    taskCode = taskDetial.Taskno,
                    taskType = taskDetial.Type,
                    startPos = taskDetial.Startport,
                    endPos = taskDetial.Endport,
                    agvCode = "1",//……需要和AGV确认此字段值
                };
                
                //请求小车
                genAgvSchedulingTaskRep chrep =genAgvSchedulingTask(Agv, "url");
                if (chrep.code != "0")
                {
                    logTaskEntry.IsSuccess = 0;
                    Db.Insertable(logTaskEntry).ExecuteCommand();
                    Db.CommitTran();
                    throw new Exception("RCS任务下发错误，RCS返回消息：" + chrep.message);
                    path1.type = "05";
                }
                //请求成功修改任务表相应字段状态
                logTaskEntry.IsSuccess = 1;
                logTaskEntry.BackDate = DateTime.Now;
                logTaskEntry.Status = "1";
                if (taskDetial.Crtype == "0" || taskDetial.Crtype == "2")
                else//申请储位（桶入库）
                {
                    sql = $"UPDATE SysStorageLocat SET Status = '2' where LocatNo = '{taskDetial.Endport}'";
                    if (taskDetial.Type == "2")
                    path1.type = "05";
                }
                pahtList.Add(path1);

                //目标位置
                PositionCodePath path2 = new PositionCodePath();
                path2.positionCode = taskDetial.Endport;
                if (taskDetial.Crtype == "1")//叫桶（桶出库）
                {
                    path2.type = "05";
                }
                else//申请储位（桶入库）
                {
                    path2.type = "05";
                }
                pahtList.Add(path2);

                //下车任务单
                AgvSchedulingTask agvTask = new AgvSchedulingTask();
                agvTask.reqCode = logTaskEntry.TaskNo;//任务号
                agvTask.ctnrTyp = "1";
                agvTask.reqTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");//请求时间                
                agvTask.wbCode = "";
                agvTask.positionCodePath = pahtList;//小车路径
                agvTask.podCode = "";
                agvTask.userCallCode = "";//taskDetial.Endport;//目标位置
                if (taskDetial.Crtype == "1")//叫桶（桶出库）
                {
                    agvTask.taskTyp = "Z3";//任务类型 线边到托盘收集器 Z1， 托盘垛申请入库 Z2
                }
                else//申请储位（桶入库）
                {
                    agvTask.taskTyp = "Z4";//任务类型 线边到托盘收集器 Z1， 托盘垛申请入库 Z2
                }
                agvTaskList.Add(agvTask);

                // 正式运行程序放开
                string str = "";
                var list2 = agvTaskList.Select(m => m.reqCode).ToList();
                var jsonData = JsonConvert.SerializeObject(agvTaskList);
                jsonData = jsonData.Substring(1);
                jsonData = jsonData.Substring(0, jsonData.Length - 1);
                string response = "";
                try
                {
                    logTaskEntry.SendDate = DateTime.Now;//发送时间

                    response = HttpHelper.DoPost(url, jsonData, "下发给AGV转运命令", "AGV");
                    //解析返回数据 
                    var agvModel = JsonConvert.DeserializeObject<OutCommanAgvDto>(response);
                    if (agvModel.Code == "0")
                    {
                        sql2 = $"UPDATE DataStockDetail SET PalletStatus = '{taskDetial.Type}',LotNo = '{taskDetial.LotNo}' " +
                        $"where PalletNo = '{taskDetial.Pallno}'";
                        Db.Ado.ExecuteCommand(sql2);
                        str += "下发成功";

                        //请求成功修改任务表相应字段状态
                        logTaskEntry.IsSuccess = 1;
                        logTaskEntry.BackDate = DateTime.Now;
                        logTaskEntry.Status = "1";                        
                        Db.Insertable(logTaskEntry).ExecuteCommand();

                        startLoction.Status = "3";//出库中
                        Db.Updateable(startLoction).ExecuteCommand();

                        endLoction.Status = "2";//入库中
                        Db.Updateable(endLoction).ExecuteCommand();
                    }
                    if (agvModel.Code == "1")
                    {
                        logTaskEntry.IsSuccess = 0;
                        Db.Insertable(logTaskEntry).ExecuteCommand();
                        Db.CommitTran();
                        throw new Exception("RCS任务下发错误，RCS返回消息：" + agvModel.Message);
                    }
                }
                else
                catch (Exception ex)
                {
                    sql = $"UPDATE SysStorageLocat SET Status = '3' where LocatNo = '{taskDetial.Startport}' ";
                    throw new Exception(ex.Message);
                }
                Db.Insertable(logTaskEntry).ExecuteCommand();
                Db.Ado.ExecuteCommand(sql);
                #endregion
                //提交事务
                Db.CommitTran();
            }