22

schangxiang@126.com

2024-12-03 90344bc24b7828091281f069e46d802642e7e0d8

 LA24030_LuLiPackageLine_Print/LA24030_LuLiPackageLine_PrintService/WindowsFormsApplication1/Form1.cs

@@ -7,6 +7,7 @@
using iWareSql;
using iWareSql.DataAccess;
using iWareSql.MyDbContext;
using iWareSql.WmsDBModel;
using System;
using System.Collections.Generic;
using System.Data;
@@ -311,12 +312,51 @@
                    Dictionary<string, object> data = new Dictionary<string, object>();
                    if (printClassifyEnum == PrintClassifyEnum.包装条码)
                    {
                        //data.Add("bar", item.SNCode);
                        //data.Add("material", item.MaterialCode ?? "" + "/" + item.MaterialName ?? "");
                        //data.Add("supplier", item.SupplierName ?? "");
                        //data.Add("unit", item.MaterialUnit ?? "");
                        //data.Add("qty", item.Quantity);
                        //data.Add("date", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
                        data.Add("Info4", item.Info4 ?? "");//合同单号
                        data.Add("Info5", item.Info5 ?? "");//生产单号
                        data.Add("Info6", "第" + (item.Info6 ?? "") + "包");//第几包
                        data.Add("bar", item.PackageCode ?? "");//二维码（包号）
                        data.Add("Info7", item.Info7 ?? "");//经销店
                        data.Add("Info8", item.Info8 ?? "");//产品
                        data.Add("Info9", item.PackageCode ?? "");//包装编码
                        data.Add("Info10", item.Info10 ?? "");//客户名称
                        data.Add("Info11", item.Info11 ?? "");//自提or发货 
                        data.Add("Info12", "包装明细 部件总数" + item.Info12 ?? "");//部件明细
                        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.已合包).ToList();
                        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);
                        int i = 0;
                        foreach (var g in gg)
                        {
                            i++;
                            data.Add("detail_" + i, g.Key ?? "");//部件名称
                            data.Add("detail_" + i + "_length", g.ToList().First().Info16 ?? "");//部件尺寸
                            data.Add("detail_" + i + "_number", g.ToList().Count());//部件数量
                        }
                        for (int p = (i + 1); p <= 6; p++)
                        {
                            data.Add("detail_" + p, "");//部件名称
                            data.Add("detail_" + p + "_length", "");//部件尺寸
                            data.Add("detail_" + p + "_number", "");//部件数量
                        }
                    }
                    else
                    {