cdk
2025-11-01 cbb5315301b1490b57497212256c5255e5eb7eb6
DevApp/Gs.DevApp/DevFrm/Rk/Frm_MesItemQtrk.cs
@@ -41,6 +41,8 @@
            this.toolBarMenu1.btnCaiGouFchkClick += ToolBarMenu1_btnCaiGouFchkClick;
            this.toolBarMenu1.btnCaiWuChkClick += ToolBarMenu1_btnCaiWuChkClick;
            this.toolBarMenu1.btnCaiWuFchkClick += ToolBarMenu1_btnCaiWuFchkClick;
            toolBarMenu1.btnPrintClick += ToolBarMenu1_btnPrintClick;
            toolBarMenu1.btnWjClick += ToolBarMenu1_btnWjClick;
            this.toolBarMenu1.getXmlConfig();
            Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx1);
            Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx2);
@@ -69,34 +71,61 @@
                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;
                }
                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;
                    //    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();
            };
@@ -184,7 +213,45 @@
            {
                Gs.DevApp.ToolBox.UtilityHelper.PrintAuto(txt_psnQty_1, txt_iCount_1, radOut, txt_yuliang_1);
            };
            //全部打印
            ucBtnPrintAll1.btnPrintClick += (s, e) =>
            {
                this.ucBtnPrintAll1.rptType = "";
                this.ucBtnPrintAll1.mxList = null;
                if (string.IsNullOrEmpty(lbGuid.Text.Trim()))
                {
                    MsgHelper.ShowError("提示:打印前请先保存单据!");
                    return;
                }
                getModel(lbGuid.Text.Trim());
                List<dynamic> lst = new List<dynamic>();
                DataTable dt = (DataTable)gcMx1.DataSource;
                foreach (DataRow row in dt.Rows)
                {
                    string guid = row["guid"].ToString();
                    string psnQty = row["kdy"].ToString();
                    if (string.IsNullOrEmpty(psnQty))
                    {
                        continue;
                    }
                    if (psnQty == "0")
                    {
                        continue;
                    }
                    lst.Add(new
                    {
                        guid = guid,
                        kdy = psnQty,
                    });
                }
                if (lst.Count <= 0)
                {
                    MsgHelper.ShowError("提示:暂无可打印的物料!");
                    return;
                }
                this.ucBtnPrintAll1.rptType = "rpt_Qtrk";
                this.ucBtnPrintAll1.mxList = lst;
            };
            #region 2025-08-27 复制beg
            btnCopyXls.Click += (s, e) =>
            {
@@ -199,15 +266,102 @@
                if (File.Exists(filePath))
                {
                    var frm = new CopyXls(kcZz, lbGuid.Text.Trim(), OrderType.其它入库.ToString());
                    frm.UpdateParent += (ss, ee) =>
                    {
                        try
                        {
                            var lst = ee.DynamicList;
                            DataTable _Table = (DataTable)gcMx1.DataSource;
                            foreach (dynamic dym in lst)
                            {
                                DataRow _row = _Table.NewRow();
                                _row["qd002"] = dym.itemNo;
                                _row["qd003"] = dym.itemName;
                                _row["qd004"] = dym.itemModel;
                                _row["kcDw"] = dym.dwName;
                                _row["itemId"] = dym.itemId;
                                _row["qd007"] = dym.sl;
                                _row["qd010"] = dym.bz;
                                _row["qd012"] = dym.bllx;
                                _Table.Rows.Add(_row);
                            }
                            gcMx1.BindingContext = new BindingContext();
                            gcMx1.DataSource = _Table;
                            gcMx1.ForceInitialize();
                            gvMx1.CloseEditor();
                            gvMx1.PostEditor();
                            gvMx1.UpdateCurrentRow();
                            gvMx1.BestFitColumns();
                        }
                        catch (Exception ex)
                        {
                            Gs.DevApp.ToolBox.MsgHelper.ShowError(ex.Message);
                        }
                    };
                    frm.ShowDialog();
                }
                else
                {
                    Gs.DevApp.ToolBox.MsgHelper.ShowError("找不到xlsCopy.xls文件,请联系管理员!");
                }
            };
            #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)
@@ -409,6 +563,7 @@
            string inHz = ucLookHuoZhu1.GetHzId();//货主
            string inRkyy = txt_qt010.Text.Trim();//入库原因
            string kcCk = txt_qt008.GetId();//仓库
            string qtlx = txt_qtlx.Text.Trim();//后来增加的类型
            if (string.IsNullOrEmpty(kcZz))
            {
                Gs.DevApp.ToolBox.MsgHelper.ShowError("请选择库存组织!");
@@ -431,10 +586,10 @@
                txt_qt003.Focus();
                return;
            }
            if (txt_qt019.SelectedIndex <= 0)
            if (txt_qtlx.SelectedIndex <= 0)
            {
                Gs.DevApp.ToolBox.MsgHelper.ShowError("请选择库存方向!");
                txt_qt019.Focus();
                Gs.DevApp.ToolBox.MsgHelper.ShowError("请选择入库类型!");
                txt_qtlx.Focus();
                return;
            }
            if (string.IsNullOrEmpty(kcBm) && string.IsNullOrEmpty(kcGys))
@@ -462,6 +617,7 @@
                hzlx = inHzlx,//货主类型
                inHz = inHz,//货主
                inSource = txt_qt035.EditValue,//工单号
                qtlx = qtlx,
                list = new List<dynamic>(),
            };
            gvMx1.CloseEditor();
@@ -572,7 +728,6 @@
        /// <param name="strGuid"></param>
        private void getModel(string strGuid)
        {
            gcMx1.DataSource = null;
            bool isEdit = false;
            if (toolBarMenu1.currentAction == "add") return;
@@ -673,6 +828,9 @@
            gvMx1.CloseEditor();
            gvMx1.PostEditor();
            gvMx1.UpdateCurrentRow();
            gvMx1.BestFitColumns();
            Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gvMx1);
        }
        /// <summary>
        /// 移出明细
@@ -720,6 +878,12 @@
                }
            }
        }
        private void ToolBarMenu1_btnWjClick(object sender, EventArgs e)
        {
            _toolCk(2);
        }
        /// <summary>
        ///     审核事件
@@ -795,6 +959,9 @@
                    break;
                case 0:
                    strMsg = "反审核";
                    break;
                case 2:
                    strMsg = "完结";
                    break;
                case 30:
                    strMsg = "财务审核";
@@ -912,5 +1079,27 @@
                txt_iCount_1.Text = "";
            }
        }
        private void ToolBarMenu1_btnPrintClick(object sender, EventArgs e)
        {
            //guidKey, rptParameter
            string rowGuid, rowName;
            (rowGuid, rowName) = UtilityHelper.GetCurrentRow(xtraTabControl1,
                lbGuid, txt_qtck, gridView1, "qtck");
            if (string.IsNullOrEmpty(rowGuid))
            {
                MsgHelper.ShowError("请先选择你要操作的行!");
                return;
            }
            this.toolBarMenu1.rptParameter = "rpt_QTRKSQ{"
                                               + ""
                                               + "," + ""
                                               + "," + ""
                                               + "," + ""
                                               + "," + ""
                                               + "}";
            this.toolBarMenu1.guidKey = rowGuid;
        }
    }
}