From dd6a64701b6ade18e1a4742deac10f21bedb723c Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期四, 09 十一月 2023 18:49:38 +0800 Subject: [PATCH] 特批申请单:审核后自动审核源单(已注释,待优化) --- WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs | 71 +++++++++++++++++++++++++++++++++++ 1 files changed, 71 insertions(+), 0 deletions(-) diff --git a/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs b/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs index 7ac3215..5e4b100 100644 --- a/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs +++ b/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs @@ -1289,6 +1289,8 @@ { try { + string s = ""; + //鏌ョ湅鏉冮檺 if (!DBUtility.ClsPub.Security_Log("Xs_SeOrderBill_Drop", 1, false, user)) { @@ -1307,6 +1309,25 @@ 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; + } + oCN.BeginTran(); @@ -1775,6 +1796,7 @@ ,c.HCurID ,cur.HName HCurName ,cur.HExchangeRate HExRate + ,c.HTaxRate 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 @@ -1809,5 +1831,54 @@ } } #endregion + + #region 閿�鍞鍗� 鏍规嵁鐢ㄦ埛鑾峰彇閿�鍞憳銆侀攢鍞儴闂ㄣ�侀攢鍞富绠� + [Route("Xs_SeOrderBill/getCzyglByUser")] + [HttpGet] + public object getCzyglByUser(string CurUserName) + { + try + { + string sql = @"select + c.HEmpID + ,e.HName HEmpName + ,c.HDeptID + ,d.HName HDeptName + ,d.HEmpID HManagerID + ,e1.HName HManagerName + from Gy_Czygl as c + left join Gy_Employee as e on c.HEmpID = e.HItemID + left join Gy_Department as d on c.HDeptID = d.HItemID + left join Gy_Employee as e1 on d.HEmpID = e1.HItemID + where c.Czymc = '" + CurUserName + "'"; + ds = oCN.RunProcReturn(sql, "Gy_Czygl"); + + 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