From c98968a17029fb98e72596c1a868e7d543816102 Mon Sep 17 00:00:00 2001 From: yangle <admin@YINMOU> Date: 星期四, 18 四月 2024 16:31:11 +0800 Subject: [PATCH] 对色记录单查询优化 当前工单模块 出站汇报 --- WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs | 15 +++++++++++---- 1 files changed, 11 insertions(+), 4 deletions(-) diff --git a/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs b/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs index 15577f4..9fde5b9 100644 --- a/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs +++ b/WebAPI/Controllers/CJGL/Cj_StationEntrustInBillController.cs @@ -1023,12 +1023,19 @@ } ds = oCN.RunProcReturn("select ManagerFlag from gy_czygl where czymc='" + user.Trim() + "'", "gy_czygl"); - if (!(bool)ds.Tables[0].Rows[0]["ManagerFlag"]) //鏄惁绠$悊鍛� + string sErr = ""; + oSystemParameter.ShowBill(ref sErr); + if (oSystemParameter.omodel.WMS_CampanyName == "涔斾竴") { - //涓嶆槸绠$悊鍛� - sWhere += " and 鍒跺崟浜� = '" + user + "'"; } - + else + { + if (!(bool)ds.Tables[0].Rows[0]["ManagerFlag"]) //鏄惁绠$悊鍛� + { + //涓嶆槸绠$悊鍛� + sWhere += " and 鍒跺崟浜� = '" + user + "'"; + } + } string sql = "select * from h_v_QC_FirstPieceCheckBillMainList where 1=1 " + sWhere + " order by 鏃ユ湡 "; -- Gitblit v1.9.1