From 7fe7e5c3155ed0a91430d37c2c8dc66c8fbf6de3 Mon Sep 17 00:00:00 2001
From: yxj <yxj@hz-kingdee.com>
Date: 星期五, 06 二月 2026 15:29:57 +0800
Subject: [PATCH] 新增销售退货、采购退料、生产退库校验上传调用方法
---
WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs | 39 +++++++++++++++++++++++++++++++++++++--
1 files changed, 37 insertions(+), 2 deletions(-)
diff --git a/WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs b/WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs
index 511dbf7..1d59420 100644
--- a/WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs
+++ b/WebAPI/Controllers/Sb_CheckEqpRepairWorkBillController.cs
@@ -795,7 +795,8 @@
try
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
- ds = oCN.RunProcReturn("select 鍗曟嵁鍙�,hmainid,hsubid,HBillType from h_v_Sb_EquipConkBookBillList where 鍗曟嵁鍙�= '" + HMainSourceBillNo+"'", "h_v_Sb_EquipConkBookBillList");
+ // ds = oCN.RunProcReturn("select 鍗曟嵁鍙�,hmainid,hsubid,HBillType from h_v_Sb_EquipConkBookBillList where 鍗曟嵁鍙�= '" + HMainSourceBillNo+"'", "h_v_Sb_EquipConkBookBillList");
+ ds = oCN.RunProcReturn("select * from h_v_Sb_EquipConkBookBillList where 鍗曟嵁鍙�= '" + HMainSourceBillNo+"'", "h_v_Sb_EquipConkBookBillList");
objJsonResult.code = "0";
objJsonResult.count = 1;
objJsonResult.Message = "鑾峰彇淇℃伅鎴愬姛锛�";
@@ -916,7 +917,40 @@
#endregion
+ #region [璁惧缁翠慨鍗曢�氳繃鏁呴殰鐧昏鍗曡幏鍙栫淮淇褰昡
+ [Route("Sb_EqpRepairWorkBill/GetEquipMatainanceBillBySourceInterID")]
+ [HttpGet]
+ public object GetEquipMatainanceBillBySourceInterID (string user, int HSourceInterID)
+ {
+ try
+ {
+ if (!DBUtility.ClsPub.Security_Log("Sb_EquipRepairCheckBillList", 1, false, user))
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "鏃犱繚瀛樻潈闄愶紒";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ ds = oCN.RunProcReturn($"select * from h_v_GetEquipMatainanceBillBySourceInterID where HInterID = {HSourceInterID} and isnull(璁惧缁翠慨楠屾敹鍗�,'') = ''", "h_v_GetEquipMatainanceBillBySourceInterID");
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "杩斿洖璁板綍鎴愬姛锛�";
+ objJsonResult.data = ds.Tables[0];
+ return objJsonResult;
+ }
+ catch (Exception ex)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + ex.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
#region 璁惧缁翠慨楠屾敹鍗曚繚瀛�/缂栬緫
/// <summary>
@@ -1632,7 +1666,7 @@
objJsonResult.data = 1;
return objJsonResult;
}
-
+ LogService.Write("婧愬崟绫诲瀷: " + oItem.HMainSourceBillType);
//oItem.HMaker = "";
UserName = oItem.HMaker; //鍒跺崟浜�
oItem.HBillType = "3910";
@@ -1685,6 +1719,7 @@
//oItemSub.HCloseMan = ""; //琛屽叧闂�
oItemSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DateTime.Now);
oItemSub.HCloseType = false; //鍏抽棴绫诲瀷
+
//oItemSub.HRemark = ""; //澶囨敞
//oItemSub.HSourceInterID = 0; // 婧愬崟涓诲唴鐮�
//oItemSub.HSourceEntryID = 0; //婧愬崟瀛愬唴鐮�
--
Gitblit v1.9.1