From ed903443d28d390401904427bd1c1befaade33bb Mon Sep 17 00:00:00 2001 From: Rodney Chen <rodney.chen@hotmail.com> Date: 星期二, 18 三月 2025 10:16:46 +0800 Subject: [PATCH] 优化清点逻辑again --- Tiger.Business.WMS/Transaction/In_SemiProd.cs | 6 +++--- 1 files changed, 3 insertions(+), 3 deletions(-) diff --git a/Tiger.Business.WMS/Transaction/In_SemiProd.cs b/Tiger.Business.WMS/Transaction/In_SemiProd.cs index 23bb691..2d98e3c 100644 --- a/Tiger.Business.WMS/Transaction/In_SemiProd.cs +++ b/Tiger.Business.WMS/Transaction/In_SemiProd.cs @@ -472,10 +472,10 @@ ErpProdInSns = new(); inStoreInfos = new() { }; - //涓存椂浠g爜 + //涓存椂浠g爜锛屾祴璇曠敤 //DbClient _db = Biz.DataSource["YadaU9C"].Client; - //var items = Biz.Db.Queryable<WMS_ITEM>().Where(q=> SqlFunc.IsNullOrEmpty(q.SUPP_LOTNO)).ToList(); - //var snlist = items.Select(q=>q.SN).ToList(); + //var items = Biz.Db.Queryable<WMS_ITEM>().Where(q => SqlFunc.IsNullOrEmpty(q.SUPP_LOTNO)).ToList(); + //var snlist = items.Select(q => q.SN).ToList(); ////var list = _db.Ado.SqlQuery<mes_MaterialBarCodeByBin>($"select *,cast('{DateTime.Now.ToString("yyyy-MM-dd")}' as DATETIME) as PROD_DATE,'' as Unit,'' as LotNo from mes_MaterialBarCodeByBin where Code in ({string.Join(',', snlist.Select(x=> $"'{x}'"))})"); //var list = _db.Queryable<mes_MaterialBarCode>().Where(q => snlist.Contains(q.Code)).ToList(); //foreach (var item in list) -- Gitblit v1.9.3