public aers_sys_seed SeedFind(string TableName)
{
String stmtId = "aers_sys_seed_Find";
Hashtable ht = new Hashtable();
ht.Add("TableName", TableName);
aers_sys_seed result = ExecuteQueryForObject <aers_sys_seed>(stmtId, ht);
return(result);
}
public string GetMaxID(string TableName)
{
try
{
string result = "";
String stmtId = "aers_sys_seed_Find";
Hashtable ht = new Hashtable();
ht.Add("TableName", TableName);
aers_sys_seed seedEntity = ExecuteQueryForObject <aers_sys_seed>(stmtId, ht);
if (seedEntity == null)
{
seedEntity = new aers_sys_seed();
seedEntity.TableName = TableName;
seedEntity.MaxNo = 1;
seedEntity.Length = 10;
seedEntity.Prefix = "";
SeedInsert(seedEntity);
result = seedEntity.MaxNo.ToString().PadLeft(seedEntity.Length, '0');
}
else
{
seedEntity.MaxNo++;
string prefix = string.Empty;
if (!string.IsNullOrEmpty(seedEntity.Prefix))
{
prefix = seedEntity.Prefix;
}
SeedUpdate(seedEntity);
result = prefix + seedEntity.MaxNo.ToString().PadLeft(seedEntity.Length - prefix.Length, '0');
}
return(result);
}
catch (Exception)
{
throw;
}
}
public void SeedUpdate(aers_sys_seed seed)
{
String stmtId = "aers_sys_seed_Update";
ExecuteUpdate(stmtId, seed);
}
public void SeedInsert(aers_sys_seed seed)
{
String stmtId = "aers_sys_seed_Insert";
ExecuteInsert(stmtId, seed);
}
