From 7861d012b84104a33099fdd3b96560e1ccbffdf2 Mon Sep 17 00:00:00 2001
From: yangle <admin@YINMOU>
Date: 星期一, 24 七月 2023 13:36:05 +0800
Subject: [PATCH] Merge branch 'master' of http://101.37.171.70:10101/r/MESWMS-LayUI
---
WebTM/Vlog/webapi20220411.txt | 160 +++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 160 insertions(+), 0 deletions(-)
diff --git a/WebTM/Vlog/webapi20220411.txt b/WebTM/Vlog/webapi20220411.txt
index bab21dc..bd13eef 100644
--- a/WebTM/Vlog/webapi20220411.txt
+++ b/WebTM/Vlog/webapi20220411.txt
@@ -17,3 +17,163 @@
where convert(varchar(50),a.HInterID)+ Right('000000'+convert(varchar(50),b.HEntryID),7) in ('1000630100090','1000630100091')
2022/4/11 15:03:20 ReportDataSet:2
+
+2022/4/11 15:53:03 鎵撳嵃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=6146
+
+2022/4/11 15:53:03 ReportDataSet:1
+
+2022/4/11 15:54:24 鎵撳嵃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=6147
+
+2022/4/11 15:54:24 ReportDataSet:1
+
+2022/4/11 15:54:34 鎵撳嵃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=6147
+
+2022/4/11 15:54:34 ReportDataSet:1
+
+2022/4/11 15:56:05 鎵撳嵃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=6147
+
+2022/4/11 15:56:05 ReportDataSet:1
+
+2022/4/11 15:58:23 鎵撳嵃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=6147
+
+2022/4/11 15:58:23 ReportDataSet:1
+
+2022/4/11 16:00:17 鎵撳嵃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=6100
+
+2022/4/11 16:00:17 ReportDataSet:1
+
+2022/4/11 16:00:53 鎵撳嵃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=5969
+
+2022/4/11 16:00:53 ReportDataSet:1
+
+2022/4/11 16:49:01 鎵撳嵃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=6146
+
+2022/4/11 16:49:01 ReportDataSet:1
+
+2022/4/11 16:49:02 鎵撳嵃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=6147
+
+2022/4/11 16:49:02 ReportDataSet:1
+
+2022/4/11 16:49:57 鎵撳嵃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=5969
+
+2022/4/11 16:49:57 ReportDataSet:1
+
+2022/4/11 16:49:57 鎵撳嵃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=5970
+
+2022/4/11 16:49:57 ReportDataSet:1
+
+2022/4/11 16:50:47 鎵撳嵃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=5970
+
+2022/4/11 16:50:47 ReportDataSet:1
+
+2022/4/11 16:50:47 鎵撳嵃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=5971
+
+2022/4/11 16:50:47 ReportDataSet:1
+
+2022/4/11 16:54:16 鎵撳嵃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','5973')
+
+2022/4/11 16:54:16 ReportDataSet:2
+
+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