~tjx/NewPdaSqlServer.git

屠家鑫 / NewPdaSqlServer

sql server版本的

概况
操作记录
提交次数
目录
文档
分支
对比

blame | 历史 | 补丁 | 提交 | 提交对比 | 忽略空白

1.其他入库优化 2.推荐库位函数优化

南骏池

2025-06-05 0010dd10c41c5c990bf6cc1b40ad857a6c956cbe

 service/Wom/WomdaaManager.cs

@@ -204,7 +204,7 @@
        //    .ToList();

        var sql =string.Format(@"SELECT c.item_no ItemNo,c.item_name ItemName,c.item_model ItemModel,b.dab006 FQty,b.dab007 SQty,b.dab006 - b.dab007 DSQty ,
       dbo.F_QX_GETRECODEPOTSE(B.dab003) as RecoKw
       dbo.F_QX_GETRECODEPOTSE(B.dab003,'','','') as RecoKw
    FROM WOMDAB B
    LEFT JOIN WOMDAA A ON A.guid = B.daaGuid
    LEFT JOIN MES_ITEMS C ON  B.dab003 = C.item_id

			@@ -204,7 +204,7 @@
			// .ToList();

			var sql =string.Format(@"SELECT c.item_no ItemNo,c.item_name ItemName,c.item_model ItemModel,b.dab006 FQty,b.dab007 SQty,b.dab006 - b.dab007 DSQty ,
			dbo.F_QX_GETRECODEPOTSE(B.dab003) as RecoKw
			dbo.F_QX_GETRECODEPOTSE(B.dab003,'','','') as RecoKw
			FROM WOMDAB B
			LEFT JOIN WOMDAA A ON A.guid = B.daaGuid
			LEFT JOIN MES_ITEMS C ON B.dab003 = C.item_id