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/BLL/Xt_UserController.cs | 6 ++++-- 1 files changed, 4 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/BLL/Xt_UserController.cs b/WebAPI/Controllers/BLL/Xt_UserController.cs index 3ec6fa1..b0ecd17 100644 --- a/WebAPI/Controllers/BLL/Xt_UserController.cs +++ b/WebAPI/Controllers/BLL/Xt_UserController.cs @@ -238,14 +238,14 @@ ",HWhID,HWHName,HSupID,HSupName " + ",HSCWHID,HSCWHName " + ",HCloudUserName,HCloudUserPsd,HUSEORGID,HProcID" + - ",HGroupID,HSourceID,HCheckEmpID,HWorkCenterID,HICNumber,HDingDingUserID) " + + ",HGroupID,HSourceID,HCheckEmpID,HWorkCenterID,HICNumber,HDingDingUserID,HCusID) " + "values ('" + lsmain[0].Czybm.ToString() + "','" + lsmain[0].Czymc.ToString() + "','" + ClsPub.StrToPsd(lsmain[0].Czmm.ToString()) + "','" + lsmain[0].Explain.ToString() + "','" + lsmain[0].HEmpID.ToString() + "',"+ lsmain[0].HK3UserID.ToString() + "" + ","+ lsmain[0].HKeeperID.ToString() + ",'"+ lsmain[0].HKeeper.ToString() + "',"+ lsmain[0].HSecManagerID.ToString() + ",'"+ lsmain[0].HSecManager.ToString() + "'" + "," + lsmain[0].HSellManID.ToString() + ",'" + lsmain[0].HSellMan.ToString() + "'," + lsmain[0].HDeptID.ToString() + ",'" + lsmain[0].HDept.ToString() + "'" + "," + lsmain[0].HWhID.ToString() + ",'" + lsmain[0].HWHName.ToString() + "'," + lsmain[0].HSupID.ToString() + ",'" + lsmain[0].HSupName.ToString() + "'" + "," + lsmain[0].HSCWHID.ToString() + ",'" + lsmain[0].HSCWHName.ToString() + "'" + ",'" + lsmain[0].HCloudUserName.ToString() + "','" + lsmain[0].HCloudUserPsd.ToString() + "',"+ lsmain[0].HOrgID.ToString() + "," + lsmain[0].HProcID.ToString() + "" + - ","+ lsmain[0].HGroupID.ToString() + ","+ lsmain[0].HSourceID.ToString() + "," + lsmain[0].HCheckEmpID.ToString() + "," + lsmain[0].HWorkCenterID.ToString() + ",'" + lsmain[0].HICNumber + "','" + lsmain[0].HDingDingUserID + "'" + ")"); + ","+ lsmain[0].HGroupID.ToString() + ","+ lsmain[0].HSourceID.ToString() + "," + lsmain[0].HCheckEmpID.ToString() + "," + lsmain[0].HWorkCenterID.ToString() + ",'" + lsmain[0].HICNumber + "','" + lsmain[0].HDingDingUserID + "','" + lsmain[0].HCusID + "'" + ")"); //鏂板鍚庢煡璇� 纭繚鏁版嵁娣诲姞鎴愬姛 ds = oCN.RunProcReturn("Select * from Gy_Czygl where Czybm='" + lsmain[0].Czybm.ToString() + "'", "Gy_Czygl"); @@ -314,6 +314,7 @@ ",HUSEORGID=" + lsmain[0].HOrgID.ToString() + ",HICNumber='" + lsmain[0].HICNumber + "'" + ",HDingDingUserID='" + lsmain[0].HDingDingUserID + "'" + + ",HCusID='" + lsmain[0].HCusID + "'" + " where Czybm='" + lsmain[0].Czybm.ToString() + "'"); } else @@ -346,6 +347,7 @@ ",HUSEORGID=" + lsmain[0].HOrgID.ToString() + ",HICNumber='" + lsmain[0].HICNumber + "'" + ",HDingDingUserID='" + lsmain[0].HDingDingUserID + "'" + + ",HCusID='" + lsmain[0].HCusID + "'" + " where Czybm='" + lsmain[0].Czybm.ToString() + "'"); } -- Gitblit v1.9.1