From f05241b1842a8ede2f9b3442feda78ac98fbd4a7 Mon Sep 17 00:00:00 2001
From: duhe <226547893@qq.com>
Date: 星期一, 29 四月 2024 14:08:38 +0800
Subject: [PATCH] 1.(紧急)产品条码 条码编号规则:规格型号+流水号(原本流水号是做工单区分的,现在将工单区分取消,当天同一物料的流水号递增)
---
WarM/条码打印/Gy_BarCodeBill_automaticallyByPLC_New.cs | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git "a/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_BarCodeBill_automaticallyByPLC_New.cs" "b/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_BarCodeBill_automaticallyByPLC_New.cs"
index b681710..562503e 100644
--- "a/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_BarCodeBill_automaticallyByPLC_New.cs"
+++ "b/WarM/\346\235\241\347\240\201\346\211\223\345\215\260/Gy_BarCodeBill_automaticallyByPLC_New.cs"
@@ -794,6 +794,7 @@
{
HWei = ClsPub.isStrNull(grdSub.Rows[i].Cells[HWeiCol].Value);
HBarCode = ClsPub.isStrNull(grdSub.Rows[i].Cells[HTMCol].Value);
+ HBarCode = ClsPub.isStrNull(grdSub.Rows[i].Cells[HMaterModel2Col].Value) + ClsPub.isStrNull(grdSub.Rows[i].Cells[HBatchNo2Col].Value);
//
HBarCodeType = ClsPub.isStrNull(cmbHBarCodeType.Text);
HMaterID = ClsPub.isLong(grdSub.Rows[i].Cells[HMaterID2Col].Value);
@@ -917,7 +918,7 @@
string LIU = "";
int LEN = 4;
DataSet ds;
- string sql = "select * from h_v_IF_BarCodeBillList Where 婧愬崟鍗曞彿 ='" + grdMain.Rows[0].Cells[HSourceBillNoCol].Value + "' and HMaterID = " + grdMain.Rows[0].Cells[HMaterIDCol].Value + " and HSTOCKORGID = " + HOrgID + " and CONVERT(varchar(100),鏉$爜鏃ユ湡, 23) = '" + HDate + "' order by 鎵瑰彿 desc";
+ string sql = "select * from h_v_IF_BarCodeBillList Where HMaterID = " + grdMain.Rows[0].Cells[HMaterIDCol].Value + " and HSTOCKORGID = " + HOrgID + " and CONVERT(varchar(100),鏉$爜鏃ユ湡, 23) = '" + HDate + "' order by 鎵瑰彿 desc";
ds = oCn.RunProcReturn(sql, "h_v_IF_BarCodeBillList");
if (ds != null)
{
--
Gitblit v1.9.1