From 7484a847d53a56c758b6125da2f2e2aa8f36bdfb Mon Sep 17 00:00:00 2001
From: zrg <z1873@LAPTOP-EAVL132E>
Date: 星期三, 03 十二月 2025 18:34:27 +0800
Subject: [PATCH] 1
---
WebTM/Vlog/webapi20220411.txt | 100 ++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 100 insertions(+), 0 deletions(-)
diff --git a/WebTM/Vlog/webapi20220411.txt b/WebTM/Vlog/webapi20220411.txt
index b408ea7..bd13eef 100644
--- a/WebTM/Vlog/webapi20220411.txt
+++ b/WebTM/Vlog/webapi20220411.txt
@@ -77,3 +77,103 @@
2022/4/11 16:54:58 鎵撳嵃sql:select HSourceBillNo 璁㈠崟鍙�,a.HMaterID,m.HName 鐗╂枡,m.HModel 鍨嬪彿,a.HQty 鏁伴噺,a.HBatchNo 鎵瑰彿,a.HBarCode 绠卞彿,a.HRemark 鍦烘櫙鍙� from Gy_BarCodeBill a left join Gy_Material m on a.HMaterID=m.HItemID where a.HItemID in ('5974')
2022/4/11 16:54:58 ReportDataSet:1
+
+2022/4/11 20:04:06 '1000630100090','1000630100091'
+
+2022/4/11 20:04:06 select convert(varchar,a.HDate ,23)鏃ユ湡,a.HBillNo 鍗曟嵁缂栧彿,M.HName 閿�鍞墿鏂欏悕绉�,c.HName 鏀惰揣鏂硅仈绯讳汉,b.HQty 閿�鍞暟閲�,u.HName 璐揣鍗曚綅
+ from Sc_ICMOBillMain a
+ left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
+ left join Gy_Material m on a.HMaterID=m.HItemID
+ left join Gy_Customer c on a.HCusID=c.HItemID
+ left join Gy_Unit u on a.HUnitID=u.HItemID
+ where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
+
+2022/4/11 20:04:06 鎵撳嵃sql:select convert(varchar,a.HDate ,23)鏃ユ湡,a.HBillNo 鍗曟嵁缂栧彿,M.HName 閿�鍞墿鏂欏悕绉�,c.HName 鏀惰揣鏂硅仈绯讳汉,b.HQty 閿�鍞暟閲�,u.HName 璐揣鍗曚綅
+ from Sc_ICMOBillMain a
+ left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
+ left join Gy_Material m on a.HMaterID=m.HItemID
+ left join Gy_Customer c on a.HCusID=c.HItemID
+ left join Gy_Unit u on a.HUnitID=u.HItemID
+ where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
+
+2022/4/11 20:04:06 ReportDataSet:2
+
+2022/4/11 20:04:41 '1000630100090','1000630100091'
+
+2022/4/11 20:04:41 select convert(varchar,a.HDate ,23)鏃ユ湡,a.HBillNo 鍗曟嵁缂栧彿,M.HName 閿�鍞墿鏂欏悕绉�,c.HName 鏀惰揣鏂硅仈绯讳汉,b.HQty 閿�鍞暟閲�,u.HName 璐揣鍗曚綅
+ from Sc_ICMOBillMain a
+ left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
+ left join Gy_Material m on a.HMaterID=m.HItemID
+ left join Gy_Customer c on a.HCusID=c.HItemID
+ left join Gy_Unit u on a.HUnitID=u.HItemID
+ where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
+
+2022/4/11 20:04:41 鎵撳嵃sql:select convert(varchar,a.HDate ,23)鏃ユ湡,a.HBillNo 鍗曟嵁缂栧彿,M.HName 閿�鍞墿鏂欏悕绉�,c.HName 鏀惰揣鏂硅仈绯讳汉,b.HQty 閿�鍞暟閲�,u.HName 璐揣鍗曚綅
+ from Sc_ICMOBillMain a
+ left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
+ left join Gy_Material m on a.HMaterID=m.HItemID
+ left join Gy_Customer c on a.HCusID=c.HItemID
+ left join Gy_Unit u on a.HUnitID=u.HItemID
+ where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
+
+2022/4/11 20:04:41 ReportDataSet:2
+
+2022/4/11 20:04:49 '1000630100090','1000630100091','1000630100098','1000630100095'
+
+2022/4/11 20:04:49 select convert(varchar,a.HDate ,23)鏃ユ湡,a.HBillNo 鍗曟嵁缂栧彿,M.HName 閿�鍞墿鏂欏悕绉�,c.HName 鏀惰揣鏂硅仈绯讳汉,b.HQty 閿�鍞暟閲�,u.HName 璐揣鍗曚綅
+ from Sc_ICMOBillMain a
+ left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
+ left join Gy_Material m on a.HMaterID=m.HItemID
+ left join Gy_Customer c on a.HCusID=c.HItemID
+ left join Gy_Unit u on a.HUnitID=u.HItemID
+ where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091','1000630100098','1000630100095')
+
+2022/4/11 20:04:49 鎵撳嵃sql:select convert(varchar,a.HDate ,23)鏃ユ湡,a.HBillNo 鍗曟嵁缂栧彿,M.HName 閿�鍞墿鏂欏悕绉�,c.HName 鏀惰揣鏂硅仈绯讳汉,b.HQty 閿�鍞暟閲�,u.HName 璐揣鍗曚綅
+ from Sc_ICMOBillMain a
+ left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
+ left join Gy_Material m on a.HMaterID=m.HItemID
+ left join Gy_Customer c on a.HCusID=c.HItemID
+ left join Gy_Unit u on a.HUnitID=u.HItemID
+ where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091','1000630100098','1000630100095')
+
+2022/4/11 20:04:49 ReportDataSet:4
+
+2022/4/11 20:06:36 '1000630100090','1000630100091'
+
+2022/4/11 20:06:36 select convert(varchar,a.HDate ,23)鏃ユ湡,a.HBillNo 鍗曟嵁缂栧彿,M.HName 閿�鍞墿鏂欏悕绉�,c.HName 鏀惰揣鏂硅仈绯讳汉,b.HQty 閿�鍞暟閲�,u.HName 璐揣鍗曚綅
+ from Sc_ICMOBillMain a
+ left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
+ left join Gy_Material m on a.HMaterID=m.HItemID
+ left join Gy_Customer c on a.HCusID=c.HItemID
+ left join Gy_Unit u on a.HUnitID=u.HItemID
+ where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
+
+2022/4/11 20:06:36 鎵撳嵃sql:select convert(varchar,a.HDate ,23)鏃ユ湡,a.HBillNo 鍗曟嵁缂栧彿,M.HName 閿�鍞墿鏂欏悕绉�,c.HName 鏀惰揣鏂硅仈绯讳汉,b.HQty 閿�鍞暟閲�,u.HName 璐揣鍗曚綅
+ from Sc_ICMOBillMain a
+ left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
+ left join Gy_Material m on a.HMaterID=m.HItemID
+ left join Gy_Customer c on a.HCusID=c.HItemID
+ left join Gy_Unit u on a.HUnitID=u.HItemID
+ where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
+
+2022/4/11 20:06:36 ReportDataSet:2
+
+2022/4/11 20:46:02 '1000630100090','1000630100091'
+
+2022/4/11 20:46:02 select convert(varchar,a.HDate ,23)鏃ユ湡,a.HBillNo 鍗曟嵁缂栧彿,M.HName 閿�鍞墿鏂欏悕绉�,c.HName 鏀惰揣鏂硅仈绯讳汉,b.HQty 閿�鍞暟閲�,u.HName 璐揣鍗曚綅
+ from Sc_ICMOBillMain a
+ left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
+ left join Gy_Material m on a.HMaterID=m.HItemID
+ left join Gy_Customer c on a.HCusID=c.HItemID
+ left join Gy_Unit u on a.HUnitID=u.HItemID
+ where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
+
+2022/4/11 20:46:02 鎵撳嵃sql:select convert(varchar,a.HDate ,23)鏃ユ湡,a.HBillNo 鍗曟嵁缂栧彿,M.HName 閿�鍞墿鏂欏悕绉�,c.HName 鏀惰揣鏂硅仈绯讳汉,b.HQty 閿�鍞暟閲�,u.HName 璐揣鍗曚綅
+ from Sc_ICMOBillMain a
+ left join Sc_ICMOBillSub b on a.HInterID=b.HInterID
+ left join Gy_Material m on a.HMaterID=m.HItemID
+ left join Gy_Customer c on a.HCusID=c.HItemID
+ left join Gy_Unit u on a.HUnitID=u.HItemID
+ where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
+
+2022/4/11 20:46:04 ReportDataSet:2
--
Gitblit v1.9.1