From 78ca95fc34f77a2f5084d767ff8327ff2649046e Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期二, 16 七月 2024 16:46:10 +0800
Subject: [PATCH] 1
---
CLOUDWEB/WebService1.asmx.cs | 39 ++++++++++++++++++++-------------------
1 files changed, 20 insertions(+), 19 deletions(-)
diff --git a/CLOUDWEB/WebService1.asmx.cs b/CLOUDWEB/WebService1.asmx.cs
index e073faa..b1e9307 100644
--- a/CLOUDWEB/WebService1.asmx.cs
+++ b/CLOUDWEB/WebService1.asmx.cs
@@ -52556,28 +52556,10 @@
HSupIDs = ds.Tables[0].Rows[0]["HItemID"].ToString();
}
- string HSourceInterIDs = "0";
- string HSourceEntryIDs = "0";
string HSourceBillNos = "0";
- string HUnitIDs = "0";
- //鏌ヨ閲囪喘璁㈠崟
- ds = oCn.RunProcReturn(@"select a.HInterID,b.HEntryID,a.HBillNo,b.HUnitID from Cg_POOrderBillMain a with(nolock) inner join Cg_POOrderBillSub b with(nolock) on a.HInterID = b.HInterID where HBillNo='" + str[3] + "' and b.HMaterID=" + HMaterIDs, "Cg_POOrderBillMain");
- if (ds.Tables[0].Rows.Count == 0)
- {
- //sErrMsg = "鏉＄爜瑙ｆ瀽澶辫触,璇风‘璁ゆ潯鐮侀噰璐鍗曟槸鍚︽纭�!";
- //return false;
- }
- else
- {
- HSourceInterIDs = ds.Tables[0].Rows[0]["HInterID"].ToString();
- HSourceEntryIDs = ds.Tables[0].Rows[0]["HEntryID"].ToString();
- HSourceBillNos = ds.Tables[0].Rows[0]["HBillNo"].ToString();
- HUnitIDs = ds.Tables[0].Rows[0]["HUnitID"].ToString();
- }
-
string HInnerBillNos = "";
//鏌ヨ鍐呴儴閲囪喘璁㈠崟鍙�
- ds = oCn.RunProcReturn(@" select * from h_v_IF_POInStockList where 閲囪喘璁㈠崟鍙�= '" + str[3] + "' ", "h_v_IF_POInStockList");
+ ds = oCn.RunProcReturn(@" select * from h_v_IF_POInStockList where 鍐呴儴閲囪喘璁㈠崟鍙�= '" + str[3] + "' ", "h_v_IF_POInStockList");
if (ds.Tables[0].Rows.Count == 0)
{
HInnerBillNos = str[3];
@@ -52588,8 +52570,27 @@
else
{
HInnerBillNos = ds.Tables[0].Rows[0]["鍐呴儴閲囪喘璁㈠崟鍙�"].ToString();
+ HSourceBillNos = ds.Tables[0].Rows[0]["閲囪喘璁㈠崟鍙�"].ToString();
}
+ string HSourceInterIDs = "0";
+ string HSourceEntryIDs = "0";
+ string HUnitIDs = "0";
+ //鏌ヨ閲囪喘璁㈠崟
+ ds = oCn.RunProcReturn(@"select a.HInterID,b.HEntryID,a.HBillNo,b.HUnitID from Cg_POOrderBillMain a with(nolock) inner join Cg_POOrderBillSub b with(nolock) on a.HInterID = b.HInterID where HBillNo='" + HSourceBillNos + "' and b.HMaterID=" + HMaterIDs, "Cg_POOrderBillMain");
+ if (ds.Tables[0].Rows.Count == 0)
+ {
+ //sErrMsg = "鏉＄爜瑙ｆ瀽澶辫触,璇风‘璁ゆ潯鐮侀噰璐鍗曟槸鍚︽纭�!";
+ //return false;
+ }
+ else
+ {
+ HSourceInterIDs = ds.Tables[0].Rows[0]["HInterID"].ToString();
+ HSourceEntryIDs = ds.Tables[0].Rows[0]["HEntryID"].ToString();
+ HUnitIDs = ds.Tables[0].Rows[0]["HUnitID"].ToString();
+ }
+
+
if (HQty == 0)
{
HQty = double.Parse(str[6]);
--
Gitblit v1.9.1