托板码打印

wbc

2025-11-08 f4c4c53e2546a20afbfa5a2346cfc4d1330ee83f

 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,