From 54853f03a6d35e0659a9ba5ff7b0b56ca01d4d50 Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期三, 01 三月 2023 10:07:23 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- WebAPI/Controllers/CJGL/Cj_StationInBillController.cs | 60 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++-- 1 files changed, 58 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/CJGL/Cj_StationInBillController.cs b/WebAPI/Controllers/CJGL/Cj_StationInBillController.cs index 9820ef3..6d8ee64 100644 --- a/WebAPI/Controllers/CJGL/Cj_StationInBillController.cs +++ b/WebAPI/Controllers/CJGL/Cj_StationInBillController.cs @@ -72,8 +72,8 @@ objJsonResult.data = null; return objJsonResult; } - long HProcNo = list[0].HProcNo;//娴佹按鍙� - if (HProcNo <= 0) + string HProcNo = list[0].HProcNo;//娴佹按鍙� + if (HProcNo == "") { objJsonResult.code = "0"; objJsonResult.count = 0; @@ -1042,5 +1042,61 @@ } } #endregion + + #region 杩斿洖鐢ㄦ埛鑾峰彇榛樿鍊煎垪琛� + [Route("Cj_StationInBill/GetDefValByUser")] + [HttpGet] + public object GetDefValByUser(string Czybm, string Czymc) + { + try + { + ////鍒ゆ柇鏄惁鏈夋煡璇㈡潈闄� + //if (!DBUtility.ClsPub.Security_Log("Cj_StationInBill_Query", 1, false, user)) + //{ + // objJsonResult.code = "0"; + // objJsonResult.count = 0; + // objJsonResult.Message = "鏃犳煡璇㈡潈闄�!"; + // objJsonResult.data = null; + // return objJsonResult; + //} + + if (Czymc == null || Czymc.Equals("")) + { + ds = oCN.RunProcReturn("select * from h_v_Cj_GetDefValByUser", "h_v_Cj_GetDefValByUser"); + } + else + { + string sql1 = "select * from h_v_Cj_GetDefValByUser where 1 = 1 "; + string sql = sql1 + " and 鐢ㄦ埛缂栫爜 ='" + Czybm + "' and 鐢ㄦ埛鍚嶇О ='" + Czymc + "'"; + ds = oCN.RunProcReturn(sql, "h_v_Cj_GetDefValByUser"); + } + + if (ds.Tables[0].Rows.Count != 0 || ds != null) + { + objJsonResult.code = "1"; + objJsonResult.count = 1; + objJsonResult.Message = "Sucess锛�"; + objJsonResult.data = ds.Tables[0]; + return objJsonResult; + } + else + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏃犳暟鎹�"; + objJsonResult.data = null; + return objJsonResult; + } + } + catch (Exception e) + { + objJsonResult.code = "0"; + objJsonResult.count = 0; + objJsonResult.Message = "鏌ヨ鏁版嵁寮傚父锛岃涓庣鐞嗗憳鑱旂郴锛�" + e.ToString(); + objJsonResult.data = null; + return objJsonResult; + } + } + #endregion } } \ No newline at end of file -- Gitblit v1.9.1