示例#1
0
        public DataTable QuerySwitch(QueryType QT,
                                     ArrayList ParameterList
                                     )
        {
            
            CAA_BankMainDBO BankMain = new CAA_BankMainDBO(ref USEDB);
            DataTable Dt;

            try
            {
                switch (QT)
                {
                    case QueryType.ALL:
                        Dt = BankMain.doQueryAll();
                        break;
                    case QueryType.CODE:
                        Dt = BankMain.doQueryByCode(ParameterList);
                        break;
                    case QueryType.ID:
                        Dt = BankMain.doQueryByID(ParameterList);
                        break;
                    case QueryType.Custom:
                        Dt = BankMain.doQueryByFind(ParameterList);
                        break;
                    default:
                        Dt = new DataTable();
                        break;
                }

                return Dt;
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
示例#2
0
        //public DataTable BondReportDueNotYet(ArrayList ParameterList)
        //{
        //    try
        //    {
        //        CAA_BankMainDBO BankMain = new CAA_BankMainDBO(ref USEDB);
        //        return BankMain.doQueryDueNotYet(ParameterList);
        //    }
        //    catch (Exception ex)
        //    {
        //        throw ex;
        //    }

        //}

        //public DataTable BondReportDueYet(ArrayList ParameterList)
        //{
        //    try
        //    {
        //        CAA_BankMainDBO BankMain = new CAA_BankMainDBO(ref USEDB);
        //        return BankMain.doQueryDueYet(ParameterList);
        //    }
        //    catch (Exception ex)
        //    {
        //        throw ex;
        //    }

        //}

        //public DataTable BondReport(ArrayList ParameterList)
        //{
        //    try
        //    {
        //        CAA_BankMainDBO BankMain = new CAA_BankMainDBO(ref USEDB);
        //        return BankMain.doQueryBondRpt(ParameterList);
        //    }
        //    catch (Exception ex)
        //    {
        //        throw ex;
        //    }

        //}

        //public DataTable GetUser(ArrayList ParameterList)
        //{
        //    try
        //    {
        //        CAA_BankMainDBO BankMain = new CAA_BankMainDBO(ref USEDB);
        //        return BankMain.doQueryGetUser(ParameterList);
        //    }
        //    catch (Exception ex)
        //    {
        //        throw ex;
        //    }

        //}


        public DataTable QueryBankMainByCode(ArrayList ParameterList)
        {
            try
            {
                CAA_BankMainDBO BankMain = new CAA_BankMainDBO(ref USEDB);
                return BankMain.doQueryByCode(ParameterList);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }