luck_mylife

导航

 
            OracleConnection connection = new OracleConnection(conn);
            OracleCommand command = new OracleCommand();
            int result = 0;
            try
            {
                PrepareCommand(command, connection, CommandType.Text, cmdText);

                OracleParameter stopUpdateAutoCodes = new OracleParameter("StopUpdateAutoCodes", OracleDbType.Clob);
                stopUpdateAutoCodes.Value = mr.StopUpdateAutoCodes;
                command.Parameters.Add(stopUpdateAutoCodes);

                OracleParameter syncCodes = new OracleParameter("SyncCodes", OracleDbType.Clob);
                syncCodes.Value = mr.SyncCodes;
                command.Parameters.Add(syncCodes);

                OracleParameter unSyncCodes = new OracleParameter("UnSyncCodes", OracleDbType.Clob);
                unSyncCodes.Value = mr.UnSyncCodes;
                command.Parameters.Add(unSyncCodes);

                result = command.ExecuteNonQuery();
                command.Parameters.Clear();

            }
            catch { }
            finally
            {
                command.Dispose();
                connection.Close();
                connection.Dispose();
            }

 

posted on 2017-03-02 10:33  二郎神  阅读(2903)  评论(0)    收藏  举报