| | |
| | | using iWareSql; |
| | | using iWareSql.DataAccess; |
| | | using iWareSql.MyDbContext; |
| | | using iWareSql.WmsDBModel; |
| | | using System; |
| | | using System.Collections.Generic; |
| | | using System.Data; |
| | |
| | | data.Add("Info13", item.Info13 ?? "");//当前包面积 |
| | | data.Add("printTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss")); |
| | | |
| | | var finsiList = mycontext.mes_package_gather.Where(x => x.Info5 == item.Info5 && x.UpiStatus >= (int)UpiStatusEnum.已合包); |
| | | double leijisaomiaomj = 0; |
| | | foreach (var aa in finsiList) |
| | | { |
| | | if (!string.IsNullOrEmpty(aa.Info13)) |
| | | { |
| | | leijisaomiaomj += Convert.ToDouble(aa.Info13); |
| | | } |
| | | } |
| | | if (!string.IsNullOrEmpty(item.Info13)) |
| | | { |
| | | leijisaomiaomj += Convert.ToDouble(item.Info13); |
| | | } |
| | | data.Add("leijisaomiaomj", leijisaomiaomj);//累计扫描面积 |
| | | |
| | | //查询下 包数据 |
| | | var mylist = mycontext.mes_batchOrderUPI_new.Where(x => x.PackageCode == item.PackageCode).ToList(); |
| | | var gg = mylist.GroupBy(x => x.DetailName); |