From c193ef49cf93c007b8b908574e92ba5d8b0f6fc3 Mon Sep 17 00:00:00 2001 From: yusijie <ysj@hz-kingdee.com> Date: 星期三, 06 三月 2024 08:37:37 +0800 Subject: [PATCH] PDA,设备 质量模块扫码 --- WebAPI/Controllers/WebAPIController.cs | 71 ++++++++++++++++++++++++++++++++++- 1 files changed, 69 insertions(+), 2 deletions(-) diff --git a/WebAPI/Controllers/WebAPIController.cs b/WebAPI/Controllers/WebAPIController.cs index 6cca359..ca443ac 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> @@ -9678,7 +9703,7 @@ /// <returns></returns> [Route("Web/GetItemByEquipFile")] [HttpGet] - public object GetItemByEquipFile(int EquipProjectID,string Type) + public object GetItemByEquipFile(int EquipProjectID,string Type,string HDate) { if (EquipProjectID <= 0) { @@ -9708,7 +9733,8 @@ } SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); - string sql = string.Format(@"select * from " + HView + " where HInterID = " + EquipProjectID); + //string sql = string.Format(@"select * from " + HView + " where HInterID = " + EquipProjectID); + string sql = string.Format(@"Exec h_p_Sb_GetCheckItem_PDA '" + EquipProjectID + "','" + Type + "','" + HDate + "'"); ds = oCN.RunProcReturn(sql, HView); if (ds == null || ds.Tables[0].Rows.Count <= 0) { @@ -10925,6 +10951,47 @@ } } + /// <summary> + /// 鑾峰彇鍗曟嵁妯″潡鍚嶇О + /// </summary> + /// <returns></returns> + [Route("Web/GetModuleName")] + [HttpGet] + public object GetModuleName(string HModuleType) + { + try + { + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + + ds = oCN.RunProcReturn("Select * from Xt_BillType where HNumber = '" + HModuleType + "'", "Xt_BillType"); + + if (ds == null || ds.Tables[0].Rows.Count <= 0) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触" + DBUtility.ClsPub.sErrInfo; + objjson.data = null; + return objjson; + } + else + { + objjson.code = "1"; + objjson.count = 1; + objjson.Message = "鑾峰彇鎴愬姛!"; + objjson.data = ds.Tables[0]; + return objjson; + } + } + catch (Exception ex) + { + objjson.code = "0"; + objjson.count = 0; + objjson.Message = "鑾峰彇澶辫触" + ex.ToString(); + objjson.data = null; + return objjson; + } + } + } } -- Gitblit v1.9.1