C# DatabaseConversion类代码示例

        /// <summary>
        /// Custom mapper function for turnoverdetail table
        /// </summary>
        /// <param name="source"></param>
        /// <returns></returns>
        protected DatabaseConversion.CleanerTool.BOALedgerDataAccess.turnoverdetail CustomMapper_turnoverdetail(DatabaseConversion.CleanerTool.EclipseDataAccess.turnoverdetail source)
        {
            //
            // Initialize result
            DatabaseConversion.CleanerTool.BOALedgerDataAccess.turnoverdetail destination = new DatabaseConversion.CleanerTool.BOALedgerDataAccess.turnoverdetail();
            //
            // Set basic properties
            destination.minval = source.minval;
            destination.maxval = source.maxval;
            destination.IndCounter = source.IndCounter;
            destination.OrgCounter = source.OrgCounter;
            destination.ent_id = source.ent_id;
            destination.ent_name = source.ent_name;
            destination.spid = source.spid;

            //
            // Return result
            return destination;
        }

        /// <summary>
        /// Custom mapper function for BrokerFeeDefaults table
        /// </summary>
        /// <param name="source"></param>
        /// <returns></returns>
        protected DatabaseConversion.CleanerTool.BOALedgerDataAccess.BrokerFeeDefaults CustomMapper_BrokerFeeDefaults(DatabaseConversion.CleanerTool.EclipseDataAccess.BrokerFeeDefaults source)
        {
            //
            // Initialize result
            DatabaseConversion.CleanerTool.BOALedgerDataAccess.BrokerFeeDefaults destination = new DatabaseConversion.CleanerTool.BOALedgerDataAccess.BrokerFeeDefaults();
            //
            // Set basic properties
            destination.bfd_id = source.bfd_id;
            destination.bfd_branchId = source.bfd_branchId;
            destination.bfd_brokerRepId = source.bfd_brokerRepId;
            destination.bfd_classOfBusinessId = source.bfd_classOfBusinessId;
            destination.bfd_newBusinessWorkbookTypeId = source.bfd_newBusinessWorkbookTypeId;
            destination.bfd_renewalWorkbookTypeId = source.bfd_renewalWorkbookTypeId;
            destination.bfd_renewalTransferWorkbookTypeId = source.bfd_renewalTransferWorkbookTypeId;
            destination.bfd_positiveEndorsementWorkbookTypeId = source.bfd_positiveEndorsementWorkbookTypeId;
            destination.bfd_negativeEndorsementWorkbookTypeId = source.bfd_negativeEndorsementWorkbookTypeId;
            destination.bfd_cancellationWorkbookTypeId = source.bfd_cancellationWorkbookTypeId;

            //
            // Return result
            return destination;
        }

        /// <summary>
        /// Custom mapper function for BrokerFeeDefaultWorkbookType table
        /// </summary>
        /// <param name="source"></param>
        /// <returns></returns>
        protected DatabaseConversion.CleanerTool.BOALedgerDataAccess.BrokerFeeDefaultWorkbookType CustomMapper_BrokerFeeDefaultWorkbookType(DatabaseConversion.CleanerTool.EclipseDataAccess.BrokerFeeDefaultWorkbookType source)
        {
            //
            // Initialize result
            DatabaseConversion.CleanerTool.BOALedgerDataAccess.BrokerFeeDefaultWorkbookType destination = new DatabaseConversion.CleanerTool.BOALedgerDataAccess.BrokerFeeDefaultWorkbookType();
            //
            // Set basic properties
            destination.bfdwt_id = source.bfdwt_id;
            destination.bfdwt_auto = source.bfdwt_auto;
            destination.bfdwt_percentage = source.bfdwt_percentage;
            destination.bfdwt_basisId = source.bfdwt_basisId;
            destination.bfdwt_default = source.bfdwt_default;
            destination.bfdwt_minimum = source.bfdwt_minimum;
            destination.bfdwt_maximum = source.bfdwt_maximum;
            destination.bfdwt_amend = source.bfdwt_amend;

            //
            // Return result
            return destination;
        }

        /// <summary>
        /// Custom mapper function for banking table
        /// </summary>
        /// <param name="source"></param>
        /// <returns></returns>
        protected DatabaseConversion.CleanerTool.BOALedgerDataAccess.banking CustomMapper_banking(DatabaseConversion.CleanerTool.EclipseDataAccess.banking source)
        {
            //
            // Initialize result
            DatabaseConversion.CleanerTool.BOALedgerDataAccess.banking destination = new DatabaseConversion.CleanerTool.BOALedgerDataAccess.banking();
            //
            // Set basic properties
            destination.bank_id = source.bank_id;
            destination.bank_time = source.bank_time;
            destination.bank_status = source.bank_status;
            destination.bank_financial_institution = source.bank_financial_institution;

            //
            // Return result
            return destination;
        }

        /// <summary>
        /// Custom mapper function for branches table
        /// </summary>
        /// <param name="source"></param>
        /// <returns></returns>
        protected DatabaseConversion.CleanerTool.BOALedgerDataAccess.branches CustomMapper_branches(DatabaseConversion.CleanerTool.EclipseDataAccess.branches source)
        {
            //
            // Initialize result
            DatabaseConversion.CleanerTool.BOALedgerDataAccess.branches destination = new DatabaseConversion.CleanerTool.BOALedgerDataAccess.branches();
            //
            // Set basic properties
            destination.bra_id = source.bra_id;
            destination.bra_created_who = source.bra_created_who;
            destination.bra_created_when = source.bra_created_when;
            destination.bra_updated_who = source.bra_updated_who;
            destination.bra_updated_when = source.bra_updated_when;
            destination.bra_name = source.bra_name;
            destination.bra_desc = source.bra_desc;
            destination.bra_inactive = source.bra_inactive;
            destination.bra_address_1 = source.bra_address_1;
            destination.bra_address_2 = source.bra_address_2;
            destination.bra_address_3 = source.bra_address_3;
            destination.bra_suburb = source.bra_suburb;
            destination.bra_state = source.bra_state;
            destination.bra_postcode = source.bra_postcode;
            destination.bra_telephone = source.bra_telephone;
            destination.bra_telephone_2 = source.bra_telephone_2;
            destination.bra_mobile = source.bra_mobile;
            destination.bra_facsimile = source.bra_facsimile;
            destination.bra_email = source.bra_email;
            destination.bra_web_site = source.bra_web_site;
            destination.bra_trading_as = source.bra_trading_as;
            destination.bra_parent_branch = source.bra_parent_branch;
            destination.bra_asic_branch = source.bra_asic_branch;
            destination.bra_cr_closing_opt = source.bra_cr_closing_opt;
            destination.bra_cr_receipting_opt = source.bra_cr_receipting_opt;
            destination.bra_branch_id = source.bra_branch_id;
            destination.bra_company_name = source.bra_company_name;
            destination.bra_ABN = source.bra_ABN;
            destination.bra_logo = source.bra_logo;

            //
            // Return result
            return destination;
        }

        /// <summary>
        /// Custom mapper function for write_off table
        /// </summary>
        /// <param name="source"></param>
        /// <returns></returns>
        protected DatabaseConversion.CleanerTool.BOALedgerDataAccess.write_off CustomMapper_write_off(DatabaseConversion.CleanerTool.EclipseDataAccess.write_off source)
        {
            //
            // Initialize result
            DatabaseConversion.CleanerTool.BOALedgerDataAccess.write_off destination = new DatabaseConversion.CleanerTool.BOALedgerDataAccess.write_off();
            //
            // Set basic properties
            destination.wo_id = source.wo_id;
            destination.wo_inv_tran_id = source.wo_inv_tran_id;
            destination.wo_debtor_creditor = source.wo_debtor_creditor;
            destination.wo_entity_id = source.wo_entity_id;
            destination.wo_amount = source.wo_amount;
            destination.wo_gst = source.wo_gst;
            destination.wo_tran_id = source.wo_tran_id;
            destination.wo_Created_who = source.wo_Created_who;
            destination.wo_Created_when = source.wo_Created_when;

            //
            // Return result
            return destination;
        }

        /// <summary>
        /// Custom mapper function for AutoRoundingValues table
        /// </summary>
        /// <param name="source"></param>
        /// <returns></returns>
        protected DatabaseConversion.CleanerTool.BOALedgerDataAccess.AutoRoundingValues CustomMapper_AutoRoundingValues(DatabaseConversion.CleanerTool.EclipseDataAccess.AutoRoundingValues source)
        {
            //
            // Initialize result
            DatabaseConversion.CleanerTool.BOALedgerDataAccess.AutoRoundingValues destination = new DatabaseConversion.CleanerTool.BOALedgerDataAccess.AutoRoundingValues();
            //
            // Set basic properties
            destination.arv_id = source.arv_id;
            destination.arv_value = source.arv_value;

            //
            // Return result
            return destination;
        }

        /// <summary>
        /// Custom mapper function for atura_super_users table
        /// </summary>
        /// <param name="source"></param>
        /// <returns></returns>
        protected DatabaseConversion.CleanerTool.BOALedgerDataAccess.atura_super_users CustomMapper_atura_super_users(DatabaseConversion.CleanerTool.EclipseDataAccess.atura_super_users source)
        {
            //
            // Initialize result
            DatabaseConversion.CleanerTool.BOALedgerDataAccess.atura_super_users destination = new DatabaseConversion.CleanerTool.BOALedgerDataAccess.atura_super_users();
            //
            // Set basic properties
            destination.atsup_uname = source.atsup_uname;

            //
            // Return result
            return destination;
        }

        /// <summary>
        /// Custom mapper function for vims_asic_iba table
        /// </summary>
        /// <param name="source"></param>
        /// <returns></returns>
        protected DatabaseConversion.CleanerTool.BOALedgerDataAccess.vims_asic_iba CustomMapper_vims_asic_iba(DatabaseConversion.CleanerTool.EclipseDataAccess.vims_asic_iba source)
        {
            //
            // Initialize result
            DatabaseConversion.CleanerTool.BOALedgerDataAccess.vims_asic_iba destination = new DatabaseConversion.CleanerTool.BOALedgerDataAccess.vims_asic_iba();
            //
            // Set basic properties
            destination.fld77 = source.fld77;
            destination.fld79 = source.fld79;
            destination.fld80 = source.fld80;
            destination.fld81 = source.fld81;
            destination.fld85 = source.fld85;
            destination.fld86 = source.fld86;
            destination.fld87a = source.fld87a;
            destination.fld87b = source.fld87b;
            destination.fld88 = source.fld88;
            destination.fld92 = source.fld92;
            destination.fld93 = source.fld93;
            destination.fld95 = source.fld95;
            destination.fld95chk = source.fld95chk;
            destination.diff = source.diff;
            destination.spid = source.spid;

            //
            // Return result
            return destination;
        }

        /// <summary>
        /// Custom mapper function for UserConfigOptions table
        /// </summary>
        /// <param name="source"></param>
        /// <returns></returns>
        protected DatabaseConversion.CleanerTool.BOALedgerDataAccess.UserConfigOptions CustomMapper_UserConfigOptions(DatabaseConversion.CleanerTool.EclipseDataAccess.UserConfigOptions source)
        {
            //
            // Initialize result
            DatabaseConversion.CleanerTool.BOALedgerDataAccess.UserConfigOptions destination = new DatabaseConversion.CleanerTool.BOALedgerDataAccess.UserConfigOptions();
            //
            // Set basic properties
            destination.nUserConfigOptionId = source.nUserConfigOptionId;
            destination.strUsername = source.strUsername;
            destination.strOption = source.strOption;
            destination.strOptionId = source.strOptionId;

            //
            // Return result
            return destination;
        }

        /// <summary>
        /// Custom mapper function for UserWebServiceLogin table
        /// </summary>
        /// <param name="source"></param>
        /// <returns></returns>
        protected DatabaseConversion.CleanerTool.BOALedgerDataAccess.UserWebServiceLogin CustomMapper_UserWebServiceLogin(DatabaseConversion.CleanerTool.EclipseDataAccess.UserWebServiceLogin source)
        {
            //
            // Initialize result
            DatabaseConversion.CleanerTool.BOALedgerDataAccess.UserWebServiceLogin destination = new DatabaseConversion.CleanerTool.BOALedgerDataAccess.UserWebServiceLogin();
            //
            // Set basic properties
            destination.Id = source.Id;
            destination.UserName = source.UserName;
            destination.SvuUserName = source.SvuUserName;

            //
            // Return result
            return destination;
        }

        /// <summary>
        /// Custom mapper function for UserConfig table
        /// </summary>
        /// <param name="source"></param>
        /// <returns></returns>
        protected DatabaseConversion.CleanerTool.BOALedgerDataAccess.UserConfig CustomMapper_UserConfig(DatabaseConversion.CleanerTool.EclipseDataAccess.UserConfig source)
        {
            //
            // Initialize result
            DatabaseConversion.CleanerTool.BOALedgerDataAccess.UserConfig destination = new DatabaseConversion.CleanerTool.BOALedgerDataAccess.UserConfig();
            //
            // Set basic properties
            destination.nUserConfigId = source.nUserConfigId;
            destination.strUsername = source.strUsername;
            destination.nSalesTeam = source.nSalesTeam;
            destination.nSalesTeamOverride = source.nSalesTeamOverride;
            destination.nServiceTeam = source.nServiceTeam;
            destination.nServiceTeamOverride = source.nServiceTeamOverride;
            destination.nBrokerRep = source.nBrokerRep;
            destination.nBrokerRepOverride = source.nBrokerRepOverride;
            destination.nAccountType = source.nAccountType;
            destination.nAccountTypeOverride = source.nAccountTypeOverride;
            destination.nDefaultSearch = source.nDefaultSearch;
            destination.nNumPerPanelTasks = source.nNumPerPanelTasks;
            destination.nWithinDaysTasks = source.nWithinDaysTasks;
            destination.nPopupReminder = source.nPopupReminder;
            destination.nPopupFrequency = source.nPopupFrequency;
            destination.nShowPoliciesDue = source.nShowPoliciesDue;
            destination.nNumPerPanelPol = source.nNumPerPanelPol;
            destination.nWithinDaysPol = source.nWithinDaysPol;
            destination.nShowOutstandingDebt = source.nShowOutstandingDebt;
            destination.nNumPerPanelOD = source.nNumPerPanelOD;
            destination.nDaysOverdueOD = source.nDaysOverdueOD;
            destination.nEntityRole = source.nEntityRole;
            destination.nBranch = source.nBranch;
            destination.nClassification = source.nClassification;
            destination.nEntityRoleOverride = source.nEntityRoleOverride;
            destination.nBranchOverride = source.nBranchOverride;
            destination.nClassificationOverride = source.nClassificationOverride;
            destination.nShowTransactionsOutside = source.nShowTransactionsOutside;
            destination.nWithinDaysTranOut = source.nWithinDaysTranOut;
            destination.nAdvanceQueueManagement = source.nAdvanceQueueManagement;
            destination.nAllowReopeningTask = source.nAllowReopeningTask;
            destination.nAllowReopeningClaims = source.nAllowReopeningClaims;
            destination.nCloseTaskByWindow = source.nCloseTaskByWindow;
            destination.nCloseTaskByClose = source.nCloseTaskByClose;
            destination.nAccessBankDetails = source.nAccessBankDetails;
            destination.nAmendBankDetails = source.nAmendBankDetails;
            destination.nAllowUpdateClientTask = source.nAllowUpdateClientTask;
            destination.nAllowDeleteClientTask = source.nAllowDeleteClientTask;
            destination.nAllowReOpenClientTask = source.nAllowReOpenClientTask;
            destination.nAllowUpdateClientNotes = source.nAllowUpdateClientNotes;
            destination.nAllowUpdateClientDOC = source.nAllowUpdateClientDOC;
            destination.nAllowDeleteClientNotes = source.nAllowDeleteClientNotes;
            destination.nAllowDeleteClientDOC = source.nAllowDeleteClientDOC;
            destination.nAllowUpdateClaimTask = source.nAllowUpdateClaimTask;
            destination.nAllowDeleteClaimTask = source.nAllowDeleteClaimTask;
            destination.nAllowReOpenClaimTask = source.nAllowReOpenClaimTask;
            destination.nAllowUpdateClaimNotes = source.nAllowUpdateClaimNotes;
            destination.nAllowUpdateClaimDOC = source.nAllowUpdateClaimDOC;
            destination.nAllowDeleteClaimNotes = source.nAllowDeleteClaimNotes;
            destination.nAllowDeleteClaimDOC = source.nAllowDeleteClaimDOC;
            destination.nAllowUpdatePolicyTask = source.nAllowUpdatePolicyTask;
            destination.nAllowDeletePolicyTask = source.nAllowDeletePolicyTask;
            destination.nAllowReOpenPolicyTask = source.nAllowReOpenPolicyTask;
            destination.nAllowUpdatePolicyNotes = source.nAllowUpdatePolicyNotes;
            destination.nAllowUpdatePolicyDOC = source.nAllowUpdatePolicyDOC;
            destination.nAllowDeletePolicyNotes = source.nAllowDeletePolicyNotes;
            destination.nAllowDeletePolicyDOC = source.nAllowDeletePolicyDOC;
            destination.nSubBranchOverride = source.nSubBranchOverride;
            destination.nTaskFor = source.nTaskFor;
            destination.nDisplayIncome = source.nDisplayIncome;
            destination.nDisplayGrossIncome = source.nDisplayGrossIncome;
            destination.nDisplayNetIncome = source.nDisplayNetIncome;
            destination.nDisplayARIncome = source.nDisplayARIncome;
            destination.DefaultIncome = source.DefaultIncome;
            destination.nAllowCashReceiptClosingOption = source.nAllowCashReceiptClosingOption;
            destination.strSVUUsername = source.strSVUUsername;
            destination.nAllowPostedWorkbookUpdate = source.nAllowPostedWorkbookUpdate;
            destination.nValidateBankDetails = source.nValidateBankDetails;
            destination.nHideDueTasks = source.nHideDueTasks;
            destination.strUserDetailsName = source.strUserDetailsName;
            destination.strUserDetailsEmail = source.strUserDetailsEmail;
            destination.strTasksDefaultQueue = source.strTasksDefaultQueue;
            destination.nDisplayClaimTasks = source.nDisplayClaimTasks;
            destination.nDisplayClientTasks = source.nDisplayClientTasks;
            destination.nDisplayPolicyTasks = source.nDisplayPolicyTasks;
            destination.nShowOutstandingClaim = source.nShowOutstandingClaim;
            destination.nWithinDaysClaim = source.nWithinDaysClaim;
            destination.nShowWorkbooksNotPosted = source.nShowWorkbooksNotPosted;
            destination.nWithinDaysWorkbooksNotPosted = source.nWithinDaysWorkbooksNotPosted;
            destination.nTransTypeQuotation = source.nTransTypeQuotation;
            destination.nTransTypeCoverNotes = source.nTransTypeCoverNotes;
            destination.nTranTypeLapses = source.nTranTypeLapses;
            destination.nPanelOrderOutstandingTasks = source.nPanelOrderOutstandingTasks;
            destination.nPanelOrderOutstandingClaims = source.nPanelOrderOutstandingClaims;
            destination.nPanelOrderPoliciesForRenewal = source.nPanelOrderPoliciesForRenewal;
            destination.nPanelOrderOutstandingDebts = source.nPanelOrderOutstandingDebts;
            destination.nPanelOrderTransOutsideCreditTermDate = source.nPanelOrderTransOutsideCreditTermDate;
            destination.nPanelOrderWorkbooksNotPosted = source.nPanelOrderWorkbooksNotPosted;
//.........这里部分代码省略.........

        /// <summary>
        /// Custom mapper function for unallocated_cash_return_v table
        /// </summary>
        /// <param name="source"></param>
        /// <returns></returns>
        protected DatabaseConversion.CleanerTool.BOALedgerDataAccess.unallocated_cash_return_v CustomMapper_unallocated_cash_return_v(DatabaseConversion.CleanerTool.EclipseDataAccess.unallocated_cash_return_v source)
        {
            //
            // Initialize result
            DatabaseConversion.CleanerTool.BOALedgerDataAccess.unallocated_cash_return_v destination = new DatabaseConversion.CleanerTool.BOALedgerDataAccess.unallocated_cash_return_v();
            //
            // Set basic properties
            destination.Ent_Name = source.Ent_Name;
            destination.tran_id = source.tran_id;
            destination.tran_time = source.tran_time;
            destination.tran_type = source.tran_type;
            destination.particulars = source.particulars;
            destination.amount = source.amount;
            destination.bal_amount = source.bal_amount;
            destination.SPID = source.SPID;
            destination.Ent_ID = source.Ent_ID;

            //
            // Return result
            return destination;
        }

        /// <summary>
        /// Custom mapper function for ufi_country_codes table
        /// </summary>
        /// <param name="source"></param>
        /// <returns></returns>
        protected DatabaseConversion.CleanerTool.BOALedgerDataAccess.ufi_country_codes CustomMapper_ufi_country_codes(DatabaseConversion.CleanerTool.EclipseDataAccess.ufi_country_codes source)
        {
            //
            // Initialize result
            DatabaseConversion.CleanerTool.BOALedgerDataAccess.ufi_country_codes destination = new DatabaseConversion.CleanerTool.BOALedgerDataAccess.ufi_country_codes();
            //
            // Set basic properties
            destination.uficoco_id = source.uficoco_id;
            destination.uficoco_name = source.uficoco_name;
            destination.uficoco_code = source.uficoco_code;
            destination.uficoco_created_who = source.uficoco_created_who;
            destination.uficoco_created_when = source.uficoco_created_when;
            destination.uficoco_updated_who = source.uficoco_updated_who;
            destination.uficoco_updated_when = source.uficoco_updated_when;
            destination.uficoco_desc = source.uficoco_desc;
            destination.uficoco_inactive = source.uficoco_inactive;

            //
            // Return result
            return destination;
        }

        /// <summary>
        /// Custom mapper function for Workbook_Notes table
        /// </summary>
        /// <param name="source"></param>
        /// <returns></returns>
        protected DatabaseConversion.CleanerTool.BOALedgerDataAccess.Workbook_Notes CustomMapper_Workbook_Notes(DatabaseConversion.CleanerTool.EclipseDataAccess.Workbook_Notes source)
        {
            //
            // Initialize result
            DatabaseConversion.CleanerTool.BOALedgerDataAccess.Workbook_Notes destination = new DatabaseConversion.CleanerTool.BOALedgerDataAccess.Workbook_Notes();
            //
            // Set basic properties
            destination.wor_not_id = source.wor_not_id;
            destination.wor_not_wor_id = source.wor_not_wor_id;
            destination.wor_not_created_who = source.wor_not_created_who;
            destination.wor_not_created_when = source.wor_not_created_when;
            destination.wor_not_updated_who = source.wor_not_updated_who;
            destination.wor_not_updated_when = source.wor_not_updated_when;
            destination.wor_not_note = source.wor_not_note;
            destination.wor_not_contact = source.wor_not_contact;
            destination.wor_not_subject = source.wor_not_subject;
            destination.wor_not_phone = source.wor_not_phone;
            destination.wor_not_mobile = source.wor_not_mobile;
            destination.wor_not_email = source.wor_not_email;

            //
            // Return result
            return destination;
        }