数据清理

schangxiang@126.com

2025-09-02 cf5ef52a94c25e2ce92d0a0b7ebca62d81852873

数据清理

 wcs/yunneiWCS/yunneiWCS/DataAccess/OutInStockRecord_V2_MesHandler.cs

@@ -27,7 +27,7 @@
        /// <param name="productStocks"></param>
        /// <param name="currentTaskType"></param>
        public static void AddRecordForPersonDelete(dbmodel mod, OutInFlag _outInFlag, string remark,
          System.Collections.Generic.List<productStockList> productStocks, productStock modfiyStock)
          System.Collections.Generic.List<productStockList> productStocks, productStock modfiyStock, string positionName)
        {
            try
            {
@@ -43,7 +43,7 @@
                Wms_outInStockRecord_V2_Mes log = new Wms_outInStockRecord_V2_Mes()
                {
                    ID = Yitter.IdGenerator.YitIdHelper.NextId(),
                    sourcePlace = "",
                    sourcePlace = positionName,
                    toPlace = "",
                    containerCode = modfiyStock.containerCode,

@@ -97,7 +97,7 @@
                throw ex;
            }
        }
        private static void AddRecord(dbmodel mod, OutInFlag _outInFlag, string sourcePlace, string toPlace, task _task, string remark,
        private static void AddRecord(dbmodel mod, OutInFlag _outInFlag, string positionName, task _task, string remark,
            System.Collections.Generic.List<productStockList> productStocks, taskType currentTaskType)
        {
            try
@@ -114,8 +114,8 @@
                Wms_outInStockRecord_V2_Mes log = new Wms_outInStockRecord_V2_Mes()
                {
                    ID = Yitter.IdGenerator.YitIdHelper.NextId(),
                    sourcePlace = sourcePlace,
                    toPlace = toPlace,
                    sourcePlace = positionName,
                    toPlace = "",
                    containerCode = _task.containerCode,

                    LastModifier = _task.creator,
@@ -166,14 +166,14 @@
            }
        }

        public static void AddRecord(dbmodel mod, OutInFlag _outInFlag, string sourcePlace, string toPlace, task _task, string remark,
        public static void AddRecord(dbmodel mod, OutInFlag _outInFlag, string positionName, task _task, string remark,
         taskType currentTaskType)
        {
            var stock = mod.productStock.Where(a => a.containerCode == _task.containerCode).FirstOrDefault();
            if (stock != null)
            {
                System.Collections.Generic.List<productStockList> productStocks = mod.productStockList.Where(a => a.stockId == stock.stockId).ToList();
                AddRecord(mod, _outInFlag, sourcePlace, toPlace, _task, remark,
                AddRecord(mod, _outInFlag, positionName, _task, remark,
                productStocks, currentTaskType);
            }
        }

 wcs/yunneiWCS/yunneiWCS/ExtendFunction/MyExtend.cs

@@ -506,7 +506,7 @@
                                throw new Exception("入库任务，目标站点找不到，toPlace：" + finishTask.toPlace);
                            }
                            OutInStockRecordHandler.AddOutInStockRecord(mod, OutInFlag.入库, finishTask.sourcePlace, finishTask.toPlace, finishTask, "入库类型的任务");
                            OutInStockRecord_V2_MesHandler.AddRecord(mod, OutInFlag.入库, finishTask.sourcePlace, finishTask.toPlace, finishTask, "入库类型的任务", currentTaskType);//堆垛机任务完成后的入库
                            OutInStockRecord_V2_MesHandler.AddRecord(mod, OutInFlag.入库, finishTask.toPlace, finishTask, "入库类型的任务", currentTaskType);//堆垛机任务完成后的入库
                            #endregion
                            break;
                        case taskType.缸体下线:
@@ -597,7 +597,7 @@
                                #endregion

                                OutInStockRecordHandler.AddOutInStockRecord(mod, OutInFlag.入库, finishTask.sourcePlace, finishTask.toPlace, finishTask, "入库类型的任务");
                                OutInStockRecord_V2_MesHandler.AddRecord(mod, OutInFlag.入库, finishTask.sourcePlace, finishTask.toPlace, finishTask, "入库类型的任务", currentTaskType);//堆垛机任务完成后的入库
                                OutInStockRecord_V2_MesHandler.AddRecord(mod, OutInFlag.入库, finishTask.toPlace, finishTask, "入库类型的任务", currentTaskType);//堆垛机任务完成后的入库
                            }
                            else
                            {
@@ -681,7 +681,7 @@
                                errMsg = "缸盖上线/缸体上线任务，中转位为空，暂不处理";
                                return false;
                            }
                            OutInStockRecord_V2_MesHandler.AddRecord(mod, OutInFlag.出库, finishTask.sourcePlace, finishTask.toPlace, finishTask, "出库类型的任务", currentTaskType);//堆垛机任务完成后的出库
                            OutInStockRecord_V2_MesHandler.AddRecord(mod, OutInFlag.出库, finishTask.sourcePlace, finishTask, "出库类型的任务", currentTaskType);//堆垛机任务完成后的出库
                            break;
                        default://其他，出库确认
                            //finishTask.taskStatus = 3;
@@ -804,7 +804,7 @@
            //设置目标位有货
            PositionHandler.Free(true, to_positionStation, "处理 缸体上线到旁路工位的处理 的任务", SysGloble.WCSNAME, item);

            OutInStockRecord_V2_MesHandler.AddRecord(mod, OutInFlag.出库, item.sourcePlace, item.toPlace, item, "出库类型的任务", _taskType);//堆垛机任务完成后的出库
            OutInStockRecord_V2_MesHandler.AddRecord(mod, OutInFlag.出库, item.toPlace, item, "出库类型的任务", _taskType);//堆垛机任务完成后的出库
            OutInStockRecordHandler.AddOutInStockRecord(mod, OutInFlag.出库, item.sourcePlace, item.toPlace, item, "出库类型的任务");

            //通知天永,给天永发信号
@@ -1015,7 +1015,8 @@
                        List<productStockList> delteStockDatalist = mod.productStockList.Where(x => x.stockId == delteData.positionId).ToList();
                        if (delteStockDatalist.Count > 0)
                        {
                            OutInStockRecord_V2_MesHandler.AddRecordForPersonDelete(mod, OutInFlag.出库, "删除库存:" + preLog, delteStockDatalist, delteStockData.First());//堆垛机任务完成后的出库
                            OutInStockRecord_V2_MesHandler.AddRecordForPersonDelete(mod, OutInFlag.出库, "删除库存:" + preLog,
                                delteStockDatalist, delteStockData.First(), positionName);//堆垛机任务完成后的出库
                            foreach (var itemList in delteStockDatalist)
                            {
                                mod.productStockList.Remove(itemList);

 wcs/yunneiWCS/yunneiWCS/wcf/yunneiWcf.cs

@@ -2325,7 +2325,8 @@
                            preLog = "人工分拣";
                        }

                        OutInStockRecord_V2_MesHandler.AddRecordForPersonDelete(mod, OutInFlag.出库, "人工删除库存:" + preLog, record_delteList, modfiyStock);//堆垛机任务完成后的出库
                        OutInStockRecord_V2_MesHandler.AddRecordForPersonDelete(mod, OutInFlag.出库, "人工删除库存:" + preLog,
                            record_delteList, modfiyStock, (currentStock != null ? currentStock.positionName : ""));//堆垛机任务完成后的出库

                        int res = mod.SaveChanges();
                        if (res > 0)