From ef5759a657e28a389cc963e804e9862364fdcc26 Mon Sep 17 00:00:00 2001 From: duhe <226547893@qq.com> Date: 星期二, 26 三月 2024 15:13:10 +0800 Subject: [PATCH] 前端保存时,数据校验,当物料未选择时,不进行数据的校验。后端获取数据后,将物料未选择的数据去除。 --- WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs | 62 ++++++++++++++++++++++++++++++- 1 files changed, 60 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs b/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs index 347a03c..e008b7a 100644 --- a/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs +++ b/WebAPI/Controllers/XSGL/Xs_SeOrderBillController.cs @@ -1209,8 +1209,11 @@ //oItemSub.HSourceBillType = ""; //婧愬崟绫诲瀷 //oItemSub.HRelationQty = 0; //鍏宠仈鏁伴噺 //oItemSub.HRelationMoney = 0; //鍏宠仈閲戦 - oBill.DetailColl.Add(oItemSub); + if (oItemSub.HMaterID != 0) + { + oBill.DetailColl.Add(oItemSub); + } } //淇濆瓨 //淇濆瓨瀹屾瘯鍚庡鐞� @@ -1491,6 +1494,18 @@ objJsonResult.Message = "鍗曟嵁鏈鏍�!涓嶉渶瑕佸弽瀹℃牳!"; objJsonResult.data = null; return objJsonResult; + } + + foreach(Model.ClsXs_SeOrderBillSub oSub in oBill.DetailColl) + { + if (oSub.HCloseMan != "") + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鍗曟嵁涓瓨鍦ㄨ鍏抽棴鐨勮褰�!鍙嶅鏍稿け璐ワ紒"; + objJsonResult.data = null; + return objJsonResult; + } } } } @@ -2226,7 +2241,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 +2475,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