From 355dec078e44db52fc6c6371debbe44898e6f1f1 Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期四, 07 三月 2024 11:22:42 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- WebAPI/Controllers/WebAPIController.cs | 11 ++++++++++- 1 files changed, 10 insertions(+), 1 deletions(-) diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index c89afbd..b23cf09 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -10070,7 +10070,7 @@ /// <returns></returns> [Route("Web/GetEquipmentBillsList")] [HttpGet] - public object GetEquipmentBillsList(string sWhere, string Type) + public object GetEquipmentBillsList(string sWhere, string Type,string user) { try { @@ -10102,6 +10102,15 @@ } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + + ds = oCN.RunProcReturn("select ManagerFlag from gy_czygl where czymc='" + user.Trim() + "'", "gy_czygl"); + if (!(bool)ds.Tables[0].Rows[0]["ManagerFlag"]) //鏄惁绠$悊鍛� + { + //涓嶆槸绠$悊鍛� + sWhere += " and 鍒跺崟浜� = '" + user + "'"; + } + + string sql = string.Format(@"select * from " + HView + " where 1 = 1 " + sWhere); ds = oCN.RunProcReturn(sql, HView); //娣诲姞鍒楀悕 -- Gitblit v1.9.1