From d0efffbf456b068abdac497b9bf86d295e6d21be Mon Sep 17 00:00:00 2001
From: yxj <yxj@hz-kingdee.com>
Date: 星期四, 05 十二月 2024 13:14:38 +0800
Subject: [PATCH] 新增PDA扫码模块获取入库类型、出库类型调用方法，传票验证调用方法等
---
WebAPI/Service/LuBaoSevice.cs | 102 +++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 102 insertions(+), 0 deletions(-)
diff --git a/WebAPI/Service/LuBaoSevice.cs b/WebAPI/Service/LuBaoSevice.cs
index 42f09fe..0694899 100644
--- a/WebAPI/Service/LuBaoSevice.cs
+++ b/WebAPI/Service/LuBaoSevice.cs
@@ -662,6 +662,64 @@
}
/// <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>
+ /// 鐜妫�娴嬪崟鏍规嵁id鑾峰彇淇℃伅
+ /// </summary>
+ public static ApiResult<DataSet> GetGy_EnvironmentTestItemEdit(string HID)
+ {
+ if (string.IsNullOrEmpty(HID))
+ return new ApiResult<DataSet> { code = -1, msg = "ID涓嶈兘涓虹┖" };
+ var dataSet = GetGy_EnvironmentTestItemDb(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_EnvironmentTestItemDb(string HID)
+ {
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+ var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_EnvironmentTestItem where HItemID= " + HID + " ", "h_v_Gy_EnvironmentTestItem");
+ 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)
@@ -677,6 +735,25 @@
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_MaintainLev where HItemID= " + HID + " ", "h_v_Gy_MaintainLev");
+ 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;
}
@@ -750,6 +827,31 @@
return new ApiResult<DataSet> { code = -1, msg = "涓嶅瓨鍦ㄥ鎴峰垎绫绘暟鎹�" };
return new ApiResult<DataSet> { code = 1, msg = "鏌ヨ鎴愬姛", data = dataSet };
}
+
+ /// <summary>
+ ///宸ヨ壓鍝佸弬鏁板垎绫绘牴鎹甶d鑾峰彇淇℃伅
+ /// </summary>
+ public static ApiResult<DataSet> GetGy_TechnologyType(string HID)
+ {
+ if (string.IsNullOrEmpty(HID))
+ return new ApiResult<DataSet> { code = -1, msg = "ID涓嶈兘涓虹┖" };
+ var dataSet = GetGy_TechnologyTypeDb(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 };
+ }
+
+ /// <summary>
+ ///宸ヨ壓鍝佸弬鏁板垎绫绘牴鎹甶d鑾峰彇淇℃伅璋冪敤鎸佷箙灞�
+ /// </summary>
+ public static DataSet GetGy_TechnologyTypeDb(string HID)
+ {
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+ var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_Technology where HItemID= " + HID + " ", "h_v_Gy_Technology");
+ return dataSet;
+ }
+
+
public static DataSet GetGy_CusTypeDb(string HID)
{
SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
--
Gitblit v1.9.1