From 9977eaff9afe000abdf11abb63d7c6a416169d1b Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期一, 10 三月 2025 13:25:51 +0800 Subject: [PATCH] 生产资源,生产班组,不良原因,故障原因(登记单用到) ,岗位,不良后果,不良类型,岗位技能,处理方案(安灯处理单),工艺参数,故障类别,不良现象,防错装置,保养级别,启动检查项目,环境检测项目,工艺参数分类,工作中心,工序 增加保存前控制存储过程,保存后控制存储过程,审核前控制,审核后控制,禁用前控制,禁用后控制,删除前控制,删除后控制; --- WebAPI/Controllers/BaseSet/Gy_CurrencyController.cs | 6 ++++++ 1 files changed, 6 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/BaseSet/Gy_CurrencyController.cs b/WebAPI/Controllers/BaseSet/Gy_CurrencyController.cs index e54e0e3..4ad4847 100644 --- a/WebAPI/Controllers/BaseSet/Gy_CurrencyController.cs +++ b/WebAPI/Controllers/BaseSet/Gy_CurrencyController.cs @@ -595,6 +595,7 @@ try { var _value = msg["model"].ToString(); + LogService.Write("甯佸埆:" + _value); SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); ListModels oListModels = new ListModels(); List<Model.ClsGy_Currency_Model> lsmain = new List<Model.ClsGy_Currency_Model>(); @@ -607,6 +608,11 @@ sql = "set identity_insert Gy_Currency on"; oCN.RunProc(sql); + LogService.Write("甯佸埆:" + $@"insert into Gy_Currency(HItemID,HNumber,HName,HShortNumber,HParentID + ,HLevel,HEndFlag,HStopflag,HRemark,HHelpCode,HScale,HExchangeRate) + values({lsmain[0].HItemID},'{lsmain[0].HNumber}','{lsmain[0].HName}','{lsmain[0].HShortNumber}',{lsmain[0].HParentID},{lsmain[0].HLevel} + ,{Convert.ToString(lsmain[0].HEndFlag ? 1 : 0)},{Convert.ToString(lsmain[0].HStopflag ? 1 : 0) },'{lsmain[0].HRemark}','{lsmain[0].HHelpCode}','{lsmain[0].HScale}','{lsmain[0].HExchangeRate}')"); + oCN.RunProc($@"insert into Gy_Currency(HItemID,HNumber,HName,HShortNumber,HParentID ,HLevel,HEndFlag,HStopflag,HRemark,HHelpCode,HScale,HExchangeRate) values({lsmain[0].HItemID},'{lsmain[0].HNumber}','{lsmain[0].HName}','{lsmain[0].HShortNumber}',{lsmain[0].HParentID},{lsmain[0].HLevel} -- Gitblit v1.9.1