From afb06a057c840e5b5394b5526a462df23b9cbeea Mon Sep 17 00:00:00 2001
From: jingh <jingh@LAPTOP-I53VDLOO>
Date: 星期五, 01 十月 2021 11:23:58 +0800
Subject: [PATCH] 新增模具缓存列表调用方法
---
CLOUDWEB/WebService1.asmx.cs | 59 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 59 insertions(+), 0 deletions(-)
diff --git a/CLOUDWEB/WebService1.asmx.cs b/CLOUDWEB/WebService1.asmx.cs
index a479cf9..64fc40a 100644
--- a/CLOUDWEB/WebService1.asmx.cs
+++ b/CLOUDWEB/WebService1.asmx.cs
@@ -33194,6 +33194,65 @@
}
}
+ #region 妯″叿鍗曟嵁鍒楄〃澶勭悊鏂规硶
+
+ //缂撳瓨鍒楄〃鐣岄潰锛岄�夋嫨缂栬緫鏃讹紝鍒ゆ柇鎵�閫夊崟鎹槸鍚﹀瓨鍦ㄥ凡涓婁紶璁板綍
+ [WebMethod]
+ public bool MouldTempList_Modify(Int64 sHInterID, string sHBillNo, string sHBillType, ref string sErrMsg)
+ {
+ SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
+ DataSet Ds = oCn.RunProcReturn("exec h_p_WMS_MouldTempList_Modify " + sHInterID + ",'" + sHBillNo + "','" + sHBillType + "'", "h_p_WMS_MouldTempList_Modify");
+ if (Ds == null || Ds.Tables[0].Rows.Count == 0)
+ {
+ sErrMsg = "妯″叿缂撳瓨鍒楄〃缂栬緫鍓嶅垽鏂け璐ワ紒";
+ return false;
+ }
+ if (DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0][0]) == 0)
+ {
+ return true;
+ }
+ else
+ {
+ sErrMsg = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]);
+ return false;
+ }
+ }
+
+ //缂撳瓨鍒楄〃鐣岄潰锛岃繑鍥炵紦瀛樺垪琛ㄤ俊鎭�
+ [WebMethod]
+ public DataSet GetSc_MouldStockBillMain_TempList(string sHBillType, string sHMaker, Int64 sHOWNERID)
+ {
+ SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
+ DataSet Ds = oCn.RunProcReturn("exec h_p_Sc_GetMouldStockBillMain_TempList '" + sHBillType + "','" + sHMaker + "'," + sHOWNERID.ToString(), "h_p_Sc_GetMouldStockBillMain_TempList");
+ if (Ds == null || Ds.Tables[0].Rows.Count == 0)
+ {
+ return null;
+ }
+ else
+ {
+ return Ds;
+ }
+ }
+
+ //缂撳瓨鍒楄〃鐣岄潰锛屽垹闄ょ紦瀛樺垪琛ㄥ崟鎹�
+ [WebMethod]
+ public bool DeleteMouldBillList(Int64 HInterID, ref string sErrMsg)
+ {
+ SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
+ try
+ {
+ oCn.RunProc("Delete from Sc_MouldStockBillMain_Temp where HInterID=" + HInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);
+ return true;
+ }
+ catch (Exception e)
+ {
+ sErrMsg = "鍒犻櫎澶辫触锛�" + e.Message;
+ return false;
+ }
+ }
+
+ #endregion
+
#endregion
--
Gitblit v1.9.1