From c7cfb07c1d5941a2023431c4b41519dcb2b0f872 Mon Sep 17 00:00:00 2001 From: ch <37327@LLOOCCY> Date: 星期四, 01 九月 2022 08:49:54 +0800 Subject: [PATCH] 新增了出站汇报单显示流转卡信息 批量汇报功能 --- WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs | 19 +++++++++++++++++++ 1 files changed, 19 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs b/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs index a34f6e1..fd02fef 100644 --- a/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs +++ b/WebAPI/Controllers/CJGL/Sc_ProcessExchangeBillController.cs @@ -552,6 +552,25 @@ objJsonResult.data = null; return objJsonResult; } + + + //鍒犻櫎鍓嶅垽鏂叧鑱旀暟閲� + SQLHelper.ClsCN oCn = new SQLHelper.ClsCN(); + DataSet ds; + ds = oCn.RunProcReturn("select ct from ( " + + " select 1 ct from Sc_StationInBillMain Where HProcExchInterID=" + lngBillKey + " " + + " union all " + + " select 1 from Sc_StationOutBillMain Where HProcExchInterID=" + lngBillKey + " ) as a ", "Sc_ProcExchReportSub"); + if (ds.Tables[0].Rows.Count != 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "娴佽浆鍗″凡缁忔湁涓嬫父杩涘嚭绔欏崟鍚庯紝涓嶅厑璁稿垹闄わ紒"; + objJsonResult.data = null; + return objJsonResult; + } + + DAL.ClsSc_ProcessExchangeBill oBill = new DAL.ClsSc_ProcessExchangeBill(); DBUtility.ClsPub.HOrgID = HPRDORGID; if (oBill.ShowBill(lngBillKey, ref DBUtility.ClsPub.sExeReturnInfo)) -- Gitblit v1.9.1