From db5920f4d90f6b8a02a2ae50147ee044bb27968f Mon Sep 17 00:00:00 2001
From: yusijie <ysj@hz-kingdee.com>
Date: 星期五, 07 十一月 2025 09:28:08 +0800
Subject: [PATCH] 首件检验单优化，添加检验SN码，检验方法/标准字段；询价单子表添加抽检SN码字段；首件检验单编辑查询方法添加子表id排序；
---
WebAPI/Controllers/Open_PrintTemController.cs | 23 ++++++++++++++++++++---
1 files changed, 20 insertions(+), 3 deletions(-)
diff --git a/WebAPI/Controllers/Open_PrintTemController.cs b/WebAPI/Controllers/Open_PrintTemController.cs
index 12b2343..ef8c5a4 100644
--- a/WebAPI/Controllers/Open_PrintTemController.cs
+++ b/WebAPI/Controllers/Open_PrintTemController.cs
@@ -30,7 +30,7 @@
{
sWhere = " Where 1=1 ";
//sWhere = " Where HStopFlag=0 and HEndFlag=1 and HUSEORGID = " + DBUtility.ClsPub.HORGANIZATIONSID.ToString();
- if (HNumber != "")
+ if (HNumber != "" && HNumber != null && HNumber != "undefined")
{
sWhere = sWhere + " and ( HNumber = '" + HNumber + "') ";
}
@@ -73,12 +73,20 @@
/// <returns></returns>
[Route("Open_PrintTem/SaveOpenTmp")]
[HttpGet]
- public object SaveOpenTmp(string HNumber, string HName)
+ public object SaveOpenTmp(string HNumber, string HName,string user)
{
//ClsCNSRM oCn = new ClsCNSRM();
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
try
{
+ if (!DBUtility.ClsPub.Security_Log("OpenPrintTmp_Edit", 1, false, user))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
oCn.BeginTran();
oCn.RunProc("Insert into SRM_OpenTmp " +
@@ -112,11 +120,20 @@
/// <returns></returns>
[Route("Open_PrintTem/DelOpenTmp")]
[HttpGet]
- public object DelOpenTmp(string HItemID)
+ public object DelOpenTmp(string HItemID, string user)
{
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
try
{
+ if (!DBUtility.ClsPub.Security_Log("OpenPrintTmp_Delete", 1, false, user))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鏃犲垹闄ゆ潈闄愶紒";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+
oCn.BeginTran();
oCn.RunProc("Delete from SRM_OpenTmp where HItemID='" + DBUtility.ClsPub.isLong(HItemID) + "'", ref DBUtility.ClsPub.sExeReturnInfo);
oCn.Commit();
--
Gitblit v1.9.1