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;