生产汇报单新增页面自动带出计量单位；过滤方案保存

yusijie

2024-01-11 4f15da2cf64297b73dde69f12a3bb172e8c62ec8

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
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