Tiger.Api/Controllers/Test/TestController.R.cs

@@ -154,7 +154,7 @@
            //var data = 0;
            //try
            //{
            //     data = Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("pkg_ImportItemFromSRM", new SugarParameter("dlvyNo", "BAD202308240443"));
            //     data = Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("sp_ImportItemFromSRM", new SugarParameter("dlvyNo", "BAD202308240443"));
            //}
            //catch (System.Exception ex)
            //{

 Tiger.Business.WMS/Transaction/WmsCount.cs

@@ -546,7 +546,7 @@
        public override bool Close(bool needSaveHistoryLog = false)
        {
            //检查盘点单是否关闭
            Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("pkg_count_status", new SugarParameter("CountNo", count.COUNT_NO));
            Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("sp_count_status", new SugarParameter("CountNo", count.COUNT_NO));
            //needSaveHistoryLog = true;
            CloseLight(new CountLightEntity() { ShelfCode = "" }).Wait();
            //保存操作日志

 Tiger.Business.WMS/WMS_ITEM_Biz.cs

@@ -185,8 +185,8 @@
                            inv.Region = query.Region;
                            inv.Shelf = query.Shelf;
                            inv.Location = query.Location;
                            inv.Packages = Biz.Db.Ado.UseStoredProcedure().SqlQuery<WMS_ITEM_PKG>("pkg_wms_get_item_pkg", new SugarParameter("root", barcode.SN));
                            inv.Items = Biz.Db.Ado.UseStoredProcedure().SqlQuery<WMS_ITEM>("pkg_wms_get_items", new SugarParameter("root", barcode.SN));
                            inv.Packages = Biz.Db.Ado.UseStoredProcedure().SqlQuery<WMS_ITEM_PKG>("sp_wms_get_item_pkg", new SugarParameter("root", barcode.SN));
                            inv.Items = Biz.Db.Ado.UseStoredProcedure().SqlQuery<WMS_ITEM>("sp_wms_get_items", new SugarParameter("root", barcode.SN));
                            inv.ItemsExt = Biz.Db.Queryable<WMS_ITEM_EXT>().Where(q => inv.Items.Any(s => s.SN == q.SN)).ToList();//扩展表
                            //var data = inv.Items.Select(i => i.SN).ToList().Except(inv.ItemsExt.Select(i => i.SN).ToList());
                            var data = inv.Items.Where(q => !inv.ItemsExt.Any(s => s.SN == q.SN)).ToList();

 Tiger.Business.WMS/iSRM/SrmToWms.cs

@@ -538,7 +538,7 @@
                        try
                        {
                            var bTime = DateTime.Now;
                            Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("pkg_ImportItemFromSRM", new SugarParameter("dlvyNo", dlvy.documnetNumber));
                            Biz.Db.Ado.UseStoredProcedure().ExecuteCommand("sp_ImportItemFromSRM", new SugarParameter("dlvyNo", dlvy.documnetNumber));
                            Logger.Scheduler.Info($"New QqtSRM 保存送货单[{dlvy.documnetNumber}]条码导入WMS_ITEM完成，耗时:[{(DateTime.Now - bTime).TotalMilliseconds}]毫秒");
                        }
                        catch (System.Exception ex)
@@ -921,7 +921,7 @@
                            try
                            {
                                var bTime = DateTime.Now;
                                adoDb.Ado.UseStoredProcedure().ExecuteCommand("pkg_ImportItemFromSRM", new SugarParameter("dlvyNo", dlvy.documnetNumber));
                                adoDb.Ado.UseStoredProcedure().ExecuteCommand("sp_ImportItemFromSRM", new SugarParameter("dlvyNo", dlvy.documnetNumber));
                                Logger.Scheduler.Info($"New QqtSRM 保存送货单[{dlvy.documnetNumber}]条码导入WMS_ITEM完成，耗时:[{(DateTime.Now - bTime).TotalMilliseconds}]毫秒");
                            }
                            catch (System.Exception ex)