编辑 | blame | 历史 | 原始文档
2022/4/12 10:56:09 '1000630100090','1000630100091'

2022/4/12 10:56:09 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/12 10:56:09 打印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/12 10:56:09 ReportDataSet:2

2022/4/12 15:14:08 '1000630100090','1000630100091'

2022/4/12 15:14:08 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/12 15:14:08 打印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/12 15:14:08 ReportDataSet:2