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; }
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; }