From 54329f0ab6bf4d87d95e37a553ffdf0b14fa4bea Mon Sep 17 00:00:00 2001 From: zrg <z18737863051@163.com> Date: 星期四, 08 八月 2024 17:31:07 +0800 Subject: [PATCH] 产品工艺参数清单, 增加 字段 HTechParamClassID int //工艺参数大类(Gy_TechnologyParameterClass) HSNO int //工艺次序 HStdNextTimes money //理论次序间隔 HTechParamIDStd int //对应设定值工艺参数(Gy_TechnologyParameter) (都是非必录),修改出战斗获取模具 --- WebAPI/Service/LuBaoSevice.cs | 59 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++- 1 files changed, 58 insertions(+), 1 deletions(-) diff --git a/WebAPI/Service/LuBaoSevice.cs b/WebAPI/Service/LuBaoSevice.cs index b566298..7305810 100644 --- a/WebAPI/Service/LuBaoSevice.cs +++ b/WebAPI/Service/LuBaoSevice.cs @@ -326,7 +326,7 @@ public static DataSet GetGy_UserProcessDb(string HID) { SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); - var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_UserProcess where HItemID= " + HID + " ", "h_v_Gy_UserProcess"); + var dataSet = oCN.RunProcReturn("select * from h_v_Gy_InspectBasis_Edit where HItemID= " + HID + " ", "h_v_Gy_InspectBasis_Edit"); return dataSet; } @@ -662,6 +662,44 @@ } /// <summary> + /// 浼戞伅鏃ユ牴鎹甶d鑾峰彇淇℃伅 + /// </summary> + public static ApiResult<DataSet> GetGy_RestDayDetailEdit(string HID) + { + if (string.IsNullOrEmpty(HID)) + return new ApiResult<DataSet> { code = -1, msg = "鍚嶇О涓嶈兘涓虹┖" }; + var dataSet = GetGy_RestDayEditDb(HID); + if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) + return new ApiResult<DataSet> { code = -1, msg = "涓嶅瓨鍦ㄤ紤鎭棩鏁版嵁" }; + return new ApiResult<DataSet> { code = 1, msg = "鏌ヨ鎴愬姛", data = dataSet }; + } + public static DataSet GetGy_RestDayEditDb(string HID) + { + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + var dataSet = oCN.RunProcReturn("select * from h_v_Gy_RestDay where HItemID= '" + HID + "' ", "h_v_Gy_RestDay"); + return dataSet; + } + + /// <summary> + /// 浼戞伅鏃ユ牴鎹櫥褰曚汉鑾峰彇淇℃伅 + /// </summary> + public static ApiResult<DataSet> GetGy_RestDayDetail(string HName) + { + if (string.IsNullOrEmpty(HName)) + return new ApiResult<DataSet> { code = -1, msg = "鍚嶇О涓嶈兘涓虹┖" }; + var dataSet = GetGy_RestDayDb(HName); + if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) + return new ApiResult<DataSet> { code = -1, msg = "涓嶅瓨鍦ㄤ紤鎭棩鏁版嵁" }; + return new ApiResult<DataSet> { code = 1, msg = "鏌ヨ鎴愬姛", data = dataSet }; + } + public static DataSet GetGy_RestDayDb(string HName) + { + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + var dataSet = oCN.RunProcReturn("select a.HDeptID,b.HNumber 閮ㄩ棬缂栫爜,b.HName 閮ㄩ棬鍚嶇О,c.HNumber 缁勭粐缂栫爜,c.Hname 缁勭粐鍚嶇О from Gy_Czygl a left join Gy_Department b on a.HDeptID = b.HItemID left join Xt_ORGANIZATIONS c on a.HUSEORGID = c.HItemID where a.Czymc = '" + HName + "' ", "Gy_Czygl"); + return dataSet; + } + + /// <summary> /// 淇濆吇绾у埆鏍规嵁id鑾峰彇淇℃伅 /// </summary> public static ApiResult<DataSet> GetGy_MaintainLevDetail(string HID) @@ -680,6 +718,25 @@ return dataSet; } + /// <summary> + /// 鍚姩妫�鏌ラ」鐩牴鎹甶d鑾峰彇淇℃伅 + /// </summary> + public static ApiResult<DataSet> GetGy_CheckNoteItemDetail(string HID) + { + if (string.IsNullOrEmpty(HID)) + return new ApiResult<DataSet> { code = -1, msg = "ID涓嶈兘涓虹┖" }; + var dataSet = GetGy_CheckNoteItemDb(HID); + if (dataSet == null || dataSet.Tables[0].Rows.Count == 0) + return new ApiResult<DataSet> { code = -1, msg = "涓嶅瓨鍦ㄥ惎鍔ㄦ鏌ラ」鐩暟鎹�" }; + return new ApiResult<DataSet> { code = 1, msg = "鏌ヨ鎴愬姛", data = dataSet }; + } + public static DataSet GetGy_CheckNoteItemDb(string HID) + { + SQLHelper.ClsCN oCN = new SQLHelper.ClsCN(); + var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_CheckNoteItem where HItemID= " + HID + " ", "h_v_Gy_CheckNoteItem"); + return dataSet; + } + /// <summary> /// 椤圭洰绫诲埆鏍规嵁id鑾峰彇淇℃伅 -- Gitblit v1.9.1