From f4c4c53e2546a20afbfa5a2346cfc4d1330ee83f Mon Sep 17 00:00:00 2001
From: wbc <2597324127@qq.com>
Date: 星期六, 08 十一月 2025 18:37:26 +0800
Subject: [PATCH] 托板码打印

---
 DevApp/Gs.DevApp/UserControl/CopyXls.cs |   68 ++++++++++++++++++++++++++++++++++
 1 files changed, 68 insertions(+), 0 deletions(-)

diff --git a/DevApp/Gs.DevApp/UserControl/CopyXls.cs b/DevApp/Gs.DevApp/UserControl/CopyXls.cs
index bc48303..27f68e4 100644
--- a/DevApp/Gs.DevApp/UserControl/CopyXls.cs
+++ b/DevApp/Gs.DevApp/UserControl/CopyXls.cs
@@ -59,6 +59,12 @@
                             SetCellText(spreadsheetControl1.ActiveWorksheet, "C1", "鐢宠澶囨敞", true);
                             //SetCellText(spreadsheetControl1.ActiveWorksheet, "D1", "涓嶈壇绫诲瀷", true);
                             break;
+                        case "鎵归噺鎺掍骇":
+                            SetCellText(spreadsheetControl1.ActiveWorksheet, "A1", "浠诲姟鍗曞彿", true);
+                            SetCellText(spreadsheetControl1.ActiveWorksheet, "B1", "鏈鎺掍骇鏁伴噺", true);
+                            SetCellText(spreadsheetControl1.ActiveWorksheet, "C1", "鐢熶骇绾夸綋", true);
+                            //SetCellText(spreadsheetControl1.ActiveWorksheet, "D1", "涓嶈壇绫诲瀷", true);
+                            break;
                     }
                 }
                 else
@@ -247,6 +253,68 @@
                     }
                     #endregion
                     break;
+                case "鎵归噺鎺掍骇":
+                    #region MyRegion
+                    {
+                        for (int row = 2; row <= rowsCount; row++)
+                        {
+                            string workNo = spreadsheetControl1.ActiveWorksheet.Cells["A" + row.ToString()].Value.ToString().Trim();
+                            string pc_qty = spreadsheetControl1.ActiveWorksheet.Cells["B" + row.ToString()].Value.ToString().Trim();
+                            string line_no = spreadsheetControl1.ActiveWorksheet.Cells["C" + row.ToString()].Value.ToString().Trim();
+                            
+
+
+                            
+                            var _obj = new
+                            {
+                                workNo = workNo,
+                                line_no = line_no,
+                                orgId = this.orgId,
+                            };
+                            try
+                            {
+                                var strJson = UtilityHelper.HttpPost("", "WomcaaManager/GetModelByOrg", JsonConvert.SerializeObject(_obj));
+                                var _rtn = UtilityHelper.ReturnToDynamic(strJson);
+                                if (_rtn.rtnCode > 0)
+                                {
+                                    var dy = _rtn.rtnData;
+                                    list.Add(new
+                                    {
+                                        caaid  = dy.caaGuid,
+                                        workno = workNo,
+                                        itemNo = dy.itemNo,
+                                        itemName = dy.daa003,
+                                        itemModel = dy.daa004,
+                                        sclx      = dy.daa025,
+                                        yjkg      = dy.mesStartProd,
+                                        yjwg      = dy.mesEndProd,
+                                        Workqty   = dy.caa012,
+                                        unit_name = dy.fname,
+                                        yp        = dy.yp,
+                                        wp        = dy.daa008,
+                                        pc_qty    = pc_qty,
+                                        line_no   = line_no,
+                                        pbill_no  = dy.daa014,
+                                        SALE_ORDER_NO = dy.caa015,
+                                        lineid   = dy.lineid
+                                       
+                                    });
+                                }
+                                else
+                                {
+                                    MsgHelper.ShowError("澶嶅埗澶辫触锛氥��" + workNo + "銆戝彲鑳戒笉瀛樺湪,璇锋鏌ュ悗閲嶈瘯锛�");
+                                    return;
+                                }
+                            }
+                            catch (Exception ex)
+                            {
+                                MsgHelper.ShowError("澶嶅埗澶辫触锛氥��" + workNo + "銆戝彂鐢熼敊璇�,璇锋鏌ュ悗閲嶈瘯锛�" + ex.Message);
+                                return;
+                            }
+                        }
+                    }
+                    #endregion
+                    break;
             }
            
             UpdateParent?.Invoke(this,

--
Gitblit v1.9.3