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); }