lu
2025-10-08 53003f183ddae21d9b6836f9f4bfb41d693e1435
DevApp/Gs.DevApp/DevFrm/Rk/Frm_MesItemQtrk.cs
@@ -69,65 +69,60 @@
                txt_qt009.getSuppler(_orgId, _ucBm);
                txt_qt018.getSuppler(_orgId, _ucGys);
                txt_qt008.getSuppler(_orgId, _ucCk);
                System.Text.StringBuilder sbWhere = new System.Text.StringBuilder();
                sbWhere.Append(" and a.FSubsidiary ='" + _orgId + "'");
                var _obj = new PageQueryModel(1, 999999, "item_no", "asc", "", sbWhere.ToString(), "");
                var json = JsonConvert.SerializeObject(_obj);
                try
                {
                    var strReturn = UtilityHelper.HttpPost("",
                        "MesItemsManager/GetListSelect", json);
                    var rtn = UtilityHelper.ReturnToTablePage(strReturn);
                    var dt = rtn.rtnData.list;
                    this.repositoryItemSearchLookUpEdit1.DataSource = dt;
                    gridView2.BestFitColumns();
                    Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gridView2);
                }
                catch (Exception ex)
                {
                    MsgHelper.ShowError("提示:" + ex.Message);
                }
                _bindLookSearch(txt_qt035.Text.Trim(), "", "");
            };
            //选择源单明细
            txt_qt035.ButtonClick += (s, e) =>
            {
                string strSrmNo = "";
                SelectDaa frm = new SelectDaa();
                string _orgId = txt_qt022.GetId();
                SelectDaa frm = new SelectDaa(_orgId);
                frm.UpdateParent += (ss, ee) =>
                {
                    var lst = new List<dynamic>();
                    lst = ee.DynamicList;
                    strSrmNo = lst[0].guid;
                    string strSrmNo = lst[0].guid;
                    string strGdlx = lst[0].gdlx;
                    string strGdlxWlid = lst[0].gdlxWlid;
                    txt_qt035.Text = strSrmNo;
                    _bindLookSearch(txt_qt035.Text.Trim(), strGdlx, strGdlxWlid);
                    #region 选择工单后带出下面的物料 2025-09-27
                    try
                    {
                        var _obj = new
                        {
                            strDaaNo = strSrmNo,//主建
                        };
                        var strReturn = UtilityHelper.HttpPost("",
                            "WomdaaManager/SelectDaaMx",
                            JsonConvert.SerializeObject(_obj));
                        var dt = UtilityHelper.ReturnToList(strReturn);
                        DataTable _newTable = dt.rtnData;
                        DataTable _oldTable = (DataTable)gcMx1.DataSource;
                        DataRow[] sourceRows = _newTable.Select();
                        for (int i = 0; i < sourceRows.Length; i++)
                        {
                            _oldTable.ImportRow(sourceRows[i]);
                        }
                        gcMx1.BindingContext = new BindingContext();
                        gcMx1.DataSource = _oldTable;
                        gcMx1.ForceInitialize();
                        gvMx1.BestFitColumns();
                        Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gvMx1);
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show(ex.Message);
                    }
                    //try
                    //{
                    //    var _obj = new
                    //    {
                    //        strDaaNo = strSrmNo,//主建
                    //    };
                    //    var strReturn = UtilityHelper.HttpPost("",
                    //        "WomdaaManager/SelectDaaMx",
                    //        JsonConvert.SerializeObject(_obj));
                    //    var dt = UtilityHelper.ReturnToList(strReturn);
                    //    DataTable _newTable = dt.rtnData;
                    //    DataTable _oldTable = (DataTable)gcMx1.DataSource;
                    //    foreach (DataRow dddddd in _newTable.Rows)
                    //    {
                    //        DataRow _row = _oldTable.NewRow();
                    //        _row["qd002"] = dddddd["itemNo"].ToString();
                    //        _row["qd003"] = dddddd["itemName"].ToString();
                    //        _row["qd004"] = dddddd["itemModel"].ToString();
                    //        _row["kcDw"] = dddddd["dwName"].ToString();
                    //        _row["itemId"] = dddddd["itemId"].ToString();
                    //        _row["qd007"] = dddddd["sl"].ToString();
                    //        _row["qd010"] = dddddd["bz"].ToString();
                    //        _row["qd012"] = dddddd["bllx"].ToString();
                    //        // _oldTable.ImportRow(_row);
                    //        _oldTable.Rows.Add(_row);
                    //    }
                    //    gcMx1.BindingContext = new BindingContext();
                    //    gcMx1.DataSource = _oldTable;
                    //    gcMx1.ForceInitialize();
                    //    gvMx1.BestFitColumns();
                    //    Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gvMx1);
                    //}
                    //catch (Exception ex)
                    //{
                    //    MessageBox.Show(ex.Message);
                    //}
                    #endregion
                };
                frm.ShowDialog();
@@ -271,6 +266,60 @@
            };
            #endregion
        }
        /// <summary>
        /// 来源明细限制,
        /// </summary>
        /// <param name="strGdlx">工单类型,如果是维修,根据物料找</param>
        private void _bindLookSearch(string daaNo, string strGdlx, string gdlxWlid)
        {
            System.Text.StringBuilder sbWhere = new System.Text.StringBuilder();
            sbWhere.Append(" and a.FSubsidiary ='" + txt_qt022.GetId() + "'");
            if (daaNo.Trim().Length > 0)
            {
                if (strGdlx == "W-维修返工" || strGdlx == "C-拆机返工")
                {
                    sbWhere.Append("  and a.item_id in (");
                    sbWhere.Append("  select  dab.dab003  from WOMDAA daa left join WOMDAB dab on daa.guid=dab.daaGuid   ");
                    sbWhere.Append("   where  daa.guid=( select top 1  ddddd.guid as dddddGuid from WOMDAA ddddd where  ddddd.daa002='" + gdlxWlid + "' and  ddddd.daa025 in('F-量产','S-试产') order by ddddd.daa001 desc )");
                    sbWhere.Append(" )");
                }
                else
                {
                    sbWhere.Append("  and a.item_id in (");
                    sbWhere.Append("  select dab.dab003 from WOMDAB dab where dab.dab001 = '" + txt_qt035.Text.Trim() + "'");
                    sbWhere.Append(" )");
                }
            }
            var _obj = new PageQueryModel(1, 999999, "item_no", "asc", "", sbWhere.ToString(), "");
            var json = JsonConvert.SerializeObject(_obj);
            try
            {
                var strReturn = UtilityHelper.HttpPost("", "MesItemsManager/GetListSelect", json);
                var rtn = UtilityHelper.ReturnToTablePage(strReturn);
                DataTable dt = rtn.rtnData.list;
                //如果没有,再读一遍
                if (dt == null || dt.Rows.Count <= 1)
                {
                    _bindLookSearch("", "", "");
                }
                else
                {
                    this.gridView2.IndicatorWidth = 60;
                    this.gridView2.CustomDrawRowIndicator += (ss, ee) =>
                    {
                        if (ee.Info.IsRowIndicator && ee.RowHandle >= 0)
                            ee.Info.DisplayText = (ee.RowHandle + 1).ToString();
                    };
                    this.repositoryItemSearchLookUpEdit1.DataSource = dt;
                    // repositoryItemSearchLookUpEdit1.BestFitMode = DevExpress.XtraEditors.Controls.BestFitMode.BestFitResizePopup;
                    //repositoryItemSearchLookUpEdit1.PopupFormSize = new System.Drawing.Size(500, 300);
                }
            }
            catch (Exception ex)
            {
                MsgHelper.ShowError("提示:" + ex.Message);
            }
        }
        private void GridView1_ColumnFilterChanged(object sender, EventArgs e)
        {