public new IEntity GetById(IEntity en)
{
try
{
OpenConnection();
GeneralSetup e = (GeneralSetup)en;
MySql.Data.MySqlClient.MySqlCommand aCommand = new MySql.Data.MySqlClient.MySqlCommand(e.GetByIDSQL(e.GetID()), m_connection);
MySql.Data.MySqlClient.MySqlDataReader aReader = aCommand.ExecuteReader();
GeneralSetup a = (GeneralSetup)e.Get(aReader);
aReader.Close();
a.START_ENTRY_PERIOD = PeriodRepository.FindPeriod(aCommand, a.START_ENTRY_PERIOD.ID);
aCommand.CommandText = AutoNumberSetup.GetAllSQLStatic();
aReader = aCommand.ExecuteReader();
IList lst = AutoNumberSetup.GetAllStatic(aReader);
aReader.Close();
foreach (AutoNumberSetup s in lst)
{
a.AUTONUMBER_LIST.Add(s.FORM_CODE, s);
}
return(a);
}
catch (Exception x)
{
throw new Exception(getErrorMessage(x));
}
finally
{
m_connection.Close();
}
}
internal static GeneralSetup GetGeneralSetup(MySql.Data.MySqlClient.MySqlCommand cmd)
{
GeneralSetup e = new GeneralSetup();
cmd.CommandText = GeneralSetup.GetAllSQLStatic();
MySql.Data.MySqlClient.MySqlDataReader aReader = cmd.ExecuteReader();
GeneralSetup a = (GeneralSetup)e.Get(aReader);
aReader.Close();
cmd.CommandText = AutoNumberSetup.GetAllSQLStatic();
aReader = cmd.ExecuteReader();
IList lst = AutoNumberSetup.GetAllStatic(aReader);
aReader.Close();
foreach (AutoNumberSetup s in lst)
{
a.AUTONUMBER_LIST.Add(s.FORM_CODE, s);
}
a.START_ENTRY_PERIOD = PeriodRepository.FindPeriod(cmd, a.START_ENTRY_PERIOD.ID);
return(a);
}