From e4a34bc16ab46d4419133999eb9c939572f93b74 Mon Sep 17 00:00:00 2001
From: yanxiaojun <Administrator@USER-20210208XY>
Date: 星期三, 06 十月 2021 04:34:08 +0800
Subject: [PATCH] 缓存列表编辑返回界面表头信息获取调用方法新增，上传生成模具出入库单有源单关联数量回填
---
CLOUDWEB/WebService1.asmx.cs | 50 +++++++++++++++++++++++++++++++++-----------------
1 files changed, 33 insertions(+), 17 deletions(-)
diff --git a/CLOUDWEB/WebService1.asmx.cs b/CLOUDWEB/WebService1.asmx.cs
index 4a61a5f..c44182d 100644
--- a/CLOUDWEB/WebService1.asmx.cs
+++ b/CLOUDWEB/WebService1.asmx.cs
@@ -33233,6 +33233,23 @@
return DS;
}
+ //鍒犻櫎妯℃不鍏峰垪琛ㄤ腑閫変腑琛岃褰�
+ [WebMethod]
+ public bool set_DelSc_MouldStockBillMain_Temp(long HInterID, long HMouldInterID, string sHBillType, ref string sErrMsg)
+ {
+ SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
+ try
+ {
+ oCn.RunProc("Delete from Sc_MouldStockBillMain_Temp where HInterID=" + HInterID.ToString() + " and HBillType='" + sHBillType + "' and HMouldID=" + HMouldInterID.ToString() + " and HQty<>0", ref DBUtility.ClsPub.sExeReturnInfo);
+ return true;
+ }
+ catch (Exception e)
+ {
+ sErrMsg = "鍒犻櫎妯℃不鍏峰嚭鍏ュ簱涓存椂琛ㄨ褰曞け璐ワ紒" + e.Message;
+ return false;
+ }
+ }
+
//涓婁紶鐢熸垚妯″叿鍑哄叆搴撳崟
[WebMethod]
public bool set_SaveMouldStockBill_New(Model.ClsSc_MouldStockBillMain oMain, string sHSourceType, ref string sErrMsg)
@@ -33259,6 +33276,12 @@
oCn.BeginTran();
string HMouldBillType = oMain.HBillType;
oCn.RunProc("EXEC h_p_Sc_MouldStockBill_Insert_New " + oMain.HInterID.ToString() + ",'" + oMain.HBillType + "','" + HMouldBillType + "'," + oMain.HSupID.ToString() + "," + oMain.HKeeperID.ToString() + "," + oMain.HSecManagerID.ToString() + "," + oMain.HDeptID.ToString() + "," + oMain.HCorrespondentTypeID.ToString());
+ //鏇存柊鍏宠仈鏁伴噺
+ if (oMain.HBillType == "3841" && sHSourceType == "3840")
+ {
+ //鍣ㄥ叿鍒嗘璋冨叆鍗曪紝婧愬崟锛氬櫒鍏峰垎姝ヨ皟鍑哄崟
+ oCn.RunProc("exec h_p_Sc_UpDateMouldMoveStockStepOutRelation_Add " + oMain.HInterID.ToString());
+ }
oCn.Commit();
return true;
}
@@ -33270,7 +33293,7 @@
}
}
- #region 妯″叿鍗曟嵁鍒楄〃澶勭悊鏂规硶
+ #region 妯″叿缂撳瓨鍒楄〃澶勭悊鏂规硶
//缂撳瓨鍒楄〃鐣岄潰锛岄�夋嫨缂栬緫鏃讹紝鍒ゆ柇鎵�閫夊崟鎹槸鍚﹀瓨鍦ㄥ凡涓婁紶璁板綍
[WebMethod]
@@ -33292,6 +33315,15 @@
sErrMsg = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRemark"]);
return false;
}
+ }
+
+ //缂撳瓨鍒楄〃鐣岄潰锛岃繑鍥炵紦瀛樿〃澶翠俊鎭�
+ [WebMethod]
+ public DataSet GetMouldSource(string HBillType, string HSourceBillNo, string HSourceType, ref string sErrMsg)
+ {
+ SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
+ DataSet DS = oCn.RunProcReturn("exec h_p_Sc_MouldSourceList '" + HBillType.ToString() + "','" + HSourceBillNo + "','" + HSourceType + "'", "h_p_Sc_MouldSourceList");
+ return DS;
}
//缂撳瓨鍒楄〃鐣岄潰锛岃繑鍥炵紦瀛樺垪琛ㄤ俊鎭�
@@ -33382,22 +33414,6 @@
return DS;
}
- //鍒犻櫎妯℃不鍏峰垪琛ㄤ腑閫変腑琛岃褰�
- [WebMethod]
- public bool set_DelSc_MouldStockBillMain_Temp(long HInterID, long HMouldInterID, string sHBillType, ref string sErrMsg)
- {
- SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
- try
- {
- oCn.RunProc("Delete from Sc_MouldStockBillMain_Temp where HInterID=" + HInterID.ToString() + " and HBillType='" + sHBillType + "' and HMouldID=" + HMouldInterID.ToString(), ref DBUtility.ClsPub.sExeReturnInfo);
- return true;
- }
- catch (Exception e)
- {
- sErrMsg = "鍒犻櫎妯℃不鍏峰嚭鍏ュ簱涓存椂琛ㄨ褰曞け璐ワ紒" + e.Message;
- return false;
- }
- }
#endregion
--
Gitblit v1.9.1