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 +++++++++---
1 files changed, 9 insertions(+), 3 deletions(-)
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,
--
Gitblit v1.9.3