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 | 122 ++++++++++++++++++++++++++++++++++++++++
1 files changed, 122 insertions(+), 0 deletions(-)
diff --git a/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs b/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs
index 30ca36b..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();
@@ -1758,5 +1779,106 @@
}
}
#endregion
+
+ #region 閿�鍞鍗� 鏍规嵁瀹㈡埛鑾峰彇甯佸埆銆佹眹鐜囥�佺粨绠楁柟寮�
+ [Route("Xs_SeOrderBill/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
+ 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
+ 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
+
+ #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