111

schangxiang@126.com

2024-12-13 75ca84b7570d7a6a805c27164c3f17c1f2158423

 CC/iWareCC_ASRS/FormCC.cs

@@ -1477,6 +1477,49 @@
                    item.UpiStatus = (int)UpiStatusEnum.初始;
                }

                //清空队列数据
                var list = db.mes_upi_linequeue.ToList();
                db.mes_upi_linequeue.RemoveRange(list);

                db.SaveChanges();
            }
            if (!string.IsNullOrEmpty(alertMsg))
            {
                MessageBox.Show("错误:" + alertMsg);
            }
            else
            {
                MessageBox.Show("已处理");
            }
        }

        private void button1_Click(object sender, EventArgs e)
        {


            var alertMsg = "";
            using (WmsDBModel db = new WmsDBModel())
            {
                //查询立体库中的upi列表
                var quanList = db.wms_stock_quan.ToList().Select(x => x.Upi).ToList();
                var upiList = db.mes_batchOrderUPI_new.Where(x => !quanList.Contains(x.UPI)).ToList();
                foreach (var item in upiList)
                {
                    item.AreaCode = (int)AreaCodeEnum.无区域;
                    item.UpiStatus = (int)UpiStatusEnum.初始;
                }

                var packageCodeList = upiList.Select(x => x.PackageCode).ToList();
                var pList = db.mes_package_gather.Where(x => packageCodeList.Contains(x.PackageCode)).ToList();
                foreach (var item in pList)
                {
                    item.AreaCode = (int)AreaCodeEnum.无区域;
                    item.UpiStatus = (int)UpiStatusEnum.初始;
                }
                //清空队列数据
                var list = db.mes_upi_linequeue.ToList();
                db.mes_upi_linequeue.RemoveRange(list);

                db.SaveChanges();
            }
            if (!string.IsNullOrEmpty(alertMsg))