private BETableCode AddToCollectionForGettingTableCode(BETableCode objs, IDataReader reader)
{
while (reader.Read())
{
NULLHandler nullHandler = new NULLHandler(reader);
objs.MaxID = nullHandler.GetInt("maxid");
objs.CodeLength = nullHandler.GetInt("CodeLength");
}
return(objs);
}
public string GetTableCode(SQLHelper sqlHelper, string tableName)
{
string code = string.Empty;
string sql = string.Empty;
try
{
BETableCode beTableCode = new BETableCode();
sql = sqlHelper.MakeSQL("SELECT maxid, CodeLength FROM tblTableCode "
+ "WHERE upper(TableName) = $s", tableName.ToUpper());
IDataReader reader = sqlHelper.ExecuteQuery(sql);
AddToCollectionForGettingTableCode(beTableCode, reader);
code = (beTableCode.MaxID + 1).ToString().PadLeft(beTableCode.CodeLength, '0');
return(code);
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
}
