From 5c25ab3f079245bd936e27b2628629dadd7efe29 Mon Sep 17 00:00:00 2001
From: yxj <1qaz@123>
Date: 星期五, 24 十二月 2021 21:14:59 +0800
Subject: [PATCH] 新增盘点方案基础资料获取调用方法；新增模治具盘点单模块，扫描模治具条码调用方法
---
CLOUDWEB/WebService1.asmx.cs | 46 ++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 46 insertions(+), 0 deletions(-)
diff --git a/CLOUDWEB/WebService1.asmx.cs b/CLOUDWEB/WebService1.asmx.cs
index 0f48f65..da3a3ec 100644
--- a/CLOUDWEB/WebService1.asmx.cs
+++ b/CLOUDWEB/WebService1.asmx.cs
@@ -135,6 +135,24 @@
return dal.GetList(sWhere);
}
+ //杩斿洖鐩樼偣鏂规鍒楄〃 鍚屾璧勬枡
+ [WebMethod]
+ public DataSet GetStockCheckItemList(string sWhere, ref string sErr)
+ {
+ DataSet ds;
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+ ds = oCN.RunProcReturn("select HItemID,HNumber,HName from Gy_StockCheckItem"+ sWhere, "Gy_StockCheckItem");
+ if (ds == null && ds.Tables[0].Rows.Count == 0)
+ {
+ sErr = "娌℃湁杩斿洖浠讳綍鏁版嵁锛�";
+ return null;
+ }
+ else
+ {
+ return ds;
+ }
+ }
+
//鏍规嵁浠ｇ爜杩斿洖鐢熶骇璧勬簮淇℃伅
[WebMethod]
public Model.ClsGy_Source_Model GetSourceInfoByNumber(string sWhere, ref string sErr)
@@ -33682,6 +33700,34 @@
#endregion
+ #region 鐩樼偣鍗曟ā鍧� 鎵弿妯℃不鍏锋潯鐮�
+ [WebMethod]
+ //鎵弿妯℃不鍏锋潯鐮佸瓨鍏ユā娌诲叿鏉＄爜涓存椂琛紝鐩樼偣鍗曚笓鐢�
+ public bool Get_CheckTypeByMouldBarCode_ProdCheckStock(string sBarCode, Int64 HBillID, string HBillType, string HBillNo, Int64 HWhID, Int64 HSPID, Int64 HStockCheckItemID, string HStockCheckNumber, Int64 HCorrespondentTypeID, Int64 HCorrespondentID, string HMaker, Int64 HOWNERID, ref string sErrMsg)
+ {
+ SQLHelper.ClsCN oCN = new SQLHelper.ClsCN();
+ DataSet ds = oCN.RunProcReturn("exec h_p_WMS_AddMouldBarCode_ProdCheckStock '" + sBarCode + "'," + HBillID.ToString() + ",'" + HBillNo + "','" + HBillType + "'," + HWhID.ToString() + "," + HSPID.ToString() + "," + HStockCheckItemID.ToString() + ",'" + HStockCheckNumber + "'," + HCorrespondentTypeID.ToString() + "," + HCorrespondentID.ToString() + ",'" + HMaker + "'," + HOWNERID.ToString(), "h_p_WMS_AddMouldBarCode_ProdCheckStock");
+ if (ds == null || ds.Tables[0].Rows.Count == 0)
+ {
+ sErrMsg = "灏嗘ā娌诲叿淇℃伅鍐欏叆妯℃不鍏峰嚭鍏ュ簱涓存椂琛ㄥけ璐ワ紒";
+ return false;
+ }
+ else
+ {
+ 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;
+ }
+ }
+ }
+
+ #endregion
+
//鏄剧ず妯℃不鍏峰垪琛ㄤ俊鎭�
[WebMethod]
public DataSet GetMouldBillEntry_TmpList(long HInterID, string HBillNo, string HBillType, ref string sErrMsg)
--
Gitblit v1.9.1