Esempio n. 1
0
        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();
            }
        }
Esempio n. 2
0
        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);
        }