优化 ImportWoPlan.cs 代码逻辑，减少冗余并增加状态处理

Ben Lin

2025-01-02 2e2033964d99196d94b0abd9f3364b9b2387b324

优化 ImportWoPlan.cs 代码逻辑，减少冗余并增加状态处理

对 ImportWoPlan.cs 文件进行了多处修改，主要包括：
1. 增加对 item.VALIDATION_TYPE 是否为 "新增" 的判断，并根据 ORDER_NO 或已有批次信息生成 BATCH_NO。
2. 使用 IgnoreColumns(x => x.ID) 忽略 ID 列的更新操作。
3. 合并重复的批次号生成逻辑，减少代码冗余。
4. 修改查询 BIZ_MES_WO_BATCH 的条件，增加对 STATUS 范围的判断。
5. 增加对 STATUS 为初始化状态的批次的处理逻辑，允许更新并设置 item.VALIDATION_TYPE 为 "更新"。

这些修改旨在优化代码逻辑，减少冗余代码，并增加对不同状态的处理逻辑。

 Tiger.Business.MES/BIZ/ImportWoPlan.cs

@@ -46,6 +46,8 @@
                    foreach (var item in list)
                    {
                        item.ID = Guid.NewGuid().ToString("N");
                        if (item.VALIDATION_TYPE == "新增")
                        {
                        var _batchWos = await Biz.Db.Queryable<V_MES_WO_BATCH>().Where(x => x.ORDER_NO == item.ORDER_NO).ToListAsync();
                        if (_batchWos.Count > 0)
                        {
@@ -54,6 +56,7 @@
                        else
                        {
                            item.BATCH_NO = $"{item.ORDER_NO}-01";
                            }
                        }
                        BIZ_MES_WO wo = Biz.Db.Queryable<BIZ_MES_WO>().Where(x => x.ORDER_NO == item.ORDER_NO).First();
                        if (wo != null)
@@ -72,17 +75,19 @@
                            db.Utilities.PageEach(list, 100, pageList =>
                            {
                                var y = db.Storageable(pageList)
                                       .WhereColumns(t => new { t.ORDER_NO, t.PLAN_DATE, t.GHOST_ROW })
                                       .ToStorage();
                                y.AsInsertable.ExecuteCommand();
                                y.AsUpdateable.ExecuteCommand();
                                y.AsUpdateable.IgnoreColumns(x => x.ID).ExecuteCommand();
                            });
                        }
                        else
                        {
                            var s = db.Storageable(list)
                                   .WhereColumns(t => new { t.ORDER_NO, t.PLAN_DATE, t.GHOST_ROW })
                                   .ToStorage();
                            s.AsInsertable.ExecuteCommand();
                            s.AsUpdateable.ExecuteCommand();
                            s.AsUpdateable.IgnoreColumns(x => x.ID).ExecuteCommand();
                        }
                        db.Updateable(woList).UpdateColumns(x => new { x.PLAN_DATE }).ExecuteCommand();
                    });
@@ -134,16 +139,6 @@
                    }
                    else
                    {
                        var _batchWos = await Biz.Db.Queryable<V_MES_WO_BATCH>().Where(x => x.ORDER_NO == item.ORDER_NO).ToListAsync();
                        if (_batchWos.Count > 0)
                        {
                            item.BATCH_NO = $"{item.ORDER_NO}-{(_batchWos.Max(x => x.BATCH) + 1).ToString("D2")}";
                        }
                        else
                        {
                            item.BATCH_NO = $"{item.ORDER_NO}-01";
                        }

                        if (item.PLAN_DATE.IsNullOrEmpty())
                        {
                            item.VALIDATION_TYPE = "异常";
@@ -155,11 +150,18 @@
                            item.VALIDATION_TYPE = "异常";
                            item.VALIDATION_RESULT += $"计划数量为空; ";
                        }
                        var _woBatch = await Biz.Db.Queryable<BIZ_MES_WO_BATCH>().Where(x => x.ORDER_NO == item.ORDER_NO && SqlFunc.DateIsSame(x.PLAN_DATE, item.PLAN_DATE) && x.STATUS != BIZ_MES_WO_BATCH.STATUSs.Closed.GetValue()).FirstAsync();
                        var _woBatch = await Biz.Db.Queryable<BIZ_MES_WO_BATCH>().Where(x => x.ORDER_NO == item.ORDER_NO && SqlFunc.DateIsSame(x.PLAN_DATE, item.PLAN_DATE) && BIZ_MES_WO_BATCH.STATUSs.Init.GetValue() < x.STATUS && x.STATUS < BIZ_MES_WO_BATCH.STATUSs.Closed.GetValue()).FirstAsync();
                        if (!_woBatch.IsNullOrEmpty())
                        {
                            item.VALIDATION_TYPE = "异常";
                            item.VALIDATION_RESULT += $"数据已经存在，不能更新。存在的计划数量为[{_woBatch.PLAN_QTY}]";
                            item.VALIDATION_RESULT += $"数据已经存在且状态不是初始化，不能更新。存在的计划数量为[{_woBatch.PLAN_QTY}]";
                        }
                        var _woBatch2 = Biz.Db.Queryable<BIZ_MES_WO_BATCH>().Where(x => x.ORDER_NO == item.ORDER_NO && SqlFunc.DateIsSame(x.PLAN_DATE, item.PLAN_DATE) && x.STATUS == BIZ_MES_WO_BATCH.STATUSs.Init.GetValue()).First();
                        if (!_woBatch2.IsNullOrEmpty())
                        {
                            item.VALIDATION_TYPE = "更新";
                            item.VALIDATION_RESULT = $"数据可以更新";
                            item.BATCH_NO = _woBatch2.BATCH_NO;
                        }
                    }
                }