From cbeded9125b3c40c607a336e5eb27884873c3fd3 Mon Sep 17 00:00:00 2001
From: wtt <1985833171@qq.com>
Date: 星期二, 30 十二月 2025 16:02:23 +0800
Subject: [PATCH] 海诚钉钉接口调整
---
CLOUDWEB/WebService1.asmx.cs | 32 +++++++++++++++++++++++++++++---
1 files changed, 29 insertions(+), 3 deletions(-)
diff --git a/CLOUDWEB/WebService1.asmx.cs b/CLOUDWEB/WebService1.asmx.cs
index 67e81e9..de2d92d 100644
--- a/CLOUDWEB/WebService1.asmx.cs
+++ b/CLOUDWEB/WebService1.asmx.cs
@@ -31916,9 +31916,35 @@
oCn.BeginTran();
- DataSet Ds = oCn.RunProcReturn("select org.HNumber FStockOrgId,gd.HNumber FDeptId,deptOrg.HNumber AS FDeptOrgNumber ,* from Sc_MouldStockBillMain ma LEFT JOIN Xt_ORGANIZATIONS org on ma.HStockOrgID=org.HItemID LEFT JOIN Gy_Department gd on ma.HDeptID=gd.HItemID LEFT JOIN Xt_ORGANIZATIONS deptOrg ON gd.HCREATEORGID = deptOrg.HItemID where HInterID=" + oMain.HInterID, "Sc_MouldStockBillMain");
- DataSet dds = oCn.RunProcReturn("select w.hnumber FStockId,gu.hnumber FUnitID,HEntryID FEntryID,gm.hnumber FMaterialId,* from Sc_MouldStockBillSub sa LEFT JOIN Gy_MouldFileMain gmf on sa.hmaterid=gmf.HInterID LEFT JOIN Gy_Material gm on gmf.HMaterID=gm.hitemid LEFT JOIN Gy_Unit gu on sa.hunitid=gu.hitemid left join gy_Warehouse w with(nolock) on sa.HWhID=w.HItemID where sa.HInterID=" + oMain.HInterID, "Sc_MouldStockBillSub");
-
+ string mainSql = @"
+ SELECT
+ org.HNumber FStockOrgId,
+ gd.HNumber FDeptId,
+ deptOrg.HNumber AS FDeptOrgNumber,
+ ma.*
+ FROM Sc_MouldStockBillMain ma WITH(NOLOCK)
+ LEFT JOIN Xt_ORGANIZATIONS org WITH(NOLOCK) on ma.HStockOrgID=org.HItemID
+ LEFT JOIN Gy_Department gd WITH(NOLOCK) on ma.HDeptID=gd.HItemID
+ LEFT JOIN Xt_ORGANIZATIONS deptOrg WITH(NOLOCK) ON gd.HCREATEORGID = deptOrg.HItemID
+ WHERE HInterID = " + oMain.HInterID;
+
+ string detailSql = @"
+ SELECT
+ w.hnumber FStockId,
+ gu.hnumber FUnitID,
+ HEntryID FEntryID,
+ gm.hnumber FMaterialId,
+ sa.*
+ FROM Sc_MouldStockBillSub sa WITH(NOLOCK)
+ LEFT JOIN Gy_MouldFileMain gmf WITH(NOLOCK) on sa.hmaterid=gmf.HInterID
+ LEFT JOIN Gy_Material gm WITH(NOLOCK) on gmf.HMaterID=gm.hitemid
+ LEFT JOIN Gy_Unit gu WITH(NOLOCK) on sa.hunitid=gu.hitemid
+ LEFT JOIN gy_Warehouse w WITH(NOLOCK) on sa.HWhID=w.HItemID
+ WHERE sa.HInterID = " + oMain.HInterID;
+
+ DataSet Ds = oCn.RunProcReturn(mainSql, "Sc_MouldStockBillMain");
+ DataSet dds = oCn.RunProcReturn(detailSql, "Sc_MouldStockBillSub");
+
if (Ds == null || Ds.Tables[0].Rows.Count == 0)
{
sErrMsg = "鑾峰彇瀛愯〃淇℃伅澶辫触锛�";
--
Gitblit v1.9.1