From 1413158ae9f0fc5ac7eb39deeab7d5cc09950ad1 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期四, 01 二月 2024 10:57:51 +0800 Subject: [PATCH] 工序流转卡派工单删除方法,增加调用删除 前控制h_p_Sc_ProcExchSendWorkBill_BeforeDelCtrl 和删除 后控制h_p_Sc_ProcExchSendWorkBill_AfterDelCtrl 的存储过程。 工序委外派工单删除方法,增加 调用删除前控制h_p_WW_EntrustWorkOrderBill_BeforeDelCtrl 和删除后控制h_p_WW_EntrustWorkOrderBill_AfterDelCtrl 的存储过程。 工序进站接收单删除方法,增加调用删除前控制h_p_Sc_StationInBill_BeforeDelCtrl 和删除后控制h_p_Sc_StationInBill_AfterDelCtrl 的存储过程。 工序出站汇报单删除方法,增加调用删除前控制h_p_Sc_StationOutBill_BeforeDelCtrl 和删除后控制h_p_Sc_StationOutBill_AfterDelCtrl 的存储过程 --- WebAPI/Controllers/WebAPIController.cs | 29 +++++++++++++++++++++++++++-- 1 files changed, 27 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index c46c1ae..f50621d 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -7974,6 +7974,31 @@ } /// <summary> + /// 鐢ㄦ埛鍏宠仈鐝粍鑾峰彇淇℃伅 + /// </summary> + /// <returns></returns> + [Route("GetGy_UserGroupDetail")] + [HttpGet] + public ApiResult<DataSet> GetGy_UserGroupDetail(string HID) + { + var model = LuBaoSevice.GetGy_UserGroupBillDetail(HID); + return model; + } + + /// <summary> + /// 鐢ㄦ埛鍏宠仈渚涘簲鍟嗚幏鍙栦俊鎭� + /// </summary> + /// <returns></returns> + [Route("GetGy_UserSupplierDetail")] + [HttpGet] + public ApiResult<DataSet> GetGy_UserSupplierDetail(string HID) + { + var model = LuBaoSevice.GetGy_UserSupplierBillDetail(HID); + return model; + } + + + /// <summary> /// 鎶ュ簾鍘熷洜 /// </summary> /// <returns></returns> @@ -9071,11 +9096,11 @@ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { - ds = oCN.RunProcReturn("Select HItemID,HNumber 浠g爜,HName 鍚嶇О ,HQCCheckClassID 妫�楠岄」鐩被鍒� from Gy_QCCheckItem where HStopflag=0 Order by HItemID ", "Gy_QCCheckItem"); + ds = oCN.RunProcReturn("Select HItemID,HNumber 浠g爜,HName 鍚嶇О ,HQCCheckClassID 妫�楠岄」鐩被鍒�,HDefaultResult 榛樿缁撹 from Gy_QCCheckItem where HStopflag=0 Order by HItemID ", "Gy_QCCheckItem"); } else { - string sql = "Select HItemID,HNumber 浠g爜,HName 鍚嶇О ,HQCCheckClassID 妫�楠岄」鐩被鍒� from Gy_QCCheckItem where HStopflag=0 " + sWhere + "Order by HItemID "; + string sql = "Select HItemID,HNumber 浠g爜,HName 鍚嶇О ,HQCCheckClassID 妫�楠岄」鐩被鍒�,HDefaultResult 榛樿缁撹 from Gy_QCCheckItem where HStopflag=0 " + sWhere + "Order by HItemID "; ds = oCN.RunProcReturn(sql, "Gy_QCCheckItem"); } if (ds == null || ds.Tables[0].Rows.Count <= 0) -- Gitblit v1.9.1