From 0a7beb214741d32d8ee7700a354ec5dfbe9ff29e Mon Sep 17 00:00:00 2001
From: llj <132905093+newwwwwwtree@users.noreply.github.com>
Date: 星期四, 25 十二月 2025 11:33:44 +0800
Subject: [PATCH] 新增小卫自定义字段
---
WebAPI/Service/LuBaoSevice.cs | 62 ++++++++++++++++++++++++++++++
1 files changed, 61 insertions(+), 1 deletions(-)
diff --git a/WebAPI/Service/LuBaoSevice.cs b/WebAPI/Service/LuBaoSevice.cs
index ea59229..5a3021f 100644
--- a/WebAPI/Service/LuBaoSevice.cs
+++ b/WebAPI/Service/LuBaoSevice.cs
@@ -195,7 +195,28 @@
var dataSet = oCN.RunProcReturn("select top 1 * from h_v_IF_Edit_BadReasonList where HItemID= " + HID + " ", "h_v_IF_Edit_BadReasonList");
return dataSet;
}
-
+
+ /// <summary>
+ /// 鐧芥爣淇℃伅琛ㄦ牴鎹甶d鑾峰彇淇℃伅
+ /// </summary>
+ public static ApiResult<DataSet> GetSc_PackUnionBillBarCode_tempBillDetail(string HID)
+ {
+ if (string.IsNullOrEmpty(HID))
+ return new ApiResult<DataSet> { code = -1, msg = "ID涓嶈兘涓虹┖" };
+ var dataSet = GetSc_PackUnionBillBarCode_temp(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 GetSc_PackUnionBillBarCode_temp(string HID)
+ {
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+ var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sc_PackUnionBillBarCode_temp where HInterID= " + HID + " ", "h_v_Sc_PackUnionBillBarCode_temp");
+ return dataSet;
+ }
+
+
/// <summary>
/// 涓嶈壇鍚庢灉鏍规嵁id鑾峰彇淇℃伅
/// </summary>
@@ -663,6 +684,25 @@
/// <summary>
+ /// 璁惧鑺傛媿鏍规嵁id鑾峰彇淇℃伅
+ /// </summary>
+ public static ApiResult<DataSet> GetEqiupMaterWorkTimeDetail(string HID)
+ {
+ if (string.IsNullOrEmpty(HID))
+ return new ApiResult<DataSet> { code = -1, msg = "ID涓嶈兘涓虹┖" };
+ var dataSet = GetEqiupMaterWorkTimeDb(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 GetEqiupMaterWorkTimeDb(string HID)
+ {
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+ var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Sb_EqiupMaterWorkTimes where HItemID= " + HID + " ", "h_v_Sb_EqiupMaterWorkTimes");
+ return dataSet;
+ }
+
+ /// <summary>
/// 绠″緞鏍规嵁id鑾峰彇淇℃伅
/// </summary>
public static ApiResult<DataSet> GetGy_PiPeDetail(string HID)
@@ -1039,5 +1079,25 @@
return dataSet;
}
+
+ /// <summary>
+ /// 椤圭洰璐圭敤鏍规嵁id鑾峰彇淇℃伅
+ /// </summary>
+ public static ApiResult<DataSet> GetGy_ItemMoneyDetail(string HID)
+ {
+ if (string.IsNullOrEmpty(HID))
+ return new ApiResult<DataSet> { code = -1, msg = "ID涓嶈兘涓虹┖" };
+ var dataSet = GetGetGy_ItemMoneyDetailDb(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 GetGetGy_ItemMoneyDetailDb(string HID)
+ {
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+ var dataSet = oCN.RunProcReturn("select top 1 * from h_v_Gy_ItemMoney_1 where HItemID= " + HID + " ", "h_v_Gy_ItemMoney_1");
+ return dataSet;
+ }
+
}
}
\ No newline at end of file
--
Gitblit v1.9.1