增加批量打印功能，增加组织分开维护

cdk

2025-11-01 4dc2dbda4150c7c74a26435a75308789dc359b99

 DevApp/Gs.DevApp/DevFrm/Rk/Frm_MesItemQtrk.cs

@@ -1,4 +1,5 @@
using DevExpress.XtraEditors;
using Gs.DevApp.DevFrm.Rpt;
using Gs.DevApp.DevFrm.Work;
using Gs.DevApp.Entity;
using Gs.DevApp.ToolBox;
@@ -8,6 +9,7 @@
using System;
using System.Collections.Generic;
using System.Data;
using System.IO;
using System.Threading.Tasks;
using System.Windows.Forms;
namespace Gs.DevApp.DevFrm
@@ -24,6 +26,7 @@
        public Frm_MesItemQtrk()
        {
            InitializeComponent();
            split99.PanelVisibility = SplitPanelVisibility.Panel2;
            this.toolBarMenu1.btnAddClick += ToolBarMenu1_btnAddClick;
            this.toolBarMenu1.btnEdtClick += ToolBarMenu1_btnEdtClick;
            this.toolBarMenu1.btnSaveClick += ToolBarMenu1_btnSaveClick;
@@ -38,6 +41,7 @@
            this.toolBarMenu1.btnCaiGouFchkClick += ToolBarMenu1_btnCaiGouFchkClick;
            this.toolBarMenu1.btnCaiWuChkClick += ToolBarMenu1_btnCaiWuChkClick;
            this.toolBarMenu1.btnCaiWuFchkClick += ToolBarMenu1_btnCaiWuFchkClick;
            toolBarMenu1.btnPrintClick += ToolBarMenu1_btnPrintClick;
            this.toolBarMenu1.getXmlConfig();
            Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx1);
            Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx2);
@@ -66,37 +70,295 @@
                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();
            };
            //打印事件
            this.ucBtnPrint1.btnPrintClick += (s, e) =>
            {
                string rowGuid = lbMxGuid.Text.Trim();
                ucBtnPrint1.guidKey = rowGuid;
                if (!Gs.DevApp.ToolBox.UtilityHelper.IsNumeric3(txt_iCount_1.Text.Trim(), txt_yuliang_1.Text.Trim()))
                {
                    Gs.DevApp.ToolBox.MsgHelper.ShowError("请输入正确的条码数量！");
                    txt_iCount_1.Focus();
                    this.ucBtnPrint1.rptParameter = "return false";
                    return;
                }
                if (!Gs.DevApp.ToolBox.UtilityHelper.IsNumeric3(txt_psnQty_1.Text.Trim()))
                {
                    Gs.DevApp.ToolBox.MsgHelper.ShowError("请选择打印条码数量！");
                    txt_psnQty_1.Focus();
                    this.ucBtnPrint1.rptParameter = "return false";
                    return;
                }
                if (lbMxGuid.Text.Trim().Length < 10)
                {
                    Gs.DevApp.ToolBox.MsgHelper.ShowError("请选择打印的行！");
                    this.ucBtnPrint1.rptParameter = "return false";
                    return;
                }
                this.ucBtnPrint1.rptParameter = "rpt_Qtrk{"
                       + lbMxGuid.Text.Trim()//关联主键
                       + "," + ""
                       + "," + Gs.DevApp.ToolBox.UtilityHelper.ToDecimal(txt_yuliang_1.Text.Trim())//余数
                       + "," + txt_iCount_1.Text.Trim()//张数
                       + "," + txt_psnQty_1.Text.Trim()//每张条码数量
                       + "}";
                txt_iCount_1.Text = "";
                txt_psnQty_1.Text = "";
            };
            //打印批量操作事件
            this.ucBtnPrint1.btnAllClick += (s, e) =>
            {
                string rowGuid = lbMxGuid.Text.Trim();
                SelectDeleteBar frm = new SelectDeleteBar(rowGuid, QcSeason.其它入库检.ToString());
                string strCodeList = "";
                string strAction = "";
                frm.UpdateParent += (ss, ee) =>
                {
                    strCodeList = ee.StringSingle;
                    strAction = ee.Data;
                };
                frm.ShowDialog();
                if (string.IsNullOrEmpty(strCodeList))
                    return;
                if (strAction == "print")
                {
                    try
                    {
                        string rptParameter = "rpt_Qtrk{"
                        + "100"//重打都是传100，
                        + "," + ""
                        + "," + ""
                        + "," + ""
                        + "," + ""
                        + "," + strCodeList
                        + "}";
                        using (Form rpt = new RptPreview(rowGuid, rptParameter))
                        {
                            rpt.ShowDialog();
                        }
                        frm.Close();
                    }
                    catch (Exception ex)
                    {
                        MsgHelper.ShowError(ex.Message);
                    }
                }
            };
            gvMx1.FocusedRowChanged += GvMx1_FocusedRowChanged;
            //打印自动计算
            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);
            };
            radOut.SelectedIndexChanged += (s, e) =>
            {
                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) =>
            {
                string kcZz = txt_qt022.GetId();
                if (string.IsNullOrEmpty(kcZz))
                {
                    Gs.DevApp.ToolBox.MsgHelper.ShowError("请先选择库存组织后才能使用复制功能！");
                    txt_qt022.Focus();
                    return;
                }
                string filePath = AppContext.BaseDirectory + "xlsCopy.xls";
                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)
@@ -298,6 +560,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("请选择库存组织！");
@@ -320,10 +583,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))
@@ -332,12 +595,12 @@
                txt_qt009.Focus();
                return;
            }
            //if (string.IsNullOrEmpty(kcCk))
            //{
            //    Gs.DevApp.ToolBox.MsgHelper.Warning("请选择收料仓库！");
            //    txt_qt008.Focus();
            //    return;
            //}
            if (string.IsNullOrEmpty(kcCk))
            {
                Gs.DevApp.ToolBox.MsgHelper.ShowError("请选择收料仓库！\n如果不是【报废仓】！\nQC可以重新设置仓库！");
                txt_qt008.Focus();
                return;
            }
            var _obj = new
            {
                guid = UtilityHelper.ToGuid(lbGuid.Text.Trim()), //主建
@@ -351,6 +614,7 @@
                hzlx = inHzlx,//货主类型
                inHz = inHz,//货主
                inSource = txt_qt035.EditValue,//工单号
                qtlx = qtlx,
                list = new List<dynamic>(),
            };
            gvMx1.CloseEditor();
@@ -416,7 +680,11 @@
        /// <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.qt022 in");
            _sbSqlWhere.Append(ToolBox.UtilityHelper.GetOrgWhere());
            _sbSqlWhere.Append(UtilityHelper.GetSearchWhere(_filterList));
            PageQueryModel pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "qt001", "asc", "", _sbSqlWhere.ToString());
            string json = JsonConvert.SerializeObject(pgq);
            try
@@ -530,6 +798,11 @@
                    {
                        Gs.DevApp.ToolBox.UtilityHelper.SetDefaultTable(gcMx2, gvMx2);
                    }

                    if (txt_isIqc.Checked)
                        split99.PanelVisibility = SplitPanelVisibility.Panel2;
                    else
                        split99.PanelVisibility = SplitPanelVisibility.Both;
                }
                else
                    ToolBox.MsgHelper.ShowError("提示：" + _rtn.rtnMsg);
@@ -552,6 +825,9 @@
            gvMx1.CloseEditor();
            gvMx1.PostEditor();
            gvMx1.UpdateCurrentRow();
            gvMx1.BestFitColumns();
            Gs.DevApp.ToolBox.UtilityHelper.SetGridLayout(gvMx1);

        }
        /// <summary>
        /// 移出明细
@@ -591,7 +867,7 @@
                        getModel(lbGuid.Text);
                    }
                    else
                    MsgHelper.ShowError("提示：" + _rtn.rtnMsg);
                        MsgHelper.ShowError("提示：" + _rtn.rtnMsg);
                }
                catch (Exception ex)
                {
@@ -711,7 +987,7 @@
                    _webServiceName + "EditModelSubmit",
                    JsonConvert.SerializeObject(_obj));
                var _rtn = UtilityHelper.ReturnToDynamic(strJson);
              

                if (_rtn.rtnCode > 0 && _rtn.rtnData.outSum * 1 > 0)
                {
                    MsgHelper.ShowInformation(_rtn.rtnData.outMsg.ToString());
@@ -735,6 +1011,11 @@
                MsgHelper.ShowError("提示：" + ex.Message);
            }
        }
        /// <summary>
        /// 选择不良
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void rptBl_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            var rowhandle = gvMx1.FocusedRowHandle;
@@ -748,7 +1029,8 @@
                foreach (dynamic dym in lst)
                {
                    if (stringBuilder.Length > 0)
                        stringBuilder.Append("|");
                        // stringBuilder.Append("|");//|和~已被占用
                        stringBuilder.Append("&");
                    stringBuilder.Append(dym.dicTxt);
                }
                gvMx1.SetFocusedRowCellValue("qd012", stringBuilder.ToString());
@@ -756,5 +1038,56 @@
            };
            frm.ShowDialog();
        }

        private void GvMx1_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
        {
            if (e.FocusedRowHandle >= 0)
            {
                DataRow row = gvMx1.GetDataRow(e.FocusedRowHandle);
                lbMxGuid.Text = row["guid"].ToString();
                ucBtnPrint1.guidKey = row["guid"].ToString();
                txtWlid.Text = row["qd002"].ToString();
                txtWlgg.Text = row["qd004"].ToString();
                txtWlmc.Text = row["qd003"].ToString();
                txtQuantity.Text = row["qd007"].ToString();//申请总量
                txt_yQty.Text = row["ydy"].ToString();//已打印总量
                txt_kQty.Text = row["kdy"].ToString();//可打印总量
            }
            else
            {
                lbMxGuid.Text = "";
                ucBtnPrint1.guidKey = "";
                txtWlid.Text = "";
                txtWlgg.Text = "";
                txtWlmc.Text = "";
                txtQuantity.Text = "";
                txt_yQty.Text = "";
                txt_kQty.Text = "";
                txt_psnQty_1.Text = "";
                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;

        }
    }
}