From 84d11937e57ca3d73fa58e123b14de02ad8e8d4e Mon Sep 17 00:00:00 2001
From: yl <ykxkd@outlook.com>
Date: 星期二, 03 十二月 2024 14:17:00 +0800
Subject: [PATCH] 1.仓库、库位、存货新增加字段noid
---
VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs | 16 ++++++++++++----
1 files changed, 12 insertions(+), 4 deletions(-)
diff --git a/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs b/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs
index 1cdffc9..f39c590 100644
--- a/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs
@@ -2399,14 +2399,18 @@
mes.data = null;
return mes;
}
+ //鑾峰彇涓昏〃鏈�澶D
+ sql = @"select ISNULL(IDENT_CURRENT('TSecStck')+1,1) as id";
+ var dt = DapperHelper.selecttable(sql);
//鍐欏叆浠撳簱
- sql = @"insert into TSecStck(code,name,status,ishasPosition,description,lm_user,lm_date,data_sources)
- values(@code,@name,@status,@ishasPosition,@description,@lm_user,@lm_date,@data_sources)";
+ sql = @"insert into TSecStck(noid,code,name,status,ishasPosition,description,lm_user,lm_date,data_sources)
+ values(@noid,@code,@name,@status,@ishasPosition,@description,@lm_user,@lm_date,@data_sources)";
list.Add(new
{
str = sql,
parm = new
{
+ noid= int.Parse(dt.Rows[0]["ID"].ToString()),
code = stckcode,
name = stckname,
status = status,
@@ -2707,14 +2711,18 @@
{
parentlocacode = "";
}
+ //鑾峰彇涓昏〃鏈�澶D
+ sql = @"select ISNULL(IDENT_CURRENT('TSecLoca')+1,1) as id";
+ var dt = DapperHelper.selecttable(sql);
//鍐欏叆浠撲綅
- sql = @"insert into TSecLoca(code,name,idwarehouse,idparent,status,description,lm_user,lm_date,data_sources,depth)
- values(@code,@name,@idwarehouse,@idparent,@status,@description,@lm_user,@lm_date,@data_sources,@depth)";
+ sql = @"insert into TSecLoca(noid,code,name,idwarehouse,idparent,status,description,lm_user,lm_date,data_sources,depth)
+ values(@noid,@code,@name,@idwarehouse,@idparent,@status,@description,@lm_user,@lm_date,@data_sources,@depth)";
list.Add(new
{
str = sql,
parm = new
{
+ noid = int.Parse(dt.Rows[0]["ID"].ToString()),
code = locacode,
name = locaname,
idwarehouse = stckcode,
--
Gitblit v1.9.3