From 6075d101b47a4c1dcfe08e535e0772f33ed2d392 Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期四, 09 十一月 2023 13:45:06 +0800 Subject: [PATCH] 应收退款单:删除时判断单据是否审核,若已审核则删除失败 --- WebAPI/Controllers/XSGL/YS_ReceiveBillController.cs | 76 ++++++++++++++++++++++++++++++++++++++ 1 files changed, 76 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/XSGL/YS_ReceiveBillController.cs b/WebAPI/Controllers/XSGL/YS_ReceiveBillController.cs index 942e365..7c45745 100644 --- a/WebAPI/Controllers/XSGL/YS_ReceiveBillController.cs +++ b/WebAPI/Controllers/XSGL/YS_ReceiveBillController.cs @@ -312,6 +312,8 @@ { try { + string s = ""; + //鏌ョ湅鏉冮檺 if (!DBUtility.ClsPub.Security_Log("YS_ReceiveBill_Drop", 1, false, user)) { @@ -328,6 +330,24 @@ objJsonResult.count = 0; objJsonResult.Message = "HInterID涓嶈兘涓虹┖锛�"; objJsonResult.data = null; + return objJsonResult; + } + + if (BillOld.ShowBill(long.Parse(HInterID), ref s) == false) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "姝ゅ崟鎹湁璇紒"; + objJsonResult.data = 1; + return objJsonResult; + } + //鍒ゆ柇鏄惁鍙紪杈� + if (BillOld.omodel.HChecker != "" && BillOld.omodel.HChecker != null) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "姝ゅ崟鎹凡缁忚瀹℃牳锛屼笉鍏佽鍒犻櫎锛�"; + objJsonResult.data = 1; return objJsonResult; } @@ -781,5 +801,61 @@ } } #endregion + + #region 鏀舵鍗� 鏍规嵁瀹㈡埛鑾峰彇甯佸埆銆佹眹鐜囥�佺粨绠楁柟寮忋�侀摱琛屻�侀摱琛岃处鎴� + [Route("YS_ReceiveBill/getCustomerByCusID")] + [HttpGet] + public object getCustomerByCusID(long HCusID) + { + try + { + string sql = @"select + c.HItemID HCusID + ,c.HNumber HCusNumber + ,c.HName HCusName + ,c.HSSID + ,s.HName HSSName + ,c.HCurID + ,cur.HName HCurName + ,cur.HExchangeRate HExRate + ,c.HTaxRate + ,ISNULL(b.HItemID,0) HBankID + ,b.HName HBankName + ,c.HBankAccount + from Gy_Customer as c + left join Gy_SettleStyle as s on c.HSSID = s.HItemID + left join Gy_Currency as cur on c.HCurID = cur.HItemID + left join Gy_Bank as b on c.HBank = b.HName + where c.HItemID = " + HCusID; + ds = oCN.RunProcReturn(sql, "Gy_Customer"); + + + if (ds == null || ds.Tables[0].Rows.Count == 0) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏈煡璇㈠埌璇ュ鎴蜂俊鎭紒"; + objJsonResult.data = null; + return objJsonResult; + } + else + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + return objJsonResult; + } + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "Exception锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion } } \ No newline at end of file -- Gitblit v1.9.1