打印

zzr99

2022-04-13 1cb610cf44a5dc6339b6deb321a581252ce9f797

 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