예제 #1
0
        public DataTable QuerySwitch(QueryType QT, ArrayList ParameterList)
        {
            DBO.VDS_CRM_CHANMSG_MAIN_DBO VCCM = new VDS_CRM_CHANMSG_MAIN_DBO(ref USEDB);
            DBO.VDS_CRM_CHANMSG_DETL_DBO VCCD = new VDS_CRM_CHANMSG_DETL_DBO(ref USEDB);

            DataTable Dt;

            try
            {
                switch (QT)
                {
                    case QueryType.CRM121_Query_All:
                        Dt = VCCM.do_CRM121_Query_All(ParameterList);
                        break;
                    case QueryType.CODE:
                        Dt = VCCM.doQueryByCode(ParameterList);
                        break;
                    case QueryType.ID:
                        Dt = VCCM.doQueryByID(ParameterList);
                        break;
                    case QueryType.Custom:
                        Dt = VCCM.doQueryByFind(ParameterList);
                        break;
                    case QueryType.CRM122_DETL_Schema:
                        Dt = VCCD.do_CRM122_DETL_Schema();
                        break;
                    case QueryType.CRM122_Query_Master_By_ID:
                        Dt = VCCM.doQueryByID(ParameterList);
                        break;
                    case QueryType.CRM122_Query_Detail_By_ID:
                        Dt = VCCD.doQueryByID(ParameterList);
                        break;
                    default:
                        Dt = new DataTable();
                        break;
                }

                return Dt;
            }
            catch (Exception ex)
            {
                throw GetNewException(ex);
            }
        }