bard

获取条码序列与生成代码

最新推荐文章于 2025-07-03 22:41:50 发布

原创最新推荐文章于 2025-07-03 22:41:50 发布 · 663 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#string

public string GetBarCodeFordata(string prefix, int shopNum, int iLogoID)
        {
            string strsql = "";
            string sBarCodes = "";
            int jcount = 1;
            int iResult = 0;
            int iResult1 = 0;
            int iMaxLogoNum = 0;
            string sMaxLogoNum = "";
            int iLogoNum = 0;
            int iMaxNum = 0;

            for (int m = 0; m < iLogoID; m++)
            {
                sMaxLogoNum += "9";
            }
            iMaxLogoNum = int.Parse(sMaxLogoNum);
            if (shopNum > iMaxLogoNum)
            {
                return "";
            }
            for (int i = 0; i < shopNum; i++)
            {
                //未使用的条码序号次序
                for (int j = jcount; j <= iMaxLogoNum; j++)
                {
                    try
                    {
                        strsql = "select count(*) from [BarCode] where [preFix]='{0}' and [LoID]={1} and [LoNum]={2} ";
                        strsql = string.Format(strsql, prefix, iLogoID, j);
                        iResult = int.Parse(SQLHelperSQL.GetSingle(strsql).ToString());
                    }
                    catch { }
                    if (iResult == 0)
                    {
                        if (sBarCodes == "")
                        {
                            sBarCodes = jcount.ToString();
                        }
                        else
                        {
                            sBarCodes += "," + jcount.ToString();
                        }
                        jcount = j;
                        jcount++;
                        break;
                    }
                    jcount++;
                }
                //Recode
                if (jcount == iMaxLogoNum)
                {
                    if (shopNum > sBarCodes.TrimEnd(',').Split(',').Length)
                    {   //申请数量小于生成的代码
                        for (int l = sBarCodes.TrimEnd(',').Split(',').Length + 1; l < shopNum; l++)
                        {//最后剩余的代码
                            for (int k = 0; k <= iMaxLogoNum; k++)
                            {
                                try
                                {
                                    strsql = "select count(*) from [BarCode] where preFix='{0}' and LoID={1} and LoNum={2} and isnull(Isvalid,0)=0";
                                    strsql = string.Format(strsql, prefix, iLogoID, k);
                                    iResult = int.Parse(SQLHelper.GetSingle(strsql).ToString());
                                }
                                catch { }
                                if (iResult == 0)
                                {
                                    if (sBarCodes == "")
                                    {
                                        sBarCodes = jcount.ToString();
                                    }
                                    else
                                    {
                                        sBarCodes += "," + jcount.ToString();
                                    }
                                    break;
                                }
                            }
                        }
                    }
                }
            }
            return sBarCodes;
        }
        #endregion

        string sLogoNum = class.GetBarCodeData(prefixNumber, 1, 6);
                                                int iLogoNum = int.Parse(sLogoNum);
                                                int GetLength = 6 - sLogoNum.Length;
                                                for (int m = 0; m < GetLength; m++)
                                                {
                                                    sLogoNum = "0" + sLogoNum;
                                                }

string BarNO = prefixNumber + sLogoNum;