From 50c163d99127dd1af9526646c0a41438e9d2b486 Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期二, 30 一月 2024 13:18:00 +0800 Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MES-WEB-API --- WebAPI/Controllers/WebAPIController.cs | 62 ++++++++++++++++++++++++++++++- 1 files changed, 60 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index 0c650fe..f50621d 100644 --- a/WebAPI/Controllers/WebAPIController.cs +++ b/WebAPI/Controllers/WebAPIController.cs @@ -7974,6 +7974,31 @@ } /// <summary> + /// 鐢ㄦ埛鍏宠仈鐝粍鑾峰彇淇℃伅 + /// </summary> + /// <returns></returns> + [Route("GetGy_UserGroupDetail")] + [HttpGet] + public ApiResult<DataSet> GetGy_UserGroupDetail(string HID) + { + var model = LuBaoSevice.GetGy_UserGroupBillDetail(HID); + return model; + } + + /// <summary> + /// 鐢ㄦ埛鍏宠仈渚涘簲鍟嗚幏鍙栦俊鎭� + /// </summary> + /// <returns></returns> + [Route("GetGy_UserSupplierDetail")] + [HttpGet] + public ApiResult<DataSet> GetGy_UserSupplierDetail(string HID) + { + var model = LuBaoSevice.GetGy_UserSupplierBillDetail(HID); + return model; + } + + + /// <summary> /// 鎶ュ簾鍘熷洜 /// </summary> /// <returns></returns> @@ -9071,11 +9096,11 @@ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); if (sWhere == null || sWhere.Equals("")) { - ds = oCN.RunProcReturn("Select HItemID,HNumber 浠g爜,HName 鍚嶇О ,HQCCheckClassID 妫�楠岄」鐩被鍒� from Gy_QCCheckItem where HStopflag=0 Order by HItemID ", "Gy_QCCheckItem"); + ds = oCN.RunProcReturn("Select HItemID,HNumber 浠g爜,HName 鍚嶇О ,HQCCheckClassID 妫�楠岄」鐩被鍒�,HDefaultResult 榛樿缁撹 from Gy_QCCheckItem where HStopflag=0 Order by HItemID ", "Gy_QCCheckItem"); } else { - string sql = "Select HItemID,HNumber 浠g爜,HName 鍚嶇О ,HQCCheckClassID 妫�楠岄」鐩被鍒� from Gy_QCCheckItem where HStopflag=0 " + sWhere + "Order by HItemID "; + string sql = "Select HItemID,HNumber 浠g爜,HName 鍚嶇О ,HQCCheckClassID 妫�楠岄」鐩被鍒�,HDefaultResult 榛樿缁撹 from Gy_QCCheckItem where HStopflag=0 " + sWhere + "Order by HItemID "; ds = oCN.RunProcReturn(sql, "Gy_QCCheckItem"); } if (ds == null || ds.Tables[0].Rows.Count <= 0) @@ -9991,6 +10016,39 @@ } + + /// <summary> + /// 鑾峰彇閫夊崟鍙风殑婧愬崟绫诲瀷 + /// </summary> + /// <returns></returns> + [Route("Web/GetHSourceBillType")] + [HttpGet] + public object GetHSourceBillType(string HName) + { + try + { + ClsCN oCn = new ClsCN(); + DataSet oDs = new DataSet(); + //========== + oDs = oCn.RunProcReturn("select * from Xt_BillSourceSet where HName='"+HName+"'", "Xt_BillSourceSet"); + objjson.code = "1"; + objjson.count = 1; + objjson.Message = "鑾峰彇鎴愬姛锛�"; + objjson.data = oDs.Tables[0]; + return objjson; ; + } + catch (Exception e) + { + + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触锛佸紓甯�" + e.ToString(); + objjson.data = null; + return objjson; ; + } + } + + #region [浠庢暟鎹簱鍔犺浇鑿滃崟] public class MenuLoad { -- Gitblit v1.9.1