public string GenerateAutoID(string PrefixString, string TableName, string TableFieldName)
{
double ICount;
oDataSet = new DataSet();
oDataSet = SQLResult("Select " + TableFieldName + " from " + TableName + " where " + TableFieldName + " like '%" + PrefixString + "%' order by right(" + TableFieldName + ",5)");
if (oDataSet.Tables[0].Rows.Count > 0)
{
ICount = int.Parse(oDataSet.Tables[0].Rows[oDataSet.Tables[0].Rows.Count - 1][0].ToString().Substring(PrefixString.Length, 5)) + 1;
PrefixString = PrefixString + ICount.ToString("00000");
}
else
{
PrefixString = PrefixString + "00001";
}
return(PrefixString);
}
public string GenerateAutoID(string PrefixString, string TableName, string TableFieldName, int StringLength, string AdditionalWhere)
{
double ICount;
oDataSet = new DataSet();
oDataSet = SQLResult("Select " + TableFieldName + " from " + TableName + " where " + TableFieldName + " like '%" + PrefixString + "%' and " + AdditionalWhere + "order by right(" + TableFieldName + "," + StringLength + ")");
if (oDataSet.Tables[0].Rows.Count > 0)
{
ICount = int.Parse(oDataSet.Tables[0].Rows[oDataSet.Tables[0].Rows.Count - 1][0].ToString().Substring(PrefixString.Length, StringLength)) + 1;
PrefixString = PrefixString + ICount.ToString().PadLeft(StringLength, '0');
}
else
{
ICount = 1;
PrefixString = PrefixString + ICount.ToString().PadLeft(StringLength, '0');
}
return(PrefixString);
}
public string GenerateAutoID(string PrefixString, string TableName, string TableFieldName, int StringLength, SqlConnection oSqlConnection, SqlTransaction oSqlTransaction)
{
double ICount;
oDataSet = new DataSet();
oCResult = SQLResult("Select " + TableFieldName + " from " + TableName + " where " + TableFieldName + " like '%" + PrefixString + "%' order by right(" + TableFieldName + "," + StringLength + ")", oSqlConnection, oSqlTransaction);
oDataSet = (DataSet)oCResult.Data;
if (oDataSet.Tables[0].Rows.Count > 0)
{
ICount = int.Parse(oDataSet.Tables[0].Rows[oDataSet.Tables[0].Rows.Count - 1][0].ToString().Substring(PrefixString.Length, StringLength)) + 1;
PrefixString = PrefixString + ICount.ToString().PadLeft(StringLength, '0');
}
else
{
ICount = 1;
PrefixString = PrefixString + ICount.ToString().PadLeft(StringLength, '0');
}
return(PrefixString);
}