public DataTable getGridViewData(string COMPANY_NAME, string COMPANY_NAME_READING, string BILL_COMPANY_NAME, string COMPANY_NO_BOX)
        {
            ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strgetGridViewData);

            oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NAME", COMPANY_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NAME_READING", COMPANY_NAME_READING));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_COMPANY_NAME", BILL_COMPANY_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", COMPANY_NO_BOX));
            oMaster.ExcuteQuery(4, out strMessage);
            return(oMaster.dtExcuted);
        }
        public void insert(out string strMessage)
        {
            int intRtn = 0;

            strMessage = "";
            ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strInsert);

            oMaster.crudCommand.Parameters.Add(new SqlParameter("@ID", _ID));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PASS", _PASS));

            //_M01 = oMaster.intRtnID;
            //  return intRtn;
        }
Beispiel #3
0
        public void insert(out string strMessage)
        {
            int intRtn = 0;

            strMessage = "";
            ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strInsert);

            //oMaster.crudCommand.Parameters.Add(new SqlParameter("@SEQ_NO", _SEQ_NO));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@DATA_CLASS", _DATA_CLASS));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@RECORD_CLASS", _RECORD_CLASS));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_DATE", _TRANSACTION_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_CONTACT_NAME", _TRANSACTION_CONTACT_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_BANKS_NAME", _TRANSACTION_BANKS_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_BRANCH_NAME", _TRANSACTION_BRANCH_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_ACCOUNT_NO_CLASS", _TRANSACTION_ACCOUNT_NO_CLASS));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_ACCOUNT_TYPE", _TRANSACTION_ACCOUNT_TYPE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_ACCOUNT_NO", _TRANSACTION_ACCOUNT_NO));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@RESEND_INDICATION", _RESEND_INDICATION));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_NAME", _TRANSACTION_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_NO", _TRANSACTION_NO));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_DETAIL_CLASS", _TRANSACTION_DETAIL_CLASS));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@HANDLING_DATE", _HANDLING_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@DEPOSIT_DATE", _DEPOSIT_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@DEPOSIT_AMOUNT", _DEPOSIT_AMOUNT));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@CHECK_CLASS", _CHECK_CLASS));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@CUSTOMER_NAME ", _CUSTOMER_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@COLLECTION_NO_SHEETS", _COLLECTION_NO_SHEETS));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@COLLECTION_NO", _COLLECTION_NO));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@CUSTOMER_NO", _CUSTOMER_NO));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BANK_NAME", _BANK_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BRANCH_NAME", _BRANCH_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSFER_MESSAGE", _TRANSFER_MESSAGE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@NOTE", _NOTE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@NUMBER", _NUMBER));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_FILE_NAME", _TRANSACTION_FILE_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@RUN_DATE_TIME", _RUN_DATE_TIME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@RUN_RESULT", _RUN_RESULT));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@DATA_MOVEMENT_INFORMATION", _DATA_MOVEMENT_INFORMATION));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PAYMENT_DAY", _PAYMENT_DAY));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@TYPE_OF_ALLOCATION", _TYPE_OF_ALLOCATION));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@ALLOCATED_QUANTITY", _ALLOCATED_QUANTITY));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@ALLOCATED_MONEY", _ALLOCATED_MONEY));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@ALLOCATED_COMPLETION_DATE", _ALLOCATED_COMPLETION_DATE));
            oMaster.ExcuteQuery(1, out strMessage);

            //_M01 = oMaster.intRtnID;
            //  return intRtn;
        }
        public void insert(out string strMessage)
        {
            int intRtn = 0;

            strMessage = "";
            ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strInsert);

            oMaster.crudCommand.Parameters.Add(new SqlParameter("@SEQ_NO", _SEQ_NO));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@RESERVE_INFO_ID", _RESERVE_INFO_ID));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILLING_CODE", _BILLING_CODE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PAYMENT_DAY", _PAYMENT_DAY));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@TYPE_OF_ALLOCATION", _TYPE_OF_ALLOCATION));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@RESERVE_AMOUNT", _RESERVE_AMOUNT));
            //_M01 = oMaster.intRtnID;
            //  return intRtn;
        }
        public void update(out string strMessage)
        {
            strMessage = "";
            ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strUpdate);

            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NAME_1", _BILL_BANK_ACCOUNT_NAME_1));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NAME_2", _BILL_BANK_ACCOUNT_NAME_2));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NAME_3", _BILL_BANK_ACCOUNT_NAME_3));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NAME_4", _BILL_BANK_ACCOUNT_NAME_4));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BILLING_INTERVAL", _BILL_BILLING_INTERVAL));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_DEPOSIT_RULES", _BILL_DEPOSIT_RULES));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_TRANSFER_FEE", _BILL_TRANSFER_FEE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_EXPENSES", _BILL_EXPENSES));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@UPDATE_DATE", _UPDATE_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@UPDATER_CODE", _UPDATER_CODE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@NCS_CUSTOMER_CODE", _NCS_CUSTOMER_CODE));
            oMaster.ExcuteQuery(2, out strMessage);
        }
        public void insert(out string strMessage)
        {
            int intRtn = 0;

            strMessage = "";
            ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strInsert);

            oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", _COMPANY_NO_BOX));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_TYPE", _TRANSACTION_TYPE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@EFFECTIVE_DATE", _EFFECTIVE_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@UPDATE_CONTENT", _UPDATE_CONTENT));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NAME", _COMPANY_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NAME_READING", _COMPANY_NAME_READING));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@ESTIMATED_SUBMISSION_DATE", _ESTIMATED_SUBMISSION_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@CONTRACT_DATE", _CONTRACT_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPLETION_NOTE_SENDING_DATE", _COMPLETION_NOTE_SENDING_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@CONTRACTOR_DEPARTMENT_IN_CHARGE", _CONTRACTOR_DEPARTMENT_IN_CHARGE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@CONTRACTOR_CONTACT_NAME", _CONTRACTOR_CONTACT_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@CONTRACTOR_CONTACT_NAME_READING", _CONTRACTOR_CONTACT_NAME_READING));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@CONTRACTOR_POSTAL_CODE", _CONTRACTOR_POSTAL_CODE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@CONTRACTOR_ADDRESS", _CONTRACTOR_ADDRESS));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@CONTRACTOR_ADDRESS_2", _CONTRACTOR_ADDRESS_2));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@CONTRACTOR_MAIL_ADDRESS", _CONTRACTOR_MAIL_ADDRESS));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@CONTRACTOR_PHONE_NUMBER", _CONTRACTOR_PHONE_NUMBER));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_SUPPLIER_NAME", _BILL_SUPPLIER_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_SUPPLIER_NAME_READING", _BILL_SUPPLIER_NAME_READING));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_COMPANY_NAME", _BILL_COMPANY_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_DEPARTMENT_IN_CHARGE", _BILL_DEPARTMENT_IN_CHARGE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_CONTACT_NAME", _BILL_CONTACT_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_CONTACT_NAME_READING", _BILL_CONTACT_NAME_READING));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_POSTAL_CODE", _BILL_POSTAL_CODE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_ADDRESS", _BILL_ADDRESS));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_ADDRESS_2", _BILL_ADDRESS_2));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_MAIL_ADDRESS", _BILL_MAIL_ADDRESS));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_PHONE_NUMBER", _BILL_PHONE_NUMBER));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@NCS_CUSTOMER_CODE", _NCS_CUSTOMER_CODE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NAME_1", _BILL_BANK_ACCOUNT_NAME_1));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@ILL_BANK_ACCOUNT_NAME_2", _BILL_BANK_ACCOUNT_NAME_2));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NAME_3", _BILL_BANK_ACCOUNT_NAME_3));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NAME_4", _BILL_BANK_ACCOUNT_NAME_4));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NUMBER_1", _BILL_BANK_ACCOUNT_NUMBER_1));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NUMBER_2", _BILL_BANK_ACCOUNT_NUMBER_2));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NUMBER_3", _BILL_BANK_ACCOUNT_NUMBER_3));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BANK_ACCOUNT_NUMBER_4", _BILL_BANK_ACCOUNT_NUMBER_4));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_BILLING_INTERVAL", _BILL_BILLING_INTERVAL));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_DEPOSIT_RULES", _BILL_DEPOSIT_RULES));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_TRANSFER_FEE", _BILL_TRANSFER_FEE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_EXPENSES", _BILL_EXPENSES));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_SERVER", _PLAN_SERVER));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_SERVER_LIGHT", _PLAN_SERVER_LIGHT));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_BROWSER_AUTO", _PLAN_BROWSER_AUTO));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_BROWSER", _PLAN_BROWSER));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_INITIAL_COST", _PLAN_INITIAL_COST));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_MONTHLY_COST", _PLAN_MONTHLY_COST));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_AMIGO_CAI", _PLAN_AMIGO_CAI));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_AMIGO_BIZ", _PLAN_AMIGO_BIZ));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_ADD_BOX_SERVER", _PLAN_ADD_BOX_SERVER));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_ADD_BOX_BROWSER", _PLAN_ADD_BOX_BROWSER));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_OP_FLAT", _PLAN_OP_FLAT));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_OP_SSL", _PLAN_OP_SSL));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_OP_BASIC_SERVICE", _PLAN_OP_BASIC_SERVICE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_OP_ADD_SERVICE", _PLAN_OP_ADD_SERVICE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_OP_SOCIOS", _PLAN_OP_SOCIOS));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PREVIOUS_COMPANY_NAME", _PREVIOUS_COMPANY_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@NML_CODE_NISSAN", _NML_CODE_NISSAN));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@NML_CODE_NS", _NML_CODE_NS));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@NML_CODE_JATCO", _NML_CODE_JATCO));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@NML_CODE_AK", _NML_CODE_AK));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@NML_CODE_NK", _NML_CODE_NK));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@NML_CODE_OTHER", _NML_CODE_OTHER));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@UPDATE_DATE", _UPDATE_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@UPDATER_CODE", _UPDATER_CODE));
            oMaster.ExcuteQuery(1, out strMessage);
            //_M01 = oMaster.intRtnID;
            //  return intRtn;
        }
        public void insert(out string strMessage)
        {
            int intRtn = 0;

            strMessage = "";
            ConnectionMaster oMaster = new ConnectionMaster(strConnectionString, strInsert);

            oMaster.crudCommand.Parameters.Add(new SqlParameter("@INVOICE_INFO_ID", _INVOICE_INFO_ID));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@COMPANY_NO_BOX", _COMPANY_NO_BOX));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_TYPE", _TRANSACTION_TYPE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@YEAR_MONTH", _YEAR_MONTH));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@INVOICE_DATE", _INVOICE_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_HONORIFIC", _BILL_HONORIFIC));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_AMOUNT", _BILL_AMOUNT));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_TAX", _BILL_TAX));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_PRINCE", _BILL_PRINCE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_PAYMENT_DATE", _BILL_PAYMENT_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_PRINT", _STATUS_PRINT));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_MEMO", _STATUS_MEMO));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_SEND", _STATUS_SEND));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_MAIL_DATE", _STATUS_MAIL_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_ACC_RECEIVABLE_DATE", _STATUS_ACC_RECEIVABLE_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_INVOCE_COPY_DATE", _STATUS_INVOCE_COPY_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_ACTUAL_MDB_UPDATE", _STATUS_ACTUAL_MDB_UPDATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_ACTUAL_DEPOSIT_YYMM", _STATUS_ACTUAL_DEPOSIT_YYMM));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_ACTUAL_DEPOSIT_DATE", _STATUS_ACTUAL_DEPOSIT_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_CASH_FORECAST_MM", _STATUS_CASH_FORECAST_MM));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_PLAN_DEPOSIT_YYMM", _STATUS_PLAN_DEPOSIT_YYMM));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@STATUS_PAY_NOTICE_DATE", _STATUS_PAY_NOTICE_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@TYPE_OF_ALLOCATION", _TYPE_OF_ALLOCATION));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@ALLOCATION_TOTAL_AMOUNT", _ALLOCATION_TOTAL_AMOUNT));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@DUNNING_COUNT", _DUNNING_COUNT));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@DUNNING_DATE", _DUNNING_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@ANSWER_DATE", _ANSWER_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PAYMENT_DUE_DATE", _PAYMENT_DUE_DATE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@ANSWER_MEMO", _ANSWER_MEMO));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@TRANSACTION_TYPE", _TRANSACTION_TYPE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_SUPPLIER_NAME", _BILL_SUPPLIER_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_SUPPLIER_NAME_READING", _BILL_SUPPLIER_NAME_READING));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_COMPANY_NAME", _BILL_COMPANY_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_DEPARTMENT_IN_CHARGE", _BILL_DEPARTMENT_IN_CHARGE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_CONTACT_NAME", _BILL_CONTACT_NAME));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_POSTAL_CODE", _BILL_POSTAL_CODE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_ADDRESS", _BILL_ADDRESS));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_ADDRESS_2", _BILL_ADDRESS_2));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@NCS_CUSTOMER_CODE", _NCS_CUSTOMER_CODE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_DEPOSIT_RULES", _BILL_DEPOSIT_RULES));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_TRANSFER_FEE", _BILL_TRANSFER_FEE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@BILL_EXPENSES", _BILL_EXPENSES));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_SERVER", _PLAN_SERVER));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_SERVER_LIGHT", _PLAN_SERVER_LIGHT));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_BROWSER_AUTO", _PLAN_BROWSER_AUTO));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_BROWSER", _PLAN_BROWSER));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_AMIGO_CAI", _PLAN_AMIGO_CAI));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_AMIGO_BIZ", _PLAN_AMIGO_BIZ));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_ADD_BOX_SERVER", _PLAN_ADD_BOX_SERVER));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_ADD_BOX_BROWSER", _PLAN_ADD_BOX_BROWSER));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_OP_FLAT", _PLAN_OP_FLAT));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_OP_SSL", _PLAN_OP_SSL));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_OP_BASIC_SERVICE", _PLAN_OP_BASIC_SERVICE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_OP_ADD_SERVICE", _PLAN_OP_ADD_SERVICE));
            oMaster.crudCommand.Parameters.Add(new SqlParameter("@PLAN_OP_SOCIOS", _PLAN_OP_SOCIOS));

            oMaster.ExcuteQuery(1, out strMessage);
            //_M01 = oMaster.intRtnID;
            //  return intRtn;
        }