From fcca000072a8cfae98c1cb3dadce0512b19083cc Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 28 六月 2022 20:09:13 +0800
Subject: [PATCH] ERP订单查询，订单下达、订单关闭功能开发
---
VueWebApi/DLL/DAL/MaterialManagerDAL.cs | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/VueWebApi/DLL/DAL/MaterialManagerDAL.cs b/VueWebApi/DLL/DAL/MaterialManagerDAL.cs
index 4f11bcc..61c8a7c 100644
--- a/VueWebApi/DLL/DAL/MaterialManagerDAL.cs
+++ b/VueWebApi/DLL/DAL/MaterialManagerDAL.cs
@@ -258,7 +258,7 @@
}
// --------------鏌ヨ鎸囧畾鏁版嵁--------------
var total = 0; //鎬绘潯鏁�
- var sql = @"select A.code,A.name,A.description,A.stock_code,B.name as stock_name,A.lm_user,A.lm_date
+ var sql = @"select A.id,A.code,A.name,A.description,A.stock_code,B.name as stock_name,A.lm_user,A.lm_date
from T_Sec_Loca A
left join T_Sec_Stck B on A.stock_code=B.code
where A.is_delete<>'1' " + search;
@@ -288,7 +288,7 @@
if (operType == "Add")
{
var sql = @"insert into T_Sec_Loca(code,name,description,stock_code,lm_user,lm_date)
- values(@storagecode,@storagename,@description,@username,@CreateDate)";
+ values(@storagecode,@storagename,@description,@stockcode,@username,@CreateDate)";
dynamicParams.Add("@storagecode", storagecode);
dynamicParams.Add("@storagename", storagename);
dynamicParams.Add("@description", description);
--
Gitblit v1.9.3