From 1e842b39abe653fddd28c998511345c30001e884 Mon Sep 17 00:00:00 2001 From: yxj <yxj@hz-kingdee.com> Date: 星期四, 21 三月 2024 15:49:17 +0800 Subject: [PATCH] 条码生成模块,生成条码时增加根据用户权限判断生成条码总数量是否可超源单数量 --- WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs | 45 ++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 44 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs b/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs index 347a03c..8d8bc56 100644 --- a/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs +++ b/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs @@ -2226,7 +2226,7 @@ } else { - sWhere = " and HCusID in (select hcusid from Gy_UserCustomerRelation Where HUserID = '" + CurUserID + "') "; + sWhere = " and HCusID in (select hcusid from Gy_UserCustomerRelation Where HUserID = '" + CurUserID + "' union all select 166351 hcusid)"; } objJsonResult.code = "1"; @@ -2460,5 +2460,48 @@ } } #endregion + + #region 閿�鍞鍗� 鏍规嵁鑱屽憳鑾峰彇閮ㄩ棬銆佷富绠� + [Route("Xs_SeOrderBill/getEmpInfoByHEmpID")] + [HttpGet] + public object getEmpInfoByHEmpID(long HEmpID) + { + try + { + string sql = "select a.HItemID HEmpID,a.HName HEmpName,ISNULL(a.HDeptID,0) HDeptID,b.HName HDeptName,ISNULL(b.HEmpID,0) HManagerID,c.HName HManagerName " + + " from Gy_Employee as a " + + " left join Gy_Department as b on a.HDeptID = b.HItemID " + + " left join Gy_Employee as c on b.HEmpID = c.HItemID " + + " where a.HItemID = " + HEmpID; + ds = oCN.RunProcReturn(sql, "Gy_Employee"); + + + 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