From 1f412341cf39655fe47318b20c23bf4de8dc8717 Mon Sep 17 00:00:00 2001
From: lu <123456>
Date: 星期五, 31 十月 2025 15:56:07 +0800
Subject: [PATCH] 完结功能

---
 DevApp/Gs.DevApp/DevFrm/Warehouse/Frm_MesDbck.cs |  142 +++++++++++++++++++++++++++++++++++++++++++++--
 1 files changed, 136 insertions(+), 6 deletions(-)

diff --git a/DevApp/Gs.DevApp/DevFrm/Warehouse/Frm_MesDbck.cs b/DevApp/Gs.DevApp/DevFrm/Warehouse/Frm_MesDbck.cs
index b1cbc5c..516e938 100644
--- a/DevApp/Gs.DevApp/DevFrm/Warehouse/Frm_MesDbck.cs
+++ b/DevApp/Gs.DevApp/DevFrm/Warehouse/Frm_MesDbck.cs
@@ -7,6 +7,7 @@
 using System;
 using System.Collections.Generic;
 using System.Data;
+using System.IO;
 using System.Threading.Tasks;
 using System.Windows.Forms;
 
@@ -31,6 +32,7 @@
             toolBarMenu1.btnLogClick += ToolBarMenu1_btnLogClick;
             toolBarMenu1.btnShouHouChkClick += ToolBarMenu1_btnShouHouChkClick;
             toolBarMenu1.btnShouHouFchkClick += ToolBarMenu1_btnShouHouFchkClick;
+            toolBarMenu1.btnWjClick += ToolBarMenu1_btnWjClick;
             this.toolBarMenu1.getXmlConfig();
             Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameterMx(gvMx1);
             Gs.DevApp.ToolBox.UtilityHelper.SetGridViewParameter(gridView1, picCheckBox, this, "chkStatus", "", (value) =>
@@ -86,7 +88,115 @@
                 gvMx1.SetFocusedRowCellValue("dcHz", _orgName);
                 gvMx1.SetFocusedRowCellValue("dcHzGuid", _orgId);
             };
+
+            #region 2025-08-27 澶嶅埗beg
+            btnCopyXls.Click += (s, e) =>
+            {
+                string kcZz = txt_fapporgid.GetId();
+                if (string.IsNullOrEmpty(kcZz))
+                {
+                    Gs.DevApp.ToolBox.MsgHelper.ShowError("璇峰厛閫夋嫨鐢宠缁勭粐鍚庢墠鑳戒娇鐢ㄥ鍒跺姛鑳斤紒");
+                    txt_fapporgid.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
+                        {
+                            string _orgId = txt_fapporgid.GetId();
+                            string _orgName = txt_fapporgid.GetName();
+                            var lst = ee.DynamicList;
+                            DataTable _Table = (DataTable)gcMx1.DataSource;
+                            foreach (dynamic dym in lst)
+                            {
+                                DataRow _row = _Table.NewRow();
+                                _row["itemNo"] = dym.itemNo;
+                                _row["itemName"] = dym.itemName;
+                                _row["itemModel"] = dym.itemModel;
+                                _row["itemUnit"] = dym.dwName;
+                                _row["itemId"] = dym.itemId;
+                                _row["shNum"] = dym.sl;
+                                _row["remark"] = dym.bz;
+                                //榛樿浠撳簱鍜屼粨搴撴暟閲�
+                                _row["dcCk"] = dym.depotName;
+                                _row["dcCkGuid"] = dym.depotId;
+                                _row["kcQty"] = dym.kcQty;
+                                if (!string.IsNullOrEmpty(_orgId))
+                                {
+                                    _row["dcOrg"] = _orgName;
+                                    _row["dcOrgGuid"] = _orgId;
+                                    _row["drOrg"] = _orgName;
+                                    _row["drOrgGuid"] = _orgId;
+                                    _row["drHz"] = _orgName;
+                                    _row["drHzGuid"] = _orgId;
+                                    _row["dcHz"] = _orgName;
+                                    _row["dcHzGuid"] = _orgId;
+                                }
+                                _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("鎵句笉鍒皒lsCopy.xls鏂囦欢锛岃鑱旂郴绠$悊鍛橈紒");
+                }
+            };
+            #endregion
+
+            #region 2025-10-10 鍚戜笅澶嶅埗beg
+            btnDown.Click += (s, e) =>
+            {
+                // 鑾峰彇褰撳墠閫変腑琛岀殑琛屽彿
+                int focusedRowHandle = gvMx1.FocusedRowHandle;
+                if (focusedRowHandle < 0) return;
+
+                // 鑾峰彇褰撳墠琛岀殑鏃堕暱
+                DataRow currentRow = gvMx1.GetDataRow(focusedRowHandle);
+                if (currentRow == null) return;
+                var hourValue = currentRow["drCkGuid"];
+                var hourValue2 = currentRow["drCk"];
+                if (hourValue == null || string.IsNullOrEmpty(hourValue.ToString())) {
+                    MsgHelper.ShowError("褰撳墠閫変腑鐨勮鏃犱粨搴擄紝澶嶅埗澶辫触锛�");
+                    return;
+                }
+                if (hourValue2 == null) {
+                    MsgHelper.ShowError("褰撳墠閫変腑鐨勮鏃犱粨搴擄紝澶嶅埗澶辫触锛�");
+                    return;
+                }
+                // 鎵归噺璁剧疆涓嬮潰鎵�鏈夎鐨勬椂闀�
+                for (int i = focusedRowHandle + 1; i < gvMx1.DataRowCount; i++)
+                {
+                    var row = gvMx1.GetDataRow(i);
+                    if (row != null)
+                    {
+                        row["drCkGuid"] = hourValue;
+                        row["drCk"] = hourValue2;
+                    }
+                }
+                gvMx1.RefreshData();
+            };
+            #endregion
         }
+
+      
+
         private void GridView1_ColumnFilterChanged(object sender, EventArgs e)
         {
             _filterList = Gs.DevApp.ToolBox.UtilityHelper.GetDilter(gridView1.Columns, gridView1);
@@ -514,7 +624,16 @@
             }
         }
 
-
+        /// <summary>
+        /// 瀹岀粨
+        /// </summary>
+        /// <param name="sender"></param>
+        /// <param name="e"></param>
+        /// <exception cref="NotImplementedException"></exception>
+        private void ToolBarMenu1_btnWjClick(object sender, EventArgs e)
+        {
+            _toolCk(2);
+        }
         /// <summary>
         ///     瀹℃牳浜嬩欢
         /// </summary>
@@ -571,6 +690,9 @@
                 case 0:
                     strMsg = "鍙嶅鏍�";
                     break;
+                case 2:
+                    strMsg = "瀹岀粨";
+                    break;
                 case 20:
                     strMsg = "鍞悗瀹℃牳";
                     break;
@@ -608,8 +730,8 @@
                         getModel(lbGuid.Text.Trim());
                         int rowHandle = gridView1.LocateByValue(1, gridView1.Columns["guid"], rowGuid);
                         gridView1.FocusedRowHandle = rowHandle;
-                        if (_inFieldValue <= 1) 
-                        UtilityHelper.SetCheckIco(gridView1, "chkStatus", "FAPPROVEBY", "FAPPROVEDATE", picCheckBox, this, _inFieldValue.ToString());
+                        if (_inFieldValue <= 1)
+                            UtilityHelper.SetCheckIco(gridView1, "chkStatus", "FAPPROVEBY", "FAPPROVEDATE", picCheckBox, this, _inFieldValue.ToString());
                     }
                     else
                     {
@@ -643,9 +765,13 @@
             gvMx1.SetFocusedRowCellValue("itemModel", SelectedDataRow["itemModel"].ToString());
             gvMx1.SetFocusedRowCellValue("itemId", SelectedDataRow["id"].ToString());
             gvMx1.SetFocusedRowCellValue("itemUnit", SelectedDataRow["dwName"].ToString());
+            gvMx1.SetFocusedRowCellValue("dcCk", SelectedDataRow["depotName"]);
+            gvMx1.SetFocusedRowCellValue("dcCkGuid", SelectedDataRow["depotId"]);
+            gvMx1.SetFocusedRowCellValue("kcQty", SelectedDataRow["kcQty"]);
             gvMx1.CloseEditor();
             gvMx1.PostEditor();
             gvMx1.UpdateCurrentRow();
+            gvMx1.BestFitColumns();
         }
 
         /// <summary>
@@ -686,7 +812,7 @@
                         getModel(lbGuid.Text);
                     }
                     else
-                    MsgHelper.ShowError("鎻愮ず锛�" + _rtn.rtnMsg);
+                        MsgHelper.ShowError("鎻愮ず锛�" + _rtn.rtnMsg);
                 }
                 catch (Exception ex)
                 {
@@ -728,19 +854,21 @@
                 return;
             var dr = gvMx1.GetDataRow(rowhandle);
             var strOrgGuid = dr["dcOrgGuid"].ToString();
+            var strItemId = dr["itemId"].ToString();
             if (string.IsNullOrEmpty(strOrgGuid))
             {
                 MsgHelper.ShowError("鎻愮ず锛氳鍏堥�夋嫨璋冨嚭缁勭粐锛�");
                 return;
             }
             ;
-            SelectCk frm = new SelectCk(strOrgGuid);
+            SelectCk frm = new SelectCk(strOrgGuid, strItemId);
             frm.UpdateParent += (ss, ee) =>
             {
                 var lst = new List<dynamic>();
                 lst = ee.DynamicList;
                 gvMx1.SetFocusedRowCellValue("dcCk", lst[0].name);
                 gvMx1.SetFocusedRowCellValue("dcCkGuid", lst[0].guid);
+                gvMx1.BestFitColumns();
             };
             frm.ShowDialog();
         }
@@ -811,19 +939,21 @@
                 return;
             var dr = gvMx1.GetDataRow(rowhandle);
             var strOrgGuid = dr["drOrgGuid"].ToString();
+            var strItemId = dr["itemId"].ToString();
             if (string.IsNullOrEmpty(strOrgGuid))
             {
                 MsgHelper.ShowError("鎻愮ず锛氳鍏堥�夋嫨璋冨叆缁勭粐锛�");
                 return;
             }
             ;
-            SelectCk frm = new SelectCk(strOrgGuid);
+            SelectCk frm = new SelectCk(strOrgGuid, strItemId);
             frm.UpdateParent += (ss, ee) =>
             {
                 var lst = new List<dynamic>();
                 lst = ee.DynamicList;
                 gvMx1.SetFocusedRowCellValue("drCk", lst[0].name);
                 gvMx1.SetFocusedRowCellValue("drCkGuid", lst[0].guid);
+                gvMx1.BestFitColumns();
             };
             frm.ShowDialog();
         }

--
Gitblit v1.9.3