From 9f298c3a9cfc9a4d7e56e4b6e89ec09cbe9bcb88 Mon Sep 17 00:00:00 2001
From: chenhaozhe <cgz@hz-kingdee.com>
Date: 星期五, 27 二月 2026 15:29:35 +0800
Subject: [PATCH] 获取职员列表 接口 添加车间(部门)筛选选项
---
WebAPI/Controllers/Sc_EmployeeSignInNoteBillController.cs | 59 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 58 insertions(+), 1 deletions(-)
diff --git a/WebAPI/Controllers/Sc_EmployeeSignInNoteBillController.cs b/WebAPI/Controllers/Sc_EmployeeSignInNoteBillController.cs
index 842d524..709efe9 100644
--- a/WebAPI/Controllers/Sc_EmployeeSignInNoteBillController.cs
+++ b/WebAPI/Controllers/Sc_EmployeeSignInNoteBillController.cs
@@ -424,8 +424,33 @@
return objJsonResult;
}
}
- #endregion
+ [Route("Sc_EmployeeSignInNoteBillController/Get_equipmentMes")]
+ [HttpGet]
+ public object Get_MouldMes(int HInterID, string HBarCode)
+ {
+
+ DataSet dss = oCN.RunProcReturn("select HInterID from Gy_EquipFileBillMain where HBarCode='"+ HBarCode + "'", "Gy_EquipFileBillMain");
+ DataSet ds = oCN.RunProcReturn("exec h_p_SB_HEquipHMould_Query '" + dss.Tables[0].Rows[0]["HInterID"] + "'", "h_p_SB_HEquipHMould_Query");
+ if (ds != null || ds.Tables.Count > 0)
+ {
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "鎴愬姛";
+ objJsonResult.data = ds.Tables[0];
+ return objJsonResult;
+
+ }
+ else
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�";
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
#region 淇濆瓨/缂栬緫
@@ -603,5 +628,37 @@
}
}
#endregion
+
+
+ #region 鍑虹珯鍗� 鏌ヨ褰撳墠鏈哄彴鐨勬搷浣滃憳銆佹ā鍏峰伐銆佹満淇� 锛堝崕鑸燂級
+ [Route("Sc_EmployeeSignInNoteBillController/Get_HSourceRoulsList")]
+ [HttpGet]
+ public object Get_HSourceRoulsList(int HSourceID)
+ {
+ try
+ {
+ List<object> columnNameList = new List<object>();
+
+
+ ds = oCN.RunProcReturn("exec h_p_Cj_StationOutBill_Roules_HZ '" + HSourceID + "'", "h_p_Cj_StationOutBill_Roules_HZ");
+
+ objJsonResult.code = "1";
+ objJsonResult.count = 1;
+ objJsonResult.Message = "Sucess锛�";
+ objJsonResult.data = ds;
+ objJsonResult.list = null;
+ return objJsonResult;
+ }
+ catch (Exception ex)
+ {
+ objJsonResult.code = "0";
+ objJsonResult.count = 0;
+ objJsonResult.Message = "娌℃湁杩斿洖浠讳綍璁板綍锛�" + ex.ToString();
+ objJsonResult.data = null;
+ return objJsonResult;
+ }
+ }
+ #endregion
+
}
}
--
Gitblit v1.9.1