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/ProductModelDAL.cs | 12 +++++++++---
VueWebCoreApi/DLL/DAL/BasicSettingDAL.cs | 16 ++++++++++++----
VueWebCoreApi/appsettings.json | 2 +-
3 files changed, 22 insertions(+), 8 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,
diff --git a/VueWebCoreApi/DLL/DAL/ProductModelDAL.cs b/VueWebCoreApi/DLL/DAL/ProductModelDAL.cs
index ac2ed95..fc450cc 100644
--- a/VueWebCoreApi/DLL/DAL/ProductModelDAL.cs
+++ b/VueWebCoreApi/DLL/DAL/ProductModelDAL.cs
@@ -841,17 +841,23 @@
// mes.data = null;
// return mes;
//}
+
+ //鑾峰彇涓昏〃鏈�澶D
+ sql = @"select ISNULL(IDENT_CURRENT('TMateriel_Info')+1,1) as id";
+ var dt = DapperHelper.selecttable(sql);
+
//鍐欏叆瀛樿揣鍒嗙被
- sql = @"insert into TMateriel_Info(partcode,partname,partspec,idunit,idunitgroup,isSingleUnit,idSubUnitByReport,idUnitByStock,idUnitByPurchase,idUnitBySale,idunitbymanufacture,
+ sql = @"insert into TMateriel_Info(noid,partcode,partname,partspec,idunit,idunitgroup,isSingleUnit,idSubUnitByReport,idUnitByStock,idUnitByPurchase,idUnitBySale,idunitbymanufacture,
idinventoryclass,isPurchase,isSale,isMadeSelf,isMaterial,isMadeRequest,idwarehouse,status,lm_user,lm_date,data_sources)
- values(@partcode,@partname,@partspec,@idunit,@idunitgroup,@isSingleUnit,@idSubUnitByReport,@idUnitByStock,@idUnitByPurchase,@idUnitBySale,@idunitbymanufacture,
+ values(@noid,@partcode,@partname,@partspec,@idunit,@idunitgroup,@isSingleUnit,@idSubUnitByReport,@idUnitByStock,@idUnitByPurchase,@idUnitBySale,@idunitbymanufacture,
@idinventoryclass,@isPurchase,@isSale,@isMadeSelf,@isMaterial,@isMadeRequest,@idwarehouse,@status,@lm_user,@lm_date,@data_sources)";
list.Add(new
{
str = sql,
parm = new
{
- partcode=partcode,
+ noid = int.Parse(dt.Rows[0]["ID"].ToString()),
+ partcode =partcode,
partname=partname,
partspec=partspec,
idunit=unittypcode=="1"?unitcode:unitsubcode,
diff --git a/VueWebCoreApi/appsettings.json b/VueWebCoreApi/appsettings.json
index 2fc5071..3e84b3f 100644
--- a/VueWebCoreApi/appsettings.json
+++ b/VueWebCoreApi/appsettings.json
@@ -27,7 +27,7 @@
//session澶辨晥鏃堕棿
"InProc": "240",
//Excel瀵煎嚭妯℃澘閰嶇疆IP
- "FileIP": "http://121.196.36.24:8019/",
+ "FileIP": "http://121.196.36.24:8036/",
//jwtkey
"SigningKey": "Hello World"
}
--
Gitblit v1.9.3