排产工单搜索

lu

2025-10-22 70332ced875cd4afaad7c31dc83f863eb1bd1a9f

 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;

@@ -24,6 +26,7 @@
        {
            InitializeComponent();
            //先隐藏4种打印
            //  txt_mesStartProd.CustomFormat = "yyyy-MM-dd HH:mm";
            this.splitMx99.PanelVisibility = DevExpress.XtraEditors.SplitPanelVisibility.Panel2;
            this.splitMx98.PanelVisibility = DevExpress.XtraEditors.SplitPanelVisibility.Panel2;
            this.splitMx100.PanelVisibility = DevExpress.XtraEditors.SplitPanelVisibility.Panel2;
@@ -40,6 +43,7 @@
            this.toolBarMenu1.btnShouJianClick += ToolBarMenu1_btnShouJianClick;
            this.toolBarMenu1.btnDelClick += ToolBarMenu1_btnDelClick;
            this.toolBarMenu1.btnGxClick += ToolBarMenu1_btnGxClick;
            this.toolBarMenu1.btnOutClick += ToolBarMenu1_btnOutClick;
            this.toolBarMenu1.getXmlConfig();
            gvMx1.Columns["barbl"].DisplayFormat.FormatType = FormatType.Numeric;
            gvMx1.Columns["barbl"].DisplayFormat.FormatString = "p0";
@@ -64,6 +68,8 @@
            }, lbGuid);
            getPageList(1);
            pageBar1.PagerEvent += PageBar1_PagerEvent;

            #region 托板码打印相关
            txt_psnQty_1.TextChanged += (s, e) =>
            {
                Gs.DevApp.ToolBox.UtilityHelper.PrintJiSuan(txt_psnQty_1, txt_iCount_1, txt_kQty.Text.Trim(), radOut, txt_yuliang_1);
@@ -72,7 +78,6 @@
            {
                Gs.DevApp.ToolBox.UtilityHelper.PrintAuto(txt_psnQty_1, txt_iCount_1, radOut, txt_yuliang_1);
            };
            //这是托板码
            this.ucBtnPrint1.btnPrintClick += (s, e) =>
            {
                _print();
@@ -117,7 +122,12 @@
                    }
                }
            };
            //这是追溯码
            this.ucBtnPrint1.btnZhiJieClick += (s, e) =>
            {
                _print();
            };
            #endregion
            #region 追溯码打印相关
            this.ucBtnPrint98.btnPrintClick += (s, e) =>
            {
                _print98();
@@ -162,7 +172,13 @@
                    }
                }
            };
            //这是后盖码
            this.ucBtnPrint98.btnZhiJieClick += (s, e) =>
            {
                _print98();
            };
            #endregion

            #region 后盖码打印相关
            this.ucBtnPrint100.btnPrintClick += (s, e) =>
            {
                _print100();
@@ -208,12 +224,23 @@
                    }
                }
            };
            //这是齐套标识卡，仅仅打印
            this.ucBtnPrint100.btnZhiJieClick += (s, e) =>
            {
                _print100();
            };
            #endregion

            #region 这是齐套标识卡，仅仅打印
            this.ucBtnPrint101.SetPlButton(false);
            this.ucBtnPrint101.btnPrintClick += (s, e) =>
            {
                _print101();
            };
            this.ucBtnPrint101.btnZhiJieClick += (s, e) =>
            {
                _print101();
            };
            #endregion
            //导入模板
            this.btnIn.Click += (s, e) =>
            {
@@ -226,7 +253,7 @@
                    var _obj = new
                    {
                        tmpGuid = upGuid,
                        strType = "",
                        strType = txt_daa001.Text.Trim(),
                    };
                    try
                    {
@@ -255,7 +282,64 @@
                };
                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("xlsOutDaaMx", "", "", "", _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)
        {
@@ -513,12 +597,38 @@
        private void ToolBarMenu1_btnSaveClick(object sender, EventArgs e)
        {
            toolBarMenu1.isSetBtn = false;
            DateTime _dtKg = txt_mesStartProd.DateTime;
            DateTime _dtWg = txt_mesEndProd.DateTime;
            if (string.IsNullOrEmpty(txt_mesStartProd.Text.Trim()))
            {
                ToolBox.MsgHelper.ShowError("提示：预计开工时间不能为空！");
                txt_mesStartProd.Focus();
                return;
            }
            if (string.IsNullOrEmpty(txt_mesEndProd.Text.Trim()))
            {
                ToolBox.MsgHelper.ShowError("提示：预计完工时间不能为空！");
                txt_mesEndProd.Focus();
                return;
            }
            if (_dtWg < _dtKg)
            {
                ToolBox.MsgHelper.ShowError("提示：完工时间不能小于开工时间！");
                return;
            }
            if (string.IsNullOrEmpty(txt_daa015.GetId()))
            {
                ToolBox.MsgHelper.ShowError("提示：线体不能为空！");
                return;
            }
            var _obj = new
            {
                guid = UtilityHelper.ToGuid(lbGuid.Text.Trim()), //主建
                sjxt = txt_daa015.GetId(), //线体
                sclx = txt_daa025.Text.Trim(),//生产类型
                bz = txt_daa009.Text.Trim()//备注
                bz = txt_daa009.Text.Trim(),//备注
                dtKg = _dtKg.ToString("yyyy-MM-dd HH:mm:ss"),
                dtWg = _dtWg.ToString("yyyy-MM-dd HH:mm:ss"),
            };
            try
            {
@@ -531,12 +641,13 @@
                    toolBarMenu1.isSetBtn = true;
                    List<DevExpress.XtraGrid.Views.Grid.GridView> gvList = new List<DevExpress.XtraGrid.Views.Grid.GridView>();
                    //gvList.Add(gvMx1);
                    UtilityHelper.ChangeEnableByControl(this.layoutMx1.Controls, false, gvList);
                    UtilityHelper.ChangeEnableByControl(this.layoutMx1.Controls, false);
                    //toolBarMenu1.currentAction = "";
                    //txt_printRemark.Enabled = txt_psnQty_1.Enabled = txt_iCount_1.Enabled = true;
                    //txt_printRemark.ReadOnly = txt_psnQty_1.ReadOnly = txt_iCount_1.ReadOnly = false;
                    //toolBarMenu1.currentAction = "";
                    Gs.DevApp.ToolBox.UtilityHelper.JumpTab(xtraTabControl1, 6);
                    toolBarMenu1.currentAction = "";
                }
                else
                    ToolBox.MsgHelper.ShowError("提示：" + _rtn.rtnMsg);
@@ -548,13 +659,76 @@
        }

        /// <summary>
        /// 工单导出
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        /// <exception cref="NotImplementedException"></exception>
        private void ToolBarMenu1_btnOutClick(object sender, EventArgs e)
        {
            System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder();
            _sbSqlWhere.Append(" and a.ERP_SCZZ in");
            _sbSqlWhere.Append(ToolBox.UtilityHelper.GetOrgWhere());
            _sbSqlWhere.Append(UtilityHelper.GetSearchWhere(_filterList));
            using (FolderBrowserDialog folderBrowserDialog = new FolderBrowserDialog())
            {
                folderBrowserDialog.Description = "选择导出文件的保存路径";
                DialogResult dialogResult = folderBrowserDialog.ShowDialog();
                if (dialogResult == DialogResult.OK)
                {
                    string _folder = folderBrowserDialog.SelectedPath;
                    var _params = new
                    {
                        inQueryWhere = _sbSqlWhere.ToString(),
                        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);
                    }
                }
            }

        }

        /// <summary>
        /// 
        /// </summary>
        /// <param name="curPage">第几页</param>
        /// <param name="pageSize">每页几条</param>
        private void getPageList(int curPage)
        {
            gcMain1.DataSource = null; var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList);
            gcMain1.DataSource = null;
            System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder();
            _sbSqlWhere.Append(" and a.ERP_SCZZ in");
            _sbSqlWhere.Append(ToolBox.UtilityHelper.GetOrgWhere());
            _sbSqlWhere.Append(UtilityHelper.GetSearchWhere(_filterList));
            PageQueryModel pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "create_date", "desc", "", _sbSqlWhere.ToString());
            string json = JsonConvert.SerializeObject(pgq);
            try
@@ -790,7 +964,7 @@
                    txt_psnQty_1.Text = txt_printRemark.Text = txt_iCount_1.Text = txt_printRemark98.Text = txt_iCount_98.Text = txt_yuliang_1.Text = "";
                    txt_iCount_98.Text = txt_kQty98.Text;//追溯码
                    txt_iCount_100.Text = txt_kQty100.Text;//后盖码
                  

                }
                else
                    ToolBox.MsgHelper.ShowError("提示：" + _rtn.rtnMsg);
@@ -1035,5 +1209,25 @@
                frm.ShowDialog();
            }
        }
        /// <summary>
        /// 进入看板
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void repositoryItemButtonEdit1_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            if (e.Button.Index == 0)
            {
                var userGuid =
               string.IsNullOrEmpty(LoginInfoModel.CurrentUser.LoginUserGuid)
                   ? Guid.NewGuid().ToString()
                   : LoginInfoModel.CurrentUser.LoginUserGuid;
                var rowhandle = gridView1.FocusedRowHandle;
                var dr = gridView1.GetDataRow(rowhandle);
                var qcGuid = dr["guid"].ToString() + "&mth=" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss.fff") + "&userGuid=" + userGuid;
                KanBanLaTouH5 frm = new KanBanLaTouH5(qcGuid);
                frm.ShowDialog();
            }
        }
    }
}