条码自动生成：生成条码时，条码流水号控制不进行重复

duhe

2024-11-07 b11e68a85e822c6fe8513e18e0eea823181603c9

条码自动生成：生成条码时，条码流水号控制不进行重复

 WarM/条码打印/Gy_BarCodeBill_automaticallyByPLC_New.cs

@@ -1038,7 +1038,29 @@
            //鎷兼帴鎵瑰彿
            HBarCode_MaxNo = sYear + sPeriod + sDay + LIU;

            return HBarCode_MaxNo;
            long HBarCode_MaxNo_long = long.Parse(HBarCode_MaxNo);

            while (true)
            {
                int HCount_BarCodeBillList = 0;
                int HCount_SubBarCodeBill = 0;
                string sql_confirm = "select * from h_v_IF_BarCodeBillList where 鏉＄爜缂栧彿 = '" + (ClsPub.isStrNull(grdSub.Rows[0].Cells[HMaterModel2Col].Value) + HBarCode_MaxNo_long.ToString()) + "' and 鏉＄爜绫诲瀷 = '鍞竴鏉＄爜'" + " and CONVERT(varchar(100),鏉＄爜鏃ユ湡, 23) = '" + HDate + "'";
                ds = oCn.RunProcReturn(sql_confirm, "h_v_IF_BarCodeBillList");
                HCount_BarCodeBillList = ds.Tables[0].Rows.Count;
                sql_confirm = "select * from Gy_BarCodeBill_SWELL_SubBarCodeBill Where HBarCode = '" + (ClsPub.isStrNull(grdSub.Rows[0].Cells[HMaterModel2Col].Value) + HBarCode_MaxNo_long.ToString()) + "' and HBarCodeType = '鍞竴鏉＄爜'" + " and CONVERT(varchar(100),HMakeDate, 23) = '" + HDate + "'";
                ds = oCn.RunProcReturn(sql_confirm, "Gy_BarCodeBill_SWELL_SubBarCodeBill");
                HCount_SubBarCodeBill = ds.Tables[0].Rows.Count;
                if (HCount_BarCodeBillList + HCount_SubBarCodeBill > 0)
                {
                    HBarCode_MaxNo_long += 1;
                }
                else
                {
                    break;
                }
            }

            return HBarCode_MaxNo_long.ToString();
        }
        #endregion