工单导出

lu

2025-10-09 94fea9bf84c3b53279ab96bf4a5feb386b40739c

 DevApp/Gs.DevApp/DevFrm/WOM/Frm_Womdaa.cs

@@ -9,8 +9,10 @@
using Newtonsoft.Json.Linq;
using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Drawing;
using System.Net;
using System.Threading.Tasks;
using System.Windows.Forms;

@@ -256,6 +258,62 @@
                };
                frm.ShowDialog();
            };
            //导出备料单身
            btnXls.Click += (s, e) =>
            {
                if (string.IsNullOrEmpty(lbGuid.Text.Trim()))
                {
                    MsgHelper.ShowError("请先选择你导出的工单！");
                    return;
                }
                if (!MsgHelper.AskQuestion("你选择了【" + txt_daa001.Text.Trim() + "】，确定导出吗？"))
                    return;
                using (FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog())
                {
                    folderBrowserDialog.Description = "选择导出文件的保存路径";
                    DialogResult dialogResult = folderBrowserDialog.ShowDialog();
                    if (dialogResult == DialogResult.OK)
                    {
                        string _folder = folderBrowserDialog.SelectedPath;
                        var _params = new
                        {
                            inQueryWhere = lbGuid.Text.Trim(),//主建
                            inFid = "",
                            inP1 = "",
                            inP2 = "",
                            inP3 = "",
                            inP4 = ""
                        };
                        var _obj = new Gs.DevApp.Entity.XlsOutModel("xlsOutDaa", "", "", "", _params);
                        try
                        {
                            string strJson = UtilityHelper.HttpPost("", "XlsInOut/XlsOutView_NEW", JsonConvert.SerializeObject(_obj));
                            ReturnModel<dynamic> _rtn = ToolBox.UtilityHelper.ReturnToDynamic(strJson);
                            if (_rtn.rtnCode > 0)
                            {
                                string _file = _rtn.rtnData.fileUrl.ToString();
                                string _folderName = _folder + "\\" + _file.Replace("down/", "");
                                string _url = ConfigurationManager.AppSettings["WebApiUrl"].ToString() + _file;
                                using (WebClient client = new WebClient())
                                {
                                    client.DownloadFile(_url, _folderName);
                                }
                                var frm = new Gs.DevApp.DevFrm.QC.Xls(_folderName);
                                frm.ShowDialog();
                            }
                            else
                            {
                                ToolBox.MsgHelper.ShowError("提示：" + _rtn.rtnMsg);
                            }
                        }
                        catch (Exception ex)
                        {
                            ToolBox.MsgHelper.ShowError("提示：" + ex.Message);
                        }
                    }
                }

            };
        }

        private void GridView1_ColumnFilterChanged(object sender, EventArgs e)