예제 #1
0
        public DataTable QuerySwitch(QueryType QT,
                                     ArrayList ParameterList
                                     )
        {
            DBO.TRN_BoxnumDBO dbo = new TRN_BoxnumDBO(ref USEDB);

            DataTable Dt;

            try
            {
                switch (QT)
                {
                    case QueryType.ALL:
                        Dt = dbo.doQueryAll();
                        break;
                    case QueryType.CODE:
                        Dt = dbo.doQueryByCode(ParameterList);
                        break;
                    case QueryType.ID:
                        Dt = dbo.doQueryByID(ParameterList);
                        break;

                    default:
                        Dt = new DataTable();
                        break;
                }

                return Dt;
            }
            catch (Exception ex)
            {
                throw ex;
            }
예제 #2
0
        public DataTable QueryByALL()
        {
            try
            {
                DBO.TRN_BoxnumDBO dbo = new TRN_BoxnumDBO(ref USEDB);
                return dbo.doQueryAll();
            }
            catch (Exception ex)
            {
                throw ex;
            }