1111

lss

3 天以前 17e3ef45fe0a6b6f8a147b50740834ac734f9317

 HH.WCS.Mobox3/HH.WCS.Mobox3.DaYang/api/ApiHelper.cs

@@ -169,7 +169,7 @@
                try
                {
                    // 1 空托回库
                    if (model.TaskType == "1")
                    if (model.TaskType.Trim() == "1")
                    {
                        Type = "空托入库";

@@ -181,6 +181,23 @@
                            result.Msg = $"根据起点:{model.startBit}未找到货位信息";
                            LogHelper.Info($"creattask:{result.Msg}");
                            return result;
                        }
                        else
                        {
                            if (startloc.N_LOCK_STATE != 0)
                            {
                                result.Code = -1;
                                result.Msg = $"起点:{model.startBit}货位存在任务，该货位不允许再呼叫，请等待任务完成";
                                LogHelper.Info($"creattask:{result.Msg}");
                                return result;
                            }
                            if (startloc.N_CURRENT_NUM == 0)
                            {
                                result.Code = -1;
                                result.Msg = $"起点:{model.startBit}货位不存在托盘，不允许下发任务";
                                LogHelper.Info($"creattask:{result.Msg}");
                                return result;
                            }
                        }

                        #endregion
@@ -240,7 +257,7 @@

                    }
                    // 2 出库
                    if (model.TaskType == "2")
                    else if (model.TaskType.Trim() == "2")
                    {
                        Type = "出库";

@@ -253,6 +270,23 @@
                            LogHelper.Info($"creattask:{result.Msg}");
                            return result;
                        }
                        else
                        {
                            if (endloc.N_LOCK_STATE != 0)
                            {
                                result.Code = -1;
                                result.Msg = $"终点:{model.startBit}货位存在任务，该货位不允许再呼叫，请等待任务完成";
                                LogHelper.Info($"creattask:{result.Msg}");
                                return result;
                            }
                            if (endloc.N_CURRENT_NUM == 0)
                            {
                                result.Code = -1;
                                result.Msg = $"起点:{model.startBit}货位不存在托盘，不允许下发任务";
                                LogHelper.Info($"creattask:{result.Msg}");
                                return result;
                            }
                        }
                        #endregion

                        #region 根据物料计算出库托盘，先进先出，优先出外侧
@@ -261,6 +295,13 @@
                        if (location != null)
                        {
                            startloc = location;
                        }
                        else
                        {
                            result.Code = -1;
                            result.Msg = $"根据物料:{model.ItemCode}未找到库存托盘，或货位有锁，数量存在问题，请检查货位表";
                            LogHelper.Info($"creattask:{result.Msg}");
                            return result;
                        }

                        #endregion
@@ -342,87 +383,204 @@
            Location endloc = new Location();
            Location startloc = new Location();
            string cntrcode = model.CntrNo;
            string DiePanLoc = "";
            string DiePanLoc = "CPDPJ-1-1";
            // string itemCode = "";
            var db = new SqlHelper<object>().GetInstance();

            if (model.DeviceNo == "1")//叠盘机
            {
                //判断设备状态是否属于叠盘状态
                var DeviceStatu = db.Queryable<EquipmentStatus>().Where(a => a.deviceNo == model.DeviceNo).First();
                if (DeviceStatu != null && DeviceStatu.Status == "1")
                if (model.SignalType == 1)
                {
                    #region 获取起点信息，并判断空托是否叠满
                    //根据起点 获取绑定托盘数量
                    //var CntrLoc = db.Queryable<LocCntrRel>().Where(a => a.S_LOC_CODE == model.Loc).ToList();
                    //if (CntrLoc.Count < 4)
                    //{
                    //    result.Code = -1;
                    //    result.Msg = $"根据货位:{model.Loc}获取托盘数量小于4";
                    //    LogHelper.Info($"EquipmentInfo:{result.Msg}");
                    //    return result;
                    //}
                    //else
                    //{
                    //    //拼接托盘号
                    //    cntrcode = CntrLoc.Select(a => a.S_CNTR_CODE).ToString();
                    //}
                    cntrcode = model.CntrNo;
                    startloc = LocationHelper.GetLoc(model.Loc);
                    if (startloc == null)
                    //判断设备状态是否属于叠盘状态
                    var DeviceStatu = db.Queryable<EquipmentStatus>().Where(a => a.DEVICENO == model.DeviceNo).First();
                    if (DeviceStatu != null && DeviceStatu.STATUS == "1")
                    {
                        result.Code = -1;
                        result.Msg = $"根据起点:{model.Loc}未找到货位信息";
                        LogHelper.Info($"EquipmentInfo:{result.Msg}");
                        return result;
                    }
                    #endregion

                    #region 计算立库终点

                    endloc = LocationHelper.InStorage("");
                    if (endloc == null)
                    {
                        result.Code = -1;
                        result.Msg = $"未计算到立库终点货位，请检查货位情况";
                        LogHelper.Info($"EquipmentInfo:{result.Msg}");
                        return result;
                    }

                    #endregion

                    #region 创建任务
                    if (startloc != null && endloc != null)
                    {
                        var wcsTask = new WCSTask
                        #region 获取起点信息，并判断空托是否叠满
                        //根据起点 获取绑定托盘数量
                        //var CntrLoc = db.Queryable<LocCntrRel>().Where(a => a.S_LOC_CODE == model.Loc).ToList();
                        //if (CntrLoc.Count < 4)
                        //{
                        //    result.Code = -1;
                        //    result.Msg = $"根据货位:{model.Loc}获取托盘数量小于4";
                        //    LogHelper.Info($"EquipmentInfo:{result.Msg}");
                        //    return result;
                        //}
                        //else
                        //{
                        //    //拼接托盘号
                        //    cntrcode = CntrLoc.Select(a => a.S_CNTR_CODE).ToString();
                        //}
                        cntrcode = model.CntrNo;
                        //if (ContainerHelper.CheckEmpty(cntrcode))
                        //{
                        //    result.Code = -1;
                        //    result.Msg = $"托盘:{cntrcode}已经绑定货位，叠盘机";
                        //    LogHelper.Info($"EquipmentInfo:{result.Msg}");
                        //    return result;
                        //}  
                        var containern = db.Queryable<Container>().Where(a => a.S_CODE.Trim() == cntrcode).First();
                        if (containern == null)
                        { ContainerHelper.AddCntr(cntrcode, "2"); }
                        else
                        {
                            S_CODE = WCSHelper.GenerateTaskNo(),
                            S_TYPE = "叠盘机入库",
                            S_START_LOC = startloc.S_CODE,
                            S_END_LOC = endloc.S_CODE,
                            S_START_WH = startloc.S_WH_CODE,
                            S_START_AREA = startloc.S_AREA_CODE,
                            S_END_WH = endloc.S_WH_CODE,
                            S_END_AREA = endloc.S_AREA_CODE,
                            N_CNTR_COUNT = 1,
                            N_SCHEDULE_TYPE = 2,
                            S_CNTR_CODE = cntrcode
                        };
                        LogHelper.Info("创建入平库任务：" + JsonConvert.SerializeObject(wcsTask));
                        if (WCSHelper.CreateTask(wcsTask))
                        {
                            LocationHelper.LockLoc(startloc.S_CODE, 2);
                            LocationHelper.LockLoc(endloc.S_CODE, 1);
                            LogHelper.Info("创建任务成功");
                            containern.S_SOURCE = "2";
                            db.Updateable<Container>(containern).UpdateColumns(a => new { a.S_SOURCE }).ExecuteCommand();
                           
                        }

                        startloc = LocationHelper.GetLoc(model.Loc);
                        if (startloc == null)
                        {
                            result.Code = -1;
                            result.Msg = $"根据起点:{model.Loc}未找到货位信息";
                            LogHelper.Info($"EquipmentInfo:{result.Msg}");
                            return result;
                        }
                        #endregion

                        #region 计算立库终点

                        endloc = LocationHelper.InStorage("");
                        if (endloc == null)
                        {
                            result.Code = -1;
                            result.Msg = $"未计算到立库终点货位，请检查货位情况";
                            LogHelper.Info($"EquipmentInfo:{result.Msg}");
                            return result;
                        }

                        #endregion

                        #region 创建作业
                        if (startloc != null && endloc != null)
                        {
                            var wcsTask = new WMSTask
                            {
                                S_CODE = WMSHelper.GenerateTaskNo(),
                                S_TYPE = "叠盘机入库",
                                N_TYPE = 3,
                                S_START_LOC = startloc.S_CODE,
                                S_END_LOC = endloc.S_CODE,
                                S_START_WH = startloc.S_WH_CODE,
                                S_START_AREA = startloc.S_AREA_CODE,
                                S_END_WH = endloc.S_WH_CODE,
                                S_END_AREA = endloc.S_AREA_CODE,

                                S_CNTR_CODE = cntrcode
                            };
                            LogHelper.Info("创建入平库作业：" + JsonConvert.SerializeObject(wcsTask));
                            if (WMSHelper.CreateTask(wcsTask))
                            {
                                LocationHelper.LockLoc(startloc.S_CODE, 2);
                                LocationHelper.LockLoc(endloc.S_CODE, 1);
                                LogHelper.Info("创建作业成功");
                            }
                        }
                        #endregion
                    }
                    #endregion
                    else
                    {
                        result.Code = -1;
                        result.Msg = $"当前叠盘机状态不属于叠盘状态，不允许空托入库";
                        LogHelper.Info($"EquipmentInfo:{result.Msg}");
                        return result;
                    }
                }
                else if (model.SignalType == 2)
                { //判断设备状态是否属于叠盘状态
                    var DeviceStatu = db.Queryable<EquipmentStatus>().Where(a => a.DEVICENO == model.DeviceNo).First();
                    if (DeviceStatu != null && DeviceStatu.STATUS == "2")
                    {
                        #region 获取叠盘机托盘数量

                        endloc = LocationHelper.GetLoc(DiePanLoc);
                        if (endloc == null)
                        {
                            result.Code = -1;
                            result.Msg = $"根据叠盘货位:{DiePanLoc}未找到货位信息";
                            LogHelper.Info($"EquipmentInfo:{result.Msg}");
                            return result;
                        }
                        #endregion

                        #region 计算数量
                        if (endloc.N_CURRENT_NUM > 0 && endloc.N_CURRENT_NUM < 4)
                        {
                            startloc = LocationHelper.GetLocByItemCodeOrderyTime("YCLLKQ", null);

                        }
                        else
                        {
                            startloc = LocationHelper.GetLocByItemCodeOrderyTime("YCLLKQ", null, "2");
                            if (startloc == null)
                            {
                                startloc = LocationHelper.GetLocByItemCodeOrderyTime("YCLLKQ", null);
                            }
                        }
                        if (startloc == null)
                        {
                            result.Code = -1;
                            result.Msg = $"未找到库存空托";
                            LogHelper.Info($"EquipmentInfo:{result.Msg}");
                            return result;
                        }
                        else
                        {
                            var Cntr = db.Queryable<LocCntrRel>().Where(a => a.S_LOC_CODE.Trim() == startloc.S_CODE).ToList();
                            if (Cntr == null)
                            {
                                result.Code = -1;
                                result.Msg = $"起点{startloc.S_CODE}，未找到托盘货位绑定关系，请检查货位数量";
                                LogHelper.Info($"EquipmentInfo:{result.Msg}");
                                return result;
                            }
                            cntrcode = string.Join(",", Cntr.Select(a => a.S_CNTR_CODE));
                        }

                        #endregion

                        #region 创建作业
                        if (startloc != null && endloc != null)
                        {
                            var wcsTask = new WMSTask
                            {
                                S_CODE = WMSHelper.GenerateTaskNo(),
                                S_TYPE = "叠盘机呼叫空托",
                                N_TYPE = 3,
                                S_START_LOC = startloc.S_CODE,
                                S_END_LOC = endloc.S_CODE,
                                S_START_WH = startloc.S_WH_CODE,
                                S_START_AREA = startloc.S_AREA_CODE,
                                S_END_WH = endloc.S_WH_CODE,
                                S_END_AREA = endloc.S_AREA_CODE,

                                S_CNTR_CODE = cntrcode
                            };
                            LogHelper.Info("创建入平库作业：" + JsonConvert.SerializeObject(wcsTask));
                            if (WMSHelper.CreateTask(wcsTask))
                            {
                                LocationHelper.LockLoc(startloc.S_CODE, 2);
                                LocationHelper.LockLoc(endloc.S_CODE, 1);
                                LogHelper.Info("创建作业成功");
                            }
                        }
                        #endregion
                    }
                    else
                    {
                        result.Code = -1;
                        result.Msg = $"当前叠盘机状态不属于拆托状态，不允许呼叫空托";
                        LogHelper.Info($"EquipmentInfo:{result.Msg}");
                        return result;
                    }
                }
                else
                {
                   
                    result.Code = -1;
                    result.Msg = $"下发类型错误";
                    LogHelper.Info($"EquipmentInfo:{result.Msg}");
                    return result;
                }

            }
            else //入库空
            {
@@ -431,20 +589,20 @@
                {
                    #region 获取起点信息
                    //根据托盘获取起点信息
                
                    var CntrLoc = db.Queryable<LocCntrRel>().Where(a => a.S_LOC_CODE == model.Loc).First();
                    if (CntrLoc == null)
                    {
                        result.Code = -1;
                        result.Msg = $"根据起点:{model.Loc}未找到绑定托盘";
                        LogHelper.Info($"EquipmentInfo:{result.Msg}");
                        return result;
                    }
                    startloc = LocationHelper.GetLoc(CntrLoc.S_LOC_CODE);

                    //var CntrLoc = db.Queryable<LocCntrRel>().Where(a => a.S_LOC_CODE == model.Loc).First();
                    //if (CntrLoc == null)
                    //{
                    //    result.Code = -1;
                    //    result.Msg = $"根据起点:{model.Loc}未找到绑定托盘";
                    //    LogHelper.Info($"EquipmentInfo:{result.Msg}");
                    //    return result;
                    //}
                    startloc = LocationHelper.GetLoc(model.Loc);
                    if (startloc == null)
                    {
                        result.Code = -1;
                        result.Msg = $"根据起点:{CntrLoc.S_LOC_CODE}未找到货位信息";
                        result.Msg = $"根据起点:{model.Loc}未找到货位信息";
                        LogHelper.Info($"EquipmentInfo:{result.Msg}");
                        return result;
                    }
@@ -453,7 +611,7 @@

                    #region 计算立库终点
                    //获取托盘物料绑定关系
                    var cntrItem = db.Queryable<CntrItemDetail>().Where(a => a.S_CNTR_CODE == CntrLoc.S_CNTR_CODE).First();
                    var cntrItem = db.Queryable<CntrItemDetail>().Where(a => a.S_CNTR_CODE == model.CntrNo).First();
                    if (cntrItem == null)
                    {
                        result.Code = -1;
@@ -471,29 +629,30 @@
                    }
                    #endregion

                    #region 创建任务
                    #region 创建作业
                    if (startloc != null && endloc != null)
                    {
                        var wcsTask = new WCSTask
                        var wmsTask = new WMSTask
                        {
                            S_CODE = WCSHelper.GenerateTaskNo(),
                            S_CODE = WMSHelper.GenerateTaskNo(),
                            S_TYPE = "物料入库",
                            N_TYPE = 3,
                            S_START_LOC = startloc.S_CODE,
                            S_END_LOC = endloc.S_CODE,
                            S_START_WH = startloc.S_WH_CODE,
                            S_START_AREA = startloc.S_AREA_CODE,
                            S_END_WH = endloc.S_WH_CODE,
                            S_END_AREA = endloc.S_AREA_CODE,
                            N_CNTR_COUNT = 1,
                            N_SCHEDULE_TYPE = 2,
                            S_CNTR_CODE = CntrLoc.S_CNTR_CODE
                            S_CNTR_CODE = model.CntrNo
                        };
                        LogHelper.Info("创建入平库任务：" + JsonConvert.SerializeObject(wcsTask));
                        if (WCSHelper.CreateTask(wcsTask))
                        LogHelper.Info("创建入平库作业：" + JsonConvert.SerializeObject(wmsTask));
                        if (WMSHelper.CreateTask(wmsTask))
                        {
                            cntrItem.F_WEIGHT = float.Parse(model.Weight);
                            var aaaaa = db.Updateable(cntrItem).UpdateColumns(a => new { a.F_WEIGHT }).ExecuteCommand();
                            LocationHelper.LockLoc(startloc.S_CODE, 2);
                            LocationHelper.LockLoc(endloc.S_CODE, 1);
                            LogHelper.Info("创建任务成功");
                            LogHelper.Info("创建作业成功");
                        }
                    }
                    #endregion
@@ -502,28 +661,36 @@
                else
                {
                    //判断设备状态是否属于叠盘状态
                    var DeviceStatu = db.Queryable<EquipmentStatus>().Where(a => a.deviceNo == model.DeviceNo).First();
                    if (DeviceStatu != null && DeviceStatu.Status == "1")
                    var DeviceStatu = db.Queryable<EquipmentStatus>().Where(a => a.DEVICENO == "1").First();
                    if (DeviceStatu != null && DeviceStatu.STATUS == "1")
                    {
                        #region 获取起点信息
                        //根据托盘获取起点信息
                        var CntrLoc = db.Queryable<LocCntrRel>().Where(a => a.S_CNTR_CODE == cntrcode).First();
                        if (CntrLoc == null)
                        {
                            result.Code = -1;
                            result.Msg = $"根据托盘:{cntrcode}未找到绑定托盘";
                            LogHelper.Info($"EquipmentInfo:{result.Msg}");
                            return result;
                        }
                        startloc = LocationHelper.GetLoc(CntrLoc.S_LOC_CODE);
                        //var CntrLoc = db.Queryable<LocCntrRel>().Where(a => a.S_CNTR_CODE == cntrcode).First();
                        //if (CntrLoc == null)
                        //{
                        //    result.Code = -1;
                        //    result.Msg = $"根据托盘:{cntrcode}未找到绑定托盘";
                        //    LogHelper.Info($"EquipmentInfo:{result.Msg}");
                        //    return result;
                        //}
                        ContainerHelper.AddCntr(cntrcode, "1");
                        startloc = LocationHelper.GetLoc(model.Loc);
                        if (startloc == null)
                        {
                            result.Code = -1;
                            result.Msg = $"根据起点:{CntrLoc.S_LOC_CODE}未找到货位信息";
                            result.Msg = $"根据起点:{model.Loc}未找到货位信息";
                            LogHelper.Info($"EquipmentInfo:{result.Msg}");
                            return result;
                        }

                        var cntrItem = db.Queryable<CntrItemDetail>().Where(a => a.S_CNTR_CODE == model.CntrNo).First();
                        if (cntrItem != null)
                        {
                            result.Code = -1;
                            result.Msg = $"根据托盘:{model.CntrNo}找到物料信息,不允许叠盘入库";
                            LogHelper.Info($"EquipmentInfo:{result.Msg}");
                            return result;
                        }
                        #endregion

                        #region 获取终点信息
@@ -539,29 +706,28 @@
                        }
                        #endregion

                        #region 创建任务
                        #region 创建作业
                        if (startloc != null && endloc != null)
                        {
                            var wcsTask = new WCSTask
                            var wmsTask = new WMSTask
                            {
                                S_CODE = WCSHelper.GenerateTaskNo(),
                                S_TYPE = "入库",
                                S_CODE = WMSHelper.GenerateTaskNo(),
                                S_TYPE = "叠盘机空托入库",
                                N_TYPE = 3,
                                S_START_LOC = startloc.S_CODE,
                                S_END_LOC = endloc.S_CODE,
                                S_START_WH = startloc.S_WH_CODE,
                                S_START_AREA = startloc.S_AREA_CODE,
                                S_END_WH = endloc.S_WH_CODE,
                                S_END_AREA = endloc.S_AREA_CODE,
                                N_CNTR_COUNT = 1,
                                N_SCHEDULE_TYPE = 2,
                                S_CNTR_CODE = cntrcode
                            };
                            LogHelper.Info("创建入平库任务：" + JsonConvert.SerializeObject(wcsTask));
                            if (WCSHelper.CreateTask(wcsTask))
                            LogHelper.Info("创建入平库作业：" + JsonConvert.SerializeObject(wmsTask));
                            if (WMSHelper.CreateTask(wmsTask))
                            {
                                LocationHelper.LockLoc(startloc.S_CODE, 2);
                                LocationHelper.LockLoc(endloc.S_CODE, 1);
                                LogHelper.Info("创建任务成功");
                                LogHelper.Info("创建任务作业");
                            }
                        }