From 8392ea7db9ad3d7cbddba1b880bb133e4f7aa5c0 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期二, 30 四月 2024 09:56:30 +0800
Subject: [PATCH] 托盘条码自动生成:临时组托

---
 WarM/条码打印/Gy_PackBarCodeBill_automaticallyByPLC.Designer.cs |   15 +++
 WarM/条码打印/Gy_PackBarCodeBill_automaticallyByPLC.cs          |  189 +++++++++++++++++++++++++++++++++++++++++++++++
 2 files changed, 202 insertions(+), 2 deletions(-)

diff --git "a/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_PackBarCodeBill_automaticallyByPLC.Designer.cs" "b/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_PackBarCodeBill_automaticallyByPLC.Designer.cs"
index ea49d71..703f4cb 100644
--- "a/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_PackBarCodeBill_automaticallyByPLC.Designer.cs"
+++ "b/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_PackBarCodeBill_automaticallyByPLC.Designer.cs"
@@ -34,6 +34,7 @@
             this.tabControl_MainInfo = new System.Windows.Forms.TabControl();
             this.tabPage_BillInfo = new System.Windows.Forms.TabPage();
             this.gbUp = new System.Windows.Forms.GroupBox();
+            this.button_produceTemp = new System.Windows.Forms.Button();
             this.label_sBillNo = new System.Windows.Forms.Label();
             this.textBox_sBillNo = new System.Windows.Forms.TextBox();
             this.label_sBillID = new System.Windows.Forms.Label();
@@ -121,6 +122,7 @@
             // gbUp
             // 
             this.gbUp.BackColor = System.Drawing.Color.Transparent;
+            this.gbUp.Controls.Add(this.button_produceTemp);
             this.gbUp.Controls.Add(this.label_sBillNo);
             this.gbUp.Controls.Add(this.textBox_sBillNo);
             this.gbUp.Controls.Add(this.label_sBillID);
@@ -149,6 +151,16 @@
             this.gbUp.Size = new System.Drawing.Size(1374, 310);
             this.gbUp.TabIndex = 33;
             this.gbUp.TabStop = false;
+            // 
+            // button_produceTemp
+            // 
+            this.button_produceTemp.Location = new System.Drawing.Point(829, 215);
+            this.button_produceTemp.Name = "button_produceTemp";
+            this.button_produceTemp.Size = new System.Drawing.Size(158, 70);
+            this.button_produceTemp.TabIndex = 123;
+            this.button_produceTemp.Text = "涓存椂缁勬墭";
+            this.button_produceTemp.UseVisualStyleBackColor = true;
+            this.button_produceTemp.Click += new System.EventHandler(this.button_produceTemp_Click);
             // 
             // label_sBillNo
             // 
@@ -287,11 +299,11 @@
             // textBox_HPackBarCode
             // 
             this.textBox_HPackBarCode.BackColor = System.Drawing.SystemColors.ScrollBar;
-            this.textBox_HPackBarCode.Enabled = false;
             this.textBox_HPackBarCode.Location = new System.Drawing.Point(122, 81);
             this.textBox_HPackBarCode.Name = "textBox_HPackBarCode";
             this.textBox_HPackBarCode.Size = new System.Drawing.Size(280, 28);
             this.textBox_HPackBarCode.TabIndex = 43;
+            this.textBox_HPackBarCode.KeyPress += new System.Windows.Forms.KeyPressEventHandler(this.textBox_HPackBarCode__KeyPress);
             // 
             // dtpHDate
             // 
@@ -744,5 +756,6 @@
         private System.Windows.Forms.ToolStripSeparator toolStripSeparator10;
         private System.Windows.Forms.ToolStripButton tc;
         private System.Windows.Forms.ToolStripButton toolStripButton_Delete;
+        private System.Windows.Forms.Button button_produceTemp;
     }
 }
\ No newline at end of file
diff --git "a/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_PackBarCodeBill_automaticallyByPLC.cs" "b/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_PackBarCodeBill_automaticallyByPLC.cs"
index 254645b..578ef1d 100644
--- "a/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_PackBarCodeBill_automaticallyByPLC.cs"
+++ "b/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_PackBarCodeBill_automaticallyByPLC.cs"
@@ -1163,9 +1163,196 @@
             }
         }
 
+
         #endregion
 
-        
+
+        #region 涓存椂缁勬墭
+        #region 涓存椂缁勬墭 鎸夐挳鐐瑰嚮浜嬩欢
+        private void button_produceTemp_Click(object sender, EventArgs e)
+        {
+            if (HQty == 0)
+            {
+                MessageBox.Show("璇锋壂鐮佸瓙鏉$爜!");
+                return;
+            }
+            this.produceTemp();
+
+            //璁剧疆鎵撳嵃妯℃澘锛屾墦鍗�
+            grdSub.Rows[0].Cells[0].Value = "*";
+            Report = new GridppReport();
+            Report.LoadFromFile(DBUtility.ClsPub.AppPath + @"\" + textBox_PrintModelParams.Text + "_Temp" + ".grf");  //here .
+            Report.BeforePostRecord += new _IGridppReportEvents_BeforePostRecordEventHandler(ReportBeforePostRecord);
+            Report.FetchRecord += new _IGridppReportEvents_FetchRecordEventHandler(ReportFetchRecordByDataTable);
+            Report.PrintEnd += new _IGridppReportEvents_PrintEndEventHandler(ReportPrintEnd);
+            if (comboBox_PrinterParams.Text != "")
+            {
+                Report.Printer.PrinterName = comboBox_PrinterParams.Text.Replace("(榛樿)", "");
+            }
+            Report.Print(false);
+        }
+        #endregion
+
+        #region 涓存椂缁勬墭
+        private void produceTemp()
+        {
+            //鍒ゆ柇鏉$爜妗f涓槸鍚﹀凡缁忓瓨鍦ㄨ鎵樻潯鐮侊紝鑻ュ瓨鍦紝鍒欎笉闇�瑕佸啀鍒涘缓銆傞噸鏂板姞杞界晫闈㈠嵆鍙��
+            DataSet ds_getPackBarCode;
+            string sql_getPackBarCode = "select * from Gy_BarCodeBill where HBarCode = '" + textBox_HPackBarCode.Text + "'";
+            ds_getPackBarCode = oCn.RunProcReturn(sql_getPackBarCode, "Gy_BarCodeBill");
+            if (ds_getPackBarCode != null && ds_getPackBarCode.Tables[0].Rows.Count > 0)
+            {
+                //閲嶆柊鍔犺浇鐣岄潰
+                getDisplay_grdSub();
+
+                setPackBarCodeBillData();
+
+                getDisplay_GrdMain();
+                return;
+            }
+
+
+            //鑾峰彇缁勭粐淇℃伅
+            HOrgID = get_ORGANIZATIONSIDByName(cmbHOrgID.Text);
+            HOrgNumber = get_ORGANIZATIONSNOByName(cmbHOrgID.Text);
+
+            //楠岃瘉缁勭粐
+            if (HOrgID == -1)
+            {
+                MessageBox.Show("閫夋嫨缁勭粐鏈夐敊璇紒");
+                return;
+            }
+
+            //鍗曟嵁瀹屾暣鎬у垽鏂�
+            if (!Sub_AllowSave())
+            {
+                return;
+            }
+
+            //鑾峰彇褰撳墠浜х嚎鍙婁骇绾垮唴鐮�
+            long HSourceID = 0;
+            string sql = "select * from Gy_Source where HName = '" + comboBox_SourceNameParams.Text + "' ";
+            DataSet ds = oCn.RunProcReturn(sql, "Gy_Source");
+            if (ds != null && ds.Tables[0].Rows.Count > 0)
+            {
+                HSourceID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HItemID"].ToString());
+            }
+
+            //鎷兼帴涓存椂缁勬墭鏃讹紝鎵樻潯鐮佺殑鐢熸垚璇彞
+            sSQLMul = new string[2];
+            sSQLMul[0] = "insert into Gy_BarCodeBill (HBarCode,HBarCodeType,HMaterID,HUnitID,HQty" +
+                            ",HBatchNo,HSupID,HGroupID,HMaker,HMakeDate,HPrintQty,HinitQty" +
+                            ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HEndQty " +
+                            ",HBarcodeQtys,HBarcodeNo,HDeptID,HWhID,HSPID,HRemark " +
+                            ",HCusID,HCusType,HEndDate,HWorkLineName,HJiaYe " +
+                            ",HPressModel,HCusModel,HMaterialModel,HColor,HBarCodeDate " +
+                            ",HLogo,HPackageSize,HMaterialJQty,HMaterialMQty,HCustomBatchNo " +
+                            ",HSTOCKORGID,HOWNERID,HBeginDate,HSeOrderBillNo,HGBBarCode " +
+                            ",POOrderBillNo,HInterID,HInitSourceEntryID,HBarCode_Pack " +
+                            ",HMaterName,HMaterModel,HPinfan,HAuxPropID,HMTONo " +
+                            ",HCustomQty1,HLayerNumber,HCusBarCode,HBarCodeStatus,HSourceID " +
+                            ") values ("
+                            + "'" + textBox_HPackBarCode.Text + "','" + HBarCodeType + "',0,0,1"
+                            + ",'',0,0,'" + ClsPub.CurUserName + "',getdate(),0,1"
+                            + ",0,0,'','',''"
+                            + "," + HQty.ToString() + ",1,0,0,0,''"
+                            + ",0,'','','',''"
+                            + ",'','','','','" + sDate + "'"
+                            + ",'','',0,0,''"
+                            + "," + HOrgID.ToString() + "," + HOrgID.ToString() + ",'','',''"
+                            + ",''," + HInterID.ToString() + ",0,'" + textBox_HPackBarCode.Text + "'"
+                            + ",'','','',0,''"
+                            + ",0,0,'',''," + HSourceID +
+                            ")";
+            //鎷兼帴 鏇存柊 鎵樻潯鐮佹祦姘村彿 鐨剆ql璇彞
+            sSQLMul[1] = " exec h_p_WMS_SetMaxNo_QTY '" + sTMNumber + "'," + HQty.ToString() + " ";
+
+            if (sSQLMul.Length > 0)
+            {
+                //鎵ц鎵樻潯鐮佺殑鐢熸垚璇彞涓庢墭鏉$爜娴佹按鍙风殑鏇存柊璇彞
+                for (int i = 0; i < 1; i++)
+                {
+                    oCn.RunProc(sSQLMul[i]);
+                }
+
+                //閲嶆柊鍔犺浇鐣岄潰
+                getDisplay_grdSub();
+
+                setPackBarCodeBillData();
+
+                getDisplay_GrdMain();
+            }
+            else
+            {
+                MessageBox.Show("娌℃湁鏁版嵁锛�");
+                return;
+            }
+        }
+        #endregion
+
+        #region 鎵樻潯鐮� 鎵爜
+        private void textBox_HPackBarCode__KeyPress(object sender, KeyPressEventArgs e)
+        {
+            if (e.KeyChar == (char)Keys.Return)
+            {
+                //鑾峰彇鎵弿鐨勬墭鏉$爜
+                string HPackBarCode = textBox_HPackBarCode.Text;
+                //鏉$爜绫诲瀷
+                HBarCodeType = ClsPub.isStrNull(cmbHBarCodeType.Text);
+                //鑾峰彇缁勭粐淇℃伅
+                HOrgID = get_ORGANIZATIONSIDByName(cmbHOrgID.Text);
+                HOrgNumber = get_ORGANIZATIONSNOByName(cmbHOrgID.Text);
+
+                //澹版槑鐢ㄤ簬鏁版嵁搴撴煡璇㈢殑鍙橀噺
+                string sql = "";
+                DataSet ds;
+
+                //鍒ゆ柇 鎵樻潯鐮佹槸鍚﹀凡缁忕敓鎴愮粍鎵樺崟
+                sql = "select * from Sc_PackUnionBillMain where HBarCode_Pack = '" + HPackBarCode + "'";
+                ds = oCn.RunProcReturn(sql, "Sc_PackUnionBillMain");
+                if (ds != null && ds.Tables[0].Rows.Count > 0)
+                {
+                    MessageBox.Show("鎵樻潯鐮乕" + HPackBarCode + "]宸茬粡缁勬墭锛�");
+                    return;
+                }
+
+
+                //鑾峰彇褰撳墠浜х嚎
+                long HSourceID = 0;
+                sql = "select * from Gy_Source where HName = '" + comboBox_SourceNameParams.Text + "'";
+                ds = oCn.RunProcReturn(sql, "Gy_Source");
+                if (ds != null && ds.Tables[0].Rows.Count > 0)
+                {
+                    HSourceID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HItemID"].ToString());
+                }
+
+
+                //鑾峰彇缂撳瓨鍒楄〃涓� 鎵樻潯鐮� 瀵瑰簲鐨� 缁勬墭璁板綍
+                sql = "select top(1) a.* from Sc_PackUnionBill_Temp as a inner join Gy_BarCodeBill as b on a.HBarCode = b.HBarCode where a.HBarCode_Pack = '" + HPackBarCode + "' and b.HSourceID = " + HSourceID + " and a.HStockorgID = " + HOrgID;
+                ds = oCn.RunProcReturn(sql, "Sc_PackUnionBill_Temp");
+                if (ds == null || ds.Tables[0].Rows.Count == 0)
+                {
+                    MessageBox.Show("缂撳瓨鍒楄〃涓湭鏌ヨ鍒拌鎵樻潯鐮佷笌瀛愭潯鐮佺殑缁勬墭璁板綍锛�");
+                    return;
+                }
+                else
+                {
+                    string HBarCode_Pack = ds.Tables[0].Rows[0]["HBarCode_Pack"].ToString();
+                    long HBillID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[0]["HInterID"].ToString());
+                    string HBillNo = ds.Tables[0].Rows[0]["HBillNo"].ToString();
+
+                    textBox_HPackBarCode.Text = HBarCode_Pack;
+                    textBox_sBillID.Text = HBillID.ToString();
+                    textBox_sBillNo.Text = HBillNo;
+
+                    getDisplay_GrdMain();
+                }
+            }
+        }
+        #endregion
+        #endregion
+
+
     }
 }
 

--
Gitblit v1.9.1