优化Api数据库缓存模块，增加MES岗位缓存跟不良代码缓存

Rodney Chen

2024-12-06 9719a7f0ccbb70e4e51a93cbe1733d1424c16f6d

 Tiger.Business.WMS/Transaction/OutSale.cs

@@ -63,6 +63,8 @@
                    action.LocaleMsg = new("WMS.ProdMReq.SelectOrder.DtlsException", input.ReqNo);
                    return action;
                }

                Biz.Db.Deleteable<WMS_ITEM_POOL>().Where(q => q.TRANS_CODE == req.BILLCODE).ExecuteCommand();
                //如果上一次推荐有数据，则先灭掉亮的灯
                if (Suggests.Any())
                {
@@ -121,17 +123,7 @@
                Suggests.RemoveAll(q => q.poolItem.IsNullOrEmpty());

                //保存物料池到数据库
                var db = Biz.Db;
                var dbTran = db.UseTran(() =>
                {
                    db.Insertable(CurPoolList).ExecuteCommand();
                });
                if (!dbTran.IsSuccess)
                {
                    Logger.Default.Fatal(dbTran.ErrorException, "Database transaction save exception");
                    this.Close(!dbTran.IsSuccess);
                    throw dbTran.ErrorException;
                }
                Biz.Db.Insertable(CurPoolList).ExecuteCommand();
                action = await LightAll(new() { AuthOption = input.AuthOption, Color = LedColor.Blue });
            }
            catch (Exception ex)
@@ -335,7 +327,7 @@
                //}
                var MaxDC = CurPoolList.Any(x => x.ITEM_CODE == CurInv.ItemInfo.ITEM_CODE) ? CurPoolList.Where(x => x.ITEM_CODE == CurInv.ItemInfo.ITEM_CODE).Max(t => t.PROD_DATE) : DateTime.MinValue;
                //判断系统参数是否设置先进先出
                if (Biz.SysParam["YesOrNo"].PARAM_VALUE == "Y")
                if (Cache.SysParam["YesOrNo"].PARAM_VALUE == "Y")
                {
                    if (CurInv.Items.Max(x => x.PROD_DATE).Date > MaxDC.Date)
                    {