Set RS1 = GetSQLRecordset(strSQL, "../../data/xgw1.mdb", "固定资产帐")
if rs1.eof then
num1="0000000001" '验收单号
else
num1=right("000000000"&(Rs1("申购单号")+1),10)
end if num1那个是什么算法?
if rs1.eof then
num1="0000000001" '验收单号
else
num1=right("000000000"&(Rs1("申购单号")+1),10)
end if num1那个是什么算法?
num1="0000000001" '验收单号
else
num1=right("000000000"&(Rs1("申购单号")+1),10)
取得数据库字段"申购单号"的值Rs1("申购单号"),让它加1,然后前面补10个0,然后取右边的10,这样就保证取到数据库单号,加1就相当于递增,加10个0是为了补足10,取右边10位是把不用的0去掉
end if
{
Int32 int32Temp;
string strNumber; strNumber = strTempClientID.Substring (8, 8);
int32Temp = Convert.ToInt32 (strNumber);
int32Temp = int32Temp + 1;
strNumber = System.Convert.ToString(int32Temp);
if (strNumber.Length == 7) strNumber = "0" + strNumber;
if (strNumber.Length == 6) strNumber = "00" + strNumber;
if (strNumber.Length == 5) strNumber = "000" + strNumber;
if (strNumber.Length == 4) strNumber = "0000" + strNumber;
if (strNumber.Length == 3) strNumber = "00000" + strNumber;
if (strNumber.Length == 2) strNumber = "000000" + strNumber;
if (strNumber.Length == 1) strNumber = "0000000" + strNumber;
strTempClientID = "";
strTempClientID = "SystemNO" + strNumber;
}